{"type":"video","version":"1.0","html":"<iframe src=\"https://www.loom.com/embed/0a3d11811a404432a8e9f435416cef5e\" frameborder=\"0\" width=\"1920\" height=\"1440\" webkitallowfullscreen mozallowfullscreen allowfullscreen></iframe>","height":1440,"width":1920,"provider_name":"Loom","provider_url":"https://www.loom.com","thumbnail_height":1440,"thumbnail_width":1920,"thumbnail_url":"https://cdn.loom.com/sessions/thumbnails/0a3d11811a404432a8e9f435416cef5e-39e1399a9a59759a.gif","duration":326.294,"title":"Comparing Customer Invoice Data Across Systems 📊","description":"In this video, I compare two systems we use: SAP for customer master and invoice data, and our e-commerce platform, which has over 34,000 records. I walk through the process of extracting unique invoices from these systems, highlighting the challenges I faced with large data sets, including an error due to too many rows. I also explain how I summarize invoice data to compare sums between the two systems. I encourage viewers to download the two files for a better understanding of the data involved. Please take a moment to familiarize yourself with the unique customers and invoices as we move forward with this analysis."}