Duration: 120 Minutes
Course Objectives:
By the end of this course, participants will be able to:
- Understand the key features of Power BI Desktop.
- Import, transform, and clean data in Power BI Desktop.
- Create basic visualizations and dashboards.
- Develop a simple Power BI report.
- Share insights through Power BI Service (brief introduction).
Course Outline:
Introduction to Power BI Desktop
- Power BI Desktop vs Power BI Service
- What is Business Intelligence
- System requirements and setup
- Exploring the Power BI Desktop Interface
Connecting to Data Sources
- Excel, CSV, Databases (SQL, Access), Online Services, etc.
- Connecting Power BI Desktop to an Excel Dataset
Data Transformation with Power Query Editor
- Cleaning data: removing duplicates, handling null values
- Renaming columns, filtering data, appending and merging tables
- Creating calculated columns and custom fields
Creating Visualisations in Power BI
- Using Cards, Charts and Tables
- Other Visualizations
Creating and Publishing Reports
- Using slicers and filters
- Adding multiple pages to a report
- Publish to Power BI Service
- Sharing Reports with Others
Materials Provided:
- Courseware (Manual and Handouts)
- Course Files
- Post-Course Resources
Requirements:
- Laptop with Power BI Desktop installed.
- Basic understanding of data (spreadsheets, tables, etc.)
