To view raw code, please check the .sql file above
For a complete review (sql code, analysis, and visualization) please check the .pdf file above
The aim of this analysis is to focus on Adventure Works Cycles, a Microsoft fictitious company which manufactures and sell bicycles in North America, Europe, and Asia. I will analyze the Production department from 2011 to 2014 to gain insights on several aspects including total quantity produced by year, quantity by production unit, orders by product, and production units with highest and lowest production capacity.
Before performing the analysis, the data was collected through a public domain, then wrangled to make sure it’s cleaned, reliable and error-free. After that, I explored the different variables, proceeded to data visualization to better capture trends and insights and finally draw conclusion.
Tools: SQL, PowerBI