This advanced Power BI course is designed for people who have some experience building reports, but want to better understand how Power BI handles data behind the scenes. You’ll learn to build better data models (using the correct relationships and filter flow) to make reports more reliable by ensuring totals, filters, and calculations behave the way you want.
In this training, you will build data models using hierarchies, custom sort orders, and reusable date tables that support both fiscal and calendar year reporting. You will deepen your DAX knowledge by working with parameters, inactive relationships, and context-aware calculations, while learning when logic belongs in the data model versus in a DAX measure. You will also implement Row-Level Security (RLS), including dynamic security based on the logged-in user, to control data access in shared reports.
You will learn how to connect Power BI to databases, understand Import versus DirectQuery tradeoffs, and improve performance as you learn about query folding. By the end of the course, you will be better prepared to troubleshoot common modeling issues, publish secure datasets, and apply best practices that align with Microsoft’s PL-300 Power BI Data Analyst Associate certification.
Students should have Power BI knowledge equivalent to our Power BI Bootcamp.
Learn online at your own pace with video training and live support from our instructors. If you purchase the self-paced option, you can attend the live course for free within one year.
Receive instruction from subject‑matter experts who bring proven government experience.
Courses that are regularly updated based on feedback and industry developments, ensuring versions are mapped to federal competencies.
The instructor was wonderful and so knowledgeable. The course materials were extremely relevant to what my job is. I feel like I can be better because of this class.
— 2025 student
Directly addressing the day-to-day challenges of federal employees.
Your trusted training partner, equipping public service professionals with the skills and knowledge to excel in their roles and drive meaningful impact.
Attend this course live online or as self-paced training. Engage with expert instructors, ask questions, and get feedback on your exercises and projects.
Get the same interactivity and access to the instructor as in-person students. There are no extra fees and we’ll work with you to ensure your remote setup is perfect.
Learn at your own pace with pre-recorded video lessons and hands-on exercises. Work through the material on your schedule with access to course content and resources.
Upon completion of this course, you’ll receive an official certificate testifying to your mastery of the curriculum. We’ll send you a link where you can download your certificate, share it online with your friends, post it to your professional network on LinkedIn, and view all your earned certificates. Congratulations on your achievement!
Shareable on
We offer a single free retake of the class within a year.
You can also access recordings of each session in your student portal within one business day of the session’s end. Recordings are available for one month after the session.
Since 1921, Graduate School USA has partnered with over 125 federal agencies and trained more than one million federal employees. Led by instructors with deep, real-world knowledge of federal regulations, policies, and practices, our private group programs are practical, mission-driven, and tailored to your agency’s objectives. We offer expertise across key federal domains—including human resources, financial management, acquisition and contracting, leadership, and more—to deliver training where and how your team needs it.
Complete this form and we’ll get back to you within 1 business hour.
