Data Analysis with Excel & Power BI
Ksh 45,000 | USD 370.00
3 months
You can share this program with your friends below
Link has been copied to clipboard!
What You Will Learn
- Understanding Data Types and Structures
- Data Cleaning and Preparation Basics
- Introduction to Data Analysis Processes
- Advanced Excel Functions (VLOOKUP, IF, INDEX/MATCH, etc.)
- Pivot Tables and Charts
- Data Visualization and Conditional Formatting
- Using Excel for Exploratory Data Analysis
- Introduction to Power BI Interface
- Importing and Transforming Data with Power Query
- Creating Interactive Dashboards
- Using DAX for Calculated Columns and Measures
- Creating End-to-End Dashboards from Raw Data
- Business Case Scenarios: Sales, Finance, Marketing
- Presenting Data Insights to Stakeholders
- Capstone Project Using Excel and Power BI
- Dashboard Presentation and Peer Review
- Building Your Data Analytics Portfolio
Career Opportunities
This course prepares you for roles such as:
- Data Analyst
- Business Analyst
- Operations Analyst
- Reporting Specialist
- Excel/BI Consultant