Microsoft sql server

This project presents a centralized dashboard built on Microsoft SQL Server, designed to monitor key performance indicators, safety incidents, and operational data. It brings together paginated reports, datasets, and real-time metrics to support warehouse and inventory management.

The full build process is documented below, including how the database was structured, how queries were optimized, and how the reports and KPIs were developed and connected. This end-to-end approach demonstrates how SQL Server can be used to design an integrated monitoring solution that improves visibility and supports decision-making.

Final Result

Start of Process

Setting up firewall settings for port

Connecting to db

Querying People table

Working with layouts

Saving to access it on the SSRS online portal:

Creating a new dataset using query editor & detecting foreign key relationships

Writing T-SQL

Combining data with several tables

Hiding repeat values for purchase order ID

Creating a shared data source

Creating a new query

Stock items by group

Creating a warehouse matrix

Creating parameterized filters

Dynamic reporting with parameterized filter:

This isn’t the most ideal as you have to guess which colors are in the db. How about we give users the ability to choose instead of randomly trying to pick a color that might not be there?

Creating a variable title

Creating an action with a hyperlink

Creating parameter for viewing reports by year

Creating a linked action/parameter

Creating an interactive dropdown menu

Creating YOY comparisons with a chart with a parameterized value that will not affect the table, but will only affect the chart

Updated Chart

Creating visual gauges

Creating indicators

Creating a new dataset and query for taxes and yearly sales

Creating action steps to be able to link the report

Create sparkline chart with the report

Creating maps:

Finished result:

Creating joins

Creating stock list

Setting up page breaks so that every category has a page on its own:

Creating KPIs

Creating KPI status and KPI Goal

KPI Goals and currency editing

Adding branding colors and logo