Power Pivot, Query & Power BI : Data Analysis & Visualization

Workshop an opportunity to Upskill & Reskill….

Power Pivot, Query & Power BI Desktop: Data Analysis & Visualization

What you'll learn in this data analysis & visualization workshop:

Power Pivot,Query and Power BI Desktop: Analysis and Data Visualization

In this three-hour Excel for Windows session, you will learn how to use Excel's free Power Pivot add-in to connect to external data sources, create relational data models and perform powerful data analysis and summarization. Learn the basics of writing Data Analysis Expressions (DAX) to calculate measures and add key performance indicators (KPIs) into your PivotTables. Next, switch to Power BI Desktop (formerly Power View in Excel) and create stunning reports with interactive data visualizations. Again, connect to multiple data sources, shape the data with queries, and then use a drag-and-drop canvas to create rich, compelling reports, choosing from hundreds of modern data visuals.

Prerequisites

This class is ideally suited for people who have basic knowledge of Excel or Excel PivotTables and want to take their data analysis and visual reporting skills deeper with the free Power Pivot add-in and free Power BI Desktop app.

Class Outline

Connect to Data in Power Pivot

• create queries to connect to external data tables
• modify and fine-tune queries
• add tables to Excel's Data Model

Build Relational Data Models

• understand primary and foreign key fields
• determine cardinality of relationship between tables
• construct relationships between tables

Add Measures and KPIs

• write simple DAX formulas to create measures
• create KPIs based on your custom measures

Connect to Data in Power BI Desktop

• connect to various external data sources

Shape the Data

• construct queries to get the data in shape

Report with Interactive Data Visualizations

• create reports with stunning data visualizations
• choose from many contemporary visuals