Data Studio: Visualization & Reporting Solutions to Enable Better Decisions

hello everyone and welcome to the webinar an overview of Google Data studio I'm Dave Ekman chief technology officer at Cardinal path and I'll be moderating today's session we will have time for questions towards the end of the presentation but throughout this presentation you can feel free to submit through the question panel on your screen we're also recording today's session so everyone who registered will receive a link to the recording after the webinar we're going to kick things off with a quick poll to better understand where we're all at in terms of dashboard adoption if you can please just select the one or ones the best fit your current state this just really helps us understand are you currently actively using dashboards and reporting within your organization to make decisions and to drive analysis and insights maybe you actually have some setup but you know they tend to be emailed out and nobody really looks at them or you don't really have anything in place at the moment while we await for the results to come in I'm going to introduce today's speakers I'm joined today by my colleague Mary Andrews director of digital intelligence with Cardinal path mary leads visualization efforts for a lot of our clients and knows what it takes to bring data to life through dashboards Mary welcome to the webinar today thank you and we're really excited to have none other than Nick mulaskey Google's lead product manager for data studio if you're already a data studio fan or have been using Google Analytics for a long time you'll probably know Nick as he's been at Google since the acquisition of urchin the precursor to Google Analytics at Google Nick leads a team of product managers who are focused on building data integrations machine learning interactive visualization and mobile experiences Nick will walk us through key features of data studio today talk about what's new and even take us through a live demo of the tool Nick welcome and thanks for taking the time to help us deliver this over data studio overview it's really great to have you on the line today great thanks for having me so Melissa have the results come in yet yeah it looks like the results have come in you know there's an it there's an interesting split here where we do see that there are quite a number of folks using dashboards to help drive some of their deeper analysis and insights that they might be doing so that's really great to hear and then a pretty even split across the board with some of the rest so it gives us a little starting point there and looks like a number quite a number of you have experience already with dashboards within your organization Mary I'm going to pass it over to you to take it away thanks Dave okay let's dive right in with you see the agenda here and we'll talk about a little bit about dashboards a case study why data studio demo and then talking about success beyond so I'm going to jump right in good Forrester quote here 90% 97% of analytics and marketing professionals still use spreadsheets to produce analysis and measurement outcomes and I have to say as an analyst at my core I'm going to continue to use spreadsheets pulling and calling data in a program like Excel is something that helps me generate deep inside but in the fast-paced digital marketing world the spreadsheet spreadsheet based approaches no not really going to cut it we need to have fast actionable insights that we can turn around especially to our marketing teams focus on those core KPIs spreadsheets often lack the data points it's just data points that might lack context in the takeaways that will persuade and drive action so in these ways we find that dashboards provide a fast seamless consistent way for us to share our data and our information across our organizations and given that it looks like from spending surveys up to throughout 2017 12% of company revenue looks like it's going to be spent on marketing budgets it's in even more compelling reason for us to get real-time visibility into our marketing performance and extreme and a schema and accelerate that reporting process in this way dashboards are key tool in our toolbox and we want to make sure we have those actionable insights at the fingertips of our marketers daily if we can to that end Forrester has another good quote dashboards act as a catalyst to change perspectives of marketing performance and help allocate your marketing spend so for all these reasons we can't underscore enough that dashboards are a core tool for today's marketing environment talk a little bit about the values of dashboards and the proposition here but before we talk about this first step back what a dashboard is not it's not an analysis Perseids tells you what is going on with your data but not often the how or why but it pees us up to do those beaver analysis by starting with one source of data truth so a solid value underpinning of a good dashboard is that it's pulling data from one place there's there's nothing worse than two teams within an organization get two different reports saying two different things based on data sets that should be similar or aligned and we know that once we lose that trust in the data the organization might not even look at the dashboards again or look at the data set and then we lose that kind of data is the core underpinning for us to be able to do these optimizations and we wanted people in to engage with the data so core value set one is making sure dashboards are all pulling from one source of data truth and we can operationalize that so it takes a lot of that manual effort and potential potential data issues out of the equation right away - it brings your data to life with beautiful visualizations and some of the key study examples we'll show today are a great example and more that marketers and I say I myself fall into this trap is it looks great I'm drawn to it I want to know more so that visual aspect really engages our teams and gets them really bought into using the dashboards and not just leaving them languishing in an inbox somewhere leading to I think once people start engaging and actually using them they start collaborate they start to share and that's another key pillar of a useful dashboard is that you know contribution across teams and sharing which to me leads to the fourth key pillar which is driving questions that can really uncover deep insights so to say like we're collaborating on a project and see this dashboard is telling us something interesting how can we learn more so it gets people engaged with asking questions about their data and therefore again driving more insights driving more action ability across your organization so these four pillars kind of coming together to form the backbone of the data value proposition or dashboard value proposition I want to talk a little bit about data studio so as you can see here data studio it's one of the seven products in the analytics 360 suite this webinar webinar is one of the series is covering all those products but today we're focus on data studio it sits on top of the entire suite it acts as a visualization engine for all the great data being generated and why I use it a little bit I just get a get a little personal but I think Davis studio not only is the ease of use I just love being able to jump in grab data start a chart and I think that lower barrier really is going to encourage your team to start interacting with the data more the dragging drop is what we'll get into it the demo with Nick and a few minutes kara just you'll see that seamless ability to pull your data in a snap integrating with different types of data and you'll see especially not only can we pull in GA data based on the pillar of the product suite we just saw on the prior slide but there's many ways to pull in data from other other sources say your marketers have a spreadsheet sitting somewhere well pop it in a G sheet we'll connect it right to data studio so it's a great way to pull data in from various places and the design again can't be beat has some of the most beautiful options for presenting data that I've seen as a tool on the mark today so for these reasons data Studios of course will we use across many of our client engagements and with that I wanted to talk about PRP bombardier recreational products who are using as you can see here a screen shot example of the beauty of the dashboards they've created for their marketing team and so we're talking about multiple brands doing having all the same dashboard options available coming from a similar back end but being able to elevate these reports up to see Suites and and then where it's constantly evolving creating new dashboards very different as people start to see these and engage you can't imagine the amount of collaboration we see with different members asking for more data I want to see this how about that like you really get people engaged when you present them something as beautiful as this a couple examples of some of the reports created what's cool here it's a cockpit level view you know your sea levels may just be keyed in on your core KPI is shown here what's amazing about the estudios the presentation of the state of its back-end that actually feeds this we're talking about current data last year's data and plan data all together in one view so this is powered by bigquery and again cooling in data sources from multiple places to be able to put so many key metrics on one visual and again at a glance you can see what's happening today against what's planned and what happened last year very valuable to the various teams additionally the fact that you can check out the whole of regional around the world all the data together break it down by whatever region or country is important to you another way I like to use data studio is to plug directly into Google Analytics and I know within Google Analytics you can pull up you know a channel or medium report directly but having all this side by side by side on one visual very powerful for marketing teams and again be able to customize the look and feel of this you know customize the colors customize it for your brand palette again very powerful what I also like about data studio is the fact that again it's not just GA centric you know if you want to know what's happening in the social space and Facebook is important to you we're able to pull that data and again make a big query table that surfaces all your important Facebook metrics but in YouTube actually is a direct connection to data studio so in one view we have side by side to reports that again if you were to try to call this in Excel and create a spreadsheet and then try to create this kind of visualization it's going to take some manual effort here everything's plugged in updates in real time and side by side you have your social network so with that I want to hand it over to Nick to go into a bit of our data studio demo great thanks no problem so if you jump to the next slide please so what I wanted to talk a little bit about is some of the vision and driving factors to why we actually created Google Data studio you know at Google it's unique because we get to work with many different customers across many different businesses and industries and at Google we actually generate lots of data so we get a lot of data points on how people work with data what's fascinating is when we talk to all these different users they all go through some sort of a common workflow as to working with data where they need to be able to access data collect it they need to be able to prepare it in some way analyze it to get some insights share those in sar curate those insights for stakeholders and then being able to share them and what we found is that today as you're going across these stages you're typically using some sort of tools and limit limitations in any of the tools at any of the stages causes you to leave the tool you're using and go and use a different tool so the next slide please and so when we started talking to customers about all the different you know tools that they're using to get to the workflow it's amazing they actually many people use many different tools like think about the process that you have to maybe pull together to put a report for your stakeholders or your customers or your partners right you have to go and get the data maybe it's in a database maybe it's in analytics maybe it's in Facebook or YouTube like we saw earlier you have to get the data out and somehow get the data into a format in the right date range so that you can compare it properly so you're doing that in Excel may be using sequel may be you know learn how to do sequel or you're learning how to use sequel to to manipulate the data in a way you want to do it then you're you might want to look at some of the insights right how do you how do you visualize the data how do you explore it how do you answer some questions that you think the stakeholders are going to ask so that way you you can answer up so you're using a tool there's many tools on the market today so what we generally find is when you start to communicate those insights you're usually pulling that stuff into a PowerPoint or Google slides of some sort of other media which you communicate and then those are getting emailed out to to the stakeholders all right there's so many different stages along that way so many different tools now how many times have you shared your report with the stakeholders maybach oh well what if we did to look at this differently or team add this other data you have to actually go through this whole process again which is super time-consuming the other use case that we hear a lot is after you've gone through this monthly maybe you're doing it on a cadence of a month you know the executives love the reporting phase that's just fantastic we get on a weekly basis on a daily basis and because there's just so much friction it actually becomes really time-consuming very difficult to do this on a regular basis so what we find is that the it's not necessarily the functionality that that doesn't exist but rather the convenience and ease of use that make it very difficult for people to actually go through this workflow regularly and it's very difficult for many people in the organization to actually work with data answer questions because they just don't have the time or the skill so they haven't had the training to use all these different tools to be effective with the data next slide please so the vision here with data studios how do we actually make it easier for people to go through this workflow and we have a couple different tools within data studio one of them is a tool to make it easy to access data we can connect to data import data transform data we have a tool around how making it easy to explore data answer questions make it really easy to query the data and then we have a built in experience around making it easy to communicate the data to stakeholders a share with them it's all integrated we'll show in the demo and the whole idea here is by making it easier for users to go through this flow we can start empowering users who traditionally don't have the time or resources to use the tools on the market today and enable them to make better business decisions and if you think about it like how do our decisions made in organization today generally you'll have an embedded analytics team who do have the resources and time to make decisions and they become the centralized analytics team for which everybody in organization goes to to gain some insights and so our vision is how do we actually empower everybody in an organization to have the tools available so that they all can make better business decisions and it's not bottlenecks and centralized but rather democratizing this ability to make these decisions so that's a high-level overview of the product what I want to do now is just jump right in and show you a demo of how it works so I'm going to go hopefully you can see my screen yes yep let's go at your screen Nick perfect so anybody can follow along we made the product completely free we started with calling it daily studio 360 then we offered a free version and then we decided to make the whole product free so anybody can follow along go to data city of Google comm and you can follow up so what I'm going to do is show you take you through the product by creating a brand new report I'm gonna go ahead and click on blank okay the first thing I need to do is add data to the report so I'm going to click this create new data source so we have a bunch of connectors to different types of data and we're continuously adding more and more you know at Google we have a lot of popular products so we've added connectors directly to those products we've we know a lot of data lives outside of Google you know in the on-premise data so you have connectors to my sequel and Postgres different databases we also have generic connectors like sheets and bigquery which allows people to have data maybe that we don't have a connector they can go through these other mechanisms and get data into the product finally recently we launched the ability to upload files so we have two gigabytes of storage that you can add files and append data to do it so for this demo I'm just going to go ahead and click on analytics Google Analytics and I'll go ahead and connect here and I get a bunch of data default so I'm just going to go ahead and use this data and add it to the report okay so I've added my Google Analytics data to reports that easy and now I'm going to start building a report so we really try to design this to look like an application product and to start visualizing data I can go into this tool bar I can click time-series and I could just go ahead and drag and drop the visualization directly on the canvas and what we really wanted to do here is empowers users to build experience around their data exactly the way they wanted to do it so I visualized this time series and notice that we understand the concepts of days we understand some of the default you know data that's available in Google Analytics that we've connected to and just like that or visualizing data now there's a bunch of different charts and I can go ahead and switch this to charts so I can go to a bar chart I can see it we have combo charts we have pie charts and notice that we're updating the data to give a good representation of how it should look to make it really easy to play around with the different data so what I'm going to do is go ahead and just create a little report I'm going to ctrl-c ctrl-v with a copy and paste this I'll bring this down here why don't we make that into a map or ctrl-c ctrl-v one own I come over here and make this into a pie chart and I'll go ahead and add a little text box here example Ford alright let's just make this a little bit bigger like a title great these look a little bit low so why don't I go ahead and bring them up here and now I can go into this view experience and just like that I've created reports and under a minute that's starting to visualize my data right very simple and so we've added a lot of customization and capabilities to the product as well so for all the data I have access to that I'm connecting to I could come in and configure anything so here I'm looking at sessions here we have like all the data we have in Google Analytics so if I wanted to look at for example users I want to potentially do a user centric report I can go ahead and add users if I wanted to add another metric that maybe percent percent new sessions which is new users I could go ahead and add that as well now that's going to actually you know percentage is going to be on a different scale so they have a bunch of different style options where I can actually click the second series here on the right side to get the right percentage so just like that I can start playing with the data we make it really easy to customize these things and one of the things that we wanted to do is make it really easy for people to make these reports interactive right you know sometimes you'll create a static report and we'll share it and then your stakeholders will start asking questions well instead of having them come back to you and then you update and report we want to make these reports interactive so they can start answering their own questions so the first thing we have is the ability to add a date range here so I can go ahead and add a date range I can go ahead and set this to any sort of default so we can say last 28 days and apply it and then when I go into the View experience I have this little control that I could click on and then now any of my viewers can now interact with it and notice how everything's updating here on the fly right really easy way to make these reports interactive for for data that that's training over the other thing we have is the ability to add more dynamic interactive filters so let me just move this over here and I'll go ahead and add what we call our filter control so the filter control there's a couple ways you can visualize it there's a drop-down but I like expanding this out here and so here I have medium I can actually configure this to have any of the dimensions in Google Analytics so for example let's say I want to look at the default channel grouping great I could just add it on here and so now when I view I have this control here and so if I wanted to now look at the total number of users and percentage of new sessions for my social campaigns I could go ahead click on that and everything now updates right if I want to now look at email I can go ahead and do so and start exploring about how my emails campaigns are trending over time you find this really useful because if you start exploring you know when you look at the total you see one story but when you start trending out the details we start to see that sometimes there's some spikes that lead to total to be really large but they're actually not sustained over a period of time so again this is just a really quick way an example of how you can put together a report really fast within the data we have access to on in your data using studio so we talked about creating these reports one of the things that we also heard from a lot of customers is they had a hard time sharing reports all right usually put this in a PowerPoint and you email it around and then somebody adds something to it and so you start adding versions and then you have a whole thread of question conversions of attachments it's pretty amazing how much work is it's just around managing these things and so we looked at Google of how do we make sharing easy and we just saw that Google Drive was actually really easy mechanism so we completely you know integrate with Google Drive I can make this report completely public so anybody who has access to this can view it or I could turn it off if if I want to keep it private one of the things I want to do is so Mary if you can help me here let's say I wanted to add Mary to have access to M Andrews I think right yeah that's it that's Cardinal path got it does that look right so I'm going to give Mary access here to edit this and I'll go ahead and yet they picked it up so I want to send it to her in invitation so what she should get is an email asking inviting her to come into this report that I just shared access with her and so you must have seen it as I see you here now in the report and one of the other things that we've integrated with our G suite and Google Drive is the ability to collaborate in real time so Mary if you can go into the edit mode to give you access to and if you can click on one of the charts what I could see is Mary here is in the chart as well so maybe we can change some of the colors and look at fields maybe we can use green and so what you can see here is Mary can go ahead and update the colors up at the top in the chart and I could actually go ahead and update the colors online down below and what we've integrated here is this concept of real time collaboration and so where this becomes really powerful is what we see is people creating reports sharing the reports with executives and executives start saying well what if we could change X or Y and see instead of going back and taking a whole bunch of time to go through that whole workflow that we talked about earlier you can actually go into edit mode change it in real time and everybody who has extra port can see the updated information so it dramatically save significant amount of time to reflect what you actually want to see it becomes really powerful when somebody asks you to for some new information and instantly you can give it to them without having to go offline pull the information and then rejoin in conversation yeah and I love this feature we work and really distributed teams and same with our clients they're often really distributed so being able to really work in real time with them as you talk things through is really helpful and valuable yeah absolutely yeah you know it's kind of interesting because when you think of dashboarding you think of okay well this is a this is a way to just know report on my data but in many ways with the dashboard is and it was you know what work the way we view it is really is a communication channel it's a way to communicate your data to other people right and the ability to have flexibility you know the flexibility over how you communicate is what differentiates effective communication versus non effective communication right in some ways is that you can think of why do we have salespeople right it's to help other people make a decision on what to buy right and and that requires tailored tailoring information to the audience and that's really what it's all like data studio starts enabling you to do and if people start giving you feedback around you know the dialogue you're having around the information being able to react in real-time to update and reflect what they're interested in becomes really powerful great so that's a quick overview of the of data studio there's a ton of features that you can do a more advanced demo in the future but for there why don't we leave it at that and let's go back into the slides possible Thanks so a couple key benefits of the product as I mentioned you know being able to streamline communication with stakeholders it seems like a small thing but it's actually really important when you have a big is that you know big presentation you really want to focus on getting people to take action make decisions when you look at how data is presented in the current product it's one size fits all and so it's really difficult to actually get people to look at the exact thing you wanted to focus on what the product like data studio you can really tailor the conversation around getting the other parties to take action to make improvements and we see that as a huge benefit we're seeing a lot of people saving time a huge amount of automation happening where instead of doing a bunch of manual reports they can use a product like data studio to be a lot more productive you know some of the company we wore it with in the past they'll have a central team that you know specifically like around a publisher where they have the news for a lot of editors want to see they're the you know the performance of the articles that they're writing what they'll traditionally do is they'll go to their analytics caveman and ask them to build reports so this analytics team is not really doing analytics or analysis they're actually doing a bunch of reports that are being asked so we're seeing the ability to actually give that task of reporting back to editors using into likes video because it's so easy to use enable them to self-serve as well as allowing that team to not just be as sometimes we call like recording monkeys but really focus on the more important things that they're getting paid to do clearly empowering more people in the organization with data allows them to make better decisions you know again if you know as more users come online and start interacting in a digital world amount of data that's being collected explodes the challenge is how do you manage that data and if you have one team that's the owner of all the data of your organization it's going to be challenging for other people who are not who don't have you know a resources within that team to actually use that data to make decisions and with this tool like data studio abilities democratize data make it accessible allows many more people to help drive those decisions on a day to day basis and finally you know if you need to know the reasons why choose the product we made it completely free there is no paid version right now so you can definitely save money on your bottom line especially if you're an agency and you're paying for other products you know definitely give it a try is a you know it could affect your bottom line so we want to benefits for the product go to the next slide you know again you know we're actually adding we have a whole bunch of different reporting connectors today as I mentioned we have the ability to import files we're working on a bunch of our Google products we're actually working on adding a whole bunch of more connectors there's some really exciting things that we're looking at of kind of rethinking the space around how we can add many there's too many different products in a Google fashion something unique in exciting so stay tuned for that but the long-term stories we realize that data is not just an analytics it's not just at Google it's in many different locations so we built a Productivity as data agnostic as possible and we'll be adding many many more sources that allow you make it easy to access your data through the product and finally kind of relax peace here is this really simple sharing you know there's some really interesting things because we leverage Google Drive where you can share with anybody who has an email address but you can also share with Google Groups it's a great way to manage you know different you know sets of users you also have all the organization capabilities Google Drive so we've seen some you know more sophisticated people what they'll do is they'll have a folder in Google Drive for their customer they'll add a bunch of different reports they'll add a Google Group to have access to the folder and then they'll manage access to all the different reports to that group which then in turn gives all those users access to all the different reports in the file so there's a lot of really powerful organization capabilities that we're leveraging by integrating with with Google Drive and then the ability to actually not have to have versions where you're sending and updating you can just have one object that you're always updating that's always the light latest status that evolves over time to be more and more accurate we have a bunch of dashboards that we create for our product you know for data studio to look performance and it's interesting that over time you know that it grows it changes we adds better metrics as we collect better data and so it evolved into something where we have many people looking at it and we and we have more and more trust in the data and more and more facets of the business that we're able to measure because it's this kind of live ongoing experience and then finally the last part is the you know the collaboration with other users in real time you see it is really a unique aspect of in really interesting technology we can leverage but then making it a lot easier you know to keep things in sync work with other people leverage the experience of others to build out these experiences cool thanks Nick so data studio I mean again can't say enough of about my love of the tool and because it satisfies the anatomy of a successful dashboard as we've outlined here so piggybacking off of everything you were just saying Nick meaningful metrics giving users control having them be able to interact I think that's key because that's one of the things with data studio as we saw in the demo it's just once you get people interacting with the tool looking at data get their hands in the data it's going to really increase your adoption there's nothing worse than as analysts when we spend a lot of time creating reports that do languish in someone's inbox whereas the data studio we see quite frankly the opposite as we're creating these types of visually beautiful meaningful dashboards and socializing them within our organizations that the adoption increases and we're delving deeper and deeper as Google also makes more connections available as well in the time efficiency again can't be bee buzzing worsen a lot of by hand data calling and data manipulation and then again those connectors with things like bigquery where we can create whatever reporting tables we need and connect with data studio it's a beautiful thing so in all these ways it's a fabulous dashboarding tool when we really believe in of course going beyond the dashboard we touched about on this throughout the presentation but dashboarding is a super tool to be able to monitor your metrics and and keep your finger on the pulse I often like to call them like pulse report so you know what's happening especially in the digital space because it's evolving it's happening so quickly but keying off those insight insights and analysis opportunities dashboards are great for that and potentially not the best for doing real-time analysis of course can creating dashboards on-the-fly for analysis a little bit deep I mean I could see a potential use case for that but usually dashboards are great to set up make sure you have your back and turning away plugging in that data and consistent way elevating those metrics to your your whole team and then pulling in those analysis opportunities as the outcome and that way you can drive data towards true insights and again continue to engage and optimize your marketing efforts across across your brands and across your organization so at this time I guess we'll pause um gave and hand it back to you if you want to add in any question that was fabulous thanks a lot Mary and Nick definitely there's great session we've got a number of questions that came in so let me dive right into them let's see here we've got so Nick you talked about there's a there's a two gigabyte limit of file upload space is that related to your Google Drive space limit so potentially folks could expand that limit if they have a larger space in their Google Drive that's a great question so right now actually we store all the data in Google Cloud storage part of that is that you have a little bit more flexibility around how you manage the data a little bit more data centric right now we have a free version for two gigs today and clearly if you want to and you don't have to sign up for anything you just drag and drop a file into your browser we uploaded it you start analyzing if you wanted to have more storage you can clearly pay for it for Google password and then you can import huge amounts of data and then you know that's one of the I think unique assets about the product is that because we integrate closely with their cloud infrastructure we can actually scale to really large amounts of data set so if you have terabytes of data you can import it and then we have ways that you can inquiry that directly within studio as well so we're really seeing cloud is the ability to Google cloud scale processing for your large data sets and there's a whole you know model where you can pay for more storage processing top of that as well awesome another one here I think this is you as well Nick how does security and permissioning work is it a live connection or is there an optimized sort of data extract happening under the hood that's on Google infrastructure yeah it's a good question I think you know security is it's a tricky question if you have so many gradients of security you know at one end you have people emailing documents around for other users where you have zero control over once it's emailed out how it gets forwarded on the other side everything is very restricted and you have to have full access to the underlying data in order to view anything right and so what's to do we try to support all the gradients and so at the most restrictive level you can repute you all the users have to have access to the underlying data in order to be able to view any of that data through data studio but we've also made it very accessible to for non sensitive data so you can actually take a report and make it public and then anybody on the Internet can actually view that data and be able to work with it until we provide all those controls within the product on how you can customize access the data and I think at the end of the day there is some implicit trust but who are you giving access to data and we've also found some really interesting you know insights about how other people think of working with data where you know one of the really nice parts about studio and analytics is that when we talk to people using Google Analytics they find it challenging to share Google Analytics with other people in the organization because there's just so much data and a lot of people start asking questions and that team doesn't have enough time to answer all those questions and so what they end up doing is just not sharing the data with studio you can actually create a report and then give only view access to that report and any viewer can only see the data that's been in the report and we're seeing that really helping out these companies curate an experience of only these days that they want to show and then just allowing only the people or you know the audience just see that subset of data in a very you know you know easy to configure way so definitely a lot of ways configure sharing we're seeing a lot of interesting powerful applications of it yeah we really like that last bit there where we can create a dashboard with all kinds of different pieces of data but the users can view the dashboard but don't need or have access to the underlying sources of data whether that's Google Analytics or bigquery or Google sheets or anything else which which is really great Mary I think this one's probably for you you work across a variety of different tools does data studio replace tableau that's a that's a question we get quite often I don't think I think they both have strengths and and they are very different in terms of their strengths whereas tableau on the fly you could be merging and transforming your data now with that great power also comes great responsibility where I've seen actually the generation of incorrect reports because metrics weren't merged or um you know you can really kind of screw things up if you don't know what you're doing in a very big way with Pablo so tableau in itself it has a lot of those deeper transformative capabilities on the data side and that again to me is what delineates it from something like data studio which case it's on top of the data structure so you're not going to be transforming your data in real time in data studio instead you would potentially again in my case of you said query to do that to create my reporting tables merge data sets that I need to pull together and then from the reporting table connect to data studio so all of that transformation data merges everything is happening separate from the visualization tool and to me that creates a very nice clean line so not saying that again putting my I'm kind of favoring data studio in the scenario but I do find that actually prevents users from making data manipulation and errors with their insights that they find through the dashboards because you're kind of keeping them only to the metrics that matter that they should see in their reporting tables rather than with tableau where you're opening up all of that to the end user in in a lot of cases things can get a little screwy yeah and so I guess it depends it sort of is dependent on the use case where data studio could potentially replace tableau in many cases and there's other cases where you might want to leverage one or the other specifically but sounds like from what you're saying tableau is a bit more of a because of some of those those deeper aspects that it can go into it's a more complex tool which also requires a little more experience in training to use great hundred-percent awesome just a just a few more here appreciate it guys so NIC we had this one before so if you're I'm going to pass it to you but if you can't answer it I think I have sort of the answer that the we've had from from Google in the past but this is one that comes up pretty regularly for us and I haven't had it specifically on data studio but are there plans to make data studio HIPAA compliant for customers in the healthcare and health insurance spaces yes it's a great question I think in the long term the answer is yes we do want to do that there's those HIPAA compliance on the healthcare space and then there's you know there's a bunch of SEC stuff for finance as well however you know getting those like we look at prioritization there's a bunch of capabilities we want to add to the product there's a bunch of SLA s and it takes we want to add as well we think we see those as being farther out of enabling those probably not in the short term I think the broader story is you know we do see HIPAA compliance solutions around G Swedes and Google cloud and and other solutions around there and as we bring data studio closer to those other Suites and solutions we definitely want to find a way to make it simple compliant but I wouldn't wait for it and short term it would probably take some time for us to get there this is another one we get quite often other plans for a feature that supports printers save as PDF you know often we find that that execs and management prefer to receive something where that's sort of printed out for them on their desk or as a PDF and they don't want to have to navigate into some website is there any plans for that yeah absolutely so we hear a lot of that actually it kind of brings up an interesting question for all these feature requests we have a new system if you go to our Help Center look at feature requests there's a new system where you can raise and vote to help us prioritize the features and you can add new features as well this is actually the number one feature requests that we're seeing on that on that on that tool so definitely something that we want to build we're trying to better understand the different use cases of what people want or what they're trying to do we here PDF is the as to ask but then we start looking at like what are the actual things people are trying to do it's more around how do you how do you do more of a push communication allowing people to consume information without logging in anywhere you know things that we've looked at is like maybe we can just put the report directly in the email so your email is the client you don't have to actually have a PDF viewer so there's a bunch of different things that we're exploring so yes it's in the roadmap I'd love to do it this year if we can and if you have more use cases definitely take a look at that resource that we have for submitting more these feature requests so you can get more of your use case to make sure we're building the right there awesome thanks you heard it here first folks just a couple more questions one thing you did mention there the support center and it's something we didn't really call out in the presentation but for those of you interested in giving data studio a try and maybe you want a little intro more intro to the product Nick and the team have developed some great getting started videos that can be accessed right from in the data studio support pages so definitely check those out if you're looking to get things started there so just one last question here and I think we're sort of coming to the end we'll have to wrap it up but you know we had different but similar questions here Iran you know is it possible we didn't you didn't show this in the in the demo but is it possible to bring multiple data sources in at the same time or linked you know such as multiple different Google sheets or multiple Google Analytics views that's a great question it's kind of - two answers to that the first one is yes in a given report you can bring in different you know any of the different data to bring it together you know what we see a lot of people doing is bringing in different like AdWords search console Google Analytics data to really get a better understanding performance of their website in the traffic to it and then you can you know coordinate and and put the right date range across the whole thing so that's possible one of the other things that we're looking at is we hear a lot of people asking to be able to take two different types of data put them into say a chart that's currently not available but again it's something that we're looking to build up and something to add to the product so definitely we see working with data is one of the key aspects of the product making it easy so we'll continue invest in that area to allow you to merge and bring together many different data sources within the product awesome well guys I think that's all we have time for today and you know I think as you've seen today you know a free tool from Google Data studio is quite powerful it's a big advance from what we previously had available and tools such as Google Analytics so you know you and the team have done an awesome job Nick so for those of you attending today you know if we didn't get to your question don't worry we will follow up with you directly to ensure you get an answer and really hope this session gave you some good insight into Google Data studio and some ideas as to how you might introduce or grow the use of dashboards and reporting within your organization we have a broad range of ways to help you ensure success beyond just choosing the right tool and we're going to send some materials out after the after the webinar here including a data studio step by step guide to help you on your way in addition we will send the record into this webinar and you're welcome to share this with your colleagues big thanks to Mary nik for the great presentation and demo i know our teams are passionate about data visualization and we try to continue to even innovate and build upon the capabilities within data studio so it was great to hear you drill down into the benefits and features today as always please don't hesitate to reach out to us at Cardinal path for more info and and thanks everyone for joining us and Nick and Mary thank you very much for your time today great thanks Freddie awesome I hope you all enjoy the rest of your day thanks again [Music]

Channel: Cardinal Path

Views: 220

Rating: 5 out of 5

Keywords: Data Studio, Google Analytics Suite

Id: zOeMh6Z64VI

Length: 49min 35sec (2975 seconds)

Published: Wed Jun 14 2017