Power BI Training

Explore your data and create interactive reports with the Power BI desktop tool. You will be able to access the data wherever it is, model it and develop customized reports for your business needs.

Request a quote Review training schedules

Learn more about the course below.

Training Options in Washington DC

Customized trainings available in Washington DC contact us at sales@greycampus.com

Power BI training program overview

In this course, you will learn why and how Power BI gives you a complete set of Business Intelligence tools and how to use them for your data analysis purposes to accomplish all the tasks related to your data. You will also learn the Power BI Desktop and its components, how to work in the various aspects of the data model, how to create calculated measures and columns, and many more.

Overview

Skills

Learn how to build connections between distinct tables and design custom visuals using Power BI developer tools and typescript.

The registration process

Once you have completed our simplified enrolment process, you’ll receive an email confirmation with your payment receipt in your registered email ID. You can then access the entire content of the online student portal immediately by logging in to your account on our site. Should you require any assistance please reach out to us via email (support@greycampus.com) or via our online chat system.

The course curriculum

The curriculum for Power BI training course covers following list of broad topics.

  • Understanding Power BI Tools
  • Installing Power BI Desktop and Connecting to Data
  • Working in the Query Editor
  • Working in the Data Model and creating a visualization
  • Workflow in Power BI Desktop
  • Different Views of the Data Model
  • Query Editor Interface
  • Connecting Power BI Desktop to Data Sources
  • Editing Rows
  • Understanding Append Queries
  • Editing Columns
  • Replacing Values
  • Formatting Data
  • Pivoting and Unpivoting Columns
  • Splitting Columns
  • Creating a New Group for Queries
  • The Star Schema
  • Duplicating and Referencing Queries
  • The DIM Region Table
  • Entering Data Manually
  • Merging Queries
  • The DIM AgeGroup Table
  • Creating an Index Column
  • Duplicating Columns and Extracting Information
  • Creating Conditional Columns
  • Creating the FACT Population Table
  • Performing Basic Mathematical Operations
  • Improving Performance and Loading Data into the Data Model
  • Query Editor vs. Data Model
  • Understanding Relationships
  • Editing Relationships
  • Understanding Cardinality
  • Cross Filter Selection and Many-To-Many Relationships
  • Active Properties
  • Understanding the differences between the M-Language and DAX
  • M vs. DAX applied: Calculated Columns
  • DAX - Basic information
  • DAX and Calculated Columns
  • Calculated Columns vs. Measures
  • DAX-Measures
  • DAX-Measures Continued
  • Categorizing Data
  • The Report View interface
  • Creating visualizations
  • Editing interactions and Adding Tooltips
  • Adding data colors
  • Understanding Hierarchies and adding drill-downs
  • Formatting charts and sorting
  • Slicers
  • Adding Treemaps and Tables
  • Applying different Filter Types
  • Creating (Multi-Row) Cards
  • Understanding Combined visualizations and Waterfalls
  • The need for the Power BI service
  • Comparing Power BI Free, Pro, and Premium
  • Logging in to Power BI Service
  • Understanding the Interface
  • Importing Data from Power BI Desktop to Power BI Service
  • The Dataset Menu
  • Working on Reports
  • Dashboards
  • Gateways
  • Personal vs On-Premise Gateways
  • Collaboration features
  • Collaborating in App Workspaces
  • Sharing results
  • Content Packs from Online Services
  • Power BI Mobile: the Mobile App
  • Excluding Datasets from sharing
  • Importing JSON Data
  • Importing Data from REST APIs
  • Importing Data from an SQL Server
  • Custom Visuals
  • Using Data-Driven Documents (D3)
  • Creating & Installing a Certificate
  • Creating and Using a Visual
  • Installing an IDE (Code Editor)
  • Understanding the visuals.ts File
  • Understanding the Project Structure
  • Installing d3.js (Data-Driven Documents)
  • Adding the First Shape
  • Connecting Shapes to Data
  • Scaling Shapes
  • Managing Visual Capabilities to Allow Data Input
  • Starting the Data Extraction
  • Limiting the Data Input
  • Extracting Data
  • Displaying the User Data
  • Optimizing the Code
  • Adding Dynamic Coloring
  • Making Bars Selectable (Cross-Visual)
  • Adding X-Axis Labels
  • Adding Custom Visuals Settings
  • Extracting the Visual Configuration
  • Informing Power BI About the Custom Configuration
  • Packaging the Custom Visual