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

Advanced Certificate Course in Data Visualisation and Analysis (A-DVA) Advanced Certificate Course covering Excel, Tableau, Power BI, SQL, and more

K-DVA (Keerti Certified Course in Data Visualization and Analytics)

COURSE OVERVIEW

Advanced Certificate Course covering Excel, Tableau, Power BI, SQL, and more for data-driven decision-making and career opportunities.


  • 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

    • 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

  • 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
      • Tables
      • Tuples
      • 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