Irene NafulainThe Data GazetteGenerate a real-world dataset using Python & insert into a databaseEver stared at a mountain of csv files and thought, ‘How on earth am I going to get this into a database?’Sep 1Sep 1
Irene NafulainThe Data Gazette10 Best Practices for Writing SQL QueriesWrite SQL like you mean it — clean, readable and efficient.Aug 21Aug 21
Irene NafulainThe Data GazetteSales Analysis in SQL Server & PowerBI -Part 2In part 1 of this project, we created our database from a backup file and then connected it to PowerBI for cleaning. If you prefer to…Aug 7Aug 7
Irene NafulainThe Data GazetteHow to create a Top N visual using Numeric Range parameters in PowerBIAssuming we have a products table in PowerBI and we would like to create a bar chart that shows the top 10 products by sales revenue.Aug 2Aug 2
Irene NafulainThe Data GazetteMeasures vs Calculated Columns in PowerBIIn PowerBI, one of the most common confusions users have is between measures and calculated columns. They might seem similar at first…Jul 6Jul 6
Irene NafulainThe Data GazetteSales Analysis in SQL Server & PowerBI -Part 1This project involves 2019 sales data from a data analytics challenge I participated in. We will restore a backup file in Microsoft SQL…Jun 24Jun 24
Irene NafulainThe Data GazetteWhich AdventureWorks Database is Suitable for Your Data Analysis Journey? OLTP, LT, or DW?Feb 1Feb 1
Irene NafulainThe Data GazetteA Beginner’s Guide to Exploratory Data Analysis (EDA)Today, I invite you to embark on a journey through the captivating world🌐 of Exploratory Data Analysis (EDA)🔍. Think of EDA as the…Aug 30, 2023Aug 30, 2023