• Classroom Training   • Live Online Training   • Corporate Training  • Live Projects & Guidance 

Data Analytics and Visualization

PostgreSQL
Courses Information

Data analytics involves inspecting, cleaning, transforming, and modeling data with the goal of discovering useful information, drawing conclusions, and supporting decision-making.

Curriculum
ADVANCED EXCEL
Module 1: Getting to Know Excel
  • The Ribbon
  • The Work Surface
  • Navigation
  • Formatting
Module 2: – Essential Formula Knowledge - I
  • Formula Anatomy
  • Cell Referencing
  • Function Anatomy
Module 3: Essentials Formula Knowledge - II
  • Logic Functions
  • Conditional Math
  • Temporal Function(EOMONTH)
  • Function Anatomy
Module 4: Functions
  • Math Functions
  • Text Functions
  • Understanding Dates
  • Understanding Time
Module 5: - Search Functions
  • VLOOKUP
  • Other Lookup Method (Index & Match )
  • HLOOKUP
Module 6: Optimizing Data
  • Sorting
  • Filtering
  • Naming Ranges
Module 7: Data Analysis
  • Creating PivotTables
  • Formatting PivotTables
  • Calculated Fields in PivotTables
Module 8: Getting and Transforming Data
  • Importing Data from a Text File
  • Contiguous Data
Module 9: Presenting and Reporting with Formats
  • Conditional Formats with Built-In Rules
  • Cell Formatting
  • Conditional Formats with Custom Rules
Module 10: – Presenting and Reporting with Charts
  • Building Column Charts
  • Building Bar Chart
  • Building Pie Charts
  • Building Line Charts
Module 11: Validating and Updating
  • Data Validation
  • Comments & Notes
  • Apply built-in number styles
VBA
Module 1: Introduction To VBA
  • Introduction to Excel
  • Introduction to Programming
  • VBA Syntax And Grammar
  • Introduction to Cloud Compu
  • Quick Review of Macros
  • Working with Macros
  • How to use Visual Basic Editor
Module 2: Understanding VBA Editor
  • The Visual Basic Editor
  • Parts of the VBA Editor
  • About VBA Forms, Sub Procedures & Modules
  • Creating Forms
  • Using Controls and their Properties
  • Running VBA Forms in Excel
Module 3: VBA Syntax And Grammar
  • Objects – The Grammar
  • Using Properties and Methods
  • Understanding Parameters
  • The Object Browser
  • Understanding object hierarchy
  • Editing Specific Cells
Module 4: Storing Data In Variables
  • How and when to declare variables
  • Selecting data types
  • Fixed and dynamic arrays
  • Constants
Module 5: Control Structure And Program Flow
  • IF (Else If, Else)
  • Select Case()
  • For Next Loop
  • Do Until Loop and Do While Loop
Module 6: Building Procedure
  • Creating Sub procedures
  • Calling procedures
  • Passing arguments to procedures
Module 7: Building Intuitive Interface
  • Communicating with the user through the message box
  • Gathering user information with the input box
Module 8: Creating Customized Dialogs with User Forms
  • Command buttons
  • List and Combo boxes
  • Labels
  • Option buttons
Module 9: Functions
  • Using Excel Worksheet Functions in VBA
  • User-Defined Functions
  • Adding Help to User Defined Functions
Module 10: Error Handling
  • Run Time Error
  • GoTo line
  • Resume Next
TABLEAU
Module 1: - Introduction To Tableau
  • Why Data Visualization?
  • What is Tableau
  • Uses of Tableau
  • Tableau Installation
  • Saving and sharing your work
Module 2: Tableau Data Connections
  • Data Connections in the Tableau Interface
  • Types of Join
  • When to Use Joining
  • Creating Data Extracts in Tableau
  • What is Data Blending
  • When to Use Data Blending
  • Joining vs. Blending
Module 3: Organizing and Simplifying Data
  • Creating Filters
  • Customizing Filters
  • Sorting of Data
  • Using Parameters
  • Fixed Sized Bins
  • Formatting and Annotations
  • Applying Filters
  • Working with Sets
  • Creating Parameters
  • Tableau Bins
Module 4: – Data Visualization I
  • Bar Charts
  • Horizontal bar charts
  • Stacked bar charts
  • Side-by-Side bar chart
  • Text tables
  • Heat maps
  • Symbol maps
  • Filled Maps
  • Pie Charts
  • Tree maps
  • Area Charts
  • Scatter Plots
  • Histogram
Module 5: – Data Visualization II
  • Using Pareto Charts
  • Using Waterfall Charts
  • Using Gantt Charts
  • Using Box Plots
Module 6: Calculations
  • Working with string functions
  • Working with number functions
  • Working with Quick Table Calculations
  • Logic and Conditional Calculations
  • Working with Dates and Times
  • Working with aggregate options
  • Working with date functions
  • Conditional Filters
Module 7: Formatting
  • Introduction to Formatting
  • Options in Formatting Visualizations
  • Working with Labels and Annotations
  • Effective Use of Titles and Captions
  • Introduction to Visual Best Practices
Module 8: Mapping
  • Importing and Modifying Custom Geocoding
  • Working with Symbol Map and Filled Map
Module 9: Stories and Dashboards
  • Using Storytelling
  • Creating your first dashboard and Story
  • Adding interactivity to your Dashboard
  • Using Dashboard Actions
  • Use of Running Actions
Module 10: Working with Tableau Public Portal
  • Publishing to Tableau Public – Overview of publishing
  • Sharing work
POWER BI
Module 1: Power BI Introduction
  • Power BI Desktop
  • Flow of Work in Power BI Desktop
  • A Brief History of Power BI
Module 2: - Power Query
  • Data Transformation
  • Overview of Power Query
  • Ribbon
  • Saving the Work
  • Datatypes
  • Basic Filtering
  • Filter Multiple Columns
  • Remove Columns
  • Name / Rename a Column
  • Reorder Columns or Sort Columns
  • Add Column
  • Merge Columns
  • Transpose Columns
  • Remove Duplicates
  • Remove Blank Rows
  • Remove Errors
Module 3: M Language
  • IF..ELSE Conditions
  • Remove Columns ()
  • Split Columns ()
  • Replace Value()
  • GROUP BY Options Table
  • Group (), Sort ()
  • Table.Pivot()
Module 4: DAX
  • Calculated Column, Measures
  • Columns Vs Measures
  • DAX Syntax & Operators
  • DAX Operators
Module 5: - Math & Statistical Functions
  • ROUND, ROUNDUP, ROUNDDOWN
  • DIVIDE
  • EVEN, ODD
  • POWER, SIGN
  • SQRT, FACT
Module 6: Time Intelligence
  • YEAR, MONTH, DAY
  • WEEKDAY, WEEKNUM
  • FORMAT
  • DATE, TODAY, NOW
  • HOUR, MINUTE, SECOND, TIME
  • DATEDIFF, CALENDAR
Module 7: Text Functions
  • LEN, CONCATENATE (&) LEFT, RIGHT, MID UPPER, LOWER
  • TRIM, SUBSTITUTE, BLANK
Module 8: Logical Functions
  • IF
  • TRUE, FALSE NOT,
  • OR, IN, AND
  • IF ERROR SWITCH
Module 9: Report View User Interface
  • Fields Pane, Visualizations pane, Ribbon, Views
  • Grouping and Binning Introduction
  • Using grouping, Creating Groups on Text Columns
  • Sorting Data in Visuals
  • Changing the Sort Column, Changing the Sort Order
  • Sort using column that is not used in the Visualization
Module 10: Visualizations
  • Visualizing Data
  • Bar and Column Charts
  • Stacked Bar Chart
  • Stacked Column Chart
  • Clustered Bar Chart
  • Clustered Column Chart
  • Pie and Donut Charts
  • Scatter Charts
  • Line Chart, Area Chart
MYSQL
Module 1: Introduction
  • What is Data, Field and database?
  • Limitations of File Management System
  • Basic Concepts of Advantages of DBMS
  • Installing SQL
Module 2: – DDL and DML Statements
  • Create, Alter and Drop Table
  • Insert, Update and Delete Statement
  • Truncate Statement
Module 3: Working with Queries (DQL)
  • Understanding Select Statement
  • Usage of Top, Distinct, Null etc...Keyword
  • Using String and Arithmetic Expressions
  • Exploring Where Clause with Operators
  • Sorting data using Order By clause
  • Working with basic of Sub Queries
Module 4: – Aggregate Functions
  • Using functions in Queries
  • Count, Sum, Min, Max, Avg Group By and Having Clause
Module 5: Joins and Sets
  • Introduction to Joins
  • Inner Join
  • Self Join
  • Outer Join
  • Cross Join
  • Set Operations using Unions, Intersect
Module 6: Implementing Views
  • Introduction & Advantages of Views
  • Creating, Altering, Dropping Views
Module 7: Data Control language
  • Creating Users
  • Granting & revoking of privileges
  • Managing users
Module 8: Working with Indexes
  • Introduction
  • Creating and Dropping Indexes
Module 9: – Transaction Control Language (TCL)
  • Transactions process
  • Working with commit, rollback and savepoint
Module 10: Working with Stored Procedures
  • Introduction to stored procedures
  • Benefits of Stored Procedures
  • Creating, Executing Modifying, Dropping Stored Procedure
Module 11 – Implementing Triggers
  • Introduction to triggers
  • Creating, Altering, Dropping triggers
  • Before and after triggers
Module 12: Built-in functions in SQL
  • Working with character, date and number functions

Trending Courses