Microsoft Power BI Boot Camp Classroom Live Raleigh, NC September 14, 2020

Price: $1,900

This course runs for a duration of 3 Days.

The class will run daily from 8:30 am EST to 4:30 pm EST.

Class Location: Raleigh - Raleigh, NC.

Enroll today to reserve your spot!

Space is limited. Enroll today.

Enroll Now

Description

This 3-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 class is packed with hands-on labs to re-enforce 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 you 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 Office 365 platform. BI has never been more accessible and capable before! This courses teaches you everything you need to know to implement BI solutions using, Power Query, PowerView, PowerPivot, Power Map, Excel Services, and Power BI.

Objectives:

  • Make better decisions and provide strategic information to the entire organization with the solutions you build!
  • Obtain a deep understanding of the entire Microsoft BI stack
  • Surface Analysis Services cubes via Power BI features
  • Learn how to connect on-premise data sources to the cloud
  • Learn how to build an enterprise Data Catalog to share queries
  • Implement scorecards, dashboards, and KPIs
  • Understand the capabilities of PowerPivot and how to analyze data with PowerPivot
  • Integrate data from many different external data sources
  • Learn best practices for implementing effective, high-performing BI solutions
  • Learn how to provide intuitive ad-hoc reporting for business users by implementing Power View
  • Learn the benefits and limitations of each BI tool and which ones will work best for your needs

Audience:

  • Analysts
  • Database Administrators
  • Project Managers
  • Senior Business Intelligence Architects and Consultants
  • Senior Business Analysts
  • Anyone responsible for implementing BI.

Course Overview

  • What is BI?
    1. Business Intelligence Overview
    2. Common Challenges
    3. Benefits of Power BI
  • Getting Started
    1. Overview
    2. Pricing and Licensing
    3. Components of Power BI
    4. Building Blocks of Power BI
    5. Quick Tour of Power BI Service
    6. Installing Power BI Desktop
  • Getting Data
    1. Navigating Power BI Desktop
    2. Connect to Data Sources in Power BI Desktop
    3. Clean and Transform your Data
    4. Advanced Data Sources and Transformation
    5. Cleaning Irregularly Formatted Data
    6. Combining Data
  • Modeling
    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
  • Visualizations
    1. Overview
    2. Create and Customize Simple Visualizations
    3. How to Use Combination Charts
    4. Create and Format Slicers
    5. How to Use Map Visualizations
    6. How to Use Tables and Matrixes
    7. How to Use Scatter Charts
    8. How to Use Water & Funnel Charts
    9. How to Use Gauges and Single Number Cards
    10. How to modify colors
    11. Style Your Reports
    12. Create Complex Interactions Between Visualizations
    13. Duplicate a Report Page
    14. Show Categories with No Data
    15. Customize Visuals with Summarizations
    16. Arrange the Z-Order of Report Elements
    17. Visual Hierarchies and drill-down behavior
  • Exploring Data
    1. Using Quick Insights
    2. Configuring Dashboards
    3. Ask Questions of your Data with Natural Language
    4. Create custom Q&A Suggestions
    5. Share Dashboards with your Organization
    6. Display Visuals and Tiles Full-Screen
    7. Edit Tile Details
    8. Get More Space on your Dashboard
    9. Install and Configure an On-premise Gateway
  • Power BI and Excel
    1. Integrating Excel
    2. Import an Excel Table into Power BI
    3. Import Excel files with data models
    4. Connect OneDrive for Business to Power BI
  • Publishing and Sharing
    1. Print and Export Power BI Dashboards
    2. Power BI Mobile
    3. Creating Groups in Power BI
    4. Creating Content Packs
    5. Publishing to Web
    6. Embed in SharePoint
    7. Export to PowerPoint
  • Administration and Security
    1. Securing Content in Power BI
    2. Row-Level Security
    3. Auditing
    4. Managing Data Capacity
    5. Governance
    6. Data Classifications
    7. Subscriptions
  • Introduction to DAX
    1. Overview
    2. DAX Calculation Types
    3. DAX Functions
    4. Using variables in DAX expressions
    5. Table Relationships in DAX
    6. DAX Tables and Filtering
  • Summary
    1. More Resources
  • End-to-End Reporting Solutions – Exercises
    1. Retail Sales Exercise
    2. Customer Profitability Exercise
    3. Opportunity Analysis Exercise
    4. Creating InfoGraphics

Hands on-Labs:

  • Quick tour
  • Installing Power BI Desktop
  • Logging into Power BI Service
  • Loading and Combining Data with Power BI Desktop
  • Creating a Basic Report
  • Publishing Reports to Power BI Service
  • Manage Table Relationships
  • Measures – Last Year Comparison
  • Measures – Year to Date
  • Measures – Market Share
  • Optimize the Data Model
  • Column from Examples
  • Conditional Columns
  • Cross-Tabular Report
  • Part-to-Whole Report
  • Relationship Report
  • Trend Report
  • Rank Report
  • Upload PBI Report and Pinning
  • Sharing Dashboard
  • Quick Insights
  • Setup On-Premise Gateway
  • Schedule Data Refresh
  • Importing Excel Models and Data
  • Exporting to PowerPoint
  • Integrating with SharePoint
  • DAX Formulas

Other Available Dates for this Course

Virtual Classroom Live
January 13, 2020

$1,900.00
3 Days    8:30 am EST - 5:00 pm EST
view class details and enroll
Classroom Live
January 13, 2020

Atlanta, GA
$1,900.00
3 Days    8:30 am EST - 5:00 pm EST
view class details and enroll
Classroom Live
February 10, 2020

Indianapolis, IN
$1,900.00
3 Days    8:30 am CST - 5:00 pm CST
view class details and enroll
Virtual Classroom Live
February 10, 2020

$1,900.00
3 Days    8:30 am CST - 5:00 pm CST
view class details and enroll
Virtual Classroom Live
March 16, 2020

$1,900.00
3 Days    8:30 am EST - 5:00 pm EST
view class details and enroll
Classroom Live
March 16, 2020

Reston, VA
$1,900.00
3 Days    8:30 am EST - 5:00 pm EST
view class details and enroll
Virtual Classroom Live
April 13, 2020

$1,900.00
3 Days    8:30 am EST - 5:00 pm EST
view class details and enroll
Classroom Live
April 13, 2020

Charlotte, NC
$1,900.00
3 Days    8:30 am EST - 5:00 pm EST
view class details and enroll
Classroom Live
May 11, 2020

Portland, OR
$1,900.00
3 Days    8:30 am PST - 5:00 pm PST
view class details and enroll
Virtual Classroom Live
May 11, 2020

$1,900.00
3 Days    8:30 am PST - 5:00 pm PST
view class details and enroll
Virtual Classroom Live
June 15, 2020

$1,900.00
3 Days    8:30 am EST - 4:30 pm EST
view class details and enroll
Classroom Live
June 15, 2020

Philadelphia, PA
$1,900.00
3 Days    8:30 am EST - 4:30 pm EST
view class details and enroll
Classroom Live
July 13, 2020

Phoenix, AZ
$1,900.00
3 Days    8:30 am PST - 4:30 pm PST
view class details and enroll
Virtual Classroom Live
July 13, 2020

$1,900.00
3 Days    8:30 am PST - 4:30 pm PST
view class details and enroll
Classroom Live
August 10, 2020

Kansas City, MO
$1,900.00
3 Days    8:30 am CST - 4:30 pm CST
view class details and enroll
Virtual Classroom Live
August 10, 2020

$1,900.00
3 Days    8:30 am CST - 4:30 pm CST
view class details and enroll
Virtual Classroom Live
September 14, 2020

$1,900.00
3 Days    8:30 am CST - 4:30 pm CST
view class details and enroll
Virtual Classroom Live
October 13, 2020

$1,900.00
3 Days    8:30 am EST - 4:30 pm EST
view class details and enroll
Classroom Live
October 13, 2020

Tampa, FL
$1,900.00
3 Days    8:30 am EST - 4:30 pm EST
view class details and enroll
Classroom Live
November 09, 2020

Denver, CO
$1,900.00
3 Days    8:30 am MST - 4:30 pm MST
view class details and enroll
Virtual Classroom Live
November 09, 2020

$1,900.00
3 Days    8:30 am MST - 4:30 pm MST
view class details and enroll
Classroom Live
December 14, 2020

Milwaukee, WI
$1,900.00
3 Days    8:30 am CST - 4:30 pm CST
view class details and enroll
Virtual Classroom Live
December 14, 2020

$1,900.00
3 Days    8:30 am CST - 4:30 pm CST
view class details and enroll