Oct 18, 2019 | Data Encryption, Data Security, Data Warehousing, healthcare, Tech Tips
By: Ken Adams Data security is a vital part of successful data warehousing and business intelligence today, and a critical step in successfully securing a data warehouse is implementing proper data security levels. From a legal perspective, related...
Jul 30, 2019 | Data Warehousing
Some data warehouse projects unfortunately don’t work out…don’t let yours be the next! Here are our top 3 reasons why data warehouse projects fail. 1) Poor Communication Between Business Units & Tech Team Great communication is not only...
Apr 30, 2019 | Big Data, Business Intelligence, Data Warehousing, Tech Tips, Technical Information
By: Jeff Levy Hadoop Distributed File System Overview This step-by-step tutorial will walk you through how to install Hadoop on a Linux Virtual Machine on Windows 10. Even though you can install Hadoop directly on Windows, I am opting to install Hadoop...
Jan 7, 2019 | Business Intelligence, Consulting, Data Warehousing, Key2 Stories, Tech Tips
By: Paul Schuliger Happy New Year to you! And welcome back to the working world. We hope that you are feeling reinvigorated after some much-needed rest and relaxation. Making resolutions at the start of a New Year is a tradition that spans many cultures....
Aug 21, 2018 | Data Warehousing, Key2 Stories, Microsoft, PowerShell, SQL Server, SSIS, Tech Tips, Technical Information
By: Ken Adams Introduction Disclaimer: Microsoft introduced the project deployment model for Integration Services (SSIS) over 6 years ago with SQL Server 2012. At this point in time, it is likely that you know a lot about project deployment. This post will...
Apr 18, 2018 | Data Warehousing, Featured
By: Ken Adams If you interviewed a handful of database professionals and asked them to define an Enterprise Data Warehouse (EDW, for short), it’s likely you would get a slightly different interpretation from each of them! That’s not to say any of them would be...
