Microsoft Power BIIntroduction to Microsoft’s Self-Service BI Platform

@JohnBerry socialsupplychains.com

Self-Service BI

Conventional BI Focuses on internal

business data

Highly structured, well-defined data model

Designed by BI professionals

Support for large data sets

Not usually real-time data

High level of change control

Self-Service BI Often focuses on

mashups of internal and external data

Ad-hoc adaptive data models

Designed by analysts or BI professionals

Support for small to medium-sized data sets

Sometimes real-time data

Little change control

Microsoft Self-Serve BI Architecture

SQL Server

Azure SQL Database

Power Query

Power Pivot

Power View /

Power Map

Power BI for Office 365

Data Storage Platform

Excel Add-Ins

Cloud Collaboration

Azure Machine Learning

Excel Power Add-ins

Power Query Power Pivot Power View

• Loads data from a variety of data sources

• Join across data sources to create mashups

• Perform basic data transformations

• Output tabular data sources into Excel Data Model or Worksheets

• In-memory analytics engine (xVelocity)

• Define relationships across tabular data sources

• Query data using DAX

• Visualize data with tables or charts

• Create interactive dashboards

• Some overlap with conventional Excel dataviz tools

• Collaborate on dashboards using Office 365

How to Get Power BI for Excel

Excel 2013 Standalone License ($99 on Amazon)

Office 2013 Professional Plus License (Enterprise Agreement)

Power BI for Office 365 ($52 per month)

Demo TimeA Quick walk-through of Power Query, Power Pivot, and Power View