| | | | | | | |

A Dimodelo Data Warehouse Automation Case Study Podcast

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

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…

Build a Data Warehouse from Freshbooks (SaaS) data

[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

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…

Data Warehouse and Business Intelligence Concepts – Simplified

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….

Range Lookups in the SSIS Lookup Transformation

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…