Thursday, December 5, 2013
How To Choose The Best Business Intelligence Solution For Microsoft Dynamics AX
Business Intelligence for dynamics ax - Is The Best Solution question asked daily by thousands of users and their partners a lot of dynamics ax ax '. No answer to this question because it really depends on many factors such as the size of the company, do not use this kind of tool Bi, the choice of platforms such as SQL Server or Oracle and more. When there is no doubt, Business Intelligence Solutions without the underlying data warehouse dedicated to the problem, at least in the long run. Some of your choices are: 1. Build your own data warehouse and Business Intelligence Solutions with Microsoft BIDS2. Use the embedded Business Intelligence in Microsoft dynamics AX3. Buy pre-packaged customized Business Intelligence Solutions AX4 dynamics. Buy drag and drop the data warehouse tool that automatically generates SQL code and also build your OLAP cube and select the tool choice.A Evaluation few comments on four options: Microsoft Bid (Business Intelligence Development Studio) is an efficient development environment for SQL Server experts to create a SQL Server data warehouse-based OLAP cube. So if you have experts at home and want to spend time and money, it is an option, but be aware of the complexity of the offer, the time required to create solutions Bi experts and dependence, both on your own company or externally.Microsoft dynamics ax offers components such as pre-packaged Bi OLAP cube for different modules ax. But be aware that they are not based on real data warehouse means that any integration of external data sources or changes in the size / size / KPI is possible, but more complicated and require expert. It is generally not a good idea to include Business Intelligence in ERP. Many common Business Intelligence Solutions dynamics around, like zap, iQ4bis, Profitbase, strength, QlikView, Targit and more. All of them have their advantages to implement a BI solution for relatively fast dynamics. The only reservation I have to say, they also do not offer true as the basis of data warehouse technology to try to use the compatibility tool front-end or both. The difference in price for these tools varies from $ 15,000 to $ 100,000 + In my opinion, the option 4 from the list above will give you the best results and maximum flexibility. Not a lot of tools around that helps you create flexible and independent ERP data warehouse and OLAP cube made of little effort and excellent front-end agnostic. Why not start with the technology used to SQL Server, Excel and SharePoint and then see the Analytics tool.