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

RapidMiner Market Basket Sample
RapidMiner Market Basket One method to create a targeted cross selling model is to use historical customer information and apply the prediction to existing customers. In this example, I will be using fictitious customer account data for a financial institution such as a bank or credit union to create a RapidMiner Market Basket predictive model. […]
Power BI Leveraging Tabular Models
Power BI Direct Query Power BI can be used in one of two modes to access data. The import option loads data from the source data to the Power BI model. Queries are then processed directly against the data in the model. Using the DirectQuery option, on the other hand, leaves at the source and Power […]
RapidMiner Text Mining Example for Loch Ness Monster Sightings
RapidMiner Text Mining Text mining is a process to pull words from free form text fields, word documents, or other data sources. Business use cases for text mining include scrubbing text from survey notes, claim notes, project notes or call center notes. It is applicable in any situation that requires parsing text to find words […]

BI and Predictive Analytics

Leveraging Data to Make Better Decisions

Month: November 2014

SQL Server Management Studio Reports

SQL Server Table Partition Example