Finally got a chance to go back to Columbia’s campus yesterday evening and spend some time shooting the cherry tree in bloom at the entrance to Earl Hall. Brought back fond memories.Broadway and Amsterdam. New York, the year 1999. Cherry trees in full blossom, sunny afternoons, and Sundays. That’s how I remember the beginning. Sunday [...]
New York, New York.Saboor Bhai and I go for a drive down memory lane in Manhattan. Figure 1 18 month at 122nd & Broadway. The fondest of memories Figure 2 Warren Hall, the joint Columbia Business, Columbia Law School building Figure 3 Church of St. John Divine on Amsterdam, my all time favorite Figure 4 Newyork Spring. Cherry trees [...]
Data Analysis, Data Tables & Excel. This is our third post in our Data Analysis series using Excel spreadsheets. The series covers correlations, trailing correlations, histograms, pivot charts and data tables. See the following prior posts for data analysis context.Correlations basics Data Analysis. 5 tools in twenty minutes Data Tables introductionThere are many questions that Excel can help [...]
Data Analysis. Using Excel Data Tables for Sensitivity Testing You have built your financial model, now is the time to test it. The objective of stress testing or sensitivity testing is to evaluate your financial model across a range of values. Sometimes we do this to test the model, more often the objective is to present a [...]
I ran the data analysis using Microsoft Excel for activists yesterday afternoon for P@SHA and Sheba Najmi’s Civic Hackathon. Was caught in the act by P@SHA Saira Khan at T2F with P@SHA, T2F, Pring and 70 others attendees as witnesses. Organized on the 6th and 7th April 2013 as a first attempt to use our collective [...]
Yesterday I ran a short twenty minute session for 60 civil activists participating in the city’s first civic hackathon. The topic was data analysis in Excel. Here are my notes from the session.As a data specialist there are few common themes that I keep running across whenever I open up Excel to do real work.Understanding [...]
This morning, as usual, my first task was to sign into my Google Analytics dash board and take a quick peek at my Real Time visitor’s screen for my blog traffic. Imagine my surprise when I see a huge blob in the south of the Atlantic ocean corresponding to no known human habitat (Atlantis?).A quick check [...]
Risk management. Risk systems for Central Banks. If you were tasked to build an ideal risk management system for a central bank, what would you look for? To answer this question you have to ask a different question first.Figure 1 Risk Management. Risk Software – Central BanksIf you are a central bank in Europe, Middle East, [...]
Making risk education richer with images. A 12 month selection from 2012-2013.Compared to our first two years, year three turned out to be much more richer in term of the quality of our content, our images and our graphical presentation.I still vividly remember the it’s just text comment Mark Broadie made when he first saw [...]
Risk jobs – Picking between Credit vs. Market vs. Treasury analysts role Here is how it has played out for the last ten years. I start wrapping up a risk training workshop or an evening class from my executive MBA students and a member of the audience walks up to me in Dubai, Abu Dhabi [...]