Data Mining and Analytics

This course is a practical tutorial on how to preform predictive analysis on different fields with SSAS and Data Mining on Excel.

What is SSAS?

SSAS is SQL Server Analysis Services. It is a technology created by Microsoft for Business Intelligence purposes. SSAS develops Online Analytical Processing (OLAP) solutions, which is a collection of related data from Data Warehouse to perform deeper and faster data analysis.

What is Data Mining?

Data Mining is the process of examining pre-existing large quantities of database to generate new information.

Forecast the price of Gold using historical gold price data

Gold is an important commodity and the forecasting it’s price could be useful for businesses. You can get the historical information of Gold from https://www.gold.org/download/value/stats/statistics/xls/gold_prices.xls and process it using PowerPivot and Data Mining in Excel.

Sales Forecasting

Install Data Mining Add-in for your Excel. Setup your analysis services for Excel and add your Data Mining Add-in. Get a sample data of your Sales data and get ready for Forecasting.

Get 5 number summary with R programming language

Learn how to use R to get the five numbers, or quartiles, in statistics, using the R programming language. Download R from this link https://www.r-project.org/.

Finding Median Value with R programming

Use the R programming language to calculate the median value of a vector. Demonstrates multiple methods: entering values into the console, reading a text file, and a csv file

Calculate Statistical Mean with R programming

Use the R programming language to calculate the mean, or average. This tutorial shows how to perform mean calculations using the console or with text and csv files.