Welcome To Our Data Analytics Blog
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…
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.
Get our latest analytics content straight to your inbox
Key2 Consulting | info@key2consulting.com | (678) 835-8539