Data Analyst Business Analyst

About Data Analyst & Business Analyst Program

The Data Analyst & Business Analyst course by Planet of Automation is a comprehensive, multi-tool certification program designed to equip learners with real-world data handling, analytics, visualization, and business insight skills. This course integrates six high-demand technologies—Advanced Excel, Power BI, Tableau, Python, SQL, and Statistics—to prepare learners for job roles in analytics, reporting, and decision-making across industries.

Whether you're a fresh graduate or a working professional aiming to pivot into analytics, this course provides hands-on training with live case studies, making you proficient in end-to-end data analysis, dashboarding, reporting, and data-driven storytelling.

Here are some Key Responsibilities of a Data Analyst & Business Analyst:

Data Cleaning & Preprocessing: Use tools like Excel, Python (Pandas), and SQL to clean, standardize, and validate raw data by handling null values, duplicates, outliers, and inconsistencies for accurate analysis.
Data Visualization & Reporting: Create dynamic and interactive dashboards using Power BI and Tableau to visualize KPIs, business trends, and forecasts. Present data through compelling stories tailored for stakeholders.
Statistical & Analytical Modeling: Apply statistical methods such as hypothesis testing, correlation, regression, and probability distributions to uncover insights, support decision-making, and solve business problems.
Database Querying & Data Extraction: Write optimized SQL queries to extract relevant datasets from relational databases. Perform data joins, aggregations, and filtering for reporting and analysis.
Business Intelligence Automation: Leverage Power Query, Pivot Tables, and automation features in Excel and Power BI to streamline recurring reports, automate data refreshes, and minimize manual work.
Cross-functional Collaboration: Work closely with business teams, developers, and managers to understand requirements, translate them into technical solutions, and deliver insights that influence decisions.
Live Project Execution & Problem Solving: Apply all toolsets (Excel, Python, SQL, BI, Statistics) in real-world case studies to solve domain-specific problems (e.g., sales forecasting, customer churn, inventory optimization).

To become a CSM, you can earn the CSM certification, which is a credential that recognizes your competency in Scrum project management. The CSM certification exam consists of 50 multiple-choice and true/false questions, and you need to answer at least 37 questions correctly to pass.

Certified Data Analyst Business Analyst Course Syllabus

ADVANCED EXCEL SYLLABUS +

MS office Versions, Interface, Data Entry

Row and Columns, Keyboard shortcuts

Functions

Mathematical calculations

Logical functions

LOOKUP, VLOOKUP

NESTED VLOOKUP, HLOOKUP, INDEX

Date Functions

Formatting

Pivot Reports

Conditional formatting

Dashboard

Using Loaded queries, Merge and Append

Power Query

Live Case Study-I

POWER BI SYLLABUS +

Power BI Background, Installation of Power BI

Formatting and Setting prerequisites

Difference: Power BI Desktop vs Power Query

Power BI vs other BI Tools

Visualization & BI Desktop Interface Overview

Loading Data from Various Sources

Data Types and Default Charts

Geo Location Map Integration

Financial Sample Data in Power BI

Map Visual Types and Usage

Scatter Plot with Play Axis

Column Chart Overview

Line Chart Overview

Conditional Formatting & Techniques

Loading Data from Folders

Deep Dive into Power Query

Add Columns, Append, Merge Queries

Multiple Data Formats Handling

Data Modeling: Cardinality & Filter Direction

Dashboard Creation with Loaded Data

Custom & Conditional Columns in Power Query

Managing Parameters

Visual Interaction Customization

Bookmarks: Use & Implementation

Navigation Buttons

Custom Visuals and Usage

Power BI Services & Publishing

Live Case Study-II

TABLEAU SYLLABUS +

Understanding the tool Tableau

What is Data Visualization

Tableau Products

Tableau File Extensions

Data Types, Dimensions & Measures

Aggregation Concepts

Tableau Desktop Installation

Data Source Overview (Live vs Extract)

Overview of Worksheet Sections & Shelves

Bar Chart, Stacked Bar Chart

Discrete & Continuous Line Charts

Symbol Map & Filled Map

Text Table & Highlight Table

Formatting: Gridlines, Axes, Shading, Dividers

Marks Card Overview

Filters: Types & Application

Filter Types: Extract, Context, Dimension, Measure

Quick Filters and Worksheet Level Filters

Dual Axis, Combined Axis Charts

Lollipop, Donut, Butterfly Charts

Groups, Bins, Sets, and Parameters

Reference Lines & Trend Lines

Dashboard Overview: Tiled vs Floating

Layout & Object Overview

Dashboard Creation & Formatting

Data Combining: Joins, Relationships, Blending

Actions: Filter, Highlight, URL, Sheet, Parameter, Set

Worksheet & Dashboard Level Actions

Live Case Study-III

PYTHON SYLLABUS +

Introduction to Python Programming

Control Statements

What is Variables, data types

Operators in Python

List comprehension

Dictionaries

Sequence methods

Concatenate, Repition, Len, Min Max Functions

Index Position, Addition and deletion of elements

Reverse, Sorting

Sets

re module (Findall, Search, Split, Match)

IF, elif, Getting Input from user

Identity Operator

For, While Loops

Functions

Lambda Functions

Modules and namespaces

Basics of Classes and Objects

Attributes and methods

Class Attributes/Object Attributes

Data hiding and encapsulation

Inheritance

Overriding of parents attributes/methods

MRO, Super() function

Multiple Inheritance

Method Resolution Order (MRO)

Concepts of Polymorphism

NumPy

Pandas

Matplotlib

Seaborn

Data Preprocessing

Live Case Study-IV

SQL SYLLABUS +

Introduction to Databases

Introduction to RDBMS

Explain RDBMS through normalization

Different types of RDBMS

Software Installation (MySQL Workbench)

Types of SQL Commands (DDL,DML,DQL,DCL,TCL)

Data Types in SQL (Numeric, Char, Datetime)

Usage of CASE WHEN THEN (IFNULL, COALESCE)

GROUP BY, HAVING Clause

COUNT, SUM, AVG, MIN, MAX, COUNT

String Functions, Date & Time Functions

NOT NULL, UNIQUE, CHECK, DEFAULT, ENUM

Primary Key, Foreign Key

Types of Joins

DDL: CREATE,DROP,ETC

DML: INSERT, UPDATE & DELETE

TCL: COMMIT, ROLLBACK,SAVEPOINT

Indexes and Views in SQL

Stored Procedures

User Defined Function

Window Functions

UNION,UNION ALL, INTERSECT

Sub Queries, Multiple Query

STATISTICS SYLLABUS +

Data Types

Measure of central tendency

Measures of Dispersion

Skewness

Box Plot

Central Limit Theorem

Confidence interval

Introduction to Hypothesis Testing

Anova and Chi-square

Data Cleaning

Imputation Techniques (Mean and Median)

Scatter Diagram and Correlation Analysis

Random variable

Probability

Probability Distribution

Normal Distribution

Key Features

Experienced Trainers: The institute should have skilled instructors with extensive industry experience in manual testing.
Comprehensive Curriculum: A well-structured curriculum covering all aspects of manual testing, including test planning, execution, defect tracking, and reporting.
Hands-On Training: Emphasis on practical, hands-on training with real-world projects to ensure students gain practical experience.
Industry-Standard Tools: Training on the latest industry-standard tools and techniques used in manual testing.
Career Support: Offering career guidance, resume building, interview preparation, and job placement assistance to help students transition into the workforce.
Positive Reviews and Testimonials: High satisfaction rates from past students, showcasing successful career transitions and positive learning experiences.

Students, freshers, working professionals, and career switchers looking to enter the data analytics or business intelligence domain.

You'll master Advanced Excel, Power BI, Tableau, Python, SQL (MySQL), and core Statistics.

No. This course is designed for both technical and non-technical learners with step-by-step teaching from basics to advanced levels.

Yes. Each module concludes with a Live Case Study to apply your learning on real business scenarios.

Absolutely. It’s structured for industry readiness with tools, projects, interview prep, and profile building.

Data Analyst, Business Analyst, Reporting Analyst, MIS Executive, Tableau Developer, Power BI Analyst, and more.

Yes. You’ll receive a certification from Planet of Automation validating your skills and tools proficiency.

Both formats are available. Contact the team to check current schedules and batch types.

Yes. If you miss any session (in the online format), you can access the recordings.

Yes. Resume building, mock interviews, and job referrals are provided as part of career support.

Instructor: Joshi Sir
Duration: 6 to 8 Weeks
Lessons: 12 Lessons
Enrolled: 15 students
Language: English & Marathi
Class Certificate: Yes

Testimonials

What Our Students Have To Say

Our students' success stories are a testament to our commitment to excellence. They praise our experienced trainers, practical approach, and job-oriented curriculum. Many have transitioned to successful careers in top IT companies, crediting our comprehensive training programs for their in-depth knowledge and confidence. Join our community and see why we are the preferred choice for Software Testing Training In Pune. Hear from our students about how Planet Of Automation has transformed their careers and opened doors to new opportunities.

View All

I recently completed the Selenium with Core Java and Manual Testing course at Planet Of Automation, and it was a game-changer for my career. The instructors were highly knowledgeable and provided clear, practical examples. The hands-on projects were particularly beneficial, giving me real-world experience. Highly recommend this course for anyone looking to break into the software testing field!

Sandesh Patil

The Appium, Selenium with Core Java, and Manual Testing course at Planet Of Automation is outstanding. The combination of mobile and web testing skills was exactly what I needed. The course was intensive but well-paced, and the instructors provided excellent guidance throughout. The practical assignments were very helpful in reinforcing the concepts. Highly recommend this course to anyone looking to enhance their testing skills!

Rupali Jain

I enrolled in the Selenium with Python and Manual Testing course, and it was one of the best decisions I've made for my career. The course content was up-to-date and relevant to current industry practices. The hands-on training was incredibly valuable, and the instructors were top-notch. The knowledge and skills I gained have already helped me secure a better job. Thank you, Planet Of Automation!

Vyankatesh Rokade

I took the Cucumber, Selenium with Core Java, and Manual Testing course, and it was an incredible learning experience. The blend of automation and behavior-driven development (BDD) techniques was exactly what I needed to advance my career. The instructors were fantastic, and the hands-on training was invaluable. I now have a strong foundation in testing and feel confident in my skills. Thanks, Planet Of Automation!

About Data Analyst & Business Analyst Program