In the first part of this series, we built a robust Power BI data model to analyze employee attrition and satisfaction trends. Now, we’ll develop new measures and columns using DAX, a powerful formula language for data modeling and analysis…
Building a robust data model is the foundation of effective analytics. In this step-by-step guide, we’ll use the IBM HR Analytics dataset (found on kaggle.com) to create a star schema that simplifies data analysis and reporting. This is the first…
Data modeling is the process of creating a visual representation of an organization’s data and the relationships between different pieces of that data. For example, imagine a retail business that tracks sales, customers, and inventory – data modeling would illustrate…
In today’s data-driven world, organizations rely on analytics tools like Power BI to derive actionable insights from vast datasets. However, the accessibility of this data comes with a critical challenge: ensuring that users can only view the data they are…
This project focuses on the analysis of gas stations across all provinces in Spain, using a dataset extracted from the official Spanish government portal dedicated to energy infrastructures. The data was obtained in September 2024 from the Gas Stations Geoportal,…
Exploratory Data Analysis (EDA) is the first and most important step in the data analysis workflow. It allows analysts and scientists to understand the patterns, relationships, and anomalies within the data, making it ready for a deeper analysis or the…
In this weather data analysis project, I analysed daily meteorological data from Warsaw, Poland from 1993 to 2022. I used Python for initial data preprocessing, Exploratory Data Analysis (EDA), statistical analysis and I created a Machine Learning model to see…
Data Analysis and Business Intelligence (BI) are field that are always in evolution, so what’s the best way to you stand out? The answer might be simpler than you think: a well built portfolio. This article will explore why portfolios…
In this project, I worked on a comprehensive examination of online transactional data, of an e-commerce. I utilized Python for preliminary exploration, SQL for investigation and querying the data, and Power BI for visualization, this work showcases a blend of…
In this article I will show you how to create a personalized dataset for your personal project or case study. It will have as many columns and entries as you need! The main tool used for this creation is the…