Data Modeling in Power BI | Power BI Tutorial | Data Modeling |

Data Modeling in Power BI | Power BI Tutorial | Data Modeling |
#powerbi #datamodeling #powerbitutorial #powerbidashboard
Book 1:1 Call with me (Career Guidance, Mock Interviews, Resume Review, etc.) - topmate.io/data_tutorials
For Important Data Analyst Materials and Other Resources - topmate.io/data_tutorials
Data modeling in Power BI is a crucial step in creating effective and insightful reports and dashboards. Power BI provides a robust set of tools and features to help users build a well-structured data model, which forms the foundation of their data analysis.
⭐Data set download - drive.google.com/drive/folder...
📱 Follow me on LinkedIn - / swapnjeet-s-58a673273
📱Follow me on Facebook - profile.php?...
⭐What will you learn
How to Create Data Model for Real time Data Tables
Fact and Dimension Table
Ways to Create Relationship in Power BI
How to identify Tables with Foreign and Primary Keys
Cardinalities in Power BI
Active and Inactive Relationships with Example
Star, Snowflake and Galaxy Schemas
Important Points to Remember while creating Data Model
⭐Content
Introduction 00:00
What is Data Modeling 03:26
Data Tables 05:50
Importing Data in Power Bi 08:10
Arranging Data Tables 11:35
Fact and Dimension Table 16:28
How to Identify Fact and Dimension Table (Primary/ Foreign Keys) 24:47
Purpose of Data Modeling 30:30
Creating Data Model 33:35
Cardinalities in Power Bi 36:10
Active and Inactive Relationship 40:46
Star Schema / Snowflake Schema / Galaxy Schema 47:02
Important Points While Creating Data Model 49:40
Outro 53:10
✅Data Modelling - • Data Modeling in Power...
✅Data Cleaning - • Data Cleaning in Power...
✅Data Analyst Portfolio Projects - • SQL & Excel Portfolio ...
✅Power BI Projects - • Power BI Dashboard fro...
✅Tableau Projects - • Tableau Dashboard from...
✅Excel Projects - • Dynamic Excel Dashboar...
✅SQL Projects - • Data Analysis SQL Proj...
✅Power BI Interview Questions with Answers - • Power BI Scenario base...
✅Tableau Interview Questions with Answers - • Tableau Scenario Based...
Related keywords:
power bi,power bi data modeling,power bi tutorial,power bi tutorial for beginners,data modeling in power bi,data modeling tutorial,data modeling,power bi desktop,power bi training,power bi data modeling best practices,power bi data modeling training,what is data modeling in power bi,power bi data modelling tutorial,data modelling in power bi,power bi data model tutorial,learn power bi,power bi for beginners,power bi desktop tutorial for beginners,data model,
power bi tutorial ,power bi desktop tutorial ,power bi tutorial for beginners ,power bi desktop ,power bi dashboard ,power bi training ,power bi demo ,power bi for beginners ,power bi dashboard tutorial ,power bi tutorial for beginners excel ,power bi ,tutorial ,desktop ,dashboard ,excel ,microsoft excel ,power bi vs tableau ,tableau vs power bi ,mspowerbi ,Power BI Pro ,PowerBIPro , swapnjeet, Microsoft PowerBI, Microsoft Power BI, PowerBI, Power BI, PowerBI Tutorial, Power BI Tutorial, PowerBI Dashboard, Tableau, tableau dashboard, tableau tutorial, SQL, SQL project
data analyst project,
data analyst project for beginners,
data analyst portfolio project,
data analysis project,
data analyst projects for resume,
data science project,
data analyst excel project,
excel tutorial,
excel tutorial for beginners,
end to end project for data analyst,
excel project for data analyst,
excel project,
report in excel,
dashboard in excel,
data analyst portfolio project
data analyst project
data analysis project
data analyst projects for resume
data analyst sql project
end to end project for data analyst

[@millar2255]

Excellent explanation 🎉🎉🎉

[@DatawithHimanshu]

Awesome contents

[@techzland1996]

Excellent explanation

[@SORWARALAM-vw4wg]

Very clear and completely understandable. Hoping to receive more videos. Thank you so much.

[@sivamani2900]

awsm

[@user-dz2xl4od7r]

Excellent video. Very rich and comprehensive presentation in Power BI Data Modeling. Thanks a lot

[@rishikalpamukherjee1339]

One of the best KZbin channel I got covering PowerBI SQL

[@user-xz8ke9ur8s]

Thank you for very clear explanation

[@Ravisankar-qz3lx]

Thanks for this video

[@fatamajohora5497]

Best video of Data Modelling

[@RajeshKumar-qk6he]

Keep going bro you're really awesome and very clear and understandable. Great Thanks 👍

[@chaitukumar61]

Thank you for making this video, a lot of questions have been answered.

[@blazesoulgamingyt6192]

your videos are very great..thankyou for making such informative video....

[@uthpalabitra7855]

This single video is enough to understand the concept of Data Modeling deeply. Thanks for your efforts.

[@spiritwithtruths1996]

i have watched many vedios and with lot of confusion found your vedio. the explnation about fact table and dimension table cleared all my doubts in one go. please do more detailed vedios thank you

[@user-hz8bf1mr8x]

Amazing amount of information within a short span, very clear and crisp

[@namratavala3947]

Hey, thanks for creating such great content, with such clarity and easy explanations!! Had all my doubts cleared and learnt something additional as well :)

[@anz672]

Very useful for beginners

[@user-jt9ev1nn5p]

Awesome!

[@emilyamalkin4367]

All your presentations are clear, easy to understand, well paced and aesthetically pleasing. Also, I really like how you explain every requirement and every step of your logic so nothing is overlooked or unclear. You are doing a great job in helping to learn so many important concepts! 👍🏻👍🏻👍🏻 liked and subscribed ❤

[@devendruraj4705]

Thanks for all this information.

[@Amir-yx8ug]

Awesome. felt authentic. My request is pls create a dashboard for 5-10 years of any data and analyze with interactive dashboard.

[@joeltarazonr]

Thanks for another great and straight explanation of Power BI aspect

[@infosphere1998]

Thanks for such videos where we are able to learn withour any cost.

[@anjusharajan161]

the best

[@dheerajnamdeobalpande5464]

Very nicely explained.....👏

[@reddamswathi8049]

Bro ur explanation is really amazing u can do more vedios on real time senario based questions that will help to everyone thanks for advance

[@ektarawat5797]

Thanks, finally found a really good tutorial 😊

[@sonaliowhal5854]

watched first vedio but understood each and every point nice. Thanks for your efforts.

[@user-eh7oe9ng4z]

Very useful

[@user-qz5yq3si9s]

An amazing amount of information and a very clear explanation. Exceptional talent

[@datatutorials1]

Glad it helped!

[@inderpanda1]

2/Mar - well explained 👍👍

[@TheAnitha00]

very useful

[@abrahamvincent6272]

Thank you sir!! It's really Helpful to understand Data modelling Concepts in Detailed.I have subscribed Your Channel,Keep Educating us and Hatt'soff for ur Efforts!!

[@perfectionist6624]

Bro your explanation is awesome. Please make a full video on power bi DAX...

[@user-qt5fo7qr4o]

Thanks a lot

[@user-vu7ec7su6i]

Bro please upload more power BI tutorials ❤️

[@sapnathakur4122]

going through all your videos one by one, its clearing my concepts. thanks alot for providing quality content that too for free.

[@amanahmed6057]

be focused in classroom 😂

[@ramprakashtripathi643]

Really helped to understand in depth concept with root. thankyou.

[@karanahuja7321]

Well explained

[@Mr.Oliveira502]

Nice video!

[@shamimahmed6640]

Thanks for your efforts

[@luckysitap9429]

Thanks for making this vdo ,i see you have taken lots of effort to making this vdo. I have subscribed ur channel. Make more useful vdo like this.❤❤

[@amolmane8747]

Nicely explained, keep up the good work 👍

[@shielamuzdaliffa]

Well explained. Thank you for your effort! Please make a dashboard with this dataset as the continuation of this video🙏🏻

[@SANTOSHKUMAR-dj3zw]

Nicely explained

[@diansiahaan7375]

very good and helpful presentations. Thank you so much

[@datatutorials1]

Glad it was helpful!

[@satyabobby6248]

No words to say ...Thnak you very much for your efforts.

[@datatutorials1]

Thanks and welcome

[@vaibhavkataria8512]

Thanks 🙏

[@Resh_aadil]

Thanks & it was great clarity in hearing this😊😊😊

[@datatutorials1]

Glad it was helpful!

[@smithydas5223]

What a wonderful explanation 👏 Thank you so much . u r doing a great job ☺️ continue doing it 👏👏 each and every video of yours is a masterpiece 💓

[@datatutorials1]

Thanks for the kind words 😊

[@adityawasankar7929]

Thank you for this video, please make make more videos on power bi but same topic wise.

[@datatutorials1]

Sure I will

[@prasanthnair9979]

Well explained Bro...super

[@datatutorials1]

Thank you so much 🙂

[@osoriomatucurane9511]

Bravo. Awesome tutorial on data modelling in PBI. Concise and crystal clear. I wish you had a context evaluation tutorial at the very same level of detail and clarity. Keep it Up, Sir!

[@datatutorials1]

Thanks for the comment

[@usamalateef4765]

Great Bro❤

[@datatutorials1]

Thanks 🔥

[@sunnyonyemeziem3433]

Thank you for this video, i love your work. Can you do End-to-End video on Power BI including visualization.

[@suchithrarangapuram4694]

its good for me to listening your videos pls try to post the msbi videos

[@vijayraj3902]

Do one video on power query editor data cleaning, if possible to yu, your video's are amazing 😊👍

[@lakshitagaba1104]

Itne videos dekh li but smjh only apka aya 🙌

[@datatutorials1]

Glad you liked

[@RajKumar-bl2pk]

Hi, well explanation, could you create a video for row level and other securities in Power BI. Thanks!

[@dxtapatap6542]

😊

[@awoyadeolatokunbo3691]

Thank you for this video. I have learned a lot about Data Modelling. Well explained. Please can i get the power point slide

[@ce13_piyushprajapati40]

Sir i request you to please make one video of circular dependancy error example and how to resolve that. Please sir...

[@mddanishkhan1301]

Please upload the lecture of DAX function

[@mrbartuss1]

Could you please make a video on how to deal with one large flat table? Unfortunately that's what I always get at my work

[@anubhavghildiyal7678]

Hi! Thanks for the video! I had a couple of doubts 1. Can there be multiple fact tables when doing any analysis? 2. In this example, why can’t reviews/ payments be fact tables, these are also populated almost daily, new reviews/ payments keep coming in. Thanks!

[@SharifulAlam-]

please make videos on dax measure

[@shivrajsunthanure1652]

Plz can u make one detailed video on incremental refresh

[@mukundkumar8022]

please make video on DAX function.

[@latesttrendsandtechnologie5849]

Nice Explained and tutorial, One request can you make one dashboard where we can learn A to Z Power BI Dax details?

[@datatutorials1]

Yes, sure

[@KS-jh4fr]

Please make a video on ms office copilot for hr use

[@praveenm4319]

May i get the PPT that u used in this video? Will be more helpful. If no. Its Fine. Thanks for sharing in the video. ❤

[@sakshinaik05]

Plz bring video's on schedule refresh,rls

[@vishwajeetghonmode7202]

Sir please give me solution, I have to fact table , how to filter data in both table alternatively , in the data two dates 1 is dos date and another is pros date. How to create relationship in between two tables.

[@shwetakharat-wk2kq]

Sir please create 3-4 videos on sql project from scratch with basic to advance query and also with database designing as you have created many video on powerBI, excel .Please create for sql project from scratch

[@datatutorials1]

As soon as possible

[@alikhan-zz5jc]

well explained however you didn't explain how to download the final outcome to our report with explanation in order to complete our task for presentation.

[@oba_idan]

The columns order_delivered_carrier_date, order_delivered_customer_date & order_estimated_delivery_date have their datatypes and format as "Text". I attempted to change it to "Date/Time" as shown in your demonstration between 10:05 and 10:10, but it kept returning some columns as error. The columns were also initially labelled column1, column2, column3, column4, column5. I was able to change this to the right column labels. but the datatype modification returned error some rows. kindly assist with this

[@gauravgupta2148]

Hi I have an work on the same thing for my organisation con we connect.

[@vishwassharma3312]

Sir. Is that content enough to Justify 2 years of experience in. Power bi.

[@MrSaraf-qz7bc]

Sir please suggest some good laptops in 60k budget for data analytics course as i am going to work on python,R ,SQL and power bi etc.

[@saurabhwalde9158]

Hp pavilion is the best with these range

[@Chetan_15]

Dimension table is know as Master table please check once Fact table definition

[@datatutorials1]

Dimension tables store the information of fact table and master table provides info of business as a whole

[@skillify9021]

Can beginner start with this video directly to learn power bi? I know only sql.. Kindly reply me. Fast

[@sureshsonti8097]

Hello, is the order_date format correct in order_dataset file. Because I am not able to convert the column to date column. I am getting error

[@datatutorials1]

See pinned comment

[@datatutorials1]

Check your csv file settings on excel

[@zaidnawali6543]

is there any other way select the data because this is very long process of selecting each and every single file

[@praveenm4319]

Once we creating a relationship btw two tables, we can access every columns from both tables right? Then adding another inactive relationship is for what the reason? I cant get it as i am a toddler in powerbi. Can anyone clarify this? Thanks.

[@datatutorials1]

There are scenarios where you need to join table with different keys, and power bi can have only one active relationship. The other can be made active using dax calculation. But to make it active it should be made as a inactive relationship in model first

[@praveenm4319]

@@datatutorials1 Rectified. Thank You❤️

[@pravallikamuddana1128]

Sir,why you have given relationship for review_id and order_id it doesn't have same column names..

[@datatutorials1]

The relationship is not always decided by the name of column, it depends on the value of that field

[@dhnguyen68]

A new customer may not have any order, thus can we have 0 to many relationship ?

[@artil1]

It is still one to many. Relatioship refers to tables, not to particular fields. Some customers can have no orders, some only one, some can have many orders. The thing is each customer appears only once in customers table and MIGHT appear more times in orders table.

[@muskankalra6546]

😃😃😃😃😃😃😃

[@shahirajlakade7921]

Sir whenever we load dataset first and foremost thing is that we have to create data modelling and then clean data know..is it right sir?? Thanks for your constant effort sir❤

[@datatutorials1]

First clean all tables then create model

[@shahirajlakade7921]

@@datatutorials1 ok sir..Thanks for reply

[@osoriomatucurane9511]

ETL. E for extract data from the sources (web scrapping, database,....) T for transform (clean, tidying, manipulate, prepare the data) L for load data

[@vishalmane3139]

kindly create dim and fact manually, nt already prepared

[@datatutorials1]

In realtime everything you have will be in tables, you do not do any manual entry

[@vishalmane3139]

@@datatutorials1 what if there r no common columns between two tables then hw to build relationships between them?

[@datatutorials1]

@vishalmane3139 there is always an entity relationship between two tables, if not we create it as per requirements.

[@vishalmane3139]

@@datatutorials1 bt hw can we ?