- An email and phone call from one of our representatives.
- A time & cost estimation.
- A follow up conversation for your feedback and questions.
Customer is a leading Housing and Urban Infrastructure Solutions company who desire to be a company that leaves its footprint of excellence as evidence of our positive impact in communities. They continue to set the stage for better performance in the areas of urban revitalization, infill development, smart growth, and public private partnerships.
Customer wanted to create allocations of payroll data provided by the payroll providers for around hundreds of employees based on different pay codes. They receive the raw data from the payroll providers, and they need to perform several steps correctly do the allocations. The allocated payroll is the final entity for them for creating journal entries. Customer would like to do payroll analysis after the successful allocations. Their current system operates only on current period which has thousands of rows of data, but now they also want to store the historical allocated payroll data in some kind of archive table and then perform the next load for current period. The consolidation of historical and current payroll allocations would then allow for customer to derive better analytics and forecasting.
After a few initial analysis and design discussions with the customer on their exact requirements, our team suggested few options like: Microsoft Fabric, Dataverse, SQL Server, etc. keeping in mind their current technology infrastructure. At the end, VNB Consulting team and the customer decided to go with Microsoft Fabric because this solution was the closest and most efficient one to meet all their expectations. Microsoft Fabric allows for the storage and utilization of data in a standardized format, eliminating unnecessary replication and enabling seamless integration with various Microsoft tools. Our BI team came up with the solution in Microsoft Fabric by making use of the data warehouse, Dataflow Gen2 and data pipeline components. Here, Dataflow Gen2 will be utilizing its Power Query functionality to get the raw data from their payroll providers and then do the correct allocations of payroll data. After the successful allocations of payroll data, the data warehouse workload of Microsoft Fabric will be used to archive the allocated data before the execution for current period. Data pipeline is used to automate the process of creation of allocations for payroll data and archive the data in data warehouse. The data in data warehouse is consumed by the Customer for their reporting and journal entry needs. Our BI team also made sure to document all the technical details to list all the technicalities and general aspects of our solution for any future references.
VNB Consulting collaborated with a leading health insurance provider to transform EDI 834 benefit enrollment processes.VIEW DETAILS
VNB Consulting helped a Utilities company migrate from OBIEE to Power BI, resulting in significant cost savings while also improving their analytics capabilities.VIEW DETAILS