1 Introduction to Business Intelligence and Data Analytics (Week 1-2)

·      Overview of BI and Data Analytics.

·      Role of Excel, Power BI, and Tableau.

·      Data analytics process in Excel.

2 Data Collection and Cleaning in Excel

·      Data import and transformation in Excel.

·      Data cleaning and preparation in Excel.

3 Data Analysis in Excel

·      Advanced functions and tools for data analysis in Excel.

·      PivotTables and PivotCharts in Excel.

4 Data Visualization with Power BI

·      Introduction to Power BI.

·      Data modeling and visualization in Power BI.

5 Advanced Power BI Techniques

·      DAX (Data Analysis Expressions) for advanced calculations.

·      Creating interactive reports and dashboards in Power BI.

6 Data Visualization with Tableau

·      Introduction to Tableau.

·      Building interactive visualizations in Tableau.

7 Tableau Advanced Features

·      Calculations and advanced mapping in Tableau.

·      Dashboard design and storytelling in Tableau.

8 Final Data Analytics Project

·      Applying Excel, Power BI, and Tableau to a real-world business problem.