Project description DWH PROJECTS

Microsoft development, database development and database administration, web portals and OO development...

Data warehouse concepts

DWH development process


  • Data modeling: Designing the logical and physical structure of the DWH based on the business requirements and the available data sources.
  • Data extraction: Extracting data from the source systems using various methods such as batch, incremental, or real-time.
  • Data transformation: Transforming the extracted data into a consistent and standardized format that is suitable for loading into the DWH.
  • Data loading: Loading the transformed data into the DWH using various techniques such as full, incremental, or delta load.
  • Data quality: Ensuring the accuracy, completeness, and validity of the data in the DWH using various tools and methods such as data profiling, cleansing, and validation.
  • Data access: Providing access to the data in the DWH for various users and applications using various tools and methods such as reporting, dashboards, analytics, and visualization.

Microsoft SQL Server DWH Developer / Consultant - Microsoft SQL Server T-SQL, SSIS, SCCM