<style type="text/css"> .wpb_animate_when_almost_visible { opacity: 1; }</style>

Professional Certificate Course in Advanced Data Visualisation and Analysis (P-ADVA)

Analysis tools and Techniques

COURSE OVERVIEW

A 7-month course covering MIS with Advanced Excel, VBA Macros, Tableau, Power BI, SQL, Python, MongoDB, and R basics, enabling you to extract insights from complex data.


  • Introduction to Data analysis & Data Visualizations

    • Data Analytics Overview
    • Data Visualization for Decision making
    • Data Analytics in Different Sectors
    • Understanding of the importance of data visualization

  • MIS with Advance Excel 2019
  • Excel Essentials

    • Excel Essentials
    • Working with Multiple Worksheet
    • Cell Referencing
    • Working with Data Lists
    • Conditional Formatting
    • Data Validation
    • What-If Analysis
    • Formula Auditing
    • Protection

  • Formulas & Functions

    • Conditional Function
    • Text & Statistical Function
    • Financial Function
    • Creating HLOOKUP and VLOOKUP Functions
    • Advanced Conditional Formatting
    • Advanced Lookup and Reference Functions

  • Dashboard Designing (MIS)

    • Creating Dashboard
    • Charts & Sparkline’s
    • Use of Power Pivots for Data Analysis
    • Use of Power Queries & Power Map
    • Pivot table Dashboard with Slicers

  • Automation

    • Working with External Data
    • Exporting & Importing Data
    • Excel, Access, PPT, TXT, CSV
    • Updating Charts, Table in PowerPoint
    • Converting Reports into PDF
    • Exporting Charts, Tables to PowerPoint

  • Reporting Techniques

    • Understanding Raw Data
    • Understanding Reporting
    • Creating Calculation Sheets
    • Working With Charts and Tables
    • Reports using Advanced Charting Techniques
    • Reports Using Pivot Table, Pivot Charts
    • Creating Dashboards using Slicers

  • Macros With VBA

    • Macro recording
    • Visual Basic Editor
    • Understanding Objects, Methods, Properties and Variables
    • Control Structures-Decision
    • Looping Structures
    • User Forms and GUI
    • Worksheet / Workbook Operations
    • Error Handling

  • MS-Access

    • Getting Started with Access
    • Working with Table Data
    • Querying a Database
    • Using Forms
    • Generating Reports
    • Sharing Data Across Applications
    • Designing a Relational Database

  • Power BI
  • Introduction to Power BI

    • What is Power BI
    • Installing Power BI Desktop
    • Exploring the Power BI Workflow

  • Transforming Data with Power BI Desktop

    • Connecting to different sources
    • Different connecting Options
    • Shaping and transforming data with Power Query
    • Editing, Merging, Appending queries etc.

  • Modeling with Power BI

    • Introduction to Modeling
    • Building Relational Models
    • Creating table relationships
    • Understanding the filter flow
    • Cardinality and Cross filtering

  • Introduction to DAX

    • Understanding DAX Syntax
    • DAX calculation types
    • DAX functions
    • Using variables in DAX expressions
    • Table relationships and DAX
    • DAX tables and filtering

  • Visualising Data with Reports

    • Creating Visualisations
    • Color & Conditional Formatting
    • Sort Order
    • Scatter & Bubble Charts & Play Axis
    • Tooltips, Slicers
    • Timeline Slicers & Sync Slicers
    • Cross Filtering and Highlighting
    • Visual, Page and Report Level Filters
    • Drill Down/Up, Hierarchies
    • Constant Lines
    • Tables, Matrices Table Conditional Formatting
    • Map Visualisations

  • Creating Dashboards

    • Pin Visuals and Pin Live Report Pages to Dashboard
    • Advantages of Dashboards
    • Interacting with Dashboards
    • Formatting Dashboard
    • Sharing Dashboard

  • Mango DB

    • Introduction to nosql
    • Introduction to mongodb
    • Data modelling & basic operations
    • Collections and basic operations on collections
    • Inserting data into tables
    • Query document
    • Rdbms where clause equivalents in mongodb
    • Update document
    • Delete document
    • Limit records
    • Sharding
    • Deployment
    • Advanced features of mongodb

  • Tableau
  • Introduction to Tableau

    • Understanding Working
    • Architecture & Data Model
    • Data Connection & Joins
    • Working with multiple data sources
    • Data joining and blending

  • Tableau Interface

    • Measures and dimension
    • Shelves
    • Show Me
    • Data Types
    • Default Properties
    • Marks Card
    • Page Shelf
    • Difference between .twb and .twbx
    • Discrete vs Continuous
    • Date Aggregations and Date parts
    • Cross tab
    • Totals & Subtotals

  • Chart Types

    • Bar Charts & Stacked Bars
    • Pie Charts
    • Line Graph with Date
    • Line Graph without Date
    • Area charts
    • Tree Map
    • Word Cloud
    • Packed Bubble
    • Box & Whiskers Plot
    • Scatter Plots
    • Highlight tables
    • Heat maps

  • Data Visualization

    • Geographical fields
    • Map options

  • Run Time Columns

    • Calculated Fields
    • String Calculation
    • Data Calculation
    • Logical Calculation
    • Numeric Calculation
    • Parameters
    • Table Calculations

  • Data Formatting

    • Legends
    • Highlights
    • Labelling
    • Number Formats
    • Alignment

  • Advanced Function

    • Sorting
    • Groups
    • Sets
    • Hierarchy
    • Reference and Trend Lines
    • Edit Axi
    • Bins

  • Filters

    • Dimension Filter
    • Measure Filter
    • Filter - Display Option
    • Context Filters
    • Relevant Filters
    • Sets in filters
    • Conditional Filters

  • Advanced Charts

    • Waterfall
    • Funnel

  • Dashboards

    • Dashboards Objects
    • Dashboard Actions
    • URL
    • Highlight
    • Filter
    • Publish to Web
  • Storyline In Tableau
  • Publish Reports

  • SQL
  • Introduction to Databases

    • Database Management system
    • SQL Syntax
    • Data Manipulation Language
    • Data Query Language
      • Built in functions in SQL
      • Sub-Query & Joins
      • Attributes
    • Normalization
      • First Normal Form
      • Second Normal Form
      • Third Normal Form
    • NOSQL Databases
      • Types of NOSQL
    • Comparison

  • SQL Commands

    • Types of SQL Commands
    • Data Definition Language
      • Create, Drop, Truncate, Alter and Rename Objects
    • Data Query Language
      • Select Statements
    • Data Manipulation Language
    • DCL and TCL
      • Grant, Revoke and transaction statements
    • SQL Data Types
      • Numeric, Date and Time, LOB Types
    • DML Commands
      • Insert, Update and Delete Statements
    • DDL Commands
      • Create and Drop Databases

  • Database Constraints

    • Types of Constraints
      • Relational Integrity Constraints
      • Key Constraints
      • Domain Constraints
      • Referential Integrity
    • Types Of Constraints
      • Primary and Foreign Keys
      • Application of Indexes
      • Checking Constraints
    • Alter Tables

  • SQL Transactions

    • SQL Transactions
      • Examples
    • ACID Properties
    • TCL Statements
      • Start, Commit and Rollback Statements
    • Auto Commit
    • Save Points
      • Identifier
      • Rollback and Release

  • Database Objects

    • Tables
      • Creating, Altering and dropping tables
    • Sequences
      • Auto Increments
      • Re-Sequencing
    • Views
      • Advantages
      • Creating and Dropping Views
    • Indexes
      • Types of Indexes
      • B-Tree and Hash Indexes
      • Creating and dropping Indexes

  • Python

    • Python Overview
      • Introduction to Python
      • Python Basics -Variables –
      • Python Build in functions -Modules –
      • Python Libraries installation using PIP
      • Python Basics -Python Operators
      • Python Basics -Flow Control Statements -If Statements -While Loops
      • Python Basics -Data & time modules
      • Python -Interfaces in Python -For Loops
      • Python Installation on laptops
    • Python Libraries
      • Python -NumPy Module
      • Python -Pandas Module
      • Python -Matplotlib Module
  • Basics Of R
    • Introduction of R
    • Data Types
    • Data Structures
    • Decision Making Statements
    • Conditional Loops
    • Flow Control Statements
    • If Statements
    • For loops
    • While Loops
    • Built Functions in R : Base, datasets, dplyrand ggplot