tag:blogger.com,1999:blog-6411920579549337139.post6207364788554439316..comments2023-12-31T05:26:17.608-08:00Comments on DATABASE DEBUNKINGS: The Trouble with Data Warehouse AnalyticsFabian Pascalhttp://www.blogger.com/profile/01346669716885494092noreply@blogger.comBlogger1125tag:blogger.com,1999:blog-6411920579549337139.post-3772920185701100242017-03-24T21:54:10.000-07:002017-03-24T21:54:10.000-07:00Today people have problem understandig science (ba...Today people have problem understandig science (based on mathematics - logic, sets) and some srbitrary concepts that are based on someone's authority or 'industry standard' devoid of any logical framewor. (Hello Object oriented and data warehousing ;-) )<br /><br />Data Warehousing 'science' suffers from lack of logic. It contradicts itself: it is supposed to be used for ad hoc querying, yet it requires aggregation and assumption about intended use. It is built for 'speed' yet cube queries take hours to execute - no kidding - this is from a Microsoft sponsored course. Data cleaning is the most laughable requirement - isn't data already clean if it comes from a relational database? What is the purpose of keeping data somewhere if it is not clean? I it was not clean at the moment of entry into database/file/spreadsheet, how are we going to clean i? Connecting data from heterogeneous sources. Like SQL databases, Access files, Excel tables and Word documents? Thank you, but no thank you. Analytic for business? Good luck with present skill level of executives and decision makers. Since executives are not capable doing simplest things in spreadsheets, we must invent mambo-jumbo arbitrary concepts, and make it look serious and scientific, to keep our jobs? Again, thank you but no thank you.Anonymousnoreply@blogger.com