July 2015 - BI and Predictive Analytics

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…]

HASSUG BI Developer Presentation on 7/14/2015

July 19, 2015 by Derek Leave a Comment

I presented on how to become a BI developer at the Houston Area SQL Server User Group (HASSUG). This session resulted from feedback we received in the user group on differences between database developers and BI developers. If you are interested in seeing the presentation content it is uploaded here: Becoming a bi developer from … [Read more…]

Increase Revenue by Cross Selling and Predictive Analytics
Cross Selling with Predictive Analytics Want to understand how data mining and predictive analytics can help you target the best customers for cross selling or up selling opportunities? By building a predictive analytics model that leverages historical data from your company. A model can be built and applied to your active customer base that identifies […]
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 […]

BI and Predictive Analytics

Leveraging Data to Make Better Decisions

Month: July 2015

SQL Server Polybase (2016)

HASSUG BI Developer Presentation on 7/14/2015