Certified courses
Microsoft Power BI Boot Camp

Make better decisions and provide strategic information to the entire organisation with the solutions you build.

Microsoft Power BI Boot Camp

Make better decisions and provide strategic information to the entire organisation with the solutions you build.

12 Sep 2022 Live-Online New York 3 days Early bird $1595 +VAT Make enquiry Book Course Make enquiry

Course Timings

This training course runs from 08:30 to 16:30 each day.

All times given are in the local timezone for the date of the course.

Course Overview

This three-day instructor-led course will teach how to use the entire Power BI and Power BI Desktop toolset as your business intelligence platform. You'll learn how to implement solutions using the Power Query, PowerPivot, PowerView, Power Map, Power BI, Power BI Desktop, and Excel Services for SharePoint.

This Power BI training course is packed with hands-on labs to reinforce class topics and provide you with the skills to successfully create impressive dashboards, reports, and other business intelligence solutions. You'll learn best practices for implementing Power BI solutions and practical ideas for implementing the solutions within your organization.

Companies today generate enormous amounts of valuable information, but often have poor reporting capabilities – inhibiting the sharing of key information. This course will teach you how to provide executives, managers, and your entire staff with insights into your data through state-of-the-art business intelligence solutions built on the Microsoft Power BI and 365 platform. BI has never been more accessible and capable before! This course teaches you everything you need to know to implement BI solutions using, Power Query, PowerView, PowerPivot, Power Map, Excel Services, and Power BI.

Course Content

Part 1: What is BI

  1. Business Intelligence Overview
  2. Evolution of Business Intelligence
  3. Common Challenges
  4. Benefits of Power BI

Part 2: Getting Started with Power BI

  1. Overview & Pricing/Licensing
  2. Components of Power BI
    1. Power BI Desktop
    2. Power BI Mobile
    3. Power BI Embedded
    4. Power BI Gateway
  3. Building Blocks of Power BI
    1. Datasets
    2. Visualization
    3. Reports
    4. Tiles
    5. Dashboards
  4. Power BI Workflows
  5. Resources for Inspiration

Demo: Quick Tour of Power BI Service

Lab Exercise: Quick Tour of Power BI Service

Part 3: Getting Data

  1. Navigating Power BI Desktop
  2. Connect to Data Sources in Power BI Desktop
    1. File Data Sources
    2. Database Data Sources
    3. Azure Data Sources
    4. Online Service Data Sources
    5. Miscellaneous Data Sources
  3. Clean and Transform your Data
  4. Advanced Data Sources
    1. Advanced Editor
    2. Shaping Data
    3. Applied Steps
  5. Transformations
  6. Cleaning Irregularly Formatted Data
  7. Data Types
  8. Combining Data
  9. AI Analytics
    1. Text Analytics
    2. Vision
    3. Azure Machine Learning
    4. Invoking the Shared Models
    5. Considerations and Limitations

Demo: Quick Tour of Power Query Editor

Lab Exercise: Import Data and Create Queries with Power BI Desktop

Lab Exercise: Transform Data

Lab Exercise: Combining Data

Lab Exercise: Create a Report using Power BI Desktop

Lab Exercise: Publish a PBIX File to the Power BI Service

Part 4: Power BI and Excel

  1. Excel Integration
    1. Import an Excel Table into Power BI
    2. Use Excel as a Dataset
    3. Import Excel Files with Data Models
    4. Connect, Manage and View Excel in Power BI
  2. Publishing and Sharing

Part 5: Modeling Data

  1. Overview
  2. How to Manage Your Data Relationships
  3. Create Calculated Columns
  4. Optimizing Data Models for Better Visuals
  5. Create Measures and Work with Time-Based Functions
  6. Create Calculated Tables
  7. Explore Time-Based Data
  8. Grouping
  9. Binning
  10. Hierarchies

Demo: Modeling Relationships Column by Example Conditional Columns, Groups, Hierarchies

Part 6: Visualizations

  1. Overview
  2. Create and Customize Simple Visualization
    1. Numerical Fields
    2. Text Fields
    3. Geographic Fields
  3. Modify Colors Insert Static Objects, and Set Page Properties
  4. Styling with Shapes, Text Boxes, and Images
  5. Page Layout and Formatting
  6. Z-Order of Report Elements
  7. Customize Visuals with Summarizations
  8. How to:
    1. Use Combination Charts
    2. Manage Slicers and Sync Slicer
    3. Use Map Visualizations
    4. Implement Tables and Matrixes
    5. Apply Conditional Formatting
    6. Interpret Scatter Charts
    7. Work with Water & Funnel Chart
    8. Use Gauges and Single Number Cards
  9. Creating Complex Interactions Between Visuals
  10. Advance Concepts and New Features
    1. Decomposition Tree
    2. Key Influencers
    3. Insights
    4. Visual Hierarchies and drill-down behavior
    5. Custom Visualizations
    6. Drillthrough
    7. Analytics Pane
    8. Forecasting
    9. Tooltips
    10. Chiclet Slicer
    11. Hierarchy Slicer
    12. Synoptic Panel
  11. Other Powerful Custom Visualizes
    1. Pivot Slicer
    2. Smart Filter
    3. Hierarchy Filter
    4. Card Browser
    5. Visio Visual
    6. Infographic Designer
    7. D3JS Visualizer

Demo: Visualizations, Slicers, and Advanced Interactions

Part 7: Publishing and Sharing

  1. Print and Export Power BI dashboards
  2. Creating Content Packs
  3. Publishing to Web
  4. Embed in SharePoint
  5. Export to PowerPoint
  6. Power BI Mobile
  7. Creating Workspaces in Power BI

Part 8: Exploring Data

  1. Overview
  2. Use Quick Insights
  3. Create and Configure a Dashboard
  4. Shared Dashboards with your Organization
  5. Display Visuals and Tiles Full-Screen
  6. Edit Tile Details
  7. Get More Space on Your Dashboard
  8. Ask Questions of your Data with Natural Language
    1. Custom Q&A suggestions
    2. Adding Q&A to a Report
    3. Adding a Q&A to a Report
    4. Q&A Tooling
    5. Review Questions
    6. Teach Q&A
    7. Manage Terms
    8. Data Sources for Q&A
    9. Bulk Synonyms
    10. Q&A Best Practices
  9. Bookmarks
  10. Themes

Demo: Quick sights

Demo: Q&A in Dashboards and Reports

Demo: Bookmarks

Part 9: Administration & Security

  1. Securing Content in Power BI
    1. My workspace
    2. Sharing a Dashboard
    3. Sharing to Web
    4. Admin Access
  2. Row-level Security
  3. Permissions
  4. Defining and Creating toles within Power BI Desktop
  5. Row-Level Security
  6. Managing Data Capacity
  7. Subscriptions
  8. Resources

Part 10: Introduction to DAX

  1. DAX Calculation Types
    1. Calculated Columns
    2. Calculated Measures
  2. DAX Functions
    1. Aggregation Functions
    2. Counting Functions
    3. Logical Functions
    4. Information Functions
    5. Text Functions
    6. Date Functions
  3. Using Variables in DAX Expressions
  4. Table Relationships in DAX
  5. DAX Tables and Filtering
  6. Quick Measures
  7. What-if Parameters
  8. Dynamic Labeling
  9. Resources

Demo: Quick Measures

Demo: What-if

Demo: Dynamic Labeling

Hands-on Lab Exercises:

  • Retail Sales Exercise
  • Retail Analysis – Overview
  • Retail Analysis – District Monthly Sales
  • Retail Analysis – New Stores
  • Customer Profitability Exercise
  • Customer Profitability – Team Scorecard
  • Customer Profitability – Industry Margin Analysis
  • Customer Profitability – Executive Scorecard
  • Opportunity Analysis: Exercise
  • Opportunity Analysis – Opportunity Count
  • Opportunity Analysis – Revenue Overview
  • Opportunity Analysis – Upcoming Opportunities
  • Opportunity Analysis – Region Stage Counts
  • Opportunity Analysis Data Model

Learning Objectives

In this class you will learn how to:

  • Utilise the entire Microsoft BI stack
  • Connect on-premise data sources to the cloud
  • Build an enterprise Data Catalog to share queries
  • Implement scorecards, dashboards, and KPIs
  • Analyze data with PowerPivot
  • Integrate data from many different external data sources
  • Implement effective, high-performing BI solutions
  • Provide intuitive ad-hoc reporting for business users by implementing Power View

Audience

Professionals who may benefit from this Microsoft Power BI training include:

  • Analysts
  • Database Administrators
  • Project Managers
  • Senior Business Intelligence Architects and Consultants
  • Senior Business Analysts
  • Digital Marketers
  • IT Specialists
  • IT Managers/IT Directors
  • Anyone responsible for implementing BI

Pre-requisites

THis course does not require any pre-requisites.

Course Preparation

Any pre-course preparation will be provided to you after registration.

Certifying Bodies & Exams

This course does not include a formal certification or exam.

What You Receive

Three days (24 hours) of instruction from one of our highly experienced trainers. Also included:

  • Course materials

Online Details

We use Zoom video conferencing to host our live online courses via a virtual classroom. We recommend that before registering participants run a zoom test meeting and check system requirements to ensure they are able to connect. Participants will also use our digital workspace, Mural and our Agile Tools Mobile app for collaboration with the class and completing exercises for the duration of the course. You’ll find links below to test and explain requirements for each of these tools.

Zoom requirements

https://support.zoom.us/hc/en-us/articles/201362023-System-Requirements-for-PC-Mac-and-Linux

Zoom test meeting

https://zoom.us/test

Mural requirements

https://support.mural.co/en/articles/2113688-technical-requirements-to-run-mural

Agile Tools Mobile App

https://www.radtac.com/resources/agile-tools-mobile-app/

On registration full information will be provided via joining instructions to each partcipant with instructions on how to acess the virtual classroom and additional tools.

Still unsure? Talk to our team of friendly learning advisors, they are here to assist before, during and after your class if you have any questions.

Refine your search
Reset
06 Jun 2022 Live-Online New York | 3 days Early bird $1595 +VAT
06 Jun 2022

Make better decisions and provide strategic information to the entire organisation with the solutions you build.

Live-Online New York 3 days
Early bird $1595 +VAT
Tools & Technical
Agile Tooling
More info & dates
Book Course
Book Course
27 Jun 2022 Live-Online New York | 3 days Early bird $1595 +VAT
27 Jun 2022

Make better decisions and provide strategic information to the entire organisation with the solutions you build.

Live-Online New York 3 days
Early bird $1595 +VAT
Tools & Technical
Agile Tooling
More info & dates
Book Course
Book Course
13 Jul 2022 Live-Online New York | 3 days Early bird $1595 +VAT
13 Jul 2022

Make better decisions and provide strategic information to the entire organisation with the solutions you build.

Live-Online New York 3 days
Early bird $1595 +VAT
Tools & Technical
Agile Tooling
More info & dates
Book Course
Book Course
08 Aug 2022 Live-Online New York | 3 days Early bird $1595 +VAT
08 Aug 2022

Make better decisions and provide strategic information to the entire organisation with the solutions you build.

Live-Online New York 3 days
Early bird $1595 +VAT
Tools & Technical
Agile Tooling
More info & dates
Book Course
Book Course
24 Aug 2022 Live-Online New York | 3 days Early bird $1595 +VAT
24 Aug 2022

Make better decisions and provide strategic information to the entire organisation with the solutions you build.

Live-Online New York 3 days
Early bird $1595 +VAT
Tools & Technical
Agile Tooling
More info & dates
Book Course
Book Course
12 Sep 2022 Live-Online New York | 3 days Early bird $1595 +VAT
12 Sep 2022

Make better decisions and provide strategic information to the entire organisation with the solutions you build.

Live-Online New York 3 days
Early bird $1595 +VAT
Tools & Technical
Agile Tooling
More info & dates
Book Course
Book Course
05 Oct 2022 Live-Online New York | 3 days Early bird $1595 +VAT
05 Oct 2022

Make better decisions and provide strategic information to the entire organisation with the solutions you build.

Live-Online New York 3 days
Early bird $1595 +VAT
Tools & Technical
Agile Tooling
More info & dates
Book Course
Book Course
17 Oct 2022 Live-Online New York | 3 days Early bird $1595 +VAT
17 Oct 2022

Make better decisions and provide strategic information to the entire organisation with the solutions you build.

Live-Online New York 3 days
Early bird $1595 +VAT
Tools & Technical
Agile Tooling
More info & dates
Book Course
Book Course
15 Nov 2022 Live-Online New York | 3 days Early bird $1595 +VAT
15 Nov 2022

Make better decisions and provide strategic information to the entire organisation with the solutions you build.

Live-Online New York 3 days
Early bird $1595 +VAT
Tools & Technical
Agile Tooling
More info & dates
Book Course
Book Course
30 Nov 2022 Live-Online New York | 3 days Early bird $1595 +VAT
30 Nov 2022

Make better decisions and provide strategic information to the entire organisation with the solutions you build.

Live-Online New York 3 days
Early bird $1595 +VAT
Tools & Technical
Agile Tooling
More info & dates
Book Course
Book Course
12 Dec 2022 Live-Online New York | 3 days Early bird $1595 +VAT
12 Dec 2022

Make better decisions and provide strategic information to the entire organisation with the solutions you build.

Live-Online New York 3 days
Early bird $1595 +VAT
Tools & Technical
Agile Tooling
More info & dates
Book Course
Book Course

Why train with Radtac?

Copyright © Radtac 2022     |     All rights reserved     |     Registered in England ∓ Wales No. 03600183