About the customer

The media company is a premier cinema, video and media organization. Headquartered in New York City, the company provides national and regional advertisers with on-screen advertising solutions, in-lobby promotions and integrated marketing programs. In a landscape of partial impressions and fragmented messaging, they deliver un-skippable innovative solutions, putting their clients at the forefront of modern advertising on the biggest screens, serving captivated audiences throughout the world.

PRODUCTS & SERVICES

SQL Server Integration Services (SSIS)

Azure SQL Database

PowerBI
Clearfix

Business Challenge

To meet its reporting requirements, the client needed a solution to replace its legacy analysis services (e.g. traditional OLAP cube) and business intelligence and performance management software suite with a tabular model (e.g.in-memory cube).

The SNP Solution

SNP Technologies provided a managed, scalable data analytics solution that offers simple, self-service capabilities the client needed along with the governance and automation their IT teams required.

Phase 1: Source Analysis & Requirement Gathering

  • Determine where the data will be extracted to support the reporting system. 

  • Document how data will be stored in the Azure SQL Database.

  • Design an ETL process to extract the data from multiple sources, aggregate it and convert it and load it into Azure SQL Database. 

  • Create design documents.

  • Update ETL processes from other sources.

Phase 2: Development & Implementation

  • Create the database.

  • Use Azure Data Factory to create the ETL process.

  • Create tabular model cube on top of the Azure Database.

  • Establish quality assurance guidelines for the deliverables.

  • Create reporting using Excel and Power BI.

  • Finalize solution for production.

Customer Benefits

  • Self-service data preparation allows users to capture and combine virtually any type of data effortlessly.

  • Different kinds of data can be handled and merged into a single model that is easy to understand and use.

  • Role based security is enforced with only authorized users having access to data models, no matter where they are.

  • Users are empowered to create and personalize dashboards and reports with Power BI.

  • Azure analysis services instances are performed within seconds without time consuming and costly migration requirements.