Business Intelligence (Advanced Excel & Power BI)
30 Hours | 12 Classes | 3000/- (Discounted: 2500/- )
Course Overview
Master the power of Excel and Power BI to turn raw data into meaningful dashboards, reports, and insights. This hands-on course takes you from data cleaning and advanced formulas to visualization, automation, and real-life business case projects.
By the end of the program, you’ll confidently design interactive dashboards, automate tasks, and perform advanced analytics—skills that are in high demand across industries.
Course Curriculum
12 Weeks – 2.5 hours per class
-
Week 1: Introduction to Excel & Power BI
-
Week 2: Data Management & Import (Excel, CSV, Web)
-
Week 3: Advanced Excel Formulas (Logical, Text, Lookup)
-
Week 4: Power Query (Data Cleaning & Transformation)
-
Week 5: Data Modeling (Power Pivot & Relationships)
-
Week 6: DAX Fundamentals (Formulas & Metrics)
-
Week 7: Visualization Basics (Pivot Tables & KPIs)
-
Week 8: Advanced Visualizations (Treemaps, Funnels, Custom Charts)
-
Week 9: Dashboard Design (Interactive Dashboards)
-
Week 10: Automation (Macros, VBA, Power Automate)
-
Week 11: Forecasting & Predictive Analysis
-
Week 12: Final Capstone Project (Real-Life Business Case)
Best for website: Show these as accordion sections so visitors can click and expand for details.
Why Choose This Course?
-
Learn both Excel & Power BI in one integrated program.
-
Build interactive dashboards and business reports.
-
Automate repetitive tasks with Macros & Power Automate.
-
Apply real-world business cases with hands-on practice.
-
Gain job-ready Business Intelligence skills trusted across industries.
Course Fees
📌 3000/- (Discounted: 2500/-)
Trainer
👨🏫 Diganta Das Dipta
Associate Manager, Data Analytics & Engineering – BRAC Bank PLC
Former Data Scientist – BJIT Group
