Jun 4, 2020 | How To, Microsoft Excel
By: Andy Kim When it comes to analyzing data, Microsoft Excel spreadsheets have always been a great tool to do so, and they will continue to be commonly used amongst data analysts for the foreseeable future. Have you ever found yourself performing...
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...
Dec 5, 2019 | Business Intelligence, How To, Microsoft Power BI
By: Mike Pierre-Louis Have you ever been in a situation at work where you need to review a really complicated report but are extremely pressed for time? I know I have, and my guess is just about everyone reading this blog post has experienced a similar...
Dec 3, 2019 | Azure, How To, SQL Server, Technical Information
By: Phil Woubshet This exercise will demonstrate how to copy multiple tables from an on-premise SQL Server database to Azure SQL Data Warehouse. We will use a metadata table that contains the schema/table names to drive the copy process from source to...
Oct 8, 2019 | Business Intelligence, Data Encryption, Data Security, How To
By: Paul Schuliger What is Column Level Security? Column level security (CLS) is a useful tool for limiting access to specific data elements (or database columns) through data obfuscation. Data obfuscation masks the underlying data elements to avoid...
Sep 20, 2019 | Data Security, How To, SQL Server, Web Applications, Web Development
By: Phillip Sharpless Security, as part of many projects, is all too often an afterthought. The standing up of a new system or the development of a new project can be quite rapid and dynamic. Not pausing during this process to think about security as an...
