Sep 12, 2017 | PowerShell, SQL Server, Technical Information
By: Jharred R. Williams Business Intelligence Consultant at Key2 Consulting A brief intro of Windows PowerShell • Windows Powershell is a task automation framework used for its ease of use when compared to building full blown executables. • With a...
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...
Jul 6, 2017 | SharePoint, Technical Information
By: Mason Prewett SharePoint & Business Intelligence Consultant PowerShell is a powerful language to use when completing repetitive tasks on a system. I usually find myself needing to use PowerShell with the following common requirements:...
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 8, 2017 | Data Warehousing, SQL Server, Technical Information
By: Ken Adams Senior BI Consultant at Key2 Consulting 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...
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...
