Step into the world of data-driven decision-making with our comprehensive
Data Science Training program at Shorat Innovations Pvt Ltd. This course is designed
to equip you with the skills and knowledge required to analyze, interpret, and visualize data,
enabling you to derive valuable insights that drive business success.
Training Content
Introduction to python
Data types , variables ,Keywords
Syntax of python language compare to other programming
Python installation
Print statement
Comments
Input & output in python
String in python
list
Set
Tuple
dictionary
Operators in python
Indentation
Control statement
Loops
Range statement
Break & continue
Functions in python
Lambda function
Oops in python
Inheritance
Polymorphism
Encapsulation
Abstraction
File handling
Exception handling
Python Libraries
Pandas
Numpy
Seaborn
Matplotlib
Tkinter
Introduction to R
Installation of R Studio
Data types in R
Relational Operators
Logical Operators
Decision Making Statements
Loops
Functions
Merging data frames
Analyzing Iris Dataset using apply functions
dplyr package
Introduction
What is Database
What is Table
Data Definition Language (DDL)
Data Manipulation Language (DML)
Create a new Database
Create a new Table
Data Types- Numeric ,Datetime,char
SQL Select
SQL Distinct
SQL AND, OR ,IN ,BETWEEN
SQL LIKE
Group BY Clause
Having Clause
Aggregate Functions
COUNT
SUM, AVG
MIN, MAX
Constraints
NOT NULL, UNIQUE , CHECK , DEFAULT
PRIMARY KEY
FOREIGN KEY
Joins
Inner Join
Left join
Right join
Cross join
Self join
Union, Intersect, Sub-query
Introduction to MySQL
Introduction to Database
Create Worksheets and Workbooks
Format Worksheets and Workbooks
Change worksheet tab color
Rename a worksheet
Change worksheet order
Insert and delete columns or rows
Change workbook themes
Adjust row height and column width
Insert headers and footers
Create and Manage Tables
Create an Excel table from a cell range
Convert a table to a cell range
Add or remove table rows and columns
Filter and Sort a Table
Look up data by using Functions
Understanding Power BI Background
Installation of Power BI and checklist for perfect installation
Formatting and Setting prerequisites
Understanding the difference between Power BI desktop & Power Query
Power BI user interface
Power BI Visualization
Understanding Column Chart
Understanding Line Chart
Implementation of Conditional formatting
Implementation of Formatting techniques
Power Query Editor Filter Data
Customize the data in Power BI
Dax Expressions
Custom Visual
Introduction to Machine Learning
Supervised Learning and Linear
Classification and Logistic Regression
Unsupervised Learning
Benefits of the Training
100% placement assistance
Individual Trainers
Iso Certificate
Mock Interviews
Weekly Test
Individual Trainer
Resume Building
Interview Preparation
Training Details
At the end of the Data Science, you will be able to write professional applications using Data Science...