Aug 28, 2017 | How To, Salesforce, SQL Server, Technical Information
By: Jeff Levy Data Warehouse Developer @ Key2 Consulting If you’re a business intelligence (BI) and/or data warehouse practitioner, chances are you’ve handled sales data in the past or will do so sometime in the future. Incorporating sales data into...
Jun 8, 2017 | How To, Microsoft PowerBI, Technical Information
By: Andy Kim Business Intelligence Consultant @ Key2 Consulting An important part in preparing data for business intelligence is manipulating the data into usable standard formats. In PowerBI, data can be manipulated both as it’s being brought into your report...
May 1, 2017 | How To, SQL Server, Technical Information
By: Paul Schuliger BI Consultant at Key2 Consulting This is the second article about the use of the Date Matrix in reporting applications. The first article can be found here if you missed it. The Date Matrix is a SQL tool that is used to solve the problem of...
Mar 27, 2017 | How To, SharePoint
By: Mason Prewett SharePoint & Business Intelligence Consultant As a SharePoint administrator, teams often ask me for advice to help them design their content in a structured way. Here are some common questions I receive: How can we make it easier for my...
Mar 9, 2017 | Analytics, Data Visualization, How To, Microsoft PowerBI, Technical Information
By: Matt Wollner Sr. Business Intelligence Consultant at Key2 Consulting I’ve spent a lot of time talking to business owners and managers. And I’ve noticed that many of these leaders tend to use excel for their analytics needs. Furthermore,...
Feb 27, 2017 | Data Warehousing, How To, SQL Server, Technical Information
By: Ken Adams Sr. Business Intelligence Consultant at Key2 Consulting 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...
