Business Intelligence

Question 1

BI

Answer 1

Business Intelligence

Question 2

BA

Answer 2

Business Analytics

Question 3

What is the difference in BI and BA?

Answer 3

Business Intelligence involves taking a thorough look at past, present and historic operations and collecting data

Business Analytics is about using the data to identify the current challenges and predicting future hardships and gearing business towards better productivity and a more stable future.

Question 4

Cloud Data Warehouse

Answer 4

a database stored as a managed service in a public cloud and optimized for scalable BI and analytics

Question 5

Four examples of Cloud Data Wearhouse vendors

Answer 5

Amazon RedShift, Snowflake, Google Big Query, or PostgreSQL

Question 6

What is SQL

Answer 6

Structured Query Language. A language used to communicate with a database.

Question 7

ETL

Answer 7

Extract, Transform and Load. ETL is a technology that automatically routes various streams of data into a one place for analysis.

Question 8

Predictive Analytics

Answer 8

Predictive analytics encompasses a variety of statistical techniques from data mining, predictive modelling, and machine learning that analyze current and historical facts to make predictions about future or otherwise unknown events.

How to ask a Buyer - Are you looing for the ability to find patterns and trends within the data?

Question 9

OLAP

Answer 9

• online analytical processing is a computing method that enables users to easily and selectively extract and query data in order to analyze it from different points of view.

How we ask buyers? - Are you looking for the ability to “dig in” and “slice and dice” the data

Question 10

Embedded analytics

Answer 10

Embedded analytics is the integration of analytical capabilities and data visualizations into another software application

Question 11

What two questions must we ask if someone wants Embedded Analytics?

Answer 11

1. What is the use case for the embedded? How is this going to be embedded?
2. Are you considering using amazon web services (AWS) to host the applications?

Question 12

Admin vs Basic Users

Answer 12

Admin- People creating reports and pulling data

Basic- People just viewing reports

Question 13

Cloud Budget

Answer 13

Cloud at min $10K-$20k first year and scales up to six figures plus

Question 14

On Premise Budget

Answer 14

On-premise at min $40k for licenses, setup, training + Additional fees of ~15% for annual maintenance and updates

Question 15

What must we say if user count is above 100 EMPS

Answer 15

100+ users screen for avg prices of $100k+