Beginner
Malware Analysis
Data Analytics
Data Analytics
Instructor
KATE BASSEY
80 hours
0 enrolled
About this course
The Data Analytics course teaches students how to collect, clean, analyze, and visualize data to support business decisions using tools such as Excel, SQL, Python, and Power BI/Tableau. Students work with real datasets and complete practical projects.
Course Content
What is Data Analytics
120 min
Types of Data
120 min
Data lifecycle
120 min
Data-driven decision making
120 min
Careers in Data Analytics
120 min
Excel formulas and functions
120 min
Data cleaning techniques
120 min
Pivot tables
120 min
Data sorting and filtering
120 min
Charts and dashboards
120 min
Descriptive statistics
120 min
Mean, median, mode
120 min
Probability basics
120 min
Correlation and regression
120 min
Hypothesis testing
120 min
Databases and relational models
120 min
SQL queries
120 min
SELECT statements
120 min
JOIN operations
120 min
Aggregation functions
120 min
Subqueries
120 min
Practicals: Customer database analysis
120 min
Python basics
120 min
Data structures
120 min
Pandas for data analysis
120 min
NumPy for computation
120 min
Data cleaning
120 min
Exploratory data analysis (EDA)
120 min
Practicals: Analyze real datasets
120 min
Visualization principles
120 min
Charts and dashboards
120 min
Storytelling with data
120 min
Business reporting
120 min
Power BI fundamentals
120 min
Data modeling
120 min
DAX formulas
120 min
Dashboard creation
120 min
Interactive reports
120 min
Practical: Business dashboard project
120 min
Predictive analytics
120 min
Machine learning overview
120 min
Big data tools
120 min
Cloud analytics platforms
120 min
Students work on real-world datasets.
120 min
Prerequisites
Basic computer skills
Laptop (minimum 8GB RAM recommended)
Internet access (for online training)
Laptop (minimum 8GB RAM recommended)
Internet access (for online training)
Learning Outcomes
Students receive:
Professional Certificate in Data Analytics
Possible industry certifications:
Microsoft Power BI Certification
Google Data Analytics Certificate
Professional Certificate in Data Analytics
Possible industry certifications:
Microsoft Power BI Certification
Google Data Analytics Certificate
Capstone Project
Duration: Weeks 15 – 16
Students work on real-world datasets.
Examples:
Sales analytics dashboard
Customer segmentation analysis
Marketing campaign performance analysis
Deliverables:
Dashboard
Data report
Presentation
Students work on real-world datasets.
Examples:
Sales analytics dashboard
Customer segmentation analysis
Marketing campaign performance analysis
Deliverables:
Dashboard
Data report
Presentation
Target Audience
Beginners with no coding experience
Business professionals
Graduates and job seekers
Entrepreneurs and marketers
Business professionals
Graduates and job seekers
Entrepreneurs and marketers
This course includes:
- 80 hours of video
- Downloadable resources
- Certificate of completion
- Lifetime access