Mark Moore here. I wanted to talk about the newest addition to Excel. Power BI. Power BI makes Excel really shine and opens a whole new world of data analysis and reporting.
What is Power BI?
Power BI is a collection of several tools that let Excel collects data, manage the data model and build interactive dashboards. No extra software needed. It’s all inside Excel.
A major limitation of Excel is that it cannot handle several million rows of data. Are you running into this wall? Have you thought about using Access to store the data and then have Excel as the analysis engine? That’s clunky and unstable. Can you create interactive dashboards from millions of rows? Do you want to be the Excel guru of the office? I’ll help you do that.
The tools in Power BI are:
- Mastering Excel: Power Query (extract data from databases, the web, Excel files, etc.)
- Mastering Excel: Power Pivot (manage the data)
- Mastering Excel: Power View (create dashboards)
- Mastering Excel: Power Map (create geographical data-based maps)
The Power BI lessons are written in plain English, from a non-technical perspective. There are several step-by-step exercises with plenty of images to help you learn these powerful features.
Additionally, the book comes with several practice workbooks so you can work alongside the text to get hands-on experience.
You can find the eBook version in Amazon.com here:
Mastering Excel: Power Pack Bundle (ebook)
You can find the paperback version in Amazon.com here:
Mastering Excel: Power Pack Bundle (paperback)
Once you buy the book, remember to come back to this page! Input your info below to get your practice workbooks via email.
If you do not see the form below, please turn off your ad blocker and try again. If that still doesn’t work, try another browser.
Note that you must have Excel 2016 or Office 365 Pro Plus to use all the features. You might get away with Excel 2013 for some of them but not all features will be supported in that version of Excel.