3-Month Live Online Program · Analytics & Data Science
Tools | Projects | Case Studies
A rigorous, hands-on program that takes you from spreadsheets and statistics to SQL, Python and Power BI — and teaches you to turn raw data into decisions a business can act on. You learn in live, instructor-led classes, working on realistic datasets and industry-style case studies in sales, marketing, HR, finance and e-commerce — from anywhere in the world.
Course overview
Almost every organization — a neighborhood retailer, a hospital, a fintech start-up or a global manufacturer — now generates more data than it can comfortably use. Raw data rarely answers questions on its own. Someone has to ask the right question, find and clean the right data, analyze it with sound statistical reasoning, and then explain the result in a way that leads to action. That is the work of data analysts and data scientists, and it is what this program teaches you to do.
Data Science & Data Analytics is a 12-week, live online program that covers the complete modern analytics toolkit in a logical, cumulative order: spreadsheets for fast exploration, statistics for rigor, SQL for getting data out of databases, Python for cleaning and analysis at scale, Matplotlib, Seaborn and Power BI for communication, and an introduction to predictive analytics with scikit-learn. Instead of treating each tool in isolation, the course connects them into one end-to-end workflow, so you learn not only how to use a tool but when it is the right choice.
The skills taught here sit at the center of decision-making in almost every business function — marketing, sales, finance, operations, human resources and product. People who can query a database, check whether a result is statistically meaningful, build a dashboard that a manager trusts and explain what the numbers mean are valued well beyond the job title “analyst”. The program is designed to give you those abilities, along with the portfolio to demonstrate them.
Teaching follows a simple, repeatable rhythm: concept → live demonstration → guided practice → case study. Each week, your trainer introduces a concept, demonstrates it live on a realistic dataset, and then you practice it yourself during class. Weekly assignments consolidate the skill, and industry case studies — sales performance, marketing funnels, HR attrition, financial reporting and e-commerce behavior — show how the same techniques solve real business problems. The program closes with a capstone project and focused interview preparation.
Every project in the course follows the same professional lifecycle, so that by the final week it has become second nature.
Frame a business question, define the metric that answers it and locate the data — in spreadsheets, databases or APIs.
Fix missing values, duplicates, inconsistent formats and outliers; join sources into one analysis-ready table.
Explore patterns, test hypotheses, segment customers and, where useful, build a simple predictive model.
Present findings in clear charts, dashboards and a concise recommendation that a decision-maker can act on.
Who should join
The program starts from first principles and builds steadily, so it suits beginners as well as learners who already use data at work and want to formalize their skills. You will get the most from it if you recognize yourself in one of these descriptions:
A note for Mac users: Power BI Desktop, used in Week 10, runs only on Windows. On a Mac you can run it inside a Windows virtual machine, or complete the dashboard work in Tableau Public, which runs natively on macOS. Every other tool in this course works on Windows, macOS and Linux.
Motivated school students are welcome if they are comfortable with the mathematics above. The minimum learner age is 10, and learners under 18 need the consent of a parent or legal guardian, collected in the registration form (see our Privacy Policy).
Learning outcomes
Each outcome below is practiced in class, reinforced through assignments and demonstrated in at least one project, so you finish the program with evidence of every skill — not just familiarity with it.
Week-by-week syllabus
The 12 modules move from foundations to advanced, job-ready work. Each week combines live teaching, hands-on labs on real datasets and an assignment, and most weeks include an industry case study. Select a week to see its topics and the outcome you will achieve.
Outcome: You can explain how analytics drives decisions, have the complete toolkit installed, and can organize and query a structured dataset in a spreadsheet.
Outcome: You can turn a messy business dataset into a clean, pivot-driven summary report with clear charts in Excel or Google Sheets.
Outcome: You can describe any dataset statistically, reason about its distribution and judge whether a relationship between variables is meaningful.
Outcome: You can design and evaluate a basic A/B test and support a business decision with clearly explained statistical evidence.
Outcome: You can query a multi-table database to answer everyday business questions accurately and efficiently.
Outcome: You can write advanced analytical SQL with CTEs and window functions and solve the query patterns most often asked in SQL interview rounds.
Outcome: You can load, manipulate and summarize tabular data in pandas as fluently as you do in a spreadsheet or in SQL.
Outcome: You can turn raw data from files, databases or APIs into a clean, analysis-ready dataset and publish a documented EDA notebook on GitHub.
Outcome: You can communicate findings through accurate, well-designed charts and a KPI-driven narrative that a non-technical stakeholder can act on.
Outcome: You can build an interactive, well-modeled Power BI dashboard with core DAX measures and find your way around Tableau with confidence.
Outcome: You can build, evaluate and explain a simple regression or classification model and connect its output to a concrete business action.
Outcome: You present a complete, end-to-end analytics capstone and approach analyst interviews with a polished portfolio and well-practiced answers.
The sequence and depth of topics may be fine-tuned for each batch to reflect learner progress and current industry practice, without reducing the overall scope of the program.
Hands-on work
You will complete six guided projects built on realistic business datasets, followed by an independent capstone. Each project mirrors a task analysts perform at work, produces a portfolio-ready deliverable and is reviewed with feedback.
Clean a multi-region retail sales dataset, then analyze revenue, margin, product mix and seasonality with lookups and pivot tables. Deliver a one-page KPI summary with charts and three clear recommendations for regional managers. Weeks 1–2.
Analyze a landing-page experiment: check the randomization, compare conversion rates between the variants, run the appropriate significance test, compute a confidence interval and write a launch recommendation that explains the uncertainty in plain language. Weeks 3–4.
Query a multi-table orders database (customers, orders, order items, products and payments) to report monthly revenue, best-selling categories, repeat-purchase behavior, top customers per region and month-by-month cohort retention. Weeks 5–6.
Explore an employee dataset in Python to identify the factors most associated with attrition — tenure, role, compensation band, workload and satisfaction. Clean the data, visualize the patterns, test key differences statistically and publish a documented notebook on GitHub. Weeks 7–8.
Build a star-schema model in Power BI from raw sales and cost tables, write DAX measures for revenue, margin, year-to-date and month-over-month growth, and design an interactive dashboard with slicers and drill-through for a leadership review. Weeks 9–10.
Using subscription or e-commerce customer data, engineer features, train logistic-regression and decision-tree models, compare them with the right metrics and translate the results into a targeted retention plan the business could actually run. Week 11.
Choose a business problem in a domain that interests you — for example retail demand, marketing return on investment, customer retention, financial performance, HR or public open data — and solve it end to end on your own. You will frame the question and success metrics, source data from files, databases or public APIs, clean and analyze it with SQL and Python, build a Power BI dashboard, optionally add a predictive model, and present a concise recommendation to your trainer and peers.
Deliverables: a problem statement, cleaned dataset with SQL and Python code, a documented EDA notebook, an interactive dashboard, an executive summary and a live presentation — all published in your GitHub portfolio.
Your toolkit
You will work with the same tools used by analytics teams around the world. Every tool in the course is free or has a free version or free alternative, so you do not need to buy any software to complete the program.
Fast exploration, cleaning and business reporting.
Querying relational data at the source.
Cleaning, analysis and statistics at scale.
Charts, dashboards and data storytelling.
An applied introduction to machine learning.
Professional habits that employers look for.
Product names are trademarks of their respective owners. They are mentioned only to describe the course content and do not imply any affiliation with or endorsement of AwT Academy.
Learning experience
The program is built around practical learning, real-world projects, industry-relevant skills and career guidance. Every element below is part of the course fee.
Interactive, instructor-led sessions on Google Meet. Every concept is demonstrated live on real data and then practiced by you in guided labs, so you write queries, formulas and code in class — not just watch.
Structured notes, practice datasets, Jupyter notebooks, SQL scripts and reference sheets for each module, plus weekly assignments that build the habit of independent problem-solving.
Ask questions during live sessions and get help from the trainer and team on blockers between classes, so a single error message never holds back your progress.
SQL interview patterns, statistics and Excel questions, business case questions and portfolio walkthroughs are built into the program and drilled intensively in the final week.
Guidance on choosing between analyst, BI and data-science paths, presenting your projects, strengthening your resume and planning your next steps after the course.
Learn alongside motivated peers from different backgrounds and countries. Be a part of a growing tech community where you share ideas, review each other’s work and grow together.
All class timings are scheduled in Indian Standard Time (IST, UTC+5:30). When you register, you choose your preferred slot — Morning, Afternoon, Evening, Weekend or Flexible — and our team confirms the batch start date and final timings with you after registration and before the batch begins. Learners outside India should convert IST to their local time when choosing a slot; our team is happy to help on WhatsApp.
Interactive live classes for learners anywhere in the world. Join from home on a laptop or desktop, practice hands-on with the trainer and take part in every project, review and interview-preparation session.
Enroll for live onlineClassroom batches are planned for learners in Chandigarh, Mohali and Panchkula only. No launch date has been announced, and offline seats cannot be booked or paid for yet. Message or call us to be informed when offline batches open.
Get notifiedCertification & assessment
On successfully completing the course requirements, you receive a Certificate of Completion from AwT Academy for Data Science & Data Analytics, issued in the name you provide at registration.
The Certificate of Completion confirms that you completed this AwT Academy program. It is not a degree or diploma and is not issued by a university or government body. Its real value lies in the skills and the portfolio of projects you build to earn it.
Career pathways
Analytics skills are used in almost every industry — retail, banking and financial services, e-commerce, healthcare, manufacturing, consulting, technology and the public sector. The program prepares you to pursue the following roles. Titles and expectations vary by company and country, and some roles also value domain experience.
| Role | What the work involves | Course skills you will use |
|---|---|---|
| Data Analyst | Collecting, cleaning and analyzing data to answer business questions; building recurring reports and dashboards. | SQL, Excel, Python, statistics, Power BI |
| Business Analyst | Translating business problems into data requirements, analyzing processes and KPIs, and recommending improvements. | Excel, SQL, KPIs, storytelling |
| BI Analyst / Power BI Developer | Designing data models and dashboards that teams rely on to track performance every day. | Power BI, DAX, data modeling, SQL |
| Product Analyst | Measuring feature adoption, funnels and retention; designing and interpreting A/B tests. | SQL, A/B testing, funnel and cohort analysis |
| Marketing Analyst | Evaluating campaign performance, conversion, acquisition cost and channel effectiveness. | Funnel analysis, experiments, dashboards |
| Financial or Operations Analyst | Tracking budgets against actuals, analyzing variances and improving operational efficiency. | Excel, Power BI, KPIs, regression |
| HR / People Analyst | Analyzing attrition, hiring funnels and workforce metrics to support people decisions. | EDA, statistics, dashboards |
| Associate Data Scientist (with further study) | Building and evaluating predictive models on business data. | Python, statistics, scikit-learn — continue with AI & Machine Learning |
No placement or job guarantee. Career guidance and interview preparation are an integral part of this program, but AwT Academy does not promise placements, jobs, internships or salaries. Hiring outcomes depend on your effort, background, portfolio and the job market. See our Terms & Conditions.
Your trainer
Managing Director & Head, AwT Academy
Technical Trainer | AI/ML Educator
Manish leads AwT Academy and is the lead trainer on its programs. He has worked at Intel, IBM and Microsoft, is GATE Qualified Twice, and brings 5 years of training experience to the classroom — having trained 25,000+ students across 68+ colleges.
His teaching is rooted in how analytics is practiced at work: start from the business question, choose the simplest tool that answers it reliably, and always be able to explain the result. Expect clear explanations, live problem-solving and honest feedback on your work.
Worked atIntel
Worked atIBM
Worked atMicrosoftCompany names and logos identify organizations where the trainer has worked. They do not indicate any partnership with or endorsement of AwT Academy.
Meet the AwT Academy teamFees & payment
One transparent fee covers the complete program. The same fee applies to every AwT Academy course; the amount depends only on your country of residence, which you declare at registration. The registration form applies the correct fee automatically based on the country you select.
| Item | Amount |
|---|---|
| Course fee — Data Science & Data Analytics (3 months, live online) | ₹24,000 (India) · ₹30,000 (outside India) |
| GST @ 18% | ₹4,320 (India) · ₹5,400 (outside India) |
| Total payable | ₹28,320 (India) · ₹35,400 (outside India) |
Complete the registration form, choose your preferred IST batch slot and pass a quick security check.
Pay ₹28,320 (India) or ₹35,400 (outside India) in the Razorpay window using UPI, cards, net banking or wallets. International cards are accepted where supported by your bank.
Your registration is submitted only after Razorpay confirms the payment. You see a receipt on screen, and Razorpay emails a payment confirmation.
Our team shares the batch start date and final timings after registration, before the batch begins.
Refunds in brief: cancel before the batch starts or within the first 4 days from the batch start date for a 100% refund of the full amount paid; on day 5, 6 or 7 receive 50% of the course fee plus the attributable GST; from day 8 no refund is available. If we cancel a batch or postpone its start by more than 30 days, you choose a 100% refund or a free transfer. Read the full Refund & Cancellation Policy.
Questions & answers
No. Python and SQL are taught from the beginning, and all statistics is built up from first principles. You only need comfort with school-level mathematics — percentages, ratios, averages and reading simple graphs — and basic computer skills. What matters most is regular practice between classes.
Both, with a deliberate emphasis. The core of the program is the complete analytics toolkit — Excel, statistics, SQL, Python, visualization and Power BI — applied to business case studies. It then introduces predictive analytics with scikit-learn, giving you a solid data-science foundation. If you later want to go deeper into machine learning and deep learning, our AI & Machine Learning course is the natural next step.
No. Every tool used in the course is free or has a free version or alternative: Google Sheets can be used where you do not have Microsoft Excel, and Python, Jupyter, Google Colab, MySQL, PostgreSQL, Power BI Desktop, Tableau Public, Git and GitHub are all available free of charge. Week 1 includes a guided setup session. Note that Power BI Desktop runs only on Windows; Mac users can use a Windows virtual machine or complete the dashboard work in Tableau Public.
Yes. Live online classes are open to learners worldwide. Timings are scheduled in Indian Standard Time (IST), so choose a slot that suits your local time zone when you register. Learners outside India pay ₹30,000 + GST (₹5,400), a total of ₹35,400, charged in INR through Razorpay; international cards are accepted where supported by your bank, which sets its own conversion rate and charges.
You choose your preferred slot — Morning, Afternoon, Evening, Weekend or Flexible — when you register. Our team then confirms the batch start date and final timings in IST after registration and before the batch begins. For the latest information on upcoming batches, call or WhatsApp us on +91 62830 97869 or +91 94652 65663.
Offline classes are coming soon and will be available only to learners in Chandigarh, Mohali and Panchkula. No launch date has been announced, and offline seats cannot be booked or paid for yet. If you are interested, message us on WhatsApp and we will let you know when offline batches open. Live online classes are open now.
Attendance matters: you need at least 75% live-session attendance to earn the Certificate of Completion. If you miss a session, work through that week’s study material and assignment and bring your questions to the next class or to the team for doubt-solving. If a recording of a session is made available, it is for your personal study only — not every session is recorded, so please plan to attend live.
You need at least 75% attendance in live sessions and must submit the required assignments and the final (capstone) project. The certificate is issued in the name you enter at registration, so please enter it exactly as you want it to appear.
No. We do not guarantee placements, jobs, internships or salaries. The program gives you job-relevant skills, a portfolio of projects, interview preparation and career guidance, but hiring outcomes depend on your own effort, background and the job market.
The course fee is ₹24,000 plus GST at 18% (₹4,320), for a total of ₹28,320 for learners in India, or ₹30,000 plus GST (₹5,400), for a total of ₹35,400 for learners outside India. The tier depends only on your country of residence, and both are charged in INR. Prices are exclusive of GST. You pay online through Razorpay using UPI, cards, net banking or wallets, and a GST-compliant tax invoice is issued to your registered email address. Enter your GSTIN during registration if you need a business invoice. Your seat is confirmed only after the payment is captured and verified with Razorpay.
Days are counted in calendar days from the batch start date (the first scheduled live session). GST is refunded in proportion to the refunded fee. Approved refunds are made to the original payment method only. Full details, exclusions and the request process are in our Refund & Cancellation Policy.
Yes. You can switch to another course (all courses have the same fee) free of charge, once, before your batch starts or within the first 4 days of the batch. Transfers to a later batch follow the rules in our Refund & Cancellation Policy. Fees are per learner and cannot be transferred to another person.
Keep learning
Every AwT Academy course runs for 3 months, live online, at the same transparent fee of ₹24,000 + GST (India) / ₹30,000 + GST (outside India).
From Basics to Advanced
Go from your first line of code to building real applications, automations and data tools with Python — the language behind AI, data science and modern back-ends.
Programming & Problem Solving
Build rock-solid programming fundamentals — memory, pointers, OOP and the C++ STL — and sharpen the problem-solving skills that coding interviews and competitive programming demand.
Programming & DSA
Master core and advanced Java — OOP, collections, exceptions, multithreading — and apply it to data structures and algorithms the way top product companies test it.
Join Upcoming Batches of Data Science & Data Analytics — live online and open worldwide. Register in minutes and pay securely with Razorpay; your seat is confirmed as soon as your payment is verified.