This course is designed for both beginners with no Data Analytics experience or experienced Analysts looking to hone their skills This program will equip you with the skills to use the power of Excel, Power BI and SQL to analyze data, create amazing visualizations, and write powerful queries to extract and analyze data to solve unique problems. Our courses are structured in a way that makes it 100% practical and ensures that you get optimal value
Problem Solving
Microsoft Excel
Power BI
SQL
Synthesizing Insights
Data Visualization
4.6 Course ratings
5,342Students
20+ Courses
Efemena is a Data Scientist with over 7 years experience cutting across multiple sectors. He currently works with Teleflex in the Global Supply Chain, and Analytics Department.
4.6 Course ratings
5,342Students
20+ Courses
Over 7 years experience in Data Analytics & Management Consulting. Trained over 3,000 participants. He is known for using simplified teaching methods and answers every question Graduated with a First Class in industrial Chemistry.
4.6 Course ratings
5,342Students
20+ Courses
County Head, Internal Audit Function for both State Bank of India London Branch and State Bank of India UKLimited. With over 19 years of experience in Banking. Professional Trainer and Data Enthusiast.
10 Videos
Problem Definition – Defining the problem statement
Preview
120 Minutes
CRISP-DM Problem Solving Framework
Preview
120 Minutes
Identifying potential root causes: the 5-Whys
Preview
120 Minutes
Designing an Issue Tree
Preview
120 Minutes
The McKinsey MECE Approach to Problem Solving
Preview
120 Minutes
The Prioritization Matrix
Preview
120 Minutes
Data Gathering
Preview
120 Minutes
Choosing the right Data Analytics Approach
Preview
120 Minutes
Synthesizing Insights
Preview
120 Minutes
Making a Decision
Preview
120 Minutes
Quizz:
Information Technology Terms
3 Videos
Introduction to Excel
Preview
120 Minutes
Data manipulation & Data Cleansing
Preview
120 Minutes
Data Modeling
Preview
120 Minutes
Quizz:
Information Technology Terms
4 Videos
Data Analyst Toolbox
Preview
120 Minutes
Data Analysis
Preview
120 Minutes
Data Visualization
Preview
120 Minutes
Data Presentation
Preview
120 Minutes
Quizz:
Information Technology Terms
4 Videos
Introduction to Power BI
Preview
120 Minutes
Data manipulation & modelling
Preview
120 Minutes
Data Analysis & DAX
Preview
120 Minutes
Data Visualization
Preview
120 Minutes
Quizz:
Information Technology Terms
5 Videos
Introduction to Data & Databases
Preview
120 Minutes
Writing SQL Statements
Preview
120 Minutes
Aggregate Functions
Preview
120 Minutes
Joins
Preview
120 Minutes
Creating Tables & Databases
Preview
120 Minutes
Quizz:
Information Technology Terms
One-month free intensive INTERNSHIP!!!
Build an online portfolio with over 6 high-end project
One-on-one CV Review Sessions
LinkedIn Optimization
Recommendation/ Reference Letter
Job and interview preparation
Gain online presence for job prospect visibility
Coaching and Mentoring
Data Analyst
Business Intelligence Analyst
Data Analytics Consultant
Business Analyst
Operations Analyst
HR Analytics Manager
Supply Chain & Logistic Analyst
Product Analyst
Course Duration
3+ Months
Course Level
Beginner & Intermediate
Students Enrolled
0 Students
Language
English
Projects
6 added to your portfolio
Classes
20 Classes
Topics
50+ Topics
Lifetime access to materials and experts
Hands-on practical sessions with videos
Quizzes and downloadable resources
Industry relevant certification
One month virtual internship
100% job prospect visibility
100% Online courses
