Test-Drive Enola
with AdventureWorks!
Ready to explore the magic of Enola? This guide lets you test Enola's data-crunching powers using the AdventureWorks Data Warehouse—a fun sandbox for a fictional bicycle company.
Enola: Your Data Sidekick
Enola is your friendly guide for slicing and dicing data. It lets you ask questions, run queries, and spark insights—no data science degree needed!
Enola is your data sidekick, simplifying data analysis with the BADIR™ philosophy (Business Question, Analysis Plan, Data Collection, Insights Derivation, Recommendations) and helping you focus on impactful insights.
In this guide, you'll use the AdventureWorks dataset to test Enola's features, but with full access, you can explore your own data.
AdventureWorks Sandbox
Picture a bike shop buzzing with sales, customers, and inventory. Its data covers:
Sales Analysis
Online orders, reseller sales, and regional performance tracking
Customer Insights
Customer demographics, purchasing patterns, and satisfaction metrics
Product Performance
Inventory movements, product pricing, and market trends
Financial Reporting
Budget tracking, expense analysis, and revenue optimization
Marketing Analytics
Promotion effectiveness and campaign performance tracking
Employee Performance
Sales quotas, performance tracking, and team analytics
Let's test Enola's skills and uncover which bikes rule the market! 🚴♂️
AdventureWorks Data: The Sandbox Tables
AdventureWorks organizes data in tables, like a bike shop's filing system. Here's a quick look at key ones to test Enola:
FactInternetSales
Online orders (products, customers, regions)
FactResellerSales
Reseller orders (who's selling what)
DimCustomer
Customer details (names, income, location)
DimProduct
Product info (bikes, prices)
FactProductInventory
Stock movements (in and out)
FactFinance
Budgets and expenses
DimPromotion
Promo details (discounts, campaigns)
FactSalesQuota
Employee sales targets
DimGeography
Customer and sales locations
DimDate
Time trends for analysis
Load Your Test Tools (DCA)
The DCA is where you set up your sandbox:
Add the Schema
Load or check the AdventureWorks schema (in this case already done by the Enola team)
Try It Now
Paste the Online Sales query in the DCA as shown in the screenshot above and run it. Start your journey with real AdventureWorks data!
Start Your Test-Drive
Log In
Zoom to the Enola platform and sign in using the credentials shared by the Enola team. Credentials not working? Reach out to the Enola support team.
Check the Product
Three key spots to look at:
- Data Catalogue Agent (DCA): Your workshop for loading schemas (in this case already uploaded by the Enola team) and most used sql queries.
- Chat Section: Your chat buddy for asking questions and building analysis plans.
- APA Section: A place where all the analysis plans get accumulated
Chat with Enola: Test the Magic
Enola's analysis approach is rooted in our proprietary BADIR™ framework, which puts your business goals at the forefront of all initiatives.
For instance, imagine you ask Enola, "What's our best-selling bike?"
Enola will respond by asking for the clarifications it needs to finalize the Business Question. Some of these clarifications could be:
- Are you looking for the best-selling bike by total units sold, or by revenue?
- Should we consider sales across all regions, or focus on a specific market?
- Are we interested in a particular time period, like the last quarter or year-to-date?
- Who are the affected stakeholders?
- What metric will define success?
Based on your answers, Enola will then generate a structured Analysis Plan including:
Hypothesis
e.g., "The Road-650 is the best-selling bike by revenue in North America for the last quarter, likely due to a recent marketing campaign."
Analysis Goal
e.g., "Identify the top 3 revenue-generating bikes in North America for Q2 2024 to inform targeted marketing strategies."
Methodology
e.g., "Analyze FactInternetSales and FactResellerSales tables, filter by DimGeography (North America), DimDate (Q2 2024), join with DimProduct for product names, and aggregate sales by revenue."
Enola will then perform the analysis and present the final insights, helping you apply the 80-20 Rule (which suggests that roughly 80% of effects come from 20% of causes) by focusing on the "vital few" products or regions that drive the most significant impact.
Questions to Test Enola's Power
Play with these questions in the Chat Section to see what Enola can do:
"What's the hottest bike by region?"
"Are high earners buying more?"
"Are we low on popular bikes?"
"Do discounts boost sales?"
"Who's the sales champ?"
"Where bikes shine most?"
Ready to Explore?
With Enola, you're just getting started. Rev up and explore the data universe! 🚀