Data Analytics Training at ANJANA INFOTECH

Data Analytics

Data analysis is a process of inspecting, cleansing, transforming, and modelling data with the goal of discovering useful information, informing conclusions, and supporting decision-making.

Syllabus

Statistics:

• Correlation
• Linear Regression
• Non Linear Regression
• Predictive time series forecasting
• K means clustering
• P value
• Find outlier
• Neural Network
• Error Measure

TABLEAU

Tableue Introduction

•  Tableue Architecture
•  The Tableue Interface
•  Distributing and Publishing

Tableue Pre Builder

•  The Input Step
•  The Cleaning Step
•  Group and Replace
•  The Profile Pane
•  The Pivot Step
•  The Aggregate Step
•  The Join Step
•  The Union Step

Connecting to Data

•  Getting Started with Data
•  Managing Metadata
•  Saving and Publishing Data Sources
•  Data Prep with Text and Excel Files
•  Join Types with Union
•  Cross-database Joins
•  Data Blending
•  Connecting to PDFs

Visual Analytics

•  Getting Started with Visual Analytics
•  Drill Down and Hierarchies
•  Sorting
•  Grouping
•  Creating Sets
•  Set Actions
•  Ways to Filter
•  Using the Filter Shelf
•  Interactive Filters
•  Parameters
•  Formatting
•  Basic Tooltips & Viz in Tooltip
•  Trend Lines
•  Reference Lines
•  Forecasting
•  Clustering

Dashboards and Stories

•  Getting Started with Dashboards and Stories
•  Building a Dashboard
•  Dashboard Objects
•  Dashboard Formatting
•  Dashboard Interactivity Using Actions
•  Dashboard Extensions
•  Story Point

Mapping

•  Getting Started with Mapping
•  Maps in Tableau
•  Editing Unrecognized Locations
•  Spatial Files
•  The Density Mark Type (Heat maps
•  Expanding Tableau's Mapping Capabilities
•  Custom Geocoding
•  Polygon Maps
•  Mapbox Integration

Calculations

•  Getting Started with Calculations
•  Calculation Syntax
•  Introduction to LOD Expressions
•  Intro to Table Calculations
•  Modifying Table Calculations
•  Aggregate Calculations
•  Date Calculations
•  Logic Calculations
•  String Calculations
•  Number Calculations
• Type Calculations
•  Conceptual Topics with LOD Expressions
•  Aggregation and Replication with LOD Expressions
•  Nested LOD Expressions
•  How to Integrate R and Tableau
•  Using R within Tableau

Why Tableue is doing it

•  Understanding Pill Types
•  Measure Names and Measure Values
•  Aggregation, Granularity, and Ratio Calculations
•  When to Blend and When to Join
•  One-to-many relationships
•  Joins inflating the number of rows
•  Filtering for Top Across Panes

How to

•  Using a Parameter to Change Fields
•  Finding the Second Purchase Date with LOD Expressions
•  Cleaning Data by Bulk Re-aliasing
•  Bollinger Bands
•  Bump Charts
•  Control Charts
•  Funnel Charts
•  Step and Jump Lines
•  Pareto Charts
•  Waterfall Charts

1: Introduction To Python

• Installation and Working with Python
• Understanding Python variables
• Python basic Operators
• Understanding python blocks

2: Python Data Types

• Declaring and using Numeric data types: int, float, complex
• Using string data type and string operations
• Defining list and list slicing
• Use of Tuple, Set, Dictionary data type

3: Python Program Flow Control

• Conditional blocks using if, else and elif
• Simple for loops in python
• For loop using ranges, string, list and dictionaries
• Use of while loops in python
• Loop manipulation using pass, continue, break and else
• Programming using Python conditional and loops block

4: Python Functions, Modules and Packages

• Organizing python codes using functions
• Organizing python projects into modules
• Importing own module as well as external modules
• Understanding Packages
• Powerful Lamda function in python
• Programming using functions, modules and external packages

5: Python String, List and Dictionary Manipulations

• Building blocks of python programs
• Understanding string in build methods
• List manipulation using in build methods
• Dictionary manipulation
• Programming using string, list and dictionary in build function

6: Python File Operation

• Reading config files in python
• Writing log files in python
• Understanding read functions, read(), readline() and readlines()
• Understanding write functions, write() and writelines()
• Manipulating file pointer using seek
• Programming using file operations

7: Python Object Oriented Programming – Oops

• Concept of class, object and instances
• Constructor, class attributes and destructors
• Real time use of class in live projects
• Inheritance, overlapping and overloading operators
• Adding and retrieving dynamic attributes of classes
• Programming using Oops support

8: Python Exception Handling

• try….except…else
• try-finally clause
• Avoiding code break using exception handling
• Safe guarding file operation using exception handling
• Handling and helping developer with error code
• Programming using Exception handling