Skip to content

jenn-db/Marketing-Data-Exploration

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

13 Commits
 
 
 
 
 
 

Repository files navigation

Campaign Performance

I was provided with a dataset in Excel format, which I transformed into CSV and imported into DB Browser. My first step was grouping campaigns based on their names to facilitate a structured overview.

I showcased campaign metrics, including their respective locations (I added the location column by concluding it from the campaign name) and platforms. I also used SQL to show monthly performance trends.

Finally, I integrated the SQL-generated tables into Tableau, and built charts that will help get a view on the campaigns and lead to informed decision making. I also added a PPT presentation to explain my findings based on the dashboard. (I did not attach it because it had confidential information).

SQL & Tableau Output

Python Skills

In this notebook, I showcased the following pandas skills

  • Reading csv, excel
  • Indexing
  • Filtering and ordering columns
  • Group by and aggregate functions

About

Campaign Metrics: SQL, Tableau, Pandas

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published