Data Analytics and Visualization with Excel Power Tools

by COMAT Claim Listing

Explore data visualization with Excel PowerPivot,PowerQuery and PowerView. This 2-days course empowers the participants with the skills and knowledge on how to combine the functionality of the power tools and Power Map to translate data into graphs, KPIs, reports, and other visualizations for use in

$864

Contact the Institutes

Fill this form

Advertisement

COMAT Logo

img Duration

2 Days

Course Details

What Will Be Taught For This Excel Power Tools Training Course?

Explore data visualization with Excel PowerPivot,PowerQuery and PowerView. This 2-days course empowers the participants with the skills and knowledge on how to combine the functionality of the power tools and Power Map to translate data into graphs, KPIs, reports, and other visualizations for use in their business.

 

Module 1. Quick Overview of Excel Power Tools

 

Module 2. Working with Power Pivot

  • Power Pivot Interface

  • Getting Data for Power Pivot

  • Working with Relationships

  • Configuring Calculated Columns and Calculated Fields

  • Introducing DAX Functions

  • Build Measures with DAX Functions

  • Using KPIs

  • Working with Hierarchies

 

Module 3. Power Query

  • Power Query Interface

  • Importing Data

  • Appending Files in Folders

  • Data Transformation (UnPivoting, Pivoting, Grouping Data)

  • Creating Charts

 

Module 4. Power View

  • Power View Interface

  • Working with Tables

  • Understanding Aggregations

  • Utilizing Matrix

  • Working with Drill Through

  • Using Cards

  • Applying Filters & Highlights

  • Cross-Filtering

 

Module 5.Power Map

  • Power Map Interface

  • Working with Power Map

 

Module 6. Present and Communicate with Dashboard

  • Create your dashboard with Excel Power Tools

  • Know the Best Practices

  • North-East Branch

    10 Anson Road, #06-19/20 International Plaza, North-East

© 2025 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy