Unknown Story
نص القصة المصورة
- 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.
تم إنشاء أكثر من 30 مليون من القصص المصورة