HOME >  Seminars in COLORADO > Denver > Analyzing Data with Power BI (20778)

Seminar Analyzing Data with Power BI (20778) Seminar

Presented by Software Skills Training, Inc.

Hands On Technology Transfer Computer Training

Bring this seminar on-site to your facility for groups of 10 or more.

This course gives students a solid understanding of data analysis with Power BI

Course Description


This is a Microsoft Official Course (MOC) and includes Microsoft courseware and hands-on labs. This course gives students a solid understanding of data analysis with Power BI. Topics include creating visualizations; connecting to Excel files; creating a Power BI dashboard; developing reports using the Power BI desktop App; using DAX syntax; accessing data in Azure SQL Data Warehouses; using the Power BI Mobile App and the Developer API.

Before attending this course, students must have:

  • Excellent knowledge of relational databases and reporting 
  • Some basic knowledge of data warehouse schema topology (including star and snowflake schemas) 
  • Some exposure to basic programming constructs (such as looping and branching) 
  • An awareness of key business priorities such as revenue, profitability, and financial accounting is desirable 
  • Familiarity with Microsoft Office applications - particularly Excel

About MOC On-Demand

US Price: $895

This course is also available via on-demand. Microsoft Official Courses On-Demand (MOC On-Demand) uses a combination of streaming video, text, lab exercises and assessment checks throughout the course. You have 6 months to activate your MOC course. Once activated, MOC On-Demand courses are available for 90 days and recommend the following system requirements:

  • Browser: Current version of Internet Explorer, Microsoft Edge, Google Chrome or Firefox
  • Internet: Broadband Internet connection of over 4Mbps
  • Screen Resolution: 1280 x 1024 or higher

Course Overview

Module 1: Introduction to Self-Service BI Solutions

Introduces business intelligence (BI) and how to self-serve with BI.

Lessons

  • Introduction to business intelligence
  • Introduction to data analysis
  • Introduction to data visualization
  • Overview of self-service BI
  • Considerations for self-service BI
  • Microsoft tools for self-service BI

Labs

  • Viewing reports
  • Creating a Power BI report
  • Creating a Power BI dashboard

After completing this module, students will be able to:

  • Describe the trends in BI
  • Describe the process of data analysis in Power BI. 
  • Use the key visualizations in Power BI
  • Describe the rationale for self-service BI
  • Describe considerations for self-service BI
  • Understand how you can use Microsoft products to implement a BI solution

Module 2: Introducing Power BI

This module introduces Power BI desktop, and explores the features that enable the rapid creation and publication of sophisticated data visualizations.

Lessons

  • Power BI
  • The Power BI service
Labs
  • Connecting to Power BI data
  • Create a Power BI dashboard

After completing this module, students will be able to:

  • Develop reports using the Power BI Desktop app
  • Use report items to create dashboards on the Power BI portal. 
  • Understand the components of the Power BI service including licensing and tenant management

Module 3: Power BI

At the end of this module students will be able to explain the rationale and advantages of using Power BI.

Lessons

  • Using Excel as a data source for Power BI
  • The Power BI data model
  • Using databases as a data source for Power BI
  • The Power BI service
Labs
  • Importing Excel files into Power BI
  • Viewing reports from Excel files

After completing this module, students will be able to:

  • Describe the data model and know how to optimize data within the model. 
  • Connect to Excel files and import data
  • Use on-premises and cloud Microsoft SQL Server databases as a data source, along with the R script data connector
  • Take advantage of the features of the Power BI service by using Q&A to ask questions in natural query language, and create content packs and groups

Module 4: Shaping and Combining Data

With Power BI desktop you can shape and combine data with powerful, built-in tools. This module introduces the tools that are available for preparing your data, and transforming it into a form ready for reporting.

Lessons 

  • Power BI desktop queries
  • Shaping data
  • Combining data
Labs
  • Shape Power BI data
  • Combine Power BI data

After completing this module, students will be able to:

  • Perform a range of query editing skills in Power BI 
  • Shape data, using formatting and transformations. 
  • Combine data together from tables in your dataset

Module 5: Modeling Data

This module describes how to shape and enhance data.

Lessons

  • Relationships
  • DAX queries
  • Calculations and measures
Labs
  • Create relationships
  • Calculations

After completing this module, students will be able to:

  • Describe relationships between data tables. 
  • Understand the DAX syntax, and use DAX functions to enhance your dataset
  • Create calculated columns, calculated tables and measures

Module 6: Interactive Data Visualizations

This module describes how to create and manage interactive data visualizations.

Lessons

  • Creating Power BI reports
  • Managing a Power BI solution
Labs
  • Connecting to Power BI data
  • Building Power BI reports
  • Creating a Power BI dashboard

After completing this module, students will be able to:

  • Use Power Bi desktop to create interactive data visualizations
  • Manage a power BI solution

Module 7: Direct Connectivity

This module describes various connectivity options using Power BI.

Lessons

  • Cloud data
  • Connecting to analysis services
Labs
  • Direct connectivity from Power BI desktop
  • Direct connectivity from the Power BI service

After completing this module, students will be able to:

  • Use Power BI direct connectivity to access data in Azure SQL data warehouse, in addition to big data sources such as Hadoop 
  • Use Power BI with SQL Server Analysis Services data, including Analysis services models running in multidimensional mode

Module 8: The Developer API

This module describes the developer API within Power BI.

Lessons

  • The developer API
  • Custom visuals
Labs
  • Using custom visuals

After completing this module, students will be able to:

  • Describe the developer API. 
  • Use the developer API to create custom visuals

Module 9: Power BI Mobile App

This module describes the Power BI mobile app.

Lessons 

  • Power BI mobile apps
  • Using the Power BI mobile app
  • Power BI embedded

After completing this module, students will be able to:

  • Describe the Power BI mobile app
  • Download and use the Power BI mobile app. 
  • Describe Power BI embedded and when you would want to use it

 

More Seminar Information

Software Skills Training, Inc.
Hands On Technology Transfer Computer Training

Summary

This course gives students a solid understanding of data analysis with Power BI

Delivery Method

Seminar Seminar

Also Available As

On-Site Training On-Site Training

Who Should Attend

Business Data Analysts

 
Search similar training
Email this page
Print this document
 

Dates and Locations

Location Information
Venue Provided Upon Registration
Denver, CO

Dates & Times
10/21/2019 to 10/23/2019


Tuition
$1795


see all dates/locations

 

Frequently Asked
Questions

Payment Options
Bill Me/Invoice
Credit Card

Register
Online
Fax Form

Availability
Seats currently available. Book now before the class is full.

Other Information
Seminar

All Date/Location Information

Alberta (Find training in Alberta)
10/21/2019-10/23/2019 in Calgary, AB         Find a seminar in Calgary AB
12/16/2019-12/18/2019 in Calgary, AB         Find a seminar in Calgary AB
10/21/2019-10/23/2019 in Edmonton, AB         Find a seminar in Edmonton AB
12/16/2019-12/18/2019 in Edmonton, AB         Find a seminar in Edmonton AB

Alabama (Find training in Alabama)
11/18/2019-11/20/2019 in Huntsville, AL         Find a seminar in Huntsville AL

Arkansas (Find training in Arkansas)
11/11/2019-11/13/2019 in Little Rock, AR         Find a seminar in Little Rock AR

Arizona (Find training in Arizona)
11/4/2019-11/6/2019 in Phoenix, AZ         Find a seminar in Phoenix AZ
11/4/2019-11/6/2019 in Tucson, AZ         Find a seminar in Tucson AZ

British Columbia (Find training in British Columbia)
10/21/2019-10/23/2019 in Vancouver, BC         Find a seminar in Vancouver BC
12/16/2019-12/18/2019 in Vancouver, BC         Find a seminar in Vancouver BC

California (Find training in California)
10/28/2019-10/30/2019 in Bakersfield, CA         Find a seminar in Bakersfield CA
10/28/2019-10/30/2019 in Fresno, CA         Find a seminar in Fresno CA
11/4/2019-11/6/2019 in Irvine, CA         Find a seminar in Irvine CA
11/4/2019-11/6/2019 in Los Angeles, CA         Find a seminar in Los Angeles CA
10/28/2019-10/30/2019 in Modesto, CA         Find a seminar in Modesto CA
10/28/2019-10/30/2019 in Oakland, CA         Find a seminar in Oakland CA
11/4/2019-11/6/2019 in Riverside, CA         Find a seminar in Riverside CA
10/28/2019-10/30/2019 in Sacramento, CA         Find a seminar in Sacramento CA
11/4/2019-11/6/2019 in San Bernardino, CA         Find a seminar in San Bernardino CA
11/4/2019-11/6/2019 in San Diego, CA         Find a seminar in San Diego CA
10/28/2019-10/30/2019 in San Francisco, CA         Find a seminar in San Francisco CA
10/28/2019-10/30/2019 in San Jose, CA         Find a seminar in San Jose CA
11/4/2019-11/6/2019 in Santa Clarita, CA         Find a seminar in Santa Clarita CA
11/4/2019-11/6/2019 in Santa Monica, CA         Find a seminar in Santa Monica CA
11/4/2019-11/6/2019 in Temecula, CA         Find a seminar in Temecula CA

Colorado (Find training in Colorado)
10/21/2019-10/23/2019 in Denver, CO         Find a seminar in Denver CO
12/16/2019-12/18/2019 in Denver, CO         Find a seminar in Denver CO

Connecticut (Find training in Connecticut)
12/2/2019-12/4/2019 in Hartford, CT         Find a seminar in Hartford CT
12/2/2019-12/4/2019 in New Haven, CT         Find a seminar in New Haven CT
12/2/2019-12/4/2019 in Stamford, CT         Find a seminar in Stamford CT

Washington DC (Find training in Washington DC)
11/18/2019-11/20/2019 in Washington, DC         Find a seminar in Washington DC

Florida (Find training in Florida)
11/18/2019-11/20/2019 in Ft Lauderdale, FL         Find a seminar in Ft Lauderdale FL
11/18/2019-11/20/2019 in Jacksonville, FL         Find a seminar in Jacksonville FL
11/18/2019-11/20/2019 in Miami, FL         Find a seminar in Miami FL
11/18/2019-11/20/2019 in Orlando, FL         Find a seminar in Orlando FL
11/18/2019-11/20/2019 in Pensacola, FL         Find a seminar in Pensacola FL
11/18/2019-11/20/2019 in Sarasota, FL         Find a seminar in Sarasota FL
11/18/2019-11/20/2019 in Tampa, FL         Find a seminar in Tampa FL
11/18/2019-11/20/2019 in West Palm Beach, FL         Find a seminar in West Palm Beach FL

Georgia (Find training in Georgia)
11/18/2019-11/20/2019 in Atlanta, GA         Find a seminar in Atlanta GA
11/18/2019-11/20/2019 in Savannah, GA         Find a seminar in Savannah GA

Iowa (Find training in Iowa)
10/21/2019-10/23/2019 in Cedar Rapids, IA         Find a seminar in Cedar Rapids IA
12/16/2019-12/18/2019 in Cedar Rapids, IA         Find a seminar in Cedar Rapids IA
10/21/2019-10/23/2019 in Des Moines, IA         Find a seminar in Des Moines IA
12/16/2019-12/18/2019 in Des Moines, IA         Find a seminar in Des Moines IA

Idaho (Find training in Idaho)
10/21/2019-10/23/2019 in Boise, ID         Find a seminar in Boise ID
12/16/2019-12/18/2019 in Boise, ID         Find a seminar in Boise ID

Illinois (Find training in Illinois)
10/21/2019-10/23/2019 in Chicago, IL         Find a seminar in Chicago IL
12/16/2019-12/18/2019 in Chicago, IL         Find a seminar in Chicago IL
10/21/2019-10/23/2019 in Schaumburg, IL         Find a seminar in Schaumburg IL
12/16/2019-12/18/2019 in Schaumburg, IL         Find a seminar in Schaumburg IL
10/21/2019-10/23/2019 in Springfield, IL         Find a seminar in Springfield IL
12/16/2019-12/18/2019 in Springfield, IL         Find a seminar in Springfield IL

Indiana (Find training in Indiana)
10/21/2019-10/23/2019 in Indianapolis, IN         Find a seminar in Indianapolis IN
12/16/2019-12/18/2019 in Indianapolis, IN         Find a seminar in Indianapolis IN

Kansas (Find training in Kansas)
11/11/2019-11/13/2019 in Wichita, KS         Find a seminar in Wichita KS

Kentucky (Find training in Kentucky)
12/9/2019-12/11/2019 in Louisville, KY         Find a seminar in Louisville KY

Louisiana (Find training in Louisiana)
11/11/2019-11/13/2019 in Shreveport, LA         Find a seminar in Shreveport LA

Massachusetts (Find training in Massachusetts)
12/2/2019-12/4/2019 in Boston, MA         Find a seminar in Boston MA
12/2/2019-12/4/2019 in Chelmsford, MA         Find a seminar in Chelmsford MA
12/2/2019-12/4/2019 in Quincy, MA         Find a seminar in Quincy MA
12/2/2019-12/4/2019 in Springfield, MA         Find a seminar in Springfield MA
12/2/2019-12/4/2019 in Waltham, MA         Find a seminar in Waltham MA
12/2/2019-12/4/2019 in Woburn, MA         Find a seminar in Woburn MA
12/2/2019-12/4/2019 in Worcester, MA         Find a seminar in Worcester MA

Manitoba (Find training in Manitoba)
10/21/2019-10/23/2019 in Winnipeg, MB         Find a seminar in Winnipeg MB
12/16/2019-12/18/2019 in Winnipeg, MB         Find a seminar in Winnipeg MB

Maryland (Find training in Maryland)
11/18/2019-11/20/2019 in Baltimore, MD         Find a seminar in Baltimore MD
11/18/2019-11/20/2019 in Columbia, MD         Find a seminar in Columbia MD

Michigan (Find training in Michigan)
10/21/2019-10/23/2019 in Detroit, MI         Find a seminar in Detroit MI
12/16/2019-12/18/2019 in Detroit, MI         Find a seminar in Detroit MI
10/21/2019-10/23/2019 in Lansing, MI         Find a seminar in Lansing MI
12/16/2019-12/18/2019 in Lansing, MI         Find a seminar in Lansing MI

Minnesota (Find training in Minnesota)
10/21/2019-10/23/2019 in Minneapolis, MN         Find a seminar in Minneapolis MN
12/16/2019-12/18/2019 in Minneapolis, MN         Find a seminar in Minneapolis MN

Missouri (Find training in Missouri)
10/21/2019-10/23/2019 in Kansas City, MO         Find a seminar in Kansas City MO
12/16/2019-12/18/2019 in Kansas City, MO         Find a seminar in Kansas City MO
10/21/2019-10/23/2019 in Springfield, MO         Find a seminar in Springfield MO
12/16/2019-12/18/2019 in Springfield, MO         Find a seminar in Springfield MO
10/21/2019-10/23/2019 in St Charles, MO         Find a seminar in St Charles MO
12/16/2019-12/18/2019 in St Charles, MO         Find a seminar in St Charles MO

North Carolina (Find training in North Carolina)
11/18/2019-11/20/2019 in Charlotte, NC         Find a seminar in Charlotte NC
11/18/2019-11/20/2019 in Raleigh-Durham, NC         Find a seminar in Raleigh-Durham NC
11/18/2019-11/20/2019 in Winston-Salem, NC         Find a seminar in Winston-Salem NC

Nebraska (Find training in Nebraska)
10/21/2019-10/23/2019 in Omaha, NE         Find a seminar in Omaha NE
12/16/2019-12/18/2019 in Omaha, NE         Find a seminar in Omaha NE

New Hampshire (Find training in New Hampshire)
12/2/2019-12/4/2019 in Manchester, NH         Find a seminar in Manchester NH
12/2/2019-12/4/2019 in Nashua, NH         Find a seminar in Nashua NH

New Jersey (Find training in New Jersey)
11/18/2019-11/20/2019 in Jersey City, NJ         Find a seminar in Jersey City NJ
11/18/2019-11/20/2019 in Newark, NJ         Find a seminar in Newark NJ
11/18/2019-11/20/2019 in Princeton, NJ         Find a seminar in Princeton NJ

New Mexico (Find training in New Mexico)
11/4/2019-11/6/2019 in Albuquerque, NM         Find a seminar in Albuquerque NM
11/4/2019-11/6/2019 in Las Cruces, NM         Find a seminar in Las Cruces NM

Nevada (Find training in Nevada)
11/4/2019-11/6/2019 in Las Vegas, NV         Find a seminar in Las Vegas NV

New York (Find training in New York)
12/2/2019-12/4/2019 in Albany, NY         Find a seminar in Albany NY
12/9/2019-12/11/2019 in Binghamton, NY         Find a seminar in Binghamton NY
12/9/2019-12/11/2019 in Buffalo, NY         Find a seminar in Buffalo NY
12/9/2019-12/11/2019 in Ithaca, NY         Find a seminar in Ithaca NY
11/18/2019-11/20/2019 in Manhattan, NY         Find a seminar in Manhattan NY
12/9/2019-12/11/2019 in Rochester, NY         Find a seminar in Rochester NY
12/9/2019-12/11/2019 in Syracuse, NY         Find a seminar in Syracuse NY

Ohio (Find training in Ohio)
12/9/2019-12/11/2019 in Cincinnati, OH         Find a seminar in Cincinnati OH
12/9/2019-12/11/2019 in Cleveland, OH         Find a seminar in Cleveland OH
12/9/2019-12/11/2019 in Columbus, OH         Find a seminar in Columbus OH
12/9/2019-12/11/2019 in Dayton, OH         Find a seminar in Dayton OH

Oklahoma (Find training in Oklahoma)
11/11/2019-11/13/2019 in Oklahoma City, OK         Find a seminar in Oklahoma City OK
11/11/2019-11/13/2019 in Tulsa, OK         Find a seminar in Tulsa OK

Ontario (Find training in Ontario)
12/9/2019-12/11/2019 in Kingston, ON         Find a seminar in Kingston ON
12/9/2019-12/11/2019 in Mississauga, ON         Find a seminar in Mississauga ON
12/9/2019-12/11/2019 in Ottawa, ON         Find a seminar in Ottawa ON
12/9/2019-12/11/2019 in Toronto, ON         Find a seminar in Toronto ON

Oregon (Find training in Oregon)
10/21/2019-10/23/2019 in Portland, OR         Find a seminar in Portland OR
12/16/2019-12/18/2019 in Portland, OR         Find a seminar in Portland OR

Pennsylvania (Find training in Pennsylvania)
11/18/2019-11/20/2019 in Harrisburg, PA         Find a seminar in Harrisburg PA
11/18/2019-11/20/2019 in Philadelphia, PA         Find a seminar in Philadelphia PA
12/9/2019-12/11/2019 in Pittsburgh, PA         Find a seminar in Pittsburgh PA

Quebec (Find training in Quebec)
12/9/2019-12/11/2019 in Montreal, QC         Find a seminar in Montreal QC
12/9/2019-12/11/2019 in Quebec City, QC         Find a seminar in Quebec City QC

Rhode Island (Find training in Rhode Island)
12/2/2019-12/4/2019 in Providence, RI         Find a seminar in Providence RI

South Carolina (Find training in South Carolina)
11/18/2019-11/20/2019 in Charleston, SC         Find a seminar in Charleston SC

Saskatchewan (Find training in Saskatchewan)
10/21/2019-10/23/2019 in Regina, SK         Find a seminar in Regina SK
12/16/2019-12/18/2019 in Regina, SK         Find a seminar in Regina SK

Tennessee (Find training in Tennessee)
12/9/2019-12/11/2019 in Memphis, TN         Find a seminar in Memphis TN
12/9/2019-12/11/2019 in Nashville, TN         Find a seminar in Nashville TN

Texas (Find training in Texas)
11/11/2019-11/13/2019 in Austin, TX         Find a seminar in Austin TX
11/11/2019-11/13/2019 in Corpus Christi, TX         Find a seminar in Corpus Christi TX
11/11/2019-11/13/2019 in Dallas, TX         Find a seminar in Dallas TX
11/4/2019-11/6/2019 in El Paso, TX         Find a seminar in El Paso TX
11/11/2019-11/13/2019 in Ft Worth, TX         Find a seminar in Ft Worth TX
11/11/2019-11/13/2019 in Houston, TX         Find a seminar in Houston TX
11/11/2019-11/13/2019 in San Antonio, TX         Find a seminar in San Antonio TX

Utah (Find training in Utah)
10/21/2019-10/23/2019 in Salt Lake City, UT         Find a seminar in Salt Lake City UT
12/16/2019-12/18/2019 in Salt Lake City, UT         Find a seminar in Salt Lake City UT

Virginia (Find training in Virginia)
11/18/2019-11/20/2019 in Alexandria, VA         Find a seminar in Alexandria VA
11/18/2019-11/20/2019 in Fairfax, VA         Find a seminar in Fairfax VA
11/18/2019-11/20/2019 in Norfolk, VA         Find a seminar in Norfolk VA
11/18/2019-11/20/2019 in Richmond, VA         Find a seminar in Richmond VA
11/18/2019-11/20/2019 in Williamsburg, VA         Find a seminar in Williamsburg VA

Washington (Find training in Washington)
10/21/2019-10/23/2019 in Seattle, WA         Find a seminar in Seattle WA
12/16/2019-12/18/2019 in Seattle, WA         Find a seminar in Seattle WA
10/21/2019-10/23/2019 in Spokane, WA         Find a seminar in Spokane WA
12/16/2019-12/18/2019 in Spokane, WA         Find a seminar in Spokane WA

Wisconsin (Find training in Wisconsin)
10/21/2019-10/23/2019 in Milwaukee, WI         Find a seminar in Milwaukee WI
12/16/2019-12/18/2019 in Milwaukee, WI         Find a seminar in Milwaukee WI