(Retired) Data Mining, Predictive Analytics with Microsoft Analysis Services and Excel PowerPivot


This three-day instructor-led course will introduce the students to the concepts of data mining, machine learning and predictive analytics utilising the Microsoft toolsets including SQL Server Analysis Services and Excel with PowerPivot and the Data Mining Add-ins.


After completing this course, students will gain the skills to:

  • have a firm understanding of the concept of data mining
  • explore the user interface
  • use offline mode and immediate mode
  • create and configure a data source
  • create and configure data view
  • explore data
  • create and configure named calculation
  • create and configure named queries
  • walk-through a project to completion
  • explore the models
  • compare mining structures
  • use cross validation
  • create reports using Reporting Services
  • save queries
  • save results to the database
  • create multiple nested tables off of a case table
  • use Microsoft Association Rules Algorithm
  • use Microsoft Sequence Clustering Algorithm
  • use Microsoft Time Series Algorithm
  • use Microsoft Neural Network Algorithm
  • properly prepare data for mining
  • use Model Usage—Browse
  • use Model Usage—Query
  • use Accuracy and Validation
  • use Decision Trees
  • use Logistic Regression
  • use Nave Bayes
  • use Neural Network
  • use Estimate Tool
  • use Cluster
  • use Associate Tool
  • use Forecast Tool
  • use Table Analysis Tools
  • use Visio Add-In
  • complete five different business scenarios that further reinforce the concepts learned.

Onsite training?

If you need training for three or more people, ask us about training at your site. You can enjoy the convenience of reduced travel cost and time, as well as a familiar environment for your staff. Additionally, we can customise the course for your business needs.

User Reviews

Not yet rated. You will need to follow this course before you can write a review.

Course Info

  • Code: 55040
  • Duration: 3 days
  • Price: Call for price

Next Step

Enquire Now
Tell a Friend