info@introtallent.com 8618569998
Introtallent
  • Home
  • Courses
    • Data Science
      • Data Science Pro
      • Data Science Plus
      • CPDS
    • Analytics
      • CPBA
      • Analytics Plus
      • Analytics Pro
    • Online Courses
    • Digital Marketing Master
    • All Courses
  • Corporate Training
  • Projects
  • Internship
  • Payment
  • LMS

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. 

Module 1: Microsoft Excel
  • Basic concepts
  • Formulas
  • Data Preparation
  • Data Cleansing
  • Data Visualization
  • Analyzing Data
Module 2: Tableau
  • Understanding BI environment
  • Data Connection
  • Designing Dashboard
  • Calculated fields and Parameter
  • Advanced Charts
  • Story
Module 3: SQL
  • Data Definition Language
  • Querying Data
  • Filter, Sort and Group Data
  • Combining Data
  • Nested Queries
Module 4: VBA Macros (Automation)
  • Automation Concepts
  • Recording a Macro
  • Variable, Decision Making, Loops
  • Handling Exceptions
  • Designing Interface
  • Automating Manual Excel Work
Capstone Projects
  • Project 1: Data Analysis Project in Excel
  • Project 2: BI Dashboard using Tableau
  • Project 3: Automation using VBA Macros
Job Preparation
  • 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

Contact Info

10, 1st Floor, 12th Cross, CMH Road, Indiranagar, Bangalore

8618569998

info@introtallent.com

https://www.introtallent.com

Recent Post

  • Tableau Interview Question and Answers in 2022 2022-01-25
  • Top 10 Interview Questions you must be prepared with 2021-02-22
  • Tableau Certification Exam 2021-01-17
  • Read More Posts

Useful Links

  • Placements
  • Success Stories
  • Excel Shortcuts
  • Tableau Interview Questions
  • SQL Interview Questions
  • Python Interview Questions
  • Excel Interview Questions
  • Resume Templates

Company

  • Privacy Policy
  • Terms & Conditions
  • Refund Policy

Introtallent © 2017-2022 All rights reserved. | Introtallent Private Limited

WhatsApp us