MS SQL Server Analysis Services & Excel - Predictive Analytics

By attending MS SQL Server Analysis Services & Excel - Predictive Analytics workshop, delegates will learn 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 Naïve 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.

• Experience with Excel
• Basic understanding of business analytics

The MS SQL Server Analysis Services & Excel - Predictive Analytics class is ideal for:

• Power Users, IT Professionals, Report Developers, BI Professionals, Project Managers and Team Leads interested in exploring the Microsoft toolsets for data mining, machine learning, and predictive analytics.