Click a Power BI course title below to view class details and dates:
- Power BI – Dashboards in a Day
- Power BI – Data Analyst (PL-300)
- Power BI – Data Analysis Practitioner
Click on a Power BI title below for Group Training:
Power BI Training for Employees and Individuals in the Scottsdale area
Data Creative provides live, instructor-led Power BI classes. Power BI, a powerful data visualization and business intelligence tool, allows users to transform raw data into insightful and visually appealing reports, dashboards, and visualizations, which can help make informed decisions and identify trends and patterns in their data. Our top-rated, expert instructors train thousands of employees each year to produce higher quality work in a shorter timeframe. Every class is live using hands-on exercises.
Power BI Training for Private Groups in the Scottsdale area
Data Creative can deliver live, in-person Power BI classes to your group at your location in the Scottsdale, Arizona area. Our instructors will go onsite to deliver standard or customized classes to meet your needs, schedule and budget. Contact Data Creative today to learn more about our private group training capabilities.
Request a private group training event here for your group in Scottsdale, Arizona or call 916-601-0992 for more information.
Microsoft Power BI Classes
Power BI – Dashboards in a Day
Created Power BI Dashboards for Analytics — 1 Day
Students will discover the full capabilities of Power BI in a one-day, hands-on workshop. Gain knowledge of how to get started with using Power BI for Analytics and confidence in building and servicing basic Power BI solutions for your organization. Understand how to connect, import, and transform data from a variety of sources, better understand how to explore data with powerful visualization tools to build stunning reports, and share dashboards with your team and publish them to the web.
- Accessing & Preparing data
- Data Modeling and Exploration
- Data Visualization
- Publishing & Accessing Reports
- Dashboard and Collaboration
Class Schedule
Power BI – Data Analyst (PL-300)
Querying and Modifying Data in Relational Databases — 3 Days
This course covers the various methods and best practices that are in line with business and technical requirements for modeling, visualizing, and analyzing data with Power BI. The course will show how to access and process data from a range of data sources including both relational and non-relational sources. Finally, this course will also discuss how to manage and deploy reports and dashboards for sharing and content distribution.
- Get Started with Microsoft Data Analytics
- Getting Data in Power BI
- Cleaning, Transforming, and Loading Data in Power BI
- Design a Data Model in Power BI
- Create Model Calculations using DAX in Power BI
- Optimize Model Performance in Power BI
- Create Reports in Power BI
- Create Dashboards in Power BI
- Identify Patterns and Trends in Power BI
- Create and Manage Workspaces in Power BI
- Manage Files and Datasets in Power BI
- Row-level Security in Power BI
Class Schedule
Power BI – Data Analysis Practitioner
Connect, Visualize and Analyze Data using Microsoft Power BI — 2 Days
This course is designed for professionals in a variety of job roles who are currently using desktop or web-based data-management tools such as Microsoft Excel or SQL Server reporting server to perform numerical or general data analysis. They are responsible for conducting data analysis and providing reports about their analysis and looking for alternative ways to analyze business data, visualize insights, and share those insights with peers across the enterprise. This includes capturing and reporting on data to peers, executives, and clients.
- Analyzing Data with Self-Service BI
- Connecting to Data
- Performing Advanced Data Modeling and Shaping
- Visualizing Data with Power BI
- Enhancing Data Analysis
- Modeling Data with Calculations
- Creating Interactive Visualizations
Class Schedule
Introduction to Microsoft Power BI
Getting Started with Power BI — Half-Day
Microsoft Power BI is a powerful tool for data analysis and visualization. As a beginner, there are many things you can do with Power BI to get started with data analysis including connecting to data sources, creating reports, using visualizations, creating dashboards and sharing your work. This is the perfect session for organizations looking to explore the possibilities of Microsoft Power BI.
- Overview of the Power BI Ecosystem
- Introduction to the Power Query Editor
- Creating a Data Model
- Creating a Report
- Publishing a Report and Data Model
- Understanding Workspaces
Request Information for a Group Training
Schedule NowPower BI – Report Performance
Introduction to Reports — Half Day
This four-hour session gives participants an introduction to report performance turning. Students will explore a data model including its fields, tables, relationships and measures, then build a simple report. That report will go “tuned” with various data techniques.
- Explore the Data Model
- Explore Default Relationships
- Slim Down the Data Model
- Use the Power Query Editor to Modify Data
- DAX Filters
- Testing Security Roles
Request Information for a Group Training
Schedule NowPower BI – Creating a Data Model
Data Model, Filters and Relationship — 1 Day
This session will teach participants how to create a data model in the Power BI desktop using previously cleansed and transformed data.
- Overview of Data Modeling
- Star Schema
- Fact and Dimension Tables
- Error Recognition
- Filter and Relationships
- Adding to the Data Model
Request Information for a Group Training
Schedule NowPower BI – Creating Reports
Data Visualization — 1 Day
This session will teach participants how to create reports in the Power BI desktop that use provided data models; review the fields, tables, relationships and measure built into the model; explore ways to visualize the underlying data; explore design implications for larger, multi-page reports; and minimize the number of queries which slow down report performance.
- Exploring the Data Model
- Create an Initial Set of Visuals
- Selecting Visuals
- Explore Interactions, Drill Down/Drill Through
- Create Visuals Supported by the Relationships
- Bookmarks, Buttons, Drill Throughs
- Slicers with Defaults
- Interactions within Visuals
- Filters on Visuals
Request Information for a Group Training
Schedule NowPower BI – Exploring the Service
The Power BI Service vs the Desktop — 1 Day
This session will teach participants when to use the Power BI Service to develop reports rather than creating them using the Desktop, then cover the feature sets within the service such as workspaces, dashboards and apps.
- Service vs Desktop
- Workspaces vs My Workspace
- Refreshing Data
- Building and Sharing Permissions
- Datasets and Dataflows
- Workspace Features
- Dashboards
- Apps
- Monitor a SQL Server infrastructure
- Troubleshoot a SQL Server infrastructure
- Import and export data
Request Information for a Group Training
Schedule NowPower BI – Introduction for Executives and Decision Makers
Overview for Stakeholders Responsible for Implementing Power BI — 1 Day
This session will teach executives and decision makers to understand the of the Power BI ecosystem to drive a data culture within the organization.
- Power BI Ecosystem
- Data Preparation
- Mastering the Data Model
- DAX
- Power BI Service
- Workspaces and Apps being Workflow Communication Tools
- Become a Data Culture
Request Information for a Group Training
Schedule NowPower BI – Streamlining Work with Datasets and Dataflows
Using Datasets to Create Reports; Using Dataflows to Create Data Models — 1 Day
This session will teach executives and decision makers to understand the of the Power BI ecosystem to drive a data culture within the organization.
- Reports in the Service
- Thin Reports
- Composite Modeling
- Creating Dataflows
- Reports using Dataflows