increase alpha
  • Home
  • Services
    • Data Strategy
    • Data Visualization
    • Planning & Forecasting
    • Performance Management
    • Data Mining
    • Data Warehousing
    • Project Management
    • Change Management
    • Virtual CDO
    • M & A Advisory
  • Products
    • Alpha Wolf Trader
    • Campaign Analytics
    • Analytics Assessment
    • Data Assessment
  • Client Success
    • Investment Banking
    • Media
    • Pharmaceuticals
    • Defense
    • information
    • M&A Integration
  • About Us
    • Thought Leadership
    • Testimonials
    • Our Team
    • Blog
    • Contact Us
  • Clients

Our Insights

Who donates the most to our politicians?

8/31/2019

1 Comment

 
Picture
As we enter another political cycle with the inevitable bombardment of ads, I wanted to know who was really influencing what we see and hear. In the USA this data is available for all of us to examine. However, actually taking the time to examine it is not something everyone can do, so I thought it might be helpful to start applying my skills to disseminate this information.  


This is my first post of a series that I am developing that will attempt to show the flow of money into and out of our political system. All of the data has been sourced from FEC.gov and has not been manipulated in any way.  


The visualizations I have created show individual contributions of $1,000,000 and more. Donors can be either individuals or entities, the recipients are PACs. 


What I found interesting is that extremely large donations occur for both parties and that there are a few individuals and families who donate enormous amounts.   Take a look and let me know what you would like to see next! Follow me to see more, I plan on posting several times a week as I have A LOT OF DATA! 

​Click here for the interactive visual.


1 Comment

Are you an influencer?

8/31/2019

0 Comments

 
Picture
We all know that social media can be an extremely cost effective method of marketing.  However, in order for it to be effective, its critical to find those that truly have influence over the issues that you are promoting.  That's where social network diagrams like the one below play a critical role.  Being able to quickly visualize your network and then identify those that have the most influence will enable you to reach out to them with targeted messages that they are likely to respond to.  Static images are not sufficient for this analysis, its critical to be able to interact with the data and try different visuals.  This image shows the last 50 tweets for hashtag#Election2020.  Notice the two dots highlighted in red, these are the key influencers with significant reach.

​Do you know who your influencers are?
0 Comments

Where does the money go?

8/26/2019

0 Comments

 
Picture
Creating visualizations of relationships within data sets can be challenging for even the most experienced data scientist.  One great tool is the Sankey diagram that shows the strengths of relationships between multiple parties.  Building on the Campaign Finance Data set I created, this diagram shows the flow of funds between political entities in 2018.  To keep the diagram as simple as possible, this shows transactions of $1MM or more.  


I intentionally did not label the recipients of the funds to avoid any heated discussions.  However, its fairly clear that some groups are the true influencers of others but remain hidden from public view.  By understanding the true flow of money through the system we can identify who the real power players are.
​


 What do you think will happen during this cycle?
0 Comments

How hard is it to beat a sitting senator?

8/19/2019

0 Comments

 
Picture
If we could bet on politics an extremely safe one would be betting that incumbent Senators would win re-election.  According to OpenSecrets, since 1964 the average re-election rate for the Senate has been higher than 82%.  That's a safe bet.


Why? Incumbents have a massive advantage in fundraising over their challengers.  The analysis below shows that in 2018, outside of a few high profile races, the incumbent had raised substantially more than their challenger.  However, there is hope in that in 3 of the 5 biggest races (Florida, Indiana, and Nevada) the challenger had raised more than the incumbent and won the seat.  Of particular interest was Arizona where the seat was open and the amount of funds raised were approximately equal between the two parties.

Want to interact with the data? Click here.


0 Comments

It's month end +13,what's the new forecast?

4/29/2019

0 Comments

 
Another month end means another round of the same questions. What went well, what went badly and what does that mean going forward? In most organizations all of the effort is spent on answering the first set of questions – the ones about what happened. Precious little time is spent answering or even attempting to answer the last one – what does the future look like? Obviously, it’s critically important to know and accurately record performance from both a practical and regulatory perspective. But that is not sufficient, especially in today’s highly complex, rapidly changing and constantly evolving marketplace. Companies cannot operate on autopilot and must adapt their tactics to meet challenges wherever they arise and take advantage of opportunities when they appear.
​
Senior executives are aware of this and it is why they are asking for forecasts with more frequency and with more detail. They expect that the books will be closed properly and accurately, but they want to know what decisions need to be made going forward and what the impact of these decisions will be. They are also keenly aware that the existing management tools are woefully inadequate in solving this problem.
0 Comments

How far can you see into the future?

4/25/2019

0 Comments

 
Think about the title of this post for just a moment.  How far into the future can you really see?  Do you know what is going to happen next month, next week, tomorrow or even one minute from now?  At an elemental level, it is impossible to know what the future will bring, there may be a natural disaster, political upheaval, or economic calamity all of which are out of your control.  You have more control on an individual level in that you can be fairly certain that with the proper precautions you will arrive at work safely, conduct business, return home safely, go to sleep and repeat again tomorrow.  The closer the event the more certain we become of it materializing the way that we had expected.

The same rules apply in our professional lives.  As the month draws closer to close, we become more certain  of the accuracy of our predictions for sales, operating expense, profits, etc.  The question is how far into the future can you see and be comfortable with the likelihood of results materializing the way that you have forecasted.  Is it one week, one month, one year or more?  What are the driving forces behind that timeline and how can we alter it?  For most organizations, the forecast horizon is dependent on the industry in which you operate and the level of volatility and change that industry is experiencing.  This volatility can come from internal or external factors and can be minor or extreme.  However, it is the industry that has the greatest impact on the forecast horizon as it dictates the business cycle.  For example, if your business is manufacturing capital intensive products with long lead times such as construction equipment, aircraft or defense it is likely that you operate on very long lead times for design, sales and contracts.  Due to the size and lengths of the contracts it allows for longer planning horizons for material purchases, staffing and financing.  However, if you are in social media or other nascent industries where the rules, players and technologies are changing on an ongoing basis, it makes it very difficult to take a long term view with any certainty.  It would not be wise to enter into long term contracts when the short term is unknown.

Volatility in both cases can come from within the industry or externally.  Two key competitors may merge resulting in a situation where the new entity has pricing power and increased economies of scale in terms of production.  Or a major vendor may declare bankruptcy leading to severe issues with your supply chain.  Technology advances may diminish or neutralize your competitive advantage.  Government regulations may make your market position untenable.  In short, almost anything can happen to any organization at any time.
​
Darwin stated that it was not the strongest or the smartest organisms that survived, it was the ones that were most able to adapt to their changing conditions.  In order to thrive and survive in a constantly changing world, organizations need to understand how far they can see into the future with a reasonable degree of certainty and have the skills to deal with the inevitable change as it occurs.  Those that are able to adapt will thrive while those who can not will be  relegated to the footnotes of history.
0 Comments

7pm during budget season

4/22/2019

0 Comments

 
It’s 7 pm midweek in the middle of budget season and if you are like most finance executives you either are in or are about to enter Excel hell! After months of creating budget input templates, instructions and timelines you know that there will still be groups and individuals who have modified the template – making consolidation nearly impossible, others that refuse to follow the guidelines and the rest who ignore your timelines. You know that you will spend the vast majority of time repairing workbooks or chasing people down for missing data.

You know that this time would be better spent identifying markets or products that show real performance potential or areas for material cost savings! Sadly, you will spend most of your time reconciling and validating workbooks so that the numbers are at least correct before you see the CFO.

You know you won’t have time to do the part of your job that you truly enjoy and that adds the most value to your organization. All the while, you will be wondering if there is a better way – a way to consolidate all this information simply, effectively and cheaply so that you can get back to the business of business. 

There is a better way! Fortunately, there are a number of tools available on the market today. They range from simple Excel add-ins to full-featured stand-alone systems. However, this can create a different kind of hell – one where you are still faced with all of the business complexities at your existing budget process buy compounded by inflexible MIS policies and procedures. Implemented poorly, these systems can make Excel hell look like Excel heaven!

So what is one to do?
  • Tread carefully
  • Take a long-term view
  • Measure twice, cut once

​We can help you throughout your journey from vendor selection and proof of concept to resources and architecting your custom solution. Contact us for further information on how to get started.
0 Comments

Cut your budget creation time by 30%

4/15/2019

0 Comments

 
When do you start your budgeting process? How long does it take your firm to complete it? Is it really meaningful after all of that effort? More and more companies are grappling with these questions, especially in light of the constantly changing business conditions.

When the economic climate can swing wildly month over month and natural disasters on the opposite side of the world disrupt supply chains and financial markets, using an outdated process as the primary management tool for allocating resources ceases to make sense. It is now a management necessity to have more flexible and adaptable methods that allow resources to be redeployed and realistic scenarios to be built. These methods include embedding forecasting into the fabric of a firm, focusing on the key operational drivers of the business and developing financial models based on these drivers to make the data accessible to those who need it, when they need it.

However, as nirvana-like as this situation may sounds, it’s not realistic to expect to achieve that in the short-term or without some substantial change for your organization. What is more realistic is to create a long-term road map that embraces a series of interlaced and incremental changes. The first of these changes could – and some even say should – involve deploying a formal budgeting tool to replace the Excel spreadsheets that are the default standard in most firms. Simply replacing the manual Excel consolidation process with an automated tool can provide a number of benefits simultaneously:
  • Substantial time savings both your central finance team and your field staff by eliminating the confusion and wasted effort of manually consolidating workbooks
  • Fewer errors
  • Time for deep analysis and recommendation formulation
  • Shortened cycles
Each of these benefits is substantial and the success can be leveraged in later releases and process changes. Studies have shown that simply putting in a formal tool can save over 30% in cycle time for creating the budget.
0 Comments

What about the budget?

4/8/2019

0 Comments

 
In the last blog post I defined a rolling forecast and demonstrated how it could be used to improve an organization’s decision making process to allow it to become more nimble and agile. I also rose the question of what should be done with the annual budget. I’d like to take a moment now to provide my thoughts on why the annual budget remains a valuable management tool and why organizations should not be too quick to abandon it.

Much has been written and said on what is wrong with the budget in its current form at most organizations. In summary, the budget:
  • Takes too long
  • Is too detailed
  • Is out of date before it is completed
  • Is too rigid
  • Promotes poor spending habits
  • Is disconnected from strategy
  • Is focused on the wrong time horizon
  • Is tied to compensation promoting poor behavior

With such a long list of issues, it is no surprise that many recommend abandoning the budget altogether. However, I caution against this approach, since the budget still has value for an organization if it is done correctly and is supplemented with tools that address its short comings, such as a rolling forecast.

The bible on budgeting was written almost 90 years ago by the founder of the consulting firm McKinsey & Co, James O. McKinsey. He articulated very clearly how a budget should be created and the value that the budget offers an organization. Though much has changed, many of these values are still applicable today including:
  • Organization wide buy-in and commitment – A budget is an excellent tool to ensure that every level of the organization has a voice in how its plans are created and conducted.
  • Scalability – By providing a guide on how resources should be deployed, a budget allows an organization to scale by not requiring executive level input of many small but critical decisions.
  • Training and managerial development – The ability to develop and execute effective plans is a skill that is learned over time. It is not realistic to think that mangers who have never been tasked to develop plans will magically become planning experts when they are promoted and tasked with developing a plan or forecast.

In addition, the budget is a process that has developed over time and as such it is also not realistic to think that it can be suddenly switched off. To retire a process that is often ingrained in an organization’s DNA takes time and careful planning, not to mention that a new process must be developed and accepted by the organization to take its place.
​
Instead of taking this approach, I recommend that a rolling forecast be used to supplement the annual budgeting process. A rolling forecast, by its very design, is much more nimble and allows for an organization to make decisions and create plans very rapidly. It addresses the core issues and criticisms of the annual budget by being created and managed at a higher level, allows for underlying assumptions to be updated, focuses on the core business drivers and forces an organization to continually plan forward and not to the end of the fiscal or calendar year. In short, the rolling forecast and annual budget when used together effectively, can allow an organization to create accurate long term plans as well as focus on short term execution simultaneously. In today’s rapidly changing world, both skills are critical to ensure success.
0 Comments

What is a rolling forecast?

4/1/2019

0 Comments

 
The first question we almost always get asked by our clients is, “What exactly is a rolling forecast?”

Most people and companies have some form of forecasting in place already to update their full year projections. “Isn’t a rolling forecast just a matter of adding a month or two or three at the end of the budget and lopping off the same number of months from the beginning?” Technically, yes, in its most primordial form, that is all it is. However, since the only tool available to most companies that would enable this is the budget, simply shifting the company’s timelines would result in organizations developing, updating and maintaining detailed budgets on a continuous basis throughout the year. Most would agree that this is not sustainable (if not downright frightening!) and the result is that it will fall by the wayside. The problem is that without taking into consideration all of the other valid and useful purposes the budget serves, this method is not likely to be sustainable. What is missed is the organization’s opportunity to become more dynamic and nimble, one that uses its forecasting processes as a true competitive advantage to achieve superior results.

We’ve seen several definitions, but we believe a rolling forecast is:
  • A process that continually adapts to changing business conditions
  • Designed to enable business decisions to be made by focusing on key drivers and levers
  • Comprised of a fixed number of forecast periods determined by how far into the future a firm can reasonably see
  • A rapid process that is completed in a day or less

We believe that a rolling forecast is NOT:
  • The budget plus x months
  • A mathematical exercise
  • Completed at the chart of accounts level
  • Focused on the calendar or fiscal year

A rolling forecast typically has a fixed number of forecast periods. The number of periods is dependent on several factors including the industry, business cycle, product life cycle, etc.

A typical forecast that only updates the budget is focused on achieving the goals for that fiscal year. The total number of periods evaluated is constant but the number of forecast periods is reduced by one period each time. The focus is typically on executing the plans that were made in the budget, regardless if the underlying assumptions are still valid. Instead of looking beyond the year, it stops suddenly in December as if business will not be conducted in January. In short, it follows an arbitrary cycle that does not align with the natural course of business. Thus, what could have been a valuable exercise becomes nothing more than a variance explanation and results in missed opportunities.

​The second question we get from our clients is, “If we adopt a rolling forecast, should we kill the budget?” The short answer is no; the long answer will come in our next entry where we demonstrate how a rolling forecast and the budget work together to enable the true execution of corporate strategy.
0 Comments

    Author

    Sid Ghatak is the Chief Data Officer at Increase Alpha and lives at the intersection of the customer, business, and technology.  Email him at sid.ghatak@increasealpha.com or follow him on Twitter to get insights on your world.

    Archives

    August 2019
    April 2019

    Categories

    All

    RSS Feed

Contact us today to learn more

Submit

Telephone

212-603-9757

Email

info@increasealpha.com
  • Home
  • Services
    • Data Strategy
    • Data Visualization
    • Planning & Forecasting
    • Performance Management
    • Data Mining
    • Data Warehousing
    • Project Management
    • Change Management
    • Virtual CDO
    • M & A Advisory
  • Products
    • Alpha Wolf Trader
    • Campaign Analytics
    • Analytics Assessment
    • Data Assessment
  • Client Success
    • Investment Banking
    • Media
    • Pharmaceuticals
    • Defense
    • information
    • M&A Integration
  • About Us
    • Thought Leadership
    • Testimonials
    • Our Team
    • Blog
    • Contact Us
  • Clients