Welcome to Mobilarian Forum - Official Symbianize forum.

Join us now to get access to all our features. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, and so, so much more. It's also quick and totally free, so what are you waiting for?

Mastering Data Modeling in Power BI

TOP 110


Alpha and Omega
Jan 21, 2021
Reaction score
3 years of service

Published 05/2022
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English + srt | Duration: 24 lectures (1h 22m) | Size: 635.5 MB

Learn Data Modeling in Power BI with mastering in all the concepts
What you'll learn
What is Data Modeling? Why do we need it?
What is a schema? What are different kinds of Schemas in a Data Model?
What are Facts & Dimensions?
What are different kinds of relationships in a data model? How to manage them?
How to do data modeling in Power BI?
Students only need a basic understanding of data management concepts and constructs such as relational database tables and how different pieces of data logically relate to one another. The course content builds on these rudimentary ideas; no other prerequisites are needed.
Basic understanding of Power BI
If you are a current or aspiring Data professional in search of sound, practical techniques to analyze and model data as part of the data modeling for data analysis or data visualization or data database/DWH design, this is the course for you.
In this course, you'll from basic concepts of data modeling to doing data modeling in Power BI using AdventureWorks DW. Not only that, you'll also get quiz, .pbix file, questions, resource material as well as PDF of the video course.
I have used my own experience in the data field to design this course. I have kept this course very precise, and to the point so that within an hour you can grasp all the necessary knowledge. I am sure after completing this course, your concepts regarding data modeling would be clear, and you can start designing your very first data model or can improve the existing one.
In this course, I take you from the fundamentals and concepts of data modeling all the way and techniques that you'll need to build data models in your organization. You'll find lab/workshop that clearly demonstrate the key concepts and techniques covered throughout the course. By the end of the course, you'll be all set to not only put these principles to work, but also to make the key data modeling and design decisions required by the "art" of data modeling that transcend the nuts-and-bolts techniques and design patterns.
Specifically, this course will cover
Part 1: Data Modelling Overview
V2: Introduction to Data Modelling: What is Data Modelling? Why Data Modelling?
What is a data model? What are different Data Modelling Techniques?
Data Modelling Techniques
Why use a data model?
Types of Data Models & their Characteristics
Advantages & Disadvantages of a data model
Part 2: Fact Vs Dimensions
Primary Vs Foreign Key
What is a fact table
What is a dimension table
Key differences between Facts & Dimensions
Types of Facts & Dimensions
Part 3: Relationships in a Data Model
What is a relationship in a db?
ypes of relationships
How to prevent duplication?
Part 4: Start Schema Vs Snowflake Schema
What is a DB Schema?
What is multidimensional schema
Types of DWH schema
Star Schema & its characteristics
Snowflake Schema & its characteristics
Difference between Start & Snowflake schemas
Galaxy Schema & it's characteristics
Part 5: Design a data model in Power BI
Lab - 20 Mints
Resource Material
Questions Answers file
Data modeling is both an art and a science. While we have developed a large body of best practices over the years, we still have to make this-or-that types of decisions throughout our data modeling work, often based on deep experience rather than specific rules. That's what I've instilled into this course: the fusion of data modeling art and science that you can bring to your organization and your own work. So come join me on this journey through the world of data modeling!
Who this course is for
business analyst, data engineer, or database designer, currently with little or no exposure to or experience with data modeling, who desires to build a personal toolbox of data modeling best practices and techniques.
After completing this course, you will be ready to begin working on real-world data modeling projects, either with expanded responsibilities as part of an existing role or to find a new position involving data modeling. Example positions include database designer, conceptual data modeler, database engineer, and business analyst with an emphasis on data requirements.
Specially, if you are working on Power BI, then this would be a milestone towards your career journey.
Please, Log in or Register to view URLs content!

Recommend Download Link Hight Speed | Please Say Thanks Keep Topic Live
Links are Interchangeable - No Password - Single Extraction
K 0

KatzSec DevOps

Alpha and Omega
Jan 17, 2022
Reaction score
2 years of service
TOP salamat sa pag contribute. Next time always upload your files sa
Please, Log in or Register to view URLs content!
para siguradong di ma dedeadlink. Let's keep on sharing to keep our community running for good. This community is built for you and everyone to share freely. Let's invite more contributors para mabalik natin sigla ng Mobilarian at tuloy ang puyatan. :)
Top Bottom