Skip to content

Cleaning and normalizing data using MySQL and creating visualizations in Power BI

Notifications You must be signed in to change notification settings

rud-ninja/Data-cleaning-visualization-SQL-PowerBI

Repository files navigation

Data-cleaning-visualization-SQL-PowerBI

Objective

The objective of this project was to conduct comprehensive data cleaning and analysis on the 'Steam games' dataset using SQL, with a focus on enhancing data quality and preparing it for insightful visualizations. Subsequently, Power BI was employed to create meaningful and interactive visualizations that provide a clear representation of key trends, patterns, and insights within the Steam games dataset.

Tools

  • MySQL Workbench
  • Microsoft Power BI

Files

  1. SQL script
  2. Dashboard (in PDF)

** Since web embedding is restricted in the free Power BI account, a downloadable PDF of the interactive dashboard has been provided. To explore the full interactivity, kindly download the file and view it within Power BI.

The original dataset can be downloaded from here.

About

Cleaning and normalizing data using MySQL and creating visualizations in Power BI

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published