Microsoft Power BI
Course number: CGIPBI40 - 1 Day (weekdays or on-demand)
This course introduces attendees to the full capabilities of Microsoft Power BI. Designed for business users, analysts, and anyone interested in data visualization, this course helps students go from raw data to compelling, interactive dashboards in just one day.
Course Objectives
In this course, you will gain foundational skills in Power BI that empower you to analyze and present data like a pro. You will learn how to connect to data sources, import and transform data, and build compelling visual dashboards. By the end of the day, you’ll feel confident building and servicing basic Power BI solutions and supporting a culture of data-driven decision-making in your organization.
Prerequisites
- Excel - Data Analysis with Power Pivot, Power BI Data Practitioner or equivalent experience
Target Audience
This course is ideal for Power Users, individuals evaluating the use of Power BI within their organization, or those who have already implemented Power BI and need guidance in data transformation and model creation to build effective dashboards. Attendees should have some experience with Power BI and want to enhance their skills in creating impactful, data-driven visualizations.
Course Outline
- What is Power BI?
- The Power BI workflow
- Power BI components overview
- Connect to Excel, databases, and cloud services
- Understanding data models
- Hands-on: Importing sample data
- Introduction to Power Query
- Cleaning and shaping data
- Hands-on: Transforming messy data
- Using charts, tables, and filters
- Custom visuals and layout tips
- Hands-on: Designing a dynamic dashboard
- Publishing to the Power BI Service
- Creating dashboards and sharing reports
- Best practices for self-service BI
Live Online