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

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

BI and Predictive Analytics

Leveraging Data to Make Better Decisions

Month: November 2014

SQL Server Management Studio Reports

SQL Server Table Partition Example