Data Analysis

In this section I will showcase my projects that I consider as data analytics. As I use various ways to build dashboards or analyse data, this section will contain web, Excel and other projects. I just want to have a place where data analytics projects are displayed in one place.

Currently this section contains these projects:

• CHEP Pallets Report (Web App).
• CHEP Pallets Report Using Excel PivotTables.

CHEP Pallets Report (Web App)

A project I developed while working as a logistics administrator. I wanted to create a dashboard that would help identify unusual CHEP pallet transfers. This web app simply allows you to upload an excel file that contains transaction details, and using the data in this file it renders 4 charts that help observe CHEP pallet transfers.

CHEP Pallets Report Using Excel PivotTables

In this page I explain how I used Excel PivotTables and Excel charts to render similar chart to CHEP PALLETS REPORT (flickerbook.co.uk) monthly pallet transfers by supplier. I did two versions of this chart.