About Course:

Data Analysis Master Program covered Advance Excel, VBA/Macros, MS Access, SQL, Power BI & Python Practical Training which is designed by industry expert. Data Analysis training course consist of study material, corporate assignment with live data of banking & Finance, workforce operations, HR reports etc. Inside the Data Analytics course has deep understanding of concepts & logic, Data Analysis, Automation Reporting, create dashboard, user forms in Access, SQL Queries to Figure meaningful data, Visualization in Tableau/Power BI, Python and basic of Business Intelligent etc.  Sage Academy, Data Analysis Course is to unlock the great career in good companies.

Data Analysis professional course are currently available at our Delhi on weekdays or weekends.

Who can learn this course:

Sage Academy is a rapidly developing corporate practical training and development company based in Delhi that helps people to learn new skills and become job-worthy. Enrolling in our Data analytics program that is helpful to career enhancement of experienced professionals or Freshers. People who have taken a sabbatical from their careers like Graduates can also learn new skills and become employable with the help of our practical training and certifications courses. We promise to meet all your training and development needs and make you an expert in a few weeks. Trust us once and you’ll be happy you did.

Data Analytics Master Certification Training Program

Module 1 - Advanced MS Excel and Back-End Operations: Introduction to Advanced MS Excel:-

Circular References error, Rectify Circular Reference, Formula Auditing, Structured Reference Solve The Real World Excel Problems with Functions:

Module 1.1 - Mathematical Functions:

Module 1.2 - If Formulas:

Module 1.3 - More If Formulas

Module 1.4 - Date & Time Function

Module 1.5 - Statistical Function & Other Functions 

Module 1.6 - Lookup & Reference Functions

Module 1.7 - Array With Multiple Formulas                                                                           

Module 1.8 - Text Functions & Data Validation 

Module 1.9 - Pivot Table and Pivot Charts with Slicer

Module 1.10 - Advanced Chart Technique

Module 1.11 - Report Development

Module 2 - VBA - Macros & Dashboard Programming

Module 2.1 -  Programming Concepts

Module 2.2 - Decision Makers

Module 2.3 -  Other Kinds of Loops

Module 2.4 -  Workbooks Objects

Module 2.5 - Worksheet Objects insert a single and Multiple Worksheets

Module 2.6 -  Cell objects insert Single and multiple Row , Column and Cells

Module 2.7 -  Reading and Writing Arrays

Module 2.8 - Form Controls and User Forms (Create and Design an user Form)

Module 2.9 - VBA Programming Functions

Module 2.10 -  Excel VBA Power Programming for VBA Macros

Effective Error Handling

Module 3 - Understanding MS Access Databases

Module 3.1 - Creating Tables

Module 3.2 - Forms & Reports Development

Module 3.3 - Creating Queries & SQL

Module 3.4 - Automating Tasks

Module 4 - SQL

Module 4.1 - SQL Overview

Module 4.2 - SQL Select Statements

Module 4.3 - SQL Functions & Expressions

Module 4.4 - SQL Updating

Module 4.5 - SQL Joins

Module 4.6 - SQL Sub queries & Unions

Module 4.7 - SQL Summarization

Module 5: Power BI

Module 5.1 - Microsoft POWER BI Desktop, Custom Visuals

Module 5.2 - Data Modeling with Power Query

Module 5.3 - Data Modeling with DAX

Module 6 - Python Program with Data Analysis

Module 6.1- Introduction

Module 6.2 - Sequences, Iterations, Date and Time

Module 6.3 - Data Cleansing with Python

Module 6.4 - File Handling and Web Scrapping

Module 6.5 - Data Handling and Manipulation

Module 6.6 -Data Analytics and Visualization

Module 6.7 - Descriptive statistics And Inferential statistics

Module 6.8 -Time series forecasting and Clustering