Microsoft Technologies for Data ScienceArchitecture Edition
Mark Tabladillo, Ph.D.
Senior Data Scientist
LogicBlox/Predictix
Networking
Interactive
http://www.bizjournals.com/atlanta/subscriber-only/2014/07/11/top-employers-in-metro-atlanta.html
http://www.kdnuggets.com/polls/2015/analytics-
data-mining-data-science-software-used.html
http://products.office.com/en-us/excel
http://www.microsoft.com/en-us/server-cloud/products/sql-server/
http://pytools.codeplex.com/
http://azure.microsoft.com/en-us/services/hdinsight/
http://www.revolutionanalytics.com/
http://download.microsoft.com/download/F/C/2/FC21C981-
4351-4434-A78A-
3384CA7515BF/SQL_Server_2016_Deeper_Insights_Across_D
ata_White_Paper.pdf
SS
SQL
AS
NoSQL
SQL Server Data Mining: Analysis Serviceshttp://sqlserverdatamining.com
Data mining add-in for business analysts
• Ease of use
• Rich data mining
• Scalable
Rowset
Output
with Scores
Varchar
NVarchar
Office
Documents
Full-Text
Keyword
Index
“FTI”
iFilters
Semantic Document
Similarity Index “DSI”
Semantic
Database
Semantic
Key Phrase
Index –
Tag Index
“TI”
Simplified Chinese
British English
Portuguese
Chinese (Hong Kong SAR, PRC)
Spanish
Chinese (Singapore)
Chinese (Macau SAR)
Time in Seconds vs. Number of Documents
(2011 – K. Mukerjee, T. Porter, S. Gherman – Microsoft)
http://users.cis.fiu.edu/~lzhen001/activities/KDD2011Program/docs/p213.pdf
http://download.microsoft.com/download/3/B/9/3B9FBA69-8AAD-4707-830F-6C70A545C389/Introducing_Azure_Machine_Learning.pdf
http://datacamp.com
https://github.com/jakevdp/sklearn_pycon2015
http://azure.microsoft.com/en-us/services/machine-learning/
Mutable Immutable
Classic Open
Source
Java Scala
.NETNow Open Source
C#, C++,
VB.NET
F#
http://channel9.msdn.com/posts/Erik-Meijer-Functional-Programming-From-First-Principles
http://tomasp.net/
Technology Use Case
SQL Server Analysis
Services
SQL Server Licensed
Input: SQL Server, SSAS
Excel Add-In for SSAS
Semantic Search
Azure Machine
Learning
F#
Technology Use Case
SQL Server Analysis
Services
SQL Server Licensed
Input: SQL Server, SSAS
Excel Add-In for SSAS (Ditto) + Excellent Bridge for Excel Users
Semantic Search
Azure Machine
Learning
F#
Technology Use Case
SQL Server Analysis
Services
SQL Server Licensed
Input: SQL Server, SSAS
Excel Add-In for SSAS (Ditto) + Excellent Bridge for Excel Users
Semantic Search SQL Server: Volume Text Processing
Azure Machine
Learning
F#
Technology Use Case
SQL Server Analysis
Services
SQL Server Licensed
Input: SQL Server, SSAS
Excel Add-In for SSAS (Ditto) + Excellent Bridge for Excel Users
Semantic Search SQL Server: Volume Text Processing
Azure Machine
Learning
Students; Web Applications (R & Python)
Input: Azure-based Sources
F#
Technology Use Case
SQL Server Analysis
Services
SQL Server Licensed
Input: SQL Server, SSAS
Excel Add-In for SSAS (Ditto) + Excellent Bridge for Excel Users
Semantic Search SQL Server: Volume Text Processing
Azure Machine
Learning
Students; Web Applications (R & Python)
Input: Azure-based Sources
F# .NET Developers
Conference: http://www.kdd.org/
http://blogs.technet.com/b/machinelearning/
http://social.msdn.microsoft.com/forums/azure/en-US/home?forum=MachineLearning
http://sqlserverdatamining.com
http://marktab.net
http://curah.microsoft.com/342704/azure-machine-learning-videos-february-2015
http://datascience.sqlpass.org