Basic line charts
1. Basic line charts
Welcome to the course Visualizations in Sigma!2. Visual storytelling with Sigma
In this course, we'll go beyond the basic bar chart to learn how Sigma can create a variety of useful visuals, or charts, for displaying your data in an interactive and visually engaging way.3. Welcome!
First, let me introduce myself. I'm your instructor, Mandy Gray with Aimpoint Digital. Aimpoint Digital is a leading analytics advisory and solution engineering firm,4. Welcome!
trusted by Sigma as a key strategic training and implementation partner. We help organizations turn data into scalable, user-centric, and insight-driven solutions that deliver measurable business impact.5. Welcome!
Together with my colleagues and co-developers Klim Kapuka and Jenny Li, we look forward to guiding you through your Sigma journey.6. Oakmark Bank needs your help
To practice with visualizations, we'll step into the role of an analyst at Oakmark Bank, looking into Oakmark's call center analytics.7. Oakmark Bank needs your help
Oamark's call center generates hundreds of interactions a day, and the executive team wants you to leverage Sigma to aggregate and summarize their raw data into easy-to-understand charts and dashboards.8. Why visualize data?
We know that Sigma is great at presenting data in tables and pivot tables, but no one wants to spend time scrolling through endless tables of data looking for the insights. As they say, a picture is worth a thousand words, and visualizing data with charts can bring insights to life in ways a table simply can't.9. Choosing Sigma charts
As we address some of Oakmark Bank's key concerns throughout this course, we'll discover that Sigma offers many different types of charts. In this course, we'll experiment with line charts, area charts, pie and donut charts, and some special chart types called KPIs and gauges.10. Choosing Sigma charts
For each new scenario we encounter, we'll think critically and weigh the strengths and weaknesses of different chart types to determine which one best fits the needs of our stakeholders.11. Choosing Sigma charts
When visualizing data with Sigma, developers must always carefully consider their objectives - what question is being asked of this data, and how can we best visualize it to efficiently answer that question?12. Choosing Sigma charts
It's possible to create charts with too much detail,13. Choosing Sigma charts
or too little,14. Choosing Sigma charts
or to choose the wrong type of chart for the task. Our challenge will be creating the right type of chart at the right level of detail every time.15. Call volumes concern
Let's get started by addressing one of the Oakmark team's key concerns - call volumes. Oakmark's call center handles hundreds of calls each day, and their Chief Hiring Officer is keeping close watch. If call volumes increase dramatically, more call center agents should be hired to avoid long customer wait times.16. Call volumes concern
One particular subset of calls is of great concern. If a customer reports fraudulent activity on their account, this triggers a lengthy review process and takes more of a call center agent's time to resolve. So, Oakmark leadership understandably wants to detect upward trends in these types of calls as early as possible and staff accordingly. But what type of chart is best for this type of question?17. Line charts
Line charts are great for showing the progression of a data point over time. As time progresses left-to-right along the x-axis, the line moves up and down along the y-axis according to its value at that point in time. Line charts help businesses see historical trends or emerging patterns. They require at least 2 columns of data - a date column and a numeric column.18. Bar charts
Bar charts are also acceptable for representing time-based trends, but they're better suited for displaying categories of data or highlighting differences in proportion from one time period to the next.19. Oakmark's choice
Since fraudulent calls do not have sub-categories and the proportion of one month to another is less important than the overall upward or downward trend of the calls, a line chart is the best fit.20. Let's practice!
Let's help the Oakmark Bank team create a line chart of fraudulent activity calls over time, and decide if the overall trend is increasing or decreasing. But first, test your knowledge of line charts with a quick exercise.Create Your Free Account
or
By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.