The hacker's den - A escape based on data analysis

As my final project for the Data analytics bootcamp, I decided to build a virtual escape room based on Data analysis and showed with Streamlit. Keep reading if you want to know more about this! (I would do it!)

Introduction 🗣

It was a risky decision but I wanted to make something different and funny with all knowledge I had about Data analysis. So I mixed my passion about escape rooms, mysteries and the final project to shape "The Hacker's Den": a police case where we have to help the Codes City Police Department as computer experts to catch a hacker from our office computer. Hope you like it!

Basically, all code is made in Streamlit and I deployed it to make it functional for everybody. So take a look in the link below:

Go to solve the case clicking here!

Storytelling 📕

"Welcome buddy! My name is Gil Push and I am the Chief of Police 👮‍♂️ at Codes City Police Academy and I will be your instructor until you pass your first case. You are a lucky buddy because we have a new case and we need your help! It has taken us too much time but finally we made it: we found out the Hacker's den 🐱‍💻 ! I need you to work as the computer expert 💻 you are and help our team that is arriving to Hacker's den. We will need all your knowledge in Data analysis 🧮 and your wit 🧠 to solve the case. Are you ready, buddy?"

"We do not have your identification 🆔 yet but you can use one of ours to access to our system: James Nake and Scarlett Plot will help you with that. Take your (jupyter) notebook 📝 and use it to solve the case. There are two different notebooks to use: a Junior one, with a guideline to solve the case, prepared for those have less knowledge about Data analysis but want to try or are with a Senior to help them (bring Data to your closest people!); and a Senior one, with no guideline at all, just you and the case. Do you dare? 😏 "

"Don't forget to send to me by email 💌 your notebook when finished so I can score 💯 your progress and stablish a ranking 🏆 with the other participants. Try to be the first one 🥇, buddy!"

Content 🧾

Puzzles 🧩 and games 🕹 are made to be solved with Python¹ 🐍, web scrapping (I used Selenium²) 🕸 and with a SQL platform(I used MySQL³) 🎫 but it's free to solve in a different way.

I made a trailer 🎞 with Sony Vegas Pro 16.0⁴ to set the escape room scene (avaible in the main page).

Almost all images 📷 are made by AI (Artificial Intelligence)^5,6🤖 and/or edited by me with Adobe Photoshop Cs5⁷. Some of them are obtained by searching on the Internet⁸ 🏄‍♂️ (no copyrights intended).

The code is written in docs.py to show in Streamlit⁹ the final result. These pages are in this repo so take a look if you want to 👀!

Sources ⛲

1. https://www.python.org/
2. https://www.selenium.dev/
3. https://www.mysql.com/
4. https://www.vegascreativesoftware.com/us/vegas-pro/
5. https://www.artbreeder.com
6. https://openai.com/dall-e-2/
7. https://www.adobe.com/es/products/photoshop.html
8. https://www.google.com/
9. https://streamlit.io/

To-do list

• I would like to improve the escape with some new games about visualization, machine learning and ETL process (I have the idea on my mind but no time enough to put them on working).
• I would like to replace the "sending-notebook-by-email" by a uploading system with cloud computing.
• I would like to improve some pages (more visual, more functional).

Acknowledgement

I would like to thank my teachers (Yonatan Rodríguez, Adrián C. Ciges and Oriana Ampuero) for their help and cheers when I though I and my work were lost. Thanks to my classmates for all the support and good words! Indeed, my project was one of the most voted by them so I am so gratefull! By last, thanks to you, viewer, for getting until here and taking a look to my job!

If you want to make some recommendations to me for improving my project, I will be pleased to read them!

You can find me on Linkedin and via email.