Build a practical foundation in data analytics through data basics, Excel formulas, data cleaning, pivot tables, charts, SQL queries, Power BI dashboard exposure and a guided mini analytics assignment at Zestminds Academy’s Mohali campus.
This short-duration program is suitable for beginners, college students, freshers and career switchers who want to understand how raw data becomes a report, dashboard and useful business insight.
Suitable for B.Tech, BCA, MCA and diploma students, beginners, freshers and learners from Mohali, Chandigarh, Panchkula and nearby Tricity areas.
Practice formulas, cleaning, pivot tables, charts and summary reports.
Learn filtering, grouping, totals and beginner reporting queries.
Import data and create cards, charts, slicers and dashboard summaries.
Practice explaining findings and writing simple recommendations.
A focused beginner syllabus covering the analytics process, Excel reporting, SQL fundamentals, Power BI and a mini assignment.
Learn how to identify a business question, clean a dataset, create reports and explain basic findings through practical classroom assignments.
Download Full SyllabusRows, columns, fields, records, data types, data quality issues and business questions.
Sort, filter, format, remove duplicates, SUM, COUNT, IF, COUNTIF, SUMIF and XLOOKUP introduction.
Create pivot summaries, charts, dashboard-style sheets and simple written insights from datasets.
Practice SELECT, WHERE, COUNT, SUM, AVG, GROUP BY, ORDER BY and beginner Power BI dashboard creation.
This short-duration course is designed for learners who want practical analytics exposure before choosing a longer program.
B.Tech, BCA, MCA and diploma students seeking short-term practical training in reporting and dashboards.
Learners who want to understand data, Excel, SQL and Power BI without starting with advanced analytics topics.
Freshers and career switchers evaluating reporting, MIS, business analysis or data analytics learning paths.
Students learn the purpose behind the tools, not only where to click inside Excel or Power BI.
Identify the business question.
Prepare accurate and usable data.
Calculate totals and comparisons.
Present findings through charts.
Explain what action should follow.
Assignment selection may vary by batch and student level, but the focus remains practical reporting and beginner insights.
Analyze enquiries, admissions, courses or marketing sources in Excel.
Build summary tables and charts from a structured dataset.
Answer beginner questions using filters, grouping and aggregate functions.
Create cards, charts and slicers in a beginner Power BI dashboard.
Students receive guidance to clean a beginner dataset, prepare an Excel report, write basic SQL queries, create a simple Power BI dashboard and present three to five observations or recommendations. This is a foundation project, not advanced job-ready mastery.
Students practice datasets, formulas, queries and dashboards with direct mentor guidance and assignment review.
Review the essential course information before booking a counselling session.
Address:
E-45, Industrial Area, Phase 8, Mohali
Students from Chandigarh, Panchkula, Kharar, Zirakpur and nearby Tricity areas can attend the offline course at the Mohali campus.
Need Python/Pandas, a portfolio project or deeper analytics and dashboard practice?
Compare All Data Analytics ProgramsQuick answers for students and parents before joining the course.
The course duration is 45 days and the fee is ₹7,000.
It is an offline classroom program conducted at Zestminds Academy’s Mohali campus.
Yes. The course begins with data basics before moving into Excel, SQL, Power BI and a mini analytics assignment.
The 45-day syllabus focuses on Excel, SQL fundamentals and introductory Power BI dashboard practice.
The 45-day foundation syllabus primarily focuses on Excel, SQL and Power BI. Python and Pandas are covered in the longer tracks.
Students receive a guided mini assignment involving data cleaning, an Excel report, basic SQL queries, a simple dashboard and a short insight summary.
The 45-day course builds a practical analytics foundation. Deeper portfolio and career preparation requires continued practice or a longer 3-month or 6-month program.
Yes. Students from Chandigarh, Panchkula and nearby Tricity areas can attend classes at the Mohali campus.
Build a practical foundation through Excel reporting, SQL query practice, Power BI dashboard exposure and a guided mini analytics assignment.
Fee: ₹7,000 | Mode: Offline | Location: Mohali Campus
Fill the form and our training counsellor will contact you shortly.
Fill the form and our training counsellor will contact you shortly to book your free counselling appointment.
