Data analytics is the process of examining data sets in order to draw conclusions about the information they contain, increasingly with the aid of specialized systems and software. Data Analytics allows you to view statistical information about unstructured data, such as files and emails. With this information, you can quickly assess the state of your big data sources, take actionable steps to retrieve valuable storage space, and mitigate the risk of compliance-related issues.
MS ADVANCED EXCEL
Advanced Excel Course – Overview of the Basics of Excel
• Customizing common options in Excel
• Absolute and relative cells
• Protecting and un-protecting worksheets and cells
Advanced Excel Course – Working with Functions
• Writing conditional expressions (using IF)
• Using logical functions (AND, OR, NOT)
• Using lookup and reference functions (VLOOKUP, HLOOKUP, MATCH, INDEX)
• VlookUP with Exact Match, Approximate Match
• Nested VlookUP with Exact Match
• VlookUP with Tables, Dynamic Ranges
• Nested VlookUP with Exact Match
• Using VLookUP to consolidate Data from Multiple Sheets
Advanced Excel Course – 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 Course – Working with Templates
• Designing the structure of a template
• Using templates for standardization of worksheets
Advanced Excel Course – 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 Course – Working with Reports
• Creating subtotals
• Multiple-level subtotals
• Creating Pivot tables
• Formatting and customizing Pivot tables
• Using advanced options of Pivot tables
• Pivot charts
• Consolidating data from multiple sheets and files using Pivot tables
• Using external data sources
• Using data consolidation feature to consolidate data
• Show Value As ( % of Row, % of Column, Running Total, Compare with Specific Field)
• Viewing Subtotal under Pivot
• Creating Slicers
Advanced Excel Course – More Functions
• Date and time functions
• Text functions
• Database functions
• Power Functions (CountIf, CountIFS, SumIF, SumIfS)
Advanced Excel Course – Formatting
• Using auto formatting option for worksheets
• Using conditional formatting option for rows, columns and cells
Advanced Excel Course – Macros
• Relative & Absolute Macros
• Editing Macro’s
Advanced Excel Course – WhatIf Analysis
• Goal Seek
• Data Tables
• Scenario Manager
Advanced Excel Course – Charts
• 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
• (Data Modified in Excel, Chart would automatically get updated)
SQL SERVER
• Introduction to SQL
• Retrieving Data
• Updating Data
• Inserting Data
• Deleting Data
• Sorting and Filtering Data
• Advanced Filtering
• Summarizing Data
• Grouping Data
• Using Sub queries
• Joining Tables
• Managing Tables
• Using Views
• Stored Procedures
• Using Cursors
• Using Transactions
MS POWER BI
Power BI Desktop Tutorial
• Download and Install BI Desktop
• Add, Rename, Duplicate, and Delete Pages
• Connect to SQL Server
• Connect to Multiple Excel Sheets
• Get Data from Excel Files
• Get Data from Text Files
• Load Data from Multiple Data Sources
• Remove Unwanted Columns from Tables
Power BI Transformations
• Change the Data type of a Column
• Combine Multiple Tables
• Clusters
• Enter data or Copy & Paste data from Clipboard
• Format Dates
• Groups
• Hierarchies
• Joins
• Pivot Table
• Query Groups
• Reorder or Remove Columns
• Rename Column Names
• Rename Table Names
• Split Columns
• UnPivot Table
Power BI Charts Tutorial
• Area Chart
• Bar Chart
• Card
• Clustered Bar Chart
• Clustered Column Chart
• Column Chart
• Donut Chart
• Funnel Chart
• Heat Map
• Line Chart
• Clustered Column and Line Chart
• Line and Stacked Column Chart
• Matrix
• Multi-Row Card
• Pie Chart
• Ribbon Chart
• Stacked Area Chart
• Scatter Chart
• Stacked Bar Chart
• Stacked Column Chart
• Table
• Tree Map
• Waterfall Chart
• 100% Stacked Bar Chart
• 100% Stacked Column Chart
• Map
• Filled Map
• Format Area Chart
• Format Bar Chart
• Formatting Card
• Format Clustered Bar Chart
• Format Clustered Column Chart
• Formatting Column Chart
• Format Donut Chart
• Format Funnel Chart
• Formatting Line Chart
• Format Line & Clustered Column
• Format Line & Stacked Column
• Formatting Matrix
• Format Multi-Row Card
• Format Pie Chart
• Formatting Ribbon Chart
• Format Stacked Area Chart
• Formatting Scatter Chart
• Format Stacked Bar Chart
• Formatting Stacked Column Chart
• Format Table
• Format Tree Map
• Formatting Waterfall Chart
• R Script
• Format Map
• Format Filled Map
Power BI Filters Tutorial
• Slicer
• Basic Filters
• Advanced Filters
• Top N Filters
• Filters on Measures
• Page Level Filters
• Report Level Filters
• Drill through Filters
Power BI Tutorial on Calculated Fields
• Calculated Columns
• Conditional Columns
• Calculated Measures
• Calculated Tables
• Custom Columns
Power BI Tutorial on Dashboards
• Register to Pro Service
• Dashboard Introduction
• Connect Desktop with BI Service or Pro
• Publish Desktop Reports
• Create a Workspace
• Create a Dashboard
• Favourites
Working with Power BI Dashboards.
• Dashboard Actions
• Add Reports to a Dashboard
• Add Title to Dashboard
• How to Add Image to Dashboard
• Add Video to Dashboard
• Add Web Content to Dashboard
• Dashboard Settings
• Delete a Dashboard
• Pin Report to a Dashboard
Sharing Power BI Work
This Power Bi tutorial section covers the sharing of Work. I means, sharing reports, Dashboards, apps, Workspaces etc.
• Share a Dashboard
• Share a Report
• Sharing Workspace
• Publish App
• View Published App
Power BI DAX Tutorial
• Aggregate Functions
• Date Functions
• Logical Functions
• Math Functions
• String Functions
• Trigonometric Functions
VBA MACROS
Unit – 1 Sheet related Activities
• Simple data
• If statements
• Tool box controls
• Loops
• Multiple loops
• Data filtering & populating to listbox
• Data filtering & populating to another column in the same sheet
• Font related activities
• Font color activities
• Cells formatting activities
• Cells fill color activities
• Sheets renaming, protecting
• Sheets sorting
• Data sorting
• Blank rows, columns deleting
• Hide, unhide rows, cols
• Workbook save, delete activities
• Range, cells controlling
Unit – 2 Multiple sheets data activities
Unit – 3 Chart related activities
Unit – 4 Msgbox related activities
Unit – 5 Other applications related activities
Unit – 6 Transferring data from excel to word, access, and pdf files
Unit – 7 Administrator related activities
Unit – 8 Pivot Tables and Pivot Chart Related Programs
PYTHON
Introduction
History
Features
Setting up path
Working with Python
Basic Syntax
Variable and Data Types
Operator
Conditional
Statements
If If- else
Nested if-else
Looping
For
While
Nested loops
Control Statements
Break
Continue
Pass
String Manipulation
Accessing Strings
Basic Operations
String slices
Function and Methods
Lists
Introduction
Accessing list
Operations
Working with lists
Function and Methods
Tuple
Introduction
Accessing tuples
Operations
Working
Functions and Methods
Dictionaries
Introduction
Accessing values in dictionaries
Working with dictionaries
Properties
Functions
Defining a function
Calling a function
Types of functions
Function Arguments
Anonymous functions
Global and local variables
Modules
Importing module
Math module
Random module
Packages
Composition
Input-Output
Printing on screen
Reading data from keyboard
Opening and closing file
Reading and writing files
Functions
OOPs concept
Class and object
Attributes
Inheritance
Overloading
Overriding
Data hiding
Regular expressions
Match function
Search function
Matching VS Searching
Modifiers
Patterns
Exception Handling
Exception
Exception Handling
Except clause
Try? Finally clause
User Defined Exceptions
Multithreading
Thread
Starting a thread
Threading module
Synchronizing threads
Multithreaded Priority Queue
Tableau
Introduction and Overview
• Why Tableau? Why Visualization?
• Level Setting – Terminology
• Getting Started – creating some powerful visualizations quickly
• The Tableau Product Line
• Things you should know about Tableau
Getting Started
• Connecting to Data and introduction to data source concept
• Working with data files versus database server
• Understanding the Tableau workspace
• Dimensions and Measures
• Using Show Me!
• Tour of Shelves (How shelves and marks work)
• Building Basic Views
• Help Menu and Samples
• Saving and sharing your work
Analysis
• Creating Views
• Marks
• Size and Transparency
• Highlighting
• Working with Dates
• Date aggregations and date parts
• Discrete versus Continuous
• Dual Axis / Multiple Measures
• Combo Charts with different mark types
• Geographic Map Page Trails
• Heat Map
• Density Chart
• Scatter Plots
• Pie Charts and Bar Charts
• Small Multiples
• Working with aggregate versus disaggregate data
• Analyzing
• Sorting & Grouping
• Aliases
• Filtering and Quick Filters
• Cross-Tabs (Pivot Tables)
• Totals and Subtotals Drilling and Drill Through
• Aggregation and Disaggregation
• Percent of Total
• Working with Statistics and Trend lines
Getting Started with Calculated Fields
• Working with String Functions
• Basic Arithmetic Calculations
• Date Math
• Working with Totals
• Custom Aggregations
• Logic Statements
Formatting
• Options in Formatting your Visualization
• Working with Labels and Annotations
• Effective Use of Titles and Captions
• Introduction to Visual Best Practices
Building Interactive Dashboard
• Combining multiple visualizations into a dashboard
• Making your worksheet interactive by using actions and filters
• An Introduction to Best Practices in Visualization
SAS
Data Structures
• Introduction to SAS interface and library structure and definition
• Reading data using Datalines and importing and exporting datasets
• Infiles statement – reading raw data
• Formats and Informats
• Variable attributes and data modification using Data and Set statements
Data Management
• Using conditional statements to modify data – Where, If and Nested IF
• Appending and Merging datasets
• SAS Functions for data manipulation
• Loops and Arrays in SAS
Report Generation
• Basic Proc steps – like Proc Contents
• Proc Format, Proc Report and Proc Tabulate
• Proc steps for basic statistics – like Proc Univariate and Proc Means
Advanced SAS
Proc SQL
• Introduction to SQL – basic DBMS and RDBMS concepts
• Using SQL Procedures in SAS
• Using conditional statements in SQL and aggregate functions
• Data manipulation using Proc SQL
SAS Macros
• Introduction to Macros
• Local and Global declarations
• Using built-in macro procedures and functions
R Programming
Essential to R programming
• An Introduction to R
• Introduction to the R language
• Programming statistical graphics
• Programming with R
• Simulation
• Computational linear algebra
• Numerical optimization
Data Manipulation Techniques using R programming
• Data in R
• Reading and Writing Data
• R and Databases
• Dates
• Factors
• Subscribing
• Character Manipulation
• Data Aggregation
• Reshaping Data
Statistical Applications using R programming
• Basics
• The R Environment
• Probability and distributions
• Descriptive statistics and graphics
• One- and two-sample tests
• Regression and correlation
• Analysis of variance and the Kruskal–Wallis test
• Tabular data
• Power and the computation of sample size
• Advanced data handling
• Multiple Regression
• Linear models
• Logistic regression
• Survival analysis
• Rates and Poisson regression
• Nonlinear curve fitting
MACHINE LANGUAGE
Unit 1 – Introductory Topics
Unit 2 – Linear Regression and Feature Selection
Unit 3 – Linear Classification
Unit 4 – Support Vector Machines and Artificial Neural Networks
Unit 5 – Bayesian Learning and Decision Trees
Unit 6 – Evaluation Measures
Unit 7 – Hypothesis Testing
Unit 8 – Ensemble Methods
Unit 9 – Clustering
Unit 10 – Graphical Models
Unit 11 – Learning Theory and Expectation Maximization
Data Science
Unit 1 – Introduction to Python
Unit 2 – Basic Python
Unit 3 – Working with Libraries Like NumPy, Pandas, Matplotlib, Seaborn, SciPy, Sklearn in Python
Unit 4 – Working Experience with Pandas In Python
Unit 5 – Working Experience with Matplotlib Library in Python
Unit 6 – To Work With Seaborn Library (High-Level Interface for Drawing Attractive and Informative Statistical Graphics) In Python
Unit 7 – Introduction to SciPy and Sklearn Libraries in Python
Unit 8 – Statistical Analysis
Unit 9 – Hypothesis Testing
Unit 10 – Linear Regression
Unit 11 – Logistic Regression
Unit 12 – Discrete Probability Distribution
Unit 13 – Advanced Regression
Unit 14 – Multinomial Regression
Unit 15 – Data Mining Unsupervised – Clustering
Unit 16 – Dimension Reduction
Unit 17 – Data Mining Unsupervised – Network Analytics
Unit 18 – Data Mining Unsupervised – Association Rules
Unit 19 – Data Mining Unsupervised – Recommender System
Unit 20 – Machine Learning Classifiers – KNN
Unit 21 – An Introduction to Data Visualization
Unit 22 – Tableau Products and Usage
Unit 23 – Basic Charts On Tableau
Unit 24 – Connecting Tableau with Multiple Sheets and Data Sources
Unit 25 – Tableau Filters and Visualization Interactivity
Unit 26 – Interaction and Grouping the Data
Unit 27 – Time Series Chart
Unit 28 – Maps and Images in Tableau
Unit 29 – Advanced Charts in Tableau and Analytical Techniques
Unit 30 – Calculations on Tableau
Unit 31 – Tableau Integration with Other Tools
Unit 32 – Understand the Business Problem
Unit 33 – Data Collection
Unit 34 – Data Cleansing / Exploratory Data Analysis / Feature Engineering
Unit 35 – Data Mining
Unit 36 – Model Deployment
Unit 37 – Introduction to Big Data
Unit 38 – Hadoop and Its Components
Unit 39 – Linux OS and Virtualization Software’s
Unit 40 – Apache Hive
Unit 41 – Apache SQOOP
Unit 42 – Apache Spark
Unit 43 – Classifier – Naive Bayes
Unit 44 – Bagging and Boosting
Unit 45 – Decision Tree and Random Forest
Unit 46 – Black Box Methods
Unit 47 – Text Mining
Unit 48 – Natural Language Processing
Unit 49 – Forecasting
