Combo Program

★★★★★

(2,088 ratings) 50,000+ Student

DATA ANALYTICS COMBO (WITHOUT PYTHON) Training in Pune

The Data Analytics Combo (Without Python) course is designed for learners who want to build practical data analysis skills using SQL, Advanced Excel, and Microsoft Power BI. The training covers data cleaning, SQL queries, Excel analysis, dashboards, data visualization, reporting, and business insights through practical exercises and real-world datasets. Learners gain the skills to work with data, identify useful trends, and present findings clearly for better decision-making. This course is ideal for freshers, students, business analysts, finance professionals, MIS executives, and working professionals looking to start or advance their career in data analytics without learning Python.

Radical Technologies

50,000+ English 96 Modules · 20 Sections

Online / Classroom

DATA ANALYTICS COMBO (WITHOUT PYTHON)

DATA ANALYTICS COMBO (WITHOUT PYTHON) + 1. COURSE OVERVIEW & CAREER ROADMAP + 3. PREREQUISITES & ANALYTICS FUNDAMENTALS + 4. EXCEL FUNDAMENTALS FOR DATA ANALYTICS + 5. ADVANCED EXCEL ANALYTICS + 6. PIVOTTABLES, PIVOTCHARTS & EXCEL DASHBOARDS + 7. POWER QUERY & DATA PREPARATION + 8. POWER PIVOT & DATA MODELING + 9. SQL FUNDAMENTALS + 10. SQL JOINS, SUBQUERIES & INTERMEDIATE ANALYTICS + 11. ADVANCED SQL FOR ANALYTICS + 12. POWER BI FUNDAMENTALS & DATA ACQUISITION + 13. POWER BI DATA TRANSFORMATION & MODELING + 14. DAX FUNDAMENTALS + 15. ADVANCED DAX & POWER BI ANALYTICS + 16. POWER BI DASHBOARDS, SERVICE & GOVERNANCE + 17. INTEGRATED PROJECTS & BUSINESS CASE STUDIES + 18. CAPSTONE PROJECT & REAL-TIME JOB SCENARIOS + 19. TROUBLESHOOTING, INDUSTRY TOOLS & BEST PRACTICES + 20. CERTIFICATIONS, INTERVIEWS, RESUME & PLACEMENT

Sections Included 20 Sections Combined

Batch Type Weekdays / Weekends

Mode of Training Classroom / Online / Corporate

Locations Pune, Bangalore, Kochi

Language English

Certification Globally Recognized

Tools you'll master

SQL Power BI Excel Azure GitHub Business Intelligence Data Visualization PostgreSQL MySQL JIRA

Next batch: Contact us ·

Call Now

100% placement assistance

Enquire Now

Get course fees, batch dates & a callback

We never share your details.

What you'll learn

Program Snapshot

Course Overview

Learning Roadmap

Career Outcomes

Prerequisites

Module 1 — Data Analytics Fundamentals

Module 2 — Excel Fundamentals

Core Formulas

Module 3 — Advanced Excel

Hands-On Labs

Programme Overview

96 modules across DATA ANALYTICS COMBO (WITHOUT PYTHON), 1. COURSE OVERVIEW & CAREER ROADMAP, 3. PREREQUISITES & ANALYTICS FUNDAMENTALS, 4. EXCEL FUNDAMENTALS FOR DATA ANALYTICS, 5. ADVANCED EXCEL ANALYTICS, 6. PIVOTTABLES, PIVOTCHARTS & EXCEL DASHBOARDS, 7. POWER QUERY & DATA PREPARATION, 8. POWER PIVOT & DATA MODELING, 9. SQL FUNDAMENTALS, 10. SQL JOINS, SUBQUERIES & INTERMEDIATE ANALYTICS, 11. ADVANCED SQL FOR ANALYTICS, 12. POWER BI FUNDAMENTALS & DATA ACQUISITION, 13. POWER BI DATA TRANSFORMATION & MODELING, 14. DAX FUNDAMENTALS, 15. ADVANCED DAX & POWER BI ANALYTICS, 16. POWER BI DASHBOARDS, SERVICE & GOVERNANCE, 17. INTEGRATED PROJECTS & BUSINESS CASE STUDIES, 18. CAPSTONE PROJECT & REAL-TIME JOB SCENARIOS, 19. TROUBLESHOOTING, INDUSTRY TOOLS & BEST PRACTICES, 20. CERTIFICATIONS, INTERVIEWS, RESUME & PLACEMENT — a single, progressive learning arc from foundational concepts to real-world projects.

Programme Sections

Total Modules

523

Total Topics

4.8★

Average Rating

50K+

Students Trained

DATA ANALYTICS COMBO (WITHOUT PYTHON)

Master the core concepts and hands-on skills of DATA ANALYTICS COMBO (WITHOUT PYTHON) — from fundamentals to real-world application.

SQL Power BI Excel

1. COURSE OVERVIEW & CAREER ROADMAP

Master the core concepts and hands-on skills of 1. COURSE OVERVIEW & CAREER ROADMAP — from fundamentals to real-world application.

Power BI SQL Excel

3. PREREQUISITES & ANALYTICS FUNDAMENTALS

Master the core concepts and hands-on skills of 3. PREREQUISITES & ANALYTICS FUNDAMENTALS — from fundamentals to real-world application.

Power BI SQL

4. EXCEL FUNDAMENTALS FOR DATA ANALYTICS

Master the core concepts and hands-on skills of 4. EXCEL FUNDAMENTALS FOR DATA ANALYTICS — from fundamentals to real-world application.

Excel

5. ADVANCED EXCEL ANALYTICS

Master the core concepts and hands-on skills of 5. ADVANCED EXCEL ANALYTICS — from fundamentals to real-world application.

Excel

6. PIVOTTABLES, PIVOTCHARTS & EXCEL DASHBOARDS

Master the core concepts and hands-on skills of 6. PIVOTTABLES, PIVOTCHARTS & EXCEL DASHBOARDS — from fundamentals to real-world application.

Excel

Who is this programme for?

Whether you're starting from scratch, know some SQL, or are already writing code — this programme takes you from database fundamentals through Python programming to real-world data analysis.

Students & Freshers

Build a strong foundation in DATA ANALYTICS COMBO (WITHOUT PYTHON) and gain practical, job-ready experience from day one.

Working Professionals

Upskill and combine complementary skills from multiple courses in one structured programme.

Career Switchers

Move into a new technical role with a single, structured path covering everything you need.

IT Professionals

Deepen your expertise and broaden your skill set with hands-on, practical training.

Course Curriculum

20 sections • 96 modules • 523 topics

DATA ANALYTICS COMBO (WITHOUT PYTHON)

Programme Sections

100% Practical · Unlimited Doubt Sessions

• Recommended Duration: 140–180 Hours

• Level: Beginner to Advanced

• Learning Model: Concepts + Hands-On Labs + Assignments + Mini Projects + Capstone + Job Scenarios

• Target Roles: Data Analyst, BI Analyst, Reporting Analyst, MIS Analyst, Power BI Analyst, SQL Analyst,

Junior BI Developer

• End-to-end workflow: understand business questions, profile and clean data, query with SQL, analyze

with Excel, transform with Power Query, model data, build DAX measures, create dashboards, validate

results and communicate insights.

• Every major module includes practical work, assignments and workplace scenarios. Learners work with

raw, inconsistent and multi-source datasets and produce portfolio-ready deliverables.

1. COURSE OVERVIEW & CAREER ROADMAP

Programme Sections

100% Practical · Unlimited Doubt Sessions

• 1. Analytics fundamentals

• 2. Excel fundamentals

• 3. Advanced Excel

• 4. PivotTables & dashboards

• 5. Power Query

• 6. Power Pivot/data modeling

• 7. SQL fundamentals

• 8. SQL joins, CTEs and subqueries

• 9. Advanced SQL and window functions

• 10. Power BI fundamentals

• 11. Power BI modeling

• 12. DAX

• 13. Advanced DAX

• 14. Power BI Service, security and governance

• 15. Integrated projects

• 16. Capstone and interview preparation

• Analyze business data

• Write analytical SQL

• Build advanced Excel models

• Automate preparation with Power Query

• Design Power BI semantic models

• Create DAX KPIs and time intelligence

• Troubleshoot reporting issues

• Present insights to technical and non-technical stakeholders

• SQL query portfolio

• Advanced Excel workbooks

• Power BI dashboards

• Data model documentation

• KPI dictionary

• Project presentations

3. PREREQUISITES & ANALYTICS FUNDAMENTALS

Programme Sections

100% Practical · Unlimited Doubt Sessions

• Basic computer and spreadsheet knowledge

• Basic arithmetic, percentages and logical reasoning

• Business-process knowledge is useful but not mandatory

• No prior SQL or Power BI experience required

• Descriptive, diagnostic, predictive and prescriptive analytics

• Structured vs semi-structured data

• Dimensions, measures and attributes

• KPIs, metrics, targets and benchmarks

• Data quality: accuracy, completeness, consistency, uniqueness and timeliness

• Data profiling and validation

• Business questions vs analytical questions

• Mean, median, mode, variance and standard deviation

• Outliers, trends, seasonality

• Correlation vs causation

• Data storytelling

• Sales KPI Definition Lab

• Data Quality Profiling Lab

• Outlier Identification Lab

• Business Question-to-KPI Mapping Lab

• Create a KPI dictionary, analytical questions and data-validation checklist.

• Retail Sales Diagnostic Analysis — identify revenue trends, weak products, regions and customer

segments.

• Reconcile two reports with different revenue totals

• Explain a sales decline despite increased order volume

• Define daily operational KPIs for management

4. EXCEL FUNDAMENTALS FOR DATA ANALYTICS

Programme Sections

100% Practical · Unlimited Doubt Sessions

• Workbook and worksheet management

• Tables and structured references

• Relative, absolute and mixed references

• Sorting, filtering and advanced filtering

• Data validation

• Text-to-Columns and Flash Fill

• Remove duplicates and data cleaning

• Conditional formatting

• Charts and visual selection

• Formula auditing

• CSV and text imports

• SUM, AVERAGE, MIN, MAX, COUNT, COUNTA

• IF, AND, OR

• SUMIF/SUMIFS, COUNTIF/COUNTIFS, AVERAGEIF/AVERAGEIFS

• ROUND, ROUNDUP, ROUNDDOWN

• LEFT, RIGHT, MID, LEN, TRIM, CLEAN, SUBSTITUTE

• CONCAT, TEXTJOIN, TEXT, DATE, YEAR, MONTH, DAY

• Sales Data Cleaning Lab

• Employee Attendance Analysis Lab

• Customer Master Cleanup Lab

• Monthly MIS Report Lab

• Build a sales tracker with validation and KPI formulas

• Clean a 10,000-row customer dataset and document the process

• Monthly Sales MIS Dashboard — revenue, orders, target achievement and regional performance

• Prepare daily MIS from CSV exports

• Identify duplicate customer records

• Create exception reports for invalid transactions

5. ADVANCED EXCEL ANALYTICS

Programme Sections

100% Practical · Unlimited Doubt Sessions

• XLOOKUP

• INDEX + MATCH

• Multi-criteria lookups

• Nested logical formulas

• Dynamic arrays: FILTER, SORT, UNIQUE

• LET

• Advanced date calculations

• Text standardization

• IFERROR

• Scenario and sensitivity analysis

• Goal Seek

• Data Tables

• Scenario Manager

• Forecasting concepts

• Advanced Lookup & Reconciliation Lab

• Dynamic Array Reporting Lab

• Target vs Actual Variance Lab

• Sales Forecasting Lab

• What-If Pricing Model Lab

• Build a multi-source reconciliation workbook

• Create a dynamic region/product/month report

• Build a price-volume-margin scenario model

• Financial Planning & Variance Analysis — actual vs budget, variance drivers and scenarios

• Finance month-end reconciliation

• Dynamic management report by region/product

• Revenue impact of multiple pricing scenarios

6. PIVOTTABLES, PIVOTCHARTS & EXCEL DASHBOARDS

Programme Sections

100% Practical · Unlimited Doubt Sessions

6. Pivottables

Pivotcharts & Exce Dashboards

• PivotTables

• Calculated fields

• Date grouping

• Slicers and timelines

• PivotCharts

• KPI cards

• Dashboard layout and visual hierarchy

• Conditional formatting for exceptions

• Presentation-ready reporting

• Sales Pivot Analysis Lab

• Customer Segmentation Lab

• Inventory Aging Lab

• Executive Excel Dashboard Lab

• Create a regional sales PivotTable with slicers

• Build an executive dashboard with at least five KPIs and three analytical views

• Retail Executive Dashboard — sales, margin, product mix, customer segment and monthly trend

• Weekly business review dashboard

• Slow-moving inventory analysis

• Refreshable monthly management report

7. POWER QUERY & DATA PREPARATION

Programme Sections

100% Practical · Unlimited Doubt Sessions

• ETL workflow

• Excel, CSV, folder and database connections

• Data profiling and data types

• Remove/replace/split/merge

• Fill and group

• Merge and append

• Pivot and unpivot

• Conditional/custom columns

• Parameters

• Refreshable transformations

• Introduction to M language

• Folder-Based Monthly Consolidation

• Customer Master Cleaning

• Sales-Product Merge

• Operational Report Unpivot

• Parameterized Data Load

• Combine 12 monthly files into one refreshable dataset

• Standardize customer and product data

• Build a reusable monthly refresh process

• Automated Sales Data Preparation Pipeline using Power Query

• Consolidate files from 20 branches

• Handle changing date/currency formats

• Replace manual daily copying with a refreshable process

8. POWER PIVOT & DATA MODELING

Programme Sections

100% Practical · Unlimited Doubt Sessions

• Fact and dimension tables

• Primary and foreign keys

• Relationships

• Star schema

• One-to-many relationships

• Date dimension

• Calculated columns vs measures

• Power Pivot model

• Model size and performance

• Relationship validation

• Sales Star Schema Lab

• Date Dimension Lab

• Customer-Product Model Lab

• Power Pivot KPI Model Lab

• Design an e-commerce star schema

• Build a sales model

• Correct duplicate keys and relationship issues

• Multi-Table Retail Analytics Model — transactions, customers, products and calendar

• Incorrect totals caused by relationships

• Reusable model design

• Optimize a slow workbook

9. SQL FUNDAMENTALS

Programme Sections

100% Practical · Unlimited Doubt Sessions

• Relational database concepts

• Tables, rows, columns and keys

• SELECT and DISTINCT

• WHERE and ORDER BY

• Aliases and calculated columns

• CASE

• NULL handling

• LIKE, IN and BETWEEN

• Aggregate functions

• GROUP BY and HAVING

• Date and string functions

• Customer Database Exploration

• Sales Filtering & Aggregation

• KPI Query

• Date-Based Sales Analysis

• Write 30 retail SQL queries

• Calculate revenue, order count, AOV and top products

• Identify invalid and duplicate records

• SQL Retail Sales Analysis — answer management questions using SQL

• Top 10 customers by revenue

• Month-wise sales and target comparison

• High-volume but low-revenue products

10. SQL JOINS, SUBQUERIES & INTERMEDIATE ANALYTICS

Programme Sections

100% Practical · Unlimited Doubt Sessions

10. Sql Joins

Subqueries & Intermediate

Analytics

• INNER JOIN

• LEFT JOIN

• RIGHT/FULL OUTER JOIN concepts

• Self and cross joins

• Multi-table joins

• Subqueries and correlated subqueries

• EXISTS/NOT EXISTS

• UNION and UNION ALL

• INTERSECT/EXCEPT concepts

• CTEs

• Conditional aggregation

• Date analysis

• Cohort concepts

• Multi-Table Sales Join

• Customer 360 SQL

• Product Profitability Query

• CTE-Based KPI

• Join five related business tables

• Find customers absent from a comparison period

• Build a CTE-based monthly product report

• Customer 360 Analysis — customer, order, product and support data

• Preserve unmatched customers

• Find customers inactive for 90 days

• Identify high-revenue/low-margin products

11. ADVANCED SQL FOR ANALYTICS

Programme Sections

100% Practical · Unlimited Doubt Sessions

• Window functions

• ROW_NUMBER, RANK, DENSE_RANK

• LAG and LEAD

• Running totals and moving averages

• PARTITION BY

• Advanced CTEs

• Views

• Stored procedure concepts

• Temporary tables

• Transactions and ACID concepts

• Indexes and execution-plan concepts

• Duplicate detection

• Data reconciliation

• Query optimization fundamentals

• Top-N per Category

• Customer Ranking

• Running Sales Total

• Month-over-Month Growth

• Deduplication

• SQL Performance Investigation

• Regional ranking query

• Month-over-month growth using windows

• Duplicate detection/resolution

• Optimize a deliberately slow query

• Advanced SQL Business Performance Analysis — executive KPIs, ranking, trends and exceptions

• Second/third-highest performer by region

• Previous vs current purchase analysis

• First and latest transaction per customer

12. POWER BI FUNDAMENTALS & DATA ACQUISITION

Programme Sections

100% Practical · Unlimited Doubt Sessions

• Power BI Desktop and Service

• Reports, dashboards and semantic models

• Excel, CSV, SQL and folder connections

• Import vs DirectQuery concepts

• Power Query in Power BI

• Basic transformations

• Visual selection

• Filters and slicers

• Formatting and themes

• Interactions

• Publishing

• Power BI Desktop Setup

• Excel-to-Power BI Import

• SQL-to-Power BI Connectivity

• Basic Sales Dashboard

• Connect Power BI to a relational sales database

• Create a three-page summary, trend and detail report

• Power BI Sales Performance Dashboard

• Convert Excel MIS to Power BI

• Build a SQL-driven management report

• Create drillable sales reporting

13. POWER BI DATA TRANSFORMATION & MODELING

Programme Sections

100% Practical · Unlimited Doubt Sessions

• Merge and append

• Query folding concepts

• Parameters

• Fact/dimension design

• Star schema

• Cardinality

• Filter direction

• Date tables

• Import vs DirectQuery decisions

• Model validation and performance

• Multi-Source Integration

• Star Schema Modeling

• Date Table

• Relationship Troubleshooting

• Model Optimization

• Transform five raw sources

• Design a retail star schema

• Correct relationship-driven totals

• Enterprise Sales Semantic Model — reusable sales/customer/product/region/calendar model

• Duplicate totals

• Automated monthly appends

• Reusable semantic model across reports

14. DAX FUNDAMENTALS

Programme Sections

100% Practical · Unlimited Doubt Sessions

• Measures vs calculated columns

• SUM, AVERAGE, COUNT, DISTINCTCOUNT

• CALCULATE

• FILTER and ALL

• IF and SWITCH

• DIVIDE

• Variables

• Date tables

• YTD, MTD and QTD

• Previous-period analysis

• Variance and growth

• KPI Measures

• Revenue & Margin

• Target vs Actual

• YTD/MTD/QTD

• Dynamic KPI

• Create 20 business measures

• Build revenue, margin, target and growth measures

• Create time-intelligence measures

• Sales KPI Semantic Model

• Same-period-last-year comparison

• Region-sensitive KPI

• Target achievement without double counting

15. ADVANCED DAX & POWER BI ANALYTICS

Programme Sections

100% Practical · Unlimited Doubt Sessions

• Filter context and row context

• Context transition

• SUMX and AVERAGEX

• Advanced ranking

• Top-N

• Dynamic titles

• Disconnected tables

• What-if parameters

• Dynamic segmentation

• Retention/cohort concepts

• Pareto analysis

• Rolling averages

• Advanced time intelligence

• DAX performance

• Top-N Product Analysis

• Pareto Customer Analysis

• Rolling 12-Month Sales

• Dynamic Segmentation

• What-If Parameter

• Dynamic Top-N selector

• Rolling 12-month KPI

• Customer segmentation measure

• 80/20 cumulative-revenue analysis

• Customer & Product Profitability Analytics

• Dynamic Top 10

• Rolling revenue trend

• Identify customers contributing 80% of revenue

16. POWER BI DASHBOARDS, SERVICE & GOVERNANCE

Programme Sections

100% Practical · Unlimited Doubt Sessions

• Executive dashboard design

• Drill-down and drill-through

• Tooltips

• Bookmarks and buttons

• Page navigation

• Conditional formatting

• Custom visuals

• Mobile layout concepts

• Power BI Service

• Workspaces

• Publishing and sharing

• Scheduled refresh concepts

• Gateway concepts

• Row-Level Security

• Governance concepts

• Executive Dashboard

• Drill-Through

• Tooltip Page

• Bookmark Navigation

• Row-Level Security

• Publish & Refresh

• Build a five-page executive report

• Implement regional RLS

• Create refresh and deployment checklist

• Regional Sales Command Center

• Regional data restriction

• Executive drill-through to root cause

• Investigate a failed refresh

17. INTEGRATED PROJECTS & BUSINESS CASE STUDIES

Programme Sections

100% Practical · Unlimited Doubt Sessions

• Retail Sales Analytics — Excel + SQL + Power BI

• HR Workforce Analytics — Excel + Power BI

• Inventory & Supply Chain Dashboard — SQL + Power BI

• Banking Customer Analytics — SQL + Excel

• E-Commerce Customer 360 — SQL + Power BI

• Finance Budget vs Actual — Advanced Excel + Power BI

• Marketing Campaign Performance — SQL + Power BI

• Service Desk KPI Analytics — Excel + SQL + Power BI

• Requirement gathering

• KPI definition

• Source identification

• Data profiling

• Cleaning

• SQL extraction and validation

• Excel reconciliation

• Power Query

• Data modeling

• DAX measures

• Dashboard design

• UAT

• Documentation

• Stakeholder presentation

• Business Requirement Document

• KPI Dictionary

• Source-to-Target Mapping

• SQL Query Pack

• Excel Workbook

• Power BI Semantic Model

• Interactive Dashboard

• Test Checklist

• User Guide

• Project Presentation

• Stakeholder changes a KPI definition

• Late or missing source data

• Business users challenge dashboard numbers and the analyst traces calculations to source

18. CAPSTONE PROJECT & REAL-TIME JOB SCENARIOS

Programme Sections

100% Practical · Unlimited Doubt Sessions

• Enterprise Sales & Profitability Analytics

• E-Commerce Customer 360

• Financial Performance & Budget Analytics

• Supply Chain & Inventory Intelligence

• HR Workforce Analytics

• Marketing Campaign & Conversion Analytics

• Service Desk KPI Dashboard

• Enterprise Sales & Profitability Analytics Platform using SQL + Excel/CSV + Power Query + Power BI

• SQL extraction, joins, validation and advanced analysis

• Excel reconciliation and exception analysis

• Power Query automation

• Star-schema semantic model

• DAX KPIs for revenue, margin, growth, targets and rankings

• Executive dashboard with regional/product/customer drill-through

• Regional security concept and documentation

• Daily sales dashboard

• Month-end revenue reconciliation

• Sales target and incentive analysis

• Customer retention analysis

• Inventory aging

• Marketing ROI

• Finance variance reporting

• Operations SLA reporting

• Executive KPI reporting

• Ad-hoc SQL analysis

• Power BI refresh investigation

• Dashboard performance optimization

• Excel/SQL/Power BI mismatch investigation

• New KPI implementation

19. TROUBLESHOOTING, INDUSTRY TOOLS & BEST PRACTICES

Programme Sections

100% Practical · Unlimited Doubt Sessions

• Duplicate SQL joins

• NULL-related analytical errors

• Slow SQL queries

• Broken Excel lookups

• Formula errors after source changes

• Power Query refresh/type issues

• Duplicate rows after merge/append

• Power BI relationship ambiguity

• Many-to-many issues

• Incorrect DAX totals/filter context

• Date intelligence problems

• Refresh/gateway issues

• RLS validation problems

• Slow Power BI visuals

• Microsoft Excel / Microsoft 365

• Power Query

• Power Pivot

• Power BI Desktop

• Power BI Service

• SQL Server / Azure SQL concepts

• MySQL / PostgreSQL concepts

• SQL Server Management Studio (SSMS)

• Visual Studio Code

• Git / GitHub

• Jira / Azure DevOps

• Microsoft Teams

• Define KPIs before visuals

• Validate source data

• Use consistent naming

• Build reusable transformations

• Prefer star-schema modeling

• Use measures efficiently

• Document business definitions

• Reconcile dashboards to source totals

• Avoid visual clutter

• Optimize SQL and data models

• Protect sensitive data

• Maintain versioned documentation

20. CERTIFICATIONS, INTERVIEWS, RESUME & PLACEMENT

Programme Sections

100% Practical · Unlimited Doubt Sessions

• Microsoft Certified: Power BI Data Analyst Associate (PL-300)

• Microsoft Office Specialist: Excel Expert (Microsoft 365 Apps) — MO-211

• Microsoft Certified: Azure Data Fundamentals (DP-900) as a complementary credential

• Relevant vendor SQL certifications for the target database platform

• SQL technical rounds

• Advanced Excel problem-solving

• Power BI/DAX scenarios

• Dashboard case studies

• Data validation scenarios

• Stakeholder communication

• Live SQL coding/debugging

• Power BI model review

• ATS-friendly Data Analyst resume

• Project-focused descriptions

• SQL + Excel + Power BI skill positioning

• Power BI portfolio guidance

• GitHub/project documentation

• LinkedIn optimization

• Achievement-oriented bullets

• Job-role mapping

• Resume screening and optimization

• Mock interviews

• Technical assessment preparation

• Portfolio presentation support

• Job application strategy

• Mentoring and career counseling

• Data Analyst

• Business Intelligence Analyst

• Power BI Analyst

• Reporting Analyst

• MIS Analyst

• SQL Analyst

• Business Analyst

• Junior BI Developer

• Data Visualization Analyst

• Reporting & Dashboard Specialist

• Learners should be able to take a business requirement, clean and validate data, write analytical SQL,

perform advanced Excel analysis, build a Power BI model, develop DAX measures, create executive

dashboards, troubleshoot reporting issues and present actionable insights.

Tools & Technologies

Every tool and library listed here is installed, configured and used in a hands-on lab session.

DATA ANALYTICS COMBO (WITHOUT PYTHON)

SQL

Covered in DATA ANALYTICS COMBO (WITHOUT PYTHON)

Power BI

Covered in DATA ANALYTICS COMBO (WITHOUT PYTHON)

Excel

Covered in DATA ANALYTICS COMBO (WITHOUT PYTHON)

1. COURSE OVERVIEW & CAREER ROADMAP

Power BI

Covered in 1. COURSE OVERVIEW & CAREER ROADMAP

SQL

Covered in 1. COURSE OVERVIEW & CAREER ROADMAP

Excel

Covered in 1. COURSE OVERVIEW & CAREER ROADMAP

3. PREREQUISITES & ANALYTICS FUNDAMENTALS

Power BI

Covered in 3. PREREQUISITES & ANALYTICS FUNDAMENTALS

SQL

Covered in 3. PREREQUISITES & ANALYTICS FUNDAMENTALS

4. EXCEL FUNDAMENTALS FOR DATA ANALYTICS

Excel

Covered in 4. EXCEL FUNDAMENTALS FOR DATA ANALYTICS

5. ADVANCED EXCEL ANALYTICS

Excel

Covered in 5. ADVANCED EXCEL ANALYTICS

6. PIVOTTABLES, PIVOTCHARTS & EXCEL DASHBOARDS

Excel

Covered in 6. PIVOTTABLES, PIVOTCHARTS & EXCEL DASHBOARDS

7. POWER QUERY & DATA PREPARATION

Excel

Covered in 7. POWER QUERY & DATA PREPARATION

8. POWER PIVOT & DATA MODELING

Covered in 8. POWER PIVOT & DATA MODELING

9. SQL FUNDAMENTALS

SQL

Covered in 9. SQL FUNDAMENTALS

10. SQL JOINS, SUBQUERIES & INTERMEDIATE ANALYTICS

SQL

Covered in 10. SQL JOINS, SUBQUERIES & INTERMEDIATE ANALYTICS

11. ADVANCED SQL FOR ANALYTICS

SQL

Covered in 11. ADVANCED SQL FOR ANALYTICS

12. POWER BI FUNDAMENTALS & DATA ACQUISITION

Power BI

Covered in 12. POWER BI FUNDAMENTALS & DATA ACQUISITION

Excel

Covered in 12. POWER BI FUNDAMENTALS & DATA ACQUISITION

SQL

Covered in 12. POWER BI FUNDAMENTALS & DATA ACQUISITION

13. POWER BI DATA TRANSFORMATION & MODELING

Power BI

Covered in 13. POWER BI DATA TRANSFORMATION & MODELING

14. DAX FUNDAMENTALS

Covered in 14. DAX FUNDAMENTALS

15. ADVANCED DAX & POWER BI ANALYTICS

Covered in 15. ADVANCED DAX & POWER BI ANALYTICS

16. POWER BI DASHBOARDS, SERVICE & GOVERNANCE

Power BI

Covered in 16. POWER BI DASHBOARDS, SERVICE & GOVERNANCE

17. INTEGRATED PROJECTS & BUSINESS CASE STUDIES

Power BI

Covered in 17. INTEGRATED PROJECTS & BUSINESS CASE STUDIES

SQL

Covered in 17. INTEGRATED PROJECTS & BUSINESS CASE STUDIES

Excel

Covered in 17. INTEGRATED PROJECTS & BUSINESS CASE STUDIES

18. CAPSTONE PROJECT & REAL-TIME JOB SCENARIOS

SQL

Covered in 18. CAPSTONE PROJECT & REAL-TIME JOB SCENARIOS

Power BI

Covered in 18. CAPSTONE PROJECT & REAL-TIME JOB SCENARIOS

Excel

Covered in 18. CAPSTONE PROJECT & REAL-TIME JOB SCENARIOS

19. TROUBLESHOOTING, INDUSTRY TOOLS & BEST PRACTICES

SQL

Covered in 19. TROUBLESHOOTING, INDUSTRY TOOLS & BEST PRACTICES

Power BI

Covered in 19. TROUBLESHOOTING, INDUSTRY TOOLS & BEST PRACTICES

Excel

Covered in 19. TROUBLESHOOTING, INDUSTRY TOOLS & BEST PRACTICES

Azure

Covered in 19. TROUBLESHOOTING, INDUSTRY TOOLS & BEST PRACTICES

20. CERTIFICATIONS, INTERVIEWS, RESUME & PLACEMENT

Power BI

Covered in 20. CERTIFICATIONS, INTERVIEWS, RESUME & PLACEMENT

SQL

Covered in 20. CERTIFICATIONS, INTERVIEWS, RESUME & PLACEMENT

Excel

Covered in 20. CERTIFICATIONS, INTERVIEWS, RESUME & PLACEMENT

Business Intelligence

Covered in 20. CERTIFICATIONS, INTERVIEWS, RESUME & PLACEMENT

10+

Tools & Libraries

523+

Hands-On Topics

Total Modules

Programme Sections

You don't just learn DATA ANALYTICS COMBO (WITHOUT PYTHON). You apply it.

A combined capstone project across all 20 sections — the same way you'd apply these skills on the job.

PROJECT // 01

DATA ANALYTICS COMBO (WITHOUT PYTHON) Capstone Project

→DATA ANALYTICS COMBO (WITHOUT PYTHON)

→1. COURSE OVERVIEW & CAREER ROADMAP

→3. PREREQUISITES & ANALYTICS FUNDAMENTALS

→4. EXCEL FUNDAMENTALS FOR DATA ANALYTICS

→5. ADVANCED EXCEL ANALYTICS

→6. PIVOTTABLES, PIVOTCHARTS & EXCEL DASHBOARDS

→7. POWER QUERY & DATA PREPARATION

→8. POWER PIVOT & DATA MODELING

→9. SQL FUNDAMENTALS

→10. SQL JOINS, SUBQUERIES & INTERMEDIATE ANALYTICS

→11. ADVANCED SQL FOR ANALYTICS

→12. POWER BI FUNDAMENTALS & DATA ACQUISITION

→13. POWER BI DATA TRANSFORMATION & MODELING

→14. DAX FUNDAMENTALS

→15. ADVANCED DAX & POWER BI ANALYTICS

→16. POWER BI DASHBOARDS, SERVICE & GOVERNANCE

→17. INTEGRATED PROJECTS & BUSINESS CASE STUDIES

→18. CAPSTONE PROJECT & REAL-TIME JOB SCENARIOS

→19. TROUBLESHOOTING, INDUSTRY TOOLS & BEST PRACTICES

→20. CERTIFICATIONS, INTERVIEWS, RESUME & PLACEMENT

Capstone Project Combined

Apply everything you learn across DATA ANALYTICS COMBO (WITHOUT PYTHON), 1. COURSE OVERVIEW & CAREER ROADMAP, 3. PREREQUISITES & ANALYTICS FUNDAMENTALS, 4. EXCEL FUNDAMENTALS FOR DATA ANALYTICS, 5. ADVANCED EXCEL ANALYTICS and 15 more to one real-world project

Bring together every course in this programme into a single, end-to-end project — the same way you would apply these combined skills on the job.

A working project combining all course modules

Added directly to your project portfolio

Reviewed by mentors before you graduate

Stack SQL Power BI Excel Azure GitHub Business Intelligence Data Visualization PostgreSQL MySQL JIRA

Hands-on Practice Areas

Hands-on Practice: DATA ANALYTICS COMBO (WITHOUT PYTHON) Hands-on Practice: 1. COURSE OVERVIEW & CAREER ROADMAP Hands-on Practice: 3. PREREQUISITES & ANALYTICS FUNDAMENTALS Hands-on Practice: 4. EXCEL FUNDAMENTALS FOR DATA ANALYTICS Hands-on Practice: 5. ADVANCED EXCEL ANALYTICS Hands-on Practice: 6. PIVOTTABLES, PIVOTCHARTS & EXCEL DASHBOARDS Hands-on Practice: 7. POWER QUERY & DATA PREPARATION Hands-on Practice: 8. POWER PIVOT & DATA MODELING Hands-on Practice: 9. SQL FUNDAMENTALS Hands-on Practice: 10. SQL JOINS, SUBQUERIES & INTERMEDIATE ANALYTICS Hands-on Practice: 11. ADVANCED SQL FOR ANALYTICS Hands-on Practice: 12. POWER BI FUNDAMENTALS & DATA ACQUISITION Hands-on Practice: 13. POWER BI DATA TRANSFORMATION & MODELING Hands-on Practice: 14. DAX FUNDAMENTALS Hands-on Practice: 15. ADVANCED DAX & POWER BI ANALYTICS Hands-on Practice: 16. POWER BI DASHBOARDS, SERVICE & GOVERNANCE Hands-on Practice: 17. INTEGRATED PROJECTS & BUSINESS CASE STUDIES Hands-on Practice: 18. CAPSTONE PROJECT & REAL-TIME JOB SCENARIOS Hands-on Practice: 19. TROUBLESHOOTING, INDUSTRY TOOLS & BEST PRACTICES Hands-on Practice: 20. CERTIFICATIONS, INTERVIEWS, RESUME & PLACEMENT

All projects go directly into your portfolio & resume — reviewed by mentors before you graduate.

See Sample Project Reports

Upcoming Batches

No upcoming batches scheduled right now. Enquire to get notified.

Why Radical Technologies

Live Online Training

Highly practical oriented training
Installation support on your system
24/7 Email and Phone support
100% Placement Assistance
Global Certification Preparation
Trainer-Student Interactive Portal
Assignments and Projects by Mentors

Live Classroom Training

Weekend / Weekdays / Morning / Evening batches
80:20 Practical and Theory ratio
Real-life Case Studies
Easy make-up for missed sessions
PSI | Kryterion | Redhat Test Centers
Lifetime Video Classroom Access (coming soon)
Resume Prep and Mock Interviews

Self-Paced Training

Learn 300+ courses at your own time
50,000+ Satisfied Learners
Course Completion Certificate
Practical Labs available
Mentor Support available
Doubt Clearing Session available
10% Discounted Global Certification

Like the Curriculum? Let's Get Started

Join 50,000+ students already enrolled at Radical Technologies

Enroll Now

Global Certification

Radical Technologies is the leading IT certification institute in Pune, offering globally recognized certifications across various domains. With expert trainers and comprehensive materials, we ensure students gain in-depth knowledge and hands-on experience to excel in their careers. Our certification programs are tailored to meet industry standards — from cloud technologies to data science — empowering individuals to stay ahead in the ever-evolving tech landscape.

Career Services

At Radical Technologies, we are committed to your success beyond the classroom. Our 100% Job Assistance program ensures that you are not only equipped with industry-relevant skills but also guided through the job placement process. With personalised resume building, interview preparation, and access to our extensive network of hiring partners, we help you take the next step confidently into your IT career.