Explore OAS Self-Service Analytics

Instructor: Hurix Digital

What you'll learn

Data prep creates analytical value—joins, cleansing, and calculated fields decide whether dashboards inform decisions or mislead.
AI shifts analysts from chart builders to insight curators—tools like Explain and BI Ask speed discovery, but human judgement remains key.
AI-assisted exploration shifts the analyst's role from chart-builder to insight curator — features like Explain and BI Ask accelerate discovery, but
Reusable data assets compound value—datasets, data flows, and dashboards scale impact far beyond a single report.

Skills you'll gain

Details to know

Shareable certificate

Add to your LinkedIn profile

Assessments

6 assignments¹

AI Graded see disclaimer

Taught in English

See how employees at top companies are mastering in-demand skills

Learn more about Coursera for Business

logos of Petrobras, TATA, Danone, Capgemini, P&G and L'Oreal

There are 3 modules in this course

What if you could turn a raw Excel budget file into a boardroom-ready dashboard within a few hours – no SQL required? This short course was created to help business intelligence professionals accomplish end-to-end self-service analytics in Oracle Analytics Server. By completing this course, you'll be able to connect governed data (subject areas curated by IT or data teams), enrich it through no-code data flows, and publish interactive dashboards your stakeholders can actually use. By the end of this course, you will be able to:

Connect to Subject Areas and upload local files to create reusable data sets Cleanse, join, and enrich datasets using no-code Data Flows Build interactive dashboards using data visualisation, Explain, and BI Ask This course is unique because it leverages OAS's AI-driven Explain and natural-language BI Ask features. To succeed, you should have basic spreadsheet skills and familiarity with data concepts such as joins, measures, and dimensions.

You will connect Oracle Analytics Server to a governed Finance Subject Area, upload a local Excel budget file, and save both as reusable data sets that will be used in later modules for data preparation and dashboard creation.

What's included

1 video1 reading2 assignments

1 videoTotal 2 minutes

From Spreadsheet to Governed Data: Why Self-Service Starts with Connection2 minutes

1 readingTotal 10 minutes

Step-by-Step: Connecting to a Subject Area and Uploading a Local File in OAS10 minutes

2 assignmentsTotal 21 minutes

Create Your First OAS Data Set: Connect a Subject Area and Upload a Local File15 minutes
Knowledge Check: OAS Data Connections and Reusable Data Sets Aligned Learning Outcome: Apply Oracle Analytics Server to connect to governed Subject Areas or upload local files and create reusable data sets6 minutes

You will use the OAS Data Flow canvas to cleanse, join, and enrich the Finance Subject Area and Excel budget data sets, producing a single enriched output data set that will be used in the next module for dashboard creation.

What's included

2 videos1 reading2 assignments

2 videosTotal 5 minutes

How to Prevent Silent Data Loss in Oracle Analytics Server2 minutes
Building a No-Code Data Flow to Produce a Cleansed, Joined Data Set3 minutes

1 readingTotal 8 minutes

Data Flows in OAS: Cleansing, Joining, and Enriching Explained8 minutes

2 assignmentsTotal 21 minutes

Build a Data Flow: Cleanse, Join, and Enrich Your Budget Data Set 15 minutes
Knowledge Check: No-Code Data Flows in OAS6 minutes

You will build an interactive OAS dashboard using Data Visualization, run Explain to surface automated profit insights, use BI Ask for natural language querying, and publish the completed dashboard to a shared folder for stakeholder access, ensuring the insights presented are validated, interpretable, and aligned with business context.

What's included

2 videos1 reading2 assignments

2 videosTotal 9 minutes

Data Visualization, Explain, and BI Ask: OAS's Insight-Generation Features5 minutes
Building an Interactive Dashboard and Surfacing Insights with Explain and BI Ask4 minutes