Go from Excel basics to querying real databases and writing Python. Master formulas, XLOOKUP, pivot tables and Power Query dashboards, design and query a MySQL database with joins, CTEs and window functions, then clean and analyse data with Python, NumPy and pandas — checking every number across tools.
Introduction
Data Analytics Level 1 is a build-first course that needs no coding or statistics background. It starts where most business data already lives, in Excel: clean data entry, everyday formulas, lookups, pivot tables, what-if analysis and a refresh-ready Power Query dashboard. You then move the same questions into a real MySQL database — designing tables with keys, writing SQL from SELECT to joins, CTEs and window functions, and completing a SQL business case study. Finally you write Python, compute fast statistics with NumPy and clean and analyse data with pandas, reproducing your SQL results to prove both tools agree. Around 70% of class time is hands-on, every lab runs on your own laptop, and every number you present must trace back to the data and steps that produced it.
Learning outcome
Clean and analyse data in Excel from basic to advanced, design and query a MySQL database with SQL, and write Python with NumPy and pandas — with an Excel dashboard and a SQL business case study to show employers.
Curriculum
Click any module to expand and view topics and hands-on labs included.
Turn a business question into measurable questions and the right KPI
Hands-on lab
Results
Clean data, use SUMIFS and XLOOKUP, summarise with pivot tables and model decisions with what-if analysis.
Automate repeat cleaning with Power Query and build a refresh-ready Excel sales dashboard.
Design a relational database and answer business questions with joins, CTEs and window functions.
Write Python, compute statistics with NumPy, and clean and analyse data with pandas and read_sql.
Ask for fees, batches and the full syllabus on WhatsApp.
Join live, hands-on classes at our Goa centres, with a certificate and placement support. See every Data Analytics course we offer, or visit the centre closest to you.
Start where most business data already lives: Excel. Learn to turn a vague business question into the right KPI, clean messy data, answer questions with formulas, combine sheets with XLOOKUP, summarise thousands of rows with pivot tables, model decisions with what-if analysis, and automate it all with Power Query into a one-screen sales dashboard.
A build-first programme that takes you from Excel basics to advanced analysis, then into SQL and MySQL databases, Python with NumPy and pandas, and interactive dashboards in Power BI and Tableau. Every phase ends with a portfolio project, every number you present must trace back to the data that produced it, and you finish with a public portfolio, live dashboards, interview practice and a 3-month dual-track internship on real business problems.