If you liked this video, try other great Looker Studio (formerly known as Google Data Studio) tutorials on our channel: - Looker Studio Tutorial for Beginners 2024 ruclips.net/video/qCl-HHVBRsU/видео.html - All Types of Looker Studio (Google Data Studio) Charts ruclips.net/video/8Pg0yO6Ijos/видео.html - How to Connect Google Sheets to Looker Studio? ruclips.net/video/wWmQ2vX_qhM/видео.html - Multiple Data Sources in Looker Studio ruclips.net/video/-W4sG5v5Z5k/видео.html - How to Share Looker Studio (Google Data Studio) Reports ruclips.net/video/ZmwYt7tIHRw/видео.html
looks simple but its not simple to do with no one besides you guiding thru step by step, but the power of this tool is immense from this beginner video.
Well done! I used this video as a real-time training tool to work with my data set to create a demo using your instruction. Pause, rewind, create, repeat...success.
I was doing self-study about google data studio. Glad to have watched this video first amongst the others on RUclips. Well explained, and easy to understand.
I am one of the many other commenters that is seriously being helped in my challenge to learn datastudio basic. i want to say thank you for your dedicated time for this quality and helpful video, you got a subscriber.
Thank you so much. I had no clue about Data Studio and I needed to learn it. Thanks to you now, I feel that I am more ready than ever to learn more about that tool and create some cool stuff
May I suggest a video - I like your teaching style from some others. 1. Relationship with what we learn X / Y ... i.e. X = "Dimensions" 2. When you have a Header of years 4 Quarters - How do I get Dimensions / X, to Have the 4 Qtrs - and the make tY the total Sum value? I 'm still looking how to do this Thank you!
Hey Sergey, this was a seriously good video man! I enjoyed it a lot, thanks for taking the time to make this and share it! I come from a BI background and I can see the power behind this tool already, sure we need to be able to establish a more robust data background but this was awesome to start with. Thanks a lot
Hey Sergey, Is Merge data Horizontally is available in GDS. I have a workbook with data in multiple sheets with same column name. I want to use this whole data as clubbed data in GDS. If this option not available directly in GDS, what are the possible solutions. Please Note : Each Sheet has 25 Columns and Row Counts are between 2 Lac to 5 Lac. Thanks have a good day.
I want to thank you for sharing your knowledge on google data studio. I learned how to build my report and create dashboard through google data studio by following your video tutorials. Thank you so much! My only question is how can I remove the decimal point in values? I want to show only whole numbers.
Hi, I am building a dashboard but I am struggling with scoreboard and comparison data from the previous year. When I choose the data it tells me no data. I have data in one spreadsheet everything in one spreadsheet from 2018/2019/2020 How can I do this?
In order to compare data with previous period you should have two columns in a table: date and your metric. You should put date column aka field into "Data Range Dimension" section in "DATA" tab and your metric in "Metrics" section. Note, that data for every year should be in one column for this to work.
Sorry to distract from your main message, but that is a _nice_ opening shot! And done by your own guys too, right? If Railsware's standards overall are as high as the video production values in that cold open, then you guys are cool!
Hello! Wondering if I can get some help here, can't find answers on forums elsewhere....When I use the provided practice sheet, all data are classified as dimensions and not metrics, even though the type is numerical. Any tips on how to solve this? Super beginner here, this video inspired me to learn Data Studio! Thanks so much!
Is it possible to save the report layout and settings to GIT? I would like to have a CI/CD system . Reports created in DEV and approved in UAT, should be moved to PROD via CI/CD.
Hi thank u so much for ur video its quite helpful ...quick question I’m trying to divide a set of column data for percentage however I find challenging..for instance I would like to know percentage of A from A,B,C which consist in the same column
Hi! Great video - how did you make the filtered sheet from the imported applicant data? I'm concerned this will mess up the data flow. Otherwise, I am following and almost able to make my dashboard project! Thank you
My applicant ID has been recognised as a 'number' field, but still is green in colour. How to change it to a metric? Also, there's a blue (metric) named 'Record Count' whose default aggregation is 'Auto'? What's that? That is the only metric being shown.
All fields are green by default. To make a metric out of them just drag and drop them to the "Metric" section in the "DATA" tab and choose a metric type, for example, "Count Distinct" by clicking on the field name. "Record Count" is created automatically and means the number of records in the table by selected Dimensions.
I am really struggling with this from long time ago on how to show ten top values in google data studio and rest as others? in bar chart ...etc. for instance, I have 50 line charts. I only want to show ten top and the other 40 as " others". With a hover on the others find out what are these rest unless you click on it.
As far as we know Data Studio doesn't support such functionality. You need to prepare your data beforehand, for example, in Google Sheets or Python / R.
Great video. Thank u. I have a question though. Is there a filtering solution to sorting landing pages in GDS? Currently when I get the stats for top landing pages it brings up all pages in order of most hits. I need to filter so that it brings up only the pages in the menu options. Would be great to resolve this.
Can these reports be utilized in the New Google Sites? If so do you have a video showing the process? I could not find anything on the video listing here on your youtube channel
Hi! They're actually very different. GA is best for monitoring your traffic and gives you a great overview out of the box. Looker Studio (previously Data Studio) requires some initial setup but gives you a fully customizable way to build dashboards of any kind. What's more, on top of GA data, you can connect thousands of apps to Looker Studio, blend data freely and visualize virtually any data at your disposal. We use both apps extensively and they're both absolutely must-haves :)
PLEASE HELP!!! The conditional formatting tab does not show up even prior to switching the dimensions and metrics. Is there anything else I can do. Please respond ASAP
How can i replace data source for the entire report whitoutgoing crazy with replacement in filters, graphs, etc? I need to update the info from my google sheets connector, the structure is the same (header name etc) but every week i have new data in my google sheet and i do not understand the best way to update the data source. thanks for helping me
Thank you for putting together this demo. It was super helpful to me. Date filtering doesn't work like in the video anymore. The UI doesn't have the same dropdown. It's now under 'Add a control'. We can find the same tool/filter/component but when you add it doesn't work exactly the same. Not sure how to get it to filter by range as you did in the video.
Hey Sergey, I have a doubt on metrics which appeared in blue in your video is not same when I tried with the same practise sheet. I'm getting record count, a new field added and rest are in green. please clear the doubt at the earliest
Hi! If your toolbox section isn't highlighted, it might be due to a couple of reasons: - Edit Mode: Make sure you're in Edit mode. You can switch to Edit mode by clicking the "Edit" button at the top right of your screen. - Permissions: Ensure you have the necessary permissions to edit the report. If it's a shared report, you might need edit access. - Browser Issues: Sometimes, a quick refresh or trying a different browser can help resolve display issues.
I love your videos and they are amazing. How to connect SQL server to Google data studio. There is no video like that on RUclips. Please provide a video like this.
If you liked this video, try other great Looker Studio (formerly known as Google Data Studio) tutorials on our channel:
- Looker Studio Tutorial for Beginners 2024 ruclips.net/video/qCl-HHVBRsU/видео.html
- All Types of Looker Studio (Google Data Studio) Charts ruclips.net/video/8Pg0yO6Ijos/видео.html
- How to Connect Google Sheets to Looker Studio? ruclips.net/video/wWmQ2vX_qhM/видео.html
- Multiple Data Sources in Looker Studio ruclips.net/video/-W4sG5v5Z5k/видео.html
- How to Share Looker Studio (Google Data Studio) Reports ruclips.net/video/ZmwYt7tIHRw/видео.html
the way that you simplified the concepts for new beginners shows you are an expert instructor
thank you so much!
Ohh thank god. I'm a small business owner with a slowly overwhelming data problem. The first example is exactly what I need.
It helps that Sergey is very nice on the eye... looks good, sounds good, explains well!
This video is amazing and really helpful. I was at zero stage using GDS but now I can manage it basically thanks to this tutorial.
looks simple but its not simple to do with no one besides you guiding thru step by step, but the power of this tool is immense from this beginner video.
Wow! You just saved me $500 which is what someone was going to charge me to create my dashboard. I got it done as I watched the video. Thank you!
Great job! We're glad it helped 🙌
This is the best beginner tutorial I found. Thanks you very much 🥰
I was looking for a start to learn about Data studio and I landed at the right spot. Thanks for this video!
Thanks for your feedback! We are happy you found the video helpful.
Well done! I used this video as a real-time training tool to work with my data set to create a demo using your instruction. Pause, rewind, create, repeat...success.
ruclips.net/video/-n2Dq8ztKtc/видео.html
An excellent introduction to GDS really appreciated this. Superb.
I was doing self-study about google data studio. Glad to have watched this video first amongst the others on RUclips. Well explained, and easy to understand.
Clapping here, you did great. I followed through to the end. Well done.!
I am one of the many other commenters that is seriously being helped in my challenge to learn datastudio basic. i want to say thank you for your dedicated time for this quality and helpful video, you got a subscriber.
Tony, hi! So happy to be of help! Thanks so much for such a wonderful feedback
this video was awesome. I was struggling with making a dashboard that shows the data real time. You my friend are great.
This was an amazing how to video. Thank you guys for putting so much effort into it
Thanks so much for the feedback! Glad you enjoyed it!
Hell yeah, this is a high quality tutorial
Thank you so much. I had no clue about Data Studio and I needed to learn it. Thanks to you now, I feel that I am more ready than ever to learn more about that tool and create some cool stuff
You're very welcome! Glad it was helpful!
Thank you. This is a great tutorial. I am a Microsoft Power Stack guy but looking to start transitioning over to Google.
Learn again something today. Thanks!
This is great content. Answers exactly the questions that beginners ask. No fluff, no gimmicks. Kudos!
Thank you for the great feedback!
Awesome intro !! impressive work done
Сергей, отлично!
serega spasibo bolshoye, vidos kaif!
Excellent walkthrough, thanks!!
this is very good. i appreciate you creating and posting it.
this is a useful video for a complete beginner
Thank you for the great video!!! I want try all
This is really helpful. I’m in moe trouble when i present data with Google sheets. This will be solved many trouble. Thanks a lot!
You're most welcome, Damith! Happy it was helpful!
Your video is so USEFUL. Thanks a lot 🙏❤️❤️❤️
Glad it was helpful!
Great video! One of the best in explaining how to work with Data Studio. Excellent job!
Happy to hear it was helpful! Thanks so much for your feedback!
Спасибо, Серёга!
This is super helpful. Thanks a lot!
May I suggest a video - I like your teaching style from some others.
1. Relationship with what we learn X / Y ... i.e. X = "Dimensions"
2. When you have a Header of years 4 Quarters - How do I get Dimensions / X, to Have the 4 Qtrs - and the make tY the total Sum value?
I 'm still looking how to do this
Thank you!
Awesome video!! Keep em coming
Thank you, John!
Thank you SO MUCH! It helped me a lot and it made my reports look very profesional!
Glad it helped!
Mjmm jj
N
Jj
Mm
Amazing and comprehensive tutorial! OUTSTANDING !!!
Many thanks! Happy you enjoyed it!
I think you are forget to Add 0:00 Introduction in Timestamp, so we can't see timestamp in your video. Great Tutorial really liked it.
Oh man! Imagine if your recruiter is Sheldon Cooper! nice touch and BBT reference :) Nice tutorial mate, very handy.
Thanks!
Well explained. Thank you!
Hey Sergey, this was a seriously good video man! I enjoyed it a lot, thanks for taking the time to make this and share it! I come from a BI background and I can see the power behind this tool already, sure we need to be able to establish a more robust data background but this was awesome to start with. Thanks a lot
Hello, Juan! Thank you. Great you've liked it.
Outstanding tutorial! Amazing!! Congrats 👏 👏 👏
Happy to be of help! Thank you for the feedback!
Thank you for sharing it.. it is indeed intriguing 😍
Superb tutorial. You really showed the power of data studio. Power BI is more interactive, but GDS gets the job done fast and easy.
very nice video. Thank you so much!
Very simple and lucid explanation. Thanks!
Hi team, thanks for this video
This video gave me all I need to know from GData Studio
A big thanks
Subscribed! I love the potential of this system. Thanks for sharing
Nice and easy tutorial. Liked this. Very helpful for beginners.
Very organic and easy to comprehend tutorial.
Thank You 🙏
This was super helpful, man! You made Data Studios less intimidating for me.
Hey Sergey, Is Merge data Horizontally is available in GDS. I have a workbook with data in multiple sheets with same column name. I want to use this whole data as clubbed data in GDS.
If this option not available directly in GDS, what are the possible solutions.
Please Note : Each Sheet has 25 Columns and Row Counts are between 2 Lac to 5 Lac.
Thanks have a good day.
This video is super simple and awesome. Thanks for the great job.
Glad it was helpful! Thank you for your feedback.
I want to thank you for sharing your knowledge on google data studio. I learned how to build my report and create dashboard through google data studio by following your video tutorials. Thank you so much! My only question is how can I remove the decimal point in values? I want to show only whole numbers.
Awesome tutorial - learnt the basics very easily !! thanks Dude
Glad it helped!
Hi, I am building a dashboard but I am struggling with scoreboard and comparison data from the previous year. When I choose the data it tells me no data. I have data in one spreadsheet everything in one spreadsheet from 2018/2019/2020 How can I do this?
In order to compare data with previous period you should have two columns in a table: date and your metric. You should put date column aka field into "Data Range Dimension" section in "DATA" tab and your metric in "Metrics" section. Note, that data for every year should be in one column for this to work.
thnx alot it was very usefull for me
Sorry to distract from your main message, but that is a _nice_ opening shot! And done by your own guys too, right? If Railsware's standards overall are as high as the video production values in that cold open, then you guys are cool!
Thanks a lot. Indeed, we strive for perfection in everything we do.
Thank you for making this video..
you are welcome :)
Thanks for free tutorial ..
Hello! Wondering if I can get some help here, can't find answers on forums elsewhere....When I use the provided practice sheet, all data are classified as dimensions and not metrics, even though the type is numerical. Any tips on how to solve this? Super beginner here, this video inspired me to learn Data Studio! Thanks so much!
ruclips.net/video/-n2Dq8ztKtc/видео.html
Luar biasa mantap bang
Awesome presentation, thanks a lot .... only one question... what is RPI?
RPI stands for "Railsware pair interview". This is a stage in our recruitment process where you get to work with a Railswarian in pair.
very helpful. thank you
Is it possible to save the report layout and settings to GIT? I would like to have a CI/CD system . Reports created in DEV and approved in UAT, should be moved to PROD via CI/CD.
Good video, thanks for sharing!
Hi thank u so much for ur video its quite helpful ...quick question I’m trying to divide a set of column data for percentage however I find challenging..for instance I would like to know percentage of A from A,B,C which consist in the same column
If I understood your question correctly, you need to create three new columns using Calculated fields with formulas like A / B, A / C, etc.
Thank you for this video. I really benefited from this
Hi! Great video - how did you make the filtered sheet from the imported applicant data? I'm concerned this will mess up the data flow. Otherwise, I am following and almost able to make my dashboard project! Thank you
My applicant ID has been recognised as a 'number' field, but still is green in colour. How to change it to a metric?
Also, there's a blue (metric) named 'Record Count' whose default aggregation is 'Auto'? What's that? That is the only metric being shown.
All fields are green by default. To make a metric out of them just drag and drop them to the "Metric" section in the "DATA" tab and choose a metric type, for example, "Count Distinct" by clicking on the field name. "Record Count" is created automatically and means the number of records in the table by selected Dimensions.
I am really struggling with this from long time ago on how to show ten top values in google data studio and rest as others? in bar chart ...etc. for instance, I have 50 line charts. I only want to show ten top and the other 40 as " others". With a hover on the others find out what are these rest unless you click on it.
As far as we know Data Studio doesn't support such functionality. You need to prepare your data beforehand, for example, in Google Sheets or Python / R.
Great video. Thank u. I have a question though. Is there a filtering solution to sorting landing pages in GDS?
Currently when I get the stats for top landing pages it brings up all pages in order of most hits. I need to filter so that it brings up only the pages in the menu options.
Would be great to resolve this.
Can these reports be utilized in the New Google Sites? If so do you have a video showing the process? I could not find anything on the video listing here on your youtube channel
Great sir
Thank you! 🔥
Awesome video!!
Thanks!
Good to visit this one .
Thanks. Amazing
Thanks for this great video tutorial
Quite amazing. This is my first time seeing this app.
What advantage does this app have over Google Analytics (if any)?
Hi! They're actually very different. GA is best for monitoring your traffic and gives you a great overview out of the box. Looker Studio (previously Data Studio) requires some initial setup but gives you a fully customizable way to build dashboards of any kind. What's more, on top of GA data, you can connect thousands of apps to Looker Studio, blend data freely and visualize virtually any data at your disposal. We use both apps extensively and they're both absolutely must-haves :)
@@coupleracademy thanks for the update. I went looking for it in app store with the old name but couldn't find it.
This was fantastic, thank you so much!
Glad it was helpful! Thanks for your feedback, Peter!
Thanks for the video!
very well done
Hi, I want help with creating a single bar showing the preceding 28 days' data in data studio
. Can you please help me with this?
Great explanation !
thank you!
Дякую, хороший туторіал
Great intro, thank you!
PLEASE HELP!!! The conditional formatting tab does not show up even prior to switching the dimensions and metrics. Is there anything else I can do. Please respond ASAP
Thank you for sharing this video! Really helpful for us!
Glad it was helpful!
thanks for maximal transfer rate of knowledge per minute )
Really helpful video for me. Thank you for your sharing.
Glad it was helpful!
How can i replace data source for the entire report whitoutgoing crazy with replacement in filters, graphs, etc? I need to update the info from my google sheets connector, the structure is the same (header name etc) but every week i have new data in my google sheet and i do not understand the best way to update the data source. thanks for helping me
Awesome Explanation....
nice video, by the way..how to do step for made a notify to other people which data already update..
Thank you for putting together this demo. It was super helpful to me.
Date filtering doesn't work like in the video anymore. The UI doesn't have the same dropdown. It's now under 'Add a control'. We can find the same tool/filter/component but when you add it doesn't work exactly the same. Not sure how to get it to filter by range as you did in the video.
select fixed list
Hey Sergey, I have a doubt on metrics which appeared in blue in your video is not same when I tried with the same practise sheet. I'm getting record count, a new field added and rest are in green. please clear the doubt at the earliest
I just began watching your video for the first time, any idea why my tool box section is not highlighted?
Thanks
Hi! If your toolbox section isn't highlighted, it might be due to a couple of reasons:
- Edit Mode: Make sure you're in Edit mode. You can switch to Edit mode by clicking the "Edit" button at the top right of your screen.
- Permissions: Ensure you have the necessary permissions to edit the report. If it's a shared report, you might need edit access.
- Browser Issues: Sometimes, a quick refresh or trying a different browser can help resolve display issues.
Amazing!!! Thanks a lot :)
thank you @railsware
now i know what i dont know before with simply learn
you have a good heart
I love your videos and they are amazing. How to connect SQL server to Google data studio. There is no video like that on RUclips. Please provide a video like this.
Thank you for the idea! We will consider it.