Add a Reporting Ribbon to Excel to consolidate and highlight the amazing capabilities of Power Query and Power Pivot
Tables, Power Query, Power Pivot and Pivot Tables are amazing tools that will transform the way people build their reports, but only once they know about them!
Let's SHOUT about how good these things are and how well they work together by putting them onto a single new Ribbon called "Reporting" - something like the attached image.
Wyn Hopkins
shared this idea
9 comments
-
NH
commented
I suggest adding Excel's Power Query and Power Pivot features to Access in Office 2019.
-
Pieter Erasmus
commented
The Graphing function does not allow for easy amendment of the graphed ranges. If I copy a graph I have to change the ranges manually one series at a time which wastes time. A global change for this graph on the full data set will be valued.
Also if the Legend for Trends would color the slope and R squared values the same color as the data series trended.
-
Wyn Hopkins
commented
Hi Bill, the name is tricky, and I'm sure there's probably a better name.
I'm looking at it from who it's aimed at / why have a separate ribbon. The reason is awareness for those users who simply miss out because these new features are hidden away.
How do we capture their attention, what resonates at a general level? I'm not particularly set on "Reporting" as a name but it does sort of capture why someone should look at this ribbon.
If your job involves reporting and you're not using Tables, Power Query, Pivot Tables and Power Pivot then you're missing out.
To me reporting is something dynamic and interactive that requires regular refreshing / updating.
-
Bill Manville
commented
Not sure I like the name Reporting.
Most of these icons are related to getting, transforming and analysing data.
To me a report is something rather static that may result from such operations, but I wouldn't look there for those operations.
I daren't suggest "Get and Transform" though... -
Wyn Hopkins
commented
Sergei, definite room for improvement on my hacked together version. The Power BI publisher features I'd like to see on there too. Plus I'm sure the Excel team will have some usage stats on most popular Get From button - personally I'm always using from Excel or From Folder, but others will be different.
Calling it out as an awesome set of features is the key to me (plus grouping together the whole data analysis / reporting story into a cohesive place).
-
Sergei Baklan
commented
The question is what to put into such ribbon. On your picture I'll miss Existing Connections, From Text/CSV, Add to Data Model, Pin Manager... Keep too many - it'll be overloaded. Keep few - quite many will be unhappy
-
Frederic LE GUEN - MVP
commented
Good idea,
I will also add the button "Forecast" -
Anonymous
commented
FWIW, by the name alone, I would interpret "Power BI connector" as a Power Query feature to connect to [and optionally import from] a data set hosted on powerbi.com.
-
Wyn Hopkins
commented
Plus the Power BI Publisher buttons would be great. Although I'd rename them as Power BI Connector :)