Demo Apps

A fast, simple way to explore machine-generated log data at scale.

This workbook uses the Brown University MgBench dataset, a public benchmark built to test analytics performance on high-volume operational logs. You’ll find millions of rows of raw machine metrics – CPU, memory, disk, network, and load stats – captured across multiple machines and groups. It’s ideal for showing how Astrato handles live-query workloads, fast filtering, and smooth interaction on dense time-series data. What’s inside: Machine groups and names CPU usage (idle, system, user, wio, nice) Memory and disk metrics Load averages (1/5/15 minute) Network bytes in/out Time-series views built directly from the raw MergeTree tables This workbook helps users explore: Trends over time Resource spikes Group comparisons Anomalies in machine performance Great for demos that highlight real operational telemetry, live queries, and how Astrato handles large datasets without extracts.

‍

Sources:  

- https://clickhouse.com/docs/getting-started/example-datasets/brown-benchmark

- https://clickpy-playground.clickhouse.com/?query_id=GEOICKHUJBUXMYROUXJK7C

‍

See your team’s GitHub activity come to life, powered by ClickHouse for lightning-fast queries ⚡

🧠 What you’ll find:

Real-time view of commits, file changes, and trends

Word cloud of the most common commit messages

Top contributors and how much they’ve modified

Heatmap showing when your team commits most

Smart AI insights that highlight work patterns and weekend dips

🚀 Why it’s cool:

You can explore years of GitHub data instantly. Spot trends, compare teammates, and see productivity shifts; all in one super-responsive dashboard.

‍

Transform raw sports data into compelling stories with dynamic player analytics, in-depth match comparisons, and personalized reporting dashboards that reveal the hidden patterns behind every game.

‍

This workbook shows how self-service formulas help users apply:

📈 Quarter-over-quarter growth (like the 274% spike in Q3 2024)

📉 Negative growth detection (e.g. -2% in Q1 2023)

➕ Inline % changes on charts with no code Use built-in functions like: Running totals Moving averages Period-over-period Nested logic Built for business users who need fast, flexible insights, without SQL or help from the data team.

‍

Effortless comparisons. Use grouped and stacked bar or column charts to show trends over time, breakdowns by category, or before/after states.

✅ Drag-and-drop setup

🎨 Conditional formatting

🧠 Smart defaults to highlight insights faster

‍

✅ Create and manage new issues with inline forms

📊 Track top reporters and most active contributors

⚙️ Filter by status, assignee, priority, and more

📈 Know what's rising, what’s resolved, and what’s stuck Perfect for product, QA, and support teams needing live, actionable insights. Powered by real-time data for faster debugging and better collaboration.

‍

🔍 Match & Learn: Astrato Memory Game
Test your memory while exploring Astrato! Flip cards to reveal data sources and try to find matching pairs, all powered by dynamic Astrato Actions. This interactive demo is a fun way to learn advanced action techniques and how to create engaging, data-driven experiences.

‍

Unlock insights with our dynamic Airbnb dashboard! Whether you're a property owner, a traveler, or a market analyst, our dashboard offers a comprehensive view of Airbnb listings and reviews in Boston.

• Interactive Map: Navigate through Boston’s neighborhoods to see the distribution of listings.
• Detailed Listings: Access key details such as price, availability, and amenities.
• Review Analysis: Understand guest experiences with sentiment analysis and ratings breakdown.
• Market Trends: Track trends over time to make informed decisions.
• Self-Service BI: Explore data without adding tickets to a never-ending backlog. Bookmark your analytics to revisit it and share with others.

Drill-down into themes and topics with our word cloud. https://help.astrato.io/en/articles/8811397-word-cloud

❄️🏔️🗺️Less than 2 WEEKS until #SnowflakeSummit2025, resident Snowflake Data Superhero, Piers Batchelor, has already mapped out the top parties.

‍

🗺️ Astrato Map Showcase Explore the power of live, interactive maps with Astrato!

This demo app shows:

📊 State-level heatmaps

✈️ Flight route visualizations

🛫 Airport terminal maps

📍 Bubble maps with state counts

‍

Perfect for uncovering insights, tracking movement, and making data-driven decisions — all in one beautiful app! 🚀

‍

Spotify Data DNA

Astrato widgets. Inspired by the work of Nicholas Lea TrengrouseThis is a set of widgets designed to maximize canvas space and deliver focused insights:

• 𝗔𝗻 𝗶𝗻𝘁𝗲𝗿𝗮𝗰𝘁𝗶𝘃𝗲 𝘄𝗶𝗱𝗴𝗲𝘁 for hands-on exploration.
• 𝗔 𝗱𝘆𝗻𝗮𝗺𝗶𝗰 𝘃𝗶𝘀𝘂𝗮𝗹 for deeper data comparisons
• 𝗔 𝘀𝗹𝗲𝗲𝗸 𝗰𝗮𝗿𝗱 to highlight key metrics.

Astrato’s LLM Comparison App brings AI and analytics together in a seamless, interactive experience—powered by Snowflake Cortex. 🎥💡Here’s what you can explore:1️⃣ LLM Prototyping: Test and compare outputs from Anthropic's Claude Sonnet, Snowflake Arctic, and Llama 3 side-by-side. Adjust model settings like temperature and system prompts directly in the app.2️⃣ Use Case Tuning: Simplify complex parameters with intuitive BI controls, allowing easy experimentation to find the best model for your use case.3️⃣ Airbnb Review Analysis: Dive into a dedicated sheet to analyze Airbnb review data. Harness the power of LLMs to derive actionable insights directly from customer feedback.Whether it’s picking the right LLM for your budget or tying AI prompts to your warehouse data, this app shows the possibilities of embedded analytics meeting AI.Built to showcase the best of Astrato + Snowflake Cortex, this app is your all-in-one tool for interactive AI experiences. Ready to elevate your data storytelling? 🚀

This is a sample - setup this workbook now,https://help.astrato.io/en/articles/10248639 This workbook provides comprehensive insights into user engagement by tracking active users, session lengths, and workbook usage trends. It enables organizations to monitor daily activity, identify high-usage content, and uncover gaps in adoption to optimize onboarding, improve content strategies, and enhance resource allocation.

Dive into this interactive map showcasing the global community of Snowflake Data Superheroes! Using Cortex, we enriched location data with Longitude & Latitude, bringing the Superheroes' worldwide presence to life.Built in Astrato, the visualization leverages our native heatmap and point map layers to deliver a seamless, dynamic experience. See the power of live data connections and intuitive storytelling in action!Created by our very own Snowflake Data Superhero, Piers Batchelor. Join the ranks, apply here: https://www.snowflake.com/en/data-superheroes/https://www.snowflake.com/en/data-superheroes/

Spotify Wrapped Meets Data Analytics: Build Your Taste ProfileGet inspired by our Spotify analytics app, built to celebrate the arrival of Spotify Wrapped!This demo uses Snowflake Cortex AI to create personalized insights like your unique taste profile and even predict your age based on listening habits. Powered by Astrato Analytics, it highlights how HTML support transforms tables, KPI cards, and visuals, making analytics as striking as your favorite album covers.⚠️ Note: While the app supports a variety of playlists, some curated by Spotify may not work due to API limitations.Experience the power of data storytelling for yourself! Explore the demo and see how Astrato brings creativity to analytics.

Create, Schedule & Share Paginated Reports and Data Exports

⏰Deliver Business-Critical Insights | Provide users with essential insights precisely when they need it📃Generate, schedule, and distribute reports and data exports seamlessly.✨Leverage AI from Astrato Insights, simplify complex data into actionable summaries.

.

.

This People Analytics and Feedback demo dashboard is enhanced with essential capabilities, including writeback functionality and AI-powered sentiment analysis using Snowflake Cortex LLM & ML from Snowpark.The sentiment sheet displays drivers and keyword segmentation to provide deeper insights into employee feedback. The integration of sentiment analytics allows for a nuanced understanding of employee performance and morale.With the ability to easily update data in real-time, this dashboard is a powerful tool for tracking employee engagement, retention efforts, and growth signals, enabling proactive decision-making based on actionable insights.

Unlock the full potential of your retail data with this self-service dashboard, designed for dynamic, real-time insights and powered by ClickHouse. Built for retail teams, this dashboard lets you explore customer, sales, and product performance across global markets—no IT support required.🌎 Customer Revenue Map – Visualize sales hotspots around the world with a revenue heatmap that pinpoints high-value regions.📊 Realized Customer Lifetime Value (RCLTV) by Location – Identify your most loyal and valuable customers by region, revealing markets with the highest lifetime value.🛍️ Product Popularity by Category – Keep tabs on top-selling categories, from fashion to accessories, and discover what’s driving sales in real-time.🌐 Revenue Flow Analysis – The Sankey diagram gives a detailed look at traffic sources and revenue distribution by category and country, showing exactly how customers are reaching you through channels like search, social, and organic.🔧 Self-Service Custom Reporting – Build your own custom reports with easy drag-and-drop visualizations, using governed data for accuracy and compliance. Tailor insights to fit your needs, whether you’re exploring customer segments or analyzing product trends, all without needing to code.💡 AI-Powered Dashboard Insights – AI-generated insights break down trends, category performance, and traffic source effectiveness, empowering you to make smarter decisions quickly.

This demo dashboard offers a comprehensive and interactive overview of Olympic medal data from 1994 to 2004. It simplifies the exploration of key metrics, such as medal distribution by year, country, and region, enabling quick and insightful analysis.

This interactive demo provides insights into energy trends from 2016 to 2018, visualizing key metrics for energy load, price analysis, and generation across multiple energy sources. Users can explore biomass, gas, hard coal, wind, and solar contributions, tracking their performance over time and analyzing the alignment between actual vs. forecasted data. The dashboard highlights significant periods of market shifts, including price fluctuations, consumption patterns, and renewable energy adoption, giving users a detailed view of energy supply and pricing strategies.

Discover the World of LEGO with Our New Dashboard!

Explore the incredible diversity and depth of LEGO themes and sets. Built with Astrato’s powerful Self-Service BI platform, this dashboard exemplifies the potential of self-service analytics and real-time data exploration.

Why You’ll Love This Dashboard:

Self-Service BI:

• No coding needed: Dive into your data with ease.
• Build 4x faster than traditional tools like Tableau and Power BI.

Explore LEGO Themes:

• 18,391 Unique Sets: Discover the extensive collection of LEGO sets across various themes.
• Detailed Insights: See the most popular sets, colors, and themes at a glance.

Unlock the potential of your data with Astrato – where insights are just a click away.

🚀 Unlock the Power of Real-Time Data with Our Demo App!Ever wondered how your call center metrics can drive smarter decisions? Dive into our demo app built on real-world data from call center operations. Here’s what you can explore:

• Agent Performance: See how different agents handle call types, resolutions, and more.
• Call Metrics: Track call duration, satisfaction scores, and disposition for actionable insights.
• Queue Management: Understand how various queues impact call handling and resolution.

Why Try the Demo?

• Instant Insights: Get a clear view of key performance indicators and call metrics.
• User-Friendly Interface: Experience seamless navigation and easy-to-understand data visualizations.
• Actionable Data: Use real-time data to make informed decisions and optimize operations.

Elevate your analytics game and make every call count!

This dashboard visualizes complex, large-scale sales data, providing real-time insights on PepsiCo’s performance with over 6 billion rows of data.Astrato’s dashboard handles massive datasets effortlessly, making it easy for teams to drill into sales performance at scale, across multiple dimensions, with interactive visuals and real-time data updates from Snowflake.

Proportional brushing is a powerful feature in data visualization that highlights related data points across multiple charts simultaneously. When you select a data point in one chart, proportional brushing automatically highlights corresponding data in other charts, making it easier to see patterns, correlations, and insights at a glance.With two measures with a 𝗰𝗼𝗺𝗺𝗼𝗻 𝗽𝗮𝗿𝗮𝗺𝗲𝘁𝗲𝗿 for the country that is 𝗯𝗿𝘂𝘀𝗵𝗲𝗱 and a variable driving that parameter, Proportional Brushing can be created with ease, using 𝗔𝘀𝘁𝗿𝗮𝘁𝗼 𝗔𝗰𝘁𝗶𝗼𝗻𝘀. Have a look at the images attached on the end result and how to create it. I also created an action to update the 𝗱𝘆𝗻𝗮𝗺𝗶𝗰 𝗹𝗮𝗯𝗲𝗹𝘀.

This visually compelling dashboard provides an insightful representation of the population distribution across the United States. Designed for ease of use, it offers a comprehensive view of population estimates and year-over-year population changes by state.Define and store new regions on the map using this Astrato Data App. Interactive map allows users to zoom in and pan across different regions for a closer look.

Explore the comprehensive Healthcare System Dashboard designed for Bedford Health System, a robust tool leveraging Astrato’s powerful data visualization capabilities. This dashboard provides a holistic view of various critical healthcare metrics, enabling informed decision-making and strategic planning.This Astrato workbook is designed for healthcare administrators, financial analysts, and strategic planners within Bedford Health System. It offers a comprehensive view of operational, clinical, and financial data, driving data-driven decisions and enhancing overall healthcare delivery.

The CRM Data App in Astrato visualizes deal sizes, top accounts, revenue share, and sales team performance. It offers real-time analytics with a user-friendly interface, empowering teams to identify high-value opportunities, streamline decision-making, and boost revenue.Drive business growth with data-driven insights and enhance sales efficiency.

🎮 Pick your Street Fighter in this pixel perfect dashboard. Inspired by Luis Felipe Tensini check it out here Youtube

☢️🎮Radioactive data just in! Since the launch of Amazon Prime's #FALLOUT, gamers have flocked back to the fallout game series with single player Fallout 4 on top, followed by MMO Fallout 76. Data sourced from SteamDB. Visualised in Astrato Analytics. Presented on a #PipBoy.

Having a hard time coming up with a creative name for your signature color? Astrato's GenAI Co-pilot functionality powered by Snowflake and Mistral AI got you covered!

Discover the journey of passengers and staff through London Luton Airport with our cutting-edge analytics. Utilizing mock WiFi triangulation location data, we've mapped the bustling foot traffic within the airport, revealing the intricacies of movement and behavior patterns. Our analysis, powered by Astrato, offers a comprehensive view, enabling users to interactively slice and dice the data. This immersive experience not only showcases the power of live query BI but also demonstrates our expertise in handling large-scale, complex datasets to derive actionable insights. Navigate the flow of people with precision, and explore the potential of data-driven decision-making in improving airport operations and enhancing the travel experience.

Smash Factor is ball speed divided by club speed. The higher the smash factor the better the energy transfer. A golfer would hope to achieve a smash factor near 1.50 on driver shots.Calculate your smash factor in this interactive data app

Ask complex questions, get simple answers quickly, without sharing data ⚡Business users ask really challenging questions of their data, LLMs can retrieve answers to those questions superfast. Bring the AI to the data, build powerful Data Apps with AI, using Astrato & Snowflake.

Select a customer from the table and update their MRR (monthly recurring revenue) to model their risk of churn. No-code modeling, without using data scientists time. Seamlessly build action into analytics and integrate with other tools using the power of Snowflake and Snowpark.How to:

1. Select a customer ID using the button in the first column of the table
2. Update the subscription value (be sure that it differed from the original subscription value)
3. Click on the calculate risk button

This dashboard presents a multi-faceted view of product sales performance. Dive deep into customer lifetime value and understand sales changes with our new sankey chart.

This comprehensive dashboard offers a real-time overview of gun violence trends across New York City, integrating advanced analytics with the Astrato custom report for nuanced policy and security analysis. Designed for policymakers, law enforcement, and researchers, it features a highly interactive map highlighting hotspots and patterns of gun-related incidents throughout the city. Users can delve into detailed statistics, such as incident frequencies, time-based trends, and demographic data of affected populations.The dashboard's intuitive interface allows for easy navigation between different data sources, including direct feeds for recent incidents and historical comparisons. With the inclusion of the custom report, users gain access to an in-depth analysis of gun trafficking patterns, helping to identify potential sources and routes of illegal firearms entering the city.Key features include:

• Dynamic Heatmap: Visualize gun violence hotspots in real time, with the ability to drill down to neighborhood-level details.
• Trend Analysis: Examine how gun violence metrics evolve over time, with filters for date ranges, specific events, and legislative changes.
• Demographic Insights: Understand the impact of gun violence on different communities, including age, gender, and ethnicity breakdowns.
• Policy Impact Analysis: Assess the effectiveness of current policies and regulations on reducing gun violence

This dashboard not only serves as a critical tool for monitoring and responding to gun violence but also as a foundation for informed decision-making and policy development in New York City.

Load data right into Snowflake using this Astrato Data App demo. Reading directly from APIs into Snowflake, presented and initiated, right in Astrato. This Astrato Data App brings you data on demand, froom the Zoopla API, searching the UK property market in real time, storing the data in Snowflake and visualising it instantly in Astrato.Built for you, by Snowflake Data Superhero & Astrato Senior Product Manager, Piers Batchelor.See the full blog, with code: https://medium.com/snowflake/python-data-ingestion-with-snowpark-in-5-steps-d5dbd305ad69

Funnel is the marketing data platform that gives you business-ready data that makes sense. Collect data from all platforms across the customer journey, transform it, explore it, and send it to any visualization app or data warehouse.You get data that is clean, accurate, and always up to date – data that helps you understand how your marketing is performing.

Unveil the Art of Data Visualization with Astrato's Design Lookbook! 🌟 Dive into a world where data meets design. Our Lookbook is your gateway to exploring stunning, innovative visualizations crafted for impact and clarity. Elevate your data storytelling skills now!

This interactive dashboard offers a comprehensive overview of the automobile industry's competitive landscape. It's an invaluable tool for business intelligence and market analysis.Insights are succinctly summarized using Generative AI, pointing out the highest and lowest performers in categories like fuel efficiency and price change. This dashboard is ideal for stakeholders to derive quick, actionable insights and for companies to demonstrate their analytic capabilities in the automobile sector.Astrato Insights summarizes the whole dashboard, ready to be easily understood by users, copied or shared.

This "Snowpark for Python" powered data app runs budget allocations against a linear regression model to predict future ROI (Return On Investment) of variable advertising spend budgets across multiple channels including search, video, social media, and email using Snowpark for Python and scikit-learn.

This high-tech armour dashboard showcases  cutting-edge data visualization, blending detailed analytics with striking aesthetics. This platform illustrates the potential in creating dynamic and engaging user experiences, perfect for tech-driven presentations and discussions. It's a prime example of data-driven storytelling, with a design that speaks directly to tech enthusiasts and professionals alike.Your browser does not support the video tag.

Pedal Your Way to Peak Performance! In the fast-paced world of sports retail, every decision counts. With Astrato's Sports Goods Retail Dashboard, you're not just selling gear—you're fueling performance. This dashboard turns you into a data hero, letting you compose retail strategies like never before.

• Real-Time Sales Data: Track bike sales, accessories, and service packages in real-time.
• Inventory Management: Know what's in stock, what's hot, and what needs reordering.
• Supplier Metrics: Evaluate the performance and reliability of your suppliers.

Logistics can be a maze, but not with Astrato's Logistics & Shipping demo. You're not just moving goods—you're optimizing every mile.Built for scale and accuracy, this tool is your compass in the complex world of logistics. With live writeback, you're not just monitoring—you're actively steering your shipping operations.

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.

Get real-time insights into your FMCG sales like never before. This isn't just a dashboard; it's your control center. Conduct your sales strategy like a maestro, making data-driven decisions on the fly. Say goodbye to ad-hoc queries and hello to instant, actionable insights.

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.

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.

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.

Easily identify hotspots in time using gradient color scales. See the lows and highs of consumption, and filter down for more detail on specific time periods for in-depth insights!