Home › Portfolio

Our Portfolio

Real projects, real results dashboards, data visualizations, and presentations built to turn complex data into clear decisions.

📊 Bar Sales Dashboard ✈️ Aviation Training 🗺️ PR Population ⚾ MLB Salaries Dashboard 📈 Executive Dashboard

Bar Sales Performance Dashboard

Data Analyst & Dashboard Developer

Interactive client-ready dashboard analyzing retail beverage sales performance. Features KPI tracking (Revenue, Orders, Avg Order Value, Growth), monthly trend analysis, top category insights, revenue breakdown, and automated executive summary with PDF export. Built with Python, Pandas, Plotly, and Streamlit. Enabling faster, data-driven decisions and seasonal trend analysis for inventory planning.

Python Streamlit Plotly Pandas Data Visualization KPI Dashboard
📅 Published Mar 2026
Bar Sales Performance Dashboard

Case Study: Bar Sales Dashboard

YC Analytics transformed monthly sales records into a client-ready dashboard that helps management track revenue performance, compare categories, identify seasonality, and export executive-ready PDF summaries.

Challenge

Sales data existed across monthly category records, making it hard to answer practical questions about revenue drivers, seasonality, and year-over-year performance.

Solution

Built a Streamlit dashboard with KPI cards, trend views, category rankings, revenue mix visuals, executive recommendations, and PDF export for stakeholder reporting.

Business Impact

Reduced manual reporting effort and gave stakeholders a reusable analytics tool for monthly review, planning, and communication.

Tools Used

Streamlit, Plotly, Python, executive reporting design, and PDF export workflow.

$71,433 Total net sales analyzed across the dataset, giving management a complete performance view.
48.6% Beer was the leading revenue driver, revealing where menu, pricing, and promotional focus should start.
11.1% YoY 2023 net sales increased versus 2022, giving stakeholders clearer evidence of growth trends.

Aviation Mechanics Training Dashboard

Data Analyst & Dashboard Developer

Excel dashboard tracking aviation maintenance training across 21 qualification tracks for 7 technicians. Consolidates weekly signoff data showing completion trends, technician performance, and progress vs. targets. Tracks 5,323+ signoffs, enabling leadership to monitor workforce readiness and identify where support is needed in real time.

Microsoft Excel Data Analysis Analytics Dashboard KPI Tracking Aviation
📅 Published Mar 2026
Aviation Mechanics Training Dashboard

Case Study: Aviation Maintenance Training Progress Dashboard

YC Analytics upgraded an existing Excel workbook into a clearer, more decision-ready dashboard that helps leadership monitor qualification progress, track weekly performance, and identify where intervention is needed.

Challenge

The original workbook contained useful data, but leadership had to spend too much time manually reviewing it to understand progress at a glance.

Solution

Reorganized the dashboard for readability, improved progress visualizations, and structured the workbook for clearer trend review and future benchmark tracking.

Business Impact

Created faster visibility into completion progress, easier identification of lagging areas, and stronger support for weekly and monthly performance reviews.

Tools Used

Microsoft Excel, dashboard design, KPI visualization, and trend-focused reporting structure.

5,323+ Training signoffs tracked in a single reporting tool for clearer qualification monitoring.
21 Tracks Qualification areas compared in one dashboard to highlight gaps and progress trends.
Excel-Based The solution stayed in a familiar operational tool, making adoption easier while improving reporting quality.

Puerto Rican Population Distribution

Data Analyst & Dashboard Developer

Demographic dashboard analyzing Puerto Rican population distribution across the United States using U.S. Census data. Features geospatial choropleth visualization, ranked Top 10 states bar chart with logarithmic scale for interpretability. Built with Python, Pandas, and Plotly. Transforming raw census data into clear, interactive geographic insights for market research.

Python Plotly Pandas Geospatial Census Data Market Research
📅 Published Mar 2026
Puerto Rican Population Distribution Dashboard

Case Study: Puerto Rican Population Distribution Dashboard

YC Analytics transformed raw demographic data into a clear geographic dashboard that supports strategic planning, market targeting, and resource allocation across U.S. states.

Challenge

Raw Census-style data needed cleaning, normalization, and stronger visual design before it could support real business or planning decisions.

Solution

Built a choropleth map, ranked comparison chart, and KPI annotations to make concentration patterns and market opportunities easier to interpret.

Business Impact

Created a scalable analytics asset that helps stakeholders prioritize high-density states while recognizing growth opportunities in secondary markets.

Tools Used

Python, Pandas, data cleaning, geospatial mapping, logarithmic scaling, and visualization design.

Top-State Focus Florida and New York emerged as key concentration markets for targeting and planning.
Log Scale Normalization improved visibility across both large and smaller state populations.
Map + Ranking Combining geographic and ranked views created a clearer decision-making tool than raw tables alone.

MLB Teams Salaries Dashboard with Tableau

Data Visualization

This project focused on combining Excel and Tableau to create a dashboard that analyzes MLB team salaries. It contains player salary data for each year from 2012 to 2018, including each player's name, team, position, and salary for that season. It also includes a team graph listing each team, along with the division, league, city, state/province, and country.

Tableau Microsoft Excel Data Visualization Dashboard Design Sports Analytics
📅 Published Mar 2026
MLB Teams Salaries Dashboard with Tableau

Interactive Executive Dashboard in Power BI

KPI Dashboard & Data Visualization

To support executive decision-making, I developed an interactive Power BI dashboard that transformed static financial reports into dynamic, user-driven insights. The project highlights cumulative sales, average sales, and units sold using DAX measures for time-based aggregation, while slicers for Country and Segment give users deeper context across business units and regions. I also added a sales forecasting line chart with configurable confidence intervals and designed a matrix visualization to display profit margins by country and segment, revealing operational efficiency across the organization.

Microsoft Power BI KPI Dashboards Interactive Dashboards DAX Data Visualization
📅 Published Mar 2026
Interactive Executive Dashboard in Power BI
❝

"Yasim has consistently demonstrated reliability and speed in delivering high-quality work. His ability to listen to clients' needs sets him apart. He fully understands project requirements and aligns his work accordingly. Yasim is always punctual, meeting deadlines without compromising quality."

N
Nilma E.
PowerPoint Presentation · Verified Client · Dec 2025

Ready to start your project?

Let's turn your data into decisions. Reach out to discuss your analytics, dashboard, or design needs.

Get In Touch → View Services