Data Warehouse and Business Intelligence Concepts – Simplified

ByAdam Gilmore Updated on

10 Page Guide – Free PDF Download.

Download our free PDF Guide to Data Warehousing and Business Intelligence Concepts.

The Guide covers Basic concepts of Data Warehousing including:

  • Facts, Dimensions, Star Schemas and Data Warehouse Design.
  • Definitions – Business Intelligence vs Data Warehouse vs Data Mining etc.
  • Extract Transform and Load (ETL).
  • OLAP and Cubes.
  • Slowly Changing Dimension Types 1 and 2 Explained.
  • Data Warehousing Tools.
  • Introduction to Business Intelligence and its applications, with examples.

Update: You can now access our free online course – Kimball Dimensional Data Warehouse Course, which covers everything in the document plus a lot more. 

Adam Gilmore

Adam Gilmore is a Data Architect with 20 years' experience in the Data field. He writes for dimodelo.com and develops courses covering Data Analysis to Data Architecture.

Similar Posts

| | | | | | | |

A Dimodelo Data Warehouse Automation Case Study Podcast

ByMike Rabinovici

Talking Analytics Platform Services with Ashley Furniture’s Data Architect Phil Haddad, and Microsoft’s Principal Program Manager in the Azure SQL Data Warehouse team, Matt Usher.  In this podcast we discuss: Refractoring an exising data warehouse Automating data warehouse development in an enterprise environment with 700 applications Migrating to Azure Data Warehouse from PDW/APS The role Microsoft Partners…

Understanding Visual Studio 2015 licencing for BI developers

ByAdam Gilmore

The latest version of SQL Server Data Tools (SSDT), unlike previous versions can be installed either standalone or as a plug-in to existing an Community, Professional or Enterprise version of Visual Studio 2015. This guide helps you understand if you need/want to licence Visual Studio 2015 with SSDT for Visual Studio 2015. To set up a…

Range Lookups in the SSIS Lookup Transformation

ByAdam Gilmore

Let’s say, in an SSIS Data Flow which is processing invoices, you wanted to match an invoice to an event based on the date of the invoice falling between the start and end date of the event. To achieve this in a SSIS Lookup Transformation, you need to use advanced configuration. The configuration steps required follow: On…

Build a Data Warehouse from Freshbooks (SaaS) data

ByAdam Gilmore

[et_pb_section admin_label=”section”][et_pb_row admin_label=”row”][et_pb_column type=”4_4″][et_pb_text admin_label=”Text” background_layout=”light” text_orientation=”left” text_font_size=”14″ use_border_color=”off” border_color=”#ffffff” border_style=”solid” custom_margin=”0px|||”] This video demonstrates using Dimodelo Data Warehouse Studio (a data warehouse automation tool) to generate a data warehouse using Freshbooks as a source. Freshbooks is a SaaS provider for timesheets and invoicing. Using ODBC drivers (like those provided by CData) Dimodelo Data Warehouse…

Dimodelo Data Warehouse Studio adds batch monitoring and analysis

ByAdam Gilmore

The following enhancements have been made in Dimodelo Data Warehouse Studio 2015 2.9: Monitor and Analyse your ETL batches. Dimodelo now writes its ETL batch execution log to an SQL Server database. New PowerBI dashboards have been created to help you monitor and analyse your ETL batches. Support for ODBC Sources. Connect to just about…

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.