September 2020
Beginner
442 pages
9h 54m
English
Content preview from Tableau Prep: Up & Running
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Chapter 38. Managing Conversion Rates
The world is getting smaller, with businesses and organizations working across national borders more than ever before. With this globalization comes data challenges that can be solved through a number of data preparation strategies. One typical use case for multinational organizations is determining currency conversion rates in order to ensure the financial data being analyzed is consistent and being accurately compared/aggregated.
Challenges of Conversion Rates
Converting rates such as currency seems like such a simple task. Multiply the currency rate by the original value, and you have the currency you require. Easy, right? Not so fast. Depending on the level of accuracy you want, using a single, constant exchange rate might not be sufficient. Currency exchange rates fluctuate throughout the day, every day.
Which rate you use may make a significant difference even in smaller transactions; added up over time, the small differences can accrue, resulting in over- or understated results or profits. The frequency of the conversion rates (hourly, daily, weekly, etc.) is another important decision to make. Greater frequency assists with accuracy but makes the conversion rate tables more difficult to apply, especially to different time periods.
Applying conversion rates consistently is also key, especially when you are working across a number of different business units. Let’s look at how to do this within Prep.
Applying Conversion Rates in Prep ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.