Astrato Gallery: Experience interactive data in action

Seattle Housing Dashboard Built with Astrato

The Seattle Housing Market: An Interactive Dashboard

Interactive

The Seattle Housing Market Dashboard displays data for homes sold in Seattle, Washington, USA between August and December 2022. The dashboard showcases Astrato’s Input form functionality, and enables the user to predict a price of their desired home based on their requirements, using a sophisticated filtering option.

The Price Prediction Sheet uses a statistical model to predict a home’s price based on its attributes, such as number of bedrooms, bathrooms, Square Feet (Sqft) and Zip code or Region. The user enters their requirements into the input form, and predicts the price based on its attributes. This feature was accomplished using Python.

The dashboard will also display similar homes (the same number of bedrooms, with ±1 bathroom, ±500 sqft, and in the same zip code or region.) This feature was created with SQL. The Supplemental Data Sheet allows the user to explore different regions and get a sense of how house prices and availability have changed over time.

Elon Musk Data Dashboard Built in Astrato

The Elon Effect: Do Elon Musk’s Antics Affect TESLA Stock Prices?

Interactive

Do Elon Musk’s actions really impact TESLA stock prices? With Elon Musk consistently making headlines with his controversial tweets, Astrato Data Visualization Developer Stephanie French built this dashboard to see if there’s a correlation between the headlines of Elon Musk and the stock price of TESLA, his only publicly-traded company.

This dashboard showcasing the ‘Elon Effect’ was created using data found in Kaggle that analyzed the sentiment of Elon Musk’s tweets. In Snowflake, Stephanie then created code to separate keywords to show what topics Elon was talking about. This dashboard showcases how interactive Astrato can be by using filtering and tool tips.

To use the dashboard, choose a headline involving Elon Musk to see the TESLA stock price the week before and after Elon made the headlines.

Sales CRM Workbook

Interactive

Time Travel and Measure Filters give you the power to view your data as it was at any point in the past, and filter data to what is relevant to your business problem. With Time Travel, you can travel back in time to see your data as it was at any point in the past.

This powerful feature helps you answer critical questions about your business, like how did we do last month? What were our sales projections for this quarter? With Time Travel, you have instant access to all of the information you need to make informed decisions about your business.

Steam Workbook

Interactive

Live Query gives you immediate insights into your data so you can make better decisions faster. With real-time updates and accurate results, you can rely on Live Query to give you the information you need when you need it.

Google Workbook

Get the insights you need to make data-driven decisions about your website traffic with Google Analytics. This snapshot view of this information is easy to read and includes graphs that show how much traffic your site is receiving, where it is coming from, and how it changes over time. Connect to Google BigQuery and show or hide relevant information using Actions so you can get the most out of your data.