Mastering in DAX and Data Modelling Training in Sydney

Certificate: Course Completion Certificate Language: English

Duration: 1 Day Credits: 8

Course Delivery: Classroom/ Virtual Live/ On-Site

Course Overview:

Learn Microsoft Power BI with our comprehensive training courses. Our courses range from the basics of Power BI to complex data modelling using DAX and creating live dashboards for reporting. These courses are for anyone interested in business intelligence, reporting and complex data modelling.

Target Audience:

The Power BI training is for all the professionals who are passionate about business intelligence, data visualization, and data analytics.

• Business Analysts
• Business Intelligence Manager
• Statisticians and Analysts
• Data Scientists
• Project Managers

Learning Objectives:

• Understand primary features of a self-service Power BI solution
• Utilize Power BI and its data sources
• Combine, analyze, model, shape, and visualize data
• Report data using rich dashboards

Prerequisites:

There are no prerequisites for this course.

Course Materials:

Students will receive a course manual with presentation slides and reference materials.

Examination:

No Exam

Technical Requirements:

For eBooks:

Internet for downloading the eBook

Laptop, tablet, Smartphone, eReader (No Kindle)

Adobe DRM supported software (e.g. Digital Editions, Bluefire Reader)

eBook download and activation instructions

Agenda:

• Dimensional modelling
• Star schema – Snowflakes
• Data modelling scenarios
• Tables relationship scenarios
• Slowly changing dimension
• Introduction to DAX
• DAX Evaluation, Filter and Row contexts
• DAX functions – Aggregator/Iterator
• Deep dive to Calculate function
• DAX Time Intelligence
• DAX table functions
• Querying data by DAX
• Hands on lab practices

Note:

However, catering to the demands of busy professionals, our virtual training programs are as effective as face-to-face learning. Reach us at [email protected] for dates and details of Instructor Led Live Virtual Session.

If you would like to get this course customized and delivered exclusively for your group, we have an On-Site Training Option you can reach us at [email protected] for more details about on-site or corporate training.

Offers:

Groups of 3 people 10% Discount

Groups of 5 people 15% Discount

Groups of 10 people 20% Discount

Host or Publisher Academy for Pros