Course Description
Data analysis helps organizations big and small to gain quick insight into data for informed decisions. With a huge amount of data that is generated on a daily basis, organizations are constantly looking for an experienced data analyst that can help them create dashboards that speak insight.
- At the end of this course, students will be able to:
- Know the ETL process concept in Data warehousing and Business Intelligence
- Know how to work with Power BI for data analysis.
- Know how to work with Measures, Visualizations, and Dashboards
- Learn how to work with various visualizations in Power BI
- Know the Power BI ecosystems
- Know how to clean and transform data in Power BI
- Know-how to model data with practical data.
Course Content
Module 1:
Data analysis fundamentals with Power BI
- What data analysis is and how it is different from data science
- Types of data and Analytics
- Understanding Power BI ecosystems
- Understanding the Power BI ETL process
- Understanding Power BI environment
- Connecting to Data Source (Get Data)
- Explaining the different data sources
- What is the Query Editor or Power Query?
- Connecting Power BI Desktop to Data Sources
Module 2:
Data Transformation, Power Query, and DAX
- How to get data into Power BI – Knowing whether to Load or Transform
- Formatting data (changing data types)
- Formatting data (removing nullability)
- Formatting data (Changing columns)
- Understanding facts and dimensions table
- How to create a relationship
- Understanding the different types of relationship – one-one, one-many, and many-many relationship
- Understanding calculated fields
- How to create measures
- How to organize measures in a table
- How to work with sum, sumx, count, countrows, min, max, divide function
- How to Pivot and Unpivot data column
- How to work with time Intelligence (creating date tables)
Module 3:
Data Visualizations with charts
- How to work with Cards
- How to work with Pie Chart
- How to work with Stacked bar Chart
- How to work with matrix table
- How to work with the bar chart
- How to decide which chart to use for your visuals
- How to work with slicers
- How to format visual
- How to work with clustered charts
Module 4:
Capstone project, creating dashboard
- How to prepare your dashboard
- How to create a dashboard
- How to design dashboard by adding images and login
- How to publish your dashboard
- Publishing dashboard (from Power BI Desktop to Power BI service for consumption)
- Understanding the concept of Workspaces
Workplan
Day 1
The activities for day 1 will include;
- Registration of participants with their training materials.
- The class starts with module 1 which is Data analysis fundamentals with Power BI
- Tea break
- Continuation of class
- Lunch and closing session
Day 2
The class continues with its activities as follows;
- A recap on the previous class
- Module 2 is Data Transformation, Power Query, and DAX
- Tea break
- Continuation of class
- Lunch and closing session
Day 3
The class continues with its activities as seen below;
- Recap on a previous class
- Data Visualizations with charts
- Tea break
- Continuation of class
- Lunch and closing session
Day 4
This is the final day of the training session. The activities are as follows;
- Recap of previous classes
- Capstone project, creating dashboard
- Tea break
- Continuation with hands-on lab training
- Lunch
- Handling of certificates to participants
- Closing session