Dataiku and Microsoft: A Complete Data Analytics Platform

Data Preparation| tutorial| Data analysis | | Robert Kelley

One of the advantages to the Microsoft ecosystem is just how comprehensive it is. From Azure to HDInsight to Power BI, there are many ways Microsoft can enhance your data analytics experience. And the good news from our end is that Dataiku Data Science Studio () seamlessly integrates with just about the whole Microsoft suite.

Watch the video summarizing how:

An Integration for a Complete Data Platform

The video above explains the various ways Dataiku integrates with Microsoft products to form a complete data platform. We use an example that walks through most of these integrations -- and I highly recommend that you watch it! -- but let me give you the main points right here:

  • All Microsoft data sources, including Excel, CSV, SQL Data Warehouse and (soon) Azure Blob storage are compatible with Dataiku
  • Thanks to an Azure template, Dataiku can automatically deploy an edge node on HDInsight
  • Any predictions (or other scoring) created from models within Dataiku can be operationalized and visualized via SQL in Power BI
  • Dataiku is available on the Azure Marketplace

Dataiku , Microsoft, and Mosquitos

In the video, we use an example of a mosquito-tracking model to demonstrate the integrations between Dataiku and Microsoft. It’s a real example, too -- in recent years, mosquitos have brought the West Nile Virus to Chicago (and other places in North America), and we can use data science in order to predict (with real-time data) where the virus will spread.

We show the full process of importing the data sets, building the model, and creating custom visualizations, all using the combined power of Microsoft and Dataiku .

We would love to hear about your experiences using this powerful combination, so do not hesitate to contact me if you have any question you'd like to ask! I'd also recommendchecking out my post on using Dataiku for some thing that Excel spreadsheets doesn't handle as well.

Try Dataiku DSS

Other Content You May Like