Business Management & Analytics Foundation Module

Overview of business management principles | Role of business management in consulting | Understanding the consulting mindset | Introduction to Balanced Scorecard and its relevance | Group discussion: Case study analysis involving Balanced Scorecard | Strategy formulation and execution | SWOT analysis and PESTEL analysis | Introduction to Blue Ocean Strategy | Review of real-world consulting case studies, including Blue Ocean Strategy examples | Types of organizational structures | Introduction to the Porter Five Forces model | Hands-on exercise: Develop a strategic plan incorporating Blue Ocean Strategy | Project initiation, planning, execution, and closure | Gantt charts, critical path analysis, and resource allocation | Discussion of BCG Matrix and its application in project portfolio management | Project Management Case Study | Introduction to Business Process Reengineering (BPR) | Identifying processes for reengineering | BPR methodologies and tools | Introduction to Six Sigma and its importance in process improvement | Real-world examples of Six Sigma success stories | Introduction to Marketing Management principles | Understanding customer segmentation and targeting | Introduction to 4 Ps - Product, Price, Place, and Promotion | Marketing Mix Case Study | Basic Excel functions and formulas | Data cleaning and preparation | Creating charts and graphs | Practical exercises using Excel | Advanced Excel functions (VLOOKUP, PivotTables, etc.) | Data analysis techniques | Case study: Analyzing business data | Q&A and problem-solving session | Overview of Power BI and its components | Connecting to data sources in Power BI | Data modeling in Power BI | Using calculated columns and measures | Creating advanced visualizations (e.g., slicers, drill-through) | Class Assignment: Hands-on exercise - Building a Power BI report