Jan 30, 2018 | .NET, SQL Server, SSIS, Technical Information
By: Jeff Levy Multithreading an SSIS Package – Introduction Ever have a single task in SSIS that can be applied to dozens of tables in your database? Such a task could be as simple as extracting a table out to a flat file and moving it to a network...
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...
