2023

Supply Sync

Project analyzing data to understand the strengths and weaknesses of an import-export company. Dataset processing with Python scripts and Power BI ETL. Power BI report, summary, and conclusions.

Line illustration: a container ship, dashed arrows into a report page with a bar chart and a line chart, the tallest bar in red

fig. 01 · Illustration. Import-export flows into a report

Supply Sync is a data analysis tool for import-export. It enables visualization of logistics flows and identification of bottlenecks through Power BI.

Python and Power BI ETL

Line illustration: a stack of spreadsheet sheets passes through three funnels in a row and comes out as a single table, one red row in the table

fig. 02 · Illustration. From raw sheets to one clean table

The import-export company's datasets were processed with Python scripts and Power BI's ETL before analysis.

Power BI report

Line illustration: a report page with two columns of lines, up arrows on the left and down arrows on the right, and a bar chart whose tallest bar is red

fig. 03 · Illustration. Strengths and weaknesses on the scale

A Power BI report, a summary and conclusions to understand the company's strengths and weaknesses: visualizing logistics flows and identifying bottlenecks.

Technologies

Python · Power BI · ETL