Business charting & dashboards in Excel and Power BI
Chandoo is an award-winning Excel & Power BI expert. His blog – Chandoo.org is renowned for creative uses of Excel, dashboards, visualizations and Power BI. Every year, millions of users learn from Chandoo thru his website, youtube channel or live classes. Originally from India, Chandoo now lives in Wellington, New Zealand with his family – Jo & twins – Nakshatra & Nishanth. For more about him visit – https://chandoo.org/wp/about/
Chandoo has an MBA from IIM Indore and Computer Science degree from Andhra University. Above all, he is passionate about Data Analytics and Visualization. In his blog, Chandoo shares what he learned about Microsoft Excel and new ways of presenting data. Furthermore, Chandoo has been awarded MVP status in 2009 by Microsoft (and renewed all years thru 2018). His MVP profile is here.
Pivot tables are easy, too easy in fact. But do you know the top creative and intuitive ways to work with them? In this session, see how to build stunning & powerful reports in Excel. Compare Month on Month values with Pivot tables Spot trends and outliers with pivots + conditional formatting Make an interactive […]
Who says we can’t make a dashboard in an hour? In this insightful & packed session, learn how to create a comprehensive, refreshable business dashboard in under an hour. You will learn: Business overview & dashboard objectives Setting up data model & calculation engine Creating visuals – charts, sparklines and conditional formats Adding interactions – […]
Closing session in which all of our speakers will share their best tips & tricks in a high-speed interactive battle! To conclude the Summit, we will hold a raffle where you can win Excel-related prizes.
Learn how to make financial reporting and scenario-based forecasting thru Power BI. Know how to work with features like bookmarks, tool-tips, What-if parameters and interactions to enhance your business reporting in Power BI. Aimed at: Beginner to Intermediate level users Software used: Power BI Desktop Type of class: Lab + hands-on. Delegates are expected to […]
Consequently, we will process with the following case study. Case study 3: ACME Inc. CFO dashboard Defining CFO reporting needs Creating a mock-up drawing of the dashboard Preparing data and loading it thru Power Query Creating necessary DAX measures Adding visuals and tiles to the dashboard Formatting and presentation Closing thoughts on financial reporting thru Power […]
Create beautiful, striking and insightful business charts & dashboards with this one-day masterclass. Use powerful Excel features like slicers, maps, forecasting, formulas, and tables to enhance your regular business charts. Understand the process for making executive dashboards to tell a complete story in one picture. In this one-day masterclass, you will learn how to make […]
You will learn to understand the process for making executive dashboards to tell a complete story in one picture. 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 […]