Course Outline
MODULE 1: POWER BI
In this section, we will outline what Power BI offers, review the available products and their benefits, and explain how Power BI updates are distributed.
Lessons
- What is Power BI?
- Reviewing the Power BI Product Suite
- Distinguishing Between Products
- Comprehending Power BI Updates
After finishing this module, students will be able to:
- Grasp the concept of Power BI.
- Recognize the differences between products.
- Understand Power BI updates.
MODULE 2: POWER BI DESKTOP
This module reviews the installation steps for Power BI Desktop, explores the interface, discusses supported file types and data sources, and explains data refresh configuration. It also covers available data types and best practices for their usage.
Lessons
- Installing Power BI Desktop
- Navigating the Power BI Desktop Interface
- Using File Types; PBIX vs PBIT
- Inspecting Data Sources
- Discussing Data Refresh
- Understanding Data Types
Lab 2: POWER BI DESKTOP
- Introduction to Power BI
- After completing this module, students will be able to:
- Understand and apply Power BI Desktop installation.
- Understand and apply PBIX and PBIT file types.
- Understand data sources, data refresh, and data types.
MODULE 3: WORKING WITH CSV, TXT AND EXCEL WORKSHEETS
Here, we examine importing, transforming, loading, and manipulating data using CSV, TXT, and Excel Worksheets. Power BI manages these file types effortlessly.
Lessons
- Importing Data
- Transforming Data
- Loading Data
- Append Operations
- Working with Folders and Files
- Using Pivot Tables
Lab 3: WORKING WITH CSV, TXT AND EXCEL WORKSHEETS
- Importing, Transforming, and Loading Data
- Append Operations
- Working with Folders and Files
- Using Pivot Tables
After finishing this module, students will be able to:
- Understand and apply importing, transforming, and loading data.
- Understand and apply append operations.
- Understand and apply working with folders and files.
- Understand and apply using Pivot Tables.
MODULE 4: CONNECTING TO DATABASES
This module explores the process of connecting to databases and examines relationships.
Lessons
- Working with Relational Data
- Understanding Relationships
- Importing from SQL Server Analysis Services Multidimensional and Tabular
Lab 4: CONNECTING TO DATABASES
- Importing From SQL Server and Examining Relationships
- Importing From SSAS Multidimensional
After finishing this module, students will be able to:
- Understand and apply importing from SQL Server and examining relationships.
- Understand relationships.
- Understand and apply importing from SSAS Multidimensional.
MODULE 5: MERGING, GROUPING, SUMMARIZING, AND CALCULATING DATA
In this module, we discuss why merges were previously challenging, how much easier they are to use now, and explore grouping, summarizing, and calculating options.
Lessons
- Understanding Issues with Merges
- Performing Merges
- Grouping Options
- Summarizing
- Calculating
Lab 5: MERGING, GROUPING, SUMMARIZING, AND CALCULATING DATA
- Performing Merges
- Grouping and Summarizing
- Calculating
After finishing this module, students will be able to:
- Understand and apply performing merges.
- Understand and apply grouping and summarizing.
- Understand and apply calculating.
MODULE 6: REPORTING
In this module, we create a report and analyze visualization options.
Lessons
- Creating Reports
- Using the Matrix Visualization
- Using the Map Visualization
- Using the Card Visualization
- Using the Chart Visualization
- Using Slicers
- Publishing to Power BI Online
Lab 6: REPORTING
- Creating Reports
- Using the Matrix Visualization
- Using the Map Visualization
- Using the Card Visualization
- Using the Chart Visualization
- Using Slicers
- Publishing to Power BI Online
- After completing this module, students will be able to:
- Understand and apply creating reports.
- Understand and apply the matrix visualization.
- Understand and apply the map visualization.
- Understand and apply the card visualization.
- Understand and apply the chart visualization.
- Understand and apply slicers.
- Understand and apply publishing to Power BI Online.
MODULE 7: POWER BI ONLINE
In this module, we explore what Power BI Online is, examine its available features, and discuss mobile options.
Lessons
- Introduction to Power BI Online
- Importing Data
- Creating Reports
- Configuring Dashboards
- Sharing Reports and Dashboards
- Exploring Power BI Mobile
Lab 7: POWER BI ONLINE
- Exploring the Power BI Online Interface
- Importing Excel (.xlsx or .xlsm), Comma Separated Value (.csv), and Power BI Desktop (.pbix) Files
- Creating a Report
- Adding Filters to a Report
- Adding KPIs to a Report
- Creating a Dashboard
- Pinning Tiles
After finishing this module, students will be able to:
- Understand and apply exploring the Power BI Online interface.
- Understand and apply importing data.
- Understand and apply creating reports.
- Understand and apply adding filters to a report.
- Understand and apply adding KPIs to a report.
- Understand and apply creating a dashboard.
- Understand and apply pinning tiles.
Requirements
Fundamental knowledge of Excel and Databases
Testimonials (7)
Khobeib was great, so polite, clam and professional. Always willing to help or slow down if needed.
Nicole - Wellington City Council (WCC)
Course - Creating Dashboards Using Microsoft Power BI
the tool itself and what I didn't know about what it could do for us
Sam - Wellington City Council (WCC)
Course - Creating Dashboards Using Microsoft Power BI
The pace, activities and screen mirroring. Power Bi is new to me and I am looking forward to working with it more.
Michelle - Childhood Development Initiative CLG
Course - Creating Dashboards Using Microsoft Power BI
Well aligned with what we need to know and apply in the company. The examples are quite comprehensive.
Gabriel de la Guardia - Desarrollos Hidraulicos de Cancun S.A. de C.V.
Course - Creating Dashboards Using Microsoft Power BI
Machine Translated
In addition to teaching us how to use Power BI, the instructor shared strategies for organizing data, creating visually appealing reports, and provided information sources to keep us updated or expand our knowledge of the topic.
Penelope Cruz Mayo - Desarrollos Hidraulicos de Cancun S.A. de C.V.
Course - Creating Dashboards Using Microsoft Power BI
Machine Translated
It was developed very well, which allowed for a deep understanding and achieving the goal.
Raul Maya Camara - Desarrollos Hidraulicos de Cancun S.A. de C.V.
Course - Creating Dashboards Using Microsoft Power BI
Machine Translated
your kindness
Karina Garcia Mendoza - Desarrollos Hidraulicos de Cancun S.A. de C.V.
Course - Creating Dashboards Using Microsoft Power BI
Machine Translated
