SSIS Data Streaming Destination to Power BI

  •   December 15, 2016

Utilizing the SSIS Data Streaming Component to process Tabular Data for Power BI Prerequisites: WideWorldImporters Data warehouse Copy SQL Server 2016 Power BI Desktop Visual Studio 2015 Data Streaming Destination...

Talavant’s Meet Our Consultants Series Featuring: Dave DuVarney

Molly Gallmeier   •   October 21, 2016

Meet Talavant’s President, Dave DuVarney. Dave has spent spent most of his career in consulting. He quotes, “I really love it.” He actually started in Accounting, but quickly realized he...

Document Maps in SSRS

Arthur Wang   •   October 13, 2016

What’s a document map? A document map is an interactive feature of an SSRS report that can generate a hierarchy of links that you can use to navigate the report. The document...

Biml – Intro (Truncate and Load)

  •   October 6, 2016

This will be an ongoing tutorial working with T-SQL, SSIS, Biml, and C#. The primary purpose of this series will be to first introduce you to some of the formal...

Talavant’s Meet Our Consultants Series Featuring: Sean Forgatch

Molly Gallmeier   •   September 29, 2016

Meet one of Talavant’s Consultants, Sean Forgatch. Prior to starting a career at Talavant, Sean has worked as an ETL Engineer and Consultant in the Healthcare and Insurance industries. While...

Foundational Data Warehouse– Testing Phase

Jess Rabida   •   September 22, 2016

Continuing the blog series, Foundational Data Warehouse, we will be taking a closer look into the next foundational building block which is the Testing phase. The primary objective of this...

Talavant’s Meet Our Consultants Series Featuring: Gill Rowley

Molly Gallmeier   •   September 20, 2016

Meet one of Talavant’s Senior Consultants, Gill Rowley. Gill has been around data for the majority of his career. Working as a DBA for quite some time before transitioning to...

Talavant’s Meet Our Consultants Series Featuring: Jess Rabida

Molly Gallmeier   •   September 13, 2016

Meet one of Talavant’s Architects, Jess Rabida. Jess has worked as an Architect Lead in BI for quite some time, and has been responsible for overseeing the strategic direction, of...

Bench Time – How to Make the Most of It

  •   July 29, 2016

You’ve just finished up Phase I of a project at a client, but the budget for Phase II hasn’t been approved yet. You have no other clients in the pipeline...

Foundational Data Warehouse – Design Phase

Jess Rabida   •   July 21, 2016

Continuing the blog series, Foundational Data Warehouse, we will be taking a deeper dive into the next foundational building block which is the Design phase. Hopefully, by the end of...

Time Management in a Start-Up

Molly Gallmeier   •   June 24, 2016

For those of you who read my first blog, “Reward Outweighing Risk – My first year at a Start –Up” you all know that this whole new company/start up world is rather...

Generating Parameterized Attunity Queries with Biml

Arthur Wang   •   June 2, 2016

Before you continue: if you’re already familiar with Biml, the Attunity connector, and using SSIS variables for SQL commands, you can skip to the “Custom Properties” section. Everything else is...

Newsletter Signup