Welcome To Our Data Analytics Blog
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.
Building a Data Warehouse: Populating and Using a Junk Dimension
A junk dimension is seen occasionally inside of data warehouses. This type of dimension can be thought of as a flag table, or a collection of attributes that have low-cardinality. In this post, we show you how to build a data warehouse by populating a junk dimension.
SQL Shootout: In-Memory Tables vs. Disk-Based Tables (Round 2)
In Part 1 of our investigation into In-Memory Tables, we saw how changing a Hash Index to a regular Nonclustered index of a sample database table improved the performance of our Select operation. In this article, we take a deeper dive into the types of indexes we can apply to memory optimized tables, focusing on the more common hash and nonclustered indexes.
For the SQL Craftsman: Date Matrix Aggregation
The SQL Date Matrix tool is a business intelligence tool that has its purpose, but is often left on the shelf to be slowly covered in dust and ultimately forgotten. But to the business intelligence expert, the SQL Date Matrix is an invaluable solution when used in the right situation.
How To Inventory Your Sharepoint Content
In this post, we guide you step-by-step on how to inventory your SharePoint content.
Managing Permissions with SSRS Data Alerts in Sharepoint 2013 On Premise
Anyone that has lived on the Admin side of even the smallest of SharePoint 2013 on premise environments has probably come across some of the many interesting “out of the box” permissions scenarios. In this post, we show you how you can overcome difficult permission scenarios that are causing your team headaches.
Recapping 5 Brilliant Presentations From SQL Saturday
SQL Saturdays are always great events to attend. In this post we share some knowledge gained from a recent SQL Saturday in Atlanta…
How to Execute a SSIS Package within a SSIS Script Task
Kicking off an SSIS package from within a Script task ended up being harder than we thought, but it can be done. In this post, we take you step-by-step through the process of executing a SSIS package within a SSIS Script Task.
3 Growing Trends in the Business Intelligence Industry
The business intelligence (BI) industry has really taken off in the last few decades, where more and more businesses are realizing the tremendous value in having a great business intelligence solution. With this exponential growth, BI strategy and implementation is constantly evolving. Three major trends that the industry is currently experiencing are…
Comparing Azure SQL Database to SQL Data Warehouse
Have you wondered what the difference is between Azure SQL Database and Azure SQL Data Warehouse? In this post we highlight the key differences between the two Microsoft product offerings and point out what you need to know.
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