Unknown Story
Storyboard Text
- Audit team discussing the ongoing Rebel Foods procurement audit.
- Challenge : Audit Team is facing issue while structuring the data, as in one of the columns data has been cumulated in one single row separated by commas.
- Team Lead
- We should connect with the Central Analytics Team. They can help us in dealing with this data format.
- Hey! Have we received the data for Rebel Foods audit from the client?
- Yes, we have received the data, However the data is in semi-structured format. We are not able to structure it. It will take a lot of time to achieve the same and only after that we will be able to get the correct analytics results.
- Team Member
- Audit Team member Calls the Central Analytics Team and explains the issue they’re facing regarding the formatting.
- Challenges : Central Analytics Team has structured the data as per requirement but after that number of line items increased to a huge size, due to which it would take a lot of time for them to do analytics on excel.
- We can help you with this. Share with us the data through OneDrive, we will upload it in our SQL database and structure it as per your requirement.
- Okay Sure!
- Okay let me ask my team to provide the data access to you. Once you upload data to the database, please Share the data with us after structuring it.
- Both the teams discussed the requirement.
- Audit team discusses the requirement with analytics team. The analysis involved complex operations which could be done easily using SQL functions as compared with Excel
- Hey, we would need your assistance in performing custom analytics since the data size is too large to perform it on Excel
- Sure, we can do the analysis for you. Let us discuss the analysis you want us to perform on it and we can do it through SQL.
Over 30 Million Storyboards Created