Power BI and the new way of working with data

Whether you are a small, medium to large company, getting your arms around good data and managing multiple data reports can be a daunting feat. As a former data analyst, I remember this process all too well.  A well-formed data report is key to understanding company growth and decline.  This is the “business intelligence” piece behind data.

Like most data analyst, my tool of choice was Excel.  I remember compiling and scrubbing data, putting together graphs and charts in highly stylized scorecards and dashboards.  This process is slow and mind numbing. 

Fast forward to present time and Business intelligence (BI) as we call it has gathered attention.  The new Business intelligence (BI) coming out of Microsoft is called Power BI.

I can’t say enough great things about Power BI.  Data reports become something to look forward to rather than dreading. Data still needs to be analyzed but the manual process of compiling and assembling is a thing of the past.  Plus taking advantage of highly stylized and interactive reports drive a stronger message when making key business decisions.

Power BI as it is called now has three flavors to choose from.  Each section of Power BI has the capability to drive good solid business intelligence and help  make good  decisions based on the data reports.

  • Excel 2013 with Power BI

Within Excel 2013, Power BI unleashes the technical power to the non-technical end users.  Start out in Excel and leverage Power BI to do the heavy lifting.

1.Power View – create interactive reports, add deeper dimensions to reports by adding filters
2.Power Pivot – join tables, sort and organize data, create KPIs based on  the new joins
3.Power Map – create a 3-D map experience in Excel

  •  Interactive Reports with Excel 2013 and SharePoint Online

Now that you’ve created your interactive reports, what is the best way to share them.  SharePoint of course.

  •  Power BI Q&A

 Consider Power BI Q&A as the presentation layer to an executive meeting.  It provides the polish and technical professionalism.

The advantages of Power BI boils down to 3 things.

1.  Data is interactive.

  Data behind the Power BI reports is dynamic and interactive. No more static scorecards or dashboards.

2. Data is update and accessible on site.

Data is loaded up on SharePoint team or O365 BI site.  Behind the scene tables are mapped using PowerPivot data models.

3. Configure and change filters and charts to suit.

 Filters and multiple chart views can be used to tell compelling story.

To read more about SharePoint Online and Power BI,
Click here.





Leave a Reply

Your email address will not be published. Required fields are marked *