Analytics Pro

Analytics Pro program includes the essential tools and languages that you need to succeed in Analytics industry. You will be learning MIS reporting, creating  BI dashboard, Analytics, writing queries to summarize/extract data, and automation of excel reports to reduce manual effort using VBA Macros. 

  • Basic concepts
  • Formulas
  • Data Preparation
  • Data Cleansing
  • Data Visualization
  • Analyzing Data
  • Understanding BI environment
  • Data Connection
  • Designing Dashboard
  • Calculated fields and Parameter
  • Advanced Charts
  • Story
  • Data Definition Language
  • Querying Data
  • Filter, Sort and Group Data
  • Combining Data
  • Nested Queries
  • Automation Concepts
  • Recording a Macro
  • Variable, Decision Making, Loops
  • Handling Exceptions
  • Designing Interface
  • Automating Manual Excel Work
  • Project 1: Data Analysis Project in Excel
  • Project 2: BI Dashboard using Tableau
  • Project 3: Automation using VBA Macros
  • Interview Questions
  • Resume Preparation
  • Interview Preparation

Why Analytics Pro?

  • Industry relevant curriculum
  • Analytics, BI and Automation are important skills and hence these skills are in demand
  • Job Assistance