Tuesday, October 6, 2009

Exam is in 3 weeks and 2 days

Exam is in 3 weeks and 2 days... time to freak out .. argggggggh!!!!!!!!!!!

Sunday, October 4, 2009

Looks like the email entry works

Looks like the email entry works... too bad from my hotmail account it throws in the footer at the end. Apparently i'm pimping singles in my area...nice!

Today has been spent going through past exams. I love the exam format, choose 4 our of 11 possible questions. It means i can focus on areas i am passionate about , rather than flunking out because i blanked out a subject area.  Found myself alittle angry today whilst reading a quote from bill gates 'the speed of thought'. Apparently 'most organisations do not have enough data to understand key aspects of their business well enough'. The way i read that statement is that billy boy is really selling copies of sql server than anything else? You need to store more data, buy SQL server and a whole heap more servers. Business don't need more data, they are knee deep in it. What they need is more focused information. No software is going to help that. Maybe Ackoff, Kaplan and Norton should have a chat with him. 


Let us find your next place for you! Need a place to rent, buy or share?

test blog

Apparently, you can send blogs entries via email... let see if this works... testing 123... 123

Click Here View photos of singles in your area

Saturday, October 3, 2009

Stupid Error messages

Whislt I won't name names because anyone can read this forum . I have come to dread the stupid error messages that are reported by BI reporting suite X. I won't write the actual error messages, because its too easy to right click and google it (or to BING it if you have been drinking). The error message, 'You do not have the right to conduct this query' sent me on a 2 hour quest to figure out what i broke and how to mend it. Turns out there is a default setting which you need to un check to allow you to perform pretty simple and routine operation. Does this restrictive default setting help anyone. Short answer, No . It doesn't increase security, encourage more elegant solutions, or avoid catraspohe. God only knows why its there in the first place. When i asked a consultant who worked for this particular software vendor, his response was vague and didn't actually respond to the question. Maybe its there to help consultants ?

R.L. Ackoff

At the tail end of the assignment and putting everything together and tied it hopefully with some sound theory. Its interesting, that at work , if i put a reference to a research paper i probably would have been asked to remove it . Maybe that is the culture at my current work place or a reflection of the sector i work in ? As i start digesting the readings, i found one of the most intersting articles by Ackoff. This article was written in the 1960's and reflects the issues still faced by the industry . Im not sure if this demonstrates how little the industry has progressed or how insightful ackoff was. Might spend today reading up on the guy

The Balance of processing

Should something be processes on the fly or precompiled when the star schema is loaded with data (the ETL process)? Its all a matter of timing ,stability and data storage . Obviously if you precompile something, it has to be stored somewhere and this can be restricted by how much storage capacity is available. Conversely if everything is calculated on the fly, this can dramatically deteriate the performance of a report. For this assignment there are too many unknowns. How fast are their servers ? How much data storage is available ? Anticipated volumes of data ? Who knows !

These decisions are something that I would make implicitly but I guess this project has really galvanized my train of though on the matter. Some are applicable to the assign, while

Rules of Thumb.

  • If something will only need to be processed once and it will not change , its best done during the ETL load. A good example is age category. Assuming there is a standardised category 18-24, 25-34, etc.why process this again and again on the fly?
  • If something is likely to be altered, changed, or there are dozens of ways to calculated it. Do it on the fly. Eg Percentage of late Sales. If this is done at the ETL level, this would need to be recalculated for every region or state.
  • If a report is standardized and isn't likely to change, create an aggregate table (select net_proceeds from sales_fact group by region). By creating aggregating a table, the load of processing data on the presentation layer can be significantly reduced. This only is applicable if data storage is not an issue and the volume of data being calculated is large.