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

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 ]
St.Hua Private School Logo

Microsoft Excel Essentials

Microsoft Excel is a powerful yet user-friendly spreadsheet software. In this course, you will learn how to input and organize data, use functions to perform calculations, format the appearance of your data and cells, and build stunning charts and PivotTables.

by St.Hua Private School [Claim Listing ]
Coursemology Logo

Advanced Microsoft Powerpoint 2016

Advanced Microsoft PowerPoint Course is a certification programme for learners who wish to create effective, high-impact presentations using advanced features and who need to be able to prove their skills in this area.

by Coursemology [Claim Listing ]
New Horizons Singapore Logo

PowerPoint Training In Singapore

New Horizons has PowerPoint classes for any experience level. Learn the basics like template use and content placement, or up your skills by learning how to create custom slides with advanced transitions and animations.

by New Horizons Singapore [Claim Listing ]
Advanced Learning Singapore Logo

Word Tips And Techniques Course

This course will cover techniques on mail merge, an important tool to reduce errors,  enhance efficiency in document creation and email communication.

by Advanced Learning Singapore [Claim Listing ]
  • Price
  • Start Date
  • Duration

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