Data
Analytics
Build a portfolio, create a network,
and land your dream job.
[Link]
Table of Contents
03 Welcome
04 Designed For Success
05 Our Mission
06 Units & Overview
17 Assessment
18 Career Statistics
19 Testimonials
20 Partnerships
21 Our Alumni Work At
Data Analytics
2
Welcome
The Job Ready curriculum from Training Basket is a structured, self-paced online instruction
that will give you complete knowledge of Data Analysis in just four months. As a Data Analyst,
you'll master the analytics, computer modeling, science, and math. Our Data Analytics experts
from the industry take you through from scratch to the advanced level and give exposure to
industry-level projects from the ground up and provide you with a solid foundation in Tableau,
Power BI & Python. You'll learn about Advance Excel & Business Analytics. Your course will
culminate in the study of Python and SQL which is the most widely used programming
language.
Statistics & Probability enables technical systems to perceive their environment, deal with what
they perceive, solve problems and act to achieve a specific goal. This is a one-of-a-kind online
learning environment.
Bootcamp-style program that prepares you for
a high-paying career in tech
Each unit in the Training Basket curriculum teaches a core concept, skill, language component,
or framework. You learn by viewing videos, and you may reinforce your skills by doing
interactive programming quizzes and challenges. Mini-exercises will help you implement
everything you've learned, and then you'll apply all you've learned in an individually graded,
hard assignment with feedback. By completing all 3 projects in this training and passing the
final exam, you will receive a Training Basket Certificate of Achievement and have the skills that
will better prepare you for entry-level employment as a Data Analyst.
Data Analytics
3
Designed For
Success
Online learning may be difficult, and we
understand how difficult it can be to learn on
your own. Thankfully, We've created AWARD-
WINNING LMS to Learn through 24*7 interactive
LMS with PPTs, Videos, Assignments, Case
Studies & Quizzes along with a progress tracker
with flexibility to match your needs your hectic
way of life.
Key Benefits of this
Job-ready Training
Live support A professional
Study at your Study and
and an online and finished
own pace career guidance
community portfolio
Data Analytics
4
Our Mission
Training Basket works to make education more Training Basket’s mission is to
inclusive and accessible so that individuals may diversify the tech industry
accomplish their goals. We've taught over through online-learning
50,000 individuals how to code and design However, if you already have some experience
since 2017, and our objective is to achieve long- but want to advance, Training Basket offers
term, systemic change in the IT industry. current and relevant skills to help you reach
Competency-based learning is used in Training where you need to go. You'll additionally
Basket training programs to reinforce what benefit from the Training Basket Slack, a
students have learned. We've reinvented the thriving online community where you can ask
learning process and created a tried-and-true questions and network with other students,
approach to help you get the skills and regardless of your past experience level. You'll
information you need to achieve your have weekly office hours, and Training Basket
support professionals will be accessible for
objectives. Stay on track with our points system,
advice and encouragement.
badges, and weekly activity journal, which has
been scientifically proven to enhance We designed this program
motivation. You didn't merely view a video to be an accessible alternative
when you finished a course; you learned, to bootcamps
practiced, and internalized an idea. Plus, at the We concluded that in order to diversify the IT
end of each lesson, Training Basket walks you industry, we needed a curriculum that was fully
through an immersive project, so you'll have a beginner-friendly, didn't result in student debt
portfolio of work ready to present as soon as and didn't demand any repayment. Many
you're through. Our Job-Ready programs are bootcamps cost huge amounts of money, or
geared toward beginners worse, force graduates to take a share of their
salary when they obtain a job. At a fraction of
the cost of bootcamps, Training Basket provides
high-quality courses, comprehensive learning
assistance, and professional expertise.
Data Analytics
5
Units & Overview
Unit-1 Python
Python Libraries Unit-2
Unit-3 Statistics/Probability
Power BI Unit-4
Unit-5 Database(My SQL)
Introduction to machine learning Unit-6
Data Analytics
6
Unit-1
Python
Week 1
1: Introduction to Python
Ÿ Overview of Python and its applications
Ÿ Installing Python, Anaconda, and relevant packages
Ÿ Running Python scripts and using Jupyter Notebook
2: Python Fundamentals
Ÿ Variables and Data Types
Ÿ Identifiers
Ÿ Keywords in Python
Ÿ Structure of a Python Program (Comments, Indentation)
Ÿ Operators (Arithmetic, Comparison, Logical, Assignment, Bitwise, Membership,
Identity)
Ÿ Type conversion and Typecasting
Ÿ Taking user input and basic output formatting
3: Strings and String Methods
Ÿ String indexing and slicing
Ÿ String methods and operations
Ÿ String formatting (f-strings, format method)
4: Data Structures in Python
Mutable vs Immutable Objects
Lists
Creating, indexing, and slicing
List methods and operations
List comprehension
Tuples
Characteristics and operations
Sets
Set operations and methods, Set comprehensionDictionaries
Data Analytics
7
Dictionaries
Ÿ Key-value pairs
Ÿ Dictionary methods
Ÿ Dictionary comprehension
5: Control Flow Statements
Ÿ Conditional statements (if, elif, else, nested if-else)
Looping statements
Ÿ For loop
Ÿ While loop
Ÿ Nested loops
Control statements
Ÿ Break, Continue, Pass
Pattern making with loops
6: Functions in Python
Ÿ Function definition and calling
Ÿ Parameters and return values
Ÿ Default arguments, Keyword arguments
Ways of Function denition
Ÿ With Argument Without Return
Ÿ Without Argument With Return
Ÿ With Argument With Return
Ÿ Without Argument Without Return
Types of Functions
Ÿ User-Defined functions
Ÿ Built-in functions
Ÿ Lambda function
Ÿ Recursion
Data Analytics
8
7: Advanced Functions
High Order Functions
Ÿ Map(), Filter(), Reduce()
Ÿ *args and **kwargs
Ÿ Iterators and Iterables
Ÿ Closures and Decorators
Ÿ Generators (yield keyword)
8: File Handling
Ÿ Reading and writing files (text and binary mode)
Ÿ File operations (open, close, read, write, append)
Ÿ Using with statement for file handling
9: Exception Handling
Ÿ Try, Except, Finally blocks
Ÿ Raising exceptions with raise
Ÿ Handling built-in exceptions
Ÿ Creating custom exceptions
9: Additional Important Concepts
Ÿ Modules and Packages
Ÿ Importing and using modules
Ÿ Creating and using custom modules
Ÿ Python Standard Library (os, sys, datetime, random, pickle etc.)
Ÿ Memory Management in Python (Garbage collection, reference counting)
OOPs
1: Introduction to OOPs
Ÿ Overview of Classes and Objects
Ÿ Class Variable vs Instance Variable vs Local Variable
Ÿ Constructors in Python (OOPs)
Ÿ Default Constructor (No Arguments)
Ÿ Parameterized Constructor
Ÿ Constructor with Default Values
Data Analytics
9
4 Pillars in OOPs
Ÿ Inheritance
Ÿ Encapsulation
Ÿ Polymorphism
Ÿ Data Abstraction
2: Main Pillars in OOPs
Pattern making with loops
Ÿ Single Inheritance
Ÿ Multiple Inheritance
Ÿ Multilevel Inheritance
Ÿ Hierarchical Inheritance
Ÿ Hybrid Inheritance
Encapsulation in Python
Ÿ Public Members
Ÿ Protected Members (_variable)
Ÿ Private Members (__variable)
Ÿ Getter and Setter Methods
Polymorphism in Python
Ÿ Method Overriding (Runtime Polymorphism)
Ÿ Method Overloading (Not Supported Natively in Python)
Data Abstraction
Ÿ Abstract Class (Interface)
Ÿ Abstract Methods
Ÿ Concrete Class
Ÿ Abstract Classes vs Concrete Classes
Ÿ Encapsulation vs Abstraction
2: Advanced OOPs Concepts
Ÿ Magic Methods (Dunder Methods)
Ÿ Constructor vs Destructor
Ÿ Super() Method in OOP
Ÿ Composition vs Inheritance
Data Analytics
10
Unit-2
Python Libraries
Week -2
Numpy
• Indexing/slicing
• Appending /Inserting on axis
• Mathematical and statistical operations
• Sort/Condition
• Transpose Operations
• Joining/splitting
• Linear Algebra
Pandas
• Data Extraction
• Series/Dataframe Creation
• Indexing and Slicing
• Conditions/Grouping/Imputations
• concat/merge/join
• Datetime functionalities and resampling
Data visualization with Matplotlib and Seaborn
• Customization of matplotlib and seaborn
• scatterplots/barplot/histogram/density plots
• Box Plot and outlier detection
• Visualization Linear relationship
• Univariate , Bivariate and Multivariate analysis
Data Analytics
11
Unit-3
Week -3
Statistics/Probability
• Probability
• Conditional Probability
• Dependent and Independent events
• Bayes Theorem
• Descriptive / Inferential
• Variance / standard deviation
• Covariance And correlation(Pearson/Spearman)
• Central Limit theorem
• PDF, CDF, PMF
• Types of distributions
• Condence Intervals
• Hypothesis testing
• Z Test,t test,chi-2 test
• F-test/Anova
Unit-4
Week -4
Power BI
Introduction to Power BI
Ÿ Introduction to Business Intelligence
Ÿ Why Power BI
Ÿ Power BI Desktop Installation
Ÿ Power BI Interface
Ÿ Power BI components
Ÿ Power BI work flow
Data Analytics
12
Data Extraction
Ÿ Data Sources in Power BI
Ÿ Extracting Data From Files(Excel,CSV,etc)
Ÿ Extracting Data From Database
Ÿ Introduction to Power Query
Data Transformation
Ÿ Shaping data using Power Query Editor
Ÿ Understanding of Data types
Ÿ Formatting data
Ÿ Transformation of data
Ÿ Merge Query
Ÿ Append Query
Ÿ Data Source Parameters
Ÿ Groupby of data (aggregation of data)
Ÿ Applied steps (query settings)
Ÿ Pivot&Un-pivotofdata
Ÿ Custom columns
Ÿ Conditional columns
Relational Data Model
Ÿ Database normalization
Ÿ Fact & dimension tables
Ÿ Primary&foreign keys
Ÿ Star & snowflake schemas
Ÿ Active&inactive relationships
Ÿ Relationship cardinality
Ÿ Filter context & flow
Ÿ Bi-directional filters
Data Analysis Expression
Ÿ Introduction of DAX
Ÿ Calculated columns & measures
Ÿ Implicit, explicit&quick measures
Ÿ Measure calculation steps
Ÿ Conditional & logical functions
Data Analytics
13
Ÿ Date & time functions
Ÿ The RELATED function
Ÿ CALCULATE, FILTER & ALL
Ÿ Iterator(X)functions
Data Visualization
Ÿ Deep dive into Power BI data visualization
Ÿ Data visualization techniques
Ÿ Page layout & Formatting
Ÿ Power BI Desktop visualization
Ÿ Visualization interaction
Ÿ Page navigations
Ÿ Bookmarks
Ÿ Formatting and customizing visuals
Ÿ Selection pane to show/hide visuals
Power BI Service
Ÿ Introduction to PowerBIService
Ÿ Introduction of workspaces
Ÿ Dashboard
Ÿ Creating&ConguringDashboards
Unit-5
Week -5
Database(My SQL)
Ÿ Intro to Databases
Ÿ Relational Databases vs Non-Relational Databases
Ÿ DB vs DBMS vs SQL
Ÿ SQL vs NoSQL
Ÿ Database Design
Data Analytics
14
Ÿ Intro to Databases
Ÿ Relational Databases vs Non-Relational Databases
Ÿ DB vs DBMS vs SQL
Ÿ SQL vs NoSQL
Ÿ Database Design
Ÿ
Ÿ Normalization
Ÿ Denormalization
Ÿ ER Diagrams
Ÿ ACID Properties
Ÿ
Ÿ Introduction to MySQL
Ÿ MySQL Workbench and Administration Tools
Ÿ Installation and Configuration
Ÿ MySQL Data Types
Ÿ Creating and Managing Databases
Ÿ Creating and Managing Tables
Ÿ CRUD Operations
Ÿ Types of SQL Commands
Ÿ DDL, DML, DQL, DCL, TCL
Ÿ Keys, Constraints and Clauses
Ÿ Operators and Aggregate Functions
Ÿ Windows Functions
Ÿ Basic SQL Queries
Ÿ Importing and Exporting Data
Ÿ Filtering and Sorting Data
Ÿ Joining Tables
Ÿ Joins
Ÿ Inner Join
Ÿ Left Join
Ÿ Right Join
Ÿ Full Outer Join
Ÿ Self Join
Ÿ Subqueries
Ÿ Views
Ÿ Nested Queries
Data Analytics
15
Unit-6
Week -6
Introduction to machine learning
• Difference Between AI, ML and DL
• Applications of Machine Learning
• Categorization of Machine Learning
• Supervised / Unsupervised / Semi Supervised
• Parametric vs NonParametric
Linear Regression
• Collect and Prepare Data
• Explore the Data (EDA)
• Split the Dataset
• Choose the Linear Regression Model
• Train the Model
• Make Predictionion
• Evaluate the Model
Linear Regression
• Project 1 - Python/OOPs (ATM Simulation)
• Project 2 - PowerBI Dashboard(Unlocking Financial Insights in Banking
Data)
• Project 3 - EDA (Advanced Challenging Dataset)
• Project 4 - ML Project(Regression Based)
• Project 5 - SQL Based Assignment
Data Analytics
16
Assessment
Our lecturers are working
experts in the field of technology
who give useful and constructive
advice.
{./.}
</>
{./.}
This Job-Ready curriculum incorporates You'll have the chance to fix the problems
project-based learning, which allows you to and resubmit the project for further
apply the skills you're learning by working on assessment. As you go through the course,
projects of increasing complexity. Each you will show your developing skillset by
project you create will be evaluated completing quizzes and coding tasks,
separately using a thorough grading criteria culminating in a Final Exam. The Final Exam is
that is specific to that assignment. Aside from your opportunity to demonstrate what
an overall grade of Exceeds, You will receive you've learned during this Training. You must
individualized written feedback on your correctly answer at least 70% of the
project in the form of Expectations, Meets questions on the Final Exam in order to
Expectations, or Needs Work. Don't panic if succeed. If you don't meet that standard, you
your project is labeled as Needs Work. can study and repeat the exam the next day.
Data Analytics
17
Statistics on a Career
You'll be ready to start your new job in the
tech bus i nes s af ter you have your
Salary Package:
Certificate! As an entry-level Data Analyst, According to [Link], the typical
these are some of the options available to base income in INDIA is 6,000,00 INR.
you.
Ÿ Junior Data Analyst
Ÿ Business Intelligence (BI) Analyst Levels
₹1200k
Ÿ Reporting Analyst
Ÿ Data Technician / Data Associate ₹1000k
Ÿ Marketing Data Analyst
Ÿ Operations/Data Coordinator ₹800k
Ÿ Product Analyst (Junior)
₹600k
Ÿ Financial/Data Analyst (Entry-level)
Ÿ Research Analyst L2 L4 L7
Average Salary Growth
Day to Day Tasks as a A typical entry-level Data Analyst job pays
₹50,000 higher per year than the National
Data Analyst Average Wage Index.
Ÿ Collecting Data
Ÿ Cleaning and Preparing Data With new technologies being invented
Ÿ Analyzing Data to Identify Trends and every day, the IT sector has been rising year
Patterns
after year and shows no signs of slowing
Ÿ Creating Reports and Dashboards
down.
Ÿ Communicating Insights to Stakeholders
Ÿ Collaborating with Teams (e.g., Marketing,
Product, Finance)
Ÿ Automating Repetitive Data Tasks
Ÿ Using Tools Like Excel, SQL, Power BI, or
Tableau
Ÿ Performing Ad-hoc Data Queries
Ÿ Monitoring Data Quality and Accuracy
Ÿ Supporting Decision-Making with Data
Ÿ Documenting Processes and Findings
Data Analytics
18
Testimonials
I was cautious at first, believing that elearning
would be difficult. However, after joining the
Training Basket, I understood how much more
handy online training programmes are. Using LMS,
we may learn study material at any time. The trainer
primarily focuses on real-life problems, such as how
to deal with the issue's complexity. Thank you very
much for your amazing service, #Training Basket.
- Shubham
I finished the training course from the
Training Basket. The instructor was fantastic.
The subject was well-presented, and the
practise exams were excellent at helping us
recall key points. Overall, it was a terrific
experience. Training Basket performed
admirably.
- Ravika
The Training Basket provided a fantastic e-
learning experience. The teacher put in a lot of
work and provided excellent help. The advice
was quite helpful. I would tell my friends and
coworkers about Training Basket.
- Gaurav
Data Analytics
19
Partnerships
We collaborate with a number of IT businesses to
guarantee that our students receive the most up-to-
date and relevant education possible.
Authorized Training Partners
Data Analytics
20
Our Alumni Work At
Data Analytics
21