Ultimate Step by Step Google Looker Studio Dashboard Project | End to End Dashboard Project Tutorial

Подписаться 3,3 тыс.

Просмотров 179 тыс.

50% 1

Data Tutorials:
Google Looker Studio tutorials
---------------------------------------------
In this video you will see how to create dashboard in Google Data Studio from scratch.
To download dataset, visit this link:
drive.google.c...
Google Workspace
Google Data Studio
Google Data Studio is an online tool for converting data into customizable informative reports and dashboards introduced by Google on March 15, 2016 as part of the enterprise Google Analytics 360 suite. In May 2016 Google announced a free version of Data Studio for individuals and small teams.
#DataStudio, #datavisualization , #Chart, #GoogleDataStudio, #Visualisation, #Import, #Dashboard

Опубликовано:

29 сен 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 79

@Stabu 3 месяца назад

So this is basically Google's version of Power BI

@balogunabiola8444 2 месяца назад

This was very insightful. Thank you very much!

@hrb323 5 месяцев назад

Thank you. The content is qualitative. 1)Do you mind me asking how long it took you to think about the design and generally produce this dashboard? 2)Do you think it possible to replicate somthing similar in an email as a weekly report? Many thanks

@PhantomCat-lj9fy 7 месяцев назад

You deserve more subscribers and more views. Man, I've been watching Looker Studio tutorials but still, I couldn't quite get it, until I watched your video. Pretty simple, straight to the point, and short, but someone who does not have a background in data analytics can learn a lot. You're not just good at it, you're also a good teacher.

@xamascovideos 6 месяцев назад

Thank you so much for your kind words! I'm glad to hear that. Your feedback motivates me to continue creating educational content. If you have any specific questions or topics you'd like me to cover in future videos, feel free to let me know. Thanks again for your support!

@nikhilsaini594 2 месяца назад

really helpful!!!

@maryjaneenendu7072 6 месяцев назад

Where can I get get icons for the dashboard😭😭

@Bloom779 3 месяца назад

Scratch that. You can download icons of any color of your choice from flaticon

@oseikwamejones9019 Год назад

Thank you for this. I enjoyed it.

@HelloIamLauraa 4 месяца назад

i dont know but the Order -Trend (Month) doesn't make much sence to me. unless we make it just for one year

@shubhampandey1462 Год назад

Hey, what is the canvas size for this dashboard ?

@ekayuliwinari751 8 месяцев назад

Thank you!

@topdamagewizard 5 месяцев назад

Man I don't know how anyone passed college without AI and Google. My professior can't explain shite better than youtube can.

@virendratrivedi3975 5 месяцев назад

nice. do you have lookml tutorial ?

@xamascovideos 5 месяцев назад

We are working on Looker and LookML tutorials. The course should start in a few weeks.

@Kavita-u5w Год назад

Hi Sir,i want to make a report for a online store. Here i want to show month wise sells for Individual customer purchased the product. So need to make a report Customer wise product purchased and total sells happened for the individual product in looker studio.Any guidance on this.Which Chart also i can use to show total sells happened by product category wise by individual customer purchased. Please guide me. I need help urgently on looker studio

@findthetruth3021 6 месяцев назад

Why don't you share the template with us? 😃

@xamascovideos 5 месяцев назад

I can share only in view mode, so you will be able only to see it. If I share it in edit mode, anyone can edit and change the dashboard, so it wouldn't make sense.

@KiranChauhan-t7g 20 дней назад

Can anyone please share a link to get the KPI icons?

@EvangelineB6 7 месяцев назад

I really appreciate how in depth and how quick your tutorial is, this saved me at work.

@Hoopoebranding 20 дней назад

That was great

@opshahmeer4764 2 месяца назад

waste of time ,isn,t good

@saeelsalvi1739 6 месяцев назад

00:02 Creating a dynamic and visually appealing dashboard using Google Looker Studio. 01:54 Establishing a data source in Google Looker Studio for dashboard creation. 03:58 Creating visually appealing dashboard elements 07:32 Adding filters and lines for visual organization on the dashboard 10:13 Creating KPIs and KPI Cards for the Dashboard 13:05 Creating multiple charts with different data for visualizations. 15:13 Configuring chart settings for order quantity visualization 17:34 Customizing table settings and formatting

@xamascovideos 6 месяцев назад

Thank you!

@hit4success Год назад

He who can give can give a lot with a moment - you are a shining example of that. In twenty minutes you have given a lot and the rest is up to the capacity of those who receive it. thank you. I am grateful for your tutorial.

@zionovic2128 2 месяца назад

Great tutorial! I have a lot, and I am ready to get started with looker studio. How did you sort the month (Jan - Dec) in the Order-Trend(month) chart?

@dwingirl6064 4 месяца назад

can you make a tutorial on making a dashboard about visualizing environmental pollution data using Google Looker Studio?

@funvideoscorner 8 месяцев назад

@Xamascos my line chart is showing only one month , and the yearly is showing only one year. how to solve this

@Omri_Ram 5 месяцев назад

Thank you for this full tutorial, it is very useful as a new user of looker

@abisheikk2438 4 месяца назад

in all the charts, the text color of axis and legends are in black which cant able to see in black background how to change the text color to white

@chidinmaokwuchi729 Месяц назад

Thank you for this detailed information, you just gained a subscriber 👍

@syedmujtabaalinizami8830 6 месяцев назад

Data is used in this dashboard is available publicaly?

@xamascovideos 6 месяцев назад

Yes, you can find it in the description of this video.

@diogodieter 4 месяца назад

congratulation!!!! I really apreciate

@funnybhadrakia1 Год назад

i want to create a comparison report of conversion rate between new users and returning users. Is this possible? I mean how many users converted from new users count and how many converted from returning user count. Please help

@kenji2342 Месяц назад

great and helpful video. tysm!

@karinekobarg9668 Год назад

Great project... tks for sharing

@iescodec6435 5 месяцев назад

Muito bom!! Parabéns !!

@zefanyatesalonikatamon6151 6 месяцев назад

Hey! Thanks for the tutorial. I love your design ❤

@xamascovideos 6 месяцев назад

You are welcome! Glad to hear that!

@AnzarBanday 2 месяца назад

mind sharing the template?

@xamascovideos 2 месяца назад

We can provide only read access. Is that okay for you?

@AnzarBanday 2 месяца назад

@@xamascovideos i wanted to create a similar for my personal projects but for that i might need a copy of it, if that's possible....

@HelloIamLauraa 4 месяца назад

how to separate tje months for each year?

@wennychandrasari762 Год назад

Why did you use count and not count distinct for your order ID?

@xamascovideos Год назад

In this case, we used the count function because all the order IDs are unique. When we use count in this context, it is equivalent to counting distinct values. If there were duplicates in the order ID column, we would specifically use the count distinct function.

@brahmabull4004 Год назад

Bro where do i get all the icons??

@xamascovideos Год назад

Here is the link, you can download them, and import as an image: www.iconsdb.com/

@NativeoilSociety 2 месяца назад

Just Fantastic Intro

@cescodeidda277 10 месяцев назад

Wrong data source, UTF-8 issues when trying to omport the source file

@xamascovideos 10 месяцев назад

Thank you for feedback! Data source should be find, but when you download it, you need to save it as CSV (UTF 8), not regular CSV, and not Excel. Then, you will be able to import that CSV file directly into Looker Studio. Also, second option is to import file first into Google Sheets, and then connect Google Sheets to Google Lookers Studio.

@TREVEAN 2 месяца назад

Great

@boooi12 8 месяцев назад

you should use blocks in between all the visuals, to have the same space between al square blocks

@xamascovideos 8 месяцев назад

Thank you for your feedback!

@GabrielFerreira-ip4wh 5 месяцев назад

Thanks for sharing!

@xamascovideos 5 месяцев назад

You are welcome!

@ZulkarnainMAmin-or2kd 11 месяцев назад

Thank you for sharing

@malaik9 10 месяцев назад

Thank you

@Saifullahkhan-j7c 6 месяцев назад

wow Amazing Project Thank u soo much 💌

@xamascovideos 6 месяцев назад

Most welcome 😊

@kagouhuppe745 Год назад

Hello, thank you for sharing your knowledge. However, at 17:00mins you had the months not in chronological order and the next second you fixed it. I have the same issue and I would like to know how you fixed this please. :)

@xamascovideos Год назад

Hello, thank you for watching my videos! To solve that, when you create your chart and select the proper data, you will need to click on your chart. After that, in the top right corner, you will see 3 dots. Click on those dots and a menu will appear. From the menu, select the "Sort" option. Instead of the metric that you provided, click on the date dimension (e.g., order date). You can click once to sort by months in descending order, and if you click one more time, it will sort in ascending order. I hope this explanation helps! Best of luck!

@kagouhuppe745 Год назад

@@xamascovideos Thank you very much. Keep the great work !

@AhmedAbdEl-Raouf 9 месяцев назад

Thanks for the great work! It's really comprehensive and to the point at the same time! I'd like to bring to your attention that in all of the three pie charts, i.e. orders by region: the legend is missing, we can't identify which regions those percentages belong to.

@xamascovideos 9 месяцев назад

Thank you for your feedback! Much appreciated! It will be improved in future vides.

@AhmedAbdEl-Raouf 9 месяцев назад

@@xamascovideos Thanks for getting back to me. Best of luck with all of your future content! KEEP GOING!

@ffgaming-fe3cx 5 месяцев назад

Thanks a lot man

@xamascovideos 5 месяцев назад

You are welcome!

@GuntherLynn Год назад

Thank you

@kamrulislam3238 11 месяцев назад

Can this dashboard be used in Google Sheets?

@xamascovideos 11 месяцев назад

Thank you for your question. Unfortunately it is not possible to use this dashboard in Google Sheets. However, it is possible to create similar dashboard in Google Sheets.

@kamrulislam3238 11 месяцев назад

@@xamascovideos Google sheet App script.