Use Case Pattern For A Spread Mart
A spread-mart is used by individual teams or individual departments or groups and is intentionally limited in scope because it focuses on a clearly defined subset of data contained withing spreadsheets. Spreadsheets were never designed to be a secure, robust, data sharing or collaboration tool. Therefore, spread-marts create all sorts of problems for users. Fortunately, Autonomous Database makes it easy to move spread-marts to a safe, secure always-on cloud...
Data Warehouse Use Case Patterns
Pattern For Replacing Spread-Marts
Using spreadsheets for business critical functions is a disaster waiting to happen!
Almost every organization utilizes spreadsheets to disseminate and report on data. A far better solution is to have a single source of truth stored in a fully secured database with a browser-based app that everyone can use to maintain the data.
Stage 1 - SOURCE
Spreadsheet Files
Spreadsheets are so easy to create - anyone can put together a spreadsheet once they have the data. This is why spreadsheets are everywhere inside every organization. Once created they often send it out to colleagues to help update, and so forth.
This inevitably leads to numerous copies with different data and very flawed business processes. A far better solution is to have a single source of truth stored in a fully secured database with a browser-based app that everyone can use to maintain the data.
Get more information...
- For a general overview of reasons to switch from spreadsheets to ADW-based spreadmart - click here
- Watch a video that explains how to sign-up for a free Autonomous Data Warehouse trial account - click here.
- Sign-up for your free Autonomous Data Warehouse trial account - click here.
- Learn more about Oracle Application Express within Autonomous Data Warehouse - click here
Stage 2 - CREATE
Oracle Autonomous Database
Oracle Autonomous Data Warehouse provides an easy-to-use, fully autonomous database that scales elastically, delivers fast query performance and requires no database administration.
Fully-managed cloud service that makes it very simple to provision a data warehouse, quickly and easily load data and query that data using built-in web-based tools such as notebooks.
Get more information...
- Watch this video to hosted by Oracle SVP Çetin Özbütün to get an overview of Oracle Autonomous Data Warehouse and understand how it offers automated "load and go" management and tuning, high performance, and instant elasticity, click here
- Learn more about what is an Autonomous Data Warehouse, click here
- Watch this tutorial to learn more about getting started and provisioning your first Autonomous Data Warehouse click here
Stage 3 - LOAD and DESIGN
Oracle Application Express
The easiest way to load spreadsheet data into Autonomous Data Warehouse is to use the file import wizard in Oracle Application Express. This then gives you the option to create an interactive report over that data.
Once the spreadsheet data has been loaded then that dataset can be shared with and accessed by any other BI reporting tool such as Oracle Analytics Desktop and Oracle Analytics Cloud.
Get more information...
- Watch this video to learn more about Oracle's zero code development environment - Application Express, click here
- Load spreadsheet data from a file as comma separated (*.csv) or tab delimited file using APEX, click here
- Load spreadsheet data using cut and paste with APEX, click here
Stage 4 - SECURE
Data Safe
Oracle Data Safe helps organizations to accelerate Cloud adoption, achieve data privacy and compliance by discovering, classifying, and masking sensitive data. It also helps them establish IT internal controls for their database infrastructure in the cloud. Audit information is consolidated from multiple sources and alerts/reports are generated to meet security and regulatory requirements.
Get more information...
- For a general overview of Data Safe - click here
- To learn how to enable Oracle Data Safe in a region of your tenancy - click here
- For more information about the key concepts and terminology - click here
- For more information about registering ADW with Data Safe - click here
Stage 5 - MAKING DATA SMARTER
Oracle Machine Learning
Oracle Machine Learning is a collaborative web-based interface that provides a development environment to create data mining notebooks where you can perform data analytics, data discovery and data visualizations.
Key features of Oracle Machine Learning:
- Allows collaboration among data scientists, developers, business users
- Leverages the scalability and performance of Oracle Platform and its Cloud Services
Get more information...
- Learn more about Machine Learning Notebooks click here
- Become a data scientist in 6 weeks click here
- Quickstart Tutorial: Creating and Running Notebooks in Oracle Machine Learning click here
- Get more information about the example notebook template for nine of the most popular ML algorithms click here