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

Training Singapore Logo

Microsoft Office

Microsoft Office is a most popular windows or Mac suites that containing various tools for processing word (Word), data entries in spreadsheets (Excel), and audio-visual clippings (PowerPoint).

by Training Singapore [Claim Listing ]
G-Tec Computer Education Centre Logo

MS Power Point

MS Power Point course is offered by G-Tec Computer Education Centre for all skill level. Our aim to train people in different categories ranging from school level to corporate clients. All this factors would help to achieve our ultimate goal.

by G-Tec Computer Education Centre [Claim Listing ]
NobleProg (Singapore) Logo

Fundamentals Of Microsoft Office

This instructor-led, live training in Singapore (online or onsite) is aimed at anyone who wishes to learn and use the software and services available in the MS Office suite to enhance their work productivity.

by NobleProg (Singapore) [Claim Listing ]
James Cook Institute Logo

MS Powerpoint

This advanced Microsoft PowerPoint presentation course sets out to elevate your presentation skills and PowerPoint design.

by James Cook Institute [Claim Listing ]
  • Price
  • Start Date
  • Duration
New Horizons Singapore Logo

Microsoft Word Training

Mastering Microsoft Word is a useful skill for all business professionals. Your Microsoft Word training will also prepare you for a Microsoft Office Specialist certification.

by New Horizons Singapore [Claim Listing ]

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