This comprehensive course is designed to equip learners with essential data analysis and visualization skills using industry-standard tools such as Excel, Power BI, SQL, and Python. It follows a structured, hands-on approach where students will work on real-world datasets, complete weekly assignments, and build projects to strengthen their analytical capabilities.
Students will start with Excel for data handling and visualization, progress to Power BI for interactive dashboards, move on to SQL for querying and managing databases, and finally, dive into Python for advanced data analysis and visualization. Each lesson includes video tutorials, datasets for practice, assignments, and live sessions to reinforce learning.
By the end of this course, students will have the practical skills required to clean, analyze, visualize, and present data effectively, making them job-ready for careers in data analytics, business intelligence, and related fields.
Curriculum
- 20 Sections
- 10 Lessons
- 24 Weeks
- Week 1: Introduction to Excel1
- Week 1: Git and GitHub Basics (Data Analysis)1
- Week 2: Data Cleaning and Transformation1
- Week 3: Advanced Excel Functions1
- Week 4: Data Visualization in Excel1
- Week 5 - 6: BIKE SALES PROJECT1
- Week 7: Getting Started with Power BI1
- Week 8: Data Transformation and Modelling1
- Week 9: Creating Visualizations1
- Week 10: Advanced Features1
- Week 11: PIZZA SALES PROJECT0
- Week 12: Introduction to SQL0
- Week 13: Working with Tables0
- Week 14: Advanced SQL Queries0
- Week 15: Data Manipulation and Optimization0
- Week 16: Hands-On Projects – HR ANALYTICS0
- Week 17: Introduction to Python0
- Week 18: Data Manipulation with Pandas0
- Week 19: Data Visualization with Python0
- Week 20: Building a portfolio on Github0
Requirements
- Basic computer literacy (no prior data experience required).
- A PC or laptop with Windows (Power BI is Windows-based).
- Installation of required software: Microsoft Excel (2016 or later) Power BI Desktop (free download from Microsoft) SQL Server & SSMS (SQL Server Management Studio) Python (Anaconda or standalone Python with Jupyter Notebook)
- Internet access to watch video tutorials and download datasets.
- A GitHub account to submit assignments.
Features
- Structured Weekly Learning – Follow a step-by-step curriculum with focused lessons.
- Hands-on Practice – Work on real-world datasets and industry-relevant case studies.
- Guided Assignments – Each lesson includes datasets, exercises, and GitHub-based submission.
- Live Interactive Sessions – Weekly Q&A and workshops to enhance understanding.
- Power BI Dashboards – Build interactive reports for business intelligence.
- SQL for Data Analysis – Learn database querying, joins, and data manipulation.
- Python for Data Science – Use Pandas, Matplotlib, and Seaborn for analysis and visualization.
- Portfolio Building – Complete projects like Bike Sales, Pizza Sales, and HR Analytics to showcase your skills.
Target audiences
- Beginners looking to start a career in data analysis or business intelligence.
- Students or professionals interested in upskilling in data analytics.
- Entrepreneurs and business owners who want to leverage data-driven decision-making.
- Anyone interested in learning Excel, Power BI, SQL, and Python for data analysis.
Glad to be here. Can’t wait to see what it holds for us.
Thank you for this opportunity.
Good day Sir,
I have successfully opened my GitHub account and i am currently going through lesson 2 but i have issues with downloading the Power BI. Please is there any link that can be shared in this regards.