Course overview

30-Day Data Analytics – From Scratch to Advanced with Hands-On Projects

Unlock the world of Data Analytics with our 30-day instructor-led program designed for beginners and aspiring professionals. This course takes you from the basics of Excel and SQL to advanced visualization tools like Tableau, Power BI, and Python for analytics. Through hands-on practice and real-world projects, you’ll gain the skills to analyze, visualize, and present data-driven insights effectively.

What You’ll Learn:

  • Fundamentals of Excel for Data Analytics (functions, PivotTables, Power Query).
  • Data Visualization & BI Tools – Tableau, Power BI, Google Data Studio.
  • SQL for business insights – queries, joins, aggregations, and data cleaning.
  • Advanced concepts like Forecasting, A/B Testing, Customer & Marketing Analytics.
  • Python for Analytics – data handling, Pandas, and visualization.
  • Build and present real-world projects to strengthen your portfolio.
Register Now

Who This Course is For:

  • Beginners wanting to enter the Data Analytics field.
  • Students & professionals looking to upskill with BI tools and SQL.
  • Anyone aiming to build a portfolio in Data Analytics for career growth.

Requirements:

  • No prior experience needed – we start from scratch.
  • A computer with internet access.
  • Enthusiasm and commitment to complete daily hands-on practice.

Course Features

Instructor-led Live Sessions

Participate in live sessions for real-time learning and interactive support.

Hands-on Projects and Exercises

Apply your skills with real-world projects, coding exercises, and quizzes.

Certificate of Completion

Earn a verifiable certificate upon course completion.

Course Curriculum

🔹 What is Data Analytics? Roles, tools, and real-world applications.
🔹 Excel basics: formatting, formulas, sorting & filtering.
🔹 Hands-on: Build a sales summary with Excel functions.

🔹 VLOOKUP, INDEX-MATCH, conditional formatting.
🔹 PivotTables, PivotCharts, slicers for dashboards.
🔹 Power Query for data cleaning & transformations.
🔹 Hands-on: Create a customer sales dashboard in Excel.

🔹 Databases overview, SELECT, WHERE, ORDER BY.
🔹 Joins (INNER, LEFT, RIGHT), GROUP BY & HAVING.
🔹 Hands-on: Write queries on a sales database.

🔹 Subqueries, Common Table Expressions (CTEs), window functions.
🔹 Case statements, cohort analysis, retention metrics.
🔹 Data cleaning with SQL (NULLs, duplicates, string functions).
🔹 Hands-on: Rank customers, clean datasets, perform cohort analysis.

🔹 Python basics: data types, loops, functions.
🔹 Pandas for data handling: filtering, merging, GroupBy.
🔹 Data visualization basics with Matplotlib & Seaborn.
🔹 Hands-on: Analyze sales trends with Pandas.

🔹 Principles of effective dashboards.
🔹 Tableau basics & advanced (calculated fields, parameters).
🔹 Power BI basics & advanced (DAX, Power Query, interactive dashboards).
🔹 Google Data Studio / Looker for real-time dashboards.
🔹 Hands-on: Build business dashboards across BI tools.

🔹 Business Analytics: KPIs, OKRs, case studies.
🔹 A/B Testing: experiment design, significance testing.
🔹 Forecasting & Trend Analysis with Excel/Python.
🔹 Data Storytelling: presenting insights effectively.
🔹 Hands-on: Marketing campaign metrics & forecasting.

🔹 Case Study 1: Marketing Analytics.
🔹 Case Study 2: Customer Analytics (RFM analysis).
🔹 Final Project: End-to-end Data Analytics project using Excel, SQL, Python & BI tools.
🔹 Portfolio & Career Prep: GitHub, dashboards, resume guidance.

About the Instructor:

Keerthana. T

Academic Program Manager at NexJireh Solutions

Keerthana Thennarasan is an Academic Program Manager with a strong foundation in Computer Science and Engineering. With a passion for simplifying complex concepts, she has been instrumental in designing and delivering academic programs that introduce students to Data Science, Analytics, and Visualization. Her experience includes mentoring students across different levels, guiding them to gain confidence in working with data through structured, beginner-friendly learning paths. She specializes in creating curricula that blend statistical foundations, Python programming, and real-world case studies—ensuring students not only understand data science concepts but also apply them effectively through hands-on projects and practical analysis.

Enroll Now

👉 Register Now and take the first step towards your career in Data Analytics!
Batch Start Date: TBA
Course Duration: 30 Days
This is your opportunity to learn from an expert, gain hands-on experience, and earn a verifiable certificate. Enroll today to secure your spot!

Register now