Home - Blog di contiprogetto

Data lover in Training: My Portfolio Journey

“I believe that a combination of technical, analytics, and business skills is essential for success in this field. I am seeking an internship opportunity to gain practical experience and further develop my skills in all three areas.”

Hate crimes analysis

This project aims to shed light on the issue of hate crimes in the United States of America. The ultimate goal is to provide useful knowledge and ideas to address this situation from several perspectives, including public awareness campaigns and governmental regulations. To better deploy government resources and raise public awareness of the issue, this study looks at how hate crimes are spread across the nation.

Interactive dashboard

Github code

Business process solving

I carried out a university project together with a group where it was required to solve various business process problems within a company, analyzing the processes and concurrently how the data move and communicate with each other within the process, we managed to find the causes of the problems the company mentions to us.
Mainly what we did was:
– analyze their business processes
– Erp analysis
– Analyze database schema (SQL)
– Create KPIs
– Create SQL queries to analyze data and provide answers based on the data
– Connect the database with Power Bi
– Create dashboards to monitor KPIs

Analysing process

IMPROVING PROCESS

dATABASE SCHEMA CREATION

ticket buying app

For the creation of a cinema ticket purchasing app, I used SQL to create a database schema. This schema gives users the option to choose a location, a date, and a particular genre for their movie. The software engineering team then can construct the app and incorporate the required functionality to enable users to buy their movie tickets through the app thanks to the creation of this database schema.

code in github repository

Linear regreassion

In this study, the association between COVID-19 vaccination and fatalities in Italy is examined. Exploratory data analysis is the first stage, which entails looking at the raw data values, computing summary statistics, and producing data visualizations. Which factors account for the rise or fall in COVID-19-related deaths in Italy is the primary issue raised. The R programming language and a number of packages, including tidyverse, readxl, and gapminder, are used to conduct the research. With the help of the initiative, public health policies and interventions can learn more about the connection between the COVID-19 vaccine and fatalities in Italy.