0:00 - Introduction 0:57 - What is Google Data Studio? 1:39 - Create a New Data Studio Report 1:42 - Connecting to a Data Source 2:53 - Scorecards 4:34 - Map Charts 5:02 - Time Series Charts 6:25 - Pie Charts 6:57 - Bar Charts 7:42 - Dynamic Reporting with a Date Filter 8:23 - Dynamic Reporting with a Filter Control 9:25 - Sharing Your Report
Hi, first of all congratulations on the amazing content - I can see (and appreciate) your effort. I can't seem to find the link with the report so I can copy it, if you could please help me with that. Thank you so much!
I have hit a relatively tough question at work: How can I create a custom field that uses the same metrics of a given field, but pulls the data from one year prior? I want to use this to make a custom year-over-year metric for measuring SEO optimizations. The idea is that I can use this information to create a conditional formula for the metric so that if our traffic trends too far away from our baseline that we see it in our GDS report.
awesome videos! thanks! I have just one question, I would like to connect my DB (MySQL) to the Google Data Studio, do you know what is the best way or method to do it? I don´t know if I have to use a partner connector and which one to use
Hi How Can I make a student report using Google Studio. I have my students formative, accumulative and teacher's comments in spread sheet. But I want to share a link where displays one student information. Thanks for sharing your knowledge.
Hi, I need help regarding Google Data Studio. I want to show "Time" from my data source as it is but can't find a way. For Example: Starting Time: 19:15 Ending Time: 20:30 If there's any way to do it, please help or if it could be done on Excel in some way, please let me know. I am making Dashboard for my company. Thanks
Hi Team, I'm trying to create a Chart bar of my sales per hour (e-commerce) (shopify style) but when i have no sales for one particular hour GDS doesn't show this bar in the chart. I would like to have always 24 bars (for 24 hours) and get the "Revenue" from each hours and see on the chart a hole when there is Zero revenue for the specific hour. Impossible to do it so far for me. I couldn't find anything online or on your channel about it ! Any Ideas ? :)
Hello I am trying to calculate an indicator in Data Studio called WMape = (Abs (Sale-Forcast)) (Sale / Sum (Sale)). The problem I have is to want to dynamically weigh the calculation. This weighted is based on the sale. Anyone who can help me with this calculation please !? Thank you!
Great explanation! Have a question - is it possible to build a chart NOT affected by filter? I would like to build a chart showing overall avg. data so we can compare the filtered data with all website data. For comparison purpose, I also wanna know whether Data Studio provide comparison function beyond date range comparison.
tom wong Hi. Filters can be applied to the whole report and to individual objects or groups of objects. Selecting each object and the filter groups them together. I haven’t tried what you want but there must be a way to stop any filters applying to an object.
@@grahamcheetham3043 I found a tricky way to do that: 1) create two identical data sources; 2)use data source A as anchor; 3) use data source B as variable -> filtering data source B charts won't affect data source A charts
Thanks for making great video :) I have question here... I have 2 separate Google Studio Reports 1: Google Analytics - Audience Overview 2: Google Analytics - Behavior Overview Now, I want to make a single "Google Studio Report" by joining these two reports. Is that something possible ? If yes please guide me. Thanks
@@MeasureSchool as google data studio is derived from power view only..as power view was launched in 2013..power bi and google data studio are just derivations of power view..power view is the trend setter..google data studio is the follower
0:00 - Introduction
0:57 - What is Google Data Studio?
1:39 - Create a New Data Studio Report
1:42 - Connecting to a Data Source
2:53 - Scorecards
4:34 - Map Charts
5:02 - Time Series Charts
6:25 - Pie Charts
6:57 - Bar Charts
7:42 - Dynamic Reporting with a Date Filter
8:23 - Dynamic Reporting with a Filter Control
9:25 - Sharing Your Report
Hi, first of all congratulations on the amazing content - I can see (and appreciate) your effort. I can't seem to find the link with the report so I can copy it, if you could please help me with that. Thank you so much!
No doubt the most useful, concise and well articulated 11mins of learning for my business this week. Thanks SO much!
It's not often you stumble upon such great tutorials. Thanks you so much!
Thanks Isak!
Great job of creating a dashboard in 10 minutes! Was clear and concise.
Boom. Awesome video !! Short, succinct and direct to the point.
awesome overview! I'm really impressed with the way you represent things in only just a few minutes!
I have master channel
It's an excellent tutorial! Very clear and concise, thank you 👍👍👍
Excellent
The best!
Great info !
I have hit a relatively tough question at work:
How can I create a custom field that uses the same metrics of a given field, but pulls the data from one year prior? I want to use this to make a custom year-over-year metric for measuring SEO optimizations. The idea is that I can use this information to create a conditional formula for the metric so that if our traffic trends too far away from our baseline that we see it in our GDS report.
How to display last record from GS in score card based on date filter
Thank you! Great video.
thx Marina!
@@MeasureSchool dhshshs
Thanks for at great video! :-) Where can we get a copy of the "Awesome eCommerce Report"?
thank you)
Excellent video! Thank you very much.
can someone please share the link to the report. Thank you!!!
Very useful. Thank you so much!!
I have one question ... I am giving date format to column in google sheets but it is not working with date range
How to hide the number (x) of selected choices from drop down list
Can we connect to Teradata DB, please let us know... Thanks!
Amazing. Thanks for sharing. Keep posting stuffs like this.
.....
awesome videos! thanks! I have just one question, I would like to connect my DB (MySQL) to the Google Data Studio, do you know what is the best way or method to do it? I don´t know if I have to use a partner connector and which one to use
Hi Rene,
You don't need to use partner connectors, a data connector to MySQL databases is provided by Google for free.
amazing !
hi! what you mean with previous period? 3:15
Awesome😍😍😍
Great tips!!! Is there anyway to create a responsive report with GDS?
Hi How Can I make a student report using Google Studio. I have my students formative, accumulative and teacher's comments in spread sheet. But I want to share a link where displays one student information. Thanks for sharing your knowledge.
Hi,
I need help regarding Google Data Studio. I want to show "Time" from my data source as it is but can't find a way. For Example:
Starting Time: 19:15
Ending Time: 20:30
If there's any way to do it, please help or if it could be done on Excel in some way, please let me know. I am making Dashboard for my company.
Thanks
Thank you for the tutorial. Do you know if there is a way to use Google Data Studio to create the kind of maps that Fusion tables used to produce?
This day is good far...
I want to edit the scorecard inside number is getting stuck in that
Thank you ✨
Wow wow wow!!!
Hi Team,
I'm trying to create a Chart bar of my sales per hour (e-commerce) (shopify style) but when i have no sales for one particular hour GDS doesn't show this bar in the chart. I would like to have always 24 bars (for 24 hours) and get the "Revenue" from each hours and see on the chart a hole when there is Zero revenue for the specific hour. Impossible to do it so far for me. I couldn't find anything online or on your channel about it !
Any Ideas ? :)
Does filter still work after you export in PDF?!
Hello
I am trying to calculate an indicator in Data Studio called WMape = (Abs (Sale-Forcast)) (Sale / Sum (Sale)). The problem I have is to want to dynamically weigh the calculation. This weighted is based on the sale. Anyone who can help me with this calculation please !?
Thank you!
Great explanation! Have a question - is it possible to build a chart NOT affected by filter? I would like to build a chart showing overall avg. data so we can compare the filtered data with all website data. For comparison purpose, I also wanna know whether Data Studio provide comparison function beyond date range comparison.
tom wong Hi. Filters can be applied to the whole report and to individual objects or groups of objects. Selecting each object and the filter groups them together. I haven’t tried what you want but there must be a way to stop any filters applying to an object.
@@grahamcheetham3043 I found a tricky way to do that: 1) create two identical data sources; 2)use data source A as anchor; 3) use data source B as variable -> filtering data source B charts won't affect data source A charts
First~! I'm interested to see what we can do with this thing. Maybe we can combine facebook data too?
yes, if you use a partner connector such as Supermetrics
@@MeasureSchool you know paul McCartney?
Thanks for making great video :) I have question here...
I have 2 separate Google Studio Reports
1: Google Analytics - Audience Overview
2: Google Analytics - Behavior Overview
Now, I want to make a single "Google Studio Report" by joining these two reports. Is that something possible ? If yes please guide me. Thanks
I know it all my master account in private days ago...
Please reply, is it possible without sharing it gets refresh automatically in my manager laptop and updates whatever changes I have done it.
You just need to share the report once with your manager. Any change you make later will be immediately applied to the report that they view.
Sorry it takes too long...
It took me 3 minutes to realize "duplicate" was actually "duplicate"
excel Power View is better than Google Data Studio
ok.... why do you believe so?
@@MeasureSchool as google data studio is derived from power view only..as power view was launched in 2013..power bi and google data studio are just derivations of power view..power view is the trend setter..google data studio is the follower
And with power view you can directly export the interactive report to powerpoint which is not the case with Google data studio
This us kinda useless,MAKE THIS WITH REAL DATA.