Eckhard Zemp
Business Intelligence, Lifehacks and Travelblog
  • Twitter
  • Xing
  • LinkedIn
RSS
  • Home
  • Zemp’s only
    • Support
  • Guestbook
  • Contact

SQL Server locking methods or the fight against dead locks

After the last Index blog post here another technical issue I recently thought to have solved. At least maybe for the next year until I find another solution. As you know I dropped all indexes of my data warehouse and therefore also unique constrains on my tables. The application should make sure that everything is […]

By ecki • Business Intelligence 0

How to build a Business Vault Satellite

At the last meetup I learnt that many people don’t know how to build a business vault satellite (or even that it exists!). Many are struggling to get the data into a Raw Data Vault. Persisting data from the source over time. On the market are a few solutions, which build Data Vaults nearly automatically. […]

By ecki • Business Intelligence 0

Universal Loading Pattern Reloaded

There was quite some noise, when I published last year my blog post about Universal Loading Pattern, a common view how to process data to any target. Be it a Data Vault Hub or a Fact table. Since then I have worked with this pattern happily without any incidents. Some time ago I thought, well, […]

By ecki • Business Intelligence 0

Data Warehouse Naming Conventions

As the amount of objects in my data warehouse is increasing, structuring them became an important topic. The goal is, that also new employees will grasp the content immediately. There are different naming conventions on the internet, but they usually just tell about prefixing objects. This is probably the easy part. How about structuring hubs […]

By ecki • Business Intelligence 0

The Hub-lemma (a.k.a. Hub Dilemma)

When I started to learn and work with Data Vault, I encountered the brilliance of hubs. It has taken me some time to adapt to the idea, that a hub can be loaded from more than 1 source system – if the Business Keys are well defined. Then I got my training and I still see […]

By ecki • Business Intelligence 1

OPTION(RECOMPILE)

Again, a technical topic for SQL Server. At the beginning as an analyst you are going to learn to write standard SQL queries to get your desired results. With time your skills evolve, and you learn how to optimize the queries, maybe using a temporary table or a common table expression. The more you learn, […]

By ecki • Business Intelligence 0

How to organize a Raw Data Lake

How many times did you hear in the last few years the words “Data Lake”? And how many times have you asked yourself how it should be organized? And how often did you ask Google for more information and didn’t get any valuable results and only funky buzzwords? I did a lot and found not […]

By ecki • Business Intelligence 0

Praise be to the LoadDate

The best invention in my Business Intelligence career is the adoption of the concept of having a LoadDate. This should be a post to give credit to Dan Linstedt and thank him for inventing Data Vault and introducing LoadDate. When I encountered the hub-and-spoke concept of Data Vault I thought, why on earth do I […]

By ecki • Business Intelligence 1

My indexing journey

The unprepared From my background as an accountant and controller I had by nature a good feeling for numbers. This helped me to understand, how to structure data. A couple of years ago when I started to work in a startup, I usually grabbed data directly from source systems to support our cause to tackle […]

By ecki • Business Intelligence 2

Recent Posts

  • SQL Server locking methods or the fight against dead locks
    11. April 2020
  • How to build a Business Vault Satellite
    18. Januar 2020
  • Universal Loading Pattern Reloaded
    30. August 2019
  • Data Warehouse Naming Conventions
    10. August 2019
  • The Hub-lemma (a.k.a. Hub Dilemma)
    13. April 2019
  • OPTION(RECOMPILE)
    30. März 2019
  • How to organize a Raw Data Lake
    10. November 2018
  • Praise be to the LoadDate
    21. Oktober 2018
  • My indexing journey
    1. September 2018
  • Timeline calculation for Satellite views
    16. Juni 2018
  • Love-hate relationship with WhereScape
    2. Juni 2018
  • Universal Loading Pattern
    7. April 2018
  • Pebble Template Release 1.0 for SQL Server
    3. März 2018
  • Virtual Data Warehouse
    27. Januar 2018
  • How to ensure development quality in WhereScape
    10. Januar 2018
  • Template: Fact
    7. Januar 2018
  • Template: Dimension
    6. Januar 2018
  • Template: Hub/Link
    17. Dezember 2017
  • Template: Satellite
    16. Dezember 2017
  • Template: History (DataStore)
    9. Dezember 2017

↑

© Eckhard Zemp 2023
Powered by WordPress • Themify WordPress Themes