Enterprise Data Analytics Dashboard

### Project Overview We designed and built an **Enterprise Data Analytics Dashboard** for a large retail conglomerate. The platform serves as the "brain" of the organization, providing C-level executives with real-time insights into sales, supply chain, and marketing performance. ### Problem Statement The company was "data-rich but insight-poor." Data was trapped in disparate silos—Excel sheets, legacy SQL databases, and various SaaS tools. Executives waited weeks for monthly reports that were outdated by the time they arrived. ### Solution Provided NacroSoft implemented a centralized Data Lakehouse architecture. We built ETL pipelines to ingest data from all sources into a unified warehouse. On top of this, we created a stunning, interactive dashboard that allows non-technical users to drill down into data and generate reports on the fly. ### Technologies Used * **Frontend:** React.js, D3.js (for custom visualizations) * **Backend:** Python, Flask * **Data Warehouse:** Snowflake * **ETL:** Apache Airflow * **Cloud:** Microsoft Azure ### Key Features * **Unified Data View:** Integrates data from SAP, Salesforce, Google Analytics, and more. * **Predictive Analytics:** Forecasts sales trends and inventory needs using ML models. * **Customizable Widgets:** Users can drag-and-drop charts to create personal dashboards. * **Automated Reporting:** Schedules and emails PDF reports to stakeholders. * **Role-Based Access Control:** Ensures data security and privacy across departments. ### Business Impact * **Reduced reporting time from 2 weeks to 5 seconds.** * **Identified $2M in supply chain inefficiencies** in the first month. * **Empowered decision-makers** with real-time, trustworthy data. ### Team Size 14 Members ### Role Breakdown * **Data Engineer (Lead):** Designed the data pipeline and Snowflake architecture. * **Frontend Developer:** Created complex, interactive D3.js visualizations. * **Backend Developer:** Built the API layer to serve aggregated data. * **Data Scientist:** Developed the forecasting models. * **UI/UX Designer:** Focused on data visualization best practices for clarity. * **Project Manager:** Managed stakeholder requirements across different business units.