Greetings from SS IT Software Online Training.
Data Analyst Training Course Content
Course Duration: 60 Days (Daily 1 Hour Per Session)
Training Type: Online Live Interactive Session
Course Consists Of
1. Excel (Basic & Advanced)
2. MySQL
3. Tableau
4. R Programming Fundamentals
5. Python Programming Fundamentals
EXCEL: BASICS TO ADVANCED
Advanced Excel — Basic
An overview of the screen, navigation and basic spreadsheet concepts
Customizing the Ribbon
Worksheets
Format Cells
Various selection techniques
Shortcuts Keys
Protecting and un-protecting worksheets
Advanced Excel -Sorting and Filtering Data
Sorting tables
Using multiple-level sorting
Using custom sorting
Filtering data for selected view (AutoFilter)
Using advanced filter options
Advanced Excel -Data Validations
Specifying a valid range of values for a cell
Specifying a list of valid values for a cell
Specifying custom validations based on formula for a cell
Advanced Excel -Text Function
Upper, Lower, Proper
left, Mid, Right
Trim, Len, Exact
Concatenate
Advanced Excel -Function & Formula
Basic Function -Sum, Average, Max, Min, Count, Count A
Conditional Formatting
Logical functions (AND, OR, NOT)
Lookup and reference functions (VLOOKUP,
HLOOKUP, MATCH, INDEX)
V-lookup with Exact Match, Approximate Match
Nested V-lookup with Exact Match
V-lookup with Tables, Dynamic Ranges
Nested V-V-lookup with Exact Match
Using V-lookup to consolidate Data from Multiple Sheets
Mathematical Functions
Sumif, Countlf, Averagelf etc
Date & Time Function
Advanced Excel - Pivot Tables
Creating Simple Pivot Tables
Basic and advanced value field setting
Grouping Based on number and Dates
Calculated field and Calculated items
Advanced Excel —Charts & Slicers
Using Charts
Formatting Charts
Using 3D Graphs
Using Bar and Line Chart together
Using Secondary Axis in Graphs
Sharing Charts with PowerPoint / MS Word, Dynamically
Advanced Excel -Working with Templates
Designing the structure of a template
Using templates for standardization of worksheets
Advanced Excel -VBA-Macro
Introduction to VBA
What is VBA?
What can you do with VBA?
What can you do with VBA?
Procedures and Function in VBA
Advanced Excel -Variable in VBA
What are Variables?
Using Non-declared variables
Variable Data Types
Advanced Excel - Message - Box and input Box Functions
Customize Message-Box and Input-box
Reading cell values into messages
Various button groups in VBA
VBA Coding Advanced function
If and Select statement
Looping in VBA
Mail Function -send automated email
Automated report will be shown
SOL
Database Constraints
Types of Constraints
Relational Integrity Constraints
Key Constraints
Domain Constraints
Referential integrity
Types of Constraints
Primary and Foreign Keys
Application of Indexes
Checking Constraints
Alter Tables
SQL Transactions
SQL Transactions
Examples
ACID Properties
TCL Statements
Start, Commit and Rollback Statements
Auto Commit
SavePoints
Identifier
Rollback and Release
Database Objects
Tables
Creating, Altering and dropping tables
Sequences
Auto Increments
Re-Sequencing
Views
Advantages
Creating and Dropping Views
Indexes
Types of Indexes
B-Tree and Hash Indexes
Creating and dropping Indexes
Introduction to Databases
Databases
Introduction to DBMS
Popular DBMS Software
Concepts of RDBMS
Tables
Tuples
Attributes
Normalization
First Normal Form
Second Normal Form
Third Normal Form
NoSQL Databases
Types of NOSQL
Comparison
SQL Commands
Types of SQL Commands
Data Definition Language
Create, Drop, Truncate, Alter and Rename Objects
Data Query Language
Select Statements
Data Manipulation Language
DCL and TCL
Grant, Revoke and transaction statements
SQL Data Types
Numeric, Date and Time, LOB Types
DML Commands
Insert, Update and Delete Statements
DDL Commands
Create and Drop Database
Stored Procedures and Functions
Stored Objects
Types of Stored Objects
Stored Procedures
Create, call and drop stored procedures
Using Variables
Handling Exceptions
Named Errors and Resigns
Programming
If-then-Else and Case Statements
Loops
Repeat and Leave Statements
Cursors
Operators and Functions
Joining Tables
Inner Join, Left Join, Right join
Advantages of Procedures
Database Triggers Accessing Database from R and Python
Triggers
Database Triggers
Data Definition Language (DDL) Triggers
Data Manipulation Language (DML) Triggers
CLR Triggers
Logon Triggers
Triggers v/s Stored Procedures
Accessing Database from R
Install R Packages
Configuration Information
Python Database Access
Databases Supported
Libraries
Read Operations
Insert, Update and Delete
Performing Transactions
Handling Errors
TABLEAU
What is Data Visualization
Advantages & Disadvantages of visualizations
Age of Big data
Why Data visualization Important
Understanding data
Examples of Data visualizations in Action
Different data visualizations
Principles of Visualizations
Design Principles
Best Practices
Data Viz Inspiration
Tableau —Data Visualization Tool
Introduction to Tableau
What is Tableau
Overview of Tableau Tool (Servers, data, visualizations)
Tableau Architecture
Advantages & Disadvantages
Different Products of Tableau
Tableau Desktop
Tableau Public
Tableau Prep
Tableau Online
Tableau Server
Tableau Analytics
Extensions in Tableau
Tableau Workbook
Tableau Data Source
Tableau Data Extract
Tableau Packaged Workbook (TWBxX)
Tableau Packaged Data Source (TDSX)
Tableau Book Mark
Tableau Map Source
Tableau Preferences
Features of Tableau Desktop
Connecting to Data from servers
Connecting Data from ODBC
Connecting data from local repositories
Tableau-Joins and Data Pane
What are joins in Tableau?
Types of Joins in Tableau
Inner Join
Left Join
Right Join
Full Outer Join
Union
Creating Joins Using Data
Tableau Data Pane
Dimensions
Measures
Parameters
Sets
Pivot Table and Split Tables in Tableau
In built Charts in Tableau
Basic Charts
Text Tables
Highlight Tables
Bar charts
Stacked Bar
Line Graphs
Dual axis
Pie chart etc.
Maps in Tableau
Symbol Maps
Filled Maps
Combined maps
Map layers
WMS
Polygon Maps
Custom coding etc.
How to Interpret Bullet Graphs
Actual Profit vs Budget Profit Analysis
Market wide Analysis etc
How to Interpret Scatter Plot
Correlation Analysis
Direction of Relationship
Strength of Relationship etc.
How to Interpret Histogram
Distributive Analysis, Bin Sizes, Custom bin sizing etc.
How to Interpret Box Plot chart
Distributive Analysis, Quartile Analysis, 5 Point Chart Analysis
Data Interpretation
Understanding of data types, discussing about dimensions and measures etc.
Creating Calculated Fields
Attribute functions
Quick table calculations
Creation of calculated fields
Aggregate and disaggregate functions etc.
Logical Functions
Understanding If-else statements, applications of if-else
statements (egg: high profit, low profit etc.)
Case-lf Function
Understanding Case Statements with examples
Applications of case statements
ZN Function
Creation of ZN functions
Application of ZN functions
Dealing with calculated fields etc.
Ad-Hoc Calculations
Calculations using parameters
Sets
Filters etcand applications
Manipulating Text-Left & Right Functions
Understanding different string functions etc.
Pre-Defined Analytics
Forecasting, LOD Expressions, Functions, Groups, Filters, etc
Dashboards Hands-On in Tableau
Understanding concept of Dashboards
Building Interactive dashboards
Dashboard actions, etc.
Story Hands-On in Tableau
Relevance of stories in Dashboards, Working with examples on stories etc.
Animated Visualization Hands-On
Animation charts, play controls, page shelf, applications of animation charts
Tools for Sharing Information
Understanding Tableau Reader, Tableau online etc.
Publishing our Workbooks in Tableau Server
Exploring publishing options using Tableau, Discussing sharing of workbooks, etc.
Connecting Tableau with Tableau Server
Overview of how to connect Tableau with Tableau server.
What is R?
R software, installation, R studio, Understanding basic interface of R.
Connecting Tableau with R
Reserve package, using functions such as SCRIPT_REAL etc, Understanding with
examples.
How to integrate Tableau with R?
Reserve package, external connections, ports, Understanding with example
BASICS OF R
Introduction of R
Data Types
Data structure
Decision making statements
Condition Loops
Flow control statements
If Statements
For Loops
While Loops
Built Functions in R: Base, Datasets, dplyrand ggplot
BASICS OF PYTHON
Introduction to Python
Introduction to Python & Data Science Python Installation on laptops
Python Basics -Variables -Python Build in functions
Modules -Python Libraries installation using PIP
Python Basics -Python Operators
Python Basics -Flow Control Statements -If Statements -VWhile Loops
Python Basics -Data & time modules in python -Interfaces in Python
-For Loops
Python modules for Data Analysis
Python Basics —Web Scrapping-Python custom functions
-Lambda Function -Regular Expressions
Data science Life cycle -Numpy Module
Data science Life cycle -Pandas Module
Data science Life cycle —Matplolib Module
For More Details / Enroll for Upcoming Batches Online Training, Please WhatsApp Us at: + 91 90366
34486 /+91 79899 38421
Thanks & Regards
SS IT Software Online Training
📧 Email: info@ssitsot.com
📞 Mobile: +91 9036634486 (WhatsApp) / +91 7989938421
🌐 www.ssitsot.com
💥 Thank you 💥
