Power BI Modelling - Part 1 | Star Schema | Reduce Model | Date Table | Power BI Tutorial (43/50)

How to Properly Model your Power BI report
Why you need Star Schema
How to Design a Star Schema from a Flat File
How to improve performance by Reducing the Model
How to Create date table what is the significance of it.

Source File

#PowerBI #PowerBIDesktop #PowerBITutorials

Complete Playlists

[liveeatwork]

Woohoo!!! This is pretty awesome I was working on real-time project and my issue was not getting resolved. After implementing this concept the desired output has been achieved. Thank you so much sir. Really helped me this concept.

[bezawitarage]

omg you are eveything for my powerbi knowledge. thanks much sir

[alphaandromeo]

Your videos are very good, the teaching style is very good.

[jagadishreddy]

Sir, please make a video on How to explain the project to the interviewer like
1. how to start
2. do we need to mention any visual names DAX formulas etc.

3.How to conclude.
Will wait for your video.

[rishadkt]

great vid...could've used left anti to filter out blocked people?

[santhoshreddy]

Hi, I am watching your videos in this channel from long back ago.
The concepts are very useful and easy to understand.
May I know, Are you offering any paid courses?

[ojusyummyreceipes]

Hi Sir, one request from my side is please do one project for full MSBI model so that, can get end to end idea of MSBI model. That will really help for beginners to get complete flow of MSBI model.

[-inshadamani]

Thank you so much sir. I have watched all your videos till now and understood the concept. I m beginner of learning just got stuck in one concept. You just duplicate the column and name it as a dim. How the relationship bet these two tables created automatically. For dimdate u have created with the common column. But for that two tables u just duplicated it and how relationship created i dont get that.
I will be thankful for the guidance.

[mohdmuzammil]

Very good explanation
My doubt is can we use choose columns options in power query to remove unnecessary columns instead of removing columns, so that in future if need one of them we can simply check those columns and get ready to use them? Is there any difference impact between using removing and choose columns opt pls reply.
Thank you

[SUJITMALLICK]

Hi Nagendra, thanks for all your wonderful videos, I have a query when we have all the information in a single table we can create the required visuals from the same table itself right? Why we should create fact and dimensions tables ? Is it for performance or something else ?

[musthakhahammed]

Hello sir,
I'm learning a lot from you.
May I ask you one doubt?
in this scenario, if I need to enter new sales records, what I will do?

if I entered new records in the big table, Will Powerbi show it when I refresh?

[saisrihari]

Very good info. What is Data model Size limit in power bi? Please help me on this

[katamrakesh]

HII sir your videos are excellent but, new learners didn't understand because videos are very fast we need your classes and also provide few videos power query editor and modelling detail classes

[shantanutiwari]

sir where to find your power dax query link for date you used in above video

[abdullahalmamun]

Is that possible if yes let me know how, if i want to return one column in FACT table which i have removed during making FACT table. plz sir

[jyotidatta]

From where are we copying the 'date code' from? Can you pls provide it in the description?

[sarsatheeshreddy]

Hi nag,
I am getting data type conversion error from nvarchar to float while importing view from dB may I know the reason.

[haribabuk]

Hello are can you teach power bi developer course full for job requirements

[shrikantlandage]

Sir 3 days ago I was grilled on data modelling topic in an interview...I was searching on net but there was not a proper content.
Sir Data Modelling 101 is sufficient for data modelling to have knowledge of it?

[beingrishi]

11:41 can u share this dimdate code in text format in description