Thursday, March 1, 2007

Is your data working for you, or are you working for your data?

Is your data working for you, or are you working for your data?


If you’re in the financial market you are making decisions on the performance of others. Whether it is the performance of companies, past and present, or the performance of individual facilities; in the end, you are making your decision on the performance of values… of numbers. You are making decisions on the performance of your data.

So, you have your reports in front of you, and you are taking scope of your positions. You’re ready to make your next move, but how do you know your data is correct? How current is it? Are they today’s prices and notional values… are they yesterday’s… or are they from last week? When you’re trying to find the direction you’re going to next then you need to know where you’ve been… and, more importantly, you need to know where you currently are.

You have your staff gathering data all the time. Maybe they are making calls to banks, a research service or even checking on the internet for their spreadsheet numbers. This might be working fine. However, how many hours of the day are going to collecting data, rather than analyzing it?

Automate your data. Harvesting your needed numbers via a bank or research service feed frees up time, and in turn allows your team to increase their processing productivity. Furthermore, the fresh data allows you a fresh perspective while reducing your risk with a factual base that it provides.

Using a web based application you can start the process of automating your data collection. Limiting the scope of where your data is coming from, while sharpening its provability.

Reconcile your data. If you have your staff running around trying to grab the latest figures then someone is bound to make a mistake once in awhile. Even banks make mistakes, and one incorrect price can throw off all your metrics. Nothing can frighten an investor more than having a question answered with the wrong information. You and your investors both need to feel secure in the data’s basis.

Using a web based application data can be gathered from more than one source and analyzed for discrepancies. Any discrepancies found against the numbers you have with what is being viewed can be reported without having your staff comparing spreadsheets line by line. These exception reports give you the opportunity to reconcile your data. These reports give you the opportunity to trust your data and grow.

Store your data. Save yesterday’s data to understand the context of what is happening today. Data with a historical perspective is data with worth. Historical data gives you the context in which you can run analytics that provide you a view of opportunities that may exist today.

Using a web based application to store your data allows for speed in report generating. It lets you compare from one day to the next, from one quarter to the next and so on. Track changes in markets and in your system, and gain security from knowing and seeing what, when and how a change occurred.

Make your data work for you. Take yesterday and today’s knowledge and turn it into a gain.

Clevertech provides cutting edge custom web application solutions that leverage database technologies and combined with our own experts who have a knack at organizing client data. Call us to schedule an appointment to discuss your data needs at 516-869-4970.

Wednesday, February 21, 2007

Excel Dashboard

Are you using an Excel Dashboard today?

I have seen some very sophisticated designs using Excel to create dashboards that summarize a great deal of information. It is highly customizable and in the right hands can create beautiful reports.

I have also seen the panic when the excel expert is sick or is no longer with the firm and other analysts are pouring over hundreds of and hundreds of formulas, cells, and sometimes vba code to try and piece together a report for an urgent presentation.

A few other drawbacks for Excel Dashboards are:
  • Only one user can change and update an Excel Dashboard at a time
  • With a printed version, you never know if you have the latest Dashboard in your hand
  • Not consistent from file to file. This is especially true when you have one dashboard per investment.
  • Hard to make broad changes across all files
If these are issues that you are facing, perhaps a web based dashboard with an underlying database structure would be the right solution for you.

Benefits of Web Based Dashboards

In a web based system, any number of people can view the dashboard in a secure fashion. You can even give different levels of access to different classes of users.

It's also very easy to get the latest dashboard with simply a browser. You might be on a business trip in Europe, at home in Connecticut, or on vacation in Cancun. By logging in to your web based dashboard, you have the latest information at your fingertips.

Reporting becomes much easier when all the information is in one database. New additions, changes and reconciliations are within reach. Your data becomes more reliable. You will see fewer emails with 'one more update' being sent out to the team.

Excel still has its purposes in environments that are not uniform and each dashboard must be totally unique.

If you are facing some of the issues we outline here and would like to explore web based dashboards, give us a call.

Clevertech provides cutting edge custom web application solutions that leverage database technologies and combined with our own experts who have a knack at organizing client data. Call us to schedule an appointment to discuss your data needs at 516-869-4970.

Thursday, February 8, 2007

Discover data gold in your reports

You're growing quickly. Your time is short. And you know that by organizing your data, you have the best chance to continue your growth in a controlled fashion.

As a successful manager, you have reports today that give you most of the information you need. It's not just luck that makes you a success. The reports you use today have the critical elements that you track.

Reporting Gold

But how long does it take to create those reports? Perhaps you ask for reports once a month as part of a major effort on the part of your staff. And the staff is always telling you how long everything takes and that they need more help in getting in done.

Put all the important reports together and make a list of the critical items they have. Add wish list items that would be helpful to your business. Perhaps reports the auditors like you to run when they show up. A few measures that you'd like to see for each investment. Trigger events that would bring the most urgent issues to the top.

Maybe you have a few reports that you correlate together. A master report that gives you a snapshot of the business. Perhaps it's an opportunity report that allows you to focus on the leads that are most profitable.

This exercise allows you to mark your goals. The real critical elements that need to be managed. You are creating a focus that defines the organization principles you want to follow in your business.

The focus can be adjusted, added to, and even changed. But without a process that reviews your focal point, powerful data organization can not begin.

Client Example

The key analyst report was an Excel "dashboard" that tracked dozens of data points on their company's balance sheet, income statement, cash flow and other financial measures. Each investment could have different data points that were important.

The key management report was an Excel snapshot of all the investments, and most critically the interest rate charged per investment and therefore the interest earned and associated risk factors.

Creating a organizational structure to manage the analyst report is very different than the structure to manage the management report.

We choose to move from Excel and create multiple related structures in a SQL database. The top structure were the data elements that related to the management reports.

Under the management data structures we were able to create a complex data structure for the analyst report which will be a subject of a future post. The critical point is that the structures were linked. And this means reports can pull from BOTH the analyst report and the management report to create new and nuanced analysis.

Just as an example, it is now possible to create a risk factor triggers that is based on an accounts receivable calculation that will only show in the management report next to the monthly revenue if the trigger is tripped.

Clevertech provides cutting edge custom web application solutions that leverage database technologies and combined with our own experts who have a knack at organizing client data. Call us to schedule an appointment to discuss your data needs at 516-869-4970.

Thursday, February 1, 2007

To answer simple questions, you need good organization

If you are managing complex financial data as a hedge fund, asset manager, or any number of structured finance products, you want to have certain simple questions answered quickly and at any time.

Perhaps it's an investor calling who is concerned about your exposure to an industry, or to a particular name.

"What's your exposure across all your investments to X ?"

Simple question. Now how are you organized to be able to answer that question?

The standard response would be - let me get back to you and then you turn to your team to dig into their excel spreadsheets to figure it out.

Excel is a great tool. It is my favorite solution as a flexible scalpel that allows for powerful calculations of data.

However, if you want to organize your data across multiple investments that do not lend themselves to a simple chart, a database product would be a better tool. And if you want to have multiple staff access it at the same time while allowing management to run reports that answer the simple questions instantaneously, a web based database application makes the most sense.

With a web based application, you would be able to give your investors access to certain details so they can answer the questions themselves.

This type of data empowerment makes simple questions that are essential to your business - easy to answer.

To empower your data, you have to organize it well. Our next article discusses how to organize your data in a way that makes your investors go "wow".

Clevertech provides cutting edge custom web application solutions that leverage database technologies and combined with our own experts who have a knack at organizing client data. Call us to schedule an appointment to discuss your data needs at 516-869-4970.