The focus of this 1 day instructor-led course is on empowering users to consume data and visualize them through Power BI by extracting, shaping, formatting and transforming the raw data from various data sources. This course helps you get started with Power BI for your business.
Date: 8th November 2023
Time: 9am – 5pm
Venue: Fedelis Office, Petaling Jaya
| Training Outline: |
| 9:00am-5:00pm |
| Section 1: Introducing to Power BI This session introduces self-service BI with Microsoft Power BI. · Introduction to Power BI · Walkthrough of Power BI Key Features and Functionalities
|
| Section 2: Data Gathering in Power BI This section describes how to extract, shape and combine data from various data sources. · Extract data from Excel Data Source. · Extract data from SQL Server Database. · Shaping and Combining Data.
|
| Section 3: Data Modeling in Power BI This section describes how to model data, create relationship and use of some DAX functions. · Model Relationships. · Introduction to DAX Queries. · Calculations and Measures.
|
| Section 4: Data Visualization in Power BI This module describes how to visualize the modeled, shaped and clean data as dashboard or report. · Creating PowerBI Reports. · Upload PowerBI Reports on PowerBI Service. · Create PowerBI Dashboard.
|
Rico Ho is the founder of CRN Solutions, a Microsoft ISV partner that won MSC APICTA awards twice under the category of tools, applications, and infrastructure.
As a Lotus Notes compete specialist, he has helped some of the biggest brands (e.g Amway, BMW, Coca Cola, Daikin & etc) to migrate thousands of business applications to SharePoint.
Check out his work at https://webparts360.wordpress.com/ and tap into his experience for ideas on how to get more value out of Office 365!
