Introduction to Data Modelling in Power BI

Published Jun 22 2022 05:44 AM 1,953 Views
Microsoft

modeling-view_06.png

 

Data Modelling and DAX

When we were curating the Data Analysis curriculum, we asked ourselves what most people spent months struggling to learn in data analysis using Power BI, then decide to bring experts and industry leaders that can break down these concepts in an hour. That’s massive transformation.


We all started Data Modelling from Nursey School --- Ahmed Oyelowo (MVP, MCT. AFM). I really don’t have anything to add to this rather than being so surprised that it is actually true.
This just made it clear that the topic of Data Modelling in Power BI was demystified as if the audience are Nursery school students and every illustrations, examples, scenarios cited were great, relevant, and relatable.

 

I wouldn’t be breaking down this session for you, you need to watch this for yourself. The comments were great and you will agree even from the very first minute into the event.

 

Get The Dataset Here

Use this link to get the datasets used in today's session https://aka.ms/30DLDATGitHubRepo The folder name is "Data Modelling Dataset"

 

 

Watch the Session Here

 

 

 

Assignment

  1. Download the Dataset here  
  2. Implement what was taught in the session using the Data provided  
  3. Attempt creating a reports for the dataset
  4. Document Your Project on GitHub and share it on LinkedIn and Twitter with the hashtag #NG30DaysOfLearning #30DaysOfLearning

 

Additional Resources

 

 

%3CLINGO-SUB%20id%3D%22lingo-sub-3537583%22%20slang%3D%22en-US%22%3EIntroduction%20to%20Data%20Modelling%20in%20Power%20BI%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3537583%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22modeling-view_06.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22modeling-view_06.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F382664iBD2B0A08923865E8%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22modeling-view_06.png%22%20alt%3D%22modeling-view_06.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CH2%20id%3D%22toc-hId-476041738%22%20id%3D%22toc-hId-476044526%22%3EData%20Modelling%20and%20DAX%3C%2FH2%3E%0A%3CP%3EWhen%20we%20were%20curating%20the%20Data%20Analysis%20curriculum%2C%20we%20asked%20ourselves%20what%20most%20people%20spent%20months%20struggling%20to%20learn%20in%20data%20analysis%20using%20Power%20BI%2C%20then%20decide%20to%20bring%20experts%20and%20industry%20leaders%20that%20can%20break%20down%20these%20concepts%20in%20an%20hour.%20That%E2%80%99s%20massive%20transformation.%3C%2FP%3E%0A%3CP%3E%3CBR%20%2F%3EWe%20all%20started%20Data%20Modelling%20from%20Nursey%20School%20---%20Ahmed%20Oyelowo%20(MVP%2C%20MCT.%20AFM).%20I%20really%20don%E2%80%99t%20have%20anything%20to%20add%20to%20this%20rather%20than%20being%20so%20surprised%20that%20it%20is%20actually%20true.%20%3CBR%20%2F%3EThis%20just%20made%20it%20clear%20that%20the%20topic%20of%20Data%20Modelling%20in%20Power%20BI%20was%20demystified%20as%20if%20the%20audience%20are%20Nursery%20school%20students%20and%20every%20illustrations%2C%20examples%2C%20scenarios%20cited%20were%20great%2C%20relevant%2C%20and%20relatable.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI%20wouldn%E2%80%99t%20be%20breaking%20down%20this%20session%20for%20you%2C%20you%20need%20to%20watch%20this%20for%20yourself.%20The%20comments%20were%20great%20and%20you%20will%20agree%20even%20from%20the%20very%20first%20minute%20into%20the%20event.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CH2%20id%3D%22toc-hId--1332272970%22%20id%3D%22toc-hId--1331412725%22%20id%3D%22toc-hId--1331409937%22%3EGet%20The%20Dataset%20Here%3C%2FH2%3E%0A%3CP%3EUse%20this%20link%20to%20get%20the%20datasets%20used%20in%20today's%20session%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Faka.ms%2F30DLDATGitHubRepo%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Faka.ms%2F30DLDATGitHubRepo%3C%2FA%3E%26nbsp%3BThe%20folder%20name%20is%20%3CEM%3E%22Data%20Modelling%20Dataset%22%3C%2FEM%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CH2%20id%3D%22toc-hId-1156100108%22%20id%3D%22toc-hId-1156102896%22%3EWatch%20the%20Session%20Here%3C%2FH2%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3C%2FP%3E%3CDIV%20class%3D%22video-embed-center%20video-embed%22%3E%3CIFRAME%20class%3D%22embedly-embed%22%20src%3D%22https%3A%2F%2Fcdn.embedly.com%2Fwidgets%2Fmedia.html%3Fsrc%3Dhttps%253A%252F%252Fwww.youtube.com%252Fembed%252FjGHkFZxPyX8%253Ffeature%253Doembed%26amp%3Bdisplay_name%3DYouTube%26amp%3Burl%3Dhttps%253A%252F%252Fwww.youtube.com%252Fwatch%253Fv%253DjGHkFZxPyX8%26amp%3Bimage%3Dhttps%253A%252F%252Fi.ytimg.com%252Fvi%252FjGHkFZxPyX8%252Fhqdefault.jpg%26amp%3Bkey%3Dfad07bfa4bd747d3bdea27e17b533c0e%26amp%3Btype%3Dtext%252Fhtml%26amp%3Bschema%3Dyoutube%22%20width%3D%22600%22%20height%3D%22337%22%20scrolling%3D%22no%22%20title%3D%22Data%20Modelling%20%2B%20Exploring%20the%20world%20of%20DAX%3A%20Data%20Analyst%20Track%22%20frameborder%3D%220%22%20allow%3D%22autoplay%3B%20fullscreen%22%20allowfullscreen%3D%22true%22%3E%3C%2FIFRAME%3E%3C%2FDIV%3E%3CP%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CH2%20id%3D%22toc-hId--651537129%22%20id%3D%22toc-hId--651354355%22%20id%3D%22toc-hId--651351567%22%3EAssignment%3C%2FH2%3E%0A%3COL%3E%0A%3CLI%3E%3CEM%3EDownload%20the%20Dataset%20here%26nbsp%3B%26nbsp%3B%3C%2FEM%3E%3C%2FLI%3E%0A%3CLI%3E%3CEM%3EImplement%20what%20was%20taught%20in%20the%20session%20using%20the%20Data%20provided%26nbsp%3B%26nbsp%3B%3C%2FEM%3E%3C%2FLI%3E%0A%3CLI%3E%3CEM%3EAttempt%20creating%20a%20reports%20for%20the%20dataset%3C%2FEM%3E%3C%2FLI%3E%0A%3CLI%3E%3CEM%3EDocument%20Your%20Project%20on%20GitHub%20and%20share%20it%20on%20LinkedIn%20and%20Twitter%20with%20the%20hashtag%20%23NG30DaysOfLearning%20%2330DaysOfLearning%3C%2FEM%3E%3C%2FLI%3E%0A%3C%2FOL%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CH2%20id%3D%22toc-hId-1252420149%22%20id%3D%22toc-hId-1836158478%22%20id%3D%22toc-hId-1836161266%22%3EAdditional%20Resources%3C%2FH2%3E%0A%3CUL%3E%0A%3CLI%3EIf%20you%20are%20just%20joining%2C%20check%20the%20onboarding%20homepage%3A%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Faka.ms%2F30DLOnboardingRecap%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Faka.ms%2F30DLOnboardingRecap%3C%2FA%3E%26nbsp%3B%3C%2FLI%3E%0A%3CLI%3EFor%2030%20Days%20Calendar%2C%20check%20our%20Landing%20Page%3A%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Faka.ms%2F30DLDATLandingPage%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Faka.ms%2F30DLDATLandingPage%3C%2FA%3E%26nbsp%3B%3C%2FLI%3E%0A%3CLI%3EMicrosoft%20Learn%20for%20Students%3A%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CA%20href%3D%22https%3A%2F%2Faka.ms%2Flearnstudent%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Faka.ms%2Flearnstudent%3C%2FA%3E%26nbsp%3B%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-3537583%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22Slide19.PNG%22%20style%3D%22width%3A%20999px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Slide19.PNG%22%20style%3D%22width%3A%20999px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F383719iA4874C0C87D85BD9%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Slide19.PNG%22%20alt%3D%22Slide19.PNG%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%3EThis%20is%20the%20best%20beginner's%20content%20guide%20to%20understand%20data%20Modelling%20and%20DAX%20in%20Microsoft%20Power%20BI.%20Every%20concept%20simplified%20with%20relevant%20and%20relatable%20examples%20and%20scenarios%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3537583%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3Eacademic%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EData%20Analytics%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EDAX%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Epower%20bi%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Co-Authors
Version history
Last update:
‎Jun 26 2022 12:56 PM
Updated by: