Power Pivot or BI

Drexl88

New Member
Joined
Jan 20, 2020
Messages
21
Office Version
365
Platform
Windows
Hi

What is the best option for creating a live dashboard linked to several excel files (stored on same location) that hold the same data sets/fields just for different departments. The data is not in SQL.

Any advice would be greatly appreciated.

Thanks
 

cyrilbrd

Well-known Member
Joined
Feb 2, 2012
Messages
4,014
Office Version
365
Platform
Windows, Mobile
Hi,
BI works well with Excel tables, you can easily set a model (layout) and create several visualizations in a dashboard.
Do you plan to share said dashboard?
BI requires a subscription for this.
 

Forum statistics

Threads
1,085,748
Messages
5,385,655
Members
401,965
Latest member
Shurlock

Some videos you may like

This Week's Hot Topics

Top