Data Analytics
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.
0 Course instructors
Instructor led course
6 month duration
2 or 6 Month Internship
Course Duration
6 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
Materials and Testing
The Materials and Testing is for both beginner with no experience or experienced professionals, it covers the following modules:
Module 1: Installations
How To download and Install Microsoft Office
How To download and Install Power BI on Windows
How To download and Install Power BI on MAC Book
How To download and Install PostgreSQL
How To download and Install Tableau
Module 2: Module 0 - Introduction to Data Analytics
Welcome Address
Introduction to the programme
Stages In Learning Data Analytics
Data & Big Data
Data Analytics & Career Paths
Module 3: Module 0 - Problem Solving
Intro to problem Solving & CRISP DM Methodology
Root Cause Analysis
Decision Tree
Adjusting Your Decison Tree in draw.io
Pareto Principle
DMAIC Framework
SWOT Analysis
Prioritization Matrix
Creating a Prioritization Matrix Using Excel & Power Point
Module 4: Portfolio Creation
Portfolio Checklist
Experiencing VScode
Editing the HTML Template
Uploading your portfolio on GitHub Pages
Week 1
Week 1- Excel for Analytics I
The Week 1- Excel for Analytics I is for both beginner with no experience or experienced professionals, it covers the following modules:
Module 1: Module 1: Introduction to Excel
Overview of Excel for Data Analytics
Introduction to Microsoft Excel
Cell Referencing
Module 2: 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: 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
Week 2: - Excel for Analytics II
The Week 2: - Excel for Analytics II is for both beginner with no experience or experienced professionals, it covers the following modules:
Module 1: Module 4: 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
Week 3 - Dashboarding and Data Storytelling
The Week 3 - Dashboarding and Data Storytelling is for both beginner with no experience or experienced professionals, it covers the following modules:
Module 1: Module 5: 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 4
Week 4 - Getting started with Power BI
The Week 4 - Getting started with Power BI is for both beginner with no experience or experienced professionals, it covers the following modules:
Module 1: Module 6: Getting Stated with Power BI
Introduction to Power BI
The Architecture of Power BI
Concept of Primary Keys and Foreign Keys
Concept of Fact and Dimension Tables
Understanding Facts and Dimension in Data Modelling
Data Importation
Data Transformation in Power Query
Creating a Calendar Dimension Table
Building a Data Model
Week 5
Week 5 - Intermediate Power BI (DAX and Dashboarding)your Dashboard in Power BI
The Week 5 - Intermediate Power BI (DAX and Dashboarding)your Dashboard in Power BI is for both beginner with no experience or experienced professionals, it covers the following modules:
Module 1: Module 7: Build your Dashboard in Power BI
Writing DAX Measures
Creating a Dashboard Template in your Report View
Building your First Dashboard Part 1
Creating Slicers in Power BI
Building your First Dashboard Part 2
Week 6
Week 6 - Power BI Service
The Week 6 - Power BI Service is for both beginner with no experience or experienced professionals, it covers the following modules:
Module 1: Module 8: Power BI Service
Introduction to Power BI Service
Loading the dataset into Power BI
Creating a Simple Dashbaord in Power BI
Defining Roles for Row Level Security (RLS)
Saving your Work and Siging into Power BI Service
Signing in on PBI Desktop and Publishing
Row Level Security in Power BI Service
Creating Apps in Power BI Service for Sharing Report
Creating Scorecards in Power BI Service
Creating and Working with Dataflows
Week 7
Week 7 - SQL for Analytics
The Week 7 - SQL for Analytics is for both beginner with no experience or experienced professionals, it covers the following modules:
Module 1: Module 9: SQL (Structured Query Language)
Introduction to SQL
Restore your NorthWind Database
SQL Syntax 1
SQL Syntax 2
SQL Syntax 3
SQL Syntax 4 & Save your work
Week 8
Week 8 - SQL For Data Analytics
The Week 8 - SQL For Data Analytics is for both beginner with no experience or experienced professionals, it covers the following modules:
Module 1: Module 10: SQL JOINS
Inner Join
LEFT JOIN
RIGHT JOIN 1
RIGHT JOIN 2
FULL JOIN & ALIASES
Week 9
Week 9 - SQL Functions
The Week 9 - SQL Functions is for both beginner with no experience or experienced professionals, it covers the following modules:
Module 1: Module 11: SQL Functions
Introduction to the Case Study
Download and Extract the Database
Restore the database
CASE & WHEN
COALESCE
CAST
Combining COALESCE, CAST & SUBQUERIES -1
Combining COALESCE, CAST & SUBQUERIES -2
Week 10
Week 10 - Tableau for Data Analytics
The Week 10 - Tableau for Data Analytics is for both beginner with no experience or experienced professionals, it covers the following modules:
Module 1: Module 12: Tableau For Data Analytics
Introduction To Tableau
Building Blocks Of Visualization
Tableau Visualization
Tableau Filters
Time Series Data
Data Prep & Modelling-1
Data Prep & Modelling-2
Week 11
Week 11 - Dashboarding in Tableau
The Week 11 - Dashboarding in Tableau is for both beginner with no experience or experienced professionals, it covers the following modules:
Module 1: Module 13: Dashboarding in Tableau
Tableau Functions 1
Tableau Functions 2
Level Of Detail Expression
Formatting Part A
Formatting Part B
Dashboards In Tableau
Week 12
Week 12 - Microsoft Fabrics & ChatGPT
The Week 12 - Microsoft Fabrics & ChatGPT is for both beginner with no experience or experienced professionals, it covers the following modules:
Module 1: Module 14: Microsoft Fabrics
Introduction to Microsoft Fabrics
Download a copy of the dataset
Set up your Microsoft developer Account
Activating Fabric items
Creating a Fabric Workspace, Lakehouse and upload data into your lakehouse
Writing SQL Queries in Fabric
Building a quick Power BI report in Fabric
Writing python codes in Fabric (Data Science)
Module 2: Module 15 : Using ChatGPT for Data Analytics
Using ChatGPT for Data Analytics Part 1
Using ChatGPT for Data Analytics Part 2
Using ChatGPT for Data Analytics Part 3
Using ChatGPT for Data Analytics Part 4
Meet Your Instructor
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
Got a full-time job as a Business Data Analyst after training with 10Alytics on the Data Analytics Program
Gbenga
Got a fulltime job as a Junior Data Analyst with the Access Group in the UK after training with 10Alytics on the Data Analytics Program
Stephen
Got a full-time job as a Business Support Analyst in the UK after training with 10Alytics on the Data Analytics Program
Amaka
Got a full-time job with Shell, UK as a Sales Analyst after training with 10Alytics on the Data Analytics Program
Wislene Beaunissant
Got a full-time job with Western Union, HQ as a Digital Analyst after training with 10Alytics on the Data Analytics Program
Emeka Anorue
Landed a full-time role as a Business Data Analyst with LawDepot in Canada, after training with 10Alytics on the Data Analytics program
Olugbemi
Landed a full-time job with the NHS UK as a Business Intelligence Officer after training with 10Alytics on the Data Analytics Program
Uthman
Got numerous interview opportunities with PwC and eventually landed a full-time job with Cognizant on the Full Stack Data Science Program and Data Analytics Program
Ubong
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.
