![]() This is also where I can put my reports and analysis views together for end-user dashboards: I’m using 4.8.2 of the Pentaho suite for this series and so when I log into the portal, I will use the Analysis feature to point to the SQL Server database and auto-generate the OLAP cube as well as design the visualizations. We’re going to stay completely in a thin client browser experience for this demo, so no need to open any IDE tools through this entire workflow. Start by going to to download an evaluation version of the Pentaho Business Analytics suite and run the installer. What I think you’ll really be impressed with is how much easier it is than building cubes in Visual Studio and PPS dashboards. I’m going to kick this series off with a very simple BI dashboard using the traditional SQL Server Adventure Works data warehouse data set and put a Pentaho ROLAP cube and dashboard on top of that data. ![]() We’re going to take this SQL Server 2012 DW and SSAS cube and recreate it all in Pentaho: ![]() If you are like me and have built many BI solutions in SSAS OLAP and PPS, then you’ll find a transition to OSS with Pentaho to be very easy and a natural fit for those BI scenarios. Let’s say you have SQL Server databases for your data marts and warehouses in your organization, but you are looking for alternatives to SSAS cubes and SharePoint-based dashboards. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |