Book Image

Effective Business Intelligence with QuickSight

By : Rajesh Nadipalli
Book Image

Effective Business Intelligence with QuickSight

By: Rajesh Nadipalli

Overview of this book

Amazon QuickSight is the next-generation Business Intelligence (BI) cloud service that can help you build interactive visualizations on top of various data sources hosted on Amazon Cloud Infrastructure. QuickSight delivers responsive insights into big data and enables organizations to quickly democratize data visualizations and scale to hundreds of users at a fraction of the cost when compared to traditional BI tools. This book begins with an introduction to Amazon QuickSight, feature differentiators from traditional BI tools, and how it fits in the overall AWS big data ecosystem. With practical examples, you will find tips and techniques to load your data to AWS, prepare it, and finally visualize it using QuickSight. You will learn how to build interactive charts, reports, dashboards, and stories using QuickSight and share with others using just your browser and mobile app. The book also provides a blueprint to build a real-life big data project on top of AWS Data Lake Solution and demonstrates how to build a modern data lake on the cloud with governance, data catalog, and analysis. It reviews the current product shortcomings, features in the roadmap, and how to provide feedback to AWS. Grow your profits, improve your products, and beat your competitors.
Table of Contents (15 chapters)
Effective Business Intelligence with QuickSight
Credits
About the Author
About the Reviewer
www.PacktPub.com
Customer Feedback
Preface

Enriching your data


One of the exciting features of SPICE is the ability to transform data and also create additional derived fields. Let's look at this feature with an example; follow these steps to add a new derived field to the dataset we just created:

  1. From the QuickSight home page, click on Manage data.

  2. Select the usasalarybyzipandcity that was created in the previous Joining data in SPICE section and then click on Edit data set.

  3. Select New Field and then follow the wizard on the right to create a new derived field.

  4. In this example, we are going to use the toUppper function in the formula and convert the statement name to uppercase.

    Figure 3.10: Derived column

This completes the example on how to create a new derived field. Now let's review the various functions available in SPICE.

Arithmetic and comparison operators

For numeric data types, SPICE allows the following arithmetic and comparison operators in calculated fields:

  • Addition (+)

  • Subtraction (-)

  • Multiplication (*)

  • Division (/)

  • Equal (=)

  • Not...