Glossary

Categories: Blog

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