Solutions: eCommerce Reporting Environment

with No Comments

A world leader in direct marketing and collectibles hit a crossroads with their eCommerce solution – where both strategic and technical direction converged for this Business Intelligence Analyst.

Purpose

This organization needed an analyst to build out a reporting and analytics solutions to support eCommerce marketing decision-making, planning, strategy, and ad-spend performance evaluation. This includes building enterprise data integration from source data systems to centralized Operational Data Store, and department-level data marts.

Process

Solving IT provided the Business Intelligence Analysts and Developers to design and develop the system to enable the business users and stakeholders more flexibility in accessing the data and allow them to perform the analytics they desired. This process included leveraging SQL Server, SSIS, SSRS, Power BI and MS Project to achieve these goals.

Results

The company is now able to attribute where their sales are deriving from, and therefore more effectively target their customers, resulting in increased sales revenues.