Business intelligence development for Nike report challenge.
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.
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.
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.
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.
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.
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:
