⬆︎

LEVEL UP YOUR GAME!

Data Analytics is a keystone for companies nowadays. We can harness the power of data together to gain insights, make better decisions, and drive growth.

Pablo Calvo - Analytics

REACH OUT IN ANY OF THESE 👇🏻

🚀 Who am I?

'Every piece of data has a story to tell.'With over 18 years of experience in the dynamic realm of the gaming industry, I consider myself an extremely versatile, results-driven data analyst. Armed with an extensive skill set and a keen analytical mind, I have consistently contributed to the success of various game and console releases, guiding the wider team with data to help them make informed decisions for their products. Proficient in a spectrum of data visualisation and analysis tools, including Qlik, Tableau, SQL, Looker Studio, Power BI, and Python, I take pride in possessing a versatile toolkit to unravel complex datasets and derive actionable insights.Whether it's dissecting player behavior trends, forecasting our financial year budget and game sales, or enhancing user experience, I have been at the forefront of leveraging data as a powerful asset in shaping the gaming landscape.Beyond technical expertise, I bring a passion for innovation, a collaborative spirit, and a commitment to staying abreast of the latest industry trends. I am not just a data analyst but a strategic partner, adept at aligning data initiatives with overarching business goals. In the ever-evolving world of gaming, it is paramount to stay at the vanguard and use the power of data to invigorate the decision-making process in every company.

🏢 SOME OF THE COMPANIES I WORKED WITH

PlayStation
KONAMI
adidas
Riot Games
Blizzard Entertainment
Miniclip
King (Activision Blizzard)
Space Ape

🔧 MY TOOLKIT

I possess proficiency in various tools and make a conscious effort to expand my skill set annually, given the rapid pace of data analysis and development.In addition to diligently fulfilling my responsibilities, coding and programming are not just tasks for me; they are my passions. This enthusiasm is evident in Finanzas MTG, a project that originated as part of my portfolio. It has since evolved into a revenue-generating venture and transformed into a full-stack data-processing tool. This tool automates data gathering on a weekly basis using Python scripts, stores the data in BigQuery, and channels it into Looker Studio for visualization. Moreover, the data is processed with Python to automate posts on Twitter or send emails to our users.

🎓 MY DATA ANALYTICS CERTIFICATES

Some of the courses and certificates I finished in the past.

Google Data Analytics Certificate
AWS Certified Data Analytics

❤️ THE POWER OF GIVING BACK

Giving back to charities is crucial for several reasons. Cancer Research UK contributes to the ongoing battle against a pervasive and devastating disease, funding vital research that can lead to breakthroughs in treatment and prevention. Special Effects, dedicated to helping individuals with disabilities through video games, relies on charitable contributions to enhance the quality of life for those facing unique challenges, emphasising the importance of inclusivity. The National History Museum serves as a beacon of education and preservation, in the vanguard of educating future generations about the wonders of our planet's past. Last but definitely not least, the WWF plays a pivotal role in conservation efforts, safeguarding endangered species and ecosystems.By donating to these charities, I aim to actively participate in global initiatives addressing health, inclusivity, education, and environmental sustainability. Together, we can create positive change for the benefit of society and the world we inhabit.

📈 DATA STORYTELLING & VISUALISATION

With the rise of digital business and data-driven decision making, data storytelling has become a cornerstone skill for any organisation. Translating sophisticated data analyses into plain-English is paramount to provide stakeholders with valuable insights to propel the business forward. By simplifying and digesting billions of rows of complex data into an easy-to-understand chart, we empower our colleagues to make powerful and tailored decisions.Data visualisation and data stoytelling gives anyone, regardless of level or skill set, the ability to understand and use data in their jobs every single day. Therefore, using data in an organisation should not be the goal – it should be part of the culture.

Looker Studio - Price & Stock Evolution in Double Masters 2022 (MTG cards)

This Looker Studio dashboard showcases full-stack data processing – data is ingested via Python with web scraping, then normalised – cleaned, aggregated, additional calculated fields – and loaded into BigQuery (SQL Database). Lastly, via custom queries, data is pipelined into the dashboard for visualisation. The dashboard can be filtered by users and it’s completely dynamic – it’s updated automatically every 12 hours with new data.

Tableau - Analysis on Pokémon & What Makes Them Powerful

This Tableau dashboard shows a snapshot of an analysis on Pokémon Total Power. The data used is from Kaggle and includes information from every Pokémon from Generation 1 through 7. The raw data was processed in order to clean it, normalise it and add calculated fields used in the analysis, including the Total Power metric. The goal of the dashboard is to find a correlation between a Pokémon Total Power and other traits – Legendary condition, size or Type.

📈 CASE STUDY: RESERVED LIST IN EUROPE

📈 CASE STUDY: POKÉMON POWER CORRELATION

🤖 { MACHINE LEARNING: PLAYER SENTIMENT }

In this GitHub repository you will find a machine learning project. The goal is to predict if a review of a game is negative or positive using an SVM model. You will find the training data and an additional, independent testing dataset to try the model.There’s no need to run the script to get the model – you can download it directly from the ‘data’ folder, load it with your favourite Python IDE and test it with any text you want.

📦 { MONTE CARLO SIMULATION #1 }

I have developed this MTG Box Generator is used to calculate estimated value of boxes for different sets. It uses modelling for statistical analysis and helps users to gauge if the retail price of a box compares positively with the potential cards inside each booster pack. This is key to understand how the market develops in the first few weeks after a new release.You can find the latest version of the Box Generator and the data to run it in my GitHub repository.

Lilibeth, the Thraben Inspector

🤖 { DISCORD BOT FOR MTG MARKET DATA }

With automation and AI being a very important part of the future's workplace, this Discord bot provides the users of Finanzas MTG with a self-service method to pull information from my database.The bot called Lilibeth, the Thraben Inspector has several features:
- Provides detailed instructions on how to use the tool via an intuitive interface with buttons and simple commands
- Deliver a list of the cards available to query and their sets
- Replies with simple data on how cards are performing in the market, including minimum price, trend price and stock
- Creates and distributes Excel files if multiple datapoints are requested from the user
- It is able to send a suggestion if the name of the card is slightly wrong, or if the date is not available

💰 FINANZAS MTG

Finanzas MTG was born as a simple data science project where I would gather data on Magic: The Gathering cards and predict price movements based on available stock of those cards. The initial goal was to include it in my portfolio, to showcase my programming and analysis skills. However, it has since evolved into a revenue-generating venture and developed into a full-stack data-processing tool that serves thousands of users every week.The ETL process put in place automates data gathering using Python scripts to compile and clean data from different websites. It is then stored in BigQuery for easy access and processing. Finally, the data is funnelled into Looker Studio to deliver striking visualisations and extract actionable insights - this way, users will understand a bit better if it's time to buy, hold or sell their MTG singles or sealed product. Moreover, the data is processed with Python to automate posts on Twitter or send emails to our users.

Space Ape

The Magic Behind Finanzas MTG

Finanzas MTG Flowchart

Designed & Crafted by Pablo Calvo with ♥ © 2024 All Rights Reserved.

Pablo Calvo - Analytics