I am thinking what are the different bi tools around. What will be a good bi tool when implementing navision. Would it be jet? or would qlikview be good? Any information would be useful. Thanks
I really depends on what kind of business intelligence you want. Is it just simple reports? Or do you want online interactive drill downs and lots of fancy features?
Jet Reports is good for the more simple static reports.
You can also use Navision's own Business Analytics, where you can create some really fancy interactive reports.
Another options is also to use Microsoft Excel. Using Excel 2007 you can actually create some very nice and fancy reports with Navision.
We use SQL Reporting Services / BI for all of our reporting. No complaints yet.
We spend 6 months in my previous job and tons of money on a SQL Reporting Services / BI - but even though we had some of the best BI people on the project then it never good good enough so we ended up scrapping the whole project and go with Jet Reports (as a low end solution - but it worked) instead.
I think the key to getting any BI solution to a point that the company likes it is testing and data validation. There's a reason it's called BUSINESS Intelligence. There are plenty of solutions...so as long as as the company isn't expecting a data warehouse to appear from the sky with everything they've ever wanted.
BI is not the same for everyone. Some users only expect a rather simple report, that you could actually just as well do directly from Navision, while other expect the big data warehouse based solution.
The key to success here (as in all projects) is really to make your expectations perfectly clear before you start the project. It's very easy to overcomplicate any project, BI projects are no exception.
But a Reporting Services solution based on a data warehouse (even a simple datawarehouse) is automatically a much bigger and more complex project than a solution "just" based on a report tool like Jet Reports or a solution in MS Excel.
I think I am going ahead with qlikview. It seems to be a easier to use tool to create more dynamic reports than jet. I think there is some limitations about it but i doubt that the current data that we have is going to hit the limitation cap. I just meet up with a sales consultant of nav who told me that qlikview has some limitation for mass deployment but i don't think we will hit the cap and we are far away from the cap whatever cap we have i think there will probably be a workaround solution. Might also be possible to deploy another bi tool for the reports that have such limitation. I believe that qlikview is faster to build and easier to maintain than jet reports. Technologicial advantage will sway to different companies as they develop better methodology to deliver value cheaper and faster.
I think the strong points of Jet Reports are the following :
- The reporting is done in Excel, so it's already a familiar tool for most business user
- It's seamlessly integrated with NAV
- You can refresh your report in real time
Check the video above :
To be honest I don't know QlikView, but I was once invovled in a NAV Installation, where a Qlikview consultant spent 3 weeks designing the datawarehouse required by clickview before being able to write a single report
Would be nice to get the feedback from someones who has both worked with JetReports & QlikView
Business Intelligence cover a lot of areas.
Do you want Reporting & Budgeting/Forecasting. A lot of tools are available to do just the reporting side - but very few options are availabel for write back to the SQL AS database.
Integrated BI should have Monitoring, Analysing and Planning (Microsoft BI). A lot of the reporting is availabel through Reporting Services and 'free' tools. It used to be that Planning was available with Performance Point - but this component was dropped last year - per the MS BI partner site the following tools are listed http://www.microsoft.com/bi/partners/find-a-partner.aspx
Clarity & CALUMO
DATA WAREHOUSE FROM THE SKY?
What if you could have a data warehouse installed and running doing 85-95% of the management reports you ever wanted within 4-5 days - including user training?
What if business users could access the data warehouse through Excel Pivot Tables and even design fantastic reports in Excel and then just push a button to publsih the Excel sheet as a SSRS reports for publication to SharePoint or the web?
What if you could use the data warehouse to audit your NAV database so that you could be sure that the numbers coming out of NAV all reconciled and were 100% accurate and provavble down to the lowest level transaction in NAV?
Click your heels Dorothy and watch your head - here comes that Data Warehouse from the SKY - www.Precision-Point.com Certified for Microsoft Dynamics NAV.