en

Power BI Masterclass

Power BI Masterclass

Microsoft Power BI Masterclass

Power BI is Microsoft’s latest business intelligence (BI) and data visualization tool that enables you to quickly develop stunning interactive dashboards that bring your data to life, and enable you to monitor your business on every device.

This Masterclass is designed to teach IT Professionals how to manage their Power BI and give a good understanding of data analysis with Power BI. This masterclass consists of 2 separate trainings; (1) basic level and (2) advanced level. You need to register separately for both.

Objectives

After this training, you’ll know how to:

  • Import data via queries
  • Use queries to transform data into usable, meaningful tables
  • Create a data model with relationships, custom sorting, a date dimension table, etc.
  • Create a report in a Power BI Desktop environment
  • Use clever tips & tricks to spruce up your reports with bookmarks and tooltips
  • Use the various filter options, such as slicers, visual level filters and page level filters
  • Use report level filters and drill through filters
  • Set up interactions between charts
  • Create a dashboard in a Power BI Service environment
  • Share reports and dashboards with colleagues
  • ...

 

Audience profile

Everyone who wants to learn the basics of how to create and share reports and dashboards with Power BI.

  • Everyone who play with Data
  • Developer, IT Professionals, Subject Matter Experts, Business Analyst, Solution Architects
  • Project Manager, Business Executives, CIO and CEO

 

Requirements

  • You should know terms Query, Excel :)

 

Content

Start your learning journey with this sequenced collection of courses, and understand the extensive and powerful capabilities of Microsoft Power BI.

Power BI Masterclass - Basic Level

Price per course US$800 | 8:30 AM - 5 PM

 

Part 1 Introducing the Power BI Ecosystem

  • Desktop, Service and Mobile
  • Installing and setting up Power BI
  • Setting up a MS Power BI account

 

Part 2 Getting started with Power BI Desktop

  • Visualization and Fields Panes
  • Create visualizations with Report View
  • Sort and format data with Data View

 

Part 3 Power BI Desktop and Data sources

  • How to import from various data sources
  • Connectivity with MS Office apps - Excel, Access
  • Using other data sources such as databases and CSV Files

 

Part 4 Power BI Desktop to create Data Models

  • Getting to grips with the Data Model
  • Using the Relationship View
  • Many-to-one relationships
  • Filter propagation

 

Part 5 Power BI Service Publishing

  • Report publishing to PowerBI.com
  • Dashboards
  • Quick Insights
  • Data searching with Q&A

 

Part 6 Power BI Service and Importing Cloud-based Data

  • Google Analytics
  • OneDrive
  • Azure SQL Websites and Databases

 

Part 7 Power BI Service and Excel PowerPivot

  • Creating a PowerPivot Data Model
  • Import data from PowerPivot to Power BI Service
  • Using PowerPivot data to create visualizations in Power BI Service

 

Part 8 Sharing Data with Power BI

  • Share interactive Power BI dashboards
  • Share through Power BI, PowerPoint, the web and other mediums
  • Content Packs

 

Power BI Masterclass - Advanced Level

Price per course US$800 | 8:30 AM - 5 PM

 

Part 1 Power BI Desktop for Visualisation Workshop

  • Adding visualisations to Report Canvas
  • Managing visualisation relationships
  • Drill Down and Drill through techniques
  • Use of Hierarchies
  • Importing and using custom visualisations

 

Part 2 Power BI Desktop and DAX

  • Custom calculation and the Data Model
  • Calculated Columns and Measures
  • Evaluation Context
  • CountRows and DistinctCount Functions

 

Part 3 Power BI Desktop and Advanced DAX functions

  • SUMX and CALCULATE
  • Time Intelligence functions
  •  

Part 4 Power BI Desktop and Queries

  • Data import and the role of Queries
  • ETL: Extract, Transform and Load
  • Data transformations
  • Using Applied Steps
  • Query Parameters

 

Part 5 Refreshing Data

  • Refreshing data manually
  • Scheduled Refresh
  • Personal Gateway
  • Enterprise Gateway

 

Part 6 Power BI on Mobile Devices

  • Meeting different mobile clients' requirements
  • Windows 10, Ipad, Android and Tablet

Upcoming classes

April 6, 2020 Power BI Masterclass - Basic Level - Register here

April 8, 2020 Power BI Masterclass - Advanced Level  Register here

Location: Microsoft Teams | Type: Online Instructor-Led | Time: 8 AM - 5 PM

Interested to learn more about Power BI?

Interested to learn more about Power BI?

Register today

Share This Story, Choose Your Platform!