Data Shaping and Modeling

Course Overview

The Power BI Data Shaping & Modeling course builds your expertise in transforming and analyzing data for clearer, more impactful reporting. This course explores advanced techniques for data modeling, query optimization, and calculation tools, empowering you to create dynamic visualizations & develop multi-report dashboards tailored for project insights.

Building on intermediate BI knowledge, attendees will leave equipped to deliver meaningful data stories that enhance decision-making and stakeholder communication.

Your insightful dashboards, clearly communicating project status, requirements, and accomplishments, can truly revolutionize your project management process.

Course Duration

In this two day course, live lessons can be delivered in person or remotely. If a hybrid course is desired, recordings will be provided with the addition of a one hour working session and Q&A with an instructor.

If you prefer to use your own environment or data sources, a course customization add-on is required to tailor the content and exercises accordingly ahead of time.

Participants Will Be Trained To

Understand basic Modeling, Power Query, and DAX concepts.
Apply query best practices.
Begin using DAX data analysis and calculation functions.
Become familiar with effective practices for creating visuals and reports.
Develop a multi-report dashboard.

Who Should Attend

Project Managers
Business Analysts
Resource Managers
Team Leads
Data Professionals

This course is targeted towards learners who already possess a good amount of Power BI knowledge and want to gain additional understanding of advanced data techniques.

Course Materials

Course materials include comprehensive digital coursewear, labs, and Q&A opportunities. Attendees may also earn Professional Development Units from PMI.

Course Outline

Data Transformation & Shaping

Power BI Licensing
Data Shaping & Hygiene
Transformation Techniques
Data Joins & Combining

Power BI Service Concepts

Multi-Report Dashboards
Incremental Data Refresh
Row-Level Security

M Language

M Language Basics
Query Folding
Parameters in Power Query
Dataflows

DAX Analysis & Calculations

DAX Basics
CALCULATE Function
Core Functions
Time Intelligence
Measures & Quick Measures
Use Variables in DAX

Data Modeling

Data Modeling Basics
Star Schema Optimization

Visualizations & Reports

Best Practices
Organizing Measures
Sankey Chart, Map, KPI, Timeline
Drill-Down & Drill-Through
Last Refresh Timestamp

Pain Points This Course Corrects!

⚡ My data queries are falling short.

Unlock the potential of the M language to streamline and enhance your data queries for cleaner, more reliable results.

⚡ There’s no story to my data!

Master the techniques behind creating clear, compelling visualizations that transform complex data into meaningful insights and paint a clear picture for your stakeholders.

⚡My dashboards need a visual upgrade.

Discover how to choose and customize the right visuals to create polished, professional reports that captivate your audience. Better visuals gain a better response!

⚡My data analysis feels unreliable!

Gain strategies to troubleshoot and refine your data analysis, ensuring accurate results that drive confident decision-making.

Course Instructors and Accreditation

Our company is made up of Microsoft Certified Professionals. Further, as a Microsoft Solutions Partner company, we have our thumb on the next generation of technology. This course will be taught by an experienced instructor who is an expert in business intelligence and analytics.

Advisicon’s goal is to improve your processes and technologies, thus creating measurable results. For over 30 years, we have successfully helped clients accelerate, adapt, and achieve.