Data Analytics - 2025
This program is designed for individuals seeking to break into Data Analytics, regardless of previous experience. It covers all the essential tools and techniques required for data analytics roles, including the mastery of Excel, Power BI, SQL, Tableau, and Microsoft Fabric. By the end of the program, participants will have the ability to perform data analysis, create visualizations, and provide strategic insights using real-world data sets.
3 Course instructors
Instructor led course
8-12 month duration
2 or 6 Month Internship
Course Duration
8-12 Months of Instructor-led classes with an option of 2 or 6 Months Internship
Projects
8 Projects
(20% Discount ongoing - Limited slots)
Program fee payment can be in instalments
Course Description
This Data Analytics program is meticulously crafted to accommodate both newcomers and professionals seeking to elevate their expertise in data analytics. The course offers a deep dive into industry-leading tools like Excel, Power BI, SQL, Tableau, and Microsoft Fabric, equipping learners with the essential skills to manipulate, analyze, and visualize data with confidence.
Through hands-on projects, real-world case studies, and expert-led instruction, participants will gain the ability to transform raw data into actionable business insights. Whether you’re looking to enhance your current role or transition into a new career, this program will empower you to confidently solve complex business problems, create impactful dashboards, and leverage data-driven strategies.
By the end of the program, you’ll have not only mastered data analytics fundamentals but also built a professional portfolio showcasing your ability to extract meaningful insights from data, drive decision-making, and optimize business performance across any industry. With our comprehensive curriculum and personalized support, you will emerge as a data-savvy professional ready to thrive in today’s data-driven world.
Course Curriculum
Week 0
Introduction to Data Analytics
The Introduction to Data Analytics is for both beginner with no experience or experienced professionals, it covers the following modules:
Module 1: Tools and software Installation
How to Download Excel
How to Download Power BI (Windows) I
How to Download Power BI (Windows) II
How to Download PostgreSQL
Module 2: Welcome to Data Analytics
Welcome Address
Learning Structure and Roadmap
About Facilitators on the LMS
Stages of learning Data Analytics
Module 3: Introduction to Data Analytics
What is Data?
Types of Data
What is Big Data?
Data Analytics and Its Types
Differences between Data Analytics and Data Analysis
Careers in Data Analytics and its relevance
Module 4: Problem Solving
What is a problem?
Types of problems in data analytics
Problems in real-life as a Data Analyst
The problem-solving phase
Seven problem solving techniques
Crisp-DM Framework
KDD - Knowledge Discovery in Databases
Root Cause Analysis
Decision Trees
Pareto Principle
DMAIC Methodology
SWOT Analysis
Mental Maths
Module 5: Building a Portfolio
Portfolio Checklist
Experiencing VScode
Editing the HTML Template
Uploading your portfolio on GitHub Pages
Module 6: Optimize your LinkedIn Profile
Introduction
Creating your LinkedIn Profile
Uploading your Profile Picture and Cover
Crafting your headline
Your About Section
Work Experience
Education
Skills - Endorsements - Recommendations
Always Refer to your LinkedIn Pack
LinkedIn X JobAlytics
UK Visa Sponsorship LinkedIn Extension
Modifying LinkedIn Settings
Week 1
Excel for Analytics I
The Excel for Analytics I is for both beginner with no experience or experienced professionals, it covers the following modules:
Module 1: Introduction to Excel
Overview of Excel for Data Analytics
Introduction to Microsoft Excel
Cell Referencing
Module 2: Excel Operations
Excel Shortcuts
Paste Specials
Move or Copy Data
Hiding and Unhiding Rows/Columns
Freeze Panes
Grouping and Ungrouping Data
Module 3: Data Cleaning Functions
Introduction to Data Cleaning in Excel
TRIM Function
CLEAN and VALUE Function
UPPER, LOWER, PROPER and CONCATENATE
SUBSTITUTE Function
LEFT, RIGHT and SEARCH Function
UNIQUE and Remove Duplicate
Week 2
Excel for Analytics II
The Excel for Analytics II is for both beginner with no experience or experienced professionals, it covers the following modules:
Module 1: Data Analyst Toolkit
Data Validation and Conditional Formatting
Referencing, Data Validation and Conditional Formatting
Aggregate Function
Aggregate Function Vs Subtotal
IF, NestedIF and IFS
IF & And, IF & OR and IFERROR
Excel Table, Structured Referencing and COUNTIF
SUMIF(S) and AVERAGEIF(S)
Lookup Functions
Module 2: Extras - Excel Functions
Formulas and Functions in Excel 1
Formulas and Functions in Excel 2
Formulas and Functions in Excel 3
Index and Match
Vlookup
Xlookup
Text Manipulation in Excel
Week 3
Dashboarding with excel
The Dashboarding with excel is for both beginner with no experience or experienced professionals, it covers the following modules:
Module 1: Dashboarding Using Microsoft Excel
Dashboard Introduction
Exercise Intro
Data Analytics
Pivot Tables and Dashboard
Dashboard and Slicers
Module 2: Extra: Dashboarding Exercise
Pivot Table 1
Pivot Table 2
Pivot Table 3
Building your Dashboard 1
Building your Dashboard 2
Week 5
Introduction to Power BI & Data Modelling
The Introduction to Power BI & Data Modelling is for both beginner with no experience or experienced professionals, it covers the following modules:
Module 1: Introduction to Power BI
Introduction to Power BI
Why Power BI and not Excel
Understanding the Power BI Workflow
Types of Data Connector
Power Query Editor
Dax functions and M Language
Case Study - Dax functions and M Language
building your first dashboard PRT 1
building your first dashboard PRT 2
building your first dashboard PRT 3
Module 2: Introduction to Data Modelling
What is Data Modelling?
Why Data Modelling?
Concept of Primary and Foreign keys
Concept of Fact and Dimension Table
Types of Relationships in a data model
Types of Schemas
Build your first Data Model using Draw.io PRT 1
Build your first Data Model using Draw.io PRT 2
Export Draw.io Data Model
Write your first Calendar DAX
Case Study - Data modeling Deskify
Case Study - Creating Dax Measures
Week 6
Intermediate Power BI
The Intermediate Power BI is for both beginner with no experience or experienced professionals, it covers the following modules:
Module 1: Intermediate Power BI (DAX and Dashboarding)
Week 7
Power BI Service
The Power BI Service is for both beginner with no experience or experienced professionals, it covers the following modules:
Module 1: Power BI Service
Week 9
Introduction to SQL
The Introduction to SQL is for both beginner with no experience or experienced professionals, it covers the following modules:
Module 1: Introduction to SQL
Week 10
SQL For Data Analytics
The SQL For Data Analytics is for both beginner with no experience or experienced professionals, it covers the following modules:
Module 1: SQL For Data Analytics
Week 11
SQL Functions
The SQL Functions is for both beginner with no experience or experienced professionals, it covers the following modules:
Module 1: SQL Functions
Week 13
Tableau Basics, and Time Series
The Tableau Basics, and Time Series is for both beginner with no experience or experienced professionals, it covers the following modules:
Module 1: Introduction to Tableau
Week 14
Tableau Aggregation, and Filters
The Tableau Aggregation, and Filters is for both beginner with no experience or experienced professionals, it covers the following modules:
Week 15
Dashboarding in Tableau
The Dashboarding in Tableau is for both beginner with no experience or experienced professionals, it covers the following modules:
Module 1: Dashboard in Tableau
Week 17
Microsoft Fabric and ChatGPT
The Microsoft Fabric and ChatGPT is for both beginner with no experience or experienced professionals, it covers the following modules:
Module 1: Microsoft Fabric
Module 2: ChatGPT
Meet Your Instructor
Amaka Daniels
Senior Data Associate
"Over five years of experience in data analytics and data science, utilizing tools like MS Excel, Google Sheets, Power BI, and Tableau to manage and visualize data effectively. - Statistical analysis with SPSS and Minitab, develop predictive models using Python and R, and execute advanced database queries with SQL to support data-driven decision-making. - Skilled in translating complex data insights into actionable strategies, fostering collaboration with stakeholders, and staying updated on the latest trends and technologies in the field. "
Mark Olafare
Senior Data Associate
Mark Olafare is a skilled Business and Data Analyst with expertise in Excel, Power BI, SQL, and Python. He specializes in transforming data into actionable insights through dynamic dashboards and data-driven solutions. With a passion for simplifying complex data, Mark helps businesses make smarter decisions and has trained over 100 aspiring data professionals.
Stanley Nwajagu
Senior Data Associate
Senior Data Associate with expertise in data analytics, leveraging advanced skills in Python, SQL, and Power BI and Excel to drive actionable insights and solve complex business problems. Passionate about empowering others with data skills, enhancing learning experiences, and fostering business growth through data-driven strategies
Job Opportunities
With our Data Analytics Cerificate, you get to work as any of the following:
Data Analyst
Business Intelligence Analyst
Data Scientist
Marketing Analyst
Sales Analyst
Logistics Analyst
Supply Chain Analyst
Procurement Analyst
Operations Analyst
Product Analyst
Customer Analyst
Course Reviews
Select your preferred pricing plan
As an edu-tech brand, we specialize in providing the essential skills and knowledge you need to unlock high-paying opportunities in the dynamic world of technology. Our mission is simple: to empower individuals to pursue their dreams and excel in high-demand tech roles through intensive, hands-on training.
8-Month Plan
Learners looking for extended industry exposure and advanced skill-building.
6 months of classroom learning + 2 months of internship.
Payment Plan: $150 per month for 5 months.
What You Get:
- Extended internship for in-depth practical experience.
- Access to all advanced course materials and certifications.
- Mentorship and career guidance throughout your journey.
12-Month Plan
Learners looking for extended industry exposure and advanced skill-building.
6 months of classroom learning + 6 months of internship.
Payment Plan: $125 per month for 8 months.
What You Get:
- Extended internship for in-depth practical experience.
- Access to all advanced course materials and certifications.
- Mentorship and career guidance throughout your journey.
