The project's goal is to set up a data visualization dashboard with Python and SQL for competitor analysis data. We have already built a competitive landscape for our company and have knowledge of our competitors but now we want to build some visualizations and do some analysis of them using data visualization. We need a pipeline that will be updated as our database updates. If time permits, we'll also work on deploying created scripts onto our servers and setting up some update notifications for the team to continuously get notified of when the pipelines and a log report of the run.

The scope of this project only involves building a key set of pre-defined visualizations and a pipeline that takes the SQL data and then visualizes them in Python. This project will not include any competitor analysis or other related research.

Students will assist with:

- Analyze the existing competitive landscape data

- Develop a data visualization dashboard using Python and SQL

- Create visualizations for competitor analysis data

- Implement a pipeline that updates as the database updates

- Test the dashboard and make improvements based on additional data

Final deliverables:

- A data visualization dashboard with Python and SQL

- Visualizations and analysis of competitor data

- Documentation of the pipeline that updates with the database

- A report explaining the design process and outcomes

Students will have full mentorship from the team and will be guided through the entire process. Students will also be provided support and guidance in the form of weekly standup and will have constant feedback from project manager and senior engineers on the team.