Welcome To Our Data Analytics Blog
How To Build and Analyze a Survey with PowerBI
A how-to guide for using Microsoft Excel Forms + Microsoft PowerBI as a simple and effective solution to build surveys and analyze the results.
Our 2019 New Year’s Business Intelligence Resolutions
In this article, several of our business intelligence consultants share their Key2 2019 New Year’s resolutions.
Custom Visuals with Microsoft’s Power BI
Did you know that Microsoft’s Power BI offers the ability to create (and share) custom visuals? This article shares what you need to know.
SQL Server 2019: Big Data Early Adoption Program Review
After taking part in the Early Adoption Program, here are our thoughts regarding the new Big Data features that are coming with SQL Server 2019.
PowerShell – How To Iterate Through Rows of Data Returned From a SQL Stored Procedure
Learn how to use PowerShell to iterate through rows of data that were returned from a SQL stored procedure.
Tales from Consulting – Part One: Software Development Environments
In this blog from our “Tales from Consulting” series, one of our Key2 consultants shares the value of having multiple environments in the code development process.
Key Takeaways from SQL Saturday Atlanta 2018
Didn’t get the chance to to attend the P.A.S.S. conference, SQL Saturday Atlanta 2018 – BI Edition? Don’t worry, we did. Check out this blog for all the best takeaways.
SharePoint Server 2019 Review: New Features, New Compatibility, New Challenges
A Key2 review of the new features, compatibility, and challenges coming with SharePoint Server 2019, based on the Public Preview released July 24th, 2018.
Paginated Reports with Power BI Desktop (Fantasy Football Edition)
We show you how to easily import data from a chart that spans multiple web pages using PBI desktop. And, you just might gain the upper-hand in your fantasy league!
How to Convert SSIS Package Deployment to Project Deployment
This blog is a how-to guide for upgrading your SSIS Package Deployment to Project Deployment, and includes methods to scale for large organizations.
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.
Get our latest analytics content straight to your inbox
Key2 Consulting | info@key2consulting.com | (678) 835-8539















