Jul 31, 2019

    Microsoft Power BI Introduction Live Hands-On Instructor-Led Training Class

    Microsoft Power BI Introduction Live Hands-On Instructor-Led Training Class

    Baltimore, Maryland, Virginia, Washington D.C., & On-Site at Your Location

    Print this Page
    Course Information & Why You Should Attend

    ThinkB!G Exclusive LogoDuration & Times: 2 Days – 8:30AM-3:00PM ET / 5:30AM-12:00PM PT (30 Minute Complimentary Lunch)

    Locations for Training:
    In Person at ThinkB!G in Columbia, Maryland near Baltimore, Washington D.C., Virginia region.
    Upon Request: Onsite Custom Private Training at Your Location!

    Course Description: In this hands-on, two-day Microsoft Power BI Introduction class, you will work to become familiar with Power BI and be introduced to basic relational data concepts and work with relationships between tables in your data. This course will cover working with reports and visualizations, creating reports that connect to data and visuals, shape and transform data with queries, and model data with DAX functions.

    Prerequisites: Students must have a good working knowledge of computers, operating systems, using a mouse, keyboard, standard menus and commands. Students must be able to open, save, and close applications, files, as well as navigate to other folders. 

    Job Roles That Use Power BI:
    Data Architects
    Data/Business Analysts
    Developers

    Uses for Power BI:
    Data Analytics & Trends
    Data Visualization

    Microsoft Power BI Introduction Course Outline

    1. Power BI Overview
    What Is Power BI?
    Power BI Desktop
    Power BI Working Environment
    Startup Screen
    The Ribbon
    Views
    Overview of Relational Database Concepts
    Preview Features

    2. Working with Power BI Reports and Visualizations
    Power BI Reports
    Connecting to Data
    Report Templates
    Interacting with Visualizations
    Focus Mode
    Sorting and Filtering
    Natural Language Queries
    Date Hierarchies
    Date Tables
    Drilling in Reports/Dashboards

    3. Creating Reports
    Using Power BI to Create a Report
    Report Creating and Publishing Overview
    Connecting to Data
    Supported Data Sources
    Refreshing Data
    Creating and Formatting Visualizations
    Adding Visualizations
    Formatting Visualizations
    Conditional Formatting
    Filtering with Report/Page/Visual-level Filters

    4. Shaping and Transforming Data with Queries
    What Is a Query?
    Introduction to the Query Editor
    Transform tab
    What can I do in the Query Editor?
    Applying query actions
    Common Actions in the Query Editor
    Use Dropdowns to Sort and Filter
    Apply the correct Data Types
    Apply a Filter or Sort Order
    Replace Values
    Remove What You Don’t Need
    Make the Data “Human Friendly”
    Combine Two or More Columns Into a New Column
    Group Column Values
    Applied Steps
    Advanced Editor

    5. Modeling Data
    Creating Measures and Calculated Columns
    Measures and Calculated Columns
    Aggregations
    Moving a Measure
    Quick Measures
    Using DAX
    Introduction to Data Analysis Expressions (DAX)
    DAX Syntax
    The Matrix Visualization
    DAX Functions 

    Disclaimer: All course objectives and outlines are used as a guideline and are subject to change to ensure the latest information is covered to support real world use of the technology.

    Software Versions: ThinkB!G open enrollment classes are taught on the most current version of software whenever possible. To request a specific version, please Contact Us or call us at 301-362-2250.

    What You Get
    • Hands-On Official Authorized Training & Certification
    • Training Delivered from Instructors that are Senior Consultants Certified by Adobe (ACI), Apple (ACT), & Microsoft (MCT)
    • Official Curriculum Print and/or Digital Courseware & Personal Use of Class Recording for Limited Time
    • Certificate of Completion
    • Computer (Apple Mac or Windows PC) with Software & Class Files (In Person Only)
    • Continental Breakfast Every Day (In Person Only)
    • Catered Gourmet Deli Lunch Every Day (In Person Only)
    • Unlimited Snacks and Refreshments (In Person Only)
    • Notebook & Pen (In Person Only)
    • Free Parking (In Person Only)
    Pricing

    Public Enrollment Training

    Commercial Price Per Person 2-Day Class: $795
    GSA/Government Price Per Person 2-Day Class: $640.81
    Non-Profit/Education Price Per Person 2-Day Class: $745

    Dates to Register!

     

    Custom Private Training – Onsite at Your Location, Online Live, or at ThinkB!G

    Submit details and a formal training quote will be sent to you!

    Click to Get a Quote Now!

    Dates to Register

    CourseLocationStart DateEnd DateTime
    Power BI - Intro

    ThinkB!G (Columbia, MD) - In Person Only

    		 Monday, Apr 13, 2020 Tuesday, Apr 14, 2020 8:30 am - 3:00 pm Register
    Power BI - Intro

    ThinkB!G (Columbia, MD) - In Person Only

    		 Wednesday, Jun 10, 2020 Thursday, Jun 11, 2020 8:30 am - 3:00 pm Register
    Power BI - Intro

    ThinkB!G (Columbia, MD) - In Person Only

    		 Wednesday, Aug 12, 2020 Thursday, Aug 13, 2020 8:30 am - 3:00 pm Register
    Power BI - Intro

    ThinkB!G (Columbia, MD) - In Person Only

    		 Thursday, Nov 12, 2020 Friday, Nov 13, 2020 8:30 am - 3:00 pm Register

    Custom Private Training

    We offer this course as Custom Private Training or Project Based Training®!

    If you have a team of individuals, you can receive bulk discounts by doing your own Private training session & cover your specific learning objectives! We can have the Private Training at ThinkB!G in Columbia, Maryland, Virtually Online Live (Available for Most Courses), or Onsite at Your Location.

    What's Included?

    • Custom Outline to include Targeted Topics Based on Your Learning Needs
    • Hands-On Official Authorized Training & Certification
    • Training Delivered from Instructors that are Senior Consultants Certified by Adobe (ACI), Apple (ACT), & Microsoft (MCT)
    • Official Curriculum Print and/or Digital Courseware
    • Certificate of Completion
    • Computer (Apple Mac or Windows PC) with Software & Class Files (In Person Only at ThinkB!G)
    • Continental Breakfast Every Day (In Person Only at ThinkB!G)
    • Catered Gourmet Deli Lunch Every Day (In Person Only at ThinkB!G)
    • Unlimited Snacks and Refreshments (In Person Only at ThinkB!G)
    • Notebook & Pen (In Person Only)
    • Free Parking (In Person Only at ThinkB!G)

    Submit details and a formal training quote will be sent to you! 

    Click to Get a Quote Now!

    Policies

    Payment Policy for Public Enrollment Classes

    Payment and/or Purchase Order is required 16 Business Days (Monday-Friday) prior to first date of training class.

     

    Payment Policy for Private & Project Based Training® Classes

    Payment and/or Purchase Order is required 16 Business Days (Monday-Friday) prior to first date of training service.  Pricing provided is firm fixed price based on number of students.  Client is responsible for entire amount regardless of change in number of registrations.

     

    Cancellation/Rescheduling Policy for Public Enrollment Classes

    • Classes may be canceled if less than 4 students are registered. We will notify you of cancellations no later than 16 business days prior to class.
    • Canceling/Rescheduling more than 16 business days prior to class: You are eligible for a refund or free reschedule. Registration is transferable to another student for the same class & date.
    • Canceling/Rescheduling less than 16 business days prior to class: No refund. No Reschedule. Registration is transferable to another student for the same class & date.
    • No Shows without contact: No refund. No Reschedule.

    Cancellation/Rescheduling Policy for Custom/Private and On-Site Training Classes

    • No penalty if cancellation/reschedule is 16 Business Days (Monday-Friday) prior to the first date of class.
    • 50% penalty will be incurred if cancellation/reschedule is less than 16 Business Days (Monday-Friday) prior to the first date of class. This fee is to cover instructor expenses, travel, and course materials purchased.

    Cancellation/Rescheduling Policy for Individual Students in Custom/Private Training Classes

    • Individual students registered in a private class, who cancel or do not show, are not eligible for a partial refund or reschedule. Please contact your class organizer or manager if you need to cancel.