Data Study on Fortune Global 500

Posted on Aug 6, 2016
The skills the author demoed here can be learned through taking Data Science with Machine Learning bootcamp with NYC Data Science Academy.
Contributed by Jiaxu Luo. He is currently in the NYC Data Science Academy 12 week full time Data Science Bootcamp program taking place between July 5th to September 23st, 2016.This post is based on his second class project - Shiny Application (due on the 4th week of the program)
This shiny app can be found :
All the code can be found through the link to Github

I. Introduction

Do you have any idea how the structure of world economy change over the years? Do you know how the giant companies in the industry you work for evolved and degraded over the years? Which companies in your industry is attracting increasing attention of investors?  My app based on Fortune Global 500 data over the years might give you an opportunity take a fresh look forward.

The Fortune Global 500, is an annual ranking of the top 500 corporations worldwide based on revenue. Every year,the list of companies is compiled and published by Fortune magazine.Since the current form we see today first published in 1995, the Fortune Global 500 has become the definitive study that both examines and defines the world business landscape. For the past decade, the world has witness rapid changes in industries. Benefiting from the technological progress , the process of marketing, integration, industrialization and globalization has been in an in an unprecedented rapid speed.  New economies has been coming up.

Industry structure has been redefined. Giant companies have come and gone. The dataset of Fortune Global 500, which spans from 2006 to 2015 (10 years in total), provides us a glimpse of how turbulent fluctuations were like over the years in the level of countries, industries and companies. The assumption here are those Fortune Global 500 companies joined into global competition and therefore the comparative market value fluctuation each year reflects the change of global business landscape.

Thanks to Financial Times--an English-language international daily newspaper specializing in business and economic news ,the dataset of Fortune Global 500 each year is freely accessible ( )

Variables of Interest

Company: Name of a Fortune Global 500 company
Country:  The country the the company registered
Market.value..m: The revenue of the company by year (unit: million dollars)
Sector: The industry the company belongs to
P.e.ratio:  An indicator to reflect the prospect of a company for higher growth by investors
Year: The year that the the company was included in the list

II. App Design

Input: Users are allowed to select any combination of year (from 2006 to 2015 ) and industry of interest
Output: The output consists of three sections
(1)Geographical distribution of an industry of interest at country level in a specified year
(2)Market value composition of an industry of interest in a specified year
(3)Comparison of market value and P/E ratio between companies in a specified year and industry

Data on Geographical distribution

The first tab of the application allows users to explore the geographical distribution  of Fortune Global 500 companies of an industry in a country level in a specified year. The assumption here is that the number of Fortune Global 500 companies fluctuations reflect the growth status of industry in the specific country. The following  example demonstrates how to draw insight from this tab.  Here we specify banking industry and explore year 2006 and 2012 respectively.
At the first graph, we would see back in 2006, the banking industry was most prosperous in North America, contributed by Canada and US. However, when time came into 2012, we can see  more Asian countries were playing an  important role, especially those countries around Asian-pacific area, including China, Malaysia,Indonesia,Thailand,etc. The finding surprisingly match the reality that the the rise of Asian-pacific economies has been challenging the once dominant role of North America. We also see India and Brazil's banking industry growed rapidly. It's no wonder they are among BRICS countries.
 Data Study on Fortune Global 500
Data Study on Fortune Global 500

Composition of an industry

The second tab of the application allows users to explore the composition of market value of an industry year by year. The assumption here is the fluctuations of order of composition by market value reflect the general trend of industry evolution and degradation. The darker the rectangle, or larger the rectangle, the higher the market value of that industry as compared with others'.
The following  example demonstrates how to draw insight from this tab.Here users are allowed to specify a year of interest and get a glimpse of what the business landscape looked like in the year. From 2007 to 2014, we noticed the software industry, which was once no match for hardware industry, had been gaining momentum and finally surpassed the hardware industry in the composition of market value, indicating the higher acceleration of growth of software industry than hardware industry over the years. If you are interested in deeper exploration of the countries that contribute to the industry most, click the rectangle to see what they are.
Data Study on Fortune Global 500

Companies comparison Data

The third tab of the application allows users to explore the market value and P/E ratio between companies. On the left hand side of the output is the bubble chart, where the size of the bubble represents the market value of a company in a particular year.The color gradient also facilitates the identification of the rank orders. On the right hand side is the bar chart of P/E ratio in descending order. P/E ratio indicate the value a company for investment. The higher the P/E ratio, the higher growth speed you could expect.
The following is an example to demonstrate the insight got from this tab. Back in 2006, when "Apple" was still called "Apple Computer", Cisco and Intel were leading the industry. It is worth noticing that in 2008, Apple's P/E ratio jumped to the highest, probably due to the launch of iphone - a revolutionized product at the time. Apple has been keeping its competitive advantage  since that time and by 2015, it has become a dominating and unrivaled giant in the industry.


The Data tab allows users to search for a company list ranking by Global rank in ascending order by specifying a combination of year and industry of interest. The users can also use the search box to identify the information they want to see more quickly.

III. Conclusion

Hopefully, this shiny app would help you to explore the shift of industries  among countries, the ups and downs of industries in the global economies, and substitution of big companies by their challengers. To some degree, it helps  you to get a glimpse of how rapidly our world has been changing. There are rich stories awaited for you to explore.

About Author

Jiaxu Luo

Jiaxu Luo is a recent MS graduate from Columbia University. As a child born in a business family and a student with diverse academic background in Material Science and Chemical Engineering, he grasps the importance of asking questions...
View all posts by Jiaxu Luo >

Leave a Comment

No comments found.

View Posts by Categories

Our Recent Popular Posts

View Posts by Tags

#python #trainwithnycdsa 2019 2020 Revenue 3-points agriculture air quality airbnb airline alcohol Alex Baransky algorithm alumni Alumni Interview Alumni Reviews Alumni Spotlight alumni story Alumnus ames dataset ames housing dataset apartment rent API Application artist aws bank loans beautiful soup Best Bootcamp Best Data Science 2019 Best Data Science Bootcamp Best Data Science Bootcamp 2020 Best Ranked Big Data Book Launch Book-Signing bootcamp Bootcamp Alumni Bootcamp Prep boston safety Bundles cake recipe California Cancer Research capstone car price Career Career Day citibike classic cars classpass clustering Coding Course Demo Course Report covid 19 credit credit card crime frequency crops D3.js data data analysis Data Analyst data analytics data for tripadvisor reviews data science Data Science Academy Data Science Bootcamp Data science jobs Data Science Reviews Data Scientist Data Scientist Jobs data visualization database Deep Learning Demo Day Discount disney dplyr drug data e-commerce economy employee employee burnout employer networking environment feature engineering Finance Financial Data Science fitness studio Flask flight delay gbm Get Hired ggplot2 googleVis H20 Hadoop hallmark holiday movie happiness healthcare frauds higgs boson Hiring hiring partner events Hiring Partners hotels housing housing data housing predictions housing price hy-vee Income Industry Experts Injuries Instructor Blog Instructor Interview insurance italki Job Job Placement Jobs Jon Krohn JP Morgan Chase Kaggle Kickstarter las vegas airport lasso regression Lead Data Scienctist Lead Data Scientist leaflet league linear regression Logistic Regression machine learning Maps market matplotlib Medical Research Meet the team meetup methal health miami beach movie music Napoli NBA netflix Networking neural network Neural networks New Courses NHL nlp NYC NYC Data Science nyc data science academy NYC Open Data nyc property NYCDSA NYCDSA Alumni Online Online Bootcamp Online Training Open Data painter pandas Part-time performance phoenix pollutants Portfolio Development precision measurement prediction Prework Programming public safety PwC python Python Data Analysis python machine learning python scrapy python web scraping python webscraping Python Workshop R R Data Analysis R language R Programming R Shiny r studio R Visualization R Workshop R-bloggers random forest Ranking recommendation recommendation system regression Remote remote data science bootcamp Scrapy scrapy visualization seaborn seafood type Selenium sentiment analysis sentiment classification Shiny Shiny Dashboard Spark Special Special Summer Sports statistics streaming Student Interview Student Showcase SVM Switchup Tableau teachers team team performance TensorFlow Testimonial tf-idf Top Data Science Bootcamp Top manufacturing companies Transfers tweets twitter videos visualization wallstreet wallstreetbets web scraping Weekend Course What to expect whiskey whiskeyadvocate wildfire word cloud word2vec XGBoost yelp youtube trending ZORI