Bariansystems Limited

Data Analysis with Power BI

Barian Academy

Data analysis with Power BI

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

  1. What data analysis is and how it is different from data science
  2. Types of data and Analytics
  3. Understanding Power BI ecosystems
  4. Understanding the Power BI ETL process
  5. Understanding Power BI environment
  6. Connecting to Data Source (Get Data)
  7. Explaining the different data sources
  8. What is the Query Editor or Power Query?
  9. Connecting Power BI Desktop to Data Sources

Course Content: Module 2:
Data Transformation, Power Query, and DAX

  1. How to get data into Power BI – Knowing whether to Load or Transform
  2. Formatting data (changing data types)
  3. Formatting data (removing nullability)
  4. Formatting data (Changing columns)
  5. Understanding facts and dimensions table
  6. How to create a relationship
  7. Understanding the different types of relationships – one-one, one-many, and many-many relationship
  8. Understanding calculated fields
  9. How to create measures
  10. How to organize measures in a table
  11. How to work with sum, sumx, count, countrows, min, max, and divide function
  12. How to Pivot and Unpivot data column
  13. How to work with time Intelligence (creating date tables)

Module 3:
Data Visualizations  with charts

  1. How to work with Cards
  2. How to work with Pie Chart
  3. How to work with a Stacked Bar Chart
  4. How to work with matrix table
  5. How to work with the bar chart
  6. How to decide which chart to use for your visuals
  7. How to work with slicers
  8. How to format visual
  9. How to work with clustered charts

Module 4:

The capstone project, creating a dashboard

  1. How to prepare your dashboard
  2. How to create a dashboard
  3. How to design a dashboard by adding images and login
  4. How to publish your dashboard
  5. Publishing dashboard (from Power BI Desktop to Power BI service for consumption)
  6. Understanding the concept of Workspaces


Day 1

The activities for day 1 will include;

  1. Registration of participants with their training materials.
  2. The class starts with module 1 which is Data analysis fundamentals with Power BI
  3. Tea break
  4. Continuation of class
  5. Lunch and closing session

Day 2

The class continues with its activities as follows;

  1. A recap on the previous class
  2. Module 2 is Data Transformation, Power Query, and DAX
  3. Tea break
  4. Continuation of class
  5. Lunch and closing session

Day 3

The class continues with its activities as seen below;

  1. Recap on a previous class
  2. Data Visualizations  with charts
  3. Tea break
  4. Continuation of class
  5. Lunch and closing session

Day 4

This is the final day of the training session. The activities are as follows;

  1. Recap of previous classes
  2. Capstone project, creating dashboard
  3. Tea break
  4. Continuation with hands-on lab training
  5. Lunch
  6. Handling of certificates to participants
  7. Closing session

Join Our Newsletter

We send out newsletters every month with the latest blog posts from our writers. Join us!


Bariansystems Limited is differentiated from our competitors by our commitment to client satisfaction; our in-depth understanding of technology issues and our relentless pursuit of optimal and cost-efficient solutions that assist our clients to achieve sustainable competitive advantage. 

Quick Links

Work Hours

At Bariansystems limited we are available on-site from Monday to Friday and 24/7 via phone call and email.

Designed  by  Bariansystems Limited

Copyright © 2023. All rights reserved.