Overview

Power BI Desktop is an element of Microsoft tools that enables an individual to publish and analyze data from numerous sources. It is a report-authoring tool that enables its users to utilize the Query Editor to build data that can be utilized to create visuals, analyze information, and create and publish reports.

Power BI Desktop allows users to connect with data sources, transform data, and create models. Using the Power Query Editor, users can extract crucial information, remove irregularities, and simplify complex data.

Target Audience

This course is specifically catered to meet the needs of individuals aspiring to attain a better understanding of data preparation, data mining, data modeling, and predictive analysis to fulfill their personal or professional goals. Power BI Desktop is suitable for students familiar with basic Microsoft Office applications such as charts and Pivotal Table concepts.

Course Prerequisites

Please note that this course is not suitable for new Excel or database users.

Before enrolling in the Power BI course, it is recommended for students to

• Have an understanding of basic data concepts
• Be able to create, and format chart outputs
• Be able to create formulas using standard aggregate functions
• Be able to apply data processing techniques such as filtering and pivot creation

Learning Outcomes

• Power BI Desktop Concepts and Main Features
• Data Sources compatible with Power BI Desktop
• Connecting Data with Power BI Desktop
• Apply Common Query Tasks to Shape Data in Power BI Desktop
• Explore Data Visualizations
• Work with Report formats and elements

Course Outline

• Introduction
• Power BI Desktop Data Transformation
  • Connecting to database
  • Managing Query Groups
  • Basic Transformation
  • Conditional Columns
  • Query Parameters
• Power BI Desktop Modelling
  • Managing Data Relationship
  • Calculated Columns
  • Optimizing Reports
  • Calculated Measures
  • Hierarchies
  • Calculated Tables
  • Time intelligence
  • Include / Exclude
  • Grouping / Binning
• Power BI Desktop Visualization
  • Introduction
  • Pie and Treemap
  • Filters
  • Bar Chart
  • Analytics Pane
  • Clustering
  • Slicer
  • Focus mode
  • Date Slicer
  • Maps
  • Table and Matrix
  • Waterfall
  • Gauge and card
• Power BI Services
  • Introduction
  • Overview of Dashboards
  • Uploading Power BI Service
  • Quick insights
  • Configuring dashboard
  • Sharing and pinning
  • Custom URL & Title
  • Export to csv and excel
  • Publishing to the web
• Working with Excel
  • Importing data using simple data
  • Excel data model
  • Connecting on OneDrive
  • Analyzing Data in Excel
• Organization Packs, Security and Groups
  • Creating Groups
  • Content Pack
  • Data Classification
  • Row Level security
• Direct Connectivity
  • Connectivity to SQL Azure
  • Connectivity to SQL Database
  • SSAS
• Developer APIs
  • API Console
  • Custom Visuals
  • Power BI Embedded
  • Push Data
• Mobile App
  • Introduction
  • Gallery and Search
  • Layouts
  • Limit Access

Certificate

Attendees will get training certificate after the completion of the course.