Business Analytics Course in Kolkata

Advance Excel crash course

Exploring advance knowledge of using excel with Data Science.

Course curriculum

  • Introduction to Excel for data analysis
  • Using functions and special shortcuts
  • Learn pivot table
  • Learn vlookup, xlookup, hlookup
  • Learn VBA
  • Advanced VBA for data processing
  • Creating interactive Excel Dashboard
  • Learn to create macros

Learning Outcome

  • Basic knowledge of excel in data science
  • Group of advance functions
  • Pivot table
  • Interactive dashboard making in excel
  • Excel programming language
  • Macros making

Brochure

Enroll Now

Business analytics master program

Become a data scientist with non-engineering background

Course curriculum

  • Introduction to Data(Data 101)
  • Data Warehousing - Business Analytics
  • Starting with Excel
  • Advance Excel - II (Dashboard)
  • Advance Excel - III (VBA)
  • Advance Excel (VBA Extension)
  • Introduction to Power BI
  • Power BI-advanced
  • Introduction to SQL
  • Introduction to R
  • Advanced R (Connecting with SQL)
  • Time Series Application with R
  • Machine learning application with R
  • Final Class
  • Capstone Project

Learning Outcome

  • Basic information of data analysis with real time data
  • Industrial knowledge of data warehousing
  • Using excel in an advance way
  • Power- BI
  • Sql database
  • Excel programming languages & advance functions
  • Programming language R
  • Machine learning approaches with R

Brocure

Enroll Now