Avik Dutta, Author at Perficient Blogs
Blog

Posts by this Author

  • Topics
  • Industries
  • Partners

Explore

Topics

Industries

Partners

Avik Dutta

Avik is working as a Solutions Architect in Oracle BI practice in Perficient Inc. in Colorado, United States. His primary role is to lead, design & implement end to end BI projects: starting from estimation, requirement gathering, hardware sizing, design, development, testing phase, go-live, support, user training and finally handover. Avik's experience includes managing and leading small to moderate sized teams focusing primarily into OBIEE/OBIA. Avik has ~ 10.5 years of experience in DWBI domain with industry knowledge in Healthcare, Recruitment, Retail, Pharmaceutical, Education, Telecommunications, Media and Entertainment, Tours and Travels, Shipyard Constructions, Financial Services and Health Insurance. Avik has worked in different modules such as Finance, HR, Supply Chain Management, Projects, Procurement & Spend, Sales and Marketing, Student Analytics etc. In these years Avik has worked extensively in OBIA (7964 and 11g) - OBIEE (12c, OAC, BICS, 11g, 10g), BI Publisher (10g, 11g, 12c), SAP BO 4.0, BO XIR2, CR XI, SSRS 2008R2 and in PL/SQL as well. Other than these Avik has working knowledge of Informatica, ODI 11g and IBM Datastage as well.

Posts by this author:

Oracle BI vs Tableau vs Microsoft BI

Introduction OBIEE: Oracle Business Intelligence Enterprise Edition Plus, also termed as theOBI EE Plus, is Oracle Corporation’s set of business intelligence tools consisting of former Siebel Systems business intelligence and Hyperion Solutions business intelligence offerings. Tableau: Tableau Software is a software that produces interactive data visualization products focused on business intelligence. MSBI (SSRS): This powerful suite is […]

Read more

Configuring Windows Services for OBIEE 11g

Introduction When Oracle Business Intelligence is started, few services will start. These are Node Manager, Admin Server, Managed Server. Starting all these services require manual effort. So these components will start once the server is restarted by a Developer or Admin person. To overcome this dependency on manual intervention, all the OBIEE services are created […]

Read more

OBIEE 12.2.1.2.0 Installation and Configuration (Win 2012R2)

System Requirements The system requirements for Oracle BI Applications installation: Oracle Fusion Middleware requires a minimum 1-GHz CPU Windows minimum physical memory required – 4 GB. Windows minimum available memory required – 8 GB. Additional System Requirements and Supported Platforms for Oracle Business Intelligence EE Release 12.2.1 can be found in Oracle Fusion Middleware 12c (12.2.1.0.0) […]

Read more

OBIEE Design and Development Best Practices

Introduction This document is for Oracle Business Intelligence Enterprise Edition (OBIEE) Developers and Designers. These standard guidelines may vary from project to project. Below mentioned OBIEE Standards are more in generic form & developers can follow these guidelines to standardize their code & minimize post development defects.   Repository – Physical Layer best practices Database […]

Read more

OBIEE 11g Portal Customization

In order to best deliver an intuitive and interactive end-user experience, architecture and UI elements have been redesigned from the ground-up in Oracle Business Intelligence Enterprise Edition 11g Release (Oracle BIEE). The 11g UI is dynamically generated using scripts which makes it highly customizable as per client’s needs and standards. This blog post illustrates the […]

Read more

OBIEE 11g – Deployment of Custom Skins and Styles

Introduction OBIEE has a set of styles and skins to make the displaying of data visually appealing. This gives the user the ability to select styles as per their need. Generally, in OBIEE 12c, the default UI Skin and Style is called ‘Alta’. In 11g, it is ‘blafp’. Customers most often want to see their organization’s […]

Read more

Configure OBIEE Cache Purge with Event Polling Table

Introduction An event polling table (S_NQ_EPT) is a way to identify for the Oracle BI Server that one or more physical tables have been updated. Each row that is added to an event table highlights a single update on a single table. The cache system reads from this table, extracts the information from these rows, […]

Read more

OBIEE Automated Cache Purge Using ODI

The OBIEE BI Server cache is the most effective way of improving response times of OBIEE dashboards followed by database modifications and tuning. Using data present in the cache limits the load on the database considerably. It is also effective for improving network, BI server and dashboard performance for obvious reasons. However, after a certain […]

Read more

OBIEE 12c Security: LDAP Authentication and DB Authorization

OBIEE 12c by default uses WebLogic internal user directory for security purposes. This is effective only when the number of the users is very limited and is not expected to grow much over the years. But, in a real world business scenario, almost all implementations require configuring a more robust way to implement authentication and […]

Read more

Usage Tracking – OBIEE 12c

Usage tracking in OBIEE 12c is very similar to that in 11g, which enables mainly administrative users to track all reports being run and queries fired to the database. It is also very helpful in identifying and analyzing objects that require better query performance. The configuration steps will be mentioned in this blog as well as […]

Read more

Configuring and Integrating Google Maps into OBIEE 11g

Introduction: When Oracle Business Intelligence is installed, functionality for users to see maps that display data is also installed. Before users can see maps in analyses and dashboards, one must understand the system requirements, specify layers and maps, and configure the metadata. This post will explain the steps to configure mapping and spatial information for […]

Read more

Multi-User Development Set Up Using OBIEE Administration Tool

Introduction Multi-user development (MUD) provides a mechanism for concurrent development on overlapping code bases. Oracle Business Intelligence provides a MUD environment that manages subsets of metadata, in addition to multiple users, by providing a built-in versioning system for repository development. By default, the Oracle BI repository development environment is not set up for multiple users. […]

Read more

Oracle Business Intelligence Out of Place Upgrade – 11g to 12c

In this post, I deliver an in-depth look at the steps to upgrade OBIEE 11g to OBIEE 12c in a separate environment. So that means it is an out-of-place upgrade of OBIEE from 11g to 12c. I did this upgrade for an American worldwide financial services client. Following are the details for the upgrade process […]

Read more

Subscribe to the Weekly Blog Digest:

Sign Up