Data Modeling in Power BI | Power BI Tutorial | Data Modeling |
Vložit
- čas přidán 17. 06. 2024
- 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
Thanks for another great and straight explanation of Power BI aspect
Very clear and completely understandable. Hoping to receive more videos. Thank you so much.
Amazing amount of information within a short span, very clear and crisp
This single video is enough to understand the concept of Data Modeling deeply. Thanks for your efforts.
watched first vedio but understood each and every point nice. Thanks for your efforts.
Thanks for such videos where we are able to learn withour any cost.
Excellent video. Very rich and comprehensive presentation in Power BI Data Modeling. Thanks a lot
One of the best CZcams channel I got covering PowerBI SQL
Keep going bro you're really awesome and very clear and understandable. Great Thanks 👍
Thank you for making this video, a lot of questions have been answered.
Awesome. felt authentic. My request is pls create a dashboard for 5-10 years of any data and analyze with interactive dashboard.
Really helped to understand in depth concept with root. thankyou.
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 ❤
Best video of Data Modelling
Thank you for very clear explanation
Very well explained. Thank you very much 👏
Well explained. Thank you for your effort! Please make a dashboard with this dataset as the continuation of this video🙏🏻
Excellent explanation 🎉🎉🎉
Nicely explained, keep up the good work 👍
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
The way you explained things, much appreciated, apart of BI we can learn some soft skill also from you....Thanks and keep making such videos....
Hey, thanks for creating such great content, with such clarity and easy explanations!! Had all my doubts cleared and learnt something additional as well :)
awsm
No words to say ...Thnak you very much for your efforts.
Thanks and welcome
Awesome contents
Thanks for all this information.
An amazing amount of information and a very clear explanation. Exceptional talent
Glad it helped!
your videos are very great..thankyou for making such informative video....
thanks for sharing
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
Very useful for beginners
Thanks, finally found a really good tutorial 😊
very good and helpful presentations. Thank you so much
Glad it was helpful!
Excellent explanation
going through all your videos one by one, its clearing my concepts. thanks alot for providing quality content that too for free.
be focused in classroom 😂
Bro your explanation is awesome.
Please make a full video on power bi DAX...
Very nicely explained.....👏
Thanks for this video
Awesome!
Thank you for this video, i love your work. Can you do End-to-End video on Power BI including visualization.
Bro please upload more power BI tutorials ❤️
Thanks for your efforts
Thanks & it was great clarity in hearing this😊😊😊
Glad it was helpful!
Do one video on power query editor data cleaning, if possible to yu, your video's are amazing 😊👍
yes i need to subscribe your channel ... Contents are too good
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.❤❤
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!
Thanks for the comment
Overall you are best
Nicely explained
Well explained
Nice video!
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 💓
Thanks for the kind words 😊
its good for me to listening your videos pls try to post the msbi videos
Very useful
Well explained Bro...super
Thank you so much 🙂
Thank you for this video, please make make more videos on power bi but same topic wise.
Sure I will
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!!
2/Mar - well explained 👍👍
Thanks 🙏
very useful
Thanks a lot
the best
Hi, well explanation, could you create a video for row level and other securities in Power BI. Thanks!
Itne videos dekh li but smjh only apka aya 🙌
Glad you liked
Great Bro❤
Thanks 🔥
Fact table is Transaction table.
Dim table is Master Table.
Please upload the lecture of DAX function
please make video on DAX function.
Sir i request you to please make one video of circular dependancy error example and how to resolve that. Please sir...
Thank you for this video. I have learned a lot about Data Modelling. Well explained. Please can i get the power point slide
Plz can u make one detailed video on incremental refresh
Please make a video on ms office copilot for hr use
Nice Explained and tutorial, One request can you make one dashboard where we can learn A to Z Power BI Dax details?
Yes, sure
😊
please make videos on dax measure
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!
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
Plz bring video's on schedule refresh,rls
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. ❤
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
As soon as possible
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.
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
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.
Foreign key means row are duplicates
But you also mentioned that data shouldn't be repeated or duplicate before going to modeling
Please give me the answer
Can beginner start with this video directly to learn power bi? I know only sql.. Kindly reply me. Fast
Sir.
Is that content enough to Justify 2 years of experience in. Power bi.
Dimension table is know as Master table please check once Fact table definition
Dimension tables store the information of fact table and master table provides info of business as a whole
is there any other way select the data because this is very long process of selecting each and every single file
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.
Hp pavilion is the best with these range
Hi I have an work on the same thing for my organisation con we connect.
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.
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
@@datatutorials1 Rectified. Thank You❤️
Sir,why you have given relationship for review_id and order_id it doesn't have same column names..
The relationship is not always decided by the name of column, it depends on the value of that field
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
See pinned comment
Check your csv file settings on excel
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❤
First clean all tables then create model
@@datatutorials1 ok sir..Thanks for reply
ETL. E for extract data from the sources (web scrapping, database,....)
T for transform (clean, tidying, manipulate, prepare the data)
L for load data
A new customer may not have any order, thus can we have 0 to many relationship ?
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.
😃😃😃😃😃😃😃
kindly create dim and fact manually, nt already prepared
In realtime everything you have will be in tables, you do not do any manual entry
@@datatutorials1 what if there r no common columns between two tables then hw to build relationships between them?
@vishalmane3139 there is always an entity relationship between two tables, if not we create it as per requirements.
@@datatutorials1 bt hw can we ?