Alessio GasperiHow to Use AVERAGEX in Power BI to Calculate a Moving AverageCalculating a moving average in Power BI is a powerful way to analyze trends over time, smoothing out short-term fluctuations and…Aug 15Aug 15
Alessio GasperiHow to Remove Duplicates from a Table in Microsoft SQL ServerIn this short article, I will show you how to remove duplicate records from a table in a database.Aug 4Aug 4
Alessio GasperiUnderstanding Star Schema vs. Snowflake Schema in Power BIWhen designing a data model in Power BI, choosing the appropriate schema is crucial for efficient querying and performance. The two primary…Jul 28Jul 28
Alessio GasperiHacks for Mastering Professional Communication and Presentation SkillsIn the following article, I’ll share some basic concepts about communication and presentation skills that I’ve learned over time by…Jun 23Jun 23
Alessio GasperiImplementing K-Nearest Neighbors (KNN) for Species Classification in RIn 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 19May 19
Alessio GasperiTransforming Sales Data into Simple and Easy-to-Understand Dashboards with Power BIIn 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 121May 121
Alessio GasperiBuilding a Complex View: An SQL ProjectIn the world of Data Analysis, SQL remains an indispensable tool.May 1May 1
Alessio GasperiPredicting Income Levels: A Logistic Regression Analysis in RAs many of you might know, Logistic Regression is a statistical method used to model the probability of a binary outcome. In this project…Apr 28Apr 28
Alessio GasperiBuilding Simple Visuals with ggplot2: A Step-by-Step GuideAre you looking to visualize your data in a clear and concise manner? With R and ggplot2, creating impactful visuals is easier than you…Mar 17Mar 17