Welcome To Our Data Analytics Blog
5 Tips for Setting Better Business Goals
What if we told you that the process of setting business goals was half the battle in realizing them?
How to View a JSON Response from a REST API (Uber Example)
REST APIs are a common way to exchange data across IT systems, and this article demonstrates how to view a sample REST API response from Uber, the peer-to-peer ride-sharing company.
Reporting with Amazon Marketplace Web Service (MWS)
Amazon Marketplace Web Service (MWS) provides a wide variety of reports that will help you make decisions, and in this blog post we walk through how to access and use those reports.
How to Upgrade to SQL Server Reporting Services 2016 in SharePoint 2013
Need help upgrading to SQL Server Reporting Services 2016 in SharePoint 2013? Check out our latest how-to guide complete with some troubleshooting tips based on our experience making the jump.
Testing Changes in SharePoint 2013 Enterprise Farm with SSRS Report Builder 2016
It’s always important as a SharePoint Admin to understand what effect an update to your system will have on your user base. And this is even more important if your user base is huge.
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.
Get our latest analytics content straight to your inbox
Key2 Consulting | [email protected] | (678) 835-8539