• Introduction to Excel
  • Basic understanding of menus and toolbars
  • Introduction to various categories of functions:
    • Basics
    • Mathematical and Statistical
    • Date and Time
    • Logical
    • Lookup and Reference
    • Text and Information
• Mathematical Functions:
  • sum, sum, sum
  • count, counta, countblank
  • countif, countifs
  • average, average, averageif, averageifs
  • subtotal total, rand, randbetween
  • roundup, rounddown, round, sumproduct
• Date and Time Function:
  • date, day, month, year
  • eDate, eMonth, networkDay
  • weekday, weekNumber, weekday
  • hour, minute, second
  • now, today, time
• Text Functions & Data Validation:
  • Character, Clear, Code, Combine
  • Find, Find, Replace, Replace
  • Long, Right, Left, Middle
  • Lower, Upper, Justified
  • Text, Trim, Value, Larger, Smaller
  • Filter (Basic, Advanced, Conditional)
  • Sort (Ascending, Descending, Cell/Font Color)
  • Conditional formatting, data validation
  • Grouping and ungrouping, data splitting
• Statistical Function & Other Functions:
  • isna, isblank, iser, iseven
  • isod, islogical, istext
  • max, min, lane, right, left, mid
  • maxa, maxifs, median, miniifs
  • mina, vara, correl, geomen
• Logical Functions:
  • And, Or, If, Iferror, Not, Nested If
• Lookup & Reference Functions:
  • VLOOKUP, HLOOKUP, INDEX, MATCH
  • OFFSET, INDIRECT, ADDRESS, COLUMN
  • COLUMNS, ROW, ROWS, SELECT
  • Arrays concept in Lookup formula
  • Previous Special, Previous Link
• Pivot Tables - MIS, Data Analysis and Visualization:
  • Pivot Tables- What-If Analysis
  • Data Tables - One Variable and Two Variable
  • Data Analysis using Statistics
  • Descriptive Statistics, ANOVA, Moving Average
  • Testing of Hypothesis, Measuring Covariance and Correlation
  • Distributions, Regression
  • Graphs and Charts, Analysis Tool Pack
  • Solver, Histogram, Pareto, Waterfall
  • Data Import and Export, Protect/Unprotect Sheet/Workbook
  • Worksheet Formatting and Print Display
• Data Collection Methods:
  • Data Quality, Collaboration and Security
  • e.g., Share your workbook on a shared drive in a quality manner
• Analysis Single/Multidimensional Analysis:
  • e.g., Three Dimensional (3D) Tables, Data Tables
  • e.g., Sensitivity Analysis, Manual What-If Analysis
  • Threshold Values, Goal Seeking, One-Variable Data Table
  • Two-Variable Data Table
• Advanced Dashboards in Excel:
  • Overview of Chart Types, Chart Formatting
  • ActiveX Form Controls, Principles of Great Dashboard Design
  • Choosing the Right Chart to Display Data
  • Interactive with Form Controls
  • Combo Box Interactive dashboard with charts, check boxes, scroll bars and radio buttons
  • Form controls, Form controls for report automation
  • Data model using Power Pivot
• Two Live Report Development in Advanced Excel: (Real World Data)

• Dashboard reports help the user get a high-level overview of the business and make quick decisions. Dashboards are often called Management Information Systems (MIS), which provide organizations with the information they need to manage themselves efficiently and effectively.
• To define KPIs (Key Performance Indicators), customer service dashboards or project management dashboards (Gantt charts)
• Dashboard reports based on tables and numbers or charts/graphs or both.
• Introduction to Programming Logical Thinking
• Introduction to Flowcharts and Algorithms:
  • Define the objective, start and end point; identify the solution and break it down into sequential steps
  • Writing an algorithm:
    • Step-by-step instructions, flowcharts, process flow diagrams
• Excel Macros - An Introduction:
  • Complete Review of VBA Language (Sub, Function, Variable, Array, Loop, Logic...etc)
  • Excel Macro Language Review (VBA) including variables, data types, constants, arrays, operators, loops, expressions, logic decisions and calling
  • Overview of commanding Excel using VBA including discussion of objects, properties and methods
  • The Power of Macros - When, What, How to Use Macros
• Introduction to Object Oriented Programming
• Object, its functions, methods and properties
• Introduction to Events
• Description of Events, How and when to use Events, Preparation of ‘Macros’
• Visual Basic Editor (VBE) – Developer Tab, Security
  • Introduction to VBE, Properties Window, Project Explorer, Password Protection of Code
• How to Use VBE – Features, Intelligence Techniques, Options
  • Inbuilt VBE Help facility in Debugging Mode, Bookmarks, Breakpoints, Watch Window, Immediate Window and Local Window – Tips and Tricks
• Form Controls vs ActiveX Controls
• Entering Code
• Message Boxes and Input Boxes
• Working with Data in Excel through VBA
  • Data Types, Constants and Variables
  • Different types of data types; how and when to use variables to store information
  • for-next, for-each, do until, do loop, do-while, decision making and code branching
  • If-Then-Else, Select-Case, and/or Nested Conditions
• What are User Defined Functions? How to Create and Use them.
• Uses of array in VBA programming with one dimensional, multi-dimensional analysis and two dimensional
• Excel VBA Power Programming for VBA Macros:
  • Working with dynamic ranges
  • Protecting worksheets, cells and ranges
  • Working with multiple files
  • Opening and Saving Files
  • How to analyze data on multiple worksheets and create summary sheets
  • How to access the Windows file and folder system to open and close a workbook
  • How to Protect Your Code Against Errors
• How to Create a Basic Dashboard Using Excel and VBA
• Creating a Custom Business Worksheet Function in VBA
• How to Create a Basic Report Generation Tool Using Excel VBA, Microsoft Word, and PowerPoint
• How to Use the Excel Visual Basic Macro Recorder to Record Excel Actions in VBA and Then Interpret the Code
• Overview of User Form for Create Business Wizard:
  • Working with User Forms and User Form Events such as List Boxes, Combo Boxes, Option Buttons, Check Boxes, Text Boxes, Labels, Command Buttons, Toggle Buttons
• How to Create Dynamic Dashboards on User Forms with Various Controls
• How to Link Different User Forms to Each Other to Create a Complete Interface Between the User and the System
• Connections Between Excel VBA and Other Platforms In:
  • Connection between Internet Explorer and VBA to open internet website through VBA
  • Integrating PowerPoint and Excel VBA to Generate Presentations
  • How to establish connection between Excel VBA and Access database to update data in Access through VBA
  • How to establish a connection between Excel VBA and Outlook through VBA
  • How to establish a connection between Excel VBA and MS Word through VBA
• Testing and Debugging Your Code:
  • Types of Errors
  • Using Breakpoints
  • Debugging Techniques
  • Dialog Boxes
  • Using MsgBox Function
  • Using InputBox Function
  • Working with FileDialog
  • Working of GetOpenFilename Method
  • Working of GetSaveAsFilename Method
• Effective Error Handling
• Automation Development Reports and Live Projects

MS Access is a (RDBMS) relational database management system of Microsoft that combine the relational Microsoft Jet database engine with a software development & graphical user interface tools. It can also import & link to data stored in other applications & database.

Introduction to SQL:-
• Editors and platforms for learning SQL
• SQL Course Overview
• Setting up a test environment
• What is SQL?

Complete SQL in Class:-
• Quick-Start Introduction
• Using the Basic SELECT Statement
• Selecting Rows
• Selecting Columns
• Counting Rows
• Inserting Data
• Updating Data
• Deleting Data
• Importing and Exporting Data

Fundamentals of SQL:-
• Databases and Tables
• SQL Syntax Overview
• Data definition, data manipulation, data control, transaction control statements
• Creating Tables
• Deleting Tables
• Inserting Rows into Tables
• Deleting Rows from Tables
• What is NULL?
• Controlling column behavior with constraints
• Changing schema with ALTER
• Filtering data with WHERE, LIKE, and IN
• Removing duplicates with SELECT DISTINCT
• Sorting with ORDER BY

How relations work in SQL:-
• Understanding joins
• Accessing related tables with JOIN
• Multiple related tables

Explaining SQL strings:-
• About SQL strings
• Finding the length of a string
• Selecting part of a string
• Removing spaces with TRIM
• Making strings uppercase and lowercase

Numbers and SQL:-
• About numeric types
• Finding the type of a value
• Integer division and remainders
• Rounding numbers

SQL functions and clauses:-
• Aggregate functions MAX, MIN, AVG, SUM and COUNT, UPPER,LOWER,LENGTH
• Grouping in GROUP BY and HAVING clause combination

Triggers SQL:-
• Trigger keys Concepts
• Create Triggers for (Insert, Update, Delete)
• Change Triggers

What are Subselects and Views in SQL:-
• Creating Simple Subselects
• Searching in a Result Set
• Creating Views
• Creating Joined Views

Maintaining SQL Server Databases:-
• Backing up a Database
• Restoring a Database

• Module 4 a) Tableau
  • Module 1 – Getting Started with Tableau
    • Overview Of Tableau
    • Tableau Architecture
    • Installation And Configuration Of Tableau 10
  • Module 2 – Connecting to The Data
    • Managing Metadata
    • Managing Extracts
    • Data Sources
    • Cross-Database Joins
    • Data Aggregation And Data Ports
  • Tableau Charts
    • Bar Charts and Stacked Bars
    • Data Blending
    • Tree Maps and Scatter Plots
    • Individual Axis, Mixed Axis, Dual Axis and Combined Charts
  • Module 3 – Visual Analytics
    • Drill Down and Hierarchies
    • Sorting, Filtering and Grouping
    • Trend and Reference Lines
    • Forecasting and Clustering
    • Analysis with Cubes and MDX
  • Module 4 – Developing First Bar Chart
    • Connecting Tableau to Data File
    • Navigating Tableau
    • Calculated Fields
    • Adding Colors, Labels and Formatting
• Module 4 b) MS Power BI
  • A Quick Introduction
  • What is MSPBI and its scope
  • Learn the common workflow in MSPBI
  • Building blocks of MSPBI and its relations
  • Quick Demo of Creating Business Dashboard in MSPBI
  • MSPBI components
  • Old vs. new technologies
  • Power BI Desktop/Service/Mobile
  • Getting Business Data
  • Get data size for use with MSPBI
  • Combining two & more data sets (source data) for reporting
  • Tackling messy data in MSPBI
    • Clean and transform data
  • Modelling in Power BI
    • How to connect many different data sources
    • Manage data source (database) relationships
    • Unique keys
    • Calculated columns and more
    • Custom calculations to evaluate time-based functions
    • Create calculated tables based on DAX formulas and expressions
    • Easy to create and view views with customized models
    • Discover hierarchical drill-down tools for date fields
  • Data Visualization
    • Create & customize visualizations in MSPBI and its power
    • Use combination charts
• Module 5 – Time Series, Maps and Aggregation
  • Data Extracts and Time Series
  • Understanding Granularity, Aggregation and Level of Details
  • Default Location in Maps
  • Custom Geo Coding
  • Symbol Map and Filled Map
• Module 6 – First Dashboard Into Section
  • Joining Data In Tableau
  • Working With Maps and Hierarchies
  • Scatter plot and apply filters to different sheets
  • Creating First Dashboard
• Module 7 – Blending Data & Dual Axis Charts
  • Duplicate Values
  • Multiple Fields
  • Data Blending
  • Dual Axis Chart
  • Building Calculated Fields
• Module 8 – Table Calculation and Storytelling
  • Downloading Dataset and Connection Mapping
  • Building Table Calculation For Gender Bins and Distributions for Age
  • Tree Map Chart
  • Advanced Dashboard Storyline and Storytelling
• Module 9 – Data Preparation
  • Data Format
  • Data Interpreter
  • Multiple Columns And Pivot
  • Metadata Grid
  • Advanced Data Preparation
  • Create and format slicers with it
  • Map visualizations and its utilization
  • Use tables and matrixes
  • Long live bubbles scatter charts in action
  • Advanced funnel and waterfall charts
  • Get quick dashboard insights with gauges and numbers
  • Color your visualization world with colors, shapes and scales
  • Adding personal touch (logo, etc.) to reports and dashboards
  • Display and present your dashboard as you wish, with summarized data
  • How to control your report elements from overlapping with each other
  • Learn to drill into hierarchies
  • Manage how levels shared (Z order in reports)
  • How to use R visuals in MSPBI
• Data Exploring & Sharing
  • Quick insights in Power BI Service
  • Create and configure a dashboard
  • Share dashboard with your organization
  • Display and edit visuals- tiles full screen
  • Get more space on your dashboard
  • Install and configure a personal gateway
  • Excel and MSPBI
    • Import an Excel table into Power BI
    • Import Excel files with Data Model and Power View sheets
    • Connect One Drive for business to MSPBI
    • Excel data in Power BI summary
• DAX (Data Analysis Expression) Application
  • DAX and its basic building blocks
  • Create calculated columns (fields) & measures
  • MSPBI using DAX formulas
  • Breadth of functions available in DAX
  • User variables in DAX
  • How to Control your Report Elements Overlap with each other
  • Filter and evaluate tables using advanced table functions

• Module 5a) R-Programming
  • Module 1- Introduction to Business Analytics
    • Introduction to Business Analytics
    • Types of Analytics
    • Case Study on Walmart, Signet Bank
    • Data Science and its Importance
  • Module 2- Introduction to R
    • Introduction to R
    • Installing R
    • Installing R Studio
    • Workspace
    • R Package Setup
  • Module 3- R Programming
    • If Statement
    • For Statement
    • While Statement
    • Repeat Statement
    • Break and Next Statement
    • Switch Statement
    • Scan Statement
    • Executing Command in a File
  • Module 4 - R Data Structure
    • Data Structures
    • Vector
    • Matrix
    • Array
    • Data Frame
    • List
    • Factors
  • Module 5 - Apply Function DPLYR and Apply Function
    • Import Data File
    • DPLYR - Sequence Data
    • List, Operations and Methods
    • Sets, Dictionaries, Tuples, Strings
  • Module 5 - Functions
    • Defining a Function
    • Parameters and Variables
    • Using Global Statements
    • Keyword Arguments
    • Keyword Parameters Only
    • Return Statement
    • Varargs Parameters
    • Docstrings
  • Module 6 - Errors and Exception Handling
    • Errors
    • Exception Handling
    • Cleanup
  • Module 7 - Create Modules, From and Import Statements
    • Apply Function
  • Module 8 - Hypothesis Testing I
    • Introduction to Hypothesis Testing
    • Hypothesis Tests - t test, ANOVA
  • Module 9 - Hypothesis Testing II
    • Population Mean
    • Chi Square Test
    • Hypothesis Testing about F Distribution and F Ratio
  • Module 10 - Regression Analysis
    • Regression
    • Linear Regression Models
    • Non Linear Regression Models
  • Module 11 - Classification
    • Decision Trees
    • Logistic Regression
    • Bayesian
    • Support Vector Machines
  • Module 12 - Clustering
    • Clustering
    • K-Means Clustering and Case Study
    • DBSCAN Clustering and Case Study
    • Hierarchical Clustering
  • Module 13 - Association
    • Association
    • Apriori

• Introduction to Python Programming for Data Analysis
  • Data types: int, float, str etc
  • Operations on data types
  • Data structures: list, dict, tuples, set
  • Iterators/iterables functions
  • Pandas Dataframe, NumPy arrays
  • Data manipulation in pandas: slicing, subset, cross tabulation, aggregation
  • Reference Data for running example:
    • XYZ Company Dataset
    • Titanic
• Module 6.2 Data Exploration
  • Univariate Statistics: mean, median, std.
  • Bivariate Statistics: correlation, covariance
  • Plots using Matplotlib, seaborn
  • Concepts of inferential statistics
  • Standardization
  • Log transform
  • Dummy variable creation
  • Dimensionality Reduction + Linear Transformation
    • PCA
    • LDA
  • Matrix Determinant
  • Matrix multiplication
  • Element wise operations
• Module 6.3 Supervised Learning
  • Linear classifier: logistic regression
  • Linear classifier: Support Vector Classifier
  • Tree Classifier: Decision Trees
  • Ensemble Classifier: RF, Boosted Trees
  • Cost Function minimization
  • Scikit learn library
  • Regression
  • Machine Learning Concepts
    • Bias, Variance
    • Regularization
    • Hyperparameter tuning
    • Parametric / non-parametric methods
    • Cross validation
    • Sampling data
• Module 6.4 Advanced Unsupervised Learning
  • K means Clustering
  • t-SNE
  • Agglomerative Clustering
• Module 6.5 Introduction to Text Processing
  • Tokenization
  • N-grams
  • TF-IDF
  • Cosine similarity
  • Text Classification
  • Topic Modelling
  • spaCy library
• Module 6.6 Introduction to Deep Learning
  • Understanding a perceptron
  • Forward propagation
  • Backward propagation
  • Parameter update
  • CNN
  • RNN: GRU, LSTM
  • Regularization: dropout, data augmentation
  • Optimization: Momentum, Adam, AdamW