Description
About this Masterclass:
In this industry-leading Masterclass, learn how to make complex, interactive and intuitive business charts & dashboards.
Masterclass Agenda:
Session 2: 5 common types of business charts and how to create them:
➤ Budget vs. Actual charts: Compare planned amounts, values with actual.
➤ Then vs. Now charts: Understand how things have changed between two points in time.
➤ Communicating trends: Use sparklines, conditional formatting to elegantly show the trends.
➤ Interactive maps: Create geographical maps to show what is going on.
➤ Forecasting: Look at historical patterns and make time-series forecasting.
➤ What is a dashboard and process for creating one
➤ Exploring dashboard case study of a retail mart
➤ Making a mock-up drawing of the dashboard
➤ Setting up data model in Excel – tables & relationships
➤ Creating pivot table driven calculation engine for the dashboard
➤ Preparing charts & information tiles for the dashboard
➤ Laying everything out and formatting
Session 4: Closing thoughts on business reporting through Excel
About your Instructor:
Chandoo runs one of the most popular and extensive online resources for data analysis and dashboard reporting through Excel & Power BI at Chandoo.org. His mission is to make people awesome in their work. He has trained more than 10,000 professionals on Excel, Power Pivot, VBA & Power BI through online & in-person classes. Full profile >>
Prerequisite knowledge:
At a minimum, participants must have experience using basic Excel charts.
Pricing Information:
➤ Payment options: You can pay be debit/credit card by simply adding this Masterclass to your cart. Alternatively, payment by invoice, purchase order or bank transfer is also available. Contact us for further details.
➤ Available discounts: DATEL Productions subscribers get 10% OFF. Please contact us if you are a student, senior over 60, charity/NHS worker or if you come from an emerging market. We will send a discount code directly to your inbox. T&Cs apply.