Data Analytics offered by The GrowthSchool Way
Data Analytics at The GrowthSchool Way Overview
Duration | 6 months |
Mode of learning | Online |
Official Website | Go to Website  |
Credential | Certificate |
Data Analytics at The GrowthSchool Way Highlights
- Earn a certificate after completion of the course
- Weekly Live Q&A Sessions
- Weekly Masterclasses by Industry Experts
Data Analytics at The GrowthSchool Way Course details
- Data Analyst
- Quality Analyst
- MIS Analyst
- Financial Analyst
- Customer Support Representative
- Engineer
- Consultant
- Student
- Business Leads
- Developer
- Anyone interested in learning Data Analysis
- Introduction to the world of Data Analysis
- Visualising Data using PowerBI / Tableau
- Stakeholder and Project Management
- Statistics and A/B Experimentation
- Case studies and Product Sense
- Projects & Github
- Interview Prep and getting Job ready
- This course is designed to equip participants with the skills and insights needed to harness the power of data for informed decision-making
- In this course students will explore the entire data analytics workflow, from data collection and cleaning to analysis and visualization
Data Analytics at The GrowthSchool Way Curriculum
Introduction to Data Analytics
Day in the life of a data analyst
What a typical data analytics project looks like
Skills required for a data/business analyst
Industries in analytics and brief about how work happens in each of them
Excel/Google Sheets - I
Introduction to Google Sheets and Excel
Formulae and Functions
Cleaning & Data Wrangling
Excel/Google Sheets - II
Various Charts
Advanced Excel (VLOOKUP, Pivots)
Google Sheets vs Excel
Hands-on Project
SQL - Beginner
Introduction to RDBMS & NOSQL DB
MySQL Installation & SQL Basics
CRUD Operations, Primary Key, Foreign Key
DDL, DML, DCL, DQL, TCL
DISTINCT, ORDER BY, Aggregate Functions
GROUP BY, HAVING, Logical operators
Case statement
SQL - Intermediate
Window Functions and Data Modeling for KPIs
Handling Dates, Duplicates, NULLs & Strings
Pivoting & Unnesting
Table Joins
Date & String Manipulation
Pattern Matching
SQL - Advanced + Interview Prep
Sub-query, Common Table Expressions (CTE)
Interview Prep & Practice Platforms
Hands-on Project
Data Transformation Techniques
Applied Statistics I
Measure of Dispersion
Descriptive Statistics
Types of Distribution
Distribution of Statistics
Applied Statistics II
Sampling techniques
p-value and statistical significance
Industry application of statistics
Error measurement techniques
Data Visualization: Power BI
Principles of data visualisation
Manipulation and best practices
Visual encoding and design
Intro to Power BI
Visualising data with Power BI
Case Studies on PowerBI
Python: Beginner
Fundamental data types and structures in Python
Reusable code blocks with Python functions
Different Python operators
Analyze and manipulate data efficiently with Pandas
Data Analytics at The GrowthSchool Way Faculty details
Other courses offered by The GrowthSchool Way
Student Forum
Anything you would want to ask experts?
Data Analytics at The GrowthSchool Way Contact Information
145, 5th Main Rd, Sector 6, HSR Layout, Bengaluru.
Bangalore ( Karnataka)