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

Aventis Learning Group (ALG) Logo

Microsoft Excel Tips & Tricks For Beginners

This course will equip learners with the techniques to create a new workbook using template, add data to the worksheet, format data, build formulas, insert functions, copy formulas, print worksheet and workbook, sort and filter data list, find and replace text or formatting.

by Aventis Learning Group (ALG) [Claim Listing ]
Koenig-Solutions Logo

Intermediate Microsoft Excel

The Intermediate Microsoft Excel Certification is an accreditation that underlines proficiency in utilizing Microsoft Excel at an intermediate level.

by Koenig-Solutions [Claim Listing ]
James Cook Institute Logo

MS Excel

Understand the concept of spreadsheets and demonstrate the ability to use a spreadsheet application. Our core commitment lies in providing excellent training to unlock our learners’ vast potential, ensuring personal and professional growth.

by James Cook Institute [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 ]
Ccisg Logo

MS Word Tips & Techniques

Despite the many alternatives that are out there, Microsoft Word remains one of the most popular word processors available. Such a popular tool should be easy to master, right?

by Ccisg [Claim Listing ]

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