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
drive.google.c...
#PowerBI #PowerBIDesktop #PowerBITutorials
✉ Business Queries / Analytics Consulting ✉ : [e-mail]
💬 For Learners Post queries and Interact 💬 : t.me/analyticsw...
Complete Playlists
Power BI Tutorials - Complete Playlist 📚📖 • How to do Power BI Ins...
Power BI Desktop Tips and Tricks 📚📖 • How to Remove Top N ro...
Power BI DAX - Complete Playlist 📚📖 • What is DAX in Power B...
Power BI Services Playlist 📚📖 • Introduction to Power ...
Power BI Project Dashboards - Power BI Realtime Projects - Playlist 📚📖 • Loan disbursement Anal...
Data Warehouse Tutorials 📚📖 • Introduction | Data Wa...
SQL Full Course | SQL Tutorial For Beginners 📚📖 • Learn SQL Complete | C...
SSAS Tutorials - SQL Server Analysis Services 📚📖 • Introduction to SQL Se...
SSIS Tutorials - SQL Server Integration Services 📚📖 • Introduction to SQL Se...
Power BI Interview Topics 📚📖 • What to Expect in Powe...
MSBI (SSIS,SSAS,SSRS) Interview Topics 📚📖 • What to Expect in MSBI...
Excel for Data Analysis 📚📖 • Analytics with Nags Yo...
Power BI + R 📚📖 • Analytics with Nags Yo...
Azure for Analytics - Complete Tutorials 📚📖 • Analytics with Nags Yo...
Catch with Nags 📚📖 • Catch Up With Nags - I...
Nags Checklist 📚📖 • 5 Things to Consider w...
Visuals with Nags 📚📖 • Visuals With Nags - Intro

[@liveeatwork3601]

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.

[@AnalyticswithNags]

Thanks for your feedback. Keep learning share this channel with friends and colleagues.

[@bezawitarage1686]

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

[@AnalyticswithNags]

Yes. Keep learning. Thanks for your words

[@alphaandromeo]

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

[@AnalyticswithNags]

Thanks keep learning. Talk about this channel if you are in linkedin

[@36-inshadamani82]

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.

[@rishadkt837]

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

[@AnalyticswithNags]

Yes

[@jagadishreddy5693]

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.

[@AnalyticswithNags]

Watch real time Project playlist. In that i covered, how real time projects will be implemented. It is your talent to crack interviews.

[@jagadishreddy5693]

@@AnalyticswithNags sure thank you sir

[@mohdmuzammil3059]

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

[@AnalyticswithNags]

Whatever you do , uncheck or delete in my opinion both have same impact. I will check is there any difference, if so I will make a video soon

[@mohdmuzammil3059]

@@AnalyticswithNags thank you for your time and genuinely learning lot from AWN

[@SUJITMALLICK100]

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 ?

[@AnalyticswithNags]

Watch this kzbin.info/www/bejne/iJDKaaKEg6lng7s

[@priyajuneja178]

Hi @sujit i cant read the reply for your question which Naga did, can you please update the same here? TIA.

[@ojusyummyreceipes7198]

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.

[@AnalyticswithNags]

Already made in Realtime project. kzbin.info/www/bejne/r4jMlICZZ9Vgedk Check it out

[@ojusyummyreceipes7198]

Thank you so much sir...your videos are really helpful.

[@musthakhahammed6535]

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?

[@AnalyticswithNags]

Ofcourse yes..learn schedule refresh in Services playlist

[@jyotidatta2126]

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

[@AnalyticswithNags]

Check this video How to Create Date Table or Date Dimension | Calendar Table in Power BI Tutorial (13/50) kzbin.info/www/bejne/eJ_UpXWufMeiZq8

[@coding7241]

let Query1 = List.Dates( #date(2022,1,1), 730, #duration(1,0,0,0) ), #"Converted to Table" = Table.FromList(Query1, Splitter.SplitByNothing(), null, null, ExtraValues.Error), #"Changed Type" = Table.TransformColumnTypes(#"Converted to Table",{{"Column1", type date}}), #"Renamed Columns" = Table.RenameColumns(#"Changed Type",{{"Column1", "Date"}}), #"Duplicated Column" = Table.DuplicateColumn(#"Renamed Columns", "Date", "Date - Copy"), #"Duplicated Column1" = Table.DuplicateColumn(#"Duplicated Column", "Date - Copy", "Date - Copy - Copy"), #"Duplicated Column2" = Table.DuplicateColumn(#"Duplicated Column1", "Date - Copy - Copy", "Date - Copy - Copy - Copy"), #"Renamed Columns1" = Table.RenameColumns(#"Duplicated Column2",{{"Date - Copy", "Year"}}), #"Extracted Year" = Table.TransformColumns(#"Renamed Columns1",{{"Year", Date.Year, Int64.Type}}), #"Calculated Week of Year" = Table.TransformColumns(#"Extracted Year",{{"Date - Copy - Copy", Date.WeekOfYear, Int64.Type}}), #"Extracted Day Name" = Table.TransformColumns(#"Calculated Week of Year", {{"Date - Copy - Copy - Copy", each Date.DayOfWeekName(_), type text}}), #"Renamed Columns2" = Table.RenameColumns(#"Extracted Day Name",{{"Date - Copy - Copy - Copy", "day"}, {"Date - Copy - Copy", "week"}}) in #"Renamed Columns2"

[@saisrihari3992]

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

[@AnalyticswithNags]

No limit

[@shantanutiwari7486]

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

[@AnalyticswithNags]

Check the date dimension video from the channel

[@KetkiShitut]

Nice video

[@AnalyticswithNags]

Thanks keep learning

[@sget-motive-wid-me4691]

Good explanation

[@AnalyticswithNags]

You are welcome

[@abdullahalmamun923]

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

[@AnalyticswithNags]

If you have deleted column in power query then you can remove that step

[@arrahmanmusicaljourney6186]

Great

[@AnalyticswithNags]

Thanks

[@oladman9058]

Good job

[@AnalyticswithNags]

Thanks keep learning share this channel with friends

[@shrikantlandage7305]

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?

[@AnalyticswithNags]

Data modelling is what Modelling in Power BI. You need to finally design star schema (Facts / Dimension) or Snow flake schema. Types of dimension like Slowly changing Dimension. Different Fact Tables. These topics are covered in Data warehousing playlist. Learn those things as well. More over As I repeatedly saying Power BI alone is not enough. SQL+ SSIS+ DW+POWER BI these skills only will land you in a Job. Watch my What to Expect playlist in Power BI

[@shrikantlandage7305]

@@AnalyticswithNags Thanks Sir for the Advice

[@sarsatheeshreddy3341]

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

[@AnalyticswithNags]

You have a value in a column which is having text. You cant convert to float or numeric. Fix that value first then import.

[@sohansinghsikarwar]

Thanks

[@AnalyticswithNags]

Welcome

[@katamrakesh1186]

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

[@AnalyticswithNags]

Sorry to hear that, Start from the beginners videos in the playlist. Not with advanced videos.

[@AnalyticswithNags]

We don't take classes we only do online videos all our contents are available for free in youtube.

[@haribabuk5162]

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

[@AnalyticswithNags]

No trainings. Follow the Real time projects playlist that will help you to understand how projects are handled in organisations

[@beingrishi6450]

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

[@AnalyticswithNags]

kzbin.info/www/bejne/eJ_UpXWufMeiZq8

[@rejeeshmullasseri8317]

Primavera p6 with power bi.please help us as we r working in construction indstry

[@AnalyticswithNags]

Cant understand your query . Please email us, mail id in the desc.

[@Chennaichandrama2181]

Hi sir how to answer the explain modelling in powerbi

[@AnalyticswithNags]

Watch Data warehouse playlist. That will clarify most of the points. You need to implement in power bi

[@bzflowerbee]

What happened? The error message shows up at 6:00. It said "An error occurred. Please try again later..." Thanks anyway.

[@AnalyticswithNags]

I am not sure what was the error

[@sailyraut4959]

Could please provide source file

[@AnalyticswithNags]

Updated the source file link in description

[@sailyraut4959]

@@AnalyticswithNags Thank you

[@aimanrazman]

@@AnalyticswithNags but there is no blocklist table, sir

[@Bangloreblogs]

Why i find all your videos hard to understand Don't know !! Have been watching chandoos and avi with goodly are much better to understand Please work on this

[@AnalyticswithNags]

Everyone have their own style. No point in This is advanced concepts, kids like you won’t understand since you may not know the fundamentals

[@ksrinivas6215]

Good explanation

[@AnalyticswithNags]

Thanks and welcome, Keep learning