SQL Server 2016 Archives - BI and Predictive Analytics

SQL Server 2016 Stretch Database

August 17, 2015 by Derek Leave a Comment

SQL Server 2016 Stretch Database One of the features in SQL Server 2016 that you will want to explore is the ability to store your historical data in the Azure cloud. By leveraging the Stretch Database feature your applications can silently migrate data to the cloud without having to change your existing code. Stretch Database … [Read more…]

SQL Server Polybase (2016)

July 20, 2015 by Derek Leave a Comment

What is SQL Server Polybase? Coming in SQL Server 2016 is the ability to query relational tables as well as data stored in Hadoop or Azure Blob storage. This technology will allow you to continue to leverage SQL Server for your data warehousing and access data stored in different formats and technologies to combine data … [Read more…]

Predicting Employee Churn with Data Mining
Use Data Mining to Identify Employees at Risk of Churn For organizations that have a lot employees that are in high turnover positions predicting employee churn with data mining can help to reduce and retain top talent. By collecting data on employees and then building a predictive model using employees that have left the organization. […]
Using Power BI to Visualize Houston Crime Stats
Houston Crime Data The city of Houston provides high level details on crime statistics via Excel files on the police website. These statistics are stored in monthly files available via Excel or Access. In order to better understand the crime data I created a single Excel file that stored the data from August 2016 to December […]
Increase Data Value with Master Data Management
Master Data Management and Data Value Master Data Management (MDM) is a system that enables business critical core data to be entered and maintained through a central application. Security and tracking of the data value changes are built into the process and allows tracking the history of values. Data that is vetted and approved can […]