2-Day Data Analysis with Excel Power Query, Data Model, DAX and Power Pivot Course

This course is created, owned and trained by Mr. Alaster Leong. Learn from the original creator of this course.

Important Note:

Please check the following before registering:

• This course is only for Windows users with Microsoft Excel that is compatible with Power Pivot. Power Pivot is an add-in for the software, and not all versions can support this add-in. Learners must have one of these Excel versions.
  
  
• To check which Excel versions can support Power Pivot, click here. To find out how to turn on the Power Pivot add-in, click here and the guide to check Power Query availability, click here.

Your understanding of Excel for business may only be scratching the surface. Trying to use formulas to process data can be confusing and challenging, and there are many more functions that may look foreign. If you are looking for a way to game the system and elevate your Microsoft Excel proficiency to new heights for data analysis, this course is for you. Through a comprehensive training module, you will be introduced to Excel’s powerful data modelling and leverage specific business intelligence tools.

Excel’s Business Intelligence (BI) is a collection of tools and processes that are used to gather data and turn it into meaningful information to help users make better decisions. Within this depository, you will find Power Query, Power Pivot, and Data Analysis Expression (DAX) – dynamic tools to help you achieve greater efficiency with little effort.

What sets us apart from other training providers providing Power Pivot courses?

• We do not have a readily created database for you. Since this is a project-based hands-on learning course, you will learn how to build data model from scratch from the raw data provided, clean up the data, build the data model with table relationships and use DAX formulas to generate other required data and KPIs, and display out as a Pivot Table final report.
• You will learn the importance of Data Normalisation and how it works.

Learners of this course will undergo hands-on training with Power Query, designed to extract, cleanse, transform, and load data from flat files, folders, databases and more. You will practice shaping, blending, and exploring project files, and create completely automated loading procedures with just a few clicks.

Additionally, learners will also get the opportunity to explore data modelling, and learn the fundamentals of database design and normalisation (including table relationships, hierarchies and more). You will take a tour through Excel’s data model interface, and create your own relational database using our raw data provided for analysis throughout this course. The raw data provides in this course may not be applicable to your industry, but the knowledge and techniques learnt in the course are applicable to any industry data.

Finally, through the exploration and analysis of the data model, you will be able to grasp a clear understanding of Power Pivot and DAX. Unlike the traditional Pivot Table, Power Pivot allows you to comprehend hundreds and millions of rows across multiple data tables. It also creates powerful calculated fields and measures data using DAX – which is a formula language. Learners will get to learn basic DAX syntax, then be introduced to some of the most commonly used and powerful functions like CALCULATE, FILTER, SUMX, among others.

With the Excel Power Query, Data Model and Power Pivot course, you will be equipped with emerging data analysis skills to make your job more efficient. Becoming a powerful Excel user in Singapore is now easier than ever.