Skip to content

In this project we analyse a dataset we got from 'Real World Fake Data' using SQL then we visualize it using Tableau.

Notifications You must be signed in to change notification settings

Armonia1999/Data-Cleaning-EDA-using-SQL

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

7 Commits
 
 
 
 
 
 

Repository files navigation

Data-Cleaning-EDA-using-SQL

In this project we analyse a dataset we got from 'Real World Fake Data' using SQL then we visualize it using Tableau.

The link to the dataset : https://data.world/markbradbourne/rwfd-real-world-fake-data/workspace/file?filename=Call+Center.csv

note: They have awesome datasets ! so feel free to choose whatever dataset you want from it, I picked the call-center one.

Steps we did :

  • Download the csv file.
  • Import the file to MySQL
  • Clean it a bit (since it's pretty clean to start with)
  • Perform EDA
  • Visualize it using Tableau.

Link to the Tableau dashboard :

https://public.tableau.com/views/CallsDashboard_16548474864490/CALLSDASHBOARD?:language=en-GB&:display_count=n&:origin=viz_share_link

Link to project article : https://medium.com/@Armonia1999/data-analysis-project-using-sql-to-clean-and-analyse-data-64a24e84b730

About

In this project we analyse a dataset we got from 'Real World Fake Data' using SQL then we visualize it using Tableau.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published