Welcome To Our Data Analytics Blog
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.
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.
Get our latest analytics content straight to your inbox
Click the button below to subscribe today.
Get our latest analytics content straight to your inbox
Click the button below to subscribe today.
Key2 Consulting | [email protected] | (678) 835-8539