Data Academy Course

Intermediate Power BI: Data Modeling

About this course 

This course is the 2nd in DataSF’s series on PowerBI.  This course will provide a strong foundation in Data Structure and Data Modeling through the tool of PowerBI.  Analyst tasked with getting multiple data sources to “talk” to each other in PowerBI will find this class of use.

While most dashboarding tools, force the user to ‘flatten’ multiple data sources into a single table, PowerBI allows for more robust Data Modeling.  Instead of making a single table, you establish relationships between many tables.  This Data Modeling capability allows for far greater analytical flexibility; allowing you to answer more questions and pose better questions.

However, it is often the case that the data you are using lacks the proper structure for data modeling.  You encounter issues like: you have difficulty getting your charts to work, simple calculations seem inexplicably complex, or you are getting weird results.  This course will also address how to structure your data for modeling.

This course will give analyst a new set of data eyes allowing them to identify and solve common data structure and data modeling issues.

What you’ll learn in this course

  • Data Structure
    • What is ideal data structure for analytics
    • How to recognize a poorly structured dataset
    • How to reshape the data in PowerBI
  • Data Modeling
    • Foundational concepts in data modeling for analytics
    • How to model properly structured data
    • Identify and fix common data modeling challenges
    • Workflow best practice

Course Outline

  • Data Structure - 1.5 hours
  • Mid-Point Exercise - .5 hours
  • Data Modeling - 4 hours
  • Workflow Best Practices - .5 hours

Pre-requisites

This course is best suited for users responsible for creating PowerBI data models that involve multiple datasets.   

Completion of Data Academy’s Intro to PowerBI Course is required.  This course assume a good working knowledge of how PowerBI works.  Heavy use is made of the query editor and familiarity is assumed.  Exceptions at discretion of instructor ([email protected])

Attendees should have made use of PowerBI since taking the Intro to PowerBI Course.  This course is not designed as a refresher course, but as the next stage in training for advanced PowerBI analyst.  Attendees out of practice should refresh their memories via an online course or work through the final exercise again from the Intro Class.

Not everyone who takes the Intro to PowerBI course needs (or should) take this course; it is fast paced and geared for users of PowerBI tasked with complicated Data Modeling scenarios.