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

NobleProg Training Institute Logo

Microsoft Access - Download The Data

The course is designed for persons with pre-information databases using SQL queries or queries.

by NobleProg Training Institute [Claim Listing ]
ARC Learning Academy Limited Logo

Using Microsoft Excel For Personal Effectiveness

This training provides learners with the necessary knowledge and practices in Microsoft Excel 365. Learners will learn the fundamental skills for building and modifying data. Additionally, they will learn to create simple formulas and charts.

by ARC Learning Academy Limited [Claim Listing ]
  • Price
  • Start Date
  • Duration
Intuition International Logo

Microsoft MS PowerPoint and MS Word (2013, 2016, 2019 and 365) for Office and Business Presentation

Our instructors are exclusive to us and we only engage excellent instructors to ensure all learners meet their individual needs and receive quality teaching. Our curriculum is unique and they include exercises to help participants retain knowledge for long-term use.

by Intuition International [Claim Listing ]
Intellisoft Logo

Microsoft Excel Training (Basic)

The Basic Excel Skills Hands-on training teaches you how to use Microsoft Excel 2019 / Microsoft Office 365 extremely well for day to day use in the office, and at home.

by Intellisoft
Ccisg Logo

Microsoft Office 2016/2019/365 Timesaving Quick Tips

This course aims at equipping participants with timesaving tips and tricks in Microsoft Excel, Microsoft Word and Microsoft PowerPoint that will boost up their work productivity.

by Ccisg [Claim Listing ]

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