Understanding the Power BI Toolset – 3 Options

BI Tools and Solutions at your fingertips

If you’re wondering how to best put to use Microsoft’s robust Self-Service business intelligence tools, or if you want an update on all the significant changes in just the last three months, here’s the run down on Power BI and three different options your organization can choose from to fully realize Microsoft’s Self-Service Business Intelligence model. Each service offers different tools and techniques to accomplish your reporting needs.

Power BI for Excel – option 1

Power BI for Excel is a set of add-ins for Microsoft Excel that will enable users to create business intelligence reports within the Excel interface they are already accustomed to.  These add-ins include, PowerPivot, Power View, Power Query, and Power Map.

Power BI for Excel is a complete reporting solution.  All reports are created as worksheets within an Excel workbook.  Data querying and modeling are performed using the Power Query and PowerPivot add-ins.  Report visualization can be performed both by traditional PivotTable/Pivot Chart reports as well as by using the Power View add-in. Report hosting is accomplished through traditional methods such as email, SharePoint libraries, OneDrive or by placing the Excel workbooks on shared network drives.

Picture2

Power BI for the Cloud – option 2 & 3

Power BI for the Cloud is broken into two components, Power BI Desktop and Power BI Service (powerbi.com).  These tools enable users to create business intelligence reports in a dedicated tool and then host them using the Power BI Service which allows users to access their reports from anywhere, anytime.

The Power BI Service pairs with the Power BI Desktop to provide a complete reporting solution.  Data querying and modeling are performed using the Power BI Desktop.  Report visualizations can be generated in both Power BI Desktop and directly in the Power BI Service.  Reports and data models created within the Power BI Desktop are saved as .PBIX files and then uploaded to the Power BI Service. Report and Dashboard hosting are accomplished through the Power BI Service.

Picture1

 

TLG Learning Power BI Courses

TLG Learning has the most up-to-date course offerings for all three Power BI options. The 3 training paths include role based courses that you can take depending on your needs.  See all Power BI courses or attend our up-to-date Free Webinar to learn what you need to know to put these tools to use, or how you can best incorporate the latest robust new features.

Power BI for Excel 2013

  • Level 1 – Power BI for Excel: Report Builders
  • Level 2 – Power BI for Excel: Power BI Tools
  • Level 3 – Power BI for Excel: Data Model Designers
  • Level 4 – Power BI for Excel: DAX Functions (2 days)

Power BI for Excel 2016

  • Level 1 – Power BI for Excel: Report Builders
  • Level 2 – Power BI for Excel: Power BI Tools
  • Level 3 – Power BI for Excel: Data Model Designers
  • Level 4 – Power BI for Excel: DAX Functions (2 days)

Power BI for the Cloud

  • Power BI for the Cloud: Service Reporting
  • Level 1 – Power BI for the Cloud: Report Builders (2 days)
  • Level 2 – Power BI for the Cloud: Data Model Designers

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s