Sign In Start Free Trial
Account

Add to playlist

Create a Playlist

Modal Close icon
You need to login to use this feature.
  • Book Overview & Buying Tableau 10 Business Intelligence Cookbook
  • Table Of Contents Toc
  • Feedback & Rating feedback
Tableau 10 Business Intelligence Cookbook

Tableau 10 Business Intelligence Cookbook

By : Donabel Santos, Paul Banoub
3.8 (5)
close
close
Tableau 10 Business Intelligence Cookbook

Tableau 10 Business Intelligence Cookbook

3.8 (5)
By: Donabel Santos, Paul Banoub

Overview of this book

Tableau is a software tool that can speed up data analysis through its rich visualization capabilities, and help uncover insights for better and smarter decision making. This book is for the business, technology, data and analytics professionals who use and analyze data and data-driven approaches to support business operations and strategic initiatives in their organizations. This book provides easy-to-follow recipes to get the reader up and running with Tableau 10, and covers basic to advanced use cases and scenarios. The book starts with building basic charts in Tableau and moves on to building more complex charts by incorporating different Tableau features and interactivity components. There is an entire chapter dedicated to dashboard techniques and best practices. A number of recipes specifically for geospatial visualization, analytics, and data preparation are also covered. By the end of this book, you’ll have gained confidence and competence to analyze and communicate data and insights more efficiently and effectively by creating compelling interactive charts, dashboards, and stories in Tableau.
Table of Contents (11 chapters)
close
close
10
Index

Using schema.ini to resolve data type issues


In this recipe, we will use a schema.ini file to resolve the data types when we connect to a fixed width text file data source with four columns.

Getting ready

To follow this recipe, download this chapter's files from the Packt website and use the file called Fixed Width Sample.txt.

This is what the file looks like when opened in a text editor showing special characters:

Note that this file does not have any column headers. In addition, note the following:

  • The first column should be text

  • The second column should be integers

  • The third column should be text

  • The fourth column should be dates

How to do it...

Here are the steps to use the .ini file with the fixed width text file:

  1. Create a text file with the following contents:

  2. Save the file as schema.ini and save it in the same directory as the Fixed Width Sample.txt file.

  3. Connect to the text file in Tableau:

  4. Confirm that there are four fields in the Tableau preview window, with the same configuration as specified...

Visually different images
CONTINUE READING
83
Tech Concepts
36
Programming languages
73
Tech Tools
Icon Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.
Icon Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.
Icon 50+ new titles added per month and exclusive early access to books as they are being written.
Tableau 10 Business Intelligence Cookbook
notes
bookmark Notes and Bookmarks search Search in title playlist Add to playlist download Download options font-size Font size

Change the font size

margin-width Margin width

Change margin width

day-mode Day/Sepia/Night Modes

Change background colour

Close icon Search
Country selected

Close icon Your notes and bookmarks

Confirmation

Modal Close icon
claim successful

Buy this book with your credits?

Modal Close icon
Are you sure you want to buy this book with one of your credits?
Close
YES, BUY

Submit Your Feedback

Modal Close icon
Modal Close icon
Modal Close icon