Daniel Havey
Web-based Reporting for Banks

This article will focus on Web-based Reporting for Banks.

CFO DashboardWho cares about web-based reporting for banks? When we think about reporting for banks, we often think about accountants, controllers, and CFO’s.  According to The Wharton School, accounting is considered the language of business.  The story of any company, no matter the size, the industry, or the country of origin, is told through its financial records and reports. Continue reading

Daniel Havey
Business Intelligence (BI) Tools for Banks

This article will focus on BI Tools for Banks.

Image taken from Shutterstock.

Business Intelligence (BI) definitions – TargetTech defines BI as a technology-driven process for analyzing data and presenting actionable information to help corporate executives, business managers and other end users make more informed business decisions. Gartner says that BI is an umbrella term that includes the applications, infrastructure and tools, and best practices that enable access to and analysis of information to improve and optimize decisions and performance. Webopedia says BI represents the tools and systems that play a key role in the strategic planning process within a corporation. These BI systems allow a company to gather, store, access and analyze corporate data to aid in decision-making. The main theme among these various definitions is that BI encompasses tools that help with decision making.  When it comes to banking, there are many use cases for BI.

Continue reading

Daniel Havey
Financial Planning and Analysis (FP&A) Tools for Banks

This article will focus on FP&A Tools for Banks.

Image taken from Shutterstock.

Image taken from Shutterstock.

So what does a FP&A manager do? – Here is a position description for a Manager of Financial Planning and Analysis for a bank in Atlanta.

The FP&A Manager will be a key finance and analysis partner for multiple lines of business within the organization. Duties will include providing support for strategic and tactical planning, understanding financial and operational results, and supporting management decision making. Key responsibilities include:

• Budgeting and Forecasting
• Monthly Analysis
• Business Scenario Planning
• Dashboard Preparation
• Ad hoc Analysis

Let’s take a look at each of these responsibilities in a little more detail.

Continue reading

Daniel Havey
Forecasting Methods for Banks

This article will focus on Forecasting Methods for Banks.

Image taken from Shutterstock.

Image taken from Shutterstock.

 

Have you done this? – According to Nasdaq, the consensus Earnings per Share (EPS) forecast for Bank of America for the years 2017, 2018, and 2019 is $1.73, $2.03, and $2.19 respectively.   How did they come up with these numbers?  If I told you that an analyst for Nasdaq went to the corner fortune teller and asked them to divine the numbers, you would laugh at me.  Or if I told you that they called three different gas stations for their price of gas for their research, you would say that the information was irrelevant. Continue reading

Daniel Havey
Strategic Planning for Banks

This article will focus on Strategic Planning for Banks.

Why I hate the first six weeks of the year – If you have been a member of any gym for more than a year, you will know what I am talking about.  Whether you go to the gym twice a week or all seven days, you have a routine and see the same people.

Then, January 1 hits.  The parking lot is so full that it takes you ten minutes to find a spot.  You enter the gym and there are three times as many people as normal.  What used to take forty-five minutes to finish your routine now takes an hour and a half because every piece of equipment is being used!

What makes it worse is that most of these new people have no idea what they are doing.  You say to yourself, just wait until Valentine’s Day.  Almost all of these newbies will be gone by then and things return to normal.  And how do I know which ones will stay and which ones will leave?

Continue reading

Daniel Havey
Budgeting Tools for Banks

This article will focus on Budgeting tools for Banks.

Photo taken from Shutterstock.

Photo taken from Shutterstock.

The Balanced Scorecard is finally in place, now what? The senior management of the bank came up with twenty-four key performance indicators (KPI’s) that will make up the bank’s balanced scorecard.  Everybody is excited about the new measures and is looking forward to see how they rank.  The first report comes out with a lot of fanfare.  The second report then comes out and nothing changes.  Hmmm.  Everyone thought performance would immediately start to improve.

 

What is missing?  Budget tools for banks!  Now that the bank knows what measures are important to implementing its strategy for success, it needs to come up with a way to set goals and targets for those various measures.  The first step in this process is to come up with a budget.  There are many approaches and tools for budgeting for banks.  This article will help you sift through the myriad budget tools for banks by coming up with a list of requirements.

Continue reading

Matthew Felzke
Data Warehouse Software for Microsoft SQL Server

If you’re like most companies, you rely on multiple data sources, each with different reporting tools to manage company information and analysis processes, but you need to bring together all of that data for richer analytics.  This article will discuss data warehouses as the solution.

Almost all companies of any size are relying on multiple data sources for company information, such as an Enterprise Resource Planning (ERP), Customer Relationship Management (CRM), Payroll, and vertical industry systems, perhaps as well as data sitting in manual spreadsheets.  Even if you have a great accounting system report designer or pre-built online analytical processing (OLAP) cubes as one of your data sources, one of the biggest ways for management to make sound business decisions requires the ability to utilize financial reports and/or dashboards to look across all of your company information.  Unfortunately, each of the data sources or systems typically have their own unique BI tools.  And that’s where a data warehouse comes into the equation, likely solving this prevalent business problem.  This article will discuss the benefits of a data warehouse (DW) as a solution to data management with a Microsoft SQL Server.

Continue reading