Power BI Suites - Which One Do I Use?

-
I'm presuming you've seen the god-like feature set of Power BI.  I reckon you've probably even opened up browser edition and had a quick play.  Then you've come to the realisation that yeah it is just as awesome as that presenter advised!  But how does it fit together with the rest of the Office 365 suite, and why are there so many different ways to use it!?

Here's a quick historical view of the product and a brief introduction into the pros/cons of each option to help you choose a path based on what your business requirements are.  Truth is, you'll probably want all options available to you, however each new solution might require a certain platform.

If you take ANYTHING away from this post, remember there are three ways you can use the Power BI suite:  Excel Add-Ins, Power BI Online App, Power BI Desktop App...

Excel Power BI Suite (PowerPivot, PowerQuery, PowerMap, PowerView)

Before Power BI became an entity of its own, it was initially birthed as separate add-on's to Excel.  The add-ons are explained in detail below:
  • PowerPivot allowed users to easily pivot millions of rows of data in excel without delays
  • PowerQuery was then introduced to gave users a powerful tool to manipulate & relate data in a repeatable way.  This meant after spending hours cleaning up a dataset, you could now refresh data from a Data Source and it would automatically run the cleanup/washing steps that you had previously performed.  Saving the user having to wash the data every time you needed the latest information.  Power Query also lets your search the internet for public datasets and connect them up with your own private data.
  • PowerMap allowed you display your data on a map.  geographical representing your information
  • PowerView adds additional ways to visualise & interact with your data.  You can even record your interactions for time-based visualisations!

When should I use the Excels Power BI Suite?
  • If you need to display reports in a SharePoint environment, then using excel and displaying on a SharePoint page through an Excel Web Part is the only method at this point.  Currently, Power BI Reports cannot be displayed outside the Power BI platform.
  • If your organisation doesn't have Office 365

Power BI Online Application

This is where Power BI really shines.  If you already have Office365 then you can sign up to the online version of Power BI here: https://powerbi.microsoft.com/en-us/

Easily pull in existing datasets from On Premises or the cloud.  Create reports & dashboards using a plethora of ways to display the data.  Share your results to anyone within your organisation.

When should I use the Power BI Online?
If you already have clean datasets you can easily use and connect to, then use the online edition.  You can't manipulate or wash data so if you need clean your data first then read on.  If you would like to use pre-developed dashboards connected to popular services like Google Analytics, Dynamics CRM, Bing Search, then that can also be done using the Online version.

Power BI Desktop Application

For me, most of my work is done in the Desktop Application.  It is where you go if you need to do some serious development & manipulation of Data & Visualisations.  This is where the Super-User/Data Analyst would spend most of their time.  After you've done the hard work in the Desktop Application, you can still publish the end-result up to the cloud for sharing within the organisation.

When should I use the Power BI Desktop?

  • If you need to be able to wash/manipulate & build relationships on your data before building a nice functional dataset. 
  • If you would like to use some of the custom open-source visualisations available online
  • If you want to use all the features available

Other Consideration (Free or Pro)

Now you know which application to use there's the question of whether you require the features that come with Power BI Pro, or whether you can achieve what you need with the free version.  Below is a feature comparison between the two options (https://powerbi.microsoft.com/en-us/pricing):

Comments

Post a Comment

Popular posts from this blog

How to Copy/Duplicate a Table and Columns in a Dataverse Environment

-
Image
What If you need to do either of these things, then this article is for you: Create a copy of a table in the same environment as the original table Create a copy of a table but want a different prefix against custom column names Why In most circumstances, if you need to duplicate a dataverse table, I would suggest to bundle it inside a solution, and migrate the solution to another environment.   However, in the scenario where you need the duplicate table to be inside the same environment, here's a quick method that requires no manual creation of columns! How Short answer : Install  XRMToolBox , inside XRMToolBox, install and utilise the Clone Field Definitions Plugin  from the Tool Library. Pre-Tasks In order to clone a table with a new PREFIX value for the columns you first need to do the following: Create a new PUBLISHER with the new prefix you would like Create a new TABLE where you will be cloning all the fields. Tasks Download & Install  XRMToolBox On t...
Read more

Export Group Membership From Active Directory Using Power Query

-
Image
If you need to export a list of staff from an Active Directory Group, follow these steps.  Allows you to gather all the names & usernames of staff in a particular group and save the information into Excel. Step By Step How To: Open up Excel > Power Query Tab Click From Other Sources > From Active Directory: (In Excel 2016 this is found under: Data Tab > New Query > From Other Sources > From Active Directory) screenshots from Excel 2016 on left, Excel 2010 w/ Power Query Add-on right A popup will ask you to enter your domain name.  It should already be populated with the correct information but if not, input your companies domain name & Click OK: In the Navigator that opens up, expand your domain tree and double click group: You should now see a list of all groups in Active Directory in the Power Query Editor: In order to find & filter for a specific Group, Click the Down-Arrow for the 'distinguishedName' column > ...
Read more

Microsoft Flow - Apply To Each Limitation (5000 items)

-
Image
What Had a situation where I was pulling back 70,000 items in an array from a REST API call.  I wanted to create a SharePoint item for each of the items in an array, however the 'Apply To Each' action kept giving me the following error: ActionFailed . An action failed. No dependent actions succeeded. Why This was due to a Microsoft Flow limitation. When you are using the Free Version of MS Flow you are limited to 5,000 items in a loop .  Explained here:  https://docs.microsoft.com/en-us/flow/limits-and-config Workaround I tried my best to come up with a workaround, tried splitting up the array into batches of 5,000.  All to no avail.  in the end, gave up, and saved the array of items to a CSV and saved the CSV in a SharePoint Library instead. body('Parse_JSON')?['applist']?['apps'] The only other alternative I could come up with is to grab the 'first 4999 items' from the array, which does work with an expression like this: ...
Read more