Skip to content

Data Analytics Training in Indore

Excel, SQL, Python and Power BI to clean data, find insights and build business dashboards.

  • Live online classes
  • Classroom batches in Indore
  • End-to-end live project
  • Course certificate
  • Interview preparation
  • Placement assistance

Book a free demo: +91 62667 39095 View syllabus

About this course

Data analysts help every department make better decisions. This programme teaches the complete analyst toolkit: advanced Excel, SQL to query databases, Python for automation and analysis, and Power BI to build interactive dashboards, all applied to realistic business problems in sales, HR and finance.

Who is this course for?

Graduates, freshers and professionals in any function who want to turn business data into insights and dashboards.

Course details

ModeLive online classes, or classroom batches at our Indore office
Classroom locationOffice Number 330, The Veda Building, Bhanwarkua Square, Indore, Madhya Pradesh
BatchesWeekday and weekend batches, in small groups with personal attention
ProjectComplete live project, built end to end from requirements to deployment
CertificateMakeMyCodes course completion certificate
Career supportInterview preparation, mock interviews and placement assistance
FeesCall +91 62667 39095 for current fees and offers
TrainerSudheer Singh Chouhan, 20+ years of MNC experience

Syllabus

The syllabus is covered through live coding, hands-on assignments after each module, and regular doubt-clearing sessions.

Module 1: Advanced Excel

  • Formulas, lookups (XLOOKUP, VLOOKUP) and logical functions
  • Data cleaning and Power Query
  • Pivot tables and pivot charts
  • Dashboards in Excel

Module 2: SQL for analysis

  • SELECT, filtering, sorting and aggregation
  • Joins, subqueries and CTEs
  • Window functions: ranking, running totals, LAG and LEAD
  • Writing reports from a database

Module 3: Statistics for analysts

  • Averages, spread and distributions
  • Trends, growth and percentages
  • Correlation and simple forecasting

Module 4: Python for analytics

  • Python basics
  • Pandas for cleaning and analysing data
  • Charts with Matplotlib and Seaborn
  • Automating repeated reports

Module 5: Power BI

  • Connecting to Excel and SQL Server
  • Power Query transformations
  • Data modelling and relationships
  • DAX measures and calculated columns
  • Interactive reports and publishing

Module 6: Business analysis and storytelling

  • Defining KPIs
  • Designing clear dashboards
  • Presenting insights to stakeholders

Tools and technologies

  • Microsoft Excel
  • Power Query
  • SQL Server and SSMS
  • Python 3
  • Pandas
  • Jupyter Notebook
  • Power BI Desktop and Service

Projects you will build

Every learner builds a complete live project end to end: requirements, design, development, testing and deployment, the same way projects run in industry. This is the project you will present in interviews.

  • Sales performance dashboard (end-to-end live project): Combine sales data from SQL Server and Excel, clean it with Power Query, model it and build an interactive Power BI dashboard with KPIs, trends and drill-downs.
  • HR attrition analysis: Analyse employee data with SQL and Python to find the factors behind attrition, and present recommendations.
  • Automated monthly report: A Python script that reads raw data, calculates KPIs and produces a ready-to-share Excel report.

Prerequisites

  • Basic computer knowledge
  • Basic familiarity with Excel is helpful but not required
  • A Windows laptop (Power BI Desktop runs on Windows)

Career opportunities

After completing this course and its project, you will be prepared for roles such as:

  • Data Analyst
  • Business Analyst
  • Power BI Developer
  • MIS / Reporting Analyst

What you get

  • Live, interactive classes with doubt-clearing in every session, online or in our Indore classroom
  • A syllabus based on how real projects are built in MNCs
  • Hands-on assignments after every module
  • A complete end-to-end live project for your portfolio
  • Interview preparation with mock interviews and frequently asked questions
  • Placement assistance: resume and profile review and help with job applications
  • A MakeMyCodes course completion certificate

Your trainer

Frequently asked questions

What is the difference between Data Analytics and Data Science?

Data analytics focuses on understanding what happened and why, using Excel, SQL and dashboards. Data science goes further into predicting what will happen, with machine learning. Many people start with analytics.

Do I need coding experience?

No. Excel and Power BI need no coding, and SQL and Python are taught from the basics with business examples.

Which dashboard tool is taught?

Microsoft Power BI, one of the most widely used business intelligence tools, along with dashboards in Excel.

Are the classes online or in a classroom?

Both. You can join live, interactive online classes from anywhere, or attend classroom batches at our Indore office near Bhanwarkua Square.

What are the fees?

Fees depend on the programme and batch. Please call +91 62667 39095 for current fees and offers.

Will I get a certificate?

Yes. You receive a MakeMyCodes course completion certificate after completing the programme and its project.

Do you provide placement assistance?

Yes. We help with resume and profile preparation, conduct mock interviews and practise frequently asked interview questions, and support you in applying for suitable job opportunities.

Will I work on a real project?

Yes. Every programme includes a complete live project, built end to end from requirements to deployment, so you are industry-ready and can explain it confidently in interviews.

Can I attend a demo class before joining?

Yes. Book a free demo class by calling +91 62667 39095. You can meet the trainer and see how the classes run before you decide.

Start learning for free

Get a head start with our free tutorials on the same topics:

Other training programmes

Book a Free Demo Class

Meet the trainer, see how the Data Analytics classes run, and get guidance on the right batch for you. Classes are available live online and at our Indore office.

Call +91 62667 39095

Or email contactus@makemycodes.com