Data Analysis with Power BI SelfService Business Intelligence

Data Analysis with Power BI Self-Service Business Intelligence http: //www. profburnett. com

Outline � The Microsoft Self-Service BI Solution � The Excel BI Toolkit and Power BI � Power Pivot Overview � Power View Overview � Power Query Overview � Power BI Overview 1/16/2022 Copyright © Carl M. Burnett � Preparing the Self-Service Environment � The Excel Data Model � MS Power BI Universe � Power BI 2. 0 Architecture � Power BI Desktop Overview 2

What is Traditional BI? Databases Text Files Spreadsheets List 1/16/2022 Copyright © Carl M. Burnett Traditional BI Tools • IBM Cognos • Oracle Hyperion • SAP Business Objects • SAS • Micro. Strategy • Tableau • Qlik. View 3

The Microsoft Self-Service BI Solution Power Pivot Databases Text Files Spreadsheets List 1/16/2022 Power BI Power View Copyright © Carl M. Burnett 4

The Excel BI Toolkit and Power BI Excel Toolkit Power BI Desktop Power Pivot Power View 1/16/2022 Copyright © Carl M. Burnett Power BI 5

Power Pivot Overview �Create A Data Model with Tables �Enrich the Data Model with �Create Calculations & Metrics �Add Hierarchies �Create Key Performance Indicators (KPIs) 1/16/2022 Copyright © Carl M. Burnett Power. Pivot 6

Power View Overview �Dynamic Analysis & Presentation �Tables �Matrixes �Charts �Maps �Slicers �Filters �Highlights 1/16/2022 Copyright © Carl M. Burnett Power View 7

Power Query Overview �Discover Access & Consolidate Data �Import from Wide Variety of Sources �Merge Data �Shape Data �Cleanse Data 1/16/2022 Copyright © Carl M. Burnett 8

Power BI Overview �Desktop & Cloud-Based Collaboration Environment �Share Presentations �Create Dashboards �Output Multiple Devices �Real-time Analytical Updating, Querying, and Reporting 1/16/2022 Copyright © Carl M. Burnett 9

Preparing the Self-Service Environment �Enable Power. Pivot & Power View �Download and Install Power Query API �Install Power BI Desktop app or �Subscribe to MS 365 Pro Plus �Install Power Map 1/16/2022 Copyright © Carl M. Burnett 10

The Excel Data Model �Excel Data Model Exceeds 1 M row limit in Excel �One or More Tables �Coherent Data Joining �Use Complex Hierarchies and KPI 1/16/2022 Copyright © Carl M. Burnett 11

MS Power BI Universe Power Pivot Excel Worksheet Data Model Power View 1/16/2022 Power BI (Cloud Based) Copyright © Carl M. Burnett Power BI (Desktop) 12

Power BI 2. 0 Architecture MS Excel Power BI Toolkit Power BI Dashboards External Data Sources Power View Power Pivot Reports Datasets Power BI Data Management Gateway Services Power BI Desktop 1/16/2022 Power BI Personal Gateway Copyright © Carl M. Burnett Power BI Analysis Service Connectors 13

Power BI Desktop Overview 1/16/2022 Copyright © Carl M. Burnett 14

Review � The Microsoft Self-Service BI Solution � The Excel BI Toolkit and Power BI � Power Pivot Overview � Power View Overview � Power Query Overview � Power BI Overview 1/16/2022 Copyright © Carl M. Burnett � Preparing the Self-Service Environment � The Excel Data Model � MS Power BI Universe � Power BI 2. 0 Architecture � Power BI Desktop Overview 15