Excel tutorial: build a dynamic bump chart of the English Premier League

Source: www.benlcollins.com 

Find your team: See the history of each of the 47 teams in the Premier League here. In this post I’ll show you how to create a dynamic bump chart like the one above, using historical data for the English Premier League going back to 1992-93 when it was created. The chart shows you how successful Manchester United have been during the Premier League years: Looking through all the different teams, you get a sense of nostalgia when recalling some of the teams that vacated the Premier League a long time ago (I remember them from my childhood): Feels like a very long time ago, a bygone era, when Nottingham Forest were hanging out with the big clubs near the top of the Premier League. And here’s my own team, Liverpool, one of the world’s elite clubs struggling to regain the success of their glory days, yet to win a Premier League title. We came so close in 2013-14, but for one unfortunate slip at a crucial time, when we lost 0-2 to Chelsea at home. Click here to see the history of all 47 teams who have made an appearance in the Premier League.

Recent Posts

Will Marketplaces Disrupt the Data Analytics Industry?

Few weeks ago, I came across Rocketgraph. This is a new platform that offers custom reports based on cloud data sources. While the concept is not new, what sets this company apart is the reports & dashboards are sold to users in a marketplace. The platform brings the analytics buyers and sellers together and provides the infrastructure. For years, many vendors have promised custom out-of-the-box solutions. In a majority of cases, most businesses require significant customizations. Will a marketplace approach to analytics offer an intermediate solution with significant time & cost savings? I interviewed Rocketgraph co-founder Constantine Nikitiadis to found out. Take a listen.

The Limitations of Data and Benchmarks

Data visualization blogosphere is filled with great ideas and inspiration. What is missing is the candid conversations about the limitations of data. Unfortunately, finding quality content on this topic is like finding a needle in a haystack. So, when one of the greatest thought leaders in SaaS data world wrote on this topic, I feel obligated to share it with you. Here is Tomasz Tunguz on the limitations of data.

The Myth of Self-Service Analytics

Self-service has been a buzzword in the analytics industry for the last few years. While the self-service movement has been instrumental in bringing about rapid decision making and empowering business users get answers to their data questions, one has to be aware of the key skills still required. Stephen Few highlights this important foundation of building a data-driven culture.

5 Data-Driven Email Newsletters You Should Subscribe To

Subscribing to email newsletters written by experts on growth and analytics is a great way to learn. Here are five newsletters that stand out from the rest. Written by entrepreneurs, data scientists, growth marketers and venture capitalists, each one offers unique insight into the process of using data to make better decisions and build a better company.

Leave a Comment