Dec 16, 2020 | How To, Microsoft, Microsoft Power BI
By: Mason Prewett Power BI report development can require a large effort, and Power BI reports are only valuable if your consumers can easily access them. Having a well-defined “sharing strategy” can ensure that your Power BI assets are being effectively used...
Oct 30, 2020 | GitHub, How To, Microsoft
By: Matt Wollner Our Branch-Based GitHub Workflow Now that Microsoft has acquired GitHub, our team here at Key2 Consulting is starting the transition from Team Foundation Server (TFS) to GitHub for our database source control. If you are...
May 7, 2020 | How To, Microsoft, Microsoft Power Automate
By: Austin Gainey Before I get into the details of Power Automate’s capabilities, it is my genuine hope that you and your family/friends are healthy and safe as we navigate our way through the COVID-19 pandemic. A huge thank you and appreciation to...
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, Azure, Microsoft
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...
