data & it depends
{ bitwise.exposed } is a blog about data engineering and data science
with focus on business intelligence and BI topics like
data warehouse, architecture, models, querying, performance metrics …
-
Analysis Service & Tabular
Services, Engines and models in an Analysis Service context … how is all that related? Terms are often used generally, inconsistently, interchanged or mixed up, which quickly makes the whole subject opaque and confusing. Therefore it’s worth to start at the top of the pyramid,…
-
Types of Fact tables
In the context of data warehousing and business intelligence, there are three main types of fact tables based on the nature of the data they store and the business processes they represent. Transactional Fact Tables Transactional fact tables serve as the bedrock of data warehousing,…
-
Facts and Dimensions
Fact tables serve as the central repository for business facts, while dimension tables categorize and add meaning to the data through descriptive attributes, forming a key component of dimensional modeling in business intelligence.
-
Dimensional Modeling Introduction
Dimensional Modeling is a key componend of designing effective data warehouses. This is an introduction, to the most important topics.
-
Create #TempTable with T-SQL
Microsoft SQL Server (T-SQL) offers a convenient way with the ‚INTO‘ statement to create a temporary table and populate it with the results of a query in a single statement.
-
Accurate percentages with row-level security
Pattern to compute ratios, when data is hidden by row-level security.
-
-
What is Data & Data Science?
Let’s break down the terms data, data science, business intelligence, and analytics to understand their meanings and relationships: Data Data refers to raw facts, figures, and statistics collected for analysis. Types of Data Structured Data: Organized and easily queryable data, often found in databases. Unstructured…
-
Current Period: avoid reporting issues
Abstract, from a SQLBI article. Link to the original article on SQLBI.com click here https://sql.bi/817168. I just could recommend to read every single article from SQLBI, Alberto Ferrari XOR Marco Russo in full length. Below some key pattern and notes from my side as my…
-
AzureDevOps: wiki
Azure DevOps Wiki written in Markdown the Pythonic way Azure DevOps > wiki is able to interpret HTML an Markdown. But what if you want to import tables into the Wiki? Please let me know, if there’s a better way, in the meantime this is…
