Search icon CANCEL
Arrow left icon
Explore Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Conferences
Free Learning
Arrow right icon
Arrow up icon
GO TO TOP
Mastering Tableau 2023

You're reading from   Mastering Tableau 2023 Implement advanced business intelligence techniques, analytics, and machine learning models with Tableau

Arrow left icon
Product type Paperback
Published in Aug 2023
Publisher Packt
ISBN-13 9781803233765
Length 684 pages
Edition 4th Edition
Languages
Tools
Arrow right icon
Author (1):
Arrow left icon
Marleen Meier Marleen Meier
Author Profile Icon Marleen Meier
Marleen Meier
Arrow right icon
View More author details
Toc

Table of Contents (19) Chapters Close

Preface 1. Reviewing the Basics 2. Getting Your Data Ready FREE CHAPTER 3. Using Tableau Prep Builder 4. Learning about Joins, Blends, and Data Structures 5. Introducing Table Calculations 6. Utilizing OData, Data Densification, Big Data, and Google BigQuery 7. Practicing Level of Detail Calculations 8. Going Beyond the Basics 9. Working with Maps 10. Presenting with Tableau 11. Designing Dashboards and Best Practices for Visualizations 12. Leveraging Advanced Analytics 13. Improving Performance 14. Exploring Tableau Server and Tableau Cloud 15. Integrating Programming Languages 16. Developing Data Governance Practices 17. Other Books You May Enjoy
18. Index

Using the OData connector

The exercises in this chapter can be followed by downloading the workbook associated with this chapter at https://public.tableau.com/profile/marleen.meier. The following steps explain how datasets from the web can be loaded directly into Tableau by using an OData endpoint – in this case, provided by the city of Chicago:

  1. Navigate to https://data.cityofchicago.org/Public-Safety/Crimes-2001-to-Present/ijzp-q8t2 and select the More icon (indicated by an ellipsis, ), followed by the Access Data via OData button:

Figure 6.1: Chicago Data Portal

  1. Copy the OData Endpoint URL and open Tableau Desktop:

Figure 6.2: OData

  1. In the Data Source pane, search for OData, and select the OData option:

Figure 6.3: OData connector

  1. In the Server field, copy in the OData endpoint from the Chicago Crime website. Authentication is not necessary, so select Sign In to get started:
  2. ...
lock icon The rest of the chapter is locked
Register for a free Packt account to unlock a world of extra content!
A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.
Unlock this book and the full library FREE for 7 days
Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of
Renews at £16.99/month. Cancel anytime