Admin

Author's details

Date registered: January 30, 2013

Latest posts

  1. Risk Analytics: Methods and Benefits — August 22, 2014
  2. Showing Error Magnitude Using a Banded Column Chart in SSRS — July 31, 2014
  3. Displaying Tick Marks on SSRS Line Chart — June 8, 2014
  4. Forecasting Software Comparison — April 29, 2014
  5. A Simple Method to Compare Financial Results — February 5, 2014

Author's posts listings

Aug 22

Risk Analytics: Methods and Benefits

This spring I took a course in Risk Analytics for the Masters of Science in Predictive Analytics (MSPA) degree that I’m working towards.  I wrote up an overview for my employer’s blog.    

Jul 31

Showing Error Magnitude Using a Banded Column Chart in SSRS

Minimum Expression

Forecasting is never completely accurate and there are always differences between the predicted value and the actual value.  Users often want to see the errors displayed so that they can judge for themselves how accurate the forecast process is.  This article will show how to create an error chart  in SSRS with a visual indicator …

Continue reading »

Jun 08

Displaying Tick Marks on SSRS Line Chart

DataSet

I was recently working with a client to display some of their sales data over the last several fiscal years.  We were using a line graph in an SSRS report to display the data.   The odd thing was that the monthly tick marks were showing up at odd intervals.  It seemed that there was space …

Continue reading »

Apr 29

Forecasting Software Comparison

Introduction At a client I was asked to help with selecting software for a sales forecasting project. The most important factors were the accuracy of the forecasts, how well it integrated into the technical environment and the level of support for the software.  We wanted to forecast sales throughout the sales hierarchy so the final …

Continue reading »

Feb 05

A Simple Method to Compare Financial Results

The sales department at my current client were making claims about the sales cycle that were hard to believe.  I discuss in a post on my employer’s blog an easy statistical test to determine whether their claims were consistent with reality or not.

Nov 29

Data Type Results from UNION Queries

TestDataTypes Columns

Sometimes when we are exporting data from one database to another we need to combine data sets at the source. One example of this is moving data in a data warehouse from a landing area where all of the tables are replicas of the source tables to a staging area where the tables are combined …

Continue reading »

Oct 27

Correcting Excel Data Types in the Import Wizard

020 - Data List 2

A common task that business intelligence professionals have to perform is to import data from Microsoft Excel into SQL Server.  This is usually a unnecessarily challenging project with many pitfalls.  One of the pitfalls is getting the SQL Import Export Wizard to correctly determine the data types. One pattern that you occasionally see in data …

Continue reading »

Oct 27

Experience at SQL Saturday Fargo

SQL Saturday is a free conference organized by PASS organizations around the country and the world.  Fargo, ND hosted their first SQL Saturday on April 27, 2013.  The day was full of learning, socializing and a surprise celebrity appearance. SQL Saturday was originally organized by PASS to give beginning presenters a venue to speak at.  …

Continue reading »

Apr 26

Speaking at SQL Saturday #175 Fargo

I’ll be traveling with the rest of the Minnesota SQL Server gang up to Fargo, ND for their first SQL Saturday. My presentation is on the Microsoft Clustering data mining algorithm. Microsoft SQL Server makes it simple to apply data mining algorithms to a wide variety of data. Applying the results to business decisions without …

Continue reading »

Apr 01

Extracting Data from the Weather Underground API

Class Library Dialogue

Many companies are beginning to bring external data into their data infrastructure.  One of the most common and easily available types of external data is weather data. There are several excellent sources of weather data.  If you need historical weather data then Fetch Climate is a great resource.  The data has been combined from many …

Continue reading »