Customer Size: Large Organization
Solution: SQL Server and MSBI (SSIS, SSRS, SSAS)
A US based software company provide solutions for the retail industry to monetize their POS data. They kicked off their business with data warehouse consultancy services for their retail clients and then moved towards advanced data analytics solution for different domains of Retail industry such as Beauty/Cosmetic, Consumer Packaged Goods (CPG), DIY-Home-Hardware, Apparels/Fashion etc.
While providing data warehousing services, clinet realized that end client is looking for an analytical solution that can accumulate and process the data from their data warehouses, that’s how the idea of Business Intelligence based solution came in to the picture, the solution was targeted to fetch and provide insight reports to drive revenue from their target audience and existing business, Client was crystal clear with the vision but he lagged with the exposure of Business Intelligence expertise to initiate the project so he was looking for a technology partner who carry a significant knowledge and exposure in product development for retailers with Business Intelligence skill set.
Keeping the above scenario in mind, client norrowed down his serach on us and shared his expectation (listed below) for required business intelligence and data management services.
- Facilitating batch processing of data,
- Gathering data from multiple source and in multiple formats used by respective domains,
- Interpreting and automating the sales reports needed from different domains.
We programmed a comprehensive cloud based SAAS system based on Microsoft SQL server capabilities and Microsoft Business Intelligence (MSBI) tools, along with rich web and mobile based analytics solution to collect and analyze EDI 852, POS, & supply chain data.
Data architecture that enabled user to respond faster, optimize assortments increase revenue and offer best practices in retail merchandising.
Automated data collection process from EDI 852 and other retails POS,
Post data collection system cleansed and validated data to generate multiple Business Intelligence report
Warehouse created so business can store customized data on cloud
User specific tailored dashboard created to provide one click access to data with graphical data visualization,
Single click sorting and filtering of data to provide quick and easy data analytics,
The solution also facilitated their end client to export, share notes send detailed reports to their sales representative and buyers.