Jun 24, 2019 | Business Intelligence, Compression, How To, SQL Server
By: Ken Adams Not Enough Space On my current engagement, we are trying to build a reporting platform that meets the needs of our client while simultaneously adhering to best practices. One of the best practices we’ve established as part of the platform is...
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...
Apr 30, 2019 | Big Data, Business Intelligence, Data Warehousing, How To, 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...
Apr 10, 2019 | Business Intelligence, Data Visualization, How To, PowerShell, Tech Tips, Technical Information
By: Mason Prewett Introduction As an admin of many server types, I often encounter the issue of a machine running out of disk space. Tracking the culprit folder that was hogging up disk space used to be a troublesome, manual effort. However, I recently coded a...
Mar 15, 2019 | Analytics, Business Intelligence, Data Visualization, How To, SQL Server, Tech Tips, Technical Information
By: Andy Kim Introduction If you ask a SQL professional to name some data types, you might hear: varchar, int, datetime, decimal, or something to that effect. Rarely do people mention the spatial data types of: geography and geometry. This is because most SQL...
Feb 7, 2019 | Analytics, Business Intelligence, Data Visualization, How To, Microsoft, Microsoft Power BI, Tech Tips
By: Matt Wollner Power BI Desktop has been on a roll with monthly updates making it easier for users to get insight out of their data. Drag and drop visualizations are making it easier than ever to craft simple, complete dashboards. The highlighting...
