Overview
Power BI training course is a perfect introduction for you into the world of BI. You will learn the basics of Power BI such as the Power BI desktop, and how to connect to data using Power BI desktop
Objectives
At the end of Power BI training course, participants will learn
Prerequisites
Participants are expected to have an understanding of how data works and how it can contribute to building a business to attend the Power BI training classes.
Course Outline
- Guided Learning for Power BI
- Using Power BI
- Building Blocks of Power BI
- A quick look at the Power BI service
- Getting Started with Power BI Desktop
- Connect to Data Sources in Power BI Desktop
- Clean and Transform your data with the Query Editor
- More Advanced Data Source and Transformation
- Type natural-language questions about your data on a dashboard
- Cleaning Irregularly Formatted Data
- How to Manage Your Data Relationships
- Create Calculated Columns
- Optimizing Data Models for Better Visuals
- Create measures and work with time-based functions
- Create Calculated Tables
- Explore Time-Based data
- Create and Customize Simple Visualizations
- How to use combination charts
- Create and format slicers
- How to use Map Visualizations
- How to use Tables and Matrixes
- How to use Scatter Charts
- How to use Waterfall and Funnel Charts
- How to use Gauges and Single Number Cards
- How to modify colors in charts and visuals
- Style your Reports with Shapes, Text Boxes and Images
- Page Layout and Formatting
- Duplicate a page report
- Show categories with No Data
- Customize Visuals with Summarization and Category Options
- Arrange the Z-order of Report Elements
- Visual hierarchies and drill down behaviour
- R visuals in Power BI
- The Power BI service
- Create and Configure a Dashboard
- Create Custom Q&A Suggestions
- Share Dashboards with your organization
- Display Visuals and Tiles Full Screen
- Edit Tile Details
- Get More space on your Dashboard
- Install and Configure a personal gateway
- Import and Excel table into Power BI
- Import Excel files with data models and Power View sheets
- Connect One Drive for business to Power BI
- Publish Reports from Power BI Desktop to the Power BI Service
- Print and Export Power BI Dashboard
- Manually Republish and Refresh your Data
- Introducing Power BI Mobile
- Create a group in Power BI
- Create a content pack in Power BI
- Connect to a content pack in Power BI
- Connect to a content pack from group in Power BI
- Edit a content pack in Power BI
- Integrate OneDrive for business with Power BIPublishing and Sharing
- Publish Reports from Power BI Desktop to the Power BI Service
- Print and Export Power BI Dashboard
- Manually Republish and Refresh your Data
- Introducing Power BI Mobile
- Create a group in Power BI
- Create a content pack in Power BI
- Connect to a content pack in Power BI
- Connect to a content pack from group in Power BI
- Edit a content pack in Power BI
- Integrate OneDrive for business with Power BI
- DAX Calculation types
- DAX Functions
- Using Variable in DAX expressions
- Table Relationships and DAX
- DAX Tables and Filtering