ITI 257 Data Analysis with Power BI Chapter

ITI 257 Data Analysis with Power BI Chapter 9 – Power Pivot Basics http: //www. profburnett. com

Outline �Pivot. Tables �The Power Pivot Environment �The Power Pivot Interface �Power Pivot Data Sources �Power View Exercise 1 �Power Pivot Data Types �Manipulating Power Pivot Data �Power View Exercise 2 1/5/2022 Copyright © Carl M. Burnett 2

Pivot. Tables �Use Sponsors. xlsx �File on GBTC share drive 1/5/2022 Copyright © Carl

Prepare Your Data for Power BI 1/5/2022 Copyright © Carl M. Burnett 4

The Power Pivot Environment �Load Data into Power Pivot form Data Sources �Make Structural Changes to Data Sets �Update data �Tweak Data �Apply Formatting �Sort Data �Filter Data 1/5/2022 Copyright © Carl M. Burnett 5

Power Pivot Data Sources From Database Data Sources �Access �SQL server �MS Analysis Services 1/5/2022 Copyright © Carl M. Burnett From Date Service Data Sources �Windows Azure Services �Suggest Related Data �Odata Data Feed 6

Power Pivot Data Sources From Other Data Sources � MS SQL Server � MS SQL Azure � Hadoop on MS Azure � Mongo. DB � My. SQL � MS SQL Server Parallel Data Warehouse � MS Access 1/5/2022 Copyright © Carl M. Burnett � Oracle � Teradata � Sybase � IBM DB 2 � MS Analysis Services � Suggest Related Data � Other Feeds (XML / JSON) � Excel File � Text File 7

Power View Exercise 1 �Loading Data from SQL Server – Page 227 �Connect to

Power Pivot Data Types �Date �True/False (Boolean) �Text �Whole Number �Decimal Number �Currency 1/5/2022

Power View Exercise 2 Manipulating Data in Power View �Sort Data – Page 261 �Filtering Data – Page 262 �Clearing Filters – Page 264 �Custom Filters: Text – Page 264 �Custom Filters: Numeric – Page 265 1/5/2022 Copyright © Carl M. Burnett 10

Review �The Power Pivot Environment �The Power Pivot Interface �Power Pivot Data Sources �Power View Exercise 1 �Power Pivot Data Types �Manipulating Power Pivot Data �Power View Exercise 2 1/5/2022 Copyright © Carl M. Burnett 11