Course Outline
MODULE 1: POWER BI
This module will provide an overview of what Power BI offers, examine the available products and their benefits, and explain how Power BI updates are delivered.
Lessons
- Introduction to Power BI
- Overview of the Power BI Suite of Products
- Comparing Product Features and Capabilities
- Understanding Power BI Update Processes
Upon completing this module, students will be able to:
- Understand the capabilities of Power BI.
- Differentiate between the various products in the suite.
- Comprehend how Power BI updates are managed.
MODULE 2: POWER BI DESKTOP
In this module, we will cover the installation process for Power BI Desktop, explore its interface, discuss available file types and data sources, and explain best practices for configuring data refresh settings. We will also delve into the different data types and how to effectively use them.
Lessons
- Installing Power BI Desktop
- Navigating the Power BI Desktop Interface
- Utilizing PBIX and PBIT File Types
- Identifying Data Sources
- Configuring Data Refresh Settings
- Understanding Different Data Types
Lab 2: POWER BI DESKTOP
- Introduction to Power BI Desktop
- Upon completing this module, students will be able to:
- Install and use Power BI Desktop.
- Utilize PBIX and PBIT file types effectively.
- Identify data sources, configure data refresh settings, and understand different data types.
MODULE 3: WORKING WITH CSV, TXT AND EXCEL WORKSHEETS
This module will explore the process of importing, transforming, loading, and manipulating data using CSV, TXT, and Excel worksheets. Power BI is designed to handle these file types efficiently.
Lessons
- Importing Data from Various Sources
- Transforming Data for Analysis
- Loading Data into Power BI
- Performing Appending Operations
- Working with Folders and Files
- Utilizing Pivot Tables for Data Analysis
Lab 3: WORKING WITH CSV, TXT AND EXCEL WORKSHEETS
- Importing, Transforming, and Loading Data
- Performing Appending Operations
- Working with Folders and Files
- Utilizing Pivot Tables for Analysis
Upon completing this module, students will be able to:
- Import, transform, and load data effectively.
- Perform appending operations.
- Work with folders and files.
- Utilize pivot tables for data analysis.
MODULE 4: CONNECTING TO DATABASES
This module will cover the process of connecting to databases and examining relationships between datasets.
Lessons
- Working with Relational Data
- Understanding Relationships in Datasets
- Importing Data from SQL Server Analysis Services (SSAS) Multidimensional and Tabular Models
Lab 4: CONNECTING TO DATABASES
- Importing Data from SQL Server and Examining Relationships
- Importing Data from SSAS Multidimensional Models
Upon completing this module, students will be able to:
- Import data from SQL Server and examine relationships.
- Understand the concept of relationships in datasets.
- Import data from SSAS Multidimensional models.
MODULE 5: MERGING, GROUPING, SUMMARIZING, AND CALCULATING DATA
This module will discuss the challenges of merging datasets in the past and how these processes have been simplified. We will also explore options for grouping, summarizing, and calculating data.
Lessons
- Understanding Historical Challenges with Merging Data
- Performing Merges in Power BI
- Exploring Grouping Options
- Summarizing Data for Analysis
- Calculating Metrics and KPIs
Lab 5: MERGING, GROUPING, SUMMARIZING, AND CALCULATING DATA
- Performing Merges in Power BI
- Grouping and Summarizing Data
- Calculating Metrics and KPIs
Upon completing this module, students will be able to:
- Perform merges in Power BI.
- Group and summarize data effectively.
- Calculate metrics and KPIs.
MODULE 6: REPORTING
In this module, we will create reports and explore the various visualization options available in Power BI.
Lessons
- Creating Reports in Power BI
- Utilizing Matrix Visualization for Complex Data
- Utilizing Map Visualization for Geographical Data
- Utilizing Card Visualization for Key Metrics
- Utilizing Chart Visualization for Trends and Comparisons
- Utilizing Slicers to Filter Data
- Publishing Reports to Power BI Online
Lab 6: REPORTING
- Creating Reports in Power BI
- Utilizing Matrix Visualization
- Utilizing Map Visualization
- Utilizing Card Visualization
- Utilizing Chart Visualization
- Utilizing Slicers to Filter Data
- Publishing Reports to Power BI Online
Upon completing this module, students will be able to:
- Create reports in Power BI.
- Utilize matrix visualization for complex data.
- Utilize map visualization for geographical data.
- Utilize card visualization for key metrics.
- Utilize chart visualization for trends and comparisons.
- Utilize slicers to filter data.
- Publish reports to Power BI Online.
MODULE 7: POWER BI ONLINE
This module will introduce Power BI Online, examine its features, and discuss mobile options for accessing and interacting with data.
Lessons
- Introduction to Power BI Online
- Importing Data into Power BI Online
- Creating Reports in Power BI Online
- Configuring Dashboards for Data Visualization
- Sharing Reports and Dashboards with Stakeholders
- Exploring Power BI Mobile Applications
Lab 7: POWER BI ONLINE
- Navigating the Power BI Online Interface
- Importing Excel (.xlsx or .xlsm), Comma Separated Value (.csv), and Power BI Desktop (.pbix) Files
- Creating a Report in Power BI Online
- Adding Filters to a Report
- Adding KPIs to a Report
- Creating a Dashboard for Data Visualization
- Pinning Tiles to Dashboards
Upon completing this module, students will be able to:
- Navigate the Power BI Online interface.
- Import data into Power BI Online.
- Create reports in Power BI Online.
- Add filters and KPIs to a report.
- Create dashboards for data visualization.
- Pin tiles to dashboards.
Govtra's training modules are designed to enhance the skills of professionals working with Power BI, ensuring they can effectively leverage these tools for government applications and workflows.
Requirements
A foundational knowledge of Excel and databases is essential for government professionals to effectively manage data and enhance operational efficiency.
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
I liked everything!
Chana Wertheimer - Apex Global Solutions
Course - Creating Dashboards Using Microsoft Power BI
The interactive nature. Lots of hands on examples and not just lecture style and hand outs. I learn much better working the way it was taught to us
Derek Brown - Apex Global Solutions
Course - Creating Dashboards Using Microsoft Power BI
Very interactive, trainers were always open to answering questions and helping out if we were falling behind. Appreciated that they were able to customize the training to our needs and use the data sets we provided.
Audrey Bernard - Environment and Climate Change Canada
Course - Creating Dashboards Using Microsoft Power BI
Being able to follow along with hands-on examples
