Project Overview: This project focuses on analyzing the sales performance of a pizza shop using a combination of SQL for data querying and Microsoft Excel for data visualization. The goal is to derive ...

I consider myself an Excel poweruser. I program in it daily (20ish hours a week) and manage a few thousand lines of code for my personal use (stocks and finance). Outside of Excel, I know very little ...

I would like the user to be able to click a button on the web page that will run a SQL query (canned report) and export the result data to an Excel spreadsheet. The data does not need to display on ...

The application runs on port 8081 by default. To change the port, modify server.port in src/main/resources/application.properties. Converts an Excel file to SQL ...