Dashboard reports, are no longer a buzz word, they’re a standard reporting tool for all kinds of industries and they’re an in-demand skill for Excel users everywhere.
In fact, IBM project that the number of jobs for all data professionals in the United States will increase by 15% by 2020.
Demand for Data Visualization skills alone is projected to grow by 44% and PivotTable skills by 34%. That’s great news for us Excel and or Power BI users.
Until recently Excel was the go-to tool (for most of us) for building interactive dashboard reports like the one below:
The benefit in having Excel Dashboard skills, aside from the kudos from your boss and colleagues, is that these skills are often transferable to your everyday Excel work.
Many Excel users already have the skills required to build interactive Excel Dashboards, they just need to be shown how to put them together to build a dashboard report.
That said, now we have a dedicated dashboard reporting tool from Microsoft in the form of Power BI that can build amazing interactive dashboards like these:
In fact, Power BI Dashboards can do things we can only dream about in Excel. Things like:
- Interactive charts that allow users to cross highlight and filter by clicking on the bars/lines in the charts etc.
- Allow users to drill down to lower levels and even underlying data (with your permission)
- Power BI takes the hassle out of sharing dashboards, enabling us to easily share reports on any device
- Clever algorithms scan your data and automatically highlight insights you may never discover on your own
- Building Power BI dashboards is super-fast with drag and drop navigation
- Updating Power BI dashboards is easy too. Simply schedule a refresh so your dashboards are always up to date
See for yourself in this replay of Mynda’s Power BI webinar where she builds the two dashboards shown above in under one hour.
So, will Power BI be the death of Excel dashboards?
Not necessarily. Excel is already on almost every PC around the world and the learning curve for Excel dashboards is relatively shallow. Whereas Power BI has a steeper learning curve, plus there is an additional cost for certain features, like sharing reports.
Excel vs Power BI Pros and Cons
The table below compares key points between Excel and Power BI to help your decision-making process:
There’s no denying that Dashboard skills, whether in Excel or Power BI, or both are a huge advantage to Excel users around the world and in a vast range of industries. Just look at any job website and you’ll plenty of jobs that mention ‘Dashboards’ in the description.
To get you off to a running start Mynda is hosting a series of free webinars from May 1 through 10 to teach and demonstrate Excel and Power BI for building dashboards.
Webinar 1 – Excel Dashboard for Excel 2007/2010/2013/2016
The first webinar will teach you how to use Excel to build this interactive dashboard below, no additional software or add-ins required, just plain old Excel and some data.
Many Excel users will already have the skills to build this dashboard, and seeing Mynda put them together will be exciting and inspiring when you realize how quickly you can get up and running with Excel dashboards.
Webinar 2 – Excel Dashboard for Excel 2010/2013/2016 using Power Query and Power Pivot
Excel is evolving; in the last few years Microsoft have added new tools like Power Query and Power Pivot, to name a couple.
Embracing these new tools will not only enable you to get your work done more quickly, but you’ll also have a huge competitive edge in the workplace because less than 1% of Excel users know these tools.
It’s easy to ignore these developments and continue doing things the way you always have, but that won’t get you ahead in your career …you know that, right?
If you have Excel 2010, 2013 or 2016* then this webinar will showcase how you can use Excel’s Power Query tool to get data from multiple sources, mash it up with Power Pivot, analyse it in PivotTables to create this interactive Excel Dashboard.
*Power Query is available with all versions of Excel 2010, 2013 and 2016. Power Pivot is available with the desktop version of Excel 2010 and Excel 2013/2016 Office Professional, Office 365 ProPlus, or in the standalone versions of Excel 2013/2016. Power Query and Power Pivot are not available for Mac.
Webinar 3 – Power BI Dashboard Reports (Replay)
See what all the hype is about first hand in this replay of Mynda’s Power BI webinar where she builds these two interactive dashboards in under one hour:
Who is Power BI for?
Power BI is for the Excel user who is ready for more. More features, because Power BI Dashboards can do things you simply can’t do in Excel, and more skills to add to your résumé.
So, if you’re wanting more interactivity from your Dashboard reports and you’re prepared to learn some new skills then check out Power BI.
What people are saying about the webinars
Over 30,000 people have attended Mynda’s webinars and this is what some of them had to say:
“Thank you! This webinar has already saved tremendous time and effort. I tried some of the techniques you illustrated for a cumbersome report update that I can see will cut our preparation time by 2/3’s or more. ….awesome! Many thanks!!!!” Cynthia Tashjian
“WOW, just WOW Can’t type more now – am trying to create a dashboard. Thank you Mynda!” Susan
“The webinar was fantastic! I really enjoyed every moment. As you said, it was fast paced, but I am so excited to go back and review the presentation. We have been trying to get a dashboard started for my department and this really motivated me to take the lead. Thank you so much!” Kathryn Puskar
“Oh. My. God. I know nothing! My jaw dropped a couple of times as you casually mentioned a way to manipulate PivotTable data. That’s the problem with being largely self-taught – there are huge gaps in my knowledge.” Ann
“I presented my first dashboard to the CEO yesterday and he was ecstatic. Since we are downsizing I was very worried about my job, but after seeing his reaction…I understand that my job is secure (for now). Thanks!” Iris Stein
Invite a Friend
Feel free to forward this email to your friends and colleagues and invite them to attend Mynda’s free Dashboard webinars. They’ll thank you for it.
All you need is an internet connection, a web browser and speakers or headphones.
You don’t need Power BI or Excel to attend the webinars.
20% Off Excel Dashboard and Power BI Courses until May 10.
If you’re ready to take the next step and add these skills to your repertoire then don’t miss out on the discounts on Mynda’s Excel and Power BI Dashboard courses. You can even get multiple courses in discounted bundles.