Course Methodology
Live online course where participants will be able to interact with
instructor (video and audio), view slides, collaborate with others, comment on
discussions, complete assessments, activities and case studies.
Course Objectives
By the end of the course, participants will be able to:
- Understand features and capabilities of Power BI
- Edit and transform data imported from various
sources and file types using Power Query
- Develop dynamic data visuals and dashboards using
Power BI Desktop version
- Automate data reporting and dashboarding using
Power BI
Target Audience
Business professionals, business analysts, data analysts, research
analysts, finance professionals, marketing and sales professionals, HR
professionals, IT professionals, administrative staff, supervisors, general
business professionals and staff from any function who need to learn and apply
state-of-the-art data analysis techniques to their daily business reporting and
decision making.
Target Competencies
- Creating dashboards
- Reporting, analysis and visualization
- Power BI Desktop Version
- Power Query
Get and transform – Power Query
- Get data from Excel
- Get data from TXT or CSV files
- Get data from web
- Get data from folder
- Transformation
- Pivoting and unpivoting
- Filtering
- Sorting
- Adding/removing columns
- Adding conditional columns
Data visualization – Power BI
- Power BI report view
- Visuals
- Fields
- Basic charts
- Formatting options
- Filtering
- Matrix visuals
- Slicers and timelines
- Cards
- Q&A
- Maps
- Tooltip
- Drill through
- Bookmarks
Working with Data Models and DAX measures
- Explicit and Implicit measures
- Creating relationships between tables
- CALCULATE and RELATED functions
- Iterative functions e.g. SUMX, COUNTX, AVERAGEX
