/dgiord.github.io

Primary LanguageJupyter Notebook

Junior Data Analyst

Let's connect on LinkedIn!

Technical Skills: SQL, Python, Tableau, Azure, Databricks, Excel

Education

  • Master in Data Analytics, start2impact University (Nov 2023 - Present)
  • Batchelor's Degree in Economics and Commerce, UniversitĂ  degli Studi di Napoli Federico II (Sep 2018 - Mar 2022)

Projects

Google Play Store Apps analysis

View the code on Github

In my second project, I simulated a business case in which a developer has to create a new app for the Android market, and wants to make sure they know the best possible conditions in order for it to be as highly rated as possible. To find what type of app would perform best, I analyzed the Google Play Store Apps Kaggle Dataset, using Python and its libraries Pandas, matplotlib and Seaborn. My analysis found what the most popular categories, genres and content ratings are for apps in the Google Play Store.

PlayStoreApps

Renewable Energy SQL Project

View the presentation
View the code on Github

For my first project, I used PostgreSQL to analyze the Kaggle Dataset Renewable Energy World Wide : 1965~2022. This dataset on renewable energy contains data on renewable energy usage worldwide from 1965 to 2022. My analysis emphasizes how in the last ~15 years, countries have started making a bigger effort towards using a higher amount of renewable energy in their energy mix - however, this still hasn't been enough to heal decades of abuse on our planet.

RenewableEnergy

Work Experience

Data Analyst - Associate @ PwC Italy (March 2024 - Present)

  • Building and maintaining data flows on Microsoft SQL Server
  • Development of data pipelines on Azure Data Factory and Databricks using Python
  • Production of comprehensive documentation for data pipelines’ architecture and workflows
  • Creation and optimization of Power BI dashboards to monitor KPIs

Operations Specialist @ Daytrip (Feb 2023 - Dec 2023)

  • Managing 100s of daily support requests, enhancing company relationships with Italian partners
  • Resolving 150+ tickets daily during the high season, averaging 15+ tickets daily
  • Overseeing the Operations team, standardizing processes and workload management
  • Effectively managing a ~90% increase in the number of bookings in 2023 compared to 2022, thanks to a more efficient team workflow