Welcome To Our Data Analytics Blog
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)!
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.
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.
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.
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.
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…
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.
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.
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.
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…
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…
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!
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.
How To Inventory Your Sharepoint Content
In this post, we guide you step-by-step on how to inventory your SharePoint content.
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.
Get our latest analytics content straight to your inbox
Key2 Consulting | info@key2consulting.com | (678) 835-8539