Kevin Cao

Master's

Applied Mathematics

Restaurant Data Insights

- The objective of this project is to analyze data from Restaurants to uncover valuable insights and trends. Utilized Microsoft - SQL Server for data storage and management, and Power BI for data visualization, incorporating DAX expressions for advanced analysis. Integrated data from diverse sources via MS Excel, enhancing the robustness of insights derived from the comprehensive analysis - Roles and Responsibilities - Stored and Managed data stored in a Microsoft SQL server to ensure secure and efficient data handling - Utilized SQL server to perform data cleaning, ensuring the removal of inconsistencies and preparation of data for analysis - Conducted data transformation and normalization within the SQL - Performed complex SQL queries to derive valuable insights and uncover trends in sales, customer behavior, and operational efficiency - Developed a dynamic and interactive dashboard in Power BI to visualize key performance indicators (KPIs) and analytical results - Employed DAX expressions in Power BI to create calculated columns and measures for enhanced data analysis - Integrated data from various sources using MS Excel for preliminary data exploration and verification before SQL - Collaborated with the management team to understand their data need and tailor the Power BI dashboards to meet those requirements - Regularly updated and maintained the Power BI - Created dynamic and interactive dashboards using Power BI to present the analytical results in an accessible and comprehensible manner - Tools and Technologies used: Microsoft SQL Server, Power BI, DAX expressions, MS Excel