- Status
- Enrollment open
- Duration
- 12 weeks
- Schedule
- Mon to Fri, 1.5 hours a day
- Format
- Live online, hands-on building
- Level
- No coding experience needed
- Fee
- ₹4,999 + GSTor 2 × ₹2,499.50
About the program
What it is
A practical program for beginners and aspiring analysts. You learn analytical thinking, database querying, data visualization and business intelligence, and use them to make data-driven decisions.
What you work on
From writing complex SQL queries and cleaning raw datasets to building interactive Power BI dashboards and automating analysis with Python and AI tooling.
How you learn
Hands-on data solving from day one. You will analyze real-world datasets, solve business case studies, and build portfolio-ready dashboards with direct mentor feedback.
Your mentor
Sandeep
Data Science Trainer & Mentor
byteXL
- Python
- SQL
- Power BI
- Data Science
- Machine Learning
Sandeep on LinkedInlinkedin.com (opens in a new tab)“Technology keeps evolving. Your ability to learn should too.”
What you will be able to do
Excel and advanced analytics
Use pivot tables, advanced formulas, lookup functions and data modeling in Excel.
SQL and database querying
Write complex SQL queries, multi-table joins, aggregations, CTEs and window functions.
Python for data analysis
Transform datasets, handle missing values and run statistical analysis with Pandas and NumPy.
Data visualization and dashboards
Build interactive business dashboards and visual reports with Power BI, Matplotlib and Seaborn.
Exploratory data analysis
Find patterns, anomalies, correlations and trends in raw data.
Business problem solving
Turn business questions into an analysis plan and clear recommendations for leadership.
AI-assisted analytics
Use GenAI tools to write queries, generate reports and clean data faster.
Statistical modeling
Apply hypothesis testing, regression analysis and descriptive statistics to real scenarios.
What you will build
Projects grow in scope from the first weeks to the capstone.
Learning
Sales and performance Excel dashboard
Analyze multi-channel sales data with advanced formulas, pivot tables and interactive slicers.
- Microsoft Excel
- Pivot Tables
- Data Modeling
Analysis
E-commerce customer cohort SQL audit
Query relational tables with window functions and CTEs to find retention trends and customer lifetime value.
- SQL
- PostgreSQL
- Database Aggregations
Visualization
Exploratory data analysis with Python
Clean messy real-world datasets with Pandas and chart what you find with Seaborn and Matplotlib.
- Python
- Pandas
- Matplotlib
- Seaborn
Business problem solving
Executive Power BI dashboard
Build a multi-page Power BI dashboard with DAX measures, KPI tracking and interactive cross-filtering.
- Power BI
- DAX
- Power Query
Capstone
AI-augmented business intelligence capstone
Turn raw company data into a full business report using SQL, Python, Power BI and GenAI-assisted summaries.
- SQL
- Python
- Power BI
- GenAI Tools
AI in your workflow
You use GenAI tools to write SQL, clean data in Python EDA scripts and draft executive summaries faster, and you still check every result yourself.
Tools covered
- ChatGPT
- Claude
- Cursor
- Code Interpreter
- Gemini
Preparation for the job search
Built into the program alongside the technical work.
Your profile
- Resume refinement
- Write an analytics resume that shows business impact, measurable results and your SQL and Python projects.
- GitHub and portfolio showcase
- Organize your SQL queries, Python notebooks and Power BI dashboards into a public portfolio.
- LinkedIn optimization
- Set up your LinkedIn profile so recruiters hiring data analysts and BI specialists can find you.
Interview preparation
- SQL and analytics interviews
- Prepare for live SQL coding challenges, data puzzle screenings and database problem solving.
- Business case preparation
- Learn to break down open-ended business problems, form hypotheses and present your findings.
- Mock interviews
- Practice technical query rounds and behavioral presentations with experienced industry mentors.
Common questions
Who is this Data Analyst program for?
This program is designed for beginners, graduates, and working professionals who want to develop practical data analysis skills in SQL, Python, Excel, and Power BI.
Do I need a prior programming background?
No prior programming experience is required. We start from foundational data concepts and build up step-by-step through guided hands-on practice.
How long is the program?
The program spans 12 weeks, requiring approximately 1.5 hours per day of live learning and practical project building.
What tools will I learn?
You will learn Microsoft Excel, SQL (PostgreSQL), Python (Pandas, NumPy, Matplotlib, Seaborn), Power BI, and GenAI analytical tools.
What projects will I build?
You will progress from interactive Excel dashboards to an e-commerce SQL retention audit, a Python EDA report, an executive Power BI dashboard, and a final AI-augmented BI Capstone.
What are the payment options?
We offer two payment plans: a one-time Full Payment of ₹4,999 + GST, or a Split Payment of ₹2,499.50 at enrollment and ₹2,499.50 after 25 days.
What happens after I apply?
Our program coordinator will personally reach out to discuss your application, confirm your selected payment plan, and guide you through enrollment.
Is a certificate provided?
Yes, upon completing the program curriculum and passing the Capstone project defense, you will receive a certificate of completion.
Something else on your mind? Write to support.lumoraspace@gmail.com.
Start with a short application.
No payment is needed to apply. A program coordinator contacts you, confirms your payment plan and completes your enrollment.
Program fee
₹4,999 + GST
- Pay in full
- ₹4,999 + GST, one-time payment
- Pay in instalments
- ₹2,499.50 at enrollment₹2,499.50 after 25 days