Student Training Guide | 2026

Technical Data Analysis Bootcamp

A practical path for CS/CE and engineering students to clean raw data, query it with SQL, analyze it with Python/Pandas, build dashboards, and communicate technical insights clearly.

Higher Levels Designed only for students ready for deeper technical data analysis practice.
12 Days 60 hours covering foundation, extension, capstone, and portfolio defense.
Portfolio Students produce code-backed analysis, dashboard, and a short technical report.
Real Tools SQL, Python/Pandas, spreadsheets, Power BI or Looker Studio.

Training duration: 12 days, 60 hours total.

This page is for Higher Levels only. Students complete the full technical data analysis path: foundation, advanced SQL, deeper Python/Pandas, dashboard iteration, reporting, and capstone defense.

Program Overview

This bootcamp is designed for CS/CE and engineering students who want practical data analysis skills. Students learn how to clean, validate, query, transform, analyze, visualize, and explain data in a way that supports technical, academic, business, operational, and engineering decisions.

Best for

Technical students and future analysts

Suitable for CS/CE, engineering, software, data, research, operations, and decision-support contexts.

Format

Hands-on technical labs

Students practice cleaning, querying, coding, analyzing, visualizing, and presenting data during the training.

Main outcome

Code, dashboard, and report

Students finish with portfolio-ready analysis work they can present in academic, technical, or professional settings.

Ain Shams University students after a Coach Academy training session
Real training environment

Built for students who need to show real analytical work.

The bootcamp focuses on practical outputs: clean data, clear calculations, useful dashboards, short reports, and confident presentation of findings.

Program Format

The program is one full Higher Levels path. It starts with a strong technical foundation, then continues into deeper technical practice and portfolio-ready capstone work.

12
Days

Higher Levels Full Track

Students complete 12 training days with a total of 60 hours.

Training focus

Data foundations, advanced spreadsheets, SQL, Python/Pandas, dashboard iteration, analytical reporting, and capstone defense.

60
Hours

Technical Portfolio Outcome

The training is built around practical outputs students can present and defend.

Training focus

Clean dataset, SQL query set, Pandas workflow, dashboard, analytical report, final presentation, and organized portfolio package.

Training Modules

The full Higher Levels program runs as one connected 12-day path, moving from data quality and analysis tools into deeper SQL, Python/Pandas, dashboard iteration, reporting, and capstone defense.

Higher Levels Full Path | 12 Days / 60 Hours
Day
1

Data Foundations & Data Quality

Students learn data types, table structure, column naming, clean rows, missing values, duplicates, validation logic, and quality checks.

Practical output

A clean and well-structured dataset that is ready for analysis, with documented cleaning decisions.

Day
2

Excel / Google Sheets Analysis

Students use formulas, pivot tables, charts, validation rules, lookup functions, conditional formatting, and reporting templates.

Practical output

A spreadsheet analysis workbook with summaries, calculations, charts, and a simple decision-oriented report.

Day
3

SQL Querying & Data Extraction

Students practice filtering, sorting, joins, grouping, aggregation, subqueries, and translating technical questions into SQL queries.

Practical output

A SQL query set that extracts, summarizes, and explains useful information from a database-style dataset.

Day
4

Python / Pandas for Analysis

Students learn how to clean, transform, inspect, group, merge, and explore data using reproducible notebooks or scripts.

Practical output

A notebook or script that cleans and analyzes a dataset with reusable steps, readable comments, and repeatable outputs.

Day
5

Power BI / Looker Studio Dashboards

Students design KPIs, choose charts, build visual pages, create useful filters, and turn technical analysis into a dashboard story.

Practical output

An interactive or presentation-ready dashboard with KPIs, charts, and views that support decisions.

Day
6

Insight Communication & Final Presentation

Students explain findings, limitations, trends, recommendations, data quality issues, assumptions, and next steps in a clear format.

Practical output

A short analytical report and final presentation that defend the dashboard, insights, and decisions.

Day
7

Advanced Data Cleaning & Validation

Students revisit messy data with deeper cleaning rules, error detection, validation logic, and documentation habits.

Practical output

A stronger cleaned dataset with a data dictionary, cleaning log, quality checks, and known limitations.

Day
8

Advanced SQL for Analysis

Students go deeper into joins, grouped analysis, subqueries, case logic, window-style thinking, and business question translation.

Practical output

An expanded SQL query set that answers more complex questions and supports dashboard-ready tables.

Day
9

Python / Pandas Project Workflow

Students build a more complete notebook workflow for importing, cleaning, transforming, grouping, merging, and exporting data.

Practical output

A reusable analysis notebook with organized steps, comments, charts or summaries, and exported clean outputs.

Day
10

Dashboard Iteration & KPI Storytelling

Students improve dashboard layout, KPI hierarchy, chart choice, filters, visual clarity, and story flow for decision makers.

Practical output

An improved dashboard version with clearer KPIs, better visual structure, and explanation notes.

Day
11

Analytical Report Writing & Recommendations

Students learn how to write findings, trends, limitations, assumptions, recommendations, and next steps clearly.

Practical output

A polished analytical report that connects the dataset, analysis, dashboard, and recommendations.

Day
12

Capstone Defense & Portfolio Packaging

Students present their full project, defend dashboard decisions, explain limitations, and package the final portfolio.

Practical output

A portfolio-ready capstone package with clean data, analysis, SQL, notebook, dashboard, report, and final presentation.

What Students Will Build

Students finish with one complete technical analysis portfolio that moves from raw data to cleaned data, queries, code-backed analysis, dashboard storytelling, report writing, and capstone defense.

Core analysis outputs

  • Clean dataset prepared from messy or raw data with documented cleaning decisions.
  • Analysis workbook or Python/Pandas notebook with transformations, summaries, and calculations.
  • SQL query set with filtering, joins, grouping, aggregation, and practical question answering.
  • Dashboard with KPIs, visual views, filters, and useful charts.
  • Short technical analytical report explaining findings, limitations, assumptions, and recommendations.

Advanced portfolio outputs

  • Data dictionary, cleaning log, and deeper data quality documentation.
  • Expanded SQL query set for more complex analytical questions.
  • Reusable Pandas notebook with a cleaner end-to-end technical workflow.
  • Improved dashboard with stronger KPI storytelling and clearer design.
  • Polished analytical report, final presentation, and capstone defense.

Tools Used During Training

The exact tool choice can be adjusted based on the university setup and student devices.

Spreadsheets

Excel or Google Sheets

Used for cleaning, formulas, pivot tables, charts, validation, and quick reporting.

Querying

SQL tools

Used for extracting, joining, grouping, and summarizing structured data.

Programming

Python with Pandas

Used for reproducible cleaning, transformation, exploratory analysis, and code-backed workflows.

Dashboards

Power BI or Looker Studio

Used for visual reporting, KPI design, filters, and presentation-ready dashboards.

Materials

Google Classroom & Drive

Used for tasks, materials, submissions, shared files, and project packaging.

Portfolio

Reports & presentations

Used to package insights clearly and present the final analytical work.

Assessment & Recognition

Assessment focuses on practical application, dashboard quality, insight clarity, and presentation.

Practice

Mini Assignments

Measure understanding of each tool, cleaning method, query pattern, or analysis concept.

Labs

Lab Participation

Measures whether students can apply concepts during guided practice and hands-on work.

Dashboard

Dashboard Quality

Reviews clarity, correctness, KPI design, chart choice, visual hierarchy, and usefulness.

Report

Final Report

Measures whether students can explain findings, limitations, recommendations, and decisions clearly.

Presentation

Final Presentation

Assesses the student’s ability to explain the analysis process and defend dashboard choices.

Portfolio

Portfolio Readiness

Checks whether the final outputs are organized, understandable, and reusable for future opportunities.

FAQ

Quick answers for students before joining the technical data analysis training.

Who should join this bootcamp?

CS/CE, engineering, and technical students who want practical experience with SQL, Python/Pandas, data cleaning, dashboards, and analytical reporting.

How is the duration divided?

The program is for Higher Levels only and runs as one full 12-day path with 60 total training hours.

What will students submit at the end?

Students submit a clean dataset, analysis workbook or notebook, SQL query set, dashboard, short technical report, and final presentation.

Is this only dashboard training?

No. Dashboards are one output. The training also covers cleaning logic, SQL querying, Python/Pandas workflows, data validation, reporting, and insight communication.

Prepared for students | Coach Academy Data Analysis Bootcamp Guide | June 2026
Scroll to Top