Impact of Social Media on Direct Sales Across the NFL DB
During my DBMS class for my M.S. in Business Analytics, my team and I went through the database life cycle to construct a database in SQL Server that the NFL can utilize to positively influence social media marketing strategies and directly increase ticket and merchandise sales.
The mission behind our database is to track social media engagement, uncover insights to drive targeted marketing strategies, and, as a result, increase sales for both the league and individual teams.
In this database project, we created an analysis of the business problem we wanted to solve, made a database design (relational, conceptual, and ER models), implemented business case queries, and performed a live presentation to demo our database development from start to end. We also leveraged Tableau to construct dashboards with visualizations for business transactions that provided valuable insights to address our mission statement and objectives.
SQL Server
Tableau
Database Design
Analytics