BI != Reporting. BI platforms enable users to build applications that help organizations learn and understand their business. Gartner defines a BI platform as a software platform that delivers the following 12 capabilities: Integration BI infrastructure — All tools in the platform should use the same security, metadata, administration, portal integration, object model and query … Read more
I reviewed multiple Bi stacks while on a path to get off of Business Objects. A lot of my comments are preference. Both tool sets are excellent. Some things are how I prefer chocolate fudge brownie ice cream over plain chocolate. Pentaho has some really smart guys working with them but Microsoft has been on … Read more
If anyone is interested: Ctrl+Alt+D combo helped me.
In Data Warehouse Modeling, a star schema and a snowflake schema consists of Fact and Dimension tables. Fact Table: It contains all the primary keys of the dimension and associated facts or measures(is a property on which calculations can be made) like quantity sold, amount sold and average sales. Dimension Tables: Dimension tables provides descriptive … Read more