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.  The Marketing department wants to send out targeted mailing and phone call campaigns to customers most likely to need an auto loan.  The available data includes information on each unique account along with flags that indicate use (1 used, 0 not used).  Other fields count the number of inbound calls,Read More →

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 BI queries the data as needed.  For smaller tables using DirectQuery can be a good option to leverage when you do not want to build a data refresh process into Power BI.  Source systems can potentially be queried on demand and provide users with the most up to date dataRead More →

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 and the number of times they appear.  These include uses in various business functions such as Risk Management, Customer Service, Project Management, or Knowledge Management.  RapidMiner text mining enables you gain insight from your business information and transform that into knowledge and actionable insights.  In this example, I will use dataRead More →

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 your best offer for a customer. Call Now Contact us today for a free demo and consultation… 832-819-5744 Schedule a Call NowRead More →

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.  You can create models that will give you new insights into the characteristics of employees that at risk of leaving.  By having this score you can then match up the performance of the employee to determine options to keep your talent and prevent them from leaving.  For example a callRead More →

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 2016.  The data is formatted as shown.  I wanted to see what type of information I could learn by using Power BI to Visualize the data. Using Power BI to Visualize the Data Connect to the data in Power BI directly to the Excel file.  To explore summary information buildRead More →

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 then be used in the enterprise by other applications.  For instance, you can create a master data set for products.  Each product would have a unique identifier and be a single view of the product. When a new product is created or an existing product is updated the updates goRead More →

CRISP-DM Mr. Wilson published an article on CIO Review that explores how to leverage the Cross Industry Standard Process for Data Mining CRISP-DM.  In this article, Leveraging JMP to Impove Business Decisions  he discusses how using the CRISP-DM process can help you create more value from your data and analytics initiatives.  Read More →