Today lets talk about how to build world-class dashboards.
What is a dashboard?
Dashboard reports allow managers to get high-level overview of the business and help them make quick decisions. A dashboard is usually a one page report that contains critical information for decision support.
How to make dashboards?
Excel is an excellent tool to make powerful dashboards that can provide analysis, insight and alert managers in timely manner. But creating a dashboard takes a lot of skill & practice. That is where a resource like Chandoo.org comes handy. In this site you can find more than 200 different dashboard examples, tutorials, samples and downloads – all designed to make you awesome.
A step-by-step approach to dashboards
Creating a dashboard is a time-consuming, tricky and intense process. To help you guide thru this process of envisioning and designing a dashboard, I have created 2 online courses – Excel School & Power Pivot class. In these courses, you learn how to,
- Structure data (using tables, data connections & SQL)
- Analyze data (using features like formulas, DAX measures)
- Gain insights (using features like charts, sparklines, pivot tables)
- Interact with reports (using slicers, form controls & VBA)
- Present results (by making amazing dashboards)
In our course, we show you how to create dashboards with 11 different examples. The dashboards you will learn are (click on any image to enlarge),
Small Business Dashboard
Dashboards that change every month • sparklines • tables • conditional formatting alerts • layout
KPI reporting • dynamic charts • Showing more in less space • layout techniques
Layout techniques • mixing different formats • dynamic charts • using color & contrast
Website Dashboard – 2
Layout techniques • analyzing lots of data • using color • mixing charts
Real Estate Dashboard
Using maps • automating with VBA • advanced charting
On Demand Details Dashboard
VBA with charts & cells • conditional formatting • in-cell charts
Picture links • using color & layout intelligently • advanced formulas & in-cell charts
Simple Kpi Dashboard
Simple layout • conditional formatting • quick dashboarding
Using tables • conditional formatting • working with calendars • layout techniques and VBA
Store Performance Dashboard
Using DAX measures & pivots • slicers • conditional formatting
Product Performance Dashboard
Using DAX measures • Show / hide slicers • Advanced charting • Advanced DAX measures
Join now to learn…
We have re-opened our online classroom this Monday (10th of February) and more than a 100 analysts & managers have already enrolled in these powerful, practical and detailed courses. As you are reading this, they are learning how to do awesome things using Excel.
What do our students say about the class?
Oh they just love it. But don’t take my word. Read the testimonials:
– John Geiger
– Johan van Dyk
– Prashant Amara
So go ahead and enroll now. Learn how to make world-class dashboards & reports using Excel.