Data Studio & Google Sheets Reports Tutorial - DataTable, GeoMap, Filters, Scorecard - Part 1

Pivot Table Video tutorial

Video tutorial about using Google Data Studio with Google Sheets. You will learn how to analyze data and create reports using Google Sheets data in Data Studio.

Google Sheets

Website:

[diegomouratorres]

Congratulations! Thank you so much for sharing these high-quality contents on data analysis using Google Sheets and Google Data Studio. It's been helping a lot with my analyses at work. Please, keep bringing these contents and insightful takes on data analysis. 📊

[karennguyen]

Thank you so much. It's an amazing and helpful.

[md.arifuzzaman]

Hey... it's a great tutorial for starting data studio! Hope the next parts will cover the remaining interesting parts.

[farhanahmed]

Is there a function in Google Sheets similar to the one in MS Excel that changes the Report Layout of a Pivot Table to a Compact view?

[yunitherarajendran]

Very easy to understand. Thanks to you..

[ahmadsammour]

🔥🔥 Important !!
can I extract Value by comma from google data studio to display each value separately in metrics ??

[triptofood]

Hi, wonderful video on Data Studio. I have to extensively work on Google Analytics and Google Sheets for third party data reporting. Can you create a video on Google Sheets Analytics Add-on to import data directly into Sheets from Analytics API or some other cool video on using Google Analytics and Google Sheets together.

[gauravgupta]

Is it possible to create a dashboard of data for a single row of information or that can drill down to a single row. I am trying to visualize a single patients symptoms graphically using bubble graphs

[sofusaxelsen]

Hey there! Great video, is there any way I can have the spreadsheet file so I can practice myself, thanks beforehand:)

[FANISITE]

I have two year sales data of different cities in Column A and B now, i want growth in my third column but i can't figure out how to do it in Google Data Studio ????

[genegraves]

Using your example can you get a median from your sales metric? The aggregation types include avg, max, sum etc but not median. I tried to create a calculated field using a formula, median(sales) but always get this error message, "Re-aggregating metrics are not supported". I always use google sheets as my data source and properly format the numeric data. What's Up??

[soromiso]

Instead of using map, I would like to the organization chart I made(it lookes a hierachy )

[daniloalba]

is it possible to extract data from lines like in excel?

[vv]

How to import data/table from tabs of a web site, when importhtml function is able to import only first tab's data.. Through "table".. Other tab's data are not importing through this function..

[sohaibroomi]

Can we do all this mapping by using Google app script. If yes, then kindly share with us..Thank you.

[ArsenIslamovandhiscattle]

I have KML file with polygons. It is my crop field. Could I put that map into google data studio?

[VictorDiGiovanni]

Great tutorials. One Data Studio question: In my spreadsheet I have a LOGO column which has the logo for each company. These logos come from external image urls or from my Google Drive. Works fine in Sheets. So far, this doesn't work when these are imported into Data Studio. I've tried to create a calculated field using the IMAGE function in Data Studio, but nothing I've done allows me to have the urls from the spreadsheet automatically populate the IMAGE parameters. I've formatted the urls as both text and as urls, with and without quotes, but nothing works. If I paste the url directly into the IMAGE parameter, it works, but puts that image into EVERY logo cell in the table. Any suggestion?

[donpuerto]

Nice, when you edit the excel or changing the value, will it change to google data studio in real time?

[singhalmonica]

Sir, do u have any course to tech the excel/ Google sheets

[donpuerto]

how to download Pivot Table Excel sheet