How to Create a Dashboard | Google Data Studio| Dashboard Hacks That Everyone Should Know
Vložit
- čas přidán 13. 07. 2024
- This is a Google Data Studio Dashboard tutorial for beginners.
We describe the most important Data Studio functions for you to build great Google dashboards. Data Studio provides you with an opportunity to pull data from various sources (such as Google Sheets, Google Analytics, Google Ads, BigQuery, MySQL, CZcams Analytics and many others). You can then easily build tables, charts, and apply various filters to modify your reports. We review the whole flow from the basic account setup to building various Data Studio charts and dashboards.
What is Google Data Studio ?
Data Studio is a free tool that turns your data into informative, easy to read, easy to share, and fully customizable dashboards and reports. Use the drag and drop report editor to:
• Tell your data story with charts, including line, bar, and pie charts, geo maps, area and bubble graphs, paginated data tables, pivot tables, and more.
• Make your reports interactive with viewer filters and date range controls. The data control turns any report into a flexible template report that anyone can use to see their own data.
• Include links and clickable images to create product catalogs, video libraries, and other hyperlinked content.
• Annotate and brand your reports with text and images.
• Apply styles and color themes that make your data stories works of data visualization art.
Share and collaborate
It's easy to share your insights with individuals, teams, or the world. Invite others to view or edit your reports, or send them links in scheduled emails. To tell your data stories as broadly as possible, you can embed your reports in other pages, such as Google Sites, blog posts, marketing articles, and annual reports.
When you share a Data Studio file with another editor, you can work it together in real time as a team.
Use these timestamps to move right to a specific topic:
0:00 - Intro
0:10 - Dashboard Introduction
0:25 - Bonuses For All Viewers
0:49 - Step-1 Source Data in excel
1:24 - Step-2 Load Data in Google Sheet
3:09 - Step-3 Connect The Data in Google Data Studio
5:47 - Step 4 Create Report
6:30 - Name Design Of Your Dashboard
7:25 - Table with bars
11:01 - Pie Chart
13:08 - Donut Chart
14:45 - Bar Chart
16:14 - Bubble Map (Google Map)
18:36 - Gauge
20:56 - Treemap Chart
22:01 - Scorecards
24:05 - Pivot Table
24:36 - Drop down list
25:40 - Slider
26:24 - Other Features
27:00 - Style & Background Colour
28:30 - Theme & Layout
29:30 - Final Dashboard
33:30 - Sharing Dashboard
35:17 - How To Download Bonuses
36:35 - Outro
Google Sheet : www.google.com/sheets/about/
Google Data Studio : datastudio.google.com/u/0/
Google Data Studio Dashboard By Vaibhav Vaidya :- datastudio.google.com/s/syvGG...
Get your personal copy of the HR Dashboard practice sheet: :- drive.google.com/file/d/1DHPm...
Bonuses(14000 PPT+10,000 Icon Set+ 150 Complete PPT) :- drive.google.com/drive/folder...
Hope You Like My Video And Share It. You Can Also Connect With Me From Other Social Sites...
Facebook ID:-- / vvaidya17
Twitter ID:- / vvaidya002
Instagram ID:- / vvaidya17
LinkedIn ID:- / vvaidya002
#Dashboard #GoogleDataStudio #BubbleMap
Good, to the point presentation !! The bonus is just lovely !!
Thank you so much for the very comprehensive topic. This is what I've been looking for...... More power to you, Sir....and GOD Bless!..
Very Simple and easy to understand !! Thanks for the video :)
Absolutely Amazing 👌 Love the way of your polite explanation ❤
No skip adds for you sir! 💛
Dear me! I want to give you a hug. Thank you for sharing your resources, making them freely available. The PPT templates are just stunning!!!!! Very professional. Thanks for sharing your work and your knowledge!
Reading such comments gives me motivation to create good content. You can follow me on Instagram @vvaidya17
@@BeingHR where can i get templates
where is the link
Absolutely woundeful...very clearly explained which is very useful for beginners....
Dear Dada, Thanks for your detail tutorial. Now its clear like water.
A very good explanation. Thank you! 🙂
Amazing video bro...So easy to learn dashboard
Wonderful Presentation. Very Informative. Keep up the great work and be helpful to our community.
This is so amazing thank you so much for sharing. God Bless you.
Marvelous Presentation Detail Explanation is very Nice..👏,
I must appreciate your efforts Brother, keep it up 🙏🙏🙏
Great presentation👌.Thanks a lot
The video is of immense value, I keep revising this video in enhancing the skills to create HR Dashboard on the Google Studio! Quick Q - Is it possible to edit the data by uploading the new data to the existing base data file ?
Nice Presentation and tutorial
This is something amazing I learnt today.... Thanks bro
Your welcome Pankaj ❤️
Thanks a lot man! You tought in the easiest way
Thankyou
Just superb video
seriously awesome
Really don't have words in order to say thanks...this vedio helped me out to complete my project..even I listened 1st tym Google studio and I accepted the project and now project has been done coz of this vedio.....one again sorry...thanks a lot
thanks for sharing this insightful tutorial, helping, and being generous instructor in the youtube channel. u r awesome sir. u r so professional. I wish u an infinity good luck in this life and afterlife. have a joyful weekend :)
Thanks for the wonderful comment.You can follow me on Instagram @vvaidya17
Thanks .U R amazing in explaining and in a simpler way
Your welcome
Thanks for your explanation
Many thanks
Great, thanks Sir
Really Exquisite....
Very very good video thank you sir🙏🙏🙏🙏
Good Information & effective way for making understand ..( All PPT only view mode not able to download kindly give access )
Awesome 👌
Also while doing CRM try to cover how employee google sheets data are given rights to some data on which they are doing sales cold calling. Also how they get automatic message for task in hand. Lastly me as a owner get thr report in the morning everyday how employees are working. Thanks
First lecture, learnt alot.
Thankyou
Very informative and helpful.
Thanks
Thank you very much for such detailed information. This will help me complete my project on speedy way. And can you please provide the access for the ppt templates
Superb.
thank you sir
Excellent, thanks for sharing
Your welcome
Sir your explanation is awesome thank you for this.
Thankyou
Hello All,
100 free coupons of this course on udemy (Valid till 13/06/2023)
Link: www.udemy.com/course/interactivedashboards/?couponCode=FREEDASHBOARDCOURSE
Code: FREEDASHBOARDCOURSE
Thanks for Sharing Valuable information
Thanks
It's really stupendous
Thankyou
amazing i learned it easily
thankyou
Nice Job Thank you
Thank a lot sir
Sir please upload more videos like this
Excellent
Good
Thanks
Super👌
Thankyou
Nice presentation
Thank you ❤️
In my website I have date, month and sales. So if say I want to know sales of 5th Feb 2021, then how to do that? What will be metric and dimension here? Because both date and sale are numbers
An August Class , Respected Sir ,
lovely sir
Your welcome
great
Thankyou sir
Thanks
Welcome
Liked
Excellent video .. kindly share the google sheet it’s not available in the link shared by you
Nice Learning video
Thankyou
Hello sir. Thank for sharing your resources. How can I edit the ppt? it's view only? thanks again
Hi thanks for the wonderful session. How can this dashboard be downloaded and save it like normal XL file? And automatically change happens when I add more rows the feed file
You can’t do that.You can download the source data but not the dashboard.
Hi, you are doing great work. Can you prepare a CRM dashboard and CRM for let's say cold calling data and leads through Facebook. You can take example of 10 employees. Thanks
Need to check that
Bro please provide us more dashboard videos useful for office work
Sure and thanks 😊
Thank you very much for the Clear explanation. Will you send me the bonus PPT? thank you. I'm very impressed
Can I get the data that you used to create this dashboard as a practise
Loved your video,can u share anything on Attrition
Sure can u tell me exactly what do you want on attrition
@@BeingHR Vol & involuntary .. Locationwise , Department wise, Designation wise ,Tenure wise.. also anything on appraisals & salary revision if u have
When do I get to video on appraisals and salary revision with attrition
You will get it soon... Its a interesting topic too..
How do I increase my row per page limit from 5k since my data consist lakhs of row ?
tech can do wonders
what the difference between report, data source and explore function?
Thank you so much for this! Can you share tips on how to exclude terminated employees? Let's say I have one more column in the sheet file for Status > Active or Terminated. Example: I want to have a pie chart with the gender only of the active employees? Thanks
Thankyou
Should be possible by adding a filter dimension
Thanks. Can I have data sheet for practice.
Yes you can check description
How to add parameter and values in the Google sheets and without deleting it how to reflect those in the report
Kindly share date for this looker studio so i can use and practice on it
Hi sir, useful video. I can't able to see or scroll down to get apply filter options for geo charts. Pl help
Do the following things:-
1-Open it from a different browser
2- see whether you have locked scrol or not
3- try to open it from a different device
I hope it works
@@BeingHR thanks. I actually used a mouse to scroll. It worked!
Hi how can upload large files in google studio
Excellent dashboard! Really impressive. If my data sheet changes every week, is there a way I can create the dashboard automatically with the new week data?
Yes you can
Kindly share the video how to design Audio Video Based Learning Material
Sure
Still can avail the offer given jn start???
bro can we create a real time dashboard ?? the data should be updated every 10 seconds or so
Hi it is nice learning video. But I am unable to download the bonus
Try now with this link : drive.google.com/drive/folders/1htK9SOeXMIC_pbBDEgOXEhCUpW6LaSNB
If some employees leave the company then how to find out working employees ?? according to that how to update all other data?
If you keep all your data on Google sheet then simple remove the name of employee and refresh
@@BeingHRIs there any other options?? Like if you have 1000+ employees it impossible to do that.
@@ranupatra6858 no it is possible because you need simply maintain all your data on google sheet and if you don't want to do that then maintain it in excel and then directly upload that.
where is the dataset ?
please share sales dashboard tutorial sir with format like this please
Will share it soon
Thank you so much sir would be grateful
Data loaded on excel but not showing data on google sheet on google data studio
What should I do??
Try to directly paste it or extract it from excel.
Hi buddy how to use resume template
Can you please elaborate further about what exactly you are expecting?
Why am i not able to see the interaction in filters
Save the work and change the browser it may work
How to keep commas’ at lakhs and crores in dash boards
Kindly share data
Plz hind
Hind me
You are so generous