in this video I'd like to talk about the
new direct connection capability between
Splunk and Tableau
Software Splunk makes machine generated
data easily searchable indexable and
applies a schema that makes it
accessible to organizations like never
before with the new direct connect to
Tableau Software this data becomes
visualized and explorable in an easy
drag and drop interface simply add some
credentials here to connect to
your Splunk
instance and Tableau desktop connects
directly to the Splunk instance and
accesses any of the safe searches
available as I go through these safe
searches I'm looking oh here's one
online products that have been removed
from a shopping cart that looks
interesting let's go ahead and do that
for the last 72 hours Tableau desktop
connect directly to Splunk is going to
make that data accessible I can connect
live or I can import some of the data
I'm going to go ahead and connect live
and there we go with a couple clicks I'm
looking live at data coming out of
Splunk so in this case again this is
online retail selling products what are
these
products looks like mobile phone
accessories and what I have here is a
count of the number of times someone put
something in their online cart and then
removed it so I have the power to look
at this just get basic answers and again
I'm connected live as this data is
flowing into Splunk I'm going to go
ahead and actually extract this
bring it down to my local machine see
how fast Tableau makes that easy for
me and there we go all done and so now
right I could package up this data and
send it around publish it up to Tableau
server or it could have stayed connected
live let's explore a little bit here uh
maybe I want to know about total overall
removes from a shopping cart over time
I've got this time stamp here and I want
to look at this by day let let's go
ahead and expand Tableau desktop so it
looks like I've actually got about four
days worth of data Tableau handles data
hierarchies incredibly easy and just a
couple clicks I can drill from day to
hour to minute and what I see here is
Big spikes of people removing things
from their carts in early to late
evening and then it dips early morning
and that makes sense to me based on
traffic volume
let's put a little color on this to make
that even more
apparent easy form
formatting why don't we
use something like this there we
go so when those High remove times are
in red and then when that is happening
the least that is in blue but how do I
understand what's normal what's not
normal um how do I understand based on
this data set you know above average
below average you know where is that cut
off um maybe I want to use a basic
statistical principle like a standard
deviation so in Tableau the ability to
do this quickly in just a
couple clicks of my mouse and there we
go with a banded reference line I can
understand what is really high versus
what is actually low right what is
sitting above a standard deviation what
is below and then if I even wanted to
add one
for let's say the average can do that
right
here perfect okay well that gives me a
pretty good overview of this data set
from a Time series I want to dig more
into the actual products themselves
though so I've got these mobile phone
products and then I've got this count of
removes so I can see for this total data
set these various products have been
removed the most times from a shopping
cart for whatever reason well as an
analyst inside of an organization um
using Tableau Splunk is just one of the
many data sources that I can connect to
right it's new and it's fascinating
because I've never been able to look at
this machine generated data from web
servers before but I've also got data
somewhere on my desktop I think in Excel
for
sales there we go so in the same easy
way I was able to connect with Splunk
I'm now connected up some sales data for
the last three days and you'll notice
here that they share a product name
field they're not named exactly the same
way but that's okay because all I need
to do to have them talk to each other is
quickly just say oops there's that
one let's add a custom one there there
we
go perfect I've got the little data
blend symbol there and that allows me to
say what are those remove numbers
compared to the sales numbers ah
interesting right despite the fact that
these guys are getting removed at a
relatively High rate they're also doing
well in sales versus some of these
others maybe not so much looks like I
have some bad data right here but I'm
pretty sure I have this product in that
Excel spreadsheet let's go and
investigate table makes it really really
simple to Simply scan through and find a
situation where oh maybe you've got a
little tiny spelling issue just looks
like a little hyphen was missing there
ah that was actually pretty crucial step
that we took because that's actually
relatively High seller in our sales data
editing metadata right adding value that
you know as the business analysts exist
there is quick and easy to do inside of
Tableau let's do some color formatting
perfect well I've got my time Trend
understanding standard deviation and the
average and total time you know when
things are being removed and when
they're not and I've also got some
compared to sales data here right I've
taken two separate data sources one
being Splunk one being Excel could be
anything could been Google analytics or
Salesforce or you name it and I'm
actually hitting queries off to those
both at the same time let's put both of
those on a
dashboard just drag the first thing I
created out there and I'll drag that
second thing down below it I'm going to
format that make the dashboard a little
easier to
see
perfect uh let's hide that title hide
that title and I'm looking at this and
I'm thinking this is pretty interesting
um it would be really cool to be able to
go back and actually look at you know
I've got this
brand field in my Excel data what
happens if I just drag that in oh that's
pretty cool and then wouldn't it be
interesting to be able to filter things
in and out based on
brand you know what let's add that to
the dashboard as
well fantastic I'm going to move that
right here I'm actually going to take
this little chart and move it float it
right on top of this other one so I get
some more
room perfect I like it space this out a
little bit
and this is looking pretty good data
that previously was unaccessible to me
now through Splunk I can see what's
going on based on these web servers and
these cart removals I can also pair that
up with some sales data that I had and
I'm learning new things um I'm going to
make this just that much more
interactive by saying when I use and
click on things here I want them to
filter data down here and likewise when
I click on things in this little sheet I
want it to filter
up above perfect and I'm just going to
add a little title
here um we're going to call
this
retail
online cart
removals perfect and let's just drop
that little dashboard little color
Legend there fantastic so I like what
I've built here um this is pretty neat I
need to share this with folks
I you know not everyone in my
organization has Tableau desktop in fact
a lot of people just want to be able to
log into our SharePoint or our Central
website or Internet or whatever and look
at this in places that're already used
to looking for information it needs to
be secure as well no problem I'm
actually going to log into my Tableau
server here we go so my desktop is now
talking to our instance of Tableau
server that is accessible via web
browser from across the company I can
schedule the refresh of this if I want
to keep an extract or keep it live I can
do things with authentication I can look
at active directory authentication or
samle you know whatever I need to do to
make this secure take advantage of
active directory groups I'm going to go
ahead and publish this
up and what's going to happen is Tableau
desktop is going to push this up to
Tableau server making it secure and
available inside of a web browser it's
going to pop a little preview here but
what I'm really going to do oh let's go
ahead and took a look at this in Firefox
so this is Tableau server live in a web
browser here's that dashboard that I
just
published available and ready to
go secure prompted for the right
credentials I have the power control who
can download this who can look at it who
can get images from it it's up to me
people can leave comments down here and
all of that interactivity that we' built
in in desktop still available right
inside of the web browser
you'll notice here people have the
ability to subscribe to email alerts
right you can even edit inside the
browser someone looking at this and
realized you know I actually want to
make a change based on the data that's
up
here quick and easy inside of the
browser to do that in fact let's say I'm
in a meeting and I'm looking at this and
I need to view it inside of my
iPad Tableau makes that a decision you
don't even have to smart enough to
understand what type of device is
connecting and optimize it for that
experience with the touch of a finger
I'm getting the same results and those
little check boxes that were so hard to
hit with your finger potentially well
now they fly out and adjust for the
device that it's connecting
to in just a few minutes I've connected
live to Splunk using Tableau desktop I
PED in information I've run analytical
Firepower against it to discover new
things I blended outside data with it
and made discoveries I built the
dashboard and I published it up inside
my organization securely for others to
share and learn the Innovations and
insights Tableau and Splunk together are
a powerful combination for leveraging
machine generated data and driving
Insight inside of organizations