Data Apps

Astrato makes visualizing financial data easy and accessible to business users, offering meaningful insights from complex financial statements. Intuitive dashboards, insightful visualizations, and cloud-native analytics not only enhance the quality of the BI but the capacity for collaboration in an organization.

This app uses an input form and Snowpark to deliver advanced forecasting. Simply enter the product category and measure that you want to forecast, along with the time frame you are looking for.

Behind the scenes, a Snowpark UDTF with the forecasting procedure ‘Prophet’ (by Facebook) calculates an advanced forecast. Prophet is a procedure for forecasting time series data based on an additive model where non-linear trends are fit with yearly, weekly, and daily seasonality, plus holiday effects. Prophet is robust to missing data and shifts in the trend, and typically handles outliers well.

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.

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.

Follow where the data leads you with clear visual storytelling! Astrato’s data analytics and visualization help all users analyze data and reach the best data-driven conclusion through engaging visuals!