Redash v5 Quick Start Guide: Create and share interactive dashboards using Redash

Description

Learn how to quickly generate business intelligence, insights and create interactive dashboards for digital storytelling through various data sources with Redash Key Features Learn the best use of visualizations to build powerful interactive dashboards Create and share visualizations and data in your organization Work with different complexities of data from different data sources Book Description Data exploration and visualization is vital to Business Intelligence, the backbone of almost every enterprise or organization. Redash is a querying and visualization tool developed to simplify how marketing and business development departments are exposed to data. If you want to learn to create interactive dashboards with Redash, explore different visualizations, and share the insights with your peers, then this is the ideal book for you. The book starts with essential Business Intelligence concepts that are at the heart of data visualizations. You will learn how to find your way round Redash and its rich array of data visualization options for building interactive dashboards. You will learn how to create data storytelling and share these with peers. You will see how to connect to different data sources to process complex data, and then visualize this data to reveal valuable insights. By the end of this book, you will be confident with the Redash dashboarding tool to provide insight and communicate data storytelling. What you will learn Install Redash and troubleshoot installation errors Manage user roles and permissions Fetch data from various data sources Visualize and present data with Redash Create active alerts based on your data Understand Redash administration and customization Export, share and recount stories with Redash visualizations Interact programmatically with Redash through the Redash API Who this book is for This book is intended for Data Analysts, BI professionals and Data Developers, but can be useful to anyone who has a basic knowledge of SQL and a creative mind. Familiarity with basic BI concepts will be helpful, but no knowledge of Redash is required. Table of Contents Introducing Redash Installing Redash Creating and Visualizing your First Query Connecting to Data Sources Writing and Executing Queries Creating Visualizations Dashboards and Practical Tips Customizing Redash Cover Title Page Copyright and Credits Packt Upsell Foreword Contributors Table of Contents Preface Chapter 1: Introducing Redash Data challenges experienced by companies on a daily basis An example dashboard Ideal tools for targeting challenges Meeting Redash What exactly is Redash? Redash architecture Summary Chapter 2: Installing Redash Sizing – choosing the right machine to do the job Installation options and installation walkthrough Installation options AWS-predefined image Launching an instance using Redash AMI Launching an instance using Bitnami Redash AMI Welcome to Redash setup page GCE-Predefined image Docker-based installation Provisioning script installation Explaining the setup.sh script Troubleshooting Configuration and setup Email configuration Using Google OAuth to log in to Redash Redash environment settings HTTPS (SSL) Setup Permissions in Redash Groups Creating and editing groups Creating users Summary Chapter 3: Creating and Visualizing your First Query Creating and testing the Data Source Alternative static Data Source definition Creating your first query Creating the visualization Creating the dashboard Summary Chapter 4: Connecting to Data Sources Supported Data Sources Adding a new Redash Data Source A detailed walk-through of the selected Data Sources Connecting to PostgreSQL Connecting to ElasticSearch Connecting to MongoDB Connecting to GoogleSpreadsheet Connecting to Url Connecting to Query Results (beta)  Connecting to Amazon Athena Connecting to BigQuery Connecting to Redshift Connecting to DynamoDB Summary Chapter 5: Writing and Executing Queries Query listing Query editor overview Query operations  Creating a query Editing a query Forking a query Archiving a query Scheduling a query Query results and filters Query results Query filters Parametrized queries Parameter settings Query snippets Alerts Alert statuses Creating Alerts Alert destinations Summary Chapter 6: Creating Visualizations The benefits of visualizations An overview of visualization types Boxplot Chart Map (Choropleth map) Cohort  Counter Funnel Map (Markers map) Pivot table Sankey Sunburst sequence Word cloud Table Visualizations in action Creating and editing visualizations Going over Redash visualizations Boxplot Chart Map (Choropleth) Cohort Counter Funnel Map (Markers) Pivot Table Sankey Sunburst sequence Table Word Cloud Special actions on visualizations Summary Chapter 7: Dashboards and Practical Tips Dashboard how-tos  Creating/editing dashboards Dashboard query filters, hashtags, and favorite dashboards Dashboard-level filters Dashboard hashtags Favorite Dashboards Sharing dashboards Dashboard guidelines Tips and tricks Summary Chapter 8: Customizing Redash Redash API API authentication API calls overview API usage examples Extending Redash code Installing Redash for development Installing a Docker-based developer environment Initial dev setup Dev use Installing a regular developer environment  Installing dependencies Installing the necessary Python packages Node.js packages and assets Redash configuration Creating Redash operational database tables Starting Redash's main processes Running tests Connecting to the remote server while running the frontend locally Summary Other Books You May Enjoy Index