Power BI Pro

Overview

This Intermediate Power BI training course builds on the Power BI Analyst class, teaching the advanced dashboard skills participants need in order to successfully build more sophisticated data visualizations.

During the class, students connect to various data sources, shape and combine data, work with reports, and create and share more sophisticated dashboards.

Attendees gain practical, real-world skills they can immediately use in their current projects. 

This course can be taught over 3 days for the less experienced users or accelerated over 2 days for the more advanced users. 

powerbi 2

Overview

powerbi 2

Overview

This Intermediate Power BI training course builds on the Power BI Analyst class, teaching the advanced dashboard skills participants need in order to successfully build more sophisticated data visualizations.

During the class, students connect to various data sources, shape and combine data, work with reports, and create and share more sophisticated dashboards.

Attendees gain practical, real-world skills they can immediately use in their current projects. 

This course can be taught over 3 days for the less experienced users or accelerated over 2 days for the more advanced users. 

Duration

2 days

Prerequisites

None

Training Materials

Manual and supporting materials included

Software Requirements

Power BI Desktop, Internet Access

Course Objectives

Untitled design (7)
  • Plan Power BI Projects with organizational goals in mind
  • Incorporate DAX for deeper analysis
  • Model and transform data
  • Create a Deployment Strategy
  • Integrate with Azure DevOps for CI/CD
  • Determine and apply role-based security
  • Administer Power BI to an organization
  • Build custom dashboards using Power BI Desktop

Course Objectives

Untitled design (7)
  • Go beyond bar charts to provide better insights
  • Understand what keeps the CEO up at night
  • How to ask the right questions  
  • Where to find answers to these questions  
  • What makes a visualization effective 

Course Outline

    • Power BI deployment modes 
    • Project discovery and ingestion 
    • Power BI project roles 
    • Power BI licenses 
    • Data warehouse bus matrix 
    • Dataset design process 
    • Data profiling 
    • Dataset planning 
    • Sample project analysis 
    • Overview 
    • Use Cases 
    • Architecting a PBIX file 
    • Preview features 
    • Visualizations 
    • Data Models 
    • Analyzing data in the PBIX tables 
    • Navigation 
    • Loading Data Models 
    • Leveraging parameters 
    • Advanced Query Editor 
    • Data transformation 
    • Data manipulation 
    • Joining multiple data sources 
      • On premise 
      • Cloud 
      • Hybrid 
    • Understanding query process 
    • Query design per dataset mode 
    • Data sources 
    • SQL views 
    • M queries 
    • Query folding 
    • M Query examples 
    • M editing tools 
    • Dataset layers 
    • The Data Model  
    • Relationships 
    • Model metadata 
    • Optimizing performance 
    • DAX measures 
    • Base measures 
    • Date intelligence metrics 
    • Dimension metrics 
    • Ranking metrics 
    • Security roles 
    • Performance testing 
    • Drill through report pages 
    • Bookmarks 
    • ArcGIS Map visual for Power BI 
    • Waterfall chart breakdown 
    • Analytics pane 
    • Quick Insights  
    • Custom visuals 
    • Animation and data storytelling 
    • End User Interaction design 
    • End User Experience design 
    • How to select the right visual 
    • Understanding visual data alignment 
    • Snowflake schema 
    • Star schema 
    • Designing to leverage relationships 
    • Dynamic filtering 
    • Dashboards versus reports 
    • Dashboard design 
    • Multi-dashboard architectures 
    • Dashboard tiles 
    • Live report pages 
    • Mobile-optimized dashboards 
    • Application workspaces 
    • Staged deployments 
    • Dashboard data classifications 
    • Version control 
    • Metadata management 
    • On-premises data gateway planning 
    • Gateway clusters 
    • Gateway architectures 
    • Gateway security 
    • Gateway configuration 
    • Managing gateway clusters 
    • Troubleshooting and monitoring gateways 
    • Scheduled data refresh 
    • DirectQuery datasets 
    • Live connections to Analysis Services models 
    • Dashboard cache refresh 
    • Planning for the Power BI Report Server 
    • Installation 
    • Configuration 
    • Upgrade cycles  
    • Report Server Desktop Application 
    • Report Server Web Portal 
    • Power BI mobile applications 
    • Report server administration 
    • Scale Power BI Report Server 
    • Content distribution methods 
    • Power BI apps 
    • Self-Service BI workspace 
    • Sharing dashboards and reports 
    • SharePoint Online embedding 
    • Custom application embedding 
    • Publish to web 
    • Data alerts 
    • Email Subscriptions 
    • Analyze in Excel 
    • Data governance for Power BI 
    • Azure Active Directory 
    • Usage metrics reports 
    • Audit logs 
    • Power BI Premium capacities 
    • Power BI Premium 
    • Power BI Premium capacity allocation 
    • Premium capacity estimations 
    • Analysis Services 
    • Migration of Power BI Desktop to Analysis Services 
    • Build an ETL 
    • Distributing Dataflow 
    • Connecting to Dataflows 
    • Management 
    • Role based access 
    • Designing for RLS 
    • Dynamic Role level security 
    • Leveraging the AAD 
    • Implementing in the Power BI Service 
    • PBIX version control 
    • Continuous Integration 
    • Continuous Deployment 
    • Aligning as an Agile/Scrum BI team 
    • Pull Requests 
    • Builds 
    • Releases 
    • Pipeline Management 
    • Automatic deployment to Power BI Service 
    • Gated deployments with approvals 
    • Security 
    • Projects 

Seamless Live Virtual Training Experience

We custom built our group training platform to give students, managers, and teachers a best in class learning experience.

Dead-Simple Scheduling

Easy scheduling and rescheduling, student logins, and delivery of the course.

Engaging Live Instruction

Intuitive, easy to use, and fully featured live video capabilities with trained instructors. No need for outside tools like Zoom.

All-in-one

Live video instruction, practice exercises, course evaluations, course materials, and student collaborations all happen in the same intuitive platform.

Best In Class Security

We built this platform from the ground up with security in mind. No Zoom bombing here.

Outcome Tracking

Student progress, participation, and achievement is all available and can be integrated into your LMS.

Forever Student Access

Students have access to all course materials, certificates, badges, and live instruction session recordings forever.

Single Course

up to 30 students

Customizations available

Forever access to training materials, sessions recordings, and platform

Forever access to student tracking

Train on your own data (extra fee)

On-site option (extra fee)

3-Course Package

up to 30 students per class

Customizations available

Forever access to training materials, sessions recordings, and platform

Forever access to student tracking

Train on your own data (extra fee)

On-site option (extra fee)

Better knowledge retention

Enterprise

All courses available at a discount

Customizations available

Forever access to training materials, sessions recordings, and platform

Forever access to student tracking

Train on your own data (extra fee)

On-site option (extra fee)

Better knowledge retention

Branded Learning Portal

Custom LMS Integration

Our Training Quality Guarantee

RyanPhotoSmall

After over a decade of working in the trenches with Tableau to solve problems in a myriad of industries, I created this curriculum to not only help others gain technical skills, but also the business acumen they need to ask the right questions and get to insight for the business.

If you’re not 100% satisfied with the course and our instructors, we’ll give you a full refund, no questions asked.

Ryan Nokes, CEO of Data Crunch 

DeloitteLogoSlider
VerizonWirelessSmall
DeltaTransparentSlider
TWCTransparentSlider
USAASlider2
BcbsilTransparentSlider-1
WattsSlider
CityofColumbusTransparentSlider
EMDSeronoTransparentSlider
AAASlider3
RyanPhotoSmall

After over a decade of working in the trenches with Tableau to solve problems in a myriad of industries, I created this curriculum to not only help others gain technical skills, but also the business acumen they need to ask the right questions and get to insight for the business.

If you’re not 100% satisfied with the course and our instructors, we’ll give you a full refund, no questions asked.

Ryan Nokes, CEO of Data Crunch 

DeloitteLogoSlider
VerizonWirelessSmall
DeltaTransparentSlider
TWCTransparentSlider
USAASlider2
BcbsilTransparentSlider-1
WattsSlider
CityofColumbusTransparentSlider
EMDSeronoTransparentSlider
AAASlider3

Testimonials

Thorough and Applicable

“I really liked the step-by-step nature of the course. It was very easy to follow and therefore learn. The instructor did a great job catering examples to us (based on his knowledge of our work) when applicable. He was very thorough in covering different aspects of the course and I learned a great deal! The instructor answered our questions thoughtfully, and even followed up after breaks to make sure our questions were answered well and correctly. Thank you!”

Adaptable

“Informational and instructor was adaptable to explain subjects outside of the planned course material as questions aros”

Safe Space to Practice and Ask Questions

“The space to practice and ask technical questions without feeling hurried.”

Lots of Energy

“Great use of examples in class. Appreciate you taking the necessary time to make sure everyone was able to understand the concepts. Lots of energy to keep everyone engaged.”

Highly Rewarding

“The class was highly rewarding and covered more than what was expected. The training was very well presented and I never felt lost.”

Immediately Applicable

“I was able to quickly apply and see where Tableau could be valuable for my internal and external reporting clients.”

Contact Us to Schedule A Course

Other Courses You May Be Interested In