Details about upcoming Power Pivot course (and a bonus tip on dashboards)
Hello friends..,
I have 2 things for you:
- Details about our upcoming Power Pivot courses
- A short video about designing better dashboards.
Never use simple numbers in your dashboards (bonus tip: how to fix default conditional formatting)
Pop quiz: What is wrong with above report?
At first glance, it looks alright. But if you observe closely, you realize that it is not telling the entire story. Just looking at regional sales numbers, you have not much clue what is going on with them.
So how to improve it?
10 Rookie mistakes to avoid when making dashboards [video]
Are you making these 10 rookie mistakes when creating dashboards?
Watch below to video to understand what these mistakes and how to avoid them.
10 Rookie mistakes to avoid when making dashboards [23 mins]
Join my Excel Dashboard Masterclass in USA [May-June 2013]
Hello folks,
I have a super exciting news to share with you all. I will be conducting a series of Masterclasses on Advanced Dashboards & Excel in USA this Summer (May – June 2012). So if you live in (or nearby) Chicago, New York, Washington DC or Columbus OH, and want to one up your dashboard skills, you know what to do next.
I am conducting these masterclasses in partnership with PowerPivotPro.
Designing a dashboard to track Employee vacations [case study]
HR managers & department heads always ask, “So what is the vacation pattern of our employees? What is our average absent rate?”
Today lets tackle that question and learn how to create a dashboard to monitor employee vacations.
What do HR Managers need? (end user needs)
There are 2 aspects tracking vacations.
1. Data entry for vacations taken by employees
2. Status dashboard to summarize vacation data
Project Portfolio Dashboard in Excel [Part 2 of 2]
In this 2 part tutorial, we will learn how to design a project portfolio dashboard. Part 1 discussed user needs & design. Part 2 will show you Excel implementation.
Click here to get your copy.
Final Implementation – Project Portfolio Dashboard
First lets take a look at the finalized dashboard implementation. Continue reading to learn more & download this dashboard.
Designing a Project Portfolio Dashboard [Part 1 of 2]
In this 2 part tutorial, we will learn how to design a project portfolio dashboard. Part 1 will focus on user needs & design. Part 2 on Excel implementation.
Background
As you may know, we sell a set of Excel Project Management templates. These templates help plan, track, manage & report a project right from Excel.
While these templates good, they have one limitation. They work for one project at a time. Many customers have asked me if I come up with a project portfolio dashboard that can tell what is going on in a set of projects in one view.
And that is where we begin.