BLOGS BY TOPIC
BLOGS BY AUTHOR
BLOGS BY YEAR
Posted by Andy Brown on 22 July 2016
You need a minimum screen resolution of about 700 pixels width to see our blogs. This is because they contain diagrams and tables which would not be viewable easily on a mobile phone or small laptop. Please use a larger tablet, notebook or desktop computer, or change your screen resolution settings.
Excel Power BI Tools or Power BI Desktop?
Wise Owl run two separate courses containing the words Power BI!
|Excel Power BI Tools||PowerPivot, Power Query, Power View and Power Map.|
|Power BI Desktop||A program for creating standalone dashboards.|
So ... what is the difference between them? This blog attempts to answer that question!
One thing is absolutely certain: you won't want to attend both courses (there's way too much overlap between the two products).
A little history to start
What would you do in Microsoft's position? They realised that they were losing out in the important Business Intelligence dashboard market to products like Tableau, Spotfire and Qlikview:
You can't easily create dashboards like this in Excel, even using Power View, so launching the new Power BI Desktop product was the answer.
They had two obvious solutions to try - add more features to Excel, or create a stand-alone application. Hedging their bets, they did both!
|Solution||Pros and cons|
|Add to Excel (Power View add-in)||Everyone uses Excel, so this was the obvious thing to try. However, it's hard extending Excel because of the constraints imposed by having to work within the existing software, and it shows: Power View is limited and buggy.|
|Separate product (Power BI Desktop)||In creating a separate application Microsoft could start with a blank slate, and consequently Power BI is far better at visualising data than Excel. Microsoft can also update the software much more easily (currently on a monthly or even weekly basis).|
What I'll now do is show what each of the two courses listed above covers, which will give a pretty good idea of the differences and similarities between the two products. Let's start with Excel.
Excel Power BI Tools
Our two-day Excel Power BI course starts by showing how to import data:
The course also shows how to choose which columns/rows to import (something you can't do in Desktop Power BI).
The course then shows how to create a data model:
A data model in PowerPivot (some tables/columns have been hidden, and some deleted).
The course then shows how to create pivot tables based on this data, including additional features like slicers (as shown here):
A pivot table based on the above data model.
We then take a digression to look at using Power Query to transform data before loading it:
Power Query is pretty much exactly the same for both courses.
Nearly all of the rest of the Excel course - about half of it in total - is then spent on creating DAX calculated columns and calculated fields (sometimes called measures), creating expressions like this:
A (fairly) typical DAX measure.
The Excel course also shows how to create and use calendar tables to create year-on-year comparisons like this:
These columns use DAX formulae to show date-based statistics.
The course then shows how to use Power View and Power Map (two add-ins within Excel), before showing how to create hierarchies and KPIs in a data model (two small final topics).
Microsoft are almost certainly going to drop Power View within Excel (and a good thing too). It's astonishingly primitive, and also has a tendency to crash!
Power BI Desktop
Our two-day Power BI course has more emphasis on visual reporting and much less on using DAX in formulae. The course shows near the start how to import data:
Although both courses show how to import data from different sources, the Desktop Power BI one uses a wider range of examples.
The course then spends time showing how you can massage data when loading it:
Queries in Desktop Power BI are more or less identical to Power Query in Excel.
Much of the course is then devoted to creating visualisations, using these tools:
The visualisations available include charts, gauges, tables, maps, cards and matrices. The diagram also shows the settings for a pie chart.
The course also shows how you can filter data for a visualisation:
|You can filter data ...||... or use a slicer|
The course then shows how to publish dashboards to the Power BI server:
A successful publication ...
The course also shows how to use the Power BI Service to pin items to dashboards:
A dashboard created in the Power BI Service.
The Power BI Desktop course covers many more topics than those chosen above (including some basic DAX formulae), but I'm trying to give a flavour to help you make the right choice!
Conclusion and recommendation
I hope the above has given an idea of what's covered on the two courses. Choose the Excel course if:
- You are familiar with pivot tables in basic Excel;
- You are a numerate person, who enjoys analysing data;
- You want to do a lot of time-based calculations (year-on-year, year-to-date, etc.);
- You want to get a good working knowledge of the DAX language.
Choose the Desktop course if:
- You want to create beautiful dashboards, with drill-down available;
- You want to be able to publish what you do so it's available on a website;
- You want to make your reports viewable on mobile phones and tablets;
- You want to create maps, or complex chart types.
The Desktop course is easier than the Excel one, and possibly more fun! However, it doesn't go into anything like as much depth on DAX expressions, and doesn't show you how to use calendars or create date-based formulae.