What you'll learn
-
Be comfortable with importing data from several sources in Power BI.
-
Cleaning and Transforming Data using the Power Query tool to get it ready for analysis.
-
Perform Data Analysis including Summarizing Data, Creating New Measures/Variables, Identifying Outliers, etc.
-
Visualize Data through interactive reports in Power BI through several relevant visualizations such as bar charts, pie charts, tables, histograms, maps, etc.
-
Apply relevant filters and slicers on the data to visualize data disaggregated by location, gender, and other relevant socio-economic and administrative clusters and strata.
Course Description
This training course on Power BI will enable participants to import, transform, analyze, and visualize data from diverse sources to draw powerful insights that can be used for storytelling through data and informing data-driven decision-making.Â
What is Power BI? – Power BI is an interactive data visualization software product developed by Microsoft with a primary focus on business intelligence. Many online learning platforms including Coursera rate Power BI as the best and most sellable data visualization tool.Â
In addition to its use for business intelligence, Power BI is immensely popular with data scientists who work with data.Â
Why Power BI? – Power BI is one the best tool for data analytics and ad-hoc data analysis. Power BI compared to other tools has many advantages and is very simple to use. End users do not need to have technical knowledge and skills to create advanced reports and dashboards.
Course Content
Week 1: Basics of Power BI: The First Professional ReportÂ
This module will introduce students to Power BI, explain the interface, and enable them to make a professional-looking Power BI report.Â
- Installing Power BI
- Importing data from diverse sources
- Creating a basic report using bar charts, pie charts, tables, histograms, maps, etc.
Week 2: Data Analysis, Manipulation and Filtering
This module will teach students how to detect outliers, use sources from the open web, and create mapsÂ
- Creating measures and calculated columns
- Filtering data in a report
- Using slicers, dynamic filtering of a reportÂ
- Introduction to DAX
Week 3: Using DAX in Power BIÂ
This module will introduce students to Data Analysis Expression (DAX) and cover the most commonly used DAX formulas in Power BI.
- Using DAX to solve complex data problemsÂ
- Visualizing cross sections of data
Week 4: Advanced/More Topics in Power BI
This module will teach students how to detect outliers, use sources from the open web, and create mapsÂ
- Detect outliers in data by coding dynamic slicers into a report using DAX
- Import Data from web sources (Wikipedia etc.) and create visuals and maps
Assessment Tools
- In-class guided practiceÂ
- 3 online quizzesÂ
- 1 Graded Course Project
Certification will be provided on the basis of attendance and class performance.
Trainer
Raja Rafi Ullah
Raja Rafi Ullah is a Research Fellow at the Pakistan Institute of Development Economics (PIDE). He holds a Master’s Degree in Public Administration from Cornell University where he majored in Economics & Finance.Â
Frequently Asked Questions
No. This is a progressive learning course, so one-week enrollment is not allowed.
Yes, this is a 100% online course.
Power BI is a powerful yet easy-to-use software that can help people from a range of different industries to create powerful visualization using data from diverse sources. You will be able to take your professional reports and presentations up by several notches!
There are no prerequisites. However, if participants have prior experience working with MS Excel and Spreadsheets, they will be able to take the most out of this course.
Students, professionals, and academicians.
Yes, but there are a few conditions. You must complete all the assignments, have at least 75% attendance, and have scored reasonably well on your quizzes & final course project. This is just for us to ensure that you can grasp the fundamentals of Power BI before we certify you.