Blog: Dan E. LinstedtMarch 18, 2008New Skills Required - Interactive BIDo you still think that knowing flash and actionscript is not a newly required skill? Have you seen the latest version of Crystal Reports from BO? It now contains a front-end product that used to be called Excelsius, which is a flash-based front-end BI dashboard library. You can drag and drop buttons, charts, pre-built reports, and other things on to the different scenes in the dashboard. No more flipping pages, and writing PHP code or Java code to exercise BI on the client side. It's a highly protected environment. Continue reading "New Skills Required - Interactive BI" » August 14, 2007Appliances for Business Intelligence and Data WarehousingThere's a movement afoot in the appliance world. Appliances are growing up. They are getting faster, smaller, cheaper, and yes: more specialized. I had it in my mind that the appliance market would combine on a single platform, and provide common plug & play hardware interfaces, well that just doesn't seem to be the case (maybe in the future, but then again maybe not). In this entry we will explore the different classes of appliances that are available, and what they do. We will also take a look at where they may go within the next 12 to 18 months. Continue reading "Appliances for Business Intelligence and Data Warehousing" » April 8, 2007SQLServer2005 and SSIS, Part 2I've read a recent comment in another blog about my original posting on SQLServer2005 and SSIS. I've also been talking with Microsoft on their product line, and improvements that are on the way. While I can't disclose what Microsoft is working on, I can talk about the type of experiment that I'm writing about, and why I staged it the way I did. Continue reading "SQLServer2005 and SSIS, Part 2" » March 21, 2007Microsoft SSIS and SQLServer2005An interesting thing happened on the way to the data bank.... Well, I just couldn't help myself. This is a discussion on performance, notions of derivations, product improvements and directions in SQLServer2005, and some annotations on SSIS and where it has gone, where it needs to go, and so forth. Please remember, this is for 35 Million row tables on a 1 CPU-2GB RAM-1 Disk I/O Channel laptop, so it's the bare-minimum. I'd hope to see exponential (or at least linear) performance gains by going to a larger machine (but this doesn't happen either). Continue reading "Microsoft SSIS and SQLServer2005" » March 1, 2007Open and Closed Appliances - Thought ExperimentI've recently been sharing my experiences with Appliances, and where I think the market will be going. I've gotten some great feedback from a few of you out there (thank-you kindly). In this entry I will explore the notion of what might make an appliance fizzle out, and what might make an appliance continue to be useful moving forward. We will play with the notions of open appliances versus closed appliances, what it means, and where it goes - along with the notions of just what software might be good for or not good for shipping on a hardware basis. Continue reading "Open and Closed Appliances - Thought Experiment" » December 12, 2006IBM - DB2 UDB 9.x - hot new technologyIBM is coming to the table with their RDBMS systems, finally making waves with their MPP options (labeled as DPF - data partitioning format), and multiple nodes. From a performance side of the house, scalability, and MPP are finally here. Not to mention new true XML interfaces, embedded XML within the RDBMS systems. Continue reading "IBM - DB2 UDB 9.x - hot new technology" » October 19, 2006Oracle and Sunopsis - my Technical Half CentEveryone's blogged on this and quite a few more have offered their two cents on the topic. After reading about all of this, I figured maybe my voice could add a half-cent value to the noise out there. This is my opinion of what this acquisition means, and what Oracle really needs to do to solve their ailing sales issues in the EDW / ADW space. I recently wrote an article on Bill's newsletter about Oracle and Clustering that explains this core issue in a round-about manner. This entry is more direct. Continue reading "Oracle and Sunopsis - my Technical Half Cent" » September 13, 2006Hot new Open Source ETL/BI productsIf you haven't heard of them already, you should! These guys are hot in the market space. They are open source ETL, ELT, BI, Dashboards, and Analytics. Two awesome companies that should be checked out. One is Pentaho, and the other is Bread-Board BI. For low-cost solutions, these guys are hot. There are major institutions out there currently examining the use of tools like these. for prime-time. Apparently I'm not the only one to notice. Pentaho grabs $8M in funding according to Computer Business Review Online. Shawn Rogers had a post back in July referencing these two vendors. Continue reading "Hot new Open Source ETL/BI products" » June 22, 2006Hot Tool, Hot Product, Hotter ProspectsReduce your development time, understand your data set and it's relationships in a visual format, accomplish all of this, and profile part of the data while your at it. You've heard of social networking on the web? If you've used Linked-In, or Plaxo, or another contact tool, you've seen some of the "social network diagrams" they produce. Well, now a company has gone and done something similar but with Source System data. Continue reading "Hot Tool, Hot Product, Hotter Prospects" » April 28, 2006Meta Integration and CapabilitiesIf you haven't heard of this company, and you're looking for Master Metadata Management, you'll want to check them out. They are a privately held firm based in Silicon Valley, and are OEM'ing their core technology to just about every major vendor out there. That said, they do sell their complete package with all kinds of cool features for a reasonable cost. The business reasons to use their software? Read on - let's try to shed some light on this... Continue reading "Meta Integration and Capabilities" » April 26, 2006SQLServer2005 and Integration ServicesI recently had the chance to work with the Beta program of SQLServer2005, and Integration services. Let me tell you, it was amazing. There are several highlights in the technology that I'd like to share. This entry will go through these items. There are only a couple of things that I'd like to see improved. My basic thoughts are: this will give customers who are tight on budget, or not moving huge volumes per load-cycle, an opportunity to really begin building out a true data warehousing/BI solution. Continue reading "SQLServer2005 and Integration Services" » April 15, 2006Welcome to BI VendorsThis is a new category for me, typically I don't focus on "vendor specific" items, but in this category I will begin doing so. I may blog on Microsoft SQLServer2005 and it's intelligence services, or Teradata, Netezza, DatAllegro, Ipedo, MetaMatrix, Oracle, DB2 UDB, IBM Ascential, IBM Websphere or any number of other vendors that I think are doing something interesting in the market space as it pertains to Business Intelligence. All entries here will be vendor specific. Feel free to send me questions about specific vendors. Thank-you! Hope to see you out here. |