Data and analytics
Data Engineer with Python & Machine Learning
- Schedule
- Every Saturday (3:00 PM to 5:30 PM)
- Length
- 24 class, 06 Months
- Course fee
- Tk 16,000
- Paid at once
- Tk 14,000
Admission closed
Course details
Data and analytics
Closes in 3 days
Data Analytics with Industrial AI Practices (Python, SQL, Excel, Power BI & Tableau)
A 12-class, 36-hour course that takes students from spreadsheet basics to AI-assisted analytics across five tools, ending in a group capstone shown at the CDIP project show. It replaces the previous 16-week outline: the same core tools, compressed into one basic and one advanced class per tool, with Tableau and AI practice added.
• Format: 12 classes, every Friday, 9:00 AM - 12:00 PM (3 hours each), from 20 November 2026, in Windows computer labs
• Modules: Excel (2), Python (3), SQL (2), Power BI (3), Tableau (2)
• AI in every module: each class ends by re-solving the lab with an AI assistant and checking its answer
• Capstone: groups of 3 - 5 students (20–25 students, so 5 - 7 groups), formed in Class 2, mentored from Class 4, presented at the CDIP project show
• Running case: one retail sales dataset follows students through every tool, plus one industrial (manufacturing) dataset per module, so each tool is compared on the same problem
Learning outcomes
By the end of the course, students can:
1. Clean, analyse and report on data in Excel with formulas, PivotTables and dynamic arrays.
2. Use Python (pandas, seaborn, scikit-learn) for cleaning, EDA, automation and a first predictive model.
3. Write SQL queries with joins, CTEs and window functions to answer business questions.
4. Model data in a star schema and build interactive Power BI reports with DAX.
5. Build and publish Tableau dashboards and data stories with LOD expressions and parameters.
6. Use AI assistants to write, debug and explain formulas, queries and code, and verify every AI answer before using it.
7. Deliver an end-to-end industrial analytics project as a team and present it to an audience.
Who this course is for
- Senior students preparing for a Data Analyst career.
- Graduates seeking to enter the field of Data Analytics and Data Visualization.
- Working professionals looking to enhance their analytical skills and advance their careers.
- Entrepreneurs interested in leveraging data analytics to make informed business decisions.
After the course you can
- Understand modern data ecosystems and enterprise data architecture.
- Acquire, clean, transform, and analyze structured datasets.
- Write complex SQL queries for business reporting and analytical problem-solving.
- Perform data extraction, transformation, aggregation, and optimization.
- Build automated analytical models and dynamic reports using advanced Excel functions and Pivot Tables.
- Utilize Python and Pandas for data cleaning, transformation, exploratory analysis, and workflow automation.
- Design data models and develop interactive dashboards using Power BI and DAX.
- Apply data storytelling techniques to communicate insights and recommendations effectively.
- Complete a real-world analytics project demonstrating end-to-end analytical competency.
- Develop a professional portfolio, optimized LinkedIn profile, and interview readiness for Data Analyst roles.
How the course works
- Trainer: Experienced and Expert Industry Professionals.
- Hands-on Training: Hands-on training with Industry-Oriented projects.
- Certification: Certification from UIU upon completion.
- Grooming: CV Development & Interview Simulation.
- Career Support: Career counseling and job placement assistance.
- Flexible Schedule: Weekly one class (Friday).
Course outline
1Week 1: Excel Fundamentals
2Week 2: Excel Advanced
3Week 3: Python Basic
4Week 4: Python Intermediate
5Week 5: Python Advanced
6Week 6: SQL Fundamentals
7Week 7: SQL Advanced
8Week 8: Power BI Fundamentals
9Week 9: Power BI Intermediate
10Week 10: Power BI Advanced
11Week 11: Tableau Fundamentals
12Week 12: Tableau Advanced
13Week 13: CDIP Project Show
Goal: Final project submission and showcasing.
Taught by
Md. Azimuddin Khan
Experience: 18+ years
Senior Leader | Driving AI-Native Transformation & Analytics Excellence | 20 years Across Telecom, Aviation & Manufacturing.
