Welcome To Our Data Analytics Blog
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.
What It Takes to Be a Great Business Intelligence Consultant
What makes someone an outstanding Business Intelligence consultant? What does it take to provide superb Business Intelligence Consulting? We explain.
5 Best Practices for Microsoft Power BI
Are you using Microsoft Power BI? We highly recommend these 5 best practices when using the Microsoft product.
How to Execute and Store Transact-SQL (T-SQL) Query Results in a PowerShell Array
Read this post to learn how you can execute and store Transact-SQL (T-SQL) queries results in a PowerShell array.
How to Query Salesforce Data Directly From SQL Server
If you’re a business intelligence (BI) and/or data warehouse practitioner, chances are you’ve handled in the past or will do so sometime in the future. Incorporating sales data into business intelligence processes has become a key ingredient for successful BI for companies across the globe.
How The Cloud Has Changed Application Development & What It Means For Developers
As an application developer, it’s been interesting to reflect on how development methodologies have adapted as technology rapidly evolves. The central focus of the app dev world has already shifted several times over in just the 15 years I’ve been a professional developer. One major direction that much of app development appears to be heading towards is the cloud…
How to Log Scripts in PowerShell
PowerShell is a powerful language to use when completing repetitive tasks on a system. In this article, we show you step-by-step how to log scripts in Powershell…
Your Key2 Intro to Microsoft Azure Data Lake (ADL)
Trying to master Microsoft Azure can be a daunting task. In this article, we provide a light overview of Azure Data Lake and point out some key things to know about the tool.
How To Manipulate Data in Microsoft Power BI
An important part in preparing data for business intelligence is manipulating the data into usable standard formats. In this article, we show you step-by-step how you can manipulate your data in Microsoft Power BI.
How To Join Data In Power BI Desktop (Fantasy Football Edition)
Do you love Fantasy Football? In this post, we show you step-by-step how to join data in Microsoft Power BI. The data we use in our guide is Fantasy Football stats from the 2016-17 season…
Useful SQL Server Management Studio (SSMS) Keyboard Shortcuts
Keyboard shortcuts play an important role in increasing the productivity of any development environment. There are myriad shortcuts that are highly beneficial in SQL Server Management Studio (SSMS), and SSMS also allows you to easily add your own keyboard shortcuts. In this article, we show you several…
Getting started with SQL Data Warehouse (SQL DW)
As was mentioned in a previous blog post comparing the pros and cons of Microsoft Azure SQL Database versus SQL Data Warehouse, Microsoft announced at SQL PASS 2016 that they are offering a free, 1-month trial of SQL Data Warehouse. In this post, we wanted to take Microsoft up on their offer and show you how to get started using Azure SQL Data Warehouse (SQL DW)!
How to Create and Implement a SQL Date Matrix
In this round 2 article, we follow up on our first post about using the Date Matrix in reporting applications. Here we explain in detail more things you can do with the power of the Date Matrix, your next secret SQL weapon…
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
