Power BI

This project aims to showcase the storied journey of Real Madrid Football Club like never before with Real Madrid Legacy Insights, providing a unique perspective for stakeholders, analysts, and enthusiasts. It serves as a vital resource for strategic decisions, performance evaluations, and a deeper understanding of the club’s enduring excellence. Join us in reimagining football history through data – welcome to a new realm of insights that brings the Real Madrid legacy to life in unprecedented detail.

Overview

The main section of the dashboard presents global data on Real Madrid, covering various aspects such as:

• Over-All Performance: Win/loss ratios, titles per season, average scored goals and defeats by opponent.
• Ramos Mastery: Explore the defensive prowess of the legendary captain. This page highlights his match appearances, goals scored, defensive records, and trophies won.
• CR7 Beyond the field: Discover the astonishing achievements of one of the greatest forwards in football history. Detailed statistics on his goal-scoring records, assists, and awards, as well as his role in key victories, are showcased here.
• Champions League Legacy: This page is dedicated to highlighting the club’s remarkable achievements and memorable moments in the UEFA Champions League in the last decade, also explains why the UCL is so important for Real Madrid.

 

Feel free to explore the dashboard and uncover the stories behind the numbers. Whether you’re a fan, a researcher, or simply interested in football analytics, this dashboard offers valuable information and engaging visuals to enhance your knowledge of Real Madrid’s legacy.

I would like to express my heartfelt gratitude to Kendall González Solano for their invaluable support and dedication throughout this project. Their knowledge, patience, and willingness to collaborate have been essential to the success of our work. I couldn’t have achieved this without their help. Thank you!

My LinkedIn Profile: https://www.linkedin.com/in/ricardolizano/

Kendall González LinkedIn Profile: https://www.linkedin.com/in/kendall-gonz%C3%A1lez-solano-31a535203/

Power BI Dashboard:

The Customer Lifetime Value (CLTV) is a metric used in marketing and sales to calculate the economic value a customer brings to a company over the course of their relationship. This metric is important for several reasons:

Knowing the CLTV of customers allows companies to make more informed strategic decisions. For example, they can allocate resources more efficiently by targeting customers with higher CLTV and develop strategies to retain those customers over time. Additionally, it can help identify opportunities to increase customer value through additional sales, improved customer service, or loyalty programs.

“Satisfied customers are the best source of advertisement and the most valuable asset a company can have in terms of Customer Lifetime Value.” – Philip Kotler

CLTV can also be used to segment customers into high, medium, and low-value categories, allowing companies to tailor their strategies and actions specifically to each group. For example, high-value customers may receive preferential treatment or additional benefits, while low-value customers may be targeted with retention efforts or upselling to increase their CLTV.

In summary, Customer Lifetime Value is an essential metric that enables companies to understand the economic value each customer can generate over their relationship with the company. It helps them make strategic decisions, calculate return on investment, and segment customers more effectively, contributing to long-term growth and profitability.

Power BI Dashboard:

This project uses data from the best-selling smartphones in recent decades. The goal of the project is to identify market trends and provide useful information for brands that want to launch mobile devices in the future. The dataset it´s a result of a previous cleaning in python (details here). 

This PowerBI basboard aims to be a tool to identify the best time to launch a product on the market. It also provides historical details of market trends and brand behavior over the years.

PowerBI Dashboard: