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

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

Data Visualization and Analysis Pro

COURSE OBJECTIVE

- Our data analysis certification Course helps you learn analysis tools and techniques, how to work with SQL databases, R and Python, how to create data visualizations, and apply statistics and predictive analytics in a business environment.


  • Prerequisites: Basic Knowledge of Computers
  • Advance Excel

    • Advanced File Tasks
    • Working with Functions and Formulas
    • Managing Tables in Microsoft Excel
    • Data Tools in Excel
    • Sparkline
    • Grouping & Outlining and Subtotals
    • What-If Analysis
    • Advanced PivotTables & Charts, slicers
    • Creating HLOOKUP and VLOOKUP Functions
    • Advanced Conditional Formatting
    • Advanced Lookup and Reference Functions
    • Advanced Functions in Excel
    • Power Pivot
    • Power Query

  • Dashboard Designing

    • Introduction to Excel Dashboards
    • Excel Table in Dashboards
    • Using Custom Number Formatting
    • Using Symbols in Excel Dashboards
    • Conditional Formatting for Dashboards
    • Sparklines in Excel Dashboards
    • Data ready for Excel Dashboards
    • Excel Dashboard formulas
    • Excel Charts for Dashboards (Advance Concept)
    • Pivot table Dashboard with Slicers

  • Automation

    • Working with External Data
    • Exporting Data to Excel, Access, PPT, TXT, CSV
    • Updating Charts, Table in PowerPoint
    • Importing Data from Excel, Access, PPT, TXT, CSV
    • 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
    • Designing a Relational Database
    • Sharing Data Across Applications

  • 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

    • Visualizing Data with Reports

      • Creating Visualizations
      • 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 Visualizations

      • 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

    • Databases
    • Introduction to DBMS
    • Popular DBMS Software
    • Concepts of RDBMS
      • 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

  • Database Accessing Database from R and Python

    • Accessing Database from R
      • Install R Packages
      • Configuration Information
    • Python Database Access
      • Databases Supported
      • Libraries
      • Read Operations
      • Insert, Update and Delete
      • Performing Transactions
      • Handling Errors

  • Introduction to Python

    • Introduction to Python
    • Python Installation on laptops
    • 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 modules for Data Analysis

    • 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