Oct 23, 2017 | Data Visualization, Featured, Microsoft, Microsoft Power BI, Technical Information
By: Ken Adams Sr. BI Consultant In this article, I am going to dive into Power BI and show you the new Timeline Storyteller visualization. This is a custom visualization for Power BI that can be found at the Office Store. I will later show you how to add it to...
Sep 12, 2017 | PowerShell, SQL Server, Technical Information
By: Jharred R. Williams 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 command line shell that is almost identical to a...
Aug 28, 2017 | Salesforce, SQL Server, Technical Information
By: Jeff Levy 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 business...
Jul 6, 2017 | SharePoint, Technical Information
By: Mason Prewett 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: Completing large tasks that take a long time to process Needing...
Jun 8, 2017 | Featured, Microsoft Power BI, Technical Information
By: Andy Kim 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 as well as after you’re bringing the data into...
May 8, 2017 | Data Warehousing, Featured, 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...
