Machine Learning & Power BI Workshop
Próximos 26 y 27 de octubre, el evento se realizará en Microsoft, México en la Sala Kukulcán Vasco de Quiroga 1700 Piso 3, Col. Centro Cd. Santa Fe
México Distrito Federal 01210, el Workshop esta orientado a investigadores y se comentarán temáticas sobre aplicación de tecnologías PowerBI y Azure Machine Learning para la inteligencia y el análisis predictivo de datos.
Cómo participar

Machine Learning & Power BI Workshop

Imagine if you could resolve critical challenges by arming yourself with the data and analytics  you (or  your stakeholders) need to generate insights, take proactive action, and improve outcomes. 
 

Join us in this workshop and unlock the potential of your data!
 

  • WHO SHOULD ATTEND? Data Scientists, Developers & Programmers, Architects, and Analysts
  • WHY SHOULD I ATTEND? Azure Machine Learning is an exciting new Microsoft product that allows rapidly add the power of Machine Learning to their efforts. If your business deals with data, Azure ML can add value. 
  • WHEN SHOULD I ATTEND?  The workshop will be held on monday october 26th and tuesday 27th.


AGENDA
The workshop will include information and hands-on lab sessions covering Predictive Analytics scenarios with Big and real-time data and Machine Learning. 

Day 1

 

Hora inicial

Hora final

Actividad

09:00 am

09:30 am

Registration and Breakfast

09:30 am

10:15 am

Presentation: What is Data Science? What is Predictive Analytics?

10:15 am

10:30am

Hands on 
– Set up studio.azureml.net account 
– Tour of Azure Machine Learning 
– Comparison and contrast with statistics environment
– Question and answer from academic modeling perspective

10:30 am

12:00pm

Hands on 
– Activity Mix Model
– Define problem 
– Import data from CSV 
– Develop multiple regression model

12:00 pm

12:45 pm

Demo – Power BI and Azure ML 
– High level explanation of Microsoft stack in the context of the EDU demonstration. Excel + AML + PowerBI

 

12:45 pm

01:00 pm

BREAK

01:00 pm

01:30 pm

Lunch

01:30 pm

02:30 pm

Syndicating Azure ML to Excel via API 
– Return to regression model developed above, and extension of that model through the API to Excel on client laptops

02:30 pm

04:30 pm

Hands on – R for “humans” in Azure Machine Learning 
– Step by step example of using R in AML 
– Replicating regression results with R
– Tutorial focus on getting outputs from AML and then using them in Excel/PowerPoint

04:30 pm

05:00 pm

How to use Azure Machine Learning Efficiently 
– Cool tools1: Descriptive Statistics 
– Cool tools2: Write CSV 
– Cool tools3: Metadata editor 
– Cool tools 4: Copy blocks and paste to compare models

05:00 pm

05:15 pm

Questions / Evaluation



Day 2
 

Hora inicial

Hora final

Actividad

09:00 am

09:30 am

Introduction to PowerBI: Compare and contrast to Excel

09:30 am

10:00 am

Importing Data (Excel, CSV, Databases)

10:00 am

11:00am

Data Transformations 
– Split, merge, rename, custom column, replace data, change data types

11:00 am

12:00pm

Table relationships 
– DAX formulas
– Always add measures after right hand-most column

12:00 pm

12:45 pm

Demo – Power BI and Azure ML 
– High level explanation of Microsoft stack in the context of the EDU demonstration. Excel + AML + PowerBI

12:45 pm

01:00 pm

BREAK

01:00 pm

01:30 pm

Lunch

01:30 pm

02:30 pm

Filters for Dynamic Reporting

02:30 pm

03:00 pm

Report Clean Up

03:00 pm

03:30 pm

Upload to app.powerbi.com and create dashboard

03:30 pm

05:00 pm

Exploration of provided data set

05:00 pm

05:15 pm

Final questions and answers.


WORKSHOP LANGUAGE: English

Cómo participar