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

S$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

Check out more MS Excel courses in Singapore

Ask Training Logo

Microsoft Excel Power Query, Data Model, Power Pivot & DAX (Intro)

This course introduces Microsoft Excel’s powerful data modeling and business intelligence tools: Power Query, Power Pivot, and Data Analysis Expressions (DAX). 

by Ask Training [Claim Listing ]
New Horizons Singapore Logo

Microsoft Access

Demonstrate that you have the skills needed to get the most out of Access by earning the Microsoft Office Specialist: Access Associate or Expert Certification. This certification demonstrates competency in database design principles.

by New Horizons Singapore [Claim Listing ]
Edulearn International College Logo

Certificate In Ms Office Basic Level

Certificate In Ms Office Basic Level course is offered by Edulearn International College. Edulearn International College is a Private Education Institute (PEI) Registered with the Committee for Private Education which is part of SkillsFuture Singapore(SSG).

by Edulearn International College [Claim Listing ]
Inspizone Logo

Microsoft PowerPoint

After completing this 2-day PowerPoint training course, participant will be able to create and deliver a professional PowerPoint presentations that explain the key points of the presented message via the use of text, graphics, and animations.

by Inspizone [Claim Listing ]
Aventis Learning Group (ALG) Logo

Microsoft Word Course

MS Words continue to play a prominent Role in people’s Professional & Personal lives. Having the skills to create amazing reports, edit perfectly, format & finalize impressive documents will improve your droductivity & will allow you to produce professional & polished documents.

by Aventis Learning Group (ALG) [Claim Listing ]

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