YOU FOR COMING ALONG. SO IN THE
NEXT 20 MINUTES MY PLAN IS HOW TO
BUILD THIS DASHBOARD. AND THIS IS
TRYING TO GIVE YOU AN IDEA HOW YOU
CAN BUILD REALTIME RESPONSIVE DASHBOARDS
WITH DATA ENTRY THAT GOES STRAIGHT
BACK IN THE DASHBOARDS. SO I BUILT
THIS DEMO ORIGINALLY FOR THE GARDE
NER BAKE -OFF EVENT. AND WEELT SHOW
OFF THE PRODUCTS. THEY WANTED TO
TALK A LITTLE BIT ABOUT THE REALTIME.
THE NEXT DATA SET WAS ALL ABOUT
LONELINESS, AND WHAT MAKES PEOPLE
LONELY. AND IT WAS REALLY DEPRESSING.
I'M GOING TO MAKE THIS DASHBOARD,
AND I'M GOING TO HAVE A SURVEY SO
I CAN ASK PEOPLE WHERE THEY ARE
FROM. SO IT'S GOT SPACE ON THE MAP.
OUTSIDE OF WHAUCHING WHAT MAKES
YOU HAPPY. DRINKING TEA. AND BECAUSE
I'M ENGLISH. I'M USING FLOW THROUGH
AZURE. AND IT PUSHES IT BACK IN
THE POWER BI DASHBOARD. SO SIMPLE
DEMO. DOING SOME TERM EXTRACTION.
AND SOME ANALYSIS. DETERMINING WHERE
THE PEOPLE SAYS THEY'RE FROM. THAT'S
A BIT OF A CHEAT THE. I'LL SHOW
YOU AS WELL. BUT THIS ABILITY TO
EMBED A DASHBOARD AND HAVE IT SHOW
UP ON THE VISUALS. WHETHER IT'S
KIND OF CAPTURING PEOPLE'S FEEDBACK.
WHETHER YOU COULD EXTEND. RATHER
THAN HAVING SOMEONE MAN MANUALLY
ENTERING DATA. WHETHER IT'S FROM
A SYSTEM, SENSORS OR EMAILS OR TWEETS.
YOU CAN TAKE THIS PATTERN AND KIND
OF EXTEND IN A BUNCH OF DIFFERENT
WAYS. LET ME WALK THROUGH THE DIFFERENT
COMPONENTS AND HOW WE BUILT THIS.
SO THE FORM ITSELF IS USING MICROSOFT
FORMS, SAND IF YOU GO TO FORMS.
OFFICE. COM. IT'S TOTALLY FREE.
THIS IS ONE OF MOWS MICROSOFT THINGS
WE GIVE AWAY. AND YOU CAN CREATE
A NEW SURVEY OR QUIZ. SPECIFY THE
QUESTIONS YOU WANT. SPECIFY THE
TYPES OF ANSWERS. AND THERE'S A
FEW DIFFERENT TYPES. YOU CAN HAVE
THESE RADIO CHOICES. YOU CAN HAVE
FREE TEXT FIELDS. YOU CAN DETERMINE
WHETHER IT'S A SHORT OR LONG ANSWER.
WHETHER OR NOT IT'S REQUIRED. YOU
CAN DO BRANCHING. YOU CAN HAVE QUITE
COMPLEX SURVEYS AS WELL. LIKE I
SAID IT'S WHAT MAKES PEOPLE HAPPY.
SO I HAVE MY HAPPINESS SURVEY. WOW,
THE INTERNET IS REALLY SLOW. 20
MINUTES MIGHT BE OPTIMISTIC IF ALL
MY PAGES TAKE 30 SECONDS TO LOAD.
I SHOWED HOW YOU CAN CREATE THE
STORY. THE GREAT THING ABOUT THESE
SURVEYS WHEN YOU SHARE YOU CAN SEND
IT IN AN EMAIL TO ANYBODY. OR YOU
CAN GET AN EMBED CODE STICK IT IN
ANY OTHER APPLICATION. THAT'S WHAT
IT'S DOING EMBEDDING IT INTO THE
DASHBOARD. SO THE WAY WE CAPTURE
ALL OF THE INPUT TO ALL OF THOSE
FORMS IS USING FLOW. WHEN YOU COME
TO THE FLOW. MICROSOFT. com. AND
I'VE GOT THIS ONE CALLED HAPPINESS
FORM. THIS IS ACTUALLY PROCESSING
INFORMATION WHEN SOMEBODY SUBMITS
IT. IF I HIT EDIT SO THE INPUT IS
LOOKING AT FORMS. HEY, I'VE GOT
THIS FORM. TO EACH OF THOSE RESPONSES
I'M GOING TO DO A DIFFERENT INFORMATION.
[AUDIO DIFFICULTIES] I'M GOING TO
AUTOMATE THE POWER BI DATA SET.
I'LL GO THROUGH AND SHOW YOU HOW
TO BUILD. THIS IS WORKING MUCH BETTER.
MAYBE IT'S JUST FORMS. IT'S NOT
MY PRODUCT. THAT'S WHY I CAN SAY
THAT. SO YOU CAN CONTINUE. AND IT
BE SET OKAY YOU'VE ALREADY AUTHENTICATED
THE FORM. WE NEED TO CHOOSE THE
ONE FROM IT. SO THE HAPPINESS WAS
THE TOP ONE. WHAT ARE THE FIELDS
AVAILABLE TO ME. I'M GOING TO REMOVE
THIS POWER BI. WHAT I WAS DOING
TO DO THE ANALYSIS AND THE KEY EXTRACTION
AND WAS THE OBSERVE PLATFORM LEARNING.
FIELD EXPOSURE. AND YOU'LL SEE THERE'S
SOME TEXT ANALYTIC FUNCTIONS. I'M
GOING TO DO TEXT ANALYTICS, AND
FLOW GIVES ME THE ONE THAT ARE IN
SIGHT. I'M GOING TO ANALYZE THESE
WATCHING THE POWER BI DEMOS WHAT
MAKES YOU HAPPIEST. I CAN GO THROUGH
AND DO THE SAME THING FOR THE KEY
EXTRACTION. MAKE SURE YOU THINK
ABOUT ALL OF THE FIELDS YOU'RE GOING
TO WANT TO PUT IN YOUR POWER BI
MODEL UP FRONT. BECAUSE THE NEXT
STEP IT'S A BIT OF A PAIN. IT'S
A REAL PAIN IF YOU WANT TO EDIT
THEM AFTERWARDS. I NEED TO KNOW
WHAT WORKS. SO LET'S GO DO THAT.
SO OVER IN POWER BI FIND THE WORK
PACE THAT YOU WANT TO CREATE YOUR
DATA SET INTO. HIT THE CREATE AND
YOU CAN CHOOSE A STREAMING DATA
SET. THE STREAMING DATA SET IS THE
CRUCIAL BIT. YOU CAN USE A FEW DIFFERENT
SOURCES. A API. THIS IS A NAME.
HAPPINESS DEMO. WHAT FIELDS ARE
GOING TO BE AVAILABLE IN THIS DATA
SET. THIS IS WHAT I MEAN I NEED
TO KNOW THIS UP FRONT. ONCE YOU
SET THIS YOU CAN'T EDIT IT. SO I'M
GOING ON TO PUT NUMBER IN HERE.
AND YOU'LL SEE YOU GET THIS BLOCK
OF JSON. IF YOU WERE DEVELOPING
AN APPLICATION THAT WAS GOING TO
USE THIS DATA SET THE LAST THING
I'D SUGGEST FOR THE DATA ANALYSIS.
BE TRAEMING SETS FOR THIS KIND OF
REALTIME UPDATE. WE KEEP AN HALF
AN HOUR OF DATA. SCHEMA HAS BEEN
CREATED. BACK OVER INFLOW I CAN
SAY OKAY, PICK MY WORKSPACE, PICK
MY DATA SETS. GOOD. I'M GLAD THAT
WORKS. THE DATA SET AUTOMATICALLY
HAS ONE TABLE IN IT CALLED REALTIME
DATA. YOU'LL FIND THAT WHENEVER
YOU CREATE ONE OF THESE STREAMING
DATA SETS. YOU CAN SEE THE THREE
FIELDS I DEFINED. I'M GOING TO DEFINE
WHAT FIELDS FROM MY FORM AND FROM
MY AZURE MACHINE LEARNING OUTPUT
DO I WANT TO PUT IN THE MODEL. I'M
GOING TO GET MY KEY PHRASES. SO
YOU SEE IT NOW WHICH GIVES US THE
CURRENT DATE. AND THEN I'M GOING
TO HAVE MY SENTIMENT SCORE. HIT
SAVE, AND HOPEFULLY IT TELLS ME
MY FLOW IS READY. SO I'M GOING TO
HAVE TWO FLOWS. I'M GOING TO BE
LISTENING TO THE SAME FORM. I CAN
SEE MY FLE. I CAN START MONITORING
IT HERE. ONE THING I DIDN'T TALK
ABOUT IS SETTING THE AZURE LEARNING
MACHINE A BIT. WHEN YOU FIRST ADD
ONE OF THESE KEY PHRASE ANALYSIS
STEPS INFLOW IT WILL ASK YOU TO
MAKE A CONNECTION TO AZURE. YOU
NEED TO SET UP IN AZURE. HOW MANY
ARE TWITTER. EVERYBODY SHOULD GET
ON THE TWITTER. BECAUSE THE POWER
BI PLATFORM ON TWITTER IS FANTASTIC.
IF YOU HAVE ANY QUESTIONS SOMEBODY
WILL GIVE YOU AN ANSWER. I'M GOING
TO SHOW YOU THIS ONE. I SHOULD HAVE
HAD THIS OPEN. WHEN I LOOKED BEFORE
IT WAS THE FIRST BLOG THAT CAME
UP. SO THERE'S A LITTLE CONNECTION
BETWEEN FLOW AND THE AZURE MACHINE
LEARNING. YOU KIND OF AUTHENTICATE
WITH IT AND THEN YOU CAN START USING
IT IN YOUR FLOWS. IF I GO BACK TO
MY OTHER ONE. AND YOU CAN IT'S READY
TO GO NOW. ON THE POWER BI SIDE
HAVING CREATED THIS DATA SET I NEED
TO BUILD SOME VISUALS AND SOME DASHBOARDS
ON TOP OF IT. LET'S JUST QUICKLY
PUT SOME IN IF I GO BACK TO MY FLOW
AGAIN. USE THE 9:00 A. M. AGAIN.
YOU SHOULD SEE ONE OF RUNS APPEARS
DOWN HERE IN A SECOND. I'M HOPING.
FORTUNATELY I HAVE ONE ALREADY SET
UP. WHY DID THAT NOT RUN. SO I'VE
GOT MY HAPPINESS DATA SET WHICH
HAS GOT SOME DATA IN IT. AND THERE'S
TWO THINGS YOU CAN DO HERE. YOU
CAN DO IT THROUGH THE WEB BROWSER.
MAYBE IT'S BECAUSE MY -- YOU CAN
EITHER BUILD IT THROUGH THE BROWSER.
WHAT I'D RECOMMEND USE POWER BI
DESKTOP AND CONNECT IT TO THE DATA
SET. THE REASON I SUGGEST DOING
IT MEANS YOU CAN AND I CAN STILL
CREATE SOME OF THESE CALCULATIONS.
WHEN YOU SET UP THE REPORT. CHOOSE
FROM THE POWER BI DATA SET AND THEN
IT WILL LET YOU BROWSE THROUGH YOUR
PACES. I'VE GOT CALCULATIONS I ADDED
ON TOP OF IT. TO WORK OUT WHERE
PEOPLE ARE HAPPIEST. I ALSO DID
SOME CALCULATIONS ON THE TYPE. SO
THE TIME STAMP THAT CAME FROM FLOW
WAS THE UTC DATE. I WANTED TO HAVE
SOMETHING SHOWING ME WHAT WAS THE
LATEST SUBMISSION SO I COULD SEE
IN MY VISUAL WHAT WAS THIS THING
SUBMITTED. WHAT I DID FOR THE U.
S. A. VERSUS THE REST OF THE WORLD
I DIDN'T DO ANY CODING. IF YOU SUBMITTED
ON AN OLD SECOND YOU WERE U. S.
A. AND IF YOU ADMITTED IT ON AN
EVEN SECOND YOU WERE OUTSIDE OF
THE U. S. A. SO MY LOCATION. I PUT
MY MAP -- IS IT NOT MY INTERNET.
IS IT ME? ANY OF THESE. LOOK AT
IT BY LOCATION AS WELL. MY MAP DATA
IS NOT UPDATING FOR SOME REASON.
PUBLISH THAT UP TO THE POWER BI
SERVICE. AND YOU CAN START PING
THINGS TO THE DASHBOARD. DO THAT
THROUGH YOUR DESKTOP SO YOU CAN
HAVE A CALCULATIONS ON TOP. IT'S
USUALLY A GOOD SUGGESTION. I CAN
PIB SOME OF THOSE THINGS TO MY DASHBOARDS.
I SPENT A BIT OF TIME FORMAT AND
RESIZING THINGS APPROPRIATELY. BASED
ON THE FLOW AND PUSH IT THROUGH
THE DATA SET IT WILL UPDATE STRAIGHTAWAY.
WHAT I DID FOR THE FORM IS THAT
WHEN I COME TO CREATE A NEW TILE
I'VE GOT AN TILE TO THIS DASHBOARD
JUST PING IT FROM A DATA SET. LIKE
I SAID WHEN YOU'RE ON THE FORMS
SET YOU CAN GRAB AN URL TO EMBED
ANYWHERE. AND PLACE IT IN THE EMBED
CODE AND IT GIVES YOU THE I FRAME.
SO IT'S A REALLY SIMPLE WAY OF EMBEDDING
THAT KIND OF DATA INTO THIS. THE
OTHER THING I DID WAS MAKE THE FORM.
IT'S PUBLICLY ACCESSIBLE. I THOUGHT
ABOUT DO THIS THROUGH POWERAPPS.
BUT I CAN MAKE THAT AVAILABLE TO
EVERYBODY UNANIMOUSLY. YOU'VE GOT
TO BE AUTHENTICATED TO POWERAPPS.
ANYBODY CAN USE THIS. BUT THEN I
HAVE THE PROBLEM WELL, I CAN'T MAKE
THIS VISIBLE. I'M HOUR THE POWER
BI OR POWERAPPS TEAM WILL FIX THOSE
THINGS THAT'S KIND OF EVERYTHING.
SO WE SET UP THE FORM. WE SET UP
THE FLOW TO SET UP THE SUBMISSIONS.
PUMP IT INTO THE POWER BI DATA SET
AND THEN PUT IT ON THE DASHBOARD.