Analytics Blogs

Handling Hard Deletes from the Source System

Dealing with data can feel like walking a tightrope—maintaining accuracy and consistency while avoiding unnecessary losses is a challenge every organization faces. When working with real-time data systems, the way you handle deleted data often determines the integrity and usability of your datasets. This post dives deep into hard and soft deletes, the challenges of…

Read More

SQL Security Audit Logs in Azure Log Analytics Workspace

In today’s digital landscape, safeguarding data and maintaining regulatory compliance are paramount. Azure SQL Database stands out as a robust solution, with its comprehensive logging capabilities playing a crucial role. At the forefront are its Audit Logs—indispensable tools that not only ensure adherence to regulatory standards but also act as vigilant sentinels against potential security…

Read More

Connecting to Oracle Database (Cloud) and Oracle EBS in Power BI Desktop

Integrating your Oracle Cloud Database and Oracle E-Business Suite with Microsoft Power BI can be a daunting task, especially when dealing with complex data structures and security protocols. However, this connection is crucial for Database Administrators and IT Professionals looking to leverage the powerful analytics and visualization capabilities of Power BI. In this comprehensive how-to…

Read More

How to handle blank visuals in Microsoft Power BI

Microsoft Power BI is a powerful data visualization tool, used to make coherent and structured visuals out of your company’s data. Apps Associates Data & Analytics practice specializes in using this tool to make our customers’ data work for them. We work collaboratively with our customers to create the best solution for their data visualization…

Read More

Implementing As-of-Date and Combining Two Data Slicers in Power BI

In a recently concluded project involving migration of Oracle Business Intelligence Enterprise Edition (OBIEE) reports to Power BI, the Apps Associates team faced the challenge of dynamically selecting dates through a slicer. OBIEE has functionality which can dynamically display or show dates, whereas Power BI does not have this feature readily available. This blog will…

Read More

How to connect Amazon Redshift to Oracle

Part 3 of 3 in the series How to Develop Analytics Leveraging Data in Multiple Cloud Platforms This is part three of a three-part blog series describing how to develop analytics leveraging data in multiple cloud platforms. In part one, we covered the basis of multi-cloud analytics structure and how to use Oracle Analytics Cloud…

Read More

Connectivity & Security Setup in a Multi-Cloud Environment

Part 2 of 3 in the series How to Develop Analytics Leveraging Data in Multiple Cloud Platforms In part 1 of this series about how to develop analytics leveraging data in multiple Cloud platforms  I showed how to use Oracle Analytics Cloud (OAC) to connect to Amazon Redshift and Oracle Autonomous Data Warehouse (ADW) to…

Read More

How to Develop Analytics Leveraging Data in Multiple Cloud Platforms

Part – 1: Data Model with Sample Analysis Multi-cloud is a strategy where an organization leverages two or more cloud computing platforms to perform various tasks. A multi-cloud strategy allows stakeholders to pick and choose the specific solutions that work best for their organization. Organizations that do not want to depend on a single cloud…

Read More

Extend your Oracle ERP Footprint with Oracle EPM

We hear it from customers all of the time. I have Oracle ERP (Enterprise Resource Planning), so why do I need Oracle EPM (Enterprise Performance Management)? I’m here to share with you why extending your Oracle ERP footprint with Oracle EPM has a stronger impact on your bottom line and overall company performance. EPM Empowers…

Read More