Collectiv 2024 logo

Power BI Training

To maximize Power BI, you have to know how to use it.

Our Power BI Training is an immersive, instructor-led course for enterprise teams who want to expand their skills.

Play Video
Power BI Training

Learn Power BI From the Experts

Power BI is an incredibly robust tool…as long as your team knows how to maximize its capabilities. Most enterprise teams are only scratching the surface when they could be mastering this powerful tool.

Our Power BI experts offer immersive training where we provide a dedicated time and place for your team to level up their skillsets. Collectiv’s hands-on approach allows teams to truly absorb the information, making it easier to learn and to successfully implement Power BI at your organization.

Power BI Training for Any Experience Level

Collectiv offers a variety of Power BI trainings to meet your team where they are at, no matter their experience level.

Foundations Training

1-2 Days

Our Foundations Training is designed for teams that don’t have any Power BI experience. With this training, you will connect your data, bring it into Power Query, transform that data, and then load it into Power BI Desktop so you can start building out visualizations.

Day 1 – Power BI Foundations

  • Discover the building blocks of Power BI – What is Power BI
  • Power BI Platform Breakdown: Power BI Report Server and Power BI Desktop
  • Data sourcing and transformations using Power Query (M)
  • Tabular Data Modeling – loading/linking your data and understanding relationships – DAX – Creating Measures and Calculated Columns for key metrics
  • Power BI visualization best practices

Day 2 – Power BI Foundations

  • Understanding CALCULATE and Time Intelligence DAX functions
  • Security: role level security, managing security roles, and assigning report/role level security
  • Using DAX to build-out measures that formulate the metrics desired
  • Introduction to proper report building process
  • Power BI report design best practices
  • Power BI Service: Collaboration, Sharing, Creating Apps

Advanced Training

1-2 Days

Our Advanced Training is designed for teams that already have experience with Power BI, but want to take a deeper dive into the platform to enhance their skills. These trainings cover topics like data modeling in Power Query, advanced DAX, and visualization best practices.

Power Query

  • Become an expert in Query Modification
  • Learn Advanced Transformations using Power Query
  • Learn advanced M-Language Transformations
  • Learn how to source data efficiently

Data Modeling

  • Learn how to implement advanced modeling techniques Power BI Desktop
  • Enhance knowledge of Table Types in Power BI


  • Learn how to create efficient DAX measures
  • Learn how to improve your analysis with advanced DAX measures


  • Utilize Advanced Data Visualizations in report development
  • Learn how to create Advanced Report Interactions

Customized Training

1-2 Days

Our Customized Training is intended for teams with mixed Power BI experience levels or who want to focus on honing specific skillsets. After an initial consultation to understand your team’s learning opportunities, we adjust our curriculum to better address your needs.

Workshop Training

1-2 Days

Our Workshop Training is a hands-on approach to solving a specific Power BI problem. Attendees bring their reports or dashboards and the instructor provides expert-level support to find the best solution. Workshops are typically combined with the Foundations Training.

Our Power BI trainings are most effective for individuals who already have analysis experience, whether that is in finance, business intelligence, or another field. They may already have experience with Excel or other solutions within the Microsoft data stack, but have not yet had any formal Power BI training.

The Power BI Foundations Training is our most popular training at Collectiv. It’s a two-day or three-day training that teaches attendees how to build a Power BI report from start to finish. Through presentations and working sessions, attendees learn how to build data models, calculations, and visualizations.

Most importantly, every attendee will walk away from the Foundations Training with the ability to implement Power BI in your organization.

While Power BI experience isn’t necessary for the Foundations Training, it’s helpful to have some previous knowledge of data analytics. For the Advanced Training, attendees should have intermediate or advanced Power BI skills.

The Foundations Training covers the basics and best practices of Power BI. This starts with Power Query input and building out your data model, and then moves on to more complex calculations and visualization best practices to create effective and cohesive reports.

The Advanced Training covers more advanced techniques, including data modeling and Power Query, advanced DAX, as well as visualization best practices.

Collectiv’s training programs are designed for a maximum of 15 participants to ensure that our team is able to provide personal attention and support for each of the attendees. If you have more than 15 team members who need training, our team is happy to lead multiple training sessions to help everybody learn.

Power BI Training FAQs