Synchronize Your Analytics with Date-Driven Enrichments in Oracle Analytics
Enhancing datasets with meaningful context is crucial for insightful analytics. One of the powerful ways to achieve this in Oracle Analytics is by leveraging Custom Knowledge with date keys. This article describes how you can effortlessly incorporate relevant business-specific time frames—like fiscal periods, holidays, or even weather data—directly into your analytics workflow.
Imagine you're working with sales data but need to analyze it using your company's fiscal calendar instead of the standard Gregorian calendar. Previously, you'd have to manually map these dates—a cumbersome and error-prone process. But with Custom Knowledge in Oracle Analytics, you can seamlessly integrate your unique date-based information and enrich datasets automatically.
Let's dive right in. This example uses a fiscal calendar that runs from June 1 to May 31.
For detailed instructions on how to create Custom Knowledge in Oracle Analytics, see the documentation.
Once the Custom Knowledge with date keys is created, these attributes become instantly available as enrichment recommendations across datasets and workbooks. Oracle Analytics automatically recognizes these date keys during dataset profiling, significantly simplifying your workflow.
Next, let’s see how Custom Knowledge enriches a dataset. The process is to create a dataset with the file or database table of your choosing, for instance "Video Game Sales." This dataset contains two important date columns: Order Date and Ship Date.
Because our Fiscal Calendar custom knowledge was previously defined, Oracle Analytics automatically identifies and matches these date columns during semantic profiling. It immediately suggests enrichments based on our Custom Knowledge set, such as Fiscal Year, Quarter, and Month, without additional configuration.
The Recommendation Engine kicks in, presenting the Custom Knowledge enrichments for easy integration:
These enrichments now align seamlessly with our original dataset, significantly reducing manual setup and ensuring accuracy.
Now comes the exciting part—building a visualization. When you create a workbook based on your enriched dataset, you'll notice the newly added fiscal calendar attributes also appear as real time enrichments for each date.
To create a quick and insightful visualization using the enrichments:
In mere seconds, you have a clear, intuitive visualization that breaks down sales performance by fiscal quarters and years. No manual date transformations or complex calculations are required!
Beyond fiscal calendars, Date Key enrichments unlock a wide array of analytical possibilities:
The ability to use date keys within Custom Knowledge is more than a convenience; it’s a significant step toward intuitive and insightful analytics. By effortlessly integrating your business-specific contexts directly into your data workflows, you can spend more time analyzing insights rather than wrangling dates.
Oracle Analytics continues to streamline complex tasks, empowering analysts and business users alike. Go ahead and give Custom Knowledge with Date Keys a try; we're confident you'll see immediate value.
Happy analyzing!
Previous Post
Next Post