The Nielsen company
Data Automation

The Nielsen Company engaged Tyler for Tableau consulting services to support several large client products, including a core product that tracks mobile performance for hundreds of thousands of end users. This solution aggregates usage data and location information from various carriers, including Sprint (sprint joined TMobile), AT&T, TMobile, Verizon, and United States Cellular Corporation.

The data products generated by this project were used by executives, direct reports to each executive, marketing teams, analysts, and engineers to inform decision-making across the business, adding new cellphone towers, improving cellphone experiences, and were also featured in commercial campaigns and marketing strategies as well as press releases to highlight Nielsen’s dominance in mobile metrics. In addition to these services, Tyler also provided data warehousing, data visualization, and data engineering consulting.

As part of the Nielsen engagement, Tyler provided SQL training, optimized dashboard templates, developed new dashboards, and assisted with project and product management as well as the architecture of trillions of records. He worked closely with Nielsen product managers to re-establish the NMP solution, re-architect the data, and increase revenue by rebuilding Tableau dashboards and developing new ones.

During the initial weeks of this multi-year engagement, Tyler worked one-on-one with IT and product teams onsite to define atomic data items and rewrite the SQL used for Tableau dashboards, resulting in a 98%+ reduction in data sizes. This project involved Tableau, Oracle, and IBMs SSPS.

The Nielsen Company Breakdown.

  • As part of their engagement with The Nielsen Company, Tyler provided SQL training, developed optimized dashboard templates, and assisted with data warehousing services.
  • He also created new dashboards and assisted with project and product management as well as the architecture of trillions of records.
  • Tyler worked closely with Nielsen product managers to re-establish the NMP solution, re-architect the data, and increase revenue by rebuilding Tableau dashboards and developing new ones to monetize.
  • To better understand the business requirements of the current dashboards, he worked with teams at Nielsen to define atomic data items and rewrite the SQL used for the Tableau dashboards, resulting in a 98%+ reduction in data sizes.
  • This project was part of a multi-year engagement, during which Tyler worked one-on-one with IT and product teams onsite to improve the performance and efficiency of their data products.
  • Tyler’s work at Nielsen helped decrease data extract sizes significantly and made data products more approachable. He worked with Nielsen’s IT team to understand the requirements of the dashboards and translate them into new solutions for data architecture problems.
  • Before rewriting the SQL, data extracts took four to five days to complete.
  • After writing SQL, data sizes were significantly reduced, with a 98%+ decrease across all data sources.
  • Improving the UX load speeds of dashboards improved the user experience.
  • The faster dashboards allowed the sales team to more easily sell the product.
  • Tyler Garrett, the founder of DEV3LOPCOM, LLC, helped increase revenue for The Nielsen Company by improving the speed and ease of demonstrating the product to end users, leading to increased adoption and revenue from sales of the data source.
  • By optimizing SQL and lowering data sizes, The Nielsen Company was able to save tens of millions of dollars in annual expenses through the use of in-memory database technology.

We also helped The Nielsen Company with Mystery Shopper Survey Data!

Using our knowledge of data engineering and data warehousing, we helped reshape the way Nielsen handles data manipulation in SPSS. Helping transform their Tableau development by offering a better user experience for Tableau Desktop usage, lowering downtime across all reporting environments, and training internal IT members at Nielsen on best practices for faster report generation.

How did Nielsen generate their Mobile Data?

The Nielsen Company and a large group of technology gurus came together to generate the NMP (Nielsen Mobile Performance) product, to help measure the success and data of providers around the US market.

  • Monitoring network signaling in 86 U.S. markets to count mobile subscribers and determine marketshare
  • Analyzing the cellphone bills of more than 65,000 mobile subscribers in the U.S.
  • Conducting extensive drive tests to measure quality of service in North America
  • Deploying On-Device Meters to measure smartphone activity
  • Analyzing carrier server logs to understand feature phone usage behavior
  • Surveying mobile consumers via telephone, in-person and online surveys

We assisted Nielsen with faster analysis and insights across the following Mobile Metrics.

  • Mobile Voice Call Data Mapping, Visualization, KPI, Trending, and Ranking
    • Call Establish Fail Rate
    • Call Roam Rate
    • No Service Attempt Rate
    • Calls Ending with No Service
    • Calls Ending in Poor Coverage
    • Estimated Drop Call Rate
    • Signal Strength
  • Data Sessions on Mobile Devices
    • Data Setup Failure Rate
    • Abnormal Termination Rate
    • No Service Attempt Rate
  • Data Speeds by Provider
    • 4G Upload and Download Speeds
    • 3G Upload and Download Speeds
  • Provider Coverage Analysis
    • % in 4G and 3G
    • $ in Roaming
    • % in No Service