Blog

/Blog/

Increase Membership and Revenue with Predictive Analytics

Credit Union Membership Increased by Data Mining I am speaking on Friday May 18th, 2018 in Savannah, GA at the National Credit Union Conference for Directors and Senior Management.  My session topic in on how to use predictive analytics to leverage your data to increase membership and revenue.   For financial institutions, the ability to determine cross selling and targeted marketing campaigns can be achieved by leveraging the data you already have.  In this session I leverage multiple technologies to put together a complete picture of member behavior, location and impact.  The image below (for my fictional credit union) shows how many members live in each postal code along with the opportunity of households in postal code.  This type of report can help you focus on areas to increase or decrease marketing to gain membership. Credit Union Member Penetration by Zipcode Session Abstract: Predictive Analytics can provide credit unions [...]

By |2019-08-09T10:54:52+00:00May 18th, 2018|Power BI, RapidMiner|0 Comments

2018 CIO Review Business Intelligence Solution Provider

CDO Advisors included in the Top 20 Business Intelligence Solution Providers We were just included as a 2018 CIO Review Business Intelligence Solution Provider. While data analytics solutions such as BI and predictive analytics have already emerged as an integral factor in bolstering the value chain of big businesses, the Small and Medium Businesses (SMB) are yet far from leveraging their impeccable benefits. The existing rumor that these services are highly expensive, and the challenge of poor data quality and sheer lack of awareness on progressive technology, have become the biggest blocks in preventing SMBs from availing data analytical services. Drawn by the situation, Derek Wilson, an astute entrepreneur endeavored on a journey to aid SMBs to extract maximum value from their data sets. Thus, saw the creation of CDO Advisors, the IT advisory and consultant firm, providing end-to-end data services ranging from data management, business intelligence, predictive analytics, to data [...]

By |2019-10-08T19:05:52+00:00May 6th, 2018|Data Mining, Power BI, RapidMiner|0 Comments

SQL Server Tabular Models (SSAS) and Power BI

Use SQL Server SSAS Tabular Models to Enhance your Power BI reports Companies with SQL Server licenses running in production most likely already own but are not using SQL Server Analysis Services (SSAS).  To get the most from your existing investment in SQL licenses.  Companies should explore how SQL Server SSAS Tabular Models  can increase the performance of their reporting environments and maximize their investment in SQL Server technology.  Transforming your data into a tabular model will allow you to get more performance from Power BI, Excel or other reporting software. Top 3 Reasons to Use SQL Server SSAS Tabular Models Speed - The data in tabular models are deployed to an in-memory data structure that makes your Power BI reports return visualizations faster than using data tables.  If your executive team hates waiting for answers or spinning circle of death Tabular models can help.  Using data compression and in-memory objects allows [...]

By |2019-08-09T10:58:44+00:00April 28th, 2018|Power BI|0 Comments

Reducing Call Center Agent Churn with Predictive Analytics

Reducing Call Center Churn Do you have a call center and want to keep your best employees from leaving?  Want to know what traits of an employee make them most likely to leave?  Apply call center predictive analytics to your employee data to determine why your employees are leaving.  Hiring the wrong employee waste time and money.  Focus on hiring the best candidates based on your historical employee data. Save money by reducing turnover and training cost on call center agents.  Leverage contact center predictive analytics to reduce call center churn. Organizations that have many employees that are in high turnover positions such as call centers, sales teams, or temporary agencies. All of these roles could benefit from building models to determine why employees are leaving. Predicting employee churn using data mining and analytics can help to reduce and retain top talent. The impact of churn can be in both [...]

By |2019-09-04T16:40:19+00:00April 22nd, 2018|Data Mining, RapidMiner|0 Comments

Primed-AP (Analytic Process)

What is the Primed-AP Methodology? CDO Advisors has launched Primed Analytics Process Homepage to publish content related to our newly published Analytic Process.  The Primed-AP © process was created based on years of experience working with business users to implement predictive analytics.  Existing methodologies focus on the data science tasks but do not include the required tasks for business users.  In order to have a successful project everyone involved needs to understand the roles and responsibilities of the entire process.  Some phases of the process require collaboration between the business and data scientist.  While other phases require more time from the data scientist.  The following section outlines the phases and highlights the responsibilities for the project team.   Full details will be available on the website that describe each step in the process along with typical tasks for business users and data scientists.  This process will enable you to get more value [...]

By |2019-08-14T11:51:27+00:00April 1st, 2018|Data Mining|0 Comments

Marketing Customer Information File Overview

Marketing Customer Information File (MCIF) Many financial organizations already have a custom customer view called a marketing customer information file.  Other industries have these as well, called by different name such as master patient index in the healthcare space.  These files are created through existing software or internal jobs to merge data from various sources into a master file or database.  This file contains relevant information on each customer from all systems to enable a holistic view of your customers interactions with your organization.  A sample MCIF data set would include information (one row per customer) such as: Customer ID Member Tenure Checking Account Indicator Saving Account Indicator ATM Card Indicator Number of Monthly Transactions by Type Auto Loan Indicator Home Loan Indicator Last Contact Date Number of Calls to the Contact Center In addition, any other information that can be used for marketing, sales, or product development can be [...]

By |2019-09-01T08:17:39+00:00March 27th, 2018|Power BI, RapidMiner|0 Comments

Speaking at the Global Predictive Analytics Conference

Implementing Predictive Analytics into Operational Workflows I will be presenting on April 3rd 2018 in Santa Clara, CA at the Global Predictive Analytics Conference.  My session focuses on how to build predictive analytics and integrate the model into your business.  I will examine two use cases: Customer Churn and Cross Selling and demonstrate the process to build the model from start to finish.  Where and how to engage with business teams to ensure the success of the project.  In addition, I will show how pilot projects build collaboration between the data science teams and business units to ensure both teams understand what is required for successful projects. For complete information on the conference - Predictive Analytics Conference Homepage

By |2018-02-27T07:14:09+00:00February 27th, 2018|Uncategorized|0 Comments

Increase Value by Creating a 360 Degree Customer View

Creating a 360 Degree Customer View Businesses today have a wealth of data and limited information and knowledge.  Unless you are using a single application to run your business, you will need to integrate your data to achieve data driven insights. Gaining knowledge about your customers and all of their interactions can enable you to outperform you competition.  A 360 degree customer view pulls relevant information from all of your data sources into a single repository that gives you easy and quick access about your customers.  Leverage Power BI to better understand your customer and their behaviors. How can a 360 Degree Customer View increase revenue? Customized Customer Segementation Targeted Marketing Campaigns Loyalty Reward Cards Create Next Best Offer Programs Anticipate Customer Issues before they arise Potential Data Sources for a 360 Degree Customer View ERP Systems CRM Applications Transaction Systems Billing Systems Call Center Tracking Social Media Survey  Responses [...]

By |2019-09-01T08:20:18+00:00February 25th, 2018|Data Mining, Power BI|0 Comments

Text Mining and Sentiment Analysis of SuperBowl LII

Sentiment Analysis of Tweets from SuperBowl LII Do you own a business and wonder what people aka customers are saying about your company?  Using text mining and sentiment analysis enables you to uncover the words your customers are using and the positive or negative sentiment of those words.  Text mining involves taking text from any source and breaking it down into the core words.   Sentiment analysis then applies the score to the words from -1 (the worst sentiment) to 0 (neutral sentiment) to 1 (highest positive sentiment).  The scores of all the words found create the overall sentiment for that encounter. To show this in action, I ran sentiment analysis on Tweets the day after SuperBowl LII (2/5/2018).  In one example, someone tweeted "Congratulations Philadelphia SuperBowl champions".  The word champion has a positive sentiment and has a positive sentiment score of  .70.  When you take all of the words in [...]

By |2018-02-06T12:55:17+00:00February 6th, 2018|RapidMiner|0 Comments

Choose the Best Power BI Version for Your Organization

Selecting the Power BI Version for Your Business Microsoft's Power BI is their flagship product for data visualization.  It enables businesses to connect to hundreds of data sources, build and deliver dashboards, and share content with others in your organization.  Since it is cloud based, users can view the information from inside their network or on mobile devices from outside the network.  Understanding with Power BI Version you should select and how they interact can be difficult.  There are two core versions of the product, Power BI Desktop Free and Power BI Professional.  Power BI Premium creates a dedicated cloud environment for your users to access the content. Power BI Desktop Free The Power BI version: Desktop edition is free for use and it great for people that want to try the product on your own data.  You can build fully functional reports and dashboards, however, you cannot share your [...]

By |2018-02-05T07:15:48+00:00February 5th, 2018|Power BI|0 Comments
Load More Posts