Data Scientist is a hot job nowadays in the market and there are lots of demand for it. Data Science origins from the BI field and sits under umbrella of Business Intelligence, because the data science and data mining helps decision makers in their decision making process. To have an idea about how data mining can solve real world issues, think about loyalty program of the super market that you usually use close to your home. Loyalty program simply analyze your purchase history and based on that it comes up with some suggestion and prediction about your next purchases and will promote that through your cell phone text messages or email or even flyers directly addressed to your home address.
Fortunately technology has been quite powerful at this stage and there are number of tools that you can use for data mining. Data Mining consists of two types of analysis: Descriptive Analysis and Predictive Analysis. Descriptive Analysis is about analyzing data from the past, and Predictive analysis is predicting the future based on existing data and the model found in the data. Data Mining contains sophisticated mathematics algorithms that can understand the patterns in the data and analyze it. However don’t worry if you are not a mathematician, there are some good Data Mining tools in the market that do the hard job for you.
Book: Data Science for Business: What You Need to Know About Data Mining and Data-Analytic Thinking
9-1- SQL Server Analysis Services Data Mining
Microsoft offered two tools for Data Mining so far. The first and older tool is SQL Server Analysis Services which enables you to create mining models and structures in Business Intelligence Development Studio or SQL Server Data Tools, and then publish it on the server, so the model can be used for analysis. This technology has been released in 2000 with SQL Server product, but it has been improved significantly in 2005 version of this product. Data Mining still is part of SSAS and SQL Server product nowadays. There are heaps of blog posts and videos about SSAS data Mining. However there are not that much books that deeply discuss features of this service. The book that I suggest here might be old, but the technology of SSAS data mining didn’t changed a lot after that time, and still this counts as one of the best books in this field.
Video: Session Recording of SQL PASS Rally 2015 Nordic: Show Me Potential Customers; Data Mining Approach
This video gives you a brief understanding of data mining with SSAS. you will see practical examples of it through the video.
Book: Data Mining with Microsoft SQL Server 2008
This is one of the best books for SSAS Data mining, it has many examples with deep technical chapters. there is even a chapter for extending SSAS Data Mining if you want!
9-2- Azure Machine Learning
Microsoft recently released a new service as part of Microsoft Azure services named Azure Machine Learning or Azure ML. This is Microsoft new data mining technology which works cloud based, with great collaboration with data mining powerful engine of R, and is highly extensible. This technology is new, but there is a very good documentation on Azure website for that with bunch of tutorial videos, there also couple of books that I would like to mention below.
Azure website Videos:
Deploying a Predictive Model as a Web Service
Azure Machine Learning API service enables you to deploy predictive models build in Azure Machine Learning studio as scalable, fault tolerant Web services. Azure ML API ser…
Getting Started with Azure Machine Learning – Step3
Getting Started with Azure Machine Learning – start using Azure Machine Learning Studio to create your first predictive model. Visit Get started with Azure Machine Learni…
Getting Started with Azure Machine Learning – Step2
Getting Started with Azure Machine Learning – creating a machine learning workspace in the Azure subscription. Visit Get started with Azure Machine Learning to learn more.
Getting Started with Azure Machine Learning – Step1
Getting Started with Azure Machine Learning – creating a free Azure trial subscription. Visit Get started with Azure Machine Learning to learn more.
Preprocessing Data in Azure Machine Learning Studio
Data preprocessing is the next step in data science workflow and general data analysis projects. This video illustrates the commonly used modules for cleaning and transfor…
Publishing an Azure Machine Learning service into the Azure Marketplace
This service will walk you through all the steps required to publish a service from Azure Machine Learning into the Azure Marketplace. Visit Publish Azure Machine Learning…
Overview of Azure Machine Learning
This provides an overview of the Azure Machine Learning Service. A browser based workbench for the data science workflow, which includes authoring, evaluating and publishin…
Provisioning Azure Machine Learning workspaces from Azure Portal
This video walkthroughs steps needed to provision an Azure Machine Learning workspace from the Azure Portal. Visit Troubleshooting guide: Create and connect to an Machine …
Using R in Azure Machine Learning Studio
Azure Machine Learning supports R. You can bring in your existing R codes in to Azure Machine Learning and run it in the same experiment with provided learners and publish …
Getting Started with Azure Machine Learning Studio
This video introduces Azure Machine Learning Studio, a visual tour of the Azure Machine Learning studio workspaces and collaboration features. Visit What is Azure Machin…
Azure Machine Learning
Cloud Machine Learning
Getting and Saving Data in Azure Machine learning Studio
Data Access is the first step of data science workflow. Azure Machine Learning supports numerous ways to connect to your data. This video illustrates several methods of dat…
Text Analytics and Vowpal Wabbit in Azure Machine Learning Studio
This video talks about text analytics capabilities in Azure Machine Learning Studio using Vowpal Wabbit to solve text classification problems. Visit Machine Learning Docu…
Building a Recommender System in Azure Machine Learning Studio
This video talks about building a step by step process of building a Recommender system using Azure Machine Learning Studio. Visit Machine Learning Documentation to learn…
Consuming a Request Response Web Service
The video shows the user how to consume an Request Response web service from R Studio using the published API’s R sample code. Visit Machine Learning Documentation to le…
Consuming Batch Execution Web Service
The video shows the user how to consume a Batch Execution Web Service from C# using the published API’s C# sample code. Visit Machine Learning Documentation to learn more.
Cloud Cover 151: Azure Machine Learning with Parmita Mehta
In this episode Chris Risner and Haishi Bai are joined by Parmita Mehta, Program Manger on the Azure Machine Learning team. Parmita gives an overview of the new Azure Clou…
Predictive Modeling with Azure ML studio
Azure Machine Learning features a pallets of modules to build a predictive model, including state of the art ML algorithms such as Scalable boosted decision trees, Bayesian…
Book: Predictive Analytics with Microsoft Azure Machine Learning
Book: Azure Machine Learning Essentials: Free eBook
This one is great free eBook that published recently.
Walk-through Steps: I’m New to BI, Where to Start? – Part 0: Prerequisites
Walk-through Steps: I’m New to BI, Where to Start? – Part 1: Fundamentals, Data Warehouse and ETL
Walk-through Steps: I’m New to BI, Where to Start? – Part 2: Modelling with BISM
Walk-through Steps: I’m New to BI, Where to Start? – Part 3: Data Governance
Walk-through Steps: I’m New to BI, Where to Start? – Part 4: Data Visualization
Walk-through Steps: I’m New to BI, Where to Start? – Part 5: Power BI
Walk-through Steps: I’m New to BI, Where to Start? – Part 6: Data Mining
Walk-through Steps: I’m New to BI, Where to Start? – Part 7: Azure
1 thought on “Walk-through Steps: I’m New to BI, Where to Start? – Part 6: Data Mining”