Diogo Silva

                                                 https://github.com/DSILVA232?tab=repositories

Melbourne E-Bike Usage & Demand Analysis

Python | Pandas | NumPy | Matplotlib

• Analyzed urban e-bike usage data to identify ridership patterns, peak demand periods, and seasonal trends
• Performed data cleaning and transformation using Pandas
• Conducted exploratory data analysis (EDA) to uncover time-based and behavioral trends
• Visualized insights using Matplotlib to highlight demand fluctuations and usage behavior

Financial Performance & Profitability Analysis

Excel | Power Query | DAX | Pivot Tables | Data Modelling

• Built an interactive financial performance model analyzing revenue, expenses, and profitability trends
• Used Power Query to clean, transform, and structure raw financial data for analysis
• Created calculated measures using DAX to evaluate YoY growth, MoM changes, and profit margins
• Developed a dashboard using Pivot Tables and data modelling techniques
• Identified key drivers impacting profitability and operational performance

ASCES Product Sales Analysis (End-to-End SQL to Power BI Project)

SQL | SQL Server  | Power BI | DAX | Data Modelling

• Designed and queried a relational database to analyze product sales performance
• Wrote complex SQL queries (joins, aggregations, CTEs) to extract business insights
• Built a structured data model in Power BI with calculated measures using DAX
• Developed an interactive dashboard highlighting revenue trends, product performance, and growth metrics