Connect with me:
Hi, I'm Michael
MBA | Business & BI Consultant | Data Analyst
I transform data into insights to help businesses make better decisions and improve performance
I am passionate about leveraging data to drive innovation and growth and I am always open to connecting, sharing knowledge, and exploring new collaboration opportunities!
Featured Projects
Here are a few examples of my data visualization and business intelligence work. These projects demonstrate how I deliver actionable insights through visually compelling dashboards.
Executive KPI Dashboard for Sales and Shipping
This Tableau dashboard was designed using fake data to provide executive-level insights into sales performance, product trends, key customers, and shipping efficiency. It highlights sales trends, top-performing products, and delivery performance, allowing leadership to make data-driven decisions.
Key features:
Visualizing sales trends and top-performing products,
Identification of key customers and revenue-driving regions,
Analysis of shipping performance with on-time delivery rates and cost breakdowns to highlight opportunities for operational improvements.
Sales Volume Variance Analysis Dashboard
This Tableau dashboard, inspired by client work in the beverage industry, enables users to identify and analyze variances in sales volume across manufacturers and sub-categories. Designed to provide actionable insights, the dashboard equips users with advanced tools for anomaly detection and data exploration.
Value to Users:
This dashboard is a powerful tool for:
• Detecting sales anomalies to optimize business strategies.
• Monitoring monthly sales trends and performance distributions.
• Making data-driven decisions quickly with a user-friendly, interactive interface.
Key Features:
Dynamic Anomaly Detection:
• Users can input custom thresholds to dynamically highlight anomalies in sales volume, making it easier to pinpoint trends or outliers.
Interactive Visualizations:
• Includes box-and-whisker plots to display sales distribution by manufacturer and sub-category.
• Heatmaps visualize sales volume trends and percentages month-by-month, providing a clear view of changes over time.
Advanced Functionality:
• Dynamic Filters: Tailor the analysis by manufacturer, sub-category, year, or month.
• Parameters: Input thresholds or toggle views to customize results.
• Dynamic Zone Visibility: Allows seamless transitions between views based on user interactions, enhancing the dashboard’s usability.
West Coast Telecom Churn and Customer Analysis Dashboard
This Churn and Customer Analysis Dashboard was created using mock data to simulate real-world scenarios. It provides telecom companies like West Coast Telecom with actionable insights into customer churn, retention, and value segmentation. By analyzing key metrics such as churn rates, customer demographics, and revenue impact, this interactive Tableau dashboard empowers stakeholders to identify at-risk customer segments, address churn drivers, and prioritize retention strategies for high-value customers.
Purpose:
This dashboard equips executives and customer success teams with tools to:
• Detect and address customer churn risks.
• Retain high-value customers who have the greatest revenue impact.
• Tailor retention and marketing strategies based on demographic and behavioral insights.
Key Features:
1. Churn Analysis:
Churn and Retention Metrics:
Visualizes churn rate (26.5%), retention rate (67.0%), and their respective revenue impacts.
Highlights $3.7M lost from churn and $17.6M revenue retained.
Demographics Breakdown:
Examines churn and retention patterns by gender and age groups, pinpointing high-risk segments (e.g., males aged 25–44).
Customer Behavior Insights:
Tracks churn by tenure, revealing higher retention rates (93.4%) among customers with longer service periods.
Analyzes contract types, showing correlations between longer contract terms (e.g., two-year contracts) and improved retention.
Reasons for Churn:
Highlights key churn drivers such as competition (45%), dissatisfaction (17.2%), and pricing (11.3%), providing focus areas for improvement.
2. Customer Analysis:
Customer Segmentation:
Segments customers into high-value (68.6%) and low-value (31.4%) groups, with high-value customers contributing 85% of total revenue ($18.2M).
Retention and Churn by Value Segment:
Displays retention rates for high-value customers (84.9%) compared to low-value customers (63.9%), emphasizing the importance of retaining high-value customers.
Demographics and Churn Drivers by Value Segment:
Explores demographic trends and churn reasons (e.g., competition, dissatisfaction) for high- and low-value customers, enabling targeted strategies for each segment.
Empowering Global Conservation Efforts with Real-Time Data Dashboards
What if data could help protect rainforests and improve the lives of communities worldwide? That was the challenge Health In Harmony faced—disparate data sources and manual reporting made it difficult for program managers in Indonesia, Madagascar, and the US to access key insights.
I partnered with Health In Harmony as a part of TIL+, an initiative from The Information Lab to help NGOs and nonprofits make sense of their data.
The project aimed to transform Health In Harmony's data processes and provide their team with real-time dashboards that empowered them to make faster, more informed decisions.
Client Feedback:
“Thanks to these dashboards, our teams in Indonesia, Madagascar, and the US can access their data easily and better serve rainforest communities.” – Nina Finlay, Research Manager at Health In Harmony
Key Deliverables:
Cleaned up Project folders on Tableau Cloud for easier navigation and improved access for stakeholders.
Overhauled and cleaned up data sources for consistent reporting.
Developed a suite of interactive Tableau Dashboards for program monitoring.
Ensured seamless data publishing to Tableau Cloud for executive and field-level access.
Delivered hands-on training to the team, presenting results in person to ensure adoption.
Results:
Increased accessibility: Program managers across global locations gained easy access to real-time data.
Enhanced decision-making: Dashboards streamlined program reporting and increased data clarity for stakeholders.
Operational impact: Improved efficiency in tracking key health and conservation metrics.