Can't talk about Tableau as I haven't used that with Access, but Power BI functions just fine, and have no trouble with an Access or SQL Server database (or both in a mashup). As to what they offer, well they are a different product in that they are data aggregators and dashboarding tools, but they do not provide and type of RDMS, that is what Access, SQL Server and the others do. But Power BI can be very good at pulling data in, from multiple sources, cleaning that data up (Power Query), extending the data without changing the database (Power Pivot), and then creating nice shiny dashboards (Power View). Personally, I couldn't be, and wouldn't want to be, without it now. The other great thing about Power BI is that is where MS are investing their R&D nowadays, not in Excel, not in Access, so you will see far more developments in that arena.
What are experiences and opinions on using Tableau, MS Power BI, or other such programs with Access/SQL data? How easily do they utilize Access/SQL data? Which ones do you prefer? What do they offer that Access can't to, or not do as well/easily?
Posted by: "Bob Phillips" <email@example.com>
|Reply via web post||•||Reply to sender||•||Reply to group||•||Start a New Topic||•||Messages in this topic (4)|