Business Intelligence

Business Intelligence (Advanced Excel & Power BI)

Duration: 30 Hours | 12 Classes | 2.5 Hours Each
Course Fee: 3000/- BDT (Discounted: 2500/- BDT)

📘 Course Overview

Master the power of Microsoft Excel and Power BI to transform raw data into impactful dashboards, reports, and business insights.
This hands-on course takes you through every stage of the Business Intelligence process — from data cleaning and advanced formulas to interactive visualizations, automation, and a real-world capstone project.

By the end of this program, you’ll confidently be able to:
✅ Design and automate professional dashboards
✅ Perform predictive and scenario-based analysis
✅ Handle large datasets efficiently
✅ Make data-driven business decisions

Perfect for students, professionals, and analysts who want to upskill in modern data analytics tools.

📚 Course Curriculum

12 Classes | 2 per Week (6 Weeks Total)

Week 1: Introduction to Excel & Power BI

• Interface, setup, and basic data entry

Week 2: Data Management & Import

• Handling Excel/CSV/Web data efficiently

Week 3: Advanced Excel Formulas

• Logical, Text, and Lookup functions

Week 4: Power Query

• Data cleaning, merging, and transformation

Week 5: Data Modeling

• Power Pivot basics and relationship building

Week 6: DAX Fundamentals

• Key formulas and calculated metrics

Week 7: Visualization Basics

• Pivot tables, charts, and KPIs

Week 8: Advanced Visualizations

• Treemaps, Funnels, Custom visuals

Week 9: Dashboard Design

• Interactive dashboards using slicers, bookmarks, and drill-downs

Week 10: Automation & Scripting

• Macros, VBA, and Power Automate integration

Week 11: Forecasting & Predictive Analysis

• What-If, Goal Seek, and Time Intelligence in DAX

Week 12: Final Capstone Project

• Real-life business case integrating Excel & Power BI

💡 Tip for Website:
Display these weeks as collapsible accordion sections so visitors can click each week to expand details.

🎯 Why Choose This Course?

• Learn both Excel & Power BI in one complete BI program

• Gain real-world, job-ready analytics skills

• Build interactive dashboards and automation workflows

• Apply learning through hands-on, practical projects

• Mentorship from an experienced industry professional

👨‍🏫 Trainer

Diganta Das Dipta
Associate Manager, Data Analytics & Engineering – BRAC Bank PLC
Former Data Scientist – BJIT Group