Motorola Analytics Internship
Data analytics internship at Motorola Solutions — PySpark/SQL pipelines, churn insights, and Looker Studio dashboards for EMEA sales leadership.
- Role
- Data Analytics Intern
- Timeline
- May 2023 — Aug 2023
Overview
Project summary and scope.
Summer internship with Motorola Solutions supporting analytics for sales and operations. Work focused on replacing manual Excel reporting with scheduled pipelines, surfacing churn signals from large transaction datasets, and delivering Looker Studio dashboards used by EMEA sales leadership.
My Contributions
Key areas of ownership and delivery.
- Replaced manual Excel reporting with scheduled PySpark and SQL pipelines across 121K+ transaction and subscription records
- Cleaned, transformed, and joined customer, transaction, and license data to identify churn signals and high-risk accounts
- Delivered a Looker Studio dashboard used by the EMEA Sales Director to analyze churn drivers and prioritize retention actions
- Collaborated with the Global Offer Manager and Sales team under tight summer internship timelines
- Presented findings and methodology to sales leadership, handling questions with clarity
Core Features
Primary capabilities delivered in this project.
- Scheduled PySpark and SQL reporting pipelines
- Churn and high-risk account signal analysis
- Looker Studio dashboard for EMEA sales leadership
- Decision-ready metrics from fragmented operational data
Architecture
How the system is structured at a high level.
Source transaction and subscription data was cleaned and joined in PySpark/SQL pipelines, then surfaced through Looker Studio dashboards so sales leadership could review churn drivers and retention priorities without manual spreadsheet work.
Impact
Outcomes and value delivered.
- Reduced processing time by approximately 30% versus manual Excel reporting
- Contributed to a 12% reduction in customer churn through clearer retention prioritization
- Gave EMEA sales leadership a reusable dashboard for churn analysis
Challenges
Constraints and difficulties encountered during delivery.
- Learning production data intricacies quickly within a short summer internship
- Aligning metric definitions with sales stakeholders under real business pressure
- Turning messy multi-source data into trustworthy visualizations for leadership review
Tradeoffs
Key decisions and the reasoning behind them.
- Prioritized high-impact recurring reports over one-off ad hoc asks
- Used Looker Studio so stakeholders could adopt the work without new tooling
- Kept client-sensitive details anonymized in public portfolio materials
Future Improvements
Next steps that would strengthen or extend this work.
- Expand automated data quality monitoring for key pipelines
- Standardize metric catalogs across reporting domains
- Add self-serve reporting layers for common operational questions
Problem and Solution
Problem
Sales and operations teams relied on manual Excel reporting across large transaction and subscription datasets, which slowed analysis and made it harder to spot churn risk early.
Solution
Built and supported PySpark and SQL pipelines, cleaned and joined customer/transaction/license data, and delivered Looker Studio dashboards that turned fragmented operational data into decision-ready insights for EMEA sales leadership.
Tech Stack
Technologies used across this project.
- Python
- PySpark
- SQL
- Looker Studio
- ETL
Manager Recommendation
Feedback from my internship manager on LinkedIn.
“It was a pleasure to collaborate with Anjali during our summer internship. Despite being in the early stages of her Data Analytics career, Anjali has showcased a strong grasp of the fundamentals and an impressive ability to adapt swiftly. Given the limited time frame of summer internships, her capability to quickly comprehend our data's intricacies was commendable. She adeptly utilized new tools to refine the data and crafted visualizations that yielded valuable business insights. Anjali's inherent curiosity is evident, aligning seamlessly with her chosen career. For her concluding project, she presented her findings to the sales leadership team, articulating her methodology and results while handling questions with poise. Her contributions significantly enriched our program, and the team was truly appreciative of the insights she provided.”