Course Number: PBI-106

Duration: 3 days (19.5 hours)

Format: Live, hands-on

Power BI Desktop Training Overview

This private, online, Power BI Desktop for Report Writers training teaches attendees how to clean and present their data as powerful visualizations and reports. Over 80% of the class is hands-on, with attendees learning by doing.

Location and Pricing

This course is taught as a private, live online class for teams of 3 or more. To receive a quote for online corporate training, please contact us.

Objectives

  • Work with data in Power Query
  • Understand relationships in Power Pivot
  • Create visuals in Power View
  • Create columns and measures using DAX Language
  • Manipulate data
  • Leverage Power BI tips and tricks
  • Tell a story with visuals
  • Share reports and dashboards
  • Use Quick Insights and Q&A for data

Prerequisites

No prior experience is presumed.

Outline

Expand All | Collapse All

Introduction to Power BI Apps and Power BI Desktop
  • What is Power BI?
  • What is Power BI Desktop?
  • Introduction to Power BI Desktop Application
Introduction to Power Query and the Data Button
  • Connecting to Data
  • Using Power Query Editor
  • Transforming the Data
  • Editing the Data
  • Refreshing the Data
Introduction to Power Pivot using the Model Button
  • Understanding Relationships
  • Modifying Relationships
Introduction to Power View using the Report Button
  • Working with Measures
  • Creating Visuals
Manipulating the Data
  • Unpivoting Data
  • Appending Data
  • Shape and Combine Data
  • Merging Data
  • Creating Calculations using M Language
More About Relationships
  • Using Manage Relationships
  • Creating Relationships
More about Visuals
  • Creating Columns using DAX Language
  • Creating Measures using DAX Language
  • Creating Reports using Visuals
  • Applying Filters to Visuals
  • Creating Bookmarks
  • Creating Multiple Pages
Publishing and Sharing Your Reports
  • Exporting Reports
  • Exporting Data
  • Publishing Reports
Power BI Tips and Tricks
  • Setting up the Quick Access Toolbar
  • Using Power BI Help
Creating Visuals that tell a Story
  • Creating Top N Filters and Groups
  • Adding Date Hierarchy to Drill Down on
  • Adding Conditional Formatting
  • Using Themes
  • Adding Report Titles, Logos, and Images
Using the Power BI Service
  • Logging into the PBI Service
  • Understanding Workspaces
  • Building a Dashboard
  • Sharing Reports & Dashboards
  • Sharing Datasets
  • Building Reports in Power BI Service
Gain Business Insights From Your Data
  • Using Quick insights
  • Create Q&A questions
  • Leverage Q&A for ad-hoc visualization
  • Optimize data for quick insights
Conclusion

Training Materials:

All attendees receive a Power BI quick reference guide.

Software Requirements:

  • The current version of Power BI Desktop installed
  • Attendees will not need to install any other software on their computer for this class. The class will be conducted in a remote environment that Accelebrate will provide.


Learn faster

Our live, instructor-led lectures are far more effective than pre-recorded classes

Satisfaction guarantee

If your team is not 100% satisfied with your training, we do what's necessary to make it right

Learn online from anywhere

Whether you are at home or in the office, we make learning interactive and engaging

Multiple Payment Options

We accept check, ACH/EFT, major credit cards, and most purchase orders



Recent Training Locations

Alabama

Birmingham

Huntsville

Montgomery

Alaska

Anchorage

Arizona

Phoenix

Tucson

Arkansas

Fayetteville

Little Rock

California

Los Angeles

Oakland

Orange County

Sacramento

San Diego

San Francisco

San Jose

Colorado

Boulder

Colorado Springs

Denver

Connecticut

Hartford

DC

Washington

Florida

Fort Lauderdale

Jacksonville

Miami

Orlando

Tampa

Georgia

Atlanta

Augusta

Savannah

Hawaii

Honolulu

Idaho

Boise

Illinois

Chicago

Indiana

Indianapolis

Iowa

Cedar Rapids

Des Moines

Kansas

Wichita

Kentucky

Lexington

Louisville

Louisiana

New Orleans

Maine

Portland

Maryland

Annapolis

Baltimore

Frederick

Hagerstown

Massachusetts

Boston

Cambridge

Springfield

Michigan

Ann Arbor

Detroit

Grand Rapids

Minnesota

Minneapolis

Saint Paul

Mississippi

Jackson

Missouri

Kansas City

St. Louis

Nebraska

Lincoln

Omaha

Nevada

Las Vegas

Reno

New Jersey

Princeton

New Mexico

Albuquerque

New York

Albany

Buffalo

New York City

White Plains

North Carolina

Charlotte

Durham

Raleigh

Ohio

Akron

Canton

Cincinnati

Cleveland

Columbus

Dayton

Oklahoma

Oklahoma City

Tulsa

Oregon

Portland

Pennsylvania

Philadelphia

Pittsburgh

Rhode Island

Providence

South Carolina

Charleston

Columbia

Greenville

Tennessee

Knoxville

Memphis

Nashville

Texas

Austin

Dallas

El Paso

Houston

San Antonio

Utah

Salt Lake City

Virginia

Alexandria

Arlington

Norfolk

Richmond

Washington

Seattle

Tacoma

West Virginia

Charleston

Wisconsin

Madison

Milwaukee

Alberta

Calgary

Edmonton

British Columbia

Vancouver

Manitoba

Winnipeg

Nova Scotia

Halifax

Ontario

Ottawa

Toronto

Quebec

Montreal

Puerto Rico

San Juan