Mydra logo
Log in
>All courses>Data
Data
Data
Naveia logo

Naveia

Data Modeling in Power BI

  • Advanced

Master your data and understand the dimensional models of your business with live classes, tutorials, and labs. This course offers a comprehensive view of the modeling process and helps you organize your data for analysis, making you an expert in Power BI.

  • Dimensional modeling
  • Data structuring
  • ETL processes
  • DAX
  • Data relationships

Overview

In this course, you will understand the concept of dimensional modeling and discover various ways to structure data, such as creating a Datawarehouse and breaking down its dimensions into star or snowflake schemas. Dive deeper into Dimensional Modeling in Power BI, learn DAX language, establish data relationships and hierarchies, manage modeling with security, and effectively communicate report results through storytelling.

  • Layers 1 Streamline Icon: https://streamlinehq.com
    Spanish
    course language
  • Professional Certification
    upon course completion

Who is this course for?

Power BI Users

Users of Power BI without a deep understanding of dimensional models.

Report Creators

Users who have created reports that have gradually become complex.

Business Users

Any business user looking to start in the world of data and Power BI.

Why should you take this course?

Data

This course will help you master data modeling in Power BI, covering key concepts like dimensional modeling, DAX, and data storytelling. Ideal for advanced users, it will enhance your data analysis skills and advance your career.

Pre-Requisites

1 / 3

  • Basic knowledge of Power BI

  • Understanding of data analysis concepts

  • Familiarity with business intelligence tools

What will you learn?

General Scenario: What is BI?
Introduction to Business Intelligence concepts and terminology.
Datawarehouse
Understanding OLAP/OLTP, Inmon/Kimball methodologies.
Dimensional Modeling
Concepts of facts, types of fact tables, and dimensions.
Handling Changes
Managing exceptions and outliers in data models.
Modeling in Power BI
Working with tables, columns, relationships, and hierarchies.
Introduction to DAX
Learning measures, calculated columns, and tables.
Particularities
Understanding disconnected slicers, Q&A, and roleplaying dimensions.
Time Intelligence
Implementing time-based calculations in Power BI.
Security Overview
An introduction to data security in Power BI.
Storytelling Overview
Using storytelling to present data insights effectively.

Meet your instructor

  • Miguel Egea Gómez

    Data & AI Technical Lead, Verne Technology Group

    Miguel Egea Gómez has over 25 years of experience in data processing, with over 15 years dedicated exclusively to data. He holds a Master's degree in Big Data & Analytics from the University of Murcia. He is a speaker at Microsoft conferences, co-founder of the SQL Sat Madrid team, passionate about Power BI, and enjoys the challenges of each day. He is also a father of three, a husband, an amateur painter, and interested in everything that sparks his curiosity.

Frequently Asked Questions

How can I learn more about this course?
For any additional information or to clarify any doubts about a course, feel free to reach out via chat or email. Our dedicated advisors are here to provide you with all the necessary details to ensure you make an informed decision about whether its the right course for you.
What payment options are available?
Mydra offers multiple payment methods for your convenience. You can choose to pay upfront with a card or bank transfer, utilize your Retribución Flexible tax credits, or opt for FixPay – our flexible payment plan. FixPay allows you to divide the cost of your course into up to 20 manageable monthly installments. For detailed Terms & Conditions, please click here.
How does Mydra vet top courses?
Our vetting process looks at the quality of the education provider, the qualifications of the instructors, success rates of past students, positive online feedback and other important data points. This ensures that we offer top-tier learning experiences, provided by the best in the field.

Still have questions?

If you can't find the answer you're looking for, chat with your Mydra advisor!