Training Trains logo

Business Intelligence Internship

Build dashboards that managers actually use: Excel, SQL, Power BI, DAX, data modelling and data storytelling on business datasets.

ExcelSQLPower BIDAXTableau Public

What you'll work on

Full syllabus: all 60 graded tasks

These are the actual tasks the internship portal assigns for this domain. You submit each one with proof (a GitHub link or document) and a mentor reviews it.

Level 1: Foundations (24 tasks)
  1. What BI is. Explain business intelligence, the difference between BI and data science, and three decisions BI helps a business make.
  2. Excel essentials. Clean a messy sales sheet in Excel: remove duplicates, fix dates, split columns and use XLOOKUP. Share the before and after.
  3. Pivot tables. Build pivot tables showing sales by region, month and product, with a pivot chart for each.
  4. KPIs and metrics. Define 10 KPIs for a retail shop with formulas and explain which ones a manager would check daily.
  5. SQL for analysts. Write 12 SQL queries on a sample sales database: filters, joins, GROUP BY, HAVING and date functions.
  6. Install Power BI Desktop. Load a CSV into Power BI, explore Power Query and build your first bar and line chart.
  7. Power Query cleaning. Use Power Query to clean a dataset (types, nulls, splits, merges) and document each applied step.
  8. Data modelling basics. Explain fact and dimension tables and build a star schema for sales data in Power BI.
  9. Chart choice. For 8 business questions, pick the right chart type and explain why (and which charts to avoid).
  10. Your first dashboard. Build a one-page sales dashboard with KPI cards, a trend, a breakdown and slicers.
  11. Storytelling with data. Write a one-page summary of your dashboard: what happened, why, and what to do next.
  12. Tableau Public basics. Recreate your dashboard in Tableau Public and publish it, adding the link to your README.
  13. Number formatting. Format currency in Indian lakhs and crores, percentages and dates correctly in Excel and Power BI.
  14. Conditional formatting. Use conditional formatting to highlight targets met and missed.
  15. Excel charts. Build combo, waterfall and sparkline charts and explain when each helps.
  16. Lookup practice. Solve 10 lookup problems with XLOOKUP, INDEX/MATCH and FILTER.
  17. Data types in BI. Fix wrong data types (text numbers, dates as text) in a dataset and explain the impact.
  18. Metric definitions. Write precise definitions for revenue, active customer and churn so nobody misreads them.
  19. Google Sheets / Looker Studio. Build a small dashboard in Looker Studio from a Google Sheet.
  20. Slicers and filters. Add slicers for date, region and product and sync them across pages.
  21. Tooltips. Add custom report page tooltips that show details on hover.
  22. Colour and accessibility. Make a report colour-blind friendly and check contrast.
  23. Mobile layout. Create a phone layout for your Power BI report.
  24. Public dataset analysis. Pick an Indian public dataset (data.gov.in) and answer five questions with charts.
Level 2: Building real features (20 tasks)
  1. DAX measures. Write 10 DAX measures: totals, averages, YoY growth, running total, % of total and a CALCULATE filter.
  2. Time intelligence. Add a date table and build month-to-date, year-to-date and same-period-last-year comparisons.
  3. Relationships and filters. Model three related tables, set cardinality and cross-filter direction, and explain a filtering bug you fixed.
  4. Drill-down and drill-through. Add a drill-down hierarchy and a drill-through detail page to your report.
  5. Dashboard design review. Redesign your dashboard for clarity: alignment, colours, labels and fewer charts. Show before and after.
  6. Advanced SQL. Use window functions (RANK, LAG, running SUM) and CTEs to answer 5 business questions.
  7. Customer segmentation. Segment customers by RFM (recency, frequency, monetary) in SQL or Power BI and describe each segment.
  8. Row-level security. Set up row-level security so each regional manager sees only their region.
  9. Data quality checks. Build a data quality page that flags missing values, duplicates and outliers.
  10. Requirements gathering. Interview a friend acting as a manager, write BI requirements and turn them into a report wireframe.
  11. Calculation groups. Use calculation groups (Tabular Editor) or field parameters to switch measures in one visual.
  12. What-if parameters. Add a what-if parameter to model a price increase and its effect on revenue.
  13. Bookmarks and navigation. Build a guided report with bookmarks, buttons and a navigation menu.
  14. Incremental refresh. Configure incremental refresh for a large fact table and explain the benefit.
  15. Composite models. Combine imported and DirectQuery tables in one model and explain the trade-offs.
  16. Python or R visual. Add a Python or R visual for a chart Power BI cannot make natively.
  17. Key influencers. Use the key influencers or decomposition tree visual to explain a metric.
  18. Paginated report. Create a printable invoice-style paginated report (Report Builder or a free alternative).
  19. Data validation report. Reconcile dashboard totals with the source system and document any differences.
  20. Stakeholder feedback loop. Show your dashboard to two users, collect feedback and release version 2.
Level 3: Professional work and capstone (16 tasks)
  1. Data warehouse design. Design a small warehouse with staging, fact and dimension tables, and load it with SQL scripts.
  2. ETL pipeline. Automate a daily load from CSV or an API into your warehouse with Python or a tool like Airbyte.
  3. Forecasting. Add a sales forecast with Power BI's forecasting or Python, and explain how reliable it is.
  4. Performance tuning. Use Performance Analyzer to find slow visuals and DAX, then speed them up and record the gain.
  5. Publish and schedule refresh. Publish a report to Power BI Service (or Tableau Public) and set up a scheduled refresh where possible.
  6. Executive dashboard. Build a one-page executive dashboard with only the 5 numbers that matter and the story behind them.
  7. Insight report. Analyse a public dataset end to end and write a 2-page insight report with recommendations.
  8. Capstone: BI solution. Deliver a complete BI solution for a business case: requirements, model, ETL, dashboard, security and a recorded walkthrough.
  9. Semantic model best practices. Review your model against best practice rules and fix naming, hidden columns and relationships.
  10. Anomaly detection. Add anomaly detection to a time series and explain one detected anomaly.
  11. Dashboard governance. Write a plan for certified datasets, ownership, refresh schedules and access requests.
  12. Self-service BI. Build a dataset that business users can explore themselves and write a short guide.
  13. Embedded analytics. Embed a report in a web page (publish to web for public data or a secure method) and explain the security choice.
  14. Cost of BI. Compare licence costs of Power BI, Tableau and Looker Studio for a 50-person company.
  15. Executive presentation. Present insights from your dashboard to a mock leadership team in 5 minutes.
  16. Capstone 2: BI for a real business. Deliver a BI solution for a real small business or a Training Trains/W3/DH process (with permission), including requirements, model, dashboard and handover guide.

Real software work, not just training

Every Business Intelligence task is reviewed by our team and saved to your portfolio. Interns who pass the readiness check can take real work from Training Trains, W3AppDevelopers and DomainHostly projects on the Company Work board.

Data Science Solutions
See the software we build →

Frequently asked questions

Do I need experience to join the Business Intelligence internship?+

Basic Excel is enough to start. Power BI Desktop is free on Windows.

What will I do in the Business Intelligence internship?+

You complete 60 graded tasks in three levels: foundations, real features, and professional work. Each task is submitted with GitHub or document proof and reviewed. The final capstone is: Capstone 2: BI for a real business.

Do I get a certificate for the Business Intelligence internship?+

Yes. After your required tasks are approved, your attendance is above 75% and you pass the proctored final exam, you get a graded completion certificate that anyone can verify at trainingtrains.com/verify.

Can I do the Business Intelligence internship online?+

Yes. You can do it fully online from home, or offline at our Erode and Perundurai branches. Tasks, quizzes and mentor reviews are the same in both modes.

Available both online (work from home) and offline at our Erode and Perundurai branches - see the full internship program details for departments, duration, and the application process.

Apply for the Business Intelligence internship