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 Auto Model for Online Data Mining
Get started with Data Mining using RapidMiner Auto Model RapidMiner recently released their online data modeling tool called Auto Model. This product allows you to upload data and have RapidMiner build initial data models for you. Currently there are limited algorithms that are available, however, the tool is a great way to get started with […]
RapidMiner Wisdom Conference Sponsor
RapidMiner Conference Sponsor Come join me at RapidMiner Wisdom Conference on October 10-12, 2018 in New Orleans. CDO Advisors is proud to be a RapidMiner sponsor for this event. It should be a great few days of learning how to get the most from RapidMiner and apply it to business problems. The post RapidMiner Wisdom […]
Power BI and Sales
Sales Management Dashboard with Power BI The example below creates a Power BI sales dashboard solution to visualize sales data for a sales manager. The data is loaded into Power BI to create several views that enable everyone from Sales Managers to Sales Reps to gain insights into the performance of the sales team. To […]

BI and Predictive Analytics

Leveraging Data to Make Better Decisions

Month: November 2014

SQL Server Management Studio Reports

SQL Server Table Partition Example