All Products

Best Sellers

New Releases

Books

Videos

Audiobooks

Learning Hub

Newsletters

Free Learning

You're reading from Tableau Desktop Certified Associate: Exam Guide

Product type Book

Published in Dec 2019

Publisher Packt

ISBN-13 9781838984137

Pages 370 pages

Edition 1st Edition

Languages

Concepts

Business Intelligence

Authors (5):

Dmitry Anoshin

JC Gillet

Fabian Peri

Radhika Biyani

Gleb Makarenko

View More author details

Table of Contents (15) Chapters

Preface

1. Section 1: Getting Started with Tableau

2. Building Your Data Model

3. Section 2: Answering Questions with Data

4. Working with Worksheets

5. Analyzing Data Using Charts

6. Visualizing Geographic Data

7. Understanding Simple Calculations in Tableau

8. Section 3: Advanced Tableau

9. Tableau Table Calculations

10. Level of Detail Expressions

11. Leveraging Analytics Capabilities

12. Building Your Dashboards

13. Mock Test A + B (Assessment)

Mock tests A and B

14. Other Books You May Enjoy

Leave a review - let other readers know what you think

Data source constraints for LOD

While LOD calculations are in general supported in Tableau, there are a few constraints on certain data source types. At the time of writing, here are the most notable exceptions to the rule:

Data source	Support
Google Big Query	Supported for standard SQL, not supported for legacy SQL
Microsoft Access	Not supported
Microsoft Jet-based connections (legacy connectors for Microsoft Excel, Microsoft Access, and text)	Not supported
Microsoft SQL Server	SQL Server 2005 and later
Mongo DB	Not supported
Oracle	Supported version 9i and later
PostgreSQL	Supported version 7 and later

A complete and up-to-date version of this list can be found at https://help.tableau.com/current/pro/desktop/en-us/calculations_calculatedfields_lod_constraints.htm.

The rest of the chapter is locked

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

Start free trial

Renews at $15.99/month. Cancel anytime}

Authors (5)

Dmitry Anoshin

Dmitry Anoshin is a data-centric technologist and a recognized expert in building and implementing big data and analytics solutions. He has a successful track record when it comes to implementing business and digital intelligence projects in numerous industries, including retail, finance, marketing, and e-commerce. Dmitry possesses in-depth knowledge of digital/business intelligence, ETL, data warehousing, and big data technologies. He has extensive experience in the data integration process and is proficient in using various data warehousing methodologies. Dmitry has constantly exceeded project expectations when he has worked in the financial, machine tool, and retail industries. He has completed a number of multinational full BI/DI solution life cycle implementation projects. With expertise in data modeling, Dmitry also has a background and business experience in multiple relation databases, OLAP systems, and NoSQL databases. He is also an active speaker at data conferences and helps people to adopt cloud analytics.

See other products by Dmitry Anoshin

JC Gillet

Jean-Charles (JC) Gillet is a seasoned business analyst with over 7 years of experience with SQL at both a large-scale multinational company in the United Kingdom and a smaller firm in the United States, and 5 years of Tableau experience. He has been working with Tableau and SQL for multiple years to share his expertise with his colleagues, as well as delivering SQL training. A French national, JC holds a master's degree in executive engineering from Mines ParisTech and is a Tableau Desktop Certified Associate. In his free time, he enjoys spending time with his wife and daughter (to whom he dedicates his work on this book) and playing team handball, having competed in national championships.

See other products by JC Gillet

Fabian Peri

Fabian Peri's interest in decision analysis started after joining his first fantasy basketball league in 2006. His love for data analysis led him to pursue an MBA in information systems at the University of Tulsa, and then an MSc in predictive analytics from Northwestern University. Since graduating, he has primarily worked in risk analysis and management for companies such as Amazon, GE Capital, and Wells Fargo. He is currently focused on using visualization to explore and interpret vast quantities of data.

See other products by Fabian Peri

Radhika Biyani

Radhika Biyani is currently working as a recruitment insights analyst with Amazon. Before this, she worked as an analytics consultant with Version 1, where she consulted on several large-scale BI and analytics projects with clients across various industry verticals such as HR, finance, utility, supply chain, and more. She holds a master's degree in business analytics and has many certifications, including Tableau Qualified Associate. She enjoys attending meetups and is an active member of many meetup groups, including Tableau User Group Dublin.

See other products by Radhika Biyani

Gleb Makarenko

Gleb Makarenko began using Tableau in 2018 and quickly fell in love with how intuitive and easy to use the software was. He was able to easily adapt to its interface and create powerful visualizations. That is when he decided to get certified on Tableau software in order to receive proper credentials that he could use on his resume, as well as learn about the intricacies of the software that he wasn't using at the time. With a bit of effort and research, Gleb was able to complete the examination. And he recommends the same to anyone who is serious about working with Tableau.

See other products by Gleb Makarenko