Fri, Nov 26 | Online Workshop

Excel Power BI Desktop for Data Analysis & Visualization

Workshop an opportunity to Upskill & Reskill….Achieve Your Career Goal Power Pivot, Query & Power BI Desktop: Data Analysis & Visualization
Registration is Closed
Excel Power BI Desktop for Data  Analysis & Visualization

Time & Location

Nov 26, 5:00 PM – 8:00 PM GMT+5:30
Online Workshop

About the Event

Workshop an opportunity to Upskill & Reskill….

Excel  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 hours

    Data Analysis & Visualization

    Online Workshop
Tickets
Price
Quantity
Total
  • Online Workshop
    INR 150
    INR 150
    0
    INR 0
TotalINR 0

Share This Event