Hacker News new | ask | show | jobs
by viraptor 3953 days ago
> Imagine what we could do just with a version of office where every bit of information was sourced live from a database, where instead of Power Point presentations of status you could throw together a dashboard and send it to everyone in the organization.

The thing is... you can. Not a presentation / PP, but if you want to create a self-updating dashboard, you can do it in Excel. It's not going to be super easy, but you can do pretty much all of it by clicking.

Here's excel with a sheet that comes from sql database. It's trivial to add another sheet with just graphs on it. https://support.office.com/en-ie/article/Connect-to-a-SQL-Se...

But if you want to do a "dashboard proper", you can use the Power BI tool: https://support.powerbi.com/knowledgebase/articles/471664 (which looks super amazing by the way for an office product, is free, and I want to have a reason to actually use it...)

It's strange that they didn't even mention those possibilities in the post. I see how they could try to improve a lot in those approaches however.

1 comments

In fact, Power Views stored on SharePoint can be embedded into PowerPoint from my understanding. ... which unfortunately complicates things, but yeah.