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

by Ask Training Claim Listing

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

S$750

Contact the Institutes

Fill this form

Advertisement

Ask Training Logo

img Duration

2 Days

Course Details

This course introduces Microsoft Excel’s powerful data modeling and business intelligence tools: Power Query, Power Pivot, and Data Analysis Expressions (DAX). Business intelligence (BI) is a collection of tools and processes that are used to gather data and turn it into meaningful information that people can use to make better decisions.

 

At the end of the 2 days training, you will be able to:

  • have hands-on experience with Power Query
  • Explore the Data Modeling and cover the fundamentals of database design and normalization (including table relationships, hierarchies and more)
  • Use Power Pivot and DAX to explore and analyze the data model. Unlike traditional Pivot Table, Power Pivot allows you to analyze hundreds of millions of rows across multiple data tables, and create powerful calculated fields and measures using a formula language called Data Analysis Expressions (or “DAX” for short)

 

  • Central Branch

    8 Jurong Town Hall Rd #27-01 JTC Summit, Central

Check out more MS Excel courses in Singapore

Ask Training Logo

Microsoft Access 2019 – Basic & Intermediate*

Learn to understand the Database structure & concept with table relationships. You will also learn how to create and modify database objects such as tables, forms, reports, and queries, and subsequently apply intermediate skills to manage data entry,

by Ask Training [Claim Listing ]
St.Hua Private School Logo

Microsoft Access Essentials

Microsoft Access is a general-purpose, versatile and powerful database management software. In this course, you will build databases that store and retrieve data efficiently, as well as editing and modifying fields and records.

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

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