Data Warehousing – Use Cases (Under Delivery)
Client (confidential)
An early wage access platform (YC’21) that allows salaried employees to draw a percentage of their accrued salary before the next payroll cycle. Helping employees avoid late payment fees on bills, access emergency cash and substitute expensive debt.
Problem Statement: Un-optimal strategic information-delivery
With time, as more businesses and customers were signing on, ABHI’s master and transactional data generated through its Customers (employer network and employees) was increasing at a pace faster than their BI and data teams could handle. With data dimensions and sources increasing, business users had to pass data through various sets of hands and systems to be useful for decision-making.
Solution
We are implementing a solution utilizing the available technology stack. Our services include creating a DWH that should support business reporting and dashboarding needs for ABHI and creating cloud-based database integrations able to ingest data from transactional data stores and applications to be used for analytics and comprehension.
Tech Stack Used: AWS, Snowflake, and Power BI