Kalyan Best Web Designing Service | IT Institute

Data Science Course Training

Duration: 3 Months

Looking for the best data science course in Kalyan? We offer top-notch data science training and certification in Thane, along with advanced data science classes in Dombivli and a comprehensive data science advanced course in Badlapur. Join our leading data science institute in Kalyan for practical, hands-on training and take the next step in your career with confidence!

Data Science
Advance Excel
MS SQL Server
Python
Tableau

Download Advance Excel Syllabus

Excel Introduction

An overview of the screen, navigation and basic spreadsheet concepts
Various selection techniques
Shortcut Keys
What is Spreadsheet
Using Basic Functions
Using Functions – Sum, Average, Max, Min, Count, Counta
Subtotal
Use of Ctrl+D
Absolute, Mixed and Relative Referencing
Formatting and Proofing
Currency Format
Format Painter
Formatting Dates
Custom and Special Formats
Formatting Cells with Number formats, Font formats, Alignment, Borders
Basic conditional formatting
Mathematical Functions
SumIf, SumIfs CountIf, CountIfs AverageIf, AverageIfs, Nested IF, IFERROR Statement, AND, OR, NOT
Protecting Excel
File Level Protection
Workbook, Worksheet Protection
Text Functions
Upper, Lower, Proper
Left, Mid, Right
Trim, Len, Exact
Concatenate
Find, Substitute
Date and Time Functions
Today, Now
Day, Month, Year
Date, Date if, DateAdd
EOMonth, Weekday
Advanced Paste Special Techniques
Paste Formulas, Paste Formats
Paste Validations
Transpose Tables
New in Excel 2013 / 2016 & 365
New Charts – Tree map & Waterfall
Sunburst, Box and whisker Charts
Combo Charts – Secondary Axis
Adding Slicers Tool in Pivot & Tables
Using Power Map and Power View
Forecast Sheet
Sparklines -Line, Column & Win/ Loss
Using 3-D Map
New Controls in Pivot Table – Field, Items and Sets
Various Time Lines in Pivot Table
Auto complete a data range and list
Quick Analysis Tool
Smart Lookup and manage Store
Sorting and Filtering
Filtering on Text, Numbers & Colors
Sorting Options
Advanced Filters on 15-20 different criteria(s)
Printing Workbooks
Setting Up Print Area
Customizing Headers & Footers
Designing the structure of a template
Print Titles –Repeat Rows / Columns
Advance Excel
What If Analysis
Goal Seek
Scenario Analysis
Data Tables (PMT Function)
Solver Tool
Logical Functions
If Function
Nested If
Complex if and or functions
Data Validation
Number, Date & Time Validation
Text and List Validation
Custom validations based on formula for a cell
Dynamic Dropdown List Creation using Data Validation – Dependency List
Lookup Functions
Vlookup / HLookup
Index and Match
Creating Smooth User Interface Using Lookup
Reverse Lookup using Choose Function
Worksheet linking using Indirect
Vlookup with Helper Column
Pivot Tables
Creating Simple Pivot Tables
Basic and Advanced Value Field Setting
Classic Pivot table
Choosing Field
Filtering PivotTables
Modifying PivotTable Data
Grouping based on numbers and Dates
Calculated Field & Calculated Items
Arrays Functions
What are the Array Formulas, Use of the Array Formulas?
Basic Examples of Arrays (Using ctrl+shift+enter).
Array with if, len and mid functions formulas.
Array with Lookup functions.
Advanced Use of formulas with Array.
Charts and slicers
Various Charts i.e. Bar Charts / Pie Charts / Line Charts
Using SLICERS, Filter data with Slicers
Manage Primary and Secondary Axis
Excel Dashboard
Planning a Dashboard
Adding Tables and Charts to Dashboard
Adding Dynamic Contents to Dashboard
If and select statements
Simple If Statements
The Elseif Statements
Defining select case statements

Download SQl Server Syllabus

Introduction Of Ms Sql Server
Installation Of Ms Sql Server
Sql Command
Ddl – Data Definition Language
Dql – Data Query Language
Dml – Data Manipulation Language
Create
Alter
Add
Modify
Rename
Drop
Truncate
Insert
Update
Delete
Merge
Aggregate And Built In Function
Max()
Min()
Length()
Avg()
Count()
Substr()
Sysdate()
Instr()
Trim()
Wildcard Search
Partition
Rank & Dense Rank
Constraints
Column Level Constraint
Table Level Constraints
Cascading Constraints
Not Null Constraint
Unique Constraint
Primary Key Constraint
Check Constraint
Foreign Key Constraint
Alter Table With Constraint
Group Function
In, Not In Clauses
Coalesce
Null, Not Null
Subqueries
Single Row Subquery
Multiple Row Subquery
Group Function Using Subquery
All With Subquery
Not In With Subquery
String Handling
Join (Display Data From Multiple Tables)
Innerjoin
Leftouterjoin
Rightouterjoin
Equijoin
Non-Equijoin
Outer Join
Self Join
Creating View
Simple View
Where Using View
DML Operation Using View
Force Using View
How To Use Sequence
Index
Using Set Operator
Union
Union All
Intersect
Distinct
Subqueries
Trigger & Types Of Trigger
Built-In Function
User-Defined Function
Stored Procedure
Validation Inside Stored Procedure
Try Catch
Temp Table Or Hash Table
Cursor
Profiler
Privileges In Sql
Create User
Grants & Revoke
Role

Download Powe BI Syllabus

Introduction to Power BI
Introduction to Data warehouse
Data warehouse Tools
What is Power BI?
Power BI – Flow of Activity
Building Blocks of Power BI
Power BI – Primary Tools: Power Pivot, Power Query, Power View, Power Map, Power Q&A, Power BI Desktop
Power BI Desktop
Power BI Desktop – Install
Data Sources and Connections
Connect to Data in Power BI Desktop
How to use Query Editor in Power BI
Advanced Data Changes and Transformation
Views in Power BI Desktop
Modeling Data - Manage Data Relationship, Create Calculated Columns, Optimize Data Models
Data Analysis Expressions (DAX)
What is DAX?
Data Types in DAX
Calculation Types
DAX Functions: Date and Time, Time Intelligence, Information, Logical, Mathematical, Statistical, Text, Aggregate Measures in DAX
Table Relationships and DAX
Data visualization
Why Data Visualization
Practices for Data Visualization
How to use Visual in Power BI
Reports in Power BI
Charts in Power BI (Scatter, Waterfall, Funnel)
Slicers
Filteration
Map Visualizations
Gauges and Single Number Cards
Custom visualizations
What Are Custom Visuals?
Office Store
Downloading Custom Visuals
Importing Custom Visuals in Power BI Report
KPI Visuals
Data Binding in Power BI
Power BI Integration Page And Administration
Data Gateways
Content packs
Power BI Report Server
Power BI Embedded
Power BI Embedded Conceptual Model
Workspace Collection
Adding Power BI content to a Workspace
Application Authentication Tokens
Parts of Power BI embedded - REST API

Download Python Syllabus

Python Overview
Installation & Getting Started
What is Syntax?
Python Comments
Python Variables
Data Types
Python Numbers
Data Conversion
Type Casting
Python Operators
Python Booleans
Python Strings
Operation on Strings
String Methods
Format Strings
Escape Characters
Python Lists
List Indexes
Add List Items
Remove List Items
Change List Items
List Comprehension
List Methods
Python Tuples
Tuple Indexes
Manipulating Tuples
Unpack Tuples
Python Sets
Add/Remove Set Items
Join Sets
Set Methods
Python Dictionaries
Access Items
Add/Remove Items
Copy Dictionaries
if Statement
if-else Statement
elif Statement
Nested if Statement
Python for Loop
Python while Loop
Nested Loops
Control Statements
Python Functions
Function Arguments
return Statement
Python Recursion
Python Modules
Python Packages
Python OOPS
self method
-init- method
Tkinter
Conectivity of Mysql
Inserting, Fetching data from Mysql
Creating Registration Form
Project Work

Please Fill Your Information

Data Science Course Training

Start Learning Today - Enroll Now and Begin Learning!

Fill Form And Download - Syllabus