Power BI: Advanced Data Modeling

This course will walk through Power BI capabilities to enhance the data model for your business users. The course covers key aspects of create a great data model to meet your business needs, various features in Power BI to enhance data model for you and your organization to build great reports and introduction to DAX to create calculations. In this course you also learn best practices on data models and various DAX calculation patterns.

Power BI: Advanced Data Modeling

What you will learn

What you will learn:

	Understand basic concepts of Data Modeling
	Understand the consequences of data model design decisions
	Understand concepts of calculated columns and measures
	Gain familiarity with standard DAX patterns & CALCULATE
	Understand evaluation contexts and their impact on calculations
	Gain ability to parse data modeling formulas

Class Size: 10

Course Outline:

I.	Introduction
	a.	Course Introduction
	b.	Study - Kit
II.	Module 1: Data Modeling Basics & Power BI Desktop Internals
III.	Module 2: Data Modeling Best Practices
IV.	Module 3: DAX Calculated Columns & Measures
V.	Module 4: CALCULATE
VI.	Module 5: DAX Evaluation Context
VII.	Module 6: Data Modeling: Time Intelligence Functions
VIII.	Module 7: DAX Best Practices
IX.	Further Readings: DAX Studio & DAX Pattern

Skills you will gain

Microsoft Power BI

Data Modeling

Data Visualization

Power BI DAX

Reports Generation

Instructor

Argelo Royce Bautista

Anonimouse Technologies Inc.

Business Systems Analyst @ Analog Devices Inc for 6 years

3-time awardee of Microsoft Most Valuable Professional Award for Data Platform

Microsoft Certified Trainer

Microsoft Certified Solutions Expert for Data Management and Analytics

Microsoft Certified Solutions Associate for Business Intelligence Reporting

Requirements

Prerequisite Knowledge: • Relational Data Concepts • Business Intelligence Concepts Prerequisite Technologies: • Power BI Desktop x64 2.79.5768.1082 64-bit (March 2020)

About Anonimouse Technologies Inc.

We are one of the country's leading technology-based education provider, committed to providing a platform to give access for both technical and non-technical learners through workshop sessions, which are friendly for beginners.

Offered by