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

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

Data Modeling

In my previous company I had been working on loading the data, preparing the data and creating directly dimensions and facts to be consumed by our analysts. This was tiresome and buggy as this style of modeling resulted in a lot of redesigns and re-engineering. In the meantime I learned different techniques to accomplish what […]

By ecki • Business Intelligence 0

Data Warehousing

In my profession as a Business Intelligence guy, it is my duty to get data from any source system into a managed system of data and deliver my users reliable and cleaned results, so that they can analyze the data and make the right decision based on them. How do we do that: As you […]

By ecki • Business Intelligence 0

Revive

My last blog post was published years ago. Since then a lot had happened. In the past I have blogged about travels, everyday observations and such things. Now I would like to blog about my profession and in English to reach a broader audience. In the last years I have been working in the area […]

By ecki • Business Intelligence 0

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 2026
Powered by WordPress • Themify WordPress Themes