Subject: EPM 2273 (PMLM - T2 - G1) Advanced Data Analytics Activity: Capstone Project Business Intelligence (BI) tools are becoming increasingly important and relevant in the current market due to their ability to help businesses make informed decisions, improve efficiency, gain a competitive advantage, provide better customer service, and improve financial performance. As data continues to play a more key role in business operations, BI tools are likely to become even more critical for success. Your group can select one of the following topics for the Capstone Project or choose any other topic: 1. Healthcare Analytics: Analyze and visualize healthcare data to support clinical decision making and improve patient outcomes. Develop a dashboard that displays key performance indicators that will help support and improve clinical decision making e.g., patient satisfaction, clinical outcomes of treatments and procedures, wait times, utilization of resources. 2. Sales Analytics: Develop a sales dashboard that displays key performance indicators (KPIs) and trends for a company's sales data. The dashboard should allow decision makers to filter and analyze sales data by multiple KPI's. Example - Product, region, and time. 2. Customer Segmentation Analytics: Develop a customer analytics dashboard that provides insights into customer behavior, preferences, and purchasing patterns. The dashboard should allow decision makers to segment customers based on demographics, purchase history, and other factors. 3. Marketing Campaign Optimization Analytics: Analyze the effectiveness of various marketing campaigns and recommend strategies to optimize results. 4. Financial Analytics: Develop a financial dashboard that displays key financial metrics and trends for a company, such as revenue, expenses, and profitability. The dashboard should allow decision makers to analyze financial data and make informed decisions about financial management and planning. 5. Fraud Detection in Banking & Analytics: Detect fraudulent activities in banking transactions. 6. Supply Chain Optimization Analytics: Analyze the supply chain data of a manufacturing company and recommend strategies to improve efficiency and reduce costs. Develop a supply chain dashboard that displays key performance indicators and trends related to supply chain operations, such as inventory levels, demand forecasting, and logistics performance. The dashboard should allow decision makers to monitor supply chain performance and make informed decisions. 7. Social Media Analytics: Analyze the social media presence of a company and evaluate the impact on its reputation and brand image. 8. Human Resources Analytics: Develop a human resources dashboard that provides insights into employee data, such as turnover, headcount, and job performance. The dashboard should allow decision makers to analyze employee data and make informed decisions about staffing and workforce planning. Following sections should be included in the project report: 1. Data Collection: Collect data from various sources. Clean the data to ensure it is ready for analysis. 2. Data Modeling: Create a data model to represent the data in a meaningful way. This may include creating relationships between variables, defining calculated fields, and creating measures and Key Performance Indicators (KPIs). 3. Data Visualization: Create interactive visualizations using to help stakeholders and decision makers understand the data. This may include bar charts, pie charts, line charts, and scatter plots. 4. Analytics: Perform data analysis to support decision making. This includes your KPIs. 5. Reporting: Create reports that can be used by stakeholders and decision makers to make informed decisions. Reports should be easy to understand and comprehend. 6. Collaboration: Share the dashboards with relevant stakeholders to allow collaboration and help drive improvements. 7. Deployment: Publish the reports and dashboards to allow access from anywhere, at any time. Project report should be between 12 to 16 pages. prepare a PowerPoint (ppt) for the presentation