Posts Tagged ‘analytics’

Four years after the signing of Dodd-Frank, financial services firms have a better understanding of both the challenges and potential benefits for their organization. While financial institutions are starting to get a better grip on Dodd-Frank reforms, one area where regulators are still coming to grips with and finalizing guidelines is incentive compensation. In fact, Section 956 was […]

In the Hadoop space we have a number of terms for the Hadoop File System used for data management. Data Lake is probably the most popular. I have heard it called a Data Refinery as well as some other not so mentionable names. The one that has stuck with me has been is the Data […]

The data warehouse has been a part of the EIM vernacular for nearly 20 years. The vision of the single source of the truth and a single repository for reporting and analysis are two objectives that have resulted in a never-ending journey.   The data warehouse never has had enough data and the quality required for […]

Scenario We want to create a target flat file name with the current system date. Solution 1 The first method is renaming the target file name in the post session command as bellow: Example: The following command will rename the file in the format filename_MMDDYYYY.out in Windows: move $PMTargetFileDir\filename $PMTargetFileDir\filename_%date:~4,2%%date:~7,2%%date:~10%.out

While there are several BI technologies and more coming into the foray every day, SSRS has remained a key player in this area for quite some time now.  One of the biggest advantages of SSRS reporting is that it involves the participation of the end user and that is very intuitive to use. Let’s go […]

Years of work went into building the elusive single version of truth. Despite all the attempts from IT and business, Excel reporting and Access databases were impossible to eliminate. Excel is the number one BI tool in the industry and for the following good reasons : accessibility to the tool, speed and familiarity. Almost all […]

Big Data is on everyone’s mind these days. Creating an analytical environment involving Big Data technologies is exciting and complex. New technology, new ways of looking at the data which is otherwise remained dark or not available. The exciting part of implementing the Big Data solution is to make it a production ready solution. Once […]

  The speed in which we receive information from multiple devices and the ever-changing customer interactions providing new ways of customer experience, creates DATA! Any company that knows how to harness the data and produce actionable information is going to make a big difference to their bottom line. So Why Virtualization? The simple answer is […]

Cloud BI comes in different forms and shapes, ranging from just visualization to full-blown EDW combined with visualization and Predictive Analytics. The truth of the matter is every niche product vendor offers some unique feature which other product suite does not offer. In most case you almost always need more than one suite of BI […]

Out of the mathematical and statistics language and tools such as SAS, SPSS, Matlab, etc. R language is a pretty good tool which provides the environment and essential packages for statistical computing and graphics. It is free and it offers an open environment and the means to allow users to develop custom package. In addition to […]

  Essbase API Overview  Oracle Essbase Provides a solution of EPM (Enterprise Performance Management) that helps end-user analysts across the enterprise in various departments Such as finance, accounting, Sales and marketing to solve complex calculations and perform ad-hoc data query operations . We operate Essbase in a client server environment from custom applications written in […]

Trying to stay ahead of the curve when it comes to IT issues is a challenging task. Emerging technology forces in the financial services industry are already impacting business. The convergence of these forces does present challenges; however, it also provides a window of opportunity for financial institutions to elevate business performance and gain a […]