Power BI Comprehensive

Overview

This course is designed for new or intermediate Power BI users who have some experience with the software. Students will learn the fundamentals of the tool and how to apply basic functionality to build and share dashboards of data visualizations using their data.

Students will connect to various data sources, shape and combine data, work with reports, and create and share useable dashboards. This course is taught workshop-style — hands-on with valuable tools to take directly back to current projects. 

PowerBI 3

Overview

PowerBI 3

This course is designed for new or intermediate Power BI users who have some experience with the software. Students will learn the fundamentals of the tool and how to apply basic functionality to build and share dashboards of data visualizations using their data.

Students will connect to various data sources, shape and combine data, work with reports, and create and share useable dashboards. This course is taught workshop-style — hands-on with valuable tools to take directly back to current projects. 

Duration

3 days

Prerequisites

None

Training Materials

Manual and supporting materials included

Software Requirements

Power BI Desktop, Internet Access

Course Objectives

Untitled design (7)
  • Apply the fundamentals of Power BI to organizational goals. 
  • Integrate Power BI with other Office 365 services. 
  • Utilize Power BI for ad-hoc reporting 
  • Create, design, and format dashboards and reports for end-user 
  •  
  •  

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 Service 
    • Sharing
    • Apps 
    • Licensing 
    • Dashboards 
    • Reports 
    • Datasets 
    • Workbooks 
    • Excel 
    • Data refresh 
    • Collaboration 
    • Notifications 
    • Application Integrations 
    • Connections 
    • Modeling 
    • Visualization 
    • DAX 
    • Version control 
    • Using Query Editor 
    • Aggregation 
    • Manipulating Data 
    • Licensing 
    • Capacity Planning 
    • Licensing 
    • Capacity Planning 
    • Row Level Security 
    • Multi Tenant 
    • Azure AD Security 
    • Embed 
    • Reports 
    • Tiles 
    • Dashboards 
    • Q&A 
    • Application Registration 
    • REST API 
    • Building Relationships 
    • Connect and transform data sets 
    • Work with unstructured datasets
    • Storage and connectivity 
    • Data Types 
      • Structured 
      • Unstructured
    • Schema Overview 
    • Working with Query Editor
      • Merging tables together 
      • Appending tables 
      • Data type transofmations 
      • Group rows 
      • Create custom columns 
      •  
      •  
    • Queries 
    • Stored Procedures 
    • Relationships
    • Data Types 
    • Security 
    • Deployment 
    • Management 
    • Use cases 
    • Market place visuals 
      • How to use and deploy 
    • D3
      • Implementation and building 
    • Auditing 
    • Service Health 
    • User Management
    • Capacity management 
    • Workspace management 
    • Data Analysis 
    • Visual Selection 
    • Understanding Audience
    • Storytelling 
    • Color selection 
    • Version control
    • File Sharing/Collaboration 
    • Report CI/CD 
    • Understanding datasets 
    • Building templated dashboards
    • Deploying to the organization 
    • Customization 
    • Build and deploy to organization 
    • Version control
    • Collaboration 
    • Row Level Security 
    • Dynamic role-based access 
    • Constructing role-based filters
    • Security Groups 
    • Workspace Security 
    • Report/Dashboard security 
    • Building
    • Managing 
    • Color and Visualization selection 
    • Understanding structure 
    • Using variables
    • Nested functions 
    • Use cases
      • Custom Measures 
      • Custom Columns 

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