Category Archive: Uncategorized

Here Are Your Reasons For Attending India Internet Day of Tie, Delhi-NCR

Around this time every year TiE of New Delhi hosts an important event which should be of interest to IT personnel around the country. The event is known as the India Internet Day, and they have been at it for the past couple of years. But as a data scientist hoping to make it big in the Big Data world with IT giants why should you expend your limited “Paid Leaves” (if you are employed) and attend this event?

Here Are Your Reasons For Attending India Internet Day of Tie, Delhi-NCR

Let DexLab Analytics explain to you why is it necessary for aspiring Data Scientists/Analysts to attend this event:


Get the necessary nudge towards your start-up success!

In India the TiE event of India Internet Day is one of the most happening events for Start-ups, held in Delhi-NCR and North Region.


Prepare For Your Data Science Job Interview With Answers to These Puzzles

You may have passed your data science certification course with flying colours, but getting your first break in an analytical job role can be quite difficult. Did you know that more than 30 percent of top tier analytical firms evaluate and select their candidates on their ability to solving puzzles? After all this is the best way to determine that they are logical, with ample creative thinking abilities and are definitely pros at dealing with numbers (a skill must have for data personnel).


Prepare For Your Data Science Job Interview With Answers to These Puzzles


The companies are keen on hiring people who have the ability to bring a unique perspective in solving business problems. Such individuals are capable of to offer their hiring firms with a huge advantage over other candidates. But to garner such capabilities an individual must practice regularly with consistent efforts.


Tutorial for creating a Speedometer dial in MS Excel

Here in this video tutorial we have discussed in detailed steps, how to create a Speedometer chart in MS Excel. A Speedometer chart is often called as a gauge chart and combines two different type of charts, a pie chart and a doughnut chart.

 Tutorial for creating a Speedometer dial in MS Excel

The Speedometer dial is made with the help of using a Doughnut chart and needle is actually a combination of two types of charts, another doughnut chart and a pie chart.


The Eclectic Mix of Big Data and Marketing

Marketers with even rudimentary knowledge of Big Data are better placed to precisely reach the largest amount of potential target customers than their counterparts who are uninitiated to the world of Big Data. Good marketers know the customers they target very well. Big Data facilitates this process.

The collection of data and its storage into separate data banks is simply a process part in acquiring raw data. This data should be reproduced in such a manner that marketers are able to easily grasp. And with the impending explosion of IoT devices, the amount of data too is expected to increase by leaps and bounds.


Marketers need to analyze the data available to them very carefully. The process involved is a complicated one which requires the use of specialized software tools.


Infographic: How Big Data Analytics Can Help To Boost Company Sales?

Following a massive explosion in the world of data has made the slow paced statisticians into the most in-demand people in the job market right now. But why are all companies whether big or small out for data analysts and scientists?

Companies are collecting data from all possible sources, through PCs, smart phones, RFID sensors,
gaming devices and even automotive sensors. However, just the volume of data is not the main factor that needs to be tackled efficiently, because that is not the only factor that is changing the business environment, but there is the velocity as well as variety of data as well which is increasing at light speed and must be managed with efficacy.

Why data is the new frontier to boost your sales figures?

Earlier the sales personnel were the only people from whom the customers gathered data about the products but today there are various sources from where customers can gather data so people are no longer that heavily reliant on the availability of data.


Regulatory Stress Testing for the US Banks: Dodd-Frank Act Stress Test (DFAST) and Comprehensive Capital Analysis and Review (CCAR)

In the last blog we had discussed, at a very high level, the BASEL accords and their role in the dynamically changing landscape of risk analytics. These accords lay down the basic guidelines to ensure capital adequacy for the banking institutions against both expected and unexpected losses. Both expected and unexpected losses are manifestations of stress situations and testing the stability of a banking model under such adverse situations is indispensable from the regulatory perspective.  With this idea in mind, we discuss the very basic framework of two important regulatory documents on stress testing: Dodd-Frank Act Stress Testing (DFAST) and Comprehensive Capital Analysis and Review (CCAR).

Regulatory Stress Testing for the US Banks

Stress testing is a technique to test the stability of an entity or a system under adverse conditions. Two specific objectives of stress test are: (a) to identify the vulnerabilities in tranquil times and act as an early warning signal (b) to support crisis management and resolution.  Stress testing the financial institutions across the world has become inevitable after the 2008 Financial Crisis. This has been a tool extensively used by the Federal Reserve for evaluating the capital sufficiency of the US banks to absorb losses resulting from the stressful economic and financial market conditions.  The Dodd-Frank Act Stress Test (2010) and Comprehensive Capital Analysis and Review (2011) are two well-known stress testing  regulatory documents for the US Banking sector to comply with.

The Dodd-Frank Act Stress Test (DFAST) is a forward looking quantitative evaluation of the impact of stressful economic and financial market conditions on the capital of the Bank Holding Companies. It requires the Federal Reserve to conduct an annual stress test of large bank holding companies and all non-bank financial companies designated by the Financial Stability Oversight Council (FSOC). Bank Holding companies with total consolidated assets of $50 billion or more and non-bank financial companies designated for supervision by the board are subjected to annual supervisory stress test.  Under this act all financial companies with more than $10 billion in total consolidated assets that are supervised by Primary Federal Financial Regulatory Authority are required to conduct an annual company run stress test and also conduct a mid-cycle stress test under the company developed scenario.

The Comprehensive Capital Analysis Review (CCAR) evaluates a bank holding company’s capital adequacy, capital adequacy process, and planned capital distributions, such as dividend payments and common stock repurchases. As a part of CCAR, the Federal Reserve evaluates whether BHCs have adequate capital to continue operations throughout times of economic and financial market stress and whether they have robust, forward looking capital planning process that account for their unique risks. If the Federal Reserve objects to a BHCs Capital plan, the BHC may not make any capital allocation.  Mid-size and small-size firms need not go for CCAR process, but the large banks must be CCAR compliant. The banks which have participated in CCAR (2015) are: Bank of America, Citigroup, JP Morgan Chase, Wells Fargo, Goldman Sachs, Morgan Stanley, American Express, Bank of New York Mellon etc.

Though DFAST and CCAR may appear to be similar, because they both are supervisory stress test procedures. But, there are two major distinctions between the two: First, DFAST tries to assess the capital adequacy of a bank under adverse economic conditions, given their current dividend and share repurchase plans. CCAR, on the other hand,  tries to analyse the capital adequacy of the banks under adverse economic and market conditions, after taking into account the proposed capital plan of the bank in the next four quarters. Second, CCAR compliance for banks can result in having ‘a capped dividend policy’, if the Federal Reserve gives a ‘no pass’ to them. DFAST does not carry any such implications.

In our follow up blog to this one, we will discuss in details the procedure of regulatory stress testing and the different scenarios in which the stress test is conducted.