JOSH PORTFOLIO

Welcome to my portfolio showcasing practical projects and insights as a data and business analyst. I leverage tools like Excel, Power BI and SQL to extract insights, build dashboards, and drive data-driven decision-making.

Customer Shopping Analysis using PowerBI

Unlocking customer behavior with data. Visual insights that drive smarter retail decisions. Power BI dashboards that turn complex data into actionable stories.
In this project, I utilized Power BI to conduct a comprehensive customer shopping analysis from over 99,000 records. I designed an interactive dashboard that visualized key business metrics such as gender distribution, sales by product category, customer generations, and payment methods. With Power BI’s powerful data modeling and DAX features, I was able to identify top-performing malls and product categories, uncover generational buying patterns, and analyze quarterly trends in customer activity. This analysis helps stakeholders understand which customer segments drive the most value and where to focus marketing and inventory strategies for maximum return. It’s a great example of how data storytelling can power business decisions in retail.

Airplane Crashes and Fatalities Using PowerBI

Transforming aviation accident data into critical insights. A global perspective on air crashes and safety trends. Power BI dashboard uncovering causes, patterns, and key hotspots.
In this project, I leveraged Power BI to explore a historical dataset on airplane crashes and fatalities across various countries and time periods. My interactive dashboard visualizes over 5,000 flight incidents, highlighting key statistics such as 145K passengers aboard, 105K fatalities, and 2,470 operators involved. The dashboard provides: A world map showing the global distribution of accident locations. Top aircraft models involved in crashes. A yearly trend analysis displaying fluctuations in accidents and fatalities over time. A scatterplot revealing the relationship between flight types and fatality levels. Insights into the most accident-prone operators and locations, helping stakeholders assess risk-prone areas and carriers. This analysis is not only a visual exploration of aviation history but also a demonstration of how data storytelling can enhance awareness and inform safety improvements in the transportation industry.

Sales Analysis Using Excel

Transforming Sales Data into Actionable Performance Insights through Excel-based analysis. A summary of business performance, trends, sales, profit patterns, and key performance indicators.
In this project, I used Excel to explore sales performance data across various categories, demographics, and locations. My analysis visualizes key metrics, highlighting statistics such as 34,866 total transactions, 69,820 total quantity of products sold, total revenue of 22,344,575, and a profit/loss of 2,261,609. The analysis provides: A monthly profit/loss trend analysis displaying fluctuations in profitability over time, achievable through Excel line charts. Profit/loss breakdowns by customer gender, visualized using Excel pie charts or bar charts. Profit/loss breakdowns by customer age group, also visualized using Excel bar charts or column charts. Profit/loss breakdowns by product category, which can be effectively shown with Excel bar charts. A "Top 10 Profit/Loss by Location" analysis, identifying key regional performance, easily created with sorted Excel bar charts. Filtering capabilities by product category, customer gender, payment option, and sales person, achievable using Excel's filtering and sorting features or with Pivot Tables.

What I do

I am a passionate Data Analyst and Business Analyst who transforms raw data into meaningful insights using tools like Excel, Power BI, and SQL. I create interactive dashboards and perform in-depth analysis to support smart business decisions.

How To use DGET

"Excel's DGET function extracts a single value from a database or list based on specified criteria. It's like a very precise lookup, requiring that your criteria match exactly one record. This is useful for pulling specific information when you have a structured dataset and need guaranteed unique results.".

Financial Modelling In Excel

"This Excel-based financial model forecasts key financial metrics over several years (2024-2027). It projects Revenue based on Price and Quantity Produced, calculates Cost of Goods Sold (COGS) and Gross Profit. It further details Operating Expenses (OPEX) like Salaries and Wages and Marketing Expenses to arrive at the Net Profit. The model also includes scenario analysis (Best Case, Base Case, Worst Case) impacting Price and Quantity Produced, allowing for different potential outcomes to be evaluated."

  • Learn more

    • Let’s Work Together

    Whether you're looking to collaborate, hire a data analyst, business analyst, powerbi developer or just say hello, I'm always open to new opportunities.