One of the most common criticism to financial planning and forecasting is : What is the point of prepare extensive and detail plans if you know you will be going to miss it. This reason drives the frustration of analyst where they spend more time explaining differences, than analyzing new opportunities and the business … More Planning as Learning
What … If, is a method for performing a sensitivity Analysis, base on the questions What would be the outputs if the inputs of the model assume different values. This type of analysis, use existing input data for estimate outputs data points, this will give you a range of probable outcomes. This approahc is really helpfull when when data is … More What …. If?
MS Excel is the standard tool for financial and project budgeting modeling, is the greatest and versatile tool ever invented for business, and my respect for that. But when the business has many dimension like Cost Centers, Business Units, Products, Accounts, etc. the tables become big really big with a lot rows and columns and the … More Plain Tables vs Cubes
The primary information for Data analysis is obvious data, if that data is normalized and available is the best way to start. If you want to explore some options to play arround with some data sets here are some sources of Commodity Data: Pink Sheets (World Bank): http://www.worldbank.org/en/research/commodity-markets IMF Primary Commodity Prices http://www.imf.org/external/np/res/commod/index.aspx Quandl https://www.quandl.com/
Coursera is a venture-Backed, for-profit company that use educational technology with the goal to offer massive online open courses. The following 5 Cousres are usesfull for a professional that seeks to some skill for manage data, financial model, bussiness analysis and Problem Solving. … More 5 Coursera Of Data Science and Financial Modeling
When you developed a model, one of the best practice to implement is define a color convention to apply to different objects. For example for manual inputs I use color yellow, for objects or cells that contains the logic itself like calculations I use light blue, and outputs of the model I use light grey. … More Model Best Practice (MBP): Colors convention
Nowadays presentations of graphics data are being made every minute in almost every presentation. These graphics are used to present result and conclusion cause are easy to explain and understand than tables and bold figures, but the design of this graphics are key for the impact that produce in the audience. Analyst tend to be … More Graphics Matter!!
Historically the standard tool for calculations and analysis is the spreadsheet especially MS Excel (other options OpenOffice, Numbers, Google Docs, etc. Excel is king by far), these tools have a paradigm of calculations based on tables of two dimensions. Over time they have added functions to generate estimates of cubes but are not very effective … More Power of Cubes
I always liked the numbers, as a kid I remember I loved to watch the NBA with all the statistics and records leading journalists, then grew up to study economics and business where numbers started to have another taste, are key for decision making. I think the DDDM (Data-Driven Decision Management) is one of the … More Starting Point