Want to learn SSIS project design principles that will streamline your ETL package deployment?
Download our eBook and start saving time and resources.
Data analytics is a constantly evolving landscape.
Keep your knowledge sharp and explore some of our recent content.
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…
The Different Career Paths in Business Intelligence (BI)
We may be biased, but here at Key2 Consulting we truly believe a career in business intelligence can be an amazing thing. There are different paths within the field that you can take to achieve your goals and encounter big opportunities to help you learn and grow…
Win Your Fantasy Football League Using Microsoft Power BI Desktop
If you’re like us, you love business intelligence. You love data, statistics, analytics, and numbers. And if you’re even more like us, you love fantasy football. In this post, we share a secret weapon you can use in your Fantasy Football leagues: Microsoft Power BI Desktop.
Standardize Your SharePoint Content With Managed Metadata
Managed Metadata is a SharePoint service that allows you to create common term sets to be used in your SharePoint site. These terms can be used to standardize the values that populate your list or library columns. In this article, we show step-by-step how to standardize your SharePoint content using Managed Metadata.
How I Got Started at Key2 Consulting
In this post, our very own Jason Bacani shares his story on how he got started with Key2 Consulting and what his experience was like!
Key2 Consulting | [email protected] | (678) 835-8539