November 2014 - BI and Predictive Analytics

SQL Server Management Studio Reports

November 17, 2014 by Derek 1 Comment

SQL Server Management Studio Reports Whether you are an Application, SQL, BI Developer or a DBA. Knowing what is occurring within your database is critical to the performance of your applications. One tool you can leverage to see what is happening are the built in reports in SSMS. SQL Server includes basic reports that you … [Read more…]

SQL Server Table Partition Example

November 3, 2014 by Derek Leave a Comment

Why Use a SQL Server Table Partition Data warehouses and data repositories often have tables that store millions of records and each day adding thousands more. As the data ages, the older records generally require fewer updates. If all of these records are kept in a single physical table. Queries and maintenance on the table … [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: November 2014

SQL Server Management Studio Reports

SQL Server Table Partition Example