QuickStart to Power BI for Analysts and Users

Gain an essentials understanding of the features and benefits of Power BI for your data analysis actions.

    Nov 2 2020

    November 2 - 3, 2020 | 10:00 AM - 6:00 PM (EST) | Virtual Classroom Live

    Date: 11/02/2020 - 11/03/2020 (Monday - Tuesday) | 10:00 AM - 6:00 PM (EST)
    Location: ONLINE (Virtual Classroom Live)
    Delivery Format: VIRTUAL CLASSROOM LIVE Request Quote & Enroll

    Success! Your message has been sent to us.
    Error! There was an error sending your message.

    REQUEST MORE INFO:


    QuickStart to Power BI for Analysts and Users

    November 2 - 3, 2020 | 10:00 AM - 6:00 PM (EST) | Virtual Classroom Live


    How Did You Hear of Global IT Training?

    Join Our Email List?

    Dec 14 2020

    December 14 - 15, 2020 | 10:00 AM - 6:00 PM (EST) | Virtual Classroom Live

    Date: 12/14/2020 - 12/15/2020 (Monday - Tuesday) | 10:00 AM - 6:00 PM (EST)
    Location: ONLINE (Virtual Classroom Live)
    Delivery Format: VIRTUAL CLASSROOM LIVE Request Quote & Enroll

    Success! Your message has been sent to us.
    Error! There was an error sending your message.

    REQUEST MORE INFO:


    QuickStart to Power BI for Analysts and Users

    December 14 - 15, 2020 | 10:00 AM - 6:00 PM (EST) | Virtual Classroom Live


    How Did You Hear of Global IT Training?

    Join Our Email List?

Introduction to Self-Service BI Solutions

  • 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
  • Hands-on: Exploring an Enterprise BI solution
  • Viewing reports
  • Creating a Power BI report
  • Creating a Power BI dashboard

Introducing Power BI

  • Power BI
  • The Power BI service
  • Hands-on: Creating a Power BI dashboard
  • Connecting to Power BI data
  • Create a Power BI dashboard

Power BI Exploration

  • 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
  • Hands-on: Importing data into Power BI
  • Importing Excel files into Power BI
  • Viewing reports from Excel files

Shaping and Combining Data

  • Power BI desktop queries
  • Shaping data
  • Combining data
  • Hands-on: Shaping and combining data
  • Shape power BI data
  • Combine Power BI data

Modelling data

  • Relationships
  • DAX queries
  • Calculations and measures
  • What is DAX (Overview)
  • What is DAX (Tabular)
  • Creating Calculated Columns (Basics)
  • Navigation Functions
  • Conditional and Logical Functions
  • Creating Calculated Measures
  • Time Intelligence (Overview)
  • Time Intelligence (Time Intelligence Functions)
  • Using X-Functions and A-Functions
  • Table Functions
  • DAX as a Query Language
  • Hands-on: Let’s Model Data
  • Create relationships
  • Calculations

Interactive Data Visualizations

  • Creating Power BI reports
  • Managing a Power BI solution
  • Hands-on: Creating a Power BI report
  • Connecting to Power BI data
  • Building Power BI reports
  • Creating a Power BI dashboard

Managing Power BI web interface

  • Creating reports and referencing data sets
  • Managing Power BI web
  • Creating dashboards via web
  • Creating Basic Reports with the Power BI Desktop
  • Creating Interactive Reports (Adding Slicers for Filters)
  • Creating Interactive Reports (Visualizing Tabular Data)
  • Creating Interactive Reports (Visualizing Categorical Data)
  • Creating Interactive Reports (Visualizing Data Trends)
  • Creating Interactive Reports (Visualizing Categorical and Trend Data Together)
  • Creating Interactive Reports (Visualizing Geographical Data with Maps)
  • Creating Interactive Reports (Visualizing Goal Tracking)
  • Creating Interactive Reports (Using Custom Visuals)
  • Creating Interactive Reports (Digital Storytelling)
  • Creating Interactive Reports (Other Features)
  • Using the Power BI Service (Deploying to the Power BI Service)
  • Using the Power BI Service (Creating and Sharing Dashboards)
  • Using the Power BI Service (Using Power BI Q&A)
  • Using the Power BI Service (Setting up App Workspaces)
  • Using the Power BI Service (Subscriptions and Alerts)
  • Using the Power BI Service (Excel Integration)
  • Using the Power BI Service (Export and Embed Options)
  • Refreshing the Data (Refreshing Data Overview)
  • Refreshing the Data (Installing the Data Gateway)
  • Refreshing the Data (Scheduling a Data Refresh)
  • Mobile BI (Power BI Mobile Overview)
  • Mobile BI (Designing Reports and Dashboards for Mobile)
  • Mobile BI (Interacting with the Power BI Mobile App)

Join an engaging hands-on learning environment, where you’ll learn:

  • Perform Power BI desktop data transformation
  • Describe Power BI desktop modeling
  • Create a Power BI desktop visualization
  • Implement the Power BI service
  • Describe how to connect to Excel data
  • Describe how to collaborate with Power BI data
  • Connect directly to data stores
  • Describe the Power BI developer API
  • Describe the Power BI mobile app
  • Manage Power BI for the web

This course has a 50% hands-on labs to 50% lecture ratio with engaging instruction, demos, group discussions, labs, and project work.

Before attending this course, you should have:

  • A general knowledge of database concepts (fields, records, relationships)
  • Awareness of key business priorities such as revenue, profitability, and financial accounting
  • Comfort when using Excel

 

Business Analyst, Data Analysts, Data Scientist, or professionals responsible for reporting on your organization's data.

Ready to Advance Your Career?

CONTACT US NOW!