GitPlanet

Cheap and reliable Node.js hosting starts at $3/month, and $1/month static HTML hosting

Created with love in Canada, visit hostnodejs.com today

Feel like to post an Ad? Learn Details
All Projects → stretcharm → SSIS-DB-Dashboard

stretcharm / SSIS-DB-Dashboard

Licence: other
PowerBI SSIS Catalog DB Dashboard

Labels

powerbissis

Projects that are alternatives of or similar to SSIS-DB-Dashboard

FlowViz
A Power BI template that provides easy to understand, actionable flow metrics and predictive analytics for your agile teams using Azure DevOps, Azure DevOps Server and/or TFS.
Stars: ✭ 150 (+172.73%)
Mutual labels:  powerbi
Power-Query-Excel-Formats
A collection of M code to get various formats from Excel sheets in Power Query
Stars: ✭ 43 (-21.82%)
Mutual labels:  powerbi
powerbi-vcs
WIP (properly) version control and collaborate on your *.pbi{tx} files
Stars: ✭ 78 (+41.82%)
Mutual labels:  powerbi
pbiworkshops
Training workshops for Power BI.
Stars: ✭ 238 (+332.73%)
Mutual labels:  powerbi
power-bi-embedded
Use Power BI Embedded to embed dashboards, reports, report visuals, Q&A, and tiles in your WordPress website.
Stars: ✭ 37 (-32.73%)
Mutual labels:  powerbi
BETL-old
BETL. Meta data driven ETL generation using T-SQL
Stars: ✭ 17 (-69.09%)
Mutual labels:  ssis
awesome-power-bi
⭐️⭐️⭐️ Awesome Power BI dashboards, visuals, development resources, learning materials and more 🔥🔥🔥
Stars: ✭ 61 (+10.91%)
Mutual labels:  powerbi
SSISMHash
SSIS Multiple Hash makes it possible to generate many Hash values from each input row. Hash's supported include MD5 and SHA1.
Stars: ✭ 32 (-41.82%)
Mutual labels:  ssis
Azure-DevOps
Data extraction and Power BI report that generate management informations about your Azure DevOps organization. Using Azure DevOps CLI and Azure DevOps REST API, PowerShell scripts extract data from Azure DevOps, store this information in an Azure SQL Database and shows them in a Power BI report.
Stars: ✭ 581 (+956.36%)
Mutual labels:  powerbi
mvp-monitor
📊 Microsoft MVPs Monitor
Stars: ✭ 30 (-45.45%)
Mutual labels:  powerbi
ModelAutoBuild
A framework for dynamically creating a tabular model based on an Excel template.
Stars: ✭ 43 (-21.82%)
Mutual labels:  powerbi
PowerQueryConnectors
A collection of data connectors for Power BI
Stars: ✭ 30 (-45.45%)
Mutual labels:  powerbi
pbila
Power BI Logs Analytics Starter Kit
Stars: ✭ 27 (-50.91%)
Mutual labels:  powerbi
datapackage-m
Power Query M functions for working with Tabular Data Packages (Frictionless Data) in Power BI and Excel
Stars: ✭ 26 (-52.73%)
Mutual labels:  powerbi
powerbi-embed-v2
Power BI Embedded with Custom Controls PoC
Stars: ✭ 34 (-38.18%)
Mutual labels:  powerbi
Federal-Business-Applications
US Government Business Applications Demo Repository
Stars: ✭ 103 (+87.27%)
Mutual labels:  powerbi
bank-statement-analysis
Flask application generating interactive visualisations from bank statements PDF documents
Stars: ✭ 31 (-43.64%)
Mutual labels:  powerbi
Data-Visualisation-libraries
A Repository consisting of various visualisation libraries and tools
Stars: ✭ 61 (+10.91%)
Mutual labels:  powerbi
SSISRabbitMQ
Custom SSIS Components for RabbitMQ
Stars: ✭ 37 (-32.73%)
Mutual labels:  ssis
PowerBI
This repository hosts well-written DAX formulas and tested Power BI PBIX samples with data sources.
Stars: ✭ 38 (-30.91%)
Mutual labels:  powerbi
View All Similar Projects ➔

SSIS-DB-Dashboard

PowerBI SSIS Catalog DB Dashboard

Intro

This SSIS Catalog DB Dashboard aims to show the progress, performance an problems with any SSIS projects running on your server. It collects data from a number of the key tables/views in the SSIS Catalog DB as well as current running jobs from msdb.

I bring in and summarise the data is at a variety of levels

  • Execution (Execution & Execution Summary)
    • The Package that is Executed First which I've named RootPackageName. This includes the Project & Folder
  • Package (Executable Package Stats)
    • Package Summary. I group Packages by Types e.g. Master/Dimension/Fact/Stage/PostProcess. You can customised these in the PackageTypes Table. Click Advanced Editor to change it.
  • Executable (Executable Stats)
    • Items inside the Package e.g. Tasks/Data Flows/Containers. I also call this level Package Steps

Data is also shown for Currently Running Packages and SQL jobs. You can refresh this individually to get quick updates. This dashboard also provides details of any package errors and maps them to the Microsoft IS Error Reference Names. Individual Executions can be viewed as a text based Gantt chart or as a matrix of executions by time slices. I also extract row counts from the SSIS data flow messages to complement the duration based dashboards Finally I extracted the Hierarchy from the execution paths to make a Network diagram and Sankey to visualise the structure and levels in an SSIS project/

I've tried to keep the custom visuals to a minimum but I have used Sankey/Network Navigator as well as the OKViz Bullet and Sparklines. The PowerBI is blank with that needs the server parameter setting to your SSIS db server before applying the changes and granting permissions.

Release Notes

v1.3 -Improved query on Executions and Executables

  • Added Include fields for the Package types to configure the Master & Package Page filtering. Edit PackageTypesUse Query to configure.
  • Changed Package filters
  • Add Date, Start, Execution ID Hierarchy to the Master and Package Pages
  • Added Preserve Layers Bookmark to help avoid window coming to the front
  • Remove Optional Job Server Code
  • Add Icon Ribbon and Help Page.
  • Minor Fixes

Forum Post http://community.powerbi.com/t5/Data-Stories-Gallery/SSIS-Catalog-DB-Dashboard/m-p/244677

Templates for the package can can be found here. https://github.com/stretcharm/SSIS-DB-Dashboard

Thanks to the providers of the following pages that I've used to help in the making of this dashboard.

https://blogs.msdn.microsoft.com/sql_pfe_blog/2017/04/18/ssisdb-reporting-with-power-bi/ Chris Schmidt

https://www.excelguru.ca/blog/2015/01/28/creating-a-vlookup-function-in-power-query/ Ken Puls

Star Ratings Quick Measure http://community.powerbi.com/t5/Quick-Measures-Gallery/Star-Ratings/m-p/166903#M12 Chris Webb

https://ssisreportingpack.codeplex.com/ Jamie Thomson

Lots of Dax help and great OK Vis PowerBI Visualisations http://www.sqlbi.com/

SSIS Catalog DB https://docs.microsoft.com/en-us/sql/integration-services/service/ssis-catalog

Reza Rad's Article on the SSIS Catalog http://www.rad.pasfu.com/index.php?/archives/75-SSIS-Catalog-Part-3-Folder-Hierarchy;-Folder,-Projec... DB Diagram http://www.rad.pasfu.com/ssis/ssiscatalogpart3/5.png

SSIS Error Codes https://docs.microsoft.com/en-us/sql/integration-services/integration-services-error-and-message-ref...

Note that the project description data, including the texts, logos, images, and/or trademarks, for each open source project belongs to its rightful owner. If you wish to add or remove any projects, please contact us at [email protected].