This is Data Warehouse project for a US based big Health and Fitness club. The project provides a single view of data for business insights and analytics for the business stakeholders. This is done by improving data quality, removing duplicates working across multiple sources of data coming through multiple channels..
The solution was created using Power BI as front end and Azure stack as backend. TeamCity is used for CICD.
The created report provides the customer with different dashboards with multiple filters using which the customer can filter out data on the dashboard as per their requirements. The dashboard also provides the count for the unique records in the system and the records that have been deduped.
- Real time reporting at various levels.
- BI Insights to track member journey, events and effect on business.
- Predictive models for member behavior..