Nov 15, 2017 | Microsoft, SQL Server, SSIS
By: Matt Wollner Sr. BI Consultant In all of the SSIS packages that we develop, we include an auditing and logging framework. This framework consists of adding Event Handlers to the package, such as OnError, OnPreExecution and OnPostExecution. ...
Nov 9, 2017 | Conferences, Microsoft, SQL Server
By: Jason E Bacani BI Consultant I was honored to be among the folks heading to Seattle to attend PASS Summit 2017, representing Key2 Consulting from November 01 – 03. Our schedule included three formal days at the conference from Wednesday through Friday,...
Oct 23, 2017 | Data Visualization, Featured, Microsoft, Microsoft Power BI, Technical Information
By: Ken Adams Sr. BI Consultant In this article, I am going to dive into Power BI and show you the new Timeline Storyteller visualization. This is a custom visualization for Power BI that can be found at the Office Store. I will later show you how to add it to...
Oct 16, 2017 | Data Encryption, Data Security, SQL Server
By: Anvesh Vallabhaneni BI Consultant IHG, Arby’s, Chipotle, University of Washington, Anthem / Blue Cross Blue Shield, Verizon, Equifax, SEC, Deloitte, Whole Foods – these are just a few popular names on a long list of companies that had a data breach this...
Oct 9, 2017 | Business Intelligence, Consulting
By: Paul Schuliger What makes someone a great Business Intelligence consultant? Is it the fact that they know Business? Or are they bringing a vast amount of Intelligence to the job that no one else has? Or is it that they are a leading expert in a field...