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.
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!
Sharing Is Caring – How To Share Your Power BI Reports
This post is part of our Power BI series and is a follow up to “Baby Steps: How to Create Basic Charts in Power BI Desktop.” In this post, we talk about how you can share your Power BI reports with your co-workers, because after all, sharing is caring.
Baby Steps: How To Build Basic Charts in Power BI Desktop
In part 1 of our Power BI series, we show you step-by-step how you can create basic charts in Microsoft’s Power BI Desktop.
Key2 Consulting | info@key2consulting.com | (678) 835-8539