Transcript Building_a_PowerPivot_BI_Dashboard_-__SQLSat

PowerPivot
Vazi Okhandiar, MCT, PMP, MBA, MSCS
SQLSaturday #497 . April 2nd, 2016
Objective
 Using PowerPivot
 Loading Data
 Preparing Data
 Using PivotTable
 Using PivotChart
 Using Slicer
 Using Power Map
Prerequisites
 Excel 2010 (32 bit or 64
bit) or higher
 Windows 7 (32-bit) or
higher
 Microsoft .NET Framework
3.5 SP1
PowerPivot Overview
 Free add-on from Microsoft
 An extension to the “normal” Excel Software.
 Expands the data analysis capabilities of Excel.
 Allows collaboration of data across an organization
 Supports data import from Text file, DB2, Access, Informix,
Oracle, Sybase, Azure, Text file, Excel, Teradata, SQL Server
 Supports Visualize Tool - PivotCharts, PivotTable, Slicers,
Sparklines
 Uses VertiPaq engine (in-memory column store)
PowerPivot Window
 Activate PowerPivot (File > Option > COM Add-in> Microsoft Office
PowerPivot for Excel 2013)
 Launch PowerPivot tab on the Excel ribbon
Using PowerPivot
 Start Excel
 Start PowerPivot
 Load Data
Database
Power
Pivot
 Prepare Data
 Build dashboard
Text File
PivotChart
/PivotTable
Demo
(Power Pivot)
Power Map
 3D data visualization tool for Excel
 Plot more than a million rows of data.
 Discover new insights by seeing your data in geographic space and
seeing time-stamped data change over time.
 Requires at least one geographic value per row of data
(Latitude/Longitude pair, City, Country/Region, Zip code/Postal
code, State/Province, or Address)
Power Map
 Download Power Map
 https://www.microsoft.com/en-us/download/details.aspx?id=38395
 Run the installer to install the Power Map add-in.
 To use Power Map open Excel and go to Insert -> Map
Demo
(Power Pivot)
Summary
 Using PowerPivot
 Loading Data
 Preparing Data
 Using PivotTable
 Using PivotChart
 Using Slicer
 Using Power Map
Vazi Okhandiar, MCT, PMP, MBA, MSCS
 20+ years – IT Project Management, Application development & IT Training
 General Motors, Toyota, EDS, Computer Science Corp
 Certification: PMP . Microsoft Certified Trainer
 Education: MBA, University of California, Irvine(UCI) . MS Computer Science,
IIT, Chicago . BS Electrical Engineering, UCI
 [email protected]
Vazi Okhandiar, MCT, PMP, MBA, MSCS
www.nrclc.com