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 TH-cam. Well explained, and easy to understand.
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!
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
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.
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
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.
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.
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
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.
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
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!
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.
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.
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!
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
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
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
Вопрос: Если у меня есть 2 столбца, я могу вывести свод по каждому в отдельную ячейку (итог), могу узнать построчно узнать результат деления одного столбца на другой. Но как мне вывести результат деления суммы по первому столбцу от деления на сумму по второму?
Привет, подскажи как выдать такой показатель как среднее кол-во? каждая строчка - это действие в день у меня может быть от 0 до 5 действий, мне надо посчитать средне кол-во действий в месяце, если на калькуляторе, то берем кол-во строк без заголовков( это показатель можем посчитать) и делим его на количество даней в месяце?
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.
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.
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
When I am plotting 2 metrics, both left and right y-axis are coming whereas when I am increasing to 3 or 4, the right y-axis is gone. Can someone help in understanding how to keep range of 2 metrics in left y-axis and 2 metrics in right y-axis
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 :)
I love your videos and they are amazing. How to connect SQL server to Google data studio. There is no video like that on TH-cam. Please provide a video like this.
![FULL Google Data Studio Course (2023) ➡️ rebranded to Looker Studio) [Compilation]](http://i.ytimg.com/vi/dsAVSsdYC10/mqdefault.jpg)
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.
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.
Ohh thank god. I'm a small business owner with a slowly overwhelming data problem. The first example is exactly what I need.
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.
This is the best beginner tutorial I found. Thanks you very much 🥰
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!
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 🙌
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.
th-cam.com/video/-n2Dq8ztKtc/w-d-xo.html
I was doing self-study about google data studio. Glad to have watched this video first amongst the others on TH-cam. Well explained, and easy to understand.
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!
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.
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
An excellent introduction to GDS really appreciated this. Superb.
this video was awesome. I was struggling with making a dashboard that shows the data real time. You my friend are great.
Thank you. This is a great tutorial. I am a Microsoft Power Stack guy but looking to start transitioning over to Google.
It helps that Sergey is very nice on the eye... looks good, sounds good, explains well!
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
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!
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!
This is great content. Answers exactly the questions that beginners ask. No fluff, no gimmicks. Kudos!
Thank you for the great feedback!
Superb tutorial. You really showed the power of data studio. Power BI is more interactive, but GDS gets the job done fast and easy.
Clapping here, you did great. I followed through to the end. Well done.!
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.
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.
Oh man! Imagine if your recruiter is Sheldon Cooper! nice touch and BBT reference :) Nice tutorial mate, very handy.
Thanks!
Learn again something today. Thanks!
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.
Subscribed! I love the potential of this system. Thanks for sharing
Your video is so USEFUL. Thanks a lot 🙏❤️❤️❤️
Glad it was helpful!
this is a useful video for a complete beginner
Thank you for making this video..
you are welcome :)
serega spasibo bolshoye, vidos kaif!
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.
Nice and easy tutorial. Liked this. Very helpful for beginners.
Thank you for the great video!!! I want try all
Very organic and easy to comprehend tutorial.
Thank You 🙏
This was super helpful, man! You made Data Studios less intimidating for me.
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!
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.
Amazing and comprehensive tutorial! OUTSTANDING !!!
Many thanks! Happy you enjoyed it!
Спасибо, Серёга!
Hi team, thanks for this video
This video gave me all I need to know from GData Studio
A big thanks
this is very good. i appreciate you creating and posting it.
Very simple and lucid explanation. Thanks!
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.
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.
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
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 this video. I really benefited from this
very nice video. Thank you so much!
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.
Excellent walkthrough, thanks!!
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.
Hell yeah, this is a high quality tutorial
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?
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!
th-cam.com/video/-n2Dq8ztKtc/w-d-xo.html
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
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 @railsware
now i know what i dont know before with simply learn
you have a good heart
This video is super simple and awesome. Thanks for the great job.
Glad it was helpful! Thank you for your feedback.
6:00 wish you said that earlier, I actually had to recreate it but still thanks
thanks for maximal transfer rate of knowledge per minute )
thnx alot it was very usefull for me
Awesome tutorial - learnt the basics very easily !! thanks Dude
Glad it helped!
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.
This is super helpful. Thanks a lot!
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
Thank you for sharing it.. it is indeed intriguing 😍
today is 2021, feb 16th. It's not possible to select this quarter to date on data range control
Awesome intro !! impressive work done
Well explained. Thank you!
Вопрос: Если у меня есть 2 столбца, я могу вывести свод по каждому в отдельную ячейку (итог), могу узнать построчно узнать результат деления одного столбца на другой. Но как мне вывести результат деления суммы по первому столбцу от деления на сумму по второму?
very helpful. thank you
I'm trying to apply date filter to selected chart. please help me
Applied: I have selected (Grouping the charts) still it is not working
Thanks for free tutorial ..
Привет, подскажи как выдать такой показатель как среднее кол-во? каждая строчка - это действие в день у меня может быть от 0 до 5 действий, мне надо посчитать средне кол-во действий в месяце, если на калькуляторе, то берем кол-во строк без заголовков( это показатель можем посчитать) и делим его на количество даней в месяце?
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
@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.
I am getting advance filter and preset filter not filter control option
Outstanding tutorial! Amazing!! Congrats 👏 👏 👏
Happy to be of help! Thank you for the feedback!
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
When I am plotting 2 metrics, both left and right y-axis are coming whereas when I am increasing to 3 or 4, the right y-axis is gone. Can someone help in understanding how to keep range of 2 metrics in left y-axis and 2 metrics in right y-axis
i dont see the "pipedrive data stream demo" , can you get me a link?
Please make a video for me on how I can embed only one of my entire Google Data Studio pages into my Google site 🙏 Very Important For me
Sir have downloaded, practice sheet provided by u. Sir I m getting filter control, I have adv. Filter but filter is not. Pls help me
Awesome video!! Keep em coming
Thank you, John!
Thank you for sharing this video! Really helpful for us!
Glad it was helpful!
Дякую, хороший туторіал
Luar biasa mantap bang
Really helpful video for me. Thank you for your sharing.
Glad it was helpful!
Thanks. Amazing
Thank you! 🔥
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.
I love your videos and they are amazing. How to connect SQL server to Google data studio. There is no video like that on TH-cam. Please provide a video like this.
Thank you for the idea! We will consider it.
Good to visit this one .
Which program do you use to create the animations in 2:22?
This was fantastic, thank you so much!
Glad it was helpful! Thanks for your feedback, Peter!
thanks for the tutorial. it helped me a lot.
Сергей, отлично!
Good video, thanks for sharing!