The purpose of this portfolio is to demonstrate my data analytics skills, using SQL and visualizations, to solve business problems. This portfolio contains five fictional projects based on common real-world business problems that can be solved through data analysis to uncover useful insights and provide data-driven recommendations to address the business challenge.
Hello everybody, and welcome to my data analytics portfolio. My name is Kevin, and it's a pleasure to share it.
Each project follows the same simple process:
During this portfolio, I used MySQL to import and clean data, Power BI to create visualizations and tell a story through data, Visual Studio Code to store queries, and Power Query to transform data before creating visualizations when necessary.
<aside> 🛒
Project 1 – Lactose-free consumer analysis A supermarket chain wants to compare purchasing behavior for lactose-free vs regular dairy products.
</aside>
<aside> 📈
Project 2 – S&P 500 & VIX analysis Analysis of VIX and S&P 500 to understand whether volatility is key to assessing investment risk.
</aside>
<aside> 👥
Project 3 – Customer analysis Customer segmentation and geographic markets analysis to identify highest sales and profitability.
</aside>
<aside> 🏨
Project 4 – Hotel booking cancellation analysis Cancellation patterns and booking characteristics to reduce revenue loss and improve reservation management.
</aside>
<aside> 🏭
Project 5 – Warehouse and inventory optimization analysis Inventory and warehouse optimization to support closing a storage facility.
</aside>