Now this is interesting. I remember searching a few years back for spreadsheet design patterns. That combination of keywords never led me to the Best Practice Modeling Standards upon which BPM – a company founded in 2002 by ex-Salomon Smith Barney investment bankers – provides its modeling products and services. The base version is apparentlyContinue reading “Spreadsheet Design Standards”
You might find the two following posts interesting if you’re dealing with vast amounts of data: Kimball ETL screening Data profiling with T-SQL
Thanks to Dick Kusleika‘s article on EuSpRIG 2007 and after browsing the latter site a bit, I located a couple interesting papers I want to share here. These are full of good high-level tips related to spreadshet design: How do you know your spreadsheet is right? Spreadsheet Modelling Best Practice
If you’ve ever had to extract data from a system that applies layers of senseless formatting, this should have you rolling on the floor laughing in no time.
I’ve wanted to elaborate on this post by Andrew Wiles for a while but it appears this isn’t going to happen anytime soon so I’ll simple refer you to it. Andrew analyzes some of the reasons why financial reporting (and MIS reporting in general) should be handled separately from mainstream IT, and goes on toContinue reading “Collaborating for a better financial reporting infrastructure”
Following up on a somewhat theoretical introductory post related to desktop data management, Here are 7 habits which should prove useful when approaching any desktop data-related task. These will be refined based on the discussion you and I will have here, so let me know what you think. I was actually shooting for 10 commandments,Continue reading “7 habits of effective desktop data management”
The complexity of modern organizations requires their employees to manage an ever-increasing flow of information. Many trends combine to that effect, among which fast growth, under-staffing, inappropriate tools or poor procedures. The purpose of this blog is to create a discussion around all the ways that managing information can be improved from a desktop worker’sContinue reading “Desktop Data Management”
This wasn’t supposed to be the first post here but it’s a good discussion and relates – if somewhat remotely – to what we will be discussing here anyway. 43 Folders has a ongoing discussion about best practices for file naming which is definitely worth your time if you manage any serious amount of files.Continue reading “How to name your files”