Jan 29, 2020 | BIML, Business Intelligence, Microsoft, SSIS
By: Andy Kim What is Biml? Business Intelligence Markup Language (Biml) is an XML-based language that can generate (SQL Server Integration Services) SSIS packages, amongst other things. The programming language was developed by Scott Currie and his company...
Jan 14, 2020 | Data Visualization, Microsoft, Microsoft Power BI
By: Matt Wollner Microsoft Power BI has many great features, two of which are “Bubble Map” and “Filled Map”. Both of these features are map visuals that are easy to set up and have high utility for all users. They are powered by Bing Maps and location...
Jan 2, 2020 | Analytics, Microsoft, Microsoft Azure
By: Matt Wisor In early November, Microsoft announced the release of Azure Synapse Analytics at the Ignite Conference in Orlando. The new analytics service is intended to help businesses bring data warehousing and big data together for deeper, more...
Sep 11, 2019 | How To, Microsoft, PowerShell, Technical Information
By: Mason Prewett We’ve written many blog articles about PowerShell and how incredibly useful the Microsoft framework can be, and this article is another example. PowerShell is a great tool for performing long running tasks. A common strategy used to...
Aug 27, 2019 | How To, Microsoft, Microsoft PowerApps, SharePoint, Technical Information
By: Austin Gainey Did you know you can utilize Microsoft PowerApps to customize out of the box SharePoint Online forms, which can then be used to take down corrupt secret government projects, destroy cars with telekinesis, and cut through the fabric of...
Jun 3, 2019 | Business Intelligence, How To, Microsoft, SQL Server
By: Paul Schuliger Over a year ago I wrote an article that discussed using the SQL Window Function ROW_NUMBER() to set up a sort order within each layer of a hierarchy, and then showed how to use that information in Power BI. I recently found...
