Business Analytics Internship & Certification
A 60-day practical business analytics programme taught live by HireCraft360 faculty: 45 days of core analytics on a four-tool stack (Excel, SQL, Power BI, Python) and 15 days of soft skills, with career support and a capstone project report.
I'm interestedAbout the programme
- Format
- One live, instructor-led hour every day for 60 days: 45 days of core business analytics training and 15 days of soft skills and career readiness training, plus live dashboards and a capstone project report.
- Who it is for
- BBA, MBA, B.Com, B.Tech and BCA students, fresh graduates and anyone aiming at a business analyst or data analyst role.
- What you leave with
- An end-to-end analytics portfolio (Excel, SQL, Power BI and Python basics), executive dashboards, an ATS-friendly resume and an updated LinkedIn profile, a capstone project report, and an internship completion certificate.
- Duration
- 60 days: 45 days core + 15 days soft skills.
- Programme fee
- ₹20,000, paid once.
- Batch dates
- To be announced. Leave your contact in the form on this page and we will tell you first.
What you get
60 hours of live teaching
A one-hour hands-on analytics session every day with HireCraft360 faculty: 45 days of core business analytics and 15 days of soft skills. Nothing is pre-recorded.
Four-tool industry stack
The workflow analyst roles are tested on, in order: advanced Excel and Power Query, SQL, Power BI with DAX, and Python (Pandas, Matplotlib, Seaborn) in Google Colab.
Project report
A data-backed project report of 25 to 35 pages, structured for college submission, with an interactive Power BI dashboard and your SQL and Excel files to show in interviews.
Certificate on completion
A certificate after you complete the classes, submit the project report and clear the final evaluation. Details come with the batch announcement.
What you will learn
- Perform data wrangling and advanced analytics using Microsoft Excel and Power Query.
- Write optimised SQL queries (joins, CTEs, window functions) to extract and shape insights from a database.
- Design interactive, multi-page executive dashboards using Power BI and DAX.
- Carry out exploratory data analysis (EDA) and the basics of predictive modelling using Python.
- Deliver an industry-aligned business analytics project report of 25 to 35 pages.
Curriculum: 12 modules
Taught over 60 days (45 days core + 15 days soft skills), one live class a day. Open a module to see its topics.
Module 01 Business Problem Framing & Excel Analytics
- Structured problem solving: KPIs, North Star metrics, issue trees and root-cause analysis.
- Data cleaning: missing values, text-to-columns, TRIM, CLEAN and data validation.
- Analytical formulas: XLOOKUP, INDEX-MATCH, SUMIFS, FILTER and UNIQUE.
- Pivot tables, pivot charts and what-if analysis (Goal Seek, Scenario Manager).
Module 02 Advanced Data Modelling with Power Query
- Power Query (ETL in Excel): connecting CSVs, appending and merging queries.
- Automating data refresh and cleaning steps.
- Customer and revenue analytics: RFM segmentation and cohort retention tables.
Module 03 SQL for Business Intelligence (Fundamentals)
- Relational database architecture: star schema vs. snowflake schema.
- Core SQL querying: SELECT, WHERE, logical operators, ORDER BY.
- Aggregations and grouping: COUNT, SUM, AVG, GROUP BY and HAVING.
Module 04 Advanced SQL & Query Optimisation
- SQL joins: INNER, LEFT, RIGHT and FULL OUTER JOIN.
- Subqueries and common table expressions (CTEs) for multi-step analysis.
- Window functions: ROW_NUMBER(), RANK(), running totals and moving averages.
- Funnel analysis, month-over-month growth and user drop-off tracking.
Module 05 Power BI Desktop Setup & Data Modelling
- Data storytelling principles: chart selection, visual hierarchy and colour theory.
- Power BI Desktop: ingestion, profiling, unpivoting and schema cleaning.
- Data modelling: fact vs. dimension tables, relationships and filter direction.
Module 06 Business DAX Formulas & Time Intelligence
- Calculated columns vs. measures, and evaluation context.
- Essential DAX: CALCULATE, FILTER, ALL, RELATED, DIVIDE, SWITCH.
- Time intelligence: YTD, MTD, YoY growth, same period last year.
Module 07 Interactive Dashboard Navigation & Storytelling
- Designing executive KPI cards, tooltips and conditional formatting.
- Interactive navigation: bookmarks, the selection pane, dynamic measure toggles.
- Publishing to Power BI Service and sharing workspaces.
Module 08 Applied Statistics & Forecasting Fundamentals
- Hypothesis testing and A/B experimentation: p-values, confidence intervals.
- Correlation vs. causation and the basics of linear regression.
- Time-series forecasting: trend, seasonality, moving averages.
Module 09 Python Basics & Exploratory Data Analysis (EDA)
- Python setup (Google Colab): variables, lists, control flow.
- Data manipulation with Pandas: filtering, GroupBy, merging.
- Python visualisation (Matplotlib and Seaborn): distribution plots, heatmaps.
Module 10 LinkedIn Optimisation & Personal Branding
- Optimising profile keywords for business analyst and data analyst searches.
- Building a professional network and showcasing data projects.
Module 11 ATS Resume Building & Placement Preparation
- Crafting customised resumes using ATS-friendly AI tools.
- Mock technical interviews (SQL whiteboarding, Excel case tests).
- Placement assistance workflows and introductions to hiring partners.
Module 12 Capstone Business Analytics Project
- Dataset selection, business problem statement and report formatting.
- Data cleaning, SQL extraction, metric definition and the final dashboard.
- Deliverable: executive summary, data architecture, dashboards and roadmap.
Career support included
LinkedIn optimisation
Tune your profile keywords and showcase your data projects so that recruiters searching for business and data analysts can find you.
ATS-friendly personalised AI resume builder
Use AI-assisted tools to build a customised analyst resume structured for applicant tracking systems (ATS).
Placement assistance
Interview preparation, mock interviews (case studies, SQL queries) and, once you complete the programme, introductions to HireCraft360's hiring partners.
Assessment and deliverables
| Assessment | Weight | What it checks |
|---|---|---|
| Excel Automation & Modelling | 15% | Ability to clean data, use dynamic formulas and build RFM cohorts. |
| SQL Query Repository | 20% | Writing optimised CTEs, window functions and accurate aggregations. |
| Power BI Dashboard Presentation | 20% | Data modelling, DAX accuracy and interactive visual storytelling. |
| Python EDA Notebook | 10% | Basic scripting, Pandas data manipulation and anomaly detection. |
| Capstone Project Report & Viva | 35% | End-to-end analytical problem solving and business communication. |
In your portfolio by the end
- An automated KPI and cohort analysis Excel workbook.
- A business query repository containing 15 complex SQL solutions.
- A multi-page executive Power BI dashboard published to a portfolio link.
- An ATS-friendly resume and an optimised LinkedIn profile.
- A bound or PDF capstone business analytics project report.
Capstone project report
Every intern completes an industry-aligned business analytics project report of 25 to 35 pages, with an interactive Power BI dashboard and the SQL and Excel files behind it. It is structured for college submission, useful in an analytics portfolio, and required for certification.
Project tracks (choose one)
- E-commerce: sales performance, customer RFM segmentation and cohort retention
- EdTech or SaaS: funnel conversion, lead-to-enrolment drop-off and churn prediction
- Supply chain: inventory optimisation and a regional profitability dashboard
- Banking or FinTech: credit risk, transaction pattern and customer attrition analytics
Report structure
- Title page, internship completion certificate and acknowledgment
- Executive summary and key business recommendations
- Business problem statement, objectives and KPI framework
- Data architecture, sources and cleaning methodology (Excel, SQL, Power BI, Python)
- Exploratory data analysis, statistical findings and visual dashboards
- Business impact estimation and implementation roadmap
- Annexure (SQL query scripts, DAX measures list, dashboard screenshots and Python notebook summary)
Questions
When does the next batch start, and at what time are the classes?
Batch dates and the daily class time will be announced. Leave your contact in the form on this page and we will tell you as soon as they are fixed.
What is the fee?
The programme fee is ₹20,000, paid once by the student. How and when to pay will be shared with the batch dates. Filling in the form costs nothing and does not commit you to anything.
How are the classes held?
Live, one hour a day with HireCraft360 faculty for 60 days: 45 days of core training and 15 days of soft skills training. These are not recorded video lessons. How you join the class will be confirmed with the batch dates.
Will I get a job at the end?
We cannot promise a job, and no honest programme can. What you get is placement assistance: an ATS-friendly resume, LinkedIn optimisation, interview preparation, mock interviews and, once you complete the programme, introductions to HireCraft360's hiring partners. An offer depends on the employer and on your interview.
Will my college accept the project report?
The report follows a standard internship report structure so it can be submitted to a college. Acceptance rules differ between colleges and universities, so check the requirement with yours before you enrol.
What do I get at the end?
A certificate of completion, once you complete the classes, submit the project report and clear the final evaluation, plus the portfolio you built along the way. Who issues the certificate and what it covers will be announced with the batch.
