Welcome To Our Data Analytics Blog
How to Deduplicate Data Using Fuzzy Logic in SSIS
Data doesn’t always match cleanly. In these cases, fuzzy logic can be an incredibly useful tool you can use to deduplicate and clean up your data.
Custom SSIS Logging and Auditing
Adding custom SSIS logging and auditing to your ETL process can be very beneficial – so much so that if your organization hasn’t added it to your ETL process yet, we highly recommend doing so.
Concepts of an Enterprise Data Warehouse (EDW)
We define what an enterprise data warehouse is, discuss both the alternatives to and the value on can bring, and detail a real-world example.
Machine Learning with R and SQL Server 2017
Learn about the fascinating machine learning capabilities of RevoScaleR and SQL Server and how you can use them to conduct machine learning!
Is Dimensional Modeling Still Relevant?
We share some quick insight as to whether dimensional modeling is still relevant to modern data management processes or not. The short answer? It certainly is.
Using SQL Window Functions – A Power BI Example
Learn how you can use SQL Window functions to properly order results in a report. In this post, we walk you through a client example that involved us working with a Power BI reporting tool.
SSIS Performance Tuning Overview
Learn more about how you can tune SSIS 2018 to enhance maximum performance. In this quick read, we mention concepts around SSIS control flow, the data flow task, and getting great performance results.
Basics of Responsive Web Design – Layout Decisions, Layout Logic, CSS Media Queries
Today’s great web & mobile applications are responsive on any and all devices, including different sizes. Learn about the basics of responsive web design.
How to Multithread the Execution of a Single SSIS Package with C#
Learn how you can use two SSIS packages to dynamically accomplish the extraction of dozens of tables to a flat file using multithreading in C#.
Testing Machine Learning With Microsoft Azure Custom Vision Service
In this Key2 post, we explore Microsoft Azure Custom Vision Service’s machine learning capabilities with an interesting experiment.
PASS Summit 2017 Twitter Feed Round Up – Part Two
In part 2 of our PASS Summit 2017 Twitter Round-Up, we share more fun tweets and action from the conference!
Event Handlers in Child Packages (SSIS)
If you ever work with Event Handlers and Child Packages, we highly recommend incorporating this time and resource-saving tip into your work.
PASS Summit 2017 Twitter Feed Round Up – Part One
PASS Summit 2017 was an amazing event. In this article, we describe the Key2 Consulting team’s first day at the conference!
Microsoft Power BI – Timeline Storyteller Visualization
Love data storytelling? We show you how to create and work with one of Microsoft Power BI’s newest custom visuals, the Timeline Storyteller.
Data Encryption – How Your Organization Can Prevent a Data Breach
Chipotle, IHG, Equifax – as time goes on, data breaches are becoming more ubiquitous. Here’s how your organization can use data encryption to protect itself from data breaches.
Get our latest analytics content straight to your inbox
Key2 Consulting | info@key2consulting.com | (678) 835-8539