
Sat, Jun 19
|Online Workshop
Power Pivot, Query & Power BI : Data Analysis & Visualization
Workshop an opportunity to Upskill & Reskill….Achieve Your Career Goal Power Pivot, Query & Power BI Desktop: Data Analysis & Visualization


Time & Location
Jun 19, 2021, 5:00 PM – 8:00 PM GMT+5:30
Online Workshop
Guests
About the Event
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
Schedule
3 hoursData Analysis & Visualization
Online Workshop
Tickets
Online Workshop
The fees is inclusive of the certificate of participation
₹150.00
Total
₹0.00