Professional Program in Data Analytics

Analyzing Data using Microsoft Advanced Excel

• Calculating Data with Advanced Formulas

• Financial, Logical, Text, Lookup & References, and Statistical Functions.

• Presenting and Forecasting Data Using Charts.

• Analyzing Data using Pivot Tables and Pivot Charts.

• Analyzing Data using What-if Analysis and Power Pivot.

• Automating Business Operations using VBA.

Data Exploration with Microsoft Power BI

• Understanding Power BI Interface and Power BI Variants

• Using Excel Data in power BI for visualization

• Reporting/Dash boarding using power

• Publishing Power BI Dashboards

• Data relationships and queries in Power BI

• Data Transformations in power BI

Programming Basics and Data Analytics with Python

• Data Visualization using Tableau

• Introduction

• Basic Chart Developments

• Advanced Charts

• Working with its Dashboards

• Data Visualization and Real-Time Analytics

Database Management with SQL

• Retrieve, summarize, and group data

• Use functions to customize the result set

• Query data by using joins and subqueries

• Manage databases, tables, and result sets

• Manipulate data by using DML statements

• Create and manage indexes and views

Course Overview

The Data Analytics Course is designed to equip learners with the essential skills needed to collect, analyze, interpret, and visualize data for effective decision-making. This program blends theoretical concepts with hands-on practical training, ensuring that students become job-ready for roles such as Data Analyst, Business Analyst, Reporting Analyst, and BI Developer.

Throughout the course, learners will gain expertise in tools like Excel, SQL, Python, and Power BI/Tableau, while also building a strong foundation in statistics, data visualization, and analytical thinking. The curriculum includes real-world datasets, case studies, and capstone projects that simulate industry challenges across domains like finance, e-commerce, healthcare, and retail.

Whether you are a beginner or a working professional looking to upskill or switch careers, this course provides a structured path to mastering data analytics and stepping confidently into the analytics job market.

COURSE CURRICULUM

Programming Basics and Data Analytics with Python

• Type Variables and Operators

• Strings, Lists, Dictionary

• Control Statements and Loops

• Functions and Scope of Variable

• Module and Package

• Collections

• Class and Objects

• Preparing the data

• Exploring the Data

• Classification Techniques

• Regular Dimensions

• Visualization in Python

Data Visualization using Tableau

• Introduction

• Basic Chart Developments

• Advanced Charts

• Working with its Dashboards

• Data Visualization and Real-Time Analytics

Project

In this section, you will be working on projects.

Our Certifications

post course certification, we provide :

© 2025 A&T Edutech (Edureka Learning Centre – Panvel). All Rights Reserved.

• Interview preparetion session

• Resume writing

• goal setting

• communication skill development

• mock interview sessions

• english speaking (if required)

• course duration : 120 days(4 months)

• batsh size : 5-6 students/ batch

• timing : 8:00am to 8:00pm

• Weekdays : monday - friday

• week end : sat & sunday(batch for working Professional

• mode of training : online/offline