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 ua-cam.com/video/qCl-HHVBRsU/v-deo.html - All Types of Looker Studio (Google Data Studio) Charts ua-cam.com/video/8Pg0yO6Ijos/v-deo.html - How to Connect Google Sheets to Looker Studio? ua-cam.com/video/wWmQ2vX_qhM/v-deo.html - Multiple Data Sources in Looker Studio ua-cam.com/video/-W4sG5v5Z5k/v-deo.html - How to Share Looker Studio (Google Data Studio) Reports ua-cam.com/video/ZmwYt7tIHRw/v-deo.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.
I was doing self-study about google data studio. Glad to have watched this video first amongst the others on UA-cam. Well explained, and easy to understand.
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 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.
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.
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!
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
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! 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
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!
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.
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, 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.
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
Anindya, good point! while we've recorded the video, the date range dimension was not selected for the positions table. This is why the data filter was not applied.
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!
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.
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! 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 :)
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
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.
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 ua-cam.com/video/qCl-HHVBRsU/v-deo.html
- All Types of Looker Studio (Google Data Studio) Charts ua-cam.com/video/8Pg0yO6Ijos/v-deo.html
- How to Connect Google Sheets to Looker Studio? ua-cam.com/video/wWmQ2vX_qhM/v-deo.html
- Multiple Data Sources in Looker Studio ua-cam.com/video/-W4sG5v5Z5k/v-deo.html
- How to Share Looker Studio (Google Data Studio) Reports ua-cam.com/video/ZmwYt7tIHRw/v-deo.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!
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.
An excellent introduction to GDS really appreciated this. Superb.
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 video is amazing and really helpful. I was at zero stage using GDS but now I can manage it basically thanks to this tutorial.
Clapping here, you did great. I followed through to the end. Well done.!
Сергей, отлично!
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.
serega spasibo bolshoye, vidos kaif!
I was doing self-study about google data studio. Glad to have watched this video first amongst the others on UA-cam. Well explained, and easy to understand.
Hell yeah, this is a high quality tutorial
Learn again something today. Thanks!
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.
ua-cam.com/video/-n2Dq8ztKtc/v-deo.html
Спасибо, Серёга!
this is a useful video for a complete beginner
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.
Awesome intro !! impressive work 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
Excellent walkthrough, thanks!!
Thank you for the great video!!! I want try all
Thank you. This is a great tutorial. I am a Microsoft Power Stack guy but looking to start transitioning over to Google.
this video was awesome. I was struggling with making a dashboard that shows the data real time. You my friend are great.
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 is very good. i appreciate you creating and posting it.
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!
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!
Well explained. Thank you!
very nice video. Thank you so much!
This is super helpful. Thanks a lot!
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!
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.
Your video is so USEFUL. Thanks a lot 🙏❤️❤️❤️
Glad it was helpful!
Thanks for free tutorial ..
Thank you for making this video..
you are welcome :)
Thank you! 🔥
Awesome video!! Keep em coming
Thank you, John!
very helpful. thank you
Thank you for sharing it.. it is indeed intriguing 😍
Oh man! Imagine if your recruiter is Sheldon Cooper! nice touch and BBT reference :) Nice tutorial mate, very handy.
Thanks!
thnx alot it was very usefull for me
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!
Luar biasa mantap bang
Good to visit this one .
6:00 wish you said that earlier, I actually had to recreate it but still thanks
Hi team, thanks for this video
This video gave me all I need to know from GData Studio
A big thanks
Thanks. Amazing
Very simple and lucid explanation. Thanks!
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.
Nice and easy tutorial. Liked this. Very helpful for beginners.
Great sir
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
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.
Subscribed! I love the potential of this system. Thanks for sharing
Thanks for the video!
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.
This is great content. Answers exactly the questions that beginners ask. No fluff, no gimmicks. Kudos!
Thank you for the great feedback!
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
Good video, thanks for sharing!
Amazing and comprehensive tutorial! OUTSTANDING !!!
Many thanks! Happy you enjoyed it!
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!
thanks for maximal transfer rate of knowledge per minute )
This was super helpful, man! You made Data Studios less intimidating for me.
Thank you for this video. I really benefited from this
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.
very well done
Very organic and easy to comprehend tutorial.
Thank You 🙏
Superb tutorial. You really showed the power of data studio. Power BI is more interactive, but GDS gets the job done fast and easy.
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
Thanks for this great video tutorial
Outstanding tutorial! Amazing!! Congrats 👏 👏 👏
Happy to be of help! Thank you for the feedback!
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.
This video is super simple and awesome. Thanks for the great job.
Glad it was helpful! Thank you for your feedback.
Thank you sir
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.
Awesome Explanation....
@railsware Hey at 18:43 , how come there are so many values in the left table when only one applicant is there on the right?
Anindya, good point! while we've recorded the video, the date range dimension was not selected for the positions table. This is why the data filter was not applied.
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!
ua-cam.com/video/-n2Dq8ztKtc/v-deo.html
Amazing!!! Thanks a lot :)
Awesome tutorial - learnt the basics very easily !! thanks Dude
Glad it helped!
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.
Awesome video!!
Thanks!
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
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.
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.
Which program do you use to create the animations in 2:22?
thanks
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 intro, thank you!
This was fantastic, thank you so much!
Glad it was helpful! Thanks for your feedback, Peter!
thank you @railsware
now i know what i dont know before with simply learn
you have a good heart
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?
Good to know that ! Love it
thanks for the tutorial. it helped me a lot.
Great explanation !
thank you!
Really helpful video for me. Thank you for your sharing.
Glad it was helpful!
Very helpfull!