Data Transformations And Modeling

Learn how to clean, optimize and model data tables to develop effective, insightful and actionable Power BI reports

5 hours

49 lessons

612 xp

Power BI

Data Modeling

Data Transformation

Let’s create your free account

Personal

Google

Corporate

Microsoft

Azure

If you have an account Login here

Trusted by 220,000+ people worldwide.

An outline of this training course

Explore the Power BI query editor and data model development in this course, highlighting their key roles in effective reporting. Learn advanced techniques to optimize data tables and build functional analytical models using DAX formulas. Enhance your skills to answer complex analytical questions with precision. Join us to master Power BI and elevate your data analysis capabilities!

Details of what you will learn in this course

Learn - best practice techniques when using the query editor
Learn - how to work with 'M' code and the advanced editor
Understand - the row and column query transformation options
Implement - advanced data cleaning and transformation techniques
Work - through end to end examples of querying multiple tables
Learn - how to think about and manage the data model
Learn - effective techniques applicable to any data scenario
Apply- advanced data modeling techniques to your own models
Understand - advanced modeling scenarios and situations
Learn - how to effectively organize your models

What you get with the course

Over 4 hours of video training
Demo data sets for practical application

Here are the specifics for the course

Learn how to:

Utilize the query editor to clean up and optimize your raw data tables
Learn the great functionality hidden away in the query editor
Implement advanced transformation techniques to improve your solutions
Organize your queries so you can manage complexity
Manage tables of data from multiple different data sources
Design and execute on an effective data model
Analytical think about your data model and then create the correct relationships
Lay out your data model so it is designed intuitively
Implement data models our unique data scenarios

What our

Students Say

Curriculum

Introduction

Data transformation examples

Advanced transformation and querying techniques

Designing advanced data models

Advanced modeling concepts

Optimising your models

Your Feedback

Free

Certification

Continuous Learning

Your

Instructor

Sam McKay

CEO & Founder

Sam is Enterprise DNA's CEO & Founder. He helps individuals and organizations develop data-driven cultures and create enterprise value by delivering business intelligence training and education on Microsoft’s Power BI platform
He partners with business decision-makers and analysts across all industries and business functions.

Frequently Asked

Questions

What’s the difference between a free account and a paid plan?

Do I need to know anything about data science or data analytics to get started with Enterprise DNA?

How will I be charged?

Can I get an invoice for my company?

Are refunds available?

Will AI take over the world and make data skills worthless?

The Ultimate Guide to Azure AI Studio

Leverage Azure's powerful AI tools to optimize your data workflows and boost automation. Automate data processing, utilize predictive analytics, and improve operational efficiency seamlessly within your existing infrastructure.

Tools