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…

Is Data Warehouse Automation good for BI Professionals?

ByAdam Gilmore

As professionals, anything that makes our job significantly easier, can be conceived as a threat. I must be honest, when Microsoft started on its journey of ‘Self Service BI’, PowerPivot, PowerView etc, I perceived this as a threat, and as a watering down of my skillset. However there is two truths that you can’t get away…

Data Warehouse Automation – the next big thing

ByAdam Gilmore

Jet Reports have written an interesting article on Data Warehouse Automation. It appears this concept is gaining recognition. TDWI has also recognized the value of Data Warehouse Automation, as one of the emerging trends for 2015 and beyond. I’ve also written an introduction article on the who, what, where, when and why of Data Warehouse Automation….

|

Tutorial 1 – Getting Started

ByWayne Roberts

In this tutorial you will learn how to use Dimodelo Data Warehouse Studio to:

Create a new Data Warehouse project.
Create a connection to a Source System.
Use the Wizard to generate the Meta Data for a Data Warehouse and its Extract, Transform and Load processes (ETL).
Generate the code to create the Data Warehouse and Staging databases, and the ETL to move data from the source through to the Data Warehouse.
Deploy the code to the Server.
Execute the ETL batch.