Google Sheets with Tableau

-

Got your data in Google Sheets? You can connect directly to your data in Tableau using it's web data connector. This feature has been around for a while now. If you are new to it, this could be a plus for you.

Select the option under “More Servers…” on the Connect menu. After entering your Google Sheets credentials, you will see the list of available sheets. You can Select from the list or use the search bar to be specific, and click “connect.”

What's cool about it is that If you aren’t sure if this is exactly the sheet you are looking for, you can easily open it in a web browser by selecting the “open in Google Drive”. Once the sheet has been loaded into Tableau, you can drag out the individual sheets from your Google Sheet and join or union them together.

Additionally, you can also union and join Google Sheets with other data sources.Sounds cool right?.

In Tableau, you can see all the sheets you have access to as well as who owns the sheets you’re using. It’s easy to share Google Sheets with your team. Use the built-in sharing feature in Google Sheets to share a link to your data source. Your team can then dive in to contribute to the data.

Here is something simple i did with my Blog, Google Sheets and Tableau:

If you have any additional information based on your experience, feel free to share.

If you still have questions or just want to chat about Tech stuff, contact me and i will be glad to help!.

Comments

  1. WafaiCloudApril 27, 2022 at 9:48 PM

    Very informative post, I have read your all Blogs. Your all blog contains good and unique information and these are very helpful Managed Database Solutions in Saudi Arabia..Thank you for sharing this post here.

    ReplyDelete

Post a Comment

Popular posts from this blog

AWS: Benefits of using Amazon S3

-
Image
Let us start with a quick introduction. Amazon simple storage service or Amazon S3 provides developers / IT teams / Organizations / Individuals with secure, available, price friendly object storage in the cloud. Ok. Slow down. What is object storage? It is a computer data storage architecture that manages data as objects, as opposed to other storage architectures like file systems, which manage data as a file hierarchy, and block storage, which manages data as blocks within sectors and tracks. Amazon S3 is easy to use and can be used to store and retrieve any amount of data at any time. All data transfers are over automatic encryption and SSL. Data is secure, available when needed and will scale as your needs grow. Last thing you want to worry about is losing valuable data. Amazon S3 automatically replicates your objects on multiple devices across multiple facilities. In Amazon S3, you create bucke
Read more

Google To Acquire Looker For $2.6 Billion

-
Image
The deal is expected to close later this year, at which point Looker will become part of Google Cloud , helping serve Google customers a more comprehensive analytics solution. Data remains an untapped resource for many organizations and businesses. I believe the addition of Looker to Google Cloud will provide customers with a more comprehensive analytics solution,from ingesting and integrating data to gain insights, to embedded analytics and visualizations enabling enterprises to leverage the power of analytics, machine learning and AI. Whether that’s supply chain analytics in retailing; media analytics in entertainment; or healthcare analytics at global scale. The market for business intelligence software is large. Indeed in August 2018, IDC said that "Worldwide revenue for big data and business analytics (BDA) solutions was $166 billion, up 11.7% over 2017 and would reach $260 billion
Read more

Python - GUI - Tkinter(Bar & Pie Chart)

-
Image
Quickly, i just want to show you a simple example of creating bar and pie chart with Tkinter . Try this simple example: import tkinter as tk root = tk.Tk() root.title("Tkinter Bar and Pie Graph") #here is for bar chart............ tk.Label(root, text='Bar Chart').pack() data = [21, 20, 19, 16, 14, 13, 11, 9, 4, 3] c_width = 400 c_height = 350 c = tk.Canvas(root, width=c_width, height=c_height, bg= 'white') c.pack() #experiment with the variables below size to fit your needs y_stretch = 15 y_gap = 20 x_stretch = 10 x_width = 20
Read more