In this episode, it is my pleasure to speak with John Johansen, Senior Vice President, Consulting Services Strategy & Innovation at Majesco, a leading provider of insurance solutions and services. He is a highly skilled consultant and data architect known for his ability to help insurers build effective data organizations. He is an entrepreneur who exited…
In this episode I have the pleasure of interviewing Yves Mulkers, a leading BI & Data Architect, social media influencer and founder of 7wData, a leading blog in the space. You can find Yves on LinkedIn at www.linkedin.com/in/yvesmulkers, on Twitter @YvesMulkers. Visit his blog for the best of curated content at www.7wdata.be. Click here to listen.
Join me for an informative discussion with Hans Michiels, founder and moderator of the Data Warehouse Automation Guide – DataWarehouseAutomation.Guide. Hans is an independent Business Intelligence and Data Warehouse consultant using Microsoft technology, working in the Netherlands. He has a special interest in Data Warehouse Automation and Metadata solutions. You can connect with Hans…
Join me for an enlightening conversation with Dr. Barry Devlin, regarded as one of the world’s leading authorities on business insight and data warehousing. He was responsible for the definition of IBM’s data warehouse architecture in the mid-1980s which in our view makes him the “Godfather” of the data warehouse . He is now founder…
In this episode, it is my pleasure to speak with Dr. Claudia Imhoff, a real rock star in our corner of the technology universe. She not only has the technical chops and but also an in-depth understanding of the business landscape. In 1992 she founded her consulting company, Intelligent Solutions, Inc., and in 2006 she…
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…
How do you gather requirements for a Data Warehouse/Business Intelligence project ? Typically, on a BI project, if you ask a business user, ‘what do you want’ you will get one of 2 responses. I don’t know. I want everything. Which are, effectively, the same thing… As much as it pains IT people to hear…
[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”] Use the defaultBufferSize setting to improve the throughput of SSIS package. Key things you need to know: Each component in an SSIS data flow is assigned a memory buffer. The default is about 10MB. When your source is a wide table (i.e. has many or large…
[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”] Dimodelo Data Warehouse Studio now allows you to extract only changed data from your source system, reducing load on your source systems and overall ETL duration. I.e. To do change data capture (CDC) at the source. Dimodelo Data Warehouse Studio now includes a managed…
[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…
