You want to change a stagnant job for dynamic career
You want to work in a big company or move out of India
You want to upskill yourself and get a higher position at work
You want to take control of your life
Get consultation
Leave your phone number, and our counselor will call you back and answer all your questions about the course!
In 8 months you will master all skills needed to be a Data Analyst. The course contains 12 blocks and 22 modules, 10 projects, 3 exams, and a lot of practice! You will complete the course with full knowledge of how IT works and how to fit in the industry.
Your skills after the course
What Is Inside
projects and business cases
30+
months to complete
8
1500+
Access assignments
Google sheets SQL Statistics Power BI Python
Get personal employment help
4
Mailing CV to our HR partners
Sessions that emulate your future interviews with employers
3
Mock interviews
10 solved business cases that show you’re ready for work
2
Portfolio
Mentors define your strengths and create a CV that will catch employers
Need more information about the course benefits? Contact us now!
Who created the program
The course is developed by field experts: Data Analysts, software engineers, and business consultants. Make experience of the best professionals work for your success!
SYLLABUS
In 8 months you will master all skills needed to be employed as a Data Analyst. The course contains 22 week-long modules of theory and practice, 10 group cases from real business and 3 exams to test your skills and employability
Google Sheets
1) Basics
Preparation
Formatting
Calculation
Automate
2) Functions
IF
VLOOKUP
COUNTIF
SUMIF
SUMIFS
3) Pivot tables and dashboards
Introduction
Analyzing data using pivot table
Putting it all together
Reports for a retail store brand
Group project for video content platform
SQL
1) Operators and Queries
Introduction to SQL and its terminology
Basics
Working with Operators
Working with Strings & Datetime
Mastering complex SQL Queries with basic statements
2) Advanced Queries
Aggregate functions
HAVING clause
SQL Joins
Sub Queries
3) Advanced functions
Windows functions
CONTROL FLOW FUNCTIONS
HANDLING NULL VALUES
DATABASE NORMALIZATION
Project for an investment bank
Project for YouTube video trends
Statistics
1) Basics
Intro to statistics
Central tendency, variance
Inferential Statistics
Types of Probability Distribution
2) Data and hypothesis
Exploratory data analysis
Data Preprocessing
Hypothesis testing (parametric tests)
Chi square test and 1 way ANOVA
Project for a bank
Power BI
1) Setup and dashboards
Introduction to Power BI
Connecting to data sources and Creating basic charts and visuals
Cleansing data with Query Editor
Creating Report by combining all visuals
Types of Visuals in Power BI
Managing Relationships between Tables in Power BI
Addition of New columns using Power Query
Transforming Columns in Query Editor
2) Modeling and Optimization
Modeling and Optimization
Customisations
Interactions
Introduction to DAX
Project for a Finance department of a company
Project on supply chain domain to optimize the supply and profit