Kito Crosby

A milestone achieved for TNZ for successful completion of a comprehensive data analytics project for Crosby Group, a leading material handling industry with premier shackle, hook and block products for rigging and lifting company. This 10 – months project involved the design and implementation of a complete data solution, encompassing raw data storage, data transformation, and advanced analytics capabilities.

Problems

Technologies

Solutions We Provided

Azure Data Lake Storage: Served as the central repository for ingesting large volumes of data from various sources, including SAP S4 and Oracle JDE (US) and SAP ECC (Europe).

Medallion Architecture: Leveraged a multi-tiered architecture for data ingestion, transformation, and curation. The Bronze layer served as the landing zone for raw data, the Silver layer facilitated data cleansing and transformation, and the Gold layer housed the refined data ready for analysis.

Azure Synapse Analytics: Provided a scalable data warehouse platform for storing and managing the transformed data.

Power BI Integration: Enabled the creation of interactive dashboards and reports for data visualization and exploration.