Microsoft sql server

A comprehensive review of a Microsoft SQL Server project, tracking key performance indicators, database health, and operational metrics.

It delivers insights into server performance, query execution times, and potential bottlenecks, facilitating effective monitoring and optimization of your database environment.

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

contact

Linkedin


Facebook-f


Github


Twitter

maycooper.mc@gmail.com

650-285-0123

© 2024 All Rights Reserved.