- In-Demand Course
Learn the Best Data Analysis, clean, analyze, and visualize data using real tools and real-world business cases. Learn Excel, SQL, Python, and Power BI with real-world projects,
This comprehensive training equips you with the technical and analytical skills to turn raw data into business insights that drive smart decisions.
🕒 Duration: 12 Weeks
📍 Mode: Physical (Lagos)
& Online (Live Virtual)
📚 Course Overview
About This Course
The global job market is looking for data-literate professionals who can read numbers, spot patterns, and help businesses grow smarter. This course is your all-access roadmap teaching you how to work with spreadsheets, databases, and dashboards from scratch.
By the end of this program, you’ll be confident in handling datasets, presenting reports, and even applying for roles in tech, finance, operations, research, and beyond.
What You’ll Learn (Course Curriculum)
Week 1: Introduction to Data Analytics
- What is data analysis & why it matters
- Career paths & industry applications
- Setting up your analyst mindset
Week 2–3: Microsoft Excel for Data Analysis
- Cleaning and sorting large datasets
- Logical formulas (IF, VLOOKUP, INDEX MATCH)
- PivotTables, data validation & Excel charts
Week 4–5: Google Sheets & Cloud Collaboration
- Spreadsheet automation with formulas
- Conditional formatting & visual reporting
- Collaborating and sharing insights live
Week 6–7: SQL for Beginners
- Understanding databases and queries
- Filtering, joining, grouping, and sorting data
- Real-life queries from sales & inventory data
Week 8–9: Power BI & Data Visualization
- Connecting data sources
- Creating interactive dashboards
- Storytelling with charts and insights
Week 10: Intro to Python for Analysts (Optional Track)
- Using Python in Jupyter Notebook
- Data cleaning with Pandas
- Visualizing with Matplotlib & Seaborn
Week 11: Real-World Capstone Project
- Analyzing a multi-source business dataset
- Presenting insights and creating dashboards
- Peer and mentor review
Week 12: Job Readiness + Portfolio
- Creating a LinkedIn-ready data portfolio
- Building your analyst CV
- Interview tips and mock assessments