Quality Data Management & Power PI 2024
Overview
This program is designed to give in-depth hands-on application on different data management and provides a comprehensive overview of the principles, techniques, and technologies involved in managing data effectively throughout its lifecycle.
Learning Objectives
By the end of this program, participants will be able to:
- Identify data concept: Introduce students to fundamental concepts related to data, such as types of data, data models, data formats, and data lifecycle
- Identify data quality and governance Strategies: Cover strategies for ensuring data quality, such as data cleaning, deduplication, and validation. Discuss data governance frameworks
- Define different models between key indicators and their effect on the organization.
- Formulate ID and apply key indicators: how to create an I D card and how to implement
- Apply data visualization techniques, build dashboards, and report data.
- Analyze data and make formulas on excel
- Identify the layout and functionalities of Power BI Desktop and other relevant tools..
- Identify the steps to connect Power BI to various data sources and import data for analysis.
- Identify skills in transforming and cleaning data using Power Query Editor for better analysis.
- Create and manage data models for effective reporting.
- Develop the ability to create different charts, graphs, and other visual elements to present data insights.
- Design reports and dashboards: Master the creation of interactive reports and dashboards that communicate information effectively.
- Identify the basics of DAX, a formula language used to create custom calculations and measures within Power BI.
Schedule
Date | Time | Lectures | Topic | Hours |
---|---|---|---|---|
05/10/2024 | 10:00pm-02:00pm | Lecture 1 | Understanding data concept | 2 Hours |
Lecture 2 | Data quality and governance | 2 Hours | ||
12/10/2024 | 10:00am-01:00pm | Lecture 3 | Key performance indicators | 3 Hours |
Key performance indicators formulation and application | ||||
19/10/2024 | 10:00am-01:00pm | Lecture 4 | Dashboard and reporting | 3 Hours |
26/10/2024 | 10:00am-01:00pm | Lecture 5 | Data analysis | 3 Hours |
02/11/2024 | 10:00am-01:00pm | Lecture 6 | Get familiar with the Power BI environment | 3 Hours |
Connect to and import data | ||||
Transform and clean data | ||||
09/11/2024 | 10:00am-01:00pm | Lecture 7 | Build data model | 3 Hours |
Lecture 8 | DAX (Data Analysis Expressions) | |||
16/11/2024 | 10:00am-01:00pm | Lecture 9 | Design reports and dashboard | 3 Hours |
Lecture 10 | Create visualization |
Available date
Waves | Date |
Wave 1 | 05/10/2024 – 16/11/2024 |
Mode of Delivery
Online
Target Audience
Post Graduates from Faculty of Medicine, Nursing, Pharmacy, Science, Physiotherapy and Dental
Certificate Requirements
In order to receive your certificate, you have to attend not less than 70%
• Hard copy for 100 Egyptian Pounds
• Soft copy for free