Data Analysis using Power BI
ر.س3,500.00
This course is one of the most powerful in data analysis and interactive report design. It equips participants with practical skills in data collection, cleaning, and analysis through Power BI’s intuitive and efficient interface, enabling the creation of dynamic dashboards for data-driven decision-making.
Day 1 – Introduction & Setup
- Introduction to Business Intelligence and Power BI
- Power BI Desktop and Service components
- Connecting and importing data from Excel, CSV, and databases
- Data modeling basics
- Understanding table relationships
Day 2 – Data Preparation & Transformation (Power Query)
6. Using Power Query for data cleaning and transformation
7. Merging, aggregating, and advanced filtering
8. Transforming columns and handling text/date data
9. Creating custom columns with M Language
10. Solving common transformation issues
Day 3 – Analysis & Functions (DAX)
11. Introduction to DAX language
12. Using Measures and Calculated Columns
13. Aggregation and Time Intelligence functions
14. Building KPIs and cumulative analysis
15. Understanding context in DAX and scenario analysis
Day 4 – Visualization & Reporting
16. Designing professional dashboards
17. Using advanced charts (Treemap, Gauge, Slicer…)
18. Customizing design and interactive navigation
19. Publishing to Power BI Service and creating apps
20. Sharing reports and enabling auto-refresh
Target Audience
- Data and report analysts
- Marketing and finance specialists needing instant reporting
- Project management and HR professionals
- Decision-makers seeking insight from KPIs
- Students and researchers handling large datasets
- Heavy Excel users upgrading to Power BI
Certification
Participants receive a TVTC-accredited certificate and are qualified to use Power BI professionally in real business environments.
Reviews
There are no reviews yet.