Tag Archives: Credit Risk Analysis online course

Credit Risk Managers Make Use of Big Data like Never Before

Credit-Risk-Managers-Make-Use-of-Big-Data-like-Never-Before

The post depression bedlam is clearing for developed nations. Nevertheless, the household debts are shooting up, making credit risk managers face growing default rates. As per the reports of International Finance, household debts have risen by USD 7.7 trillion since the year 2007 till 2015. At present, the debts stand at a whopping amount of USD 44 trillion – the figures can give anyone a nightmare!

2

In such a topsy-turvy situation, credit risk managers should look for ingenious methods to lower default rates and keep accuracy in check. Application of data analytics infused with Big Data can come to their rescue.

The term Big Data is really very big! Big Data can help draw crucial insights that would help financial institutions in analyzing their customer base and how their purchase decision patterns vary. It can also be used to enhance business results, especially in regard to credit risk management.

If you follow the current business news, in the coming three years, banks would be facing two major risks – Credit and Liquidity.  However, if credit risk managers follow the below-mentioned ways, they can turn this complication into an opportunity:

  1. Data Analytics determines a person’s behavior and how his circumstances have changed. This is verified by his social media activity, which further affirms how his financial position has changed with time. Hence, the chances of fraud and non-repayment are put in check.
  2. With proper analysis of mobile and social media data, credit risk managers may be able to gather insights and broaden their market horizon, enhancing the market base.
  3. Data science can establish contact with low risk customers.

button(2)

Enroll in a credit risk analysis course in Gurgaon offered by DexLab Analytics. Enhance your digital skills today and ace up your career dreams!


Advertisements

How to Connect Oracle BI Server with Tableau

How-to-Connect-Oracle-BI-Server-with-Tableau

Here, we will discuss about how to incorporate Oracle BI server and make use of the existing Subject Areas built on RPD in Tableau desktop workbook as Data Source.

NOTE: This is applicable for 8.2, 8.3, 9.0 and later versions.

Firstly, to launch an ODBC connection with the Oracle BI Server to access RPD Online, you have to install a copy of Oracle Business Intelligence Developer Client Tools (available from the Oracle website). Following, you can use the same DSN to connect to Tableau through ODBC connections.

2

As soon as you are done with installing the client, carry out the following steps to create a database source name (DSN):

  1. Follow the steps mentioned below to add a new system DSN for Oracle BI Server ODBC in the ODBC Administrator tool..
  • Go to the System DSN tab and click Add
  • Choose the Oracle BI Server DSN, among other available drivers

    1

    1. Give correct connection details and connect to BI Server

      2

      3. Save the System DSN
      In total, there are 3 levels in RPD:

      • Physical Layer (right pane) – This is the layer where a connection is established between each data source and the raw tables are disclosed. Joins across tables are performed here.
      • Business Layer (middle pane) – This is where logical relations, data modelling and hierarchy development are implemented.
      • Presentation Layer (left pane) – This is the layer exposed to the business through “subject areas”. The subject areas are clearly modelled to display data in the most easy-to-understand format.

      Under Tableau, tables in the presentation layer are adjoined as data sources, only.

      3

      Locate the Key Fields in Dimensions and Fact Table in Physical Layer of RPD and disclose the same to respective Presentation Tables in Presentation Layer of Sample Sales Lite Subject Area.

      4
      Create a “.tdc” file

      Create a Tableau data source customization (.tdc) file to connect Tableau Desktop to an Oracle BI server.

      1. Open a text editor; copy and paste the below code onto it:

      <connection-customization class=’genericodbc’ enabled=’true’ version=’9.3′><vendor name=’Oracle Business Intelligence’ />
      <driver name=’Oracle BI Server 1′ />
      <customizations>
      <customization name=’CAP_SET_ISOLATION_LEVEL_VIA_ODBC_API’ value=’no’ />
      <customization name=’CAP_SUPPRESS_DISCOVERY_QUERIES’ value=’no’ />
      <customization name=’SQL_CATALOG_USAGE’ value=’0′ />
      <customization name=’SQL_SCHEMA_USAGE’ value=’0′ />
      <customization name=’CAP_FAST_METADATA’ value=’yes’ />
      </customizations>
      </connection-customization>

      Nota bene: Version is crucial; adjust the version with that of your Tableau desktop version. In my case, it is 9.3.

      read full story

      Recently, credit risk analysis course in Noida is attracting a lot of attention. If you are looking for an exhaustive credit risk analysis course in Delhi, log into DexLab Analytics. You will surely get what you need!

      4

%d bloggers like this: