GlossaryPublish date: Sep 21, 2017
Idempotent – something that is repeatable, that remains unchanged in value when repeatedly executed either independently or on by itself.
SSRS – SQL Server Reporting Services part of Microsoft SQL Server. Used to deliver static reports that can be viewed via a web browser and exported to a number of formats including Excel, PDF and CSV.
SSAS – SQL Server Analysis Services part of Microsoft SQL Server.
SSIS – SQL Server Integration Services part of Microsoft SQL Server. Originally designed as a ETL tool to build a data warehouse but has expanded and is able to automate a number of SQL Server related tasks.
PowerBI – Power BI is a business analytics service provided by Microsoft. It provides interactive visualizations with self-service business intelligence capabilities, where end users can create reports and dashboards by themselves, without having to depend on information technology staff or database administrators.
Kimball -A methodology for data warehousing also known as dimensional modeling authored by Ralph Kimball.
C# – C sharp is a general-purpose, object-oriented programming language developed by Microsoft.
PowerShell -is a task automation and configuration management framework from Microsoft, consisting of a command-line shell and associated scripting language built on the .NET Framework and .NET Core.
MIS – Management Information System
MI – Management Information
BI – Business Intelligence
SQL – Structured Query Language