RE: [MS_AccessPros] Graphing/Dashboard and Access

 

Bob,

For the specific one I'm working on, SQL is the back end and Access is the UI. Does Power BI allow me to replace Access as the UI, at least for "view only" users? They'll be doing things like looking at financial data (revenue, volume, etc. for financial transactions) by client, sales rep, product (including things like top 25 clients by product), trends/variances in revenue, revenue per transaction, etc.

Thanks,

Adam

---In MS_Access_Professionals@yahoogroups.com, <bob.phillips@...> wrote :

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.

 

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: 16 June 2016 17:02
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Graphing/Dashboard and Access

 

 

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?

 

Adam

__._,_.___

---

Posted by: runuphillracing@yahoo.com

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (5)

---

Have you tried the highest rated email app?

With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.

---

Visit Your Group

• New Members 1

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___