Business Intelligence Assistant
The BI assistant is an interactive analytical engine that can help you with data analysis. Users can have conversations with the BI assistant about their business-oriented data. The assistant can handle domain-level analysis. The BI assistant has the capability to display charts along with textual narratives of the data. Alongside the assistant gives details about the measures and dimensions of the data. The data is converted into useful information by this BI assistant.
About the DVD Sales Data
The dataset used as part of this application is modelled on a DVD Store. The DVD Store dataset represents an online e-commerce store that sells DVDs. The list of customers, products and orders are primarily maintained in this dataset while also keeping track of demographics like location and genres, and customer profile data. The data for this dataset has been collected from 2018 till 2021. This dataset has been designed to represent a transactional database model.
Capabilities of the BI assistant
Queries
Queries about Data
Queries with Filters
The BI assistant is designed to use the questions asked by users in natural language to derive insights from the dataset. The questions you ask need to consist of the following that will be processed by the BI assistant for insights.
Description of Filters
| Filter | Description | Possible Values |
|---|---|---|
| Gender | Gender of the customers | M - Male, F - Female |
| Category | Genre of the movie | Action, Animation, Children, Classics, Documentary, Drama, Family, Foreign, Games, Horror, New, SciFi, Sports |
| Country | Country in which the customers are located | Australia, Canada, Chile, China, France, Germany, Japan, Russia, South Africa, United Kingdom, United States of America |
| Age Groups | Ages of customers categorized into groups | 0 to 18 years, 18 to 40 years, 40 to 60 years, 60 to 80 years, 80 years and above |
| Time dimension | Time related filters in the form of years, months and quarters | Years - (2018, 2019, 2020, 2021), Quarters - (Q1, Q2, Q3, Q4), Months - All the 12 months |
| Price Buckets | Product prices grouped into buckets | $0 - $10, $10 - $15, $15 - $20, $20 - $25, $25 - $30 |
Caveats
If the BI assistant does not understand the question,the BI assistant will send the following message
Sorry, I could not understanding the question. Can you rephrase it?
