BI and Predictive Analytics - Page 9 of 9 - Leveraging Data to Make Better Decisions

Microsoft Windows Azure Overview

October 17, 2013 by Derek Leave a Comment

I have been using the Azure infrastructure for a few months now. My overall experiences have been great. I can now create a virtual machine and entire network infrastructure in the cloud and access it from anywhere. No longer do I need a test server at home taking up space and filling the room with … [Read more…]

SQL 2012 Virtual Labs

October 16, 2013 by Derek Leave a Comment

There are a variety of great learning labs available on the SQL Server site. 19 virtual labs cover the following topics: Business Intelligence Mission-Critical Operations Database Management The original link – http://www.microsoft.com/sqlserver/en/us/learning-center/virtual-labs.aspx

What is Enterprise Architecture

October 16, 2013 by Derek Leave a Comment

Enterprise Architecture (EA) is a logical organization of the business and its supporting data, applications and IT infrastructure A typical architecture consists of diagrams that show how aspects of the business relate: EA aligns the following 4 areas: Business – Processes, Strategies, Organization Charts and Functions Information – Conceptual, Logical and Physical data models to … [Read more…]

SQL Pass Summit 13

October 16, 2013 by Derek Leave a Comment

This year I am attending SQL Pass Summit in Charlotte, NC. There are lots of great sessions on SQL Server 2012 and information being presented on SQL Server 2014. Along with all of the content of SQL Server, HDInsights and Windows Azure are being presented. From an enterprise perspective the ability to create new hybrid … [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 […]