Business intelligence development for Nike report challenge.

Service Data & Analytics
Year 2022

Developed by

Project

We created this Nike report as part of a BI hackathon – it is not affiliated with Nike.

Overview

Business intelligence development demo that uses free open-source data to produce an ecommerce shop effect and delivers aesthetic insights in the form of an executive report.

Business Intelligence Development

This Nike report was developed as part of a BI hackathon and is not affiliated with Nike.
The dataset is available on DataWorld and contains Nike footwear from the 2020 website.

 

The Challenge

Develop a BI report that has functionality like an online shopping experience. Build in organisational insights, an executive summary with narratives, and keep the report brand focused.

 

Our Solution

We built a Nike business intelligence report that was design focused, pulling resources and inspiration from the Nike website.

 

The theme.

We researched the brand, sub brands and company, and created the report colour palette from the Nike website, and brand guidelines found online.

Our starting point after data analysis and testing, was to create the UIUX and cover images. We researched past Nike advertising and found some that we liked. One being the “kiss my airs” adverts, so we started there, and created the cover images including the slogan.

Nike kiss my airs advertising
Nike – original kiss my airs advertising graphic

 

The ecommerce element

We used images of Nike trainers to create a product viewer, taking inspiration from the current website. The slider worked with HTML visuals and parameters to enable the user to view product images based upon their selections.

nike jordan mid se power bi
eCommerce Image Navigator

 

Google fonts were used to mimic the Nike fonts, brought into Power BI using HTML5 and CSS visuals, connected to the Google font Api.

The HTML visual was also used to help display some of the images.

nike html images html5
HTML visual usage

 

Executive summary

The executive summary was achieved by using additional free data sources to provide extra substance to the report. We found manufacturing information, historical stock market data, and revenue data from free data science sources online.
Dynamic narratives were added providing a written summary, with overall high-level numbers.

nike exec overview 1
Executive overview page

 

Additional pages

Additional pages were created to provide detail on the manufacturing locations and factory dynamics, footwear performance by price and reviews, and historical company and stock performance.

nike footware performance overview 1
footwear performance report

 

nike company performance overview 1
Stock & revenue report

 

nike manufacturing overview 1
Manufacturing report

 

Finally, we added a pop-up on the home screen with all information of data sources and other info. Please check out the popup inside the full report if you would like to get the data.

 

Full report

Click here to see the full report in Power BI

 

Share:

Want to see more?

Our site uses cookies to distinguish you from other users of our site. This allows us to provide convenient viewing of our site, and also allows us to improve it. In order to continue working with the site, you need to accept the terms. Cookies policy

No thanks
Accept cookies