Redash v5 Quick Start Guide.pdf

【实例简介】Learn how to quickly generate business intelligence, insights and create interactive dashboards for digital storytelling through various data sources with Redash 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.

【实例截图】

【核心代码】

Table of Contents
Title Page
Copyright and Credits
Redash v5 Quick Start Guide
Packt Upsell
Why subscribe?
PacktPub.com
Meeting Redash
What exactly is Redash?
Redash architecture
Summary
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
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
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
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
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
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
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
Leave a review - let other readers know what you think