对仪表板/数据库报告软件的建议
我们正在寻找一个可以让我们分析数据的报告套件。我不确定此类套件的确切术语，但它们通常被称为“仪表板软件”或“数据库报告”，
示例如下： Wonder Graphs
我们正在寻找一款能够与我们的 MySQL 数据库集成的套件，并为我们提供：
- “实时”图形界面（图形、图表），用于查看自动更新的数据
- 能够使用这些图表进行“深入分析”以查看更多具体信息。
例如，如果图表显示总销售额，我们希望能够单击该图表并显示有关销售类型的信息。
- 导出到 Excel 的能力
- 易于使用的用户界面，允许非技术用户创建和自定义自己的视图或仪表板。
如果任何人都可以列出他们使用、曾经使用过或知道的好软件，那将是一个很大的帮助。
如果有一个可用的开源示例那就太好了，但我们希望为此类软件付费。
如果我对细节含糊其辞，请告诉我。
提前致谢， 詹姆斯
We are looking for a reporting suite that will allow us to analyse our data. I'm not sure of the exact terminology for such suites but they are often known as 'Dashboard Software' or 'Database Reporting'
An example is: Wonder Graphs
We are looking for a suite that will integrate with our MySQL database and provide us with:
- 'Live' graphical Interfaces (Graphs, Charts) for viewing our data which are automatically updated
- The ability to 'Drill Down' using these charts to see more specific information.
For example if a chart shows total sales, we want to be able to click on that graph and be shown information on type of sales.
- The ability to export to excel
- An easy-to-use user interface that allows non-technical users to create and customise their own views or dashboards.
If anyone can list software they use, have used, or know to be good that would be a great help.
If there is an open-source example available that is great however we are expecting to pay for such software.
Let me know if I have been to vague on details.
Thanks in advance,
James
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（3）
有几件事需要考虑。首先，你有多少数据？ MySQL 并非设计为分析数据库。如果你有“少量”数据，那就没关系。但是，如果您发展或计划发展，您可能需要将数据复制到 Infobright 等分析数据库。 Infobright 确实有一个开源选项。
在数据库之上，您有一些运行良好的开源 BI 解决方案。看看 Pentaho、Jaspersoft 和 Actuate/BIRT。 Actuate 有一些很棒的深入选项，而且他们还可以轻松地将这些数据传输到移动设备。
全面披露：我是 Infobright 的开源人员。
There are a few things to consider. Firstly, how much data do you have? MySQL isn't designed to be an analytics database. If you have a "small amount" of data, then it doesn't matter. However, if you grow or plan to grow, you may want to copy the data over to an analytic database such as Infobright. Infobright does have an open-source option.
On top of the database, you have a few open-source BI solutions that will work very well. Take a look at Pentaho, Jaspersoft, and Actuate/BIRT. Actuate has some great drill down options, and they also have a way to easily get this data to a mobile device.
Full disclosure: I am the open-source guy for Infobright.
在我的研究中，我发现以下网站对于任何关注此主题的人来说似乎都是一个不错的起点：
仪表板洞察
该站点包含一长串可用套件和工具。
In my research I discovered the following site which seems to be a good place to start for anyone looking at this topic:
Dashboard Insight
This site includes a long list of available suites and tools.
我们目前正在使用 Dundas Dashboard，并取得了很大的成功。我非常确定它有一个用于 mySQL 的数据源连接器，您只需安装他们网站上提供的驱动程序即可。
总而言之，这是一个很棒的产品，虽然有一点学习曲线，但我们已经取得了很大的成功。
We're currently using Dundas Dashboard and have had a lot of success with it. I am pretty sure it has a data source connector for mySQL, you just have to install a driver that they have available on their site.
All in all, great product, a little bit of a learning curve, but we've had a lot of success with it.