BI/Data Engineering Services Provider
Category: Azure
-
Oracle Analytics Server/Cloud (OAS/OAC) – Analyze Data with Explain
I often conduct training on how to upload external data like CSV/Excel files to OAS/OAC and create visualizations. For new users, if they don’t know anything about the dataset and what visualizations to create to start with, I suggest making use of “Analyze Data with Explain” to discover data insights. It’s a useful starting point…
-
OBIEE/OAS/OAC – Dynamic date calculations
Dynamic date calculations like first and last day of current/previous month, current/previous quarter and current/previous year and many other are required for default values in the dashboard prompts as well as in the report filters. I often use below link for the required formulas and decided to share. Oracle Business Intelligence: OBIEE How to use…
-
About me
WHO AM I…I don’t know everything but I know how to use Google, product documentation and other people blog to complete tasks within allocated time. BI Solution Architect, BI Engineer, Data Engineer, BI Consultant, Data Scientist providing innovative BI Solutions fusing cloud and on-premise technologies to achieve organizational reporting and analytics goals. WHAT I DO…With…
-
Access to Azure SQL Database migration
Access database is very user friendly tool to store relational data, devlop forms for data entry and data retrieval and formatted reports. However as the database grows and number of users accessing the database increases, the performance, accessibility and security of the data becomes important. For robust data platorm, consider migrating the access database to…