
Overview
Power BI Bootcamp (Superuser) Class is a fast-paced bootcamp designed to get professionals up to speed on building and deploying custom business intelligence solution using Microsoft’s Power BI Platform.
Training participants will work through in-depth, hands-on lab exercises to jumpstart your experience in creating custom BI solutions. The course also teaches participants about the skills and techniques in implementing a Power BI project through its lifecycle from the desktop to the cloud and mobile environments
Target Audience
- Chief Data Officer/s
- Data Scientist
- C-Level & Business Users
- Roles that deliver simple to heavy reporting analytics within the organization
Mode of Delivery: Virtual (12 hours). All virtual classes are done via Microsoft Teams or Zoom.
Face-to-face (F2F) training is available upon request but has a different rate from our virtual class cost.
Course Outline
I. Introduction to Microsoft Power BI
II. Power BI Overview
a. Power BI Desktop
b. Power BI Service
c. Power BI Mobile
III. Get Data
a. Connect to data source in Power BI Desktop
b. Enter Data in Query Editor
c. Clean and transform data using Query Editor
d. Load data to Power BI Desktop
e. Data refresh using Power BI Desktop
IV. Data Model
a. Manage relationship
b. Basic DAX syntax
c. Calculated column and measure
V. Reports and Visualization
a. Page layout and formatting
b. Fields, Format and Analytics
c. Create Reports using default visual
d. Custom visualization in Marketplace
e. Publish to Power BI Cloud
VI. Power BI Service
a. Reports and dataset
b. Create and configure dashboard
c. Share dashboard within organization
VII. Q&A
I. Power BI Desktop
a. Data Preparation using Query Editor
i. Analyze data source
ii. Get data
iii. Clean and transform data
iv. Merge and append
v. Load to Power BI Desktop
b. Data Model using Relationship and Data view
i. Create relationship
ii. Hide unnecessary table and fields
iii. Create calculated column and measures
iv. DAX Function
c. Report Design using Report canvas
i. Creation of reports
ii. Textbox, Image, and Shape
iii. Tables and Visual
iv. Hierarchies and Groups
v. Drilldown and Drill through capabilities
vi. Tooltip
vii. Forecasting
II. Publish to Power BI Service
III. Q&A
I. Power BI Service
a. Navigation of Power BI Service
b. Manage Dataset
i. Create New Report
ii. Settings
iii. View Related
c. Manage Report
i. Usage Metrics
ii. Quick Insight
iii. Settings
iv. Report View
d. Manage Dashboard
i. Create Dashboard
ii. Share Dashboard
e. App Workspace
i. Create Group Workspace
ii. Publish App
iii. Manage App
f. On-Premise Gateway
i. Manage Gateway
ii. Table Mapping
iii. Schedule Refresh
g. Security
i. Role Level Security
ii. Workspace Security
iii. App Security
h. Power BI Administrator
i. Power BI Developers
i. Power BI Community
ii. Power BI Blog
iii. Power BI Ideas
iv. Meet Up Event
j. Q&A