Quarterly Market Shares (Anonymized Client Work)

• Company: [Streaming Guide Company - Withheld Name for Anonymity]

• Role: Data Analyst

• Duration: Ongoing

• Tools Used: LightDash, Google Sheets, JSON, Python, and Google Slides

As part of my Data Analyst role, I collected and created graphics which are then used to leverage journalists to use and write about our data.

The primary goal of this report is to find the streaming provider with the strongest user base using internal company data.

• LightDash - Data collection (Filtering by country and providers that fit the criteria for "SVOD")

• JSON and Python - Used to collect the list of streaming providers per country

• Google Spreadsheets - Keeps a static copy of the data for storage and data visualization using Area and Pie Charts.

• Google Slides - For final visualization and presentation of findings

For this campaign:

• Get a list of streaming providers from company JSON data, using Python to filter providers that fit SVOD criteria

• Collect data on Lightdash, filtering by the list of streaming providers and date range

• Compile data in Google Sheets to convert raw data into percentages and create the visualization using Area and Pie Charts

• Once the colors are adjusted to meet company standards, the final viz is done on Google Slides.

Note: This case study is a generalized summary of my workflow and contributions. It does not contain any proprietary data or represent real internal metrics. Company names and details have been withheld or anonymized for confidentiality.