|
Kursus Microsoft Power BI For Interactive Reports Training Course |
|
|
|
|
|
|
|
Kursus Microsoft Power BI For Interactive Reports Training Course |
|
|
|
|
|
|
Kursus
Power BI Course Overview:
This Power BI Beginner's course
typically covers the Power BI Architecture Cycle such as Getting Started with
Software Installation and User Interface (UI) of the software. In this Power BI
Beginner's course also will cover the Data Transformation (Power Query for
cleaning, shaping from sources like Excel/Web), Data Modeling (relationships,
cardinality, star schemas), Data Analysis (DAX) (measures, calculated columns),
and Visualization & Sharing (reports, dashboards, slicers, publishing to
the cloud). The core modules focus on Connect, Transform, Model, Visualize &
Share using Power BI Desktop as the main tool.
Kursus Power BI Prerequisites:
MS Office Basic Computer Knowledge.
Kursus Power BI Who should attend:
Power BI is for anyone needing data
insights, from technical data analysts, developers, and BI pros to
non-technical business users in Finance, Sales, Marketing, HR, and Operations,
including managers and executives, because it turns data into actionable
visuals for better decision-making, requiring no prior coding to get started.
Kursus Power BI Course Duration:
Online Google
Meet Course – 2 Full Days (9am-5pm) 16 Hours
Online
Google Meet Live Presentation Hosted by Vixmatech
Kursus Power BI Course Materials:
Power BI Software,
Course Manual Notes PDF, Video Recordings & Certificate of Achievement with
20ccd Points Provided
** RM 450 only per person
Kursus Power BI Software
Installer & Course Manual:
** Power BI Software, Course Manual Notes PDF & Video
Recordings Provided (Send by Google Drive)
The
Trainer:
Mr
Anas Izuddin Bin Mohd Osman B.E.E.
(Hons) Universiti Tenaga Nasional
HRD CORP ACCREDITED TRAINER
Kursus Power BI Course Syllabus:
|
Day One (Data Transformation & Data Modeling) - 9am to 5pm |
||
|
Time |
Topics |
Sub-Topics |
|
9.00am - 11.00am |
Getting Started |
Power
BI Desktop Buttons & Interface |
|
|
With |
Power
BI Desktop User Interface UI Components: |
|
|
Power BI Desktop |
Ribbon,
Views, Canvas, Page Selector, Filters, Visualizations & Fields |
|
|
|
What
is Power BI & Software Components (Desktop, Service, Mobile)? |
|
|
|
|
|
|
|
Comparison
between Power BI and Excel |
|
|
|
Installation:
Downloading and launching Power BI Desktop |
|
|
|
Interface:
Navigate Data, Model, and Report views & Power Query |
|
11.00am - 1.00pm |
Getting Data |
Understanding
Power BI Navigation |
|
|
Into |
Exploring
Different Data Sources in Power BI |
|
|
Power BI Desktop |
Getting
Data from the Web |
|
|
|
Getting
Data from Access File |
|
|
|
Getting
Data from Excel |
|
|
|
Getting
Data from a Text File |
|
|
|
Getting
Data from Database |
|
|
|
|
|
1.00pm - 2.00pm |
Rehat / Break |
Lunch
& Sembahyang Zohor |
|
2.00pm - 3.00pm |
Power BI |
Navigating
Query Editor |
|
|
Data Transformation |
What
is Query? |
|
|
|
What
is Data Transformation? |
|
|
|
Removing
empty rows |
|
|
|
Removing
irrelevant Columns |
|
|
|
Renaming
Columns |
|
|
|
Changing
Data Types |
|
|
|
Duplicating
Columns |
|
|
|
Splitting
& Merging Columns |
|
|
|
Correcting
Spelling Mistakes |
|
|
|
Changing
Cases, Trimming & Cleaning |
|
3.00pm - 5.00pm |
Power BI |
Understand
Navigation of Relationship view |
|
|
Data Modelling |
Creating
and managing relationships between tables (one-to-many, etc.). |
|
|
|
What
is Data Model? |
|
|
|
What
is a unique Identifier? |
|
|
|
Creating
a new relationship |
|
|
|
Editing
a relationship |
|
|
|
Updating
a relationship |
|
|
|
Understanding
Cardinality |
|
|
|
Understanding
Cross Filter Direction |
|
|
|
Why
is Data Model more efficient than a Flattened Data Set? |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Day Two (Data Analysis Expressions DAX & Visual Reports) -
9am to 5pm |
||
|
Time |
Topics |
Sub-Topics |
|
9.00am - 11.00am |
Introduction To |
What
can we calculate using DAX? |
|
|
Data Analysis Expressions (DAX) |
What
are Calculated Columns and Calculated Measure? |
|
|
Power BI's Formula Language |
How
is DAX different from Excel Functions? |
|
|
|
Calculating
a column using DAX |
|
|
|
Calculating
a measure using DAX |
|
|
|
Formatting
Data types |
|
|
|
Changing
property of a Data Type |
|
|
|
Creating
measures for sample model |
|
|
|
Understanding
how the DAX engine calculates measure results |
|
|
|
Understanding
CALCULATE ( ), the most powerful function in DAX |
|
|
|
Creating
measures for sample model using CALCULATE( ) |
|
|
|
Removing
Filters with the ALL( ) function |
|
|
|
Creating
measures for sample model using ALL( ) |
|
|
|
Using
Quick Measures for time intelligence |
|
|
|
Calculated
Columns: Adding new data columns |
|
|
|
Measures:
Creating aggregations (SUM, AVERAGE, etc.) |
|
|
|
Basic
functions like IF, SUMX, COUNT, RELATED & Time Intelligence |
|
11.00am - 1.00pm |
Power BI Data |
Understand
Navigation of Report View |
|
|
Visualization & Reporting |
Creating
and Formatting a Bar Chart |
|
|
|
Creating
and Formatting a Column Chart |
|
|
|
Creating
and Formatting a Line & Area Chart |
|
|
|
Creating
and Formatting a Pie Chart |
|
|
|
Creating
and Formatting a Tree Chart |
|
|
|
Creating
and Formatting a Card |
|
|
|
Creating
and Formatting a Matrix |
|
|
|
Creating
and Formatting a Table |
|
|
|
Creating
and Formatting BubbleMap Visualization |
|
|
|
Creating
a Filled Map Visualization |
|
|
|
Interactivity:
Using Slicers, Filters, Drill-down, and Drill-through |
|
|
|
Dashboards:
Basic notions and pinning visuals |
|
1.00pm - 2.00pm |
Rehat / Break |
Lunch
& Sembahyang Zohor |
|
2.00pm - 3.00pm |
Power BI |
Understanding
Visual Interaction |
|
|
Visual Interaction & Filters |
Turning
visual interaction on and off |
|
|
|
Exploring
Filters |
|
|
|
Cross
Filtering through visuals |
|
|
|
Creating
a slicer |
|
|
|
Visual
level filter |
|
|
|
Page
Level Filter |
|
|
|
Report
Level Filter |
|
|
|
Drill
through the filter |
|
|
Designing Effective Reports, |
Exploring
visual options (focus mode, show data, spotlight, export) |
|
|
Publishing and Sharing |
Create
and Duplicate New Pages |
|
3.00pm - 5.00pm |
|
Create
images, text boxes, and shapes |
|
|
|
Save
the report |
|
|
|
Print
the report |
|
|
|
Publish
report to Power Bi Service |
|
|
|
Pin
visuals from the report to the dashboard |
|
|
|
Difference
between report and dashboard |
|
|
|
Pinning
complete report to Dashboard |
|
|
|
Sharing
dashboard with colleagues |
|
|
|
Designing
Effective Reports |
|
|
|
Professional
layout design for Power BI reports |
|
|
|
Publishing
and Sharing Reports |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
