SQL Analysis for orders Pizza Restaurant and Power BI Dashboard
-
Updated
Jul 24, 2024
SQL Analysis for orders Pizza Restaurant and Power BI Dashboard
Create and deploy an efficient data warehouse using Microsoft SQL Server tools, optimizing loading processes with SSIS for ETL workflows. Extend functionality with SSAS, SSRS, and pivot tables for in-depth analysis, enhancing insights through Power BI visualization.
MS SQL Database system created for "Restaurant Management". Developed in MS SQL Server 2019 Management Studio for 3rd grade(junior year) Database Systems course.
edX course Microsoft: DAT201x Querying Data with Transact-SQL
Develop and Deploy a Datawarehouse solution. Employed MS SQL Server Management Studio to build a data warehouse and increased data loading efficiency and Implemented MS SQL Integration Services (SSIS) to devise and execute ETL processes. BI II project, Building from the Data Warehouse a SSAS, SSRS, Analysis in pivot tables and Data Visualization
Microsoft SQL Server tools and utilities
The Personal Fitness Management System helps users track fitness routines, monitor progress, and manage food-intakes. It features a user-friendly interface, calorie tracking, manage workout activities, and data analysis tools. Built with Python, MySQL, and CustomTkinter , it's developed for my academic use.
Add a description, image, and links to the ms-sql-server-managment-studio topic page so that developers can more easily learn about it.
To associate your repository with the ms-sql-server-managment-studio topic, visit your repo's landing page and select "manage topics."