Module 1:- Getting Started with Excel

• Introduction to Excel 2013/2016/2019/Office 365
• Application Interface and Key Components of Excel
• Navigating Through Excel Ribbon Tabs
• Exploring Important Excel Options*
• Live Session Exercise
• Splitting data from Single Column into multiple
• 10 Examples to use Auto-fill and Flash Fill
• Magic of Go-To Special
• Merge/Unmerge Cells & Wrap Text
• Extracting Unique Values & Important Ribbon, General and Data Entry Keyboard Shortcuts

Module 2:- Formatting Essentials

• Formatting Essentials Introduction
• Custom Cell Number Formats
• Custom Date/Time Formats
• Working with Comments / Notes
• Format Painter – A Quick way to copy ‘Formatting Attribute’
• Paste Special
• Table, Table Styles & Formatting
• Freeze Panes

Module 3:- Functions & Formulas

• Introduction to Excel Functions and Formulas
• Basics of Functions & Formulas
• Working with Cell References Types
• Most Used Basics & Advanced Functions & Formulas
• Working with Array Formulas
• Creating Customized Formulas Step-by-Step with Live examples
• Creating and Working with Dynamic Ranges using Function and Excel Table features
• Formulas Debugging / Formulas Auditing
• Types of Formula Errors / Error Handling Tricks
• Text Functions: – CLEAN, CONCATENATE, LEFT, RIGHT, MID, LEN, FIND, SEARCH, SUBSTITUTE, and TEXT, etc.
• Date & Time Functions: – DATE, DAYS, TIME, NOW, WEEKNUM, WORKDAY, and WORKDAY.INTL etc.
• Math & Trig Functions: – INT, MOD, ROUND, ROUNDDOWN, SUMIF, SUMIFS, SUMPRODUCT etc.
• Statistical Functions: – AVERAGE, COUNT, COUNTA, COUNTBLANK, MAX, MIN, LARGE, etc.
• Logical Functions: – IF, IFS, AND, OR, and IFERROR.
• Lookup & Reference Functions: – FORMULATEXT, VLOOKUP, HLOOKUP, INDEX, MATCH, INDIRECT, and OFFSET
• Newly Introduced Functions in Recent Version of Excel*: – CONCAT, TEXTJOIN, IFS, SWITCH, DGET, UNIQUE, FILTER, etc.
• Nested Conditions/Customize Formulas*

Module 4:- Data Analysis

• Data Sorting
• Data Filtering
• Named Ranges
• 10 different ways to use Conditional Formatting
• 10 different use of Data Validation
• What-If Analysis

Module 5:- Excel Charts

• Introduction to Excel Charts
• Exploring the most commonly used Charts and Templates
• Basics of Charts
• Selecting Requirement based Charts
• Working with Basic Charts:
• Creating Customized / Advanced Charts
• Creating Dynamic Chart
• Working with Dynamic Interactive Charts in Excel using Drop Down
• Working with Chart Elements, Formatting, Chart Styles, Properties, etc.

Module 6:- Pivot Tables

• Introduction to Pivot Table
• Creating a Pivot Table
• Use of Calculated Fields/Items
• Pivot Table Formatting
• Grouping Items & Summarizing data in Pivot Tables
• Grouping and Bucketing data in Pivot Table
• Changing/Modifying Data Sources
• Working with Pivot Table Designs & Layouts
• Exploring Important Pivot Table Options & Field Settings
• Pivot Table Filters
• Changing Pivot Table Summary Calculation
• Use of Slicers in Pivot Table
• Using Source Data to Convert into Infographic Summary
• Introduction to Pivot Charts

Module 1:- Getting Started with My SQL

• An Introduction and Overview of MySQL
• Installation and GUI Tools
• An Overview

Module 2:- My SQL Fundamentals

• Introducing SELECT statement
• Introducing WHERE clause
• Sort result with ORDER BY
• Using FROM to specify the source tables
• Importance of Clause Orders
• Data Modification tricks

Module 3:- Creating Database & Tables

• Creating a database
• Creating a table
• Creating Indexes
• Controlling column behavior with constraints
• Using foreign key constraints
• Creating an ID column
• Changing a schema with ALTER
• Introducing NULL and NOT_NULL
• Introduction to MySQL Data Types
• Setting up default values
• MySQL Warnings
• Alerting a table

Module 4:- My SQL Functions & Clause

• Introduction to MySQL Functions
• String Functions – CONCAT, SUBSTRING, REPLACE, REVERSE, LENGTH, UPPER, LCASE etc.
• Aggregate Functions – COUNT, MIN, MAX, SUM, AVG, ROUND etc
• Date/Time Functions – CURDATE, CURTIME, CURRENT_DATE, LOCALTIME etc.
• Control Flow Functions – IF, IFNULL, NULLIF etc.

Module 5:- Multiple Tables & Joins

• Introduction to JOINS
• Different types of JOINS
• JOINS and Aliases
• Multiple Table Joins
• Creating a simple Subselect
• Understanding of Primary keys and Foreign keys

Module 6:- Transactions, Stored Routines & Triggers

• Transactions & Stored Routines
• Triggers

Bonus Modules

• Creating a New User Login
• Granting access to new users
• Backup and Restore databases
• Important Keyboard Shortcuts Guide
• Session Study Material
• Situational Case Studies for Best Practice and Getting Ready for Corporate World
• 6 Months Live Support via Phone/Email/Messages

Module 1:- Getting Started with Tableau

• Introduction to Data Visualization
• Leading Data Visualization Tools
• Introduction to Tableau
• Exploring Interface and Important Key Components
• Navigating Through Tableau Menu Tabs
• Exploring Each Menu Tab i.e. File, Data, Worksheet, Dashboard, Story, Analysis, Map, Format, Server, etc.*
• Tableau – Design Flow
• File Types
• Tableau Data Types
• Show Me
• Data Terminology

Module 2:- Connecting to Data with Tableau Desktop

• Introduction to Data Connection
• Data Source Interface
• Types of Data Connections
• Extracting Data
• Custom Data View
• Joins and Unions
• Data Blending
• Live Connection Vs Extract
• Field Operations
• Basic Project Activity

Module 3:- Examining & Filtering

• The Sheet Interface
• Dimensions & Measures
• Hierarchies
• Data Granularity
• Highlighting
• Data Sorting
• Grouping Data
• Data Filtering
• Data Source Filters
• The Filter Shelf
• Dimension Filters & Card Modes
• Context Filters
• Measure Filters
• Creating Sets

Module 4:- Field Types & Charts

• Utilize Auto-Generated Fields
• Use Titles, Captions and Tooltips Effectively
• Creating Bins
• ToolTip
• Basic Charts

Module 5:- Calculations in Tableau

• What are Calculations
• Methods to Create Calculated Field
• Introduction to Tableau Functions
• Operator and Syntax Conventions
• Introduction to Table Calculations

Module 6:- Level of Detail (LOD) Expression

• Level of Detail (LOD) Calculations
• Live Use Cases of LOD
• Introduction to Parameters
• Parameters Data Type Options

Module 7:- Geographical Visualization

• Introduction to Geographic Visualizations
• Assigning Geographical Locations
• Spatial Files
• Map Types
• Custom Geocoding
• Background Image

Module 8:- Advanced Charts in Tableau

• Introduction to Advanced Charts
• Bar in Bar Chart
• Bullet Chart
• Pareto Chart
• Gantt Chart
• Hierarchy and Tree Maps
• Box and Whisker’s Plot
• Waterfall Chart
• Step and Jump Lines
• Maps on a Scatter Plot
• Bubble Chart
• Control Chart
• Funnel Chart
• Packaged Bubbles
• Word Cloud
• Donut Chart
• Trendlines
• Reference Line, Bands, and Distributions

Module 9:- Dashboard & Stories

• Introduction to Dashboards
• The Dashboard Interface
• Important Dashboard Objects
• Adding Objects to the Dashboard
• Building a Dashboard
• Dashboard Design and Formatting
• Types of Actions
• Designing Dashboard for Tablets & Mobile-Phones
• Story Points
• Sharing Workbook
• Wrapping up Tableau Program