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

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

How-to-Design-a-Logo–

COURSE OVERVIEW

Data visualization techniques allow people to use their perception to better understand this data. The goal of this course is to introduce students to data visualization including both the principles and techniques.



  • Advance Excel

    • BASIC Microsoft 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
    • Advanced Excel Tasks
    • Creating HLOOKUP and VLOOKUP Functions
    • Advanced Conditional Formatting
    • Advanced Lookup Functions
    • Advanced Functions in Excel

  • Macros with VBA

    • Macro recording
    • Visual Basic Editor
    • Understanding Objects, Methods, Properties and Variables
    • Control Structures-Decision
    • VBA Functions
    • Interactivity
    • Looping Structures
    • User Forms and GUI
    • Error Handling
    • Addins

  • 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

  • MS-SQL

    • MySQL Configuration
    • MySQL Basics
    • Configuring PHP My Admin for SQL usage
    • Inserting Data in MySQL via PHP Forms
    • Updating Data in MySQL via PHP Forms
    • Deleting Data in MySQL via PHP Forms
    • Selecting or Retrieving Data From MySQL and Displaying on PHP Forms

  • Power BI

    • POWER BI - Introduction
    • POWER BI - Installation Steps
    • POWER BI - Architecture
    • POWER BI - Supported Data Sources
    • POWER BI - Comparison With Other Bi Tools
    • POWER BI - Data Modeling
    • POWER BI - Dashboard Options
    • POWER BI - Visualization Options
    • POWER BI - Excel Integration
    • POWER BI - Sharing Power Bi Dashboards
    • POWER BI - Dax Basics In Power Bi

  • Tableau

    • Getting Started With Tableau
    • Tableau Interface
    • Chart Types
    • Data Visualization
    • Functions
    • Data Formatting
    • Advanced Functionalities
    • Filters
    • Advanced Charts
    • Dashboards
    • Online Introduction
    • Publish Reports