Setting up Time Dimensions for Resolutions in a Star-Schema Setting Up Time Dimensions for Resolutions in a Star Schema A Comprehensive Guide Understanding the Problem In data warehousing especially with star schemas eff 2 min read 06-10-2024 11
Using a variable as the name of a flat file destination Dynamically Naming Your Flat Files Using a Variable for Destination Paths The Problem You need to create flat files like CSV or TXT that are named dynamically b 2 min read 06-10-2024 10
Inserting Frequently Updating fact tables to the data warehouse Streamlining Data Warehouse Updates Handling Frequently Changing Fact Tables The Problem Imagine you re building a data warehouse for an e commerce platform You 3 min read 04-10-2024 11
How to get the data for SAP Business ByDesign report aging list of debtors using API connections to the system How to Retrieve Aging List of Debtors in SAP Business By Design Using API Connections If you re looking to extract the aging list of debtors from SAP Business B 3 min read 24-09-2024 18
Attempting to build a Multi-fact Relationship model in Tableau - I don't seem to be given the option to add a second base table? Troubleshooting Multi Fact Relationship Models in Tableau Building a multi fact relationship model in Tableau can be a complex task especially when you encounte 3 min read 17-09-2024 28
How to handle data vault hubs with no business key? Navigating Data Vault Hubs Without a Business Key A Salary Statement Case Study Data Vault modeling offers a robust framework for data warehousing but it can pr 3 min read 05-09-2024 23
Azure Synapse/ Datawarehouse DML monitoring of tables Monitoring Data Changes in Azure Synapse A Guide to DML Tracking Migrating from Oracle ADW to Azure Synapse can be an exciting step for your data warehousing ne 4 min read 02-09-2024 12
3nf vs star schema (kimball) for silver layer/curated zone Navigating the Silver Layer 3 NF vs Star Schema in Data Warehousing In the world of data warehousing the silver layer also known as the curated zone plays a cru 2 min read 30-08-2024 13
How to import only the new data and new records that have changed using the ETL process in a data warehouse? Optimizing ETL Importing Only New and Changed Data Extracting transforming and loading ETL data into a data warehouse is a core process for many organizations B 3 min read 30-08-2024 17
DW/ BI dimension modelling, combining facts Combining Facts in Dimensional Modeling A Streaming Companys Dilemma Building a robust data warehouse DW and business intelligence BI system for a streaming com 2 min read 29-08-2024 23
Query Designer - SSRS Report - Restrict Parameters by Other Parameters Restricting Parameters in SSRS Reports A Guide to SSRS Query Designer When creating reports in SQL Server Reporting Services SSRS one common challenge developer 3 min read 28-08-2024 18
Choosing good approach to copy multiple tables in Azure Data Factory Choosing the Right Approach to Copy Multiple Tables in Azure Data Factory Copying hundreds of tables whether in full or as delta loads from a source to a target 3 min read 28-08-2024 20