Default
Services for success
We set our sights on helping your team transform your data into insights Architecture Integration Profiling Insights Analytics
Approach
At Sterling Data Consulting, our approach is different. Through the use of our accelerators and years of experience, our consultants are able to quickly and consistently deliver quality results.
Projects
The following lists highlights some of the projects we have experience solving.
-
ADF, Azure Databricks, Medallion architecture. We helped a grocery distributor analyze store/item level profitability to provide guidance to their members. ADF consumed DB2 and flat file data to generate parquet files. Databricks was responsible for loading parquet to Unity Catalog. Power BI used to deliver reports.
-
Managed Service Provider. For a client in the transportation industry, we do it all. From user provisioning, architecture and implementation, vendor management, etc
-
Real-time messaging. For a logistics provider, created a real-time messaging solution that allowed their Mainframe database management system to be synchronized with SQL Server using Service Broker. We had subsecond processing times for millions of rows of data of varying size and recurrence.
-
Data rearchitecture. For an entertainment client, we turned around a failing data warehouse project. We fixed the data model to support the business needs. We implemented best practices to minimize data movement (DTU) within their Azure Database. Daily processing time reduced from 72+ hours to 3. Corrected the DAX formulas in their Power BI model. Reworked the snowflake pattern into a star model.