Alessio Gasperi – Medium

Alessio Gasperi

Alessio Gasperi

How to Use AVERAGEX in Power BI to Calculate a Moving Average

Calculating a moving average in Power BI is a powerful way to analyze trends over time, smoothing out short-term fluctuations and…

Aug 15

How to Use AVERAGEX in Power BI to Calculate a Moving Average

Aug 15

Alessio Gasperi

How to Remove Duplicates from a Table in Microsoft SQL Server

In this short article, I will show you how to remove duplicate records from a table in a database.

Aug 4

How to Remove Duplicates from a Table in Microsoft SQL Server

Aug 4

Alessio Gasperi

Understanding Star Schema vs. Snowflake Schema in Power BI

When designing a data model in Power BI, choosing the appropriate schema is crucial for efficient querying and performance. The two primary…

Jul 28

Understanding Star Schema vs. Snowflake Schema in Power BI

Jul 28

Alessio Gasperi

Hacks for Mastering Professional Communication and Presentation Skills

In the following article, I’ll share some basic concepts about communication and presentation skills that I’ve learned over time by…

Jun 23

Hacks for Mastering Professional Communication and Presentation Skills

Jun 23

Alessio Gasperi

Implementing K-Nearest Neighbors (KNN) for Species Classification in R

In this R project, I used the KNN function to classify the species of flowers in a small dataset. Before diving into the code, let’s…

May 19

Implementing K-Nearest Neighbors (KNN) for Species Classification in R

May 19

Alessio Gasperi

Transforming Sales Data into Simple and Easy-to-Understand Dashboards with Power BI

In this article, I will share the key steps and results of a recent project I completed using Power BI, whose goal was to create…

May 12

Transforming Sales Data into Simple and Easy-to-Understand Dashboards with Power BI

May 12

Alessio Gasperi

Building a Complex View: An SQL Project

In the world of Data Analysis, SQL remains an indispensable tool.

May 1

Building a Complex View: An SQL Project

May 1

Alessio Gasperi

Predicting Income Levels: A Logistic Regression Analysis in R

As many of you might know, Logistic Regression is a statistical method used to model the probability of a binary outcome. In this project…

Apr 28

Predicting Income Levels: A Logistic Regression Analysis in R

Apr 28

Alessio Gasperi

Exploratory Analysis and Modeling of Bike Rental Data with R

Purpose:

Apr 21

Exploratory Analysis and Modeling of Bike Rental Data with R

Apr 21

Alessio Gasperi

Building Simple Visuals with ggplot2: A Step-by-Step Guide

Are you looking to visualize your data in a clear and concise manner? With R and ggplot2, creating impactful visuals is easier than you…

Mar 17

Building Simple Visuals with ggplot2: A Step-by-Step Guide

Mar 17

Alessio Gasperi

Alessio Gasperi

Senior Data and Sales Analyst ⫸ Pricing Specialist, Forecasting and Reporting ⫸ Microsoft Excel | Power BI | SQL | R

Following

Help
Status
About
Careers
Press
Blog
Privacy
Terms
Text to speech
Teams