Do we need a Power Pivot sub-forum?
I seem to be spending all my time in Power Query and Power Pivot, these days... Maybe I'm forgetting all my VBA skills!
Anyway. Do you think we need a sub forum just to handle issues with Power Query, M, Power Pivot, DAX and Power View?
Your thoughts?
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
There was another thread about PQ in the suggestions section. I think there should be a sub-forum to cover PQ, PP and Power BI.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Hi,
Interesting that MrExcel, who are not too keen on having Sub Forums for Excel general questions, have a Power BI sub Forum. It seems fairly popular.
I ‘m slightly confused with the terminology.. Power Point, Power Pivot, Power whatever... I am not sure if a change in Forum names might just as well solve the issue...
We have
Excel Charting & Pivots
In that is a sub Forum
PowerPoint Programing ( spelt wrong lol !!)
At MrExcel it is
Power BI (Business Intelligence Tools )
Power Pivot, Power View, Power Query, DAX Formulas
It sounds like possibly a separate Forum called like
MS Queery and MS Power Queery might be appropriate..
?? Or maybe someone in the know, just out of interest, could summarise what all these different things are
Alan
( P.s. I only have "Normal" MS Query in my XL 2010 ... is Power Query similar , just better ?? )
Last edited by Doc.AElstein; 04-25-2017 at 07:50 AM.
'_- Google first, like this _ site:ExcelForum.com Gamut
Use Code Tags: Highlight code; click on the # icon above,
Post screenshots COPYABLE to a Spredsheet; NOT IMAGES PLEASE
http://www.excelforum.com/the-water-...ml#post4109080
https://app.box.com/s/gjpa8mk8ko4vkwcke3ig2w8z2wkfvrtv
http://excelmatters.com/excel-forums/ ( Scrolll down to bottom )
Power Query (or "Get & Transform" as it's called in 2016, sadly) is a tool for blending and shaping data. It uses 'M' formula language, generated by a simple, user friendly query editor. It is integrated into Excel. It is quite different, in purpose, language, skills and issues from MS Query.
Power Pivot is a tool for modelling and analysing data. It uses DAX expression language to create measures, and to summarize data. It is integrated into Excel.
Power View is a tool for visualising and presenting data. It is integrated into Excel / Sharepoint.
Power BI is a self-service business intelligence (BI) suite of tools, essentially the same as Power Query / Power Pivot / Power View, but outside Excel.
PowerPoint is a completely different tool for making bad slide shows, and boring audiences to death with too many bullet points.
A huge amount of issues raised on here, particularly those relating to blending and shaping data, and summarizing and presenting data, can be solved so much more easily using Power Query and Power Pivot, than by using 'traditional' Excel methods, of complex formulae and / or VBA. I'm surprised there is so little focus on these tools, on this site.
Thanks for the clarifications Olly.
It seems clear that these areas are very easy to get mixed up. Different combinations of these things are grouped together differently both in Forums and in people’s minds depending on the different peoples interests.
That would be one thing that would make starting a Sub Forum difficult I think. You would at any rate need a good Sticky to explain and summarise the different things.
It has also been suggested to me by informed people that the name change of Power Query to "Get & Transform" was an attempt to help clear up the confusion. Microsoft probably got mixed up themselves in what they were talking about, Lol..
From what I can glean is that many of these things have the characteristic that a lot of what is “done” is or can be done “externally” as it were to Excel. But the extent to which that is done varies with each product.
That makes it very difficult I think to decide how to organise the focussing onto these different products in a Forum such as an Excel based one as ExcelForum. It would be very difficult to distinguish between the things.
In the other thread, for example, that Ail referenced , ( https://www.excelforum.com/suggestio...wer-tools.html ) the OP suggested a Sub Forum for “Excel Power Tools”, but then went on to mention “Power Query,Power Pivot,Power BI”
Now from our discussions we see that a distinguishing factor in these things, ( one I expect to develop further in this aspect in the furute ), is doing a large amount of stuff outside Excel, or moving away from Excel.
I think someone would have a very hard job to explain to the owners of ExcelForum what such a new Sub Forum should look like, that is to say what it should cover and how the possible sub forums within the main sub forum should be organised and named!!!!
( I don’t envy anyone not fluent in Hindi in trying to do that .. Lol..
EDIT P.s. To help distinguish what MS Query is, we have a good Thread in Tips and Tutorials
https://www.excelforum.com/tips-and-...-ms-query.html
Last edited by Doc.AElstein; 04-26-2017 at 03:28 AM.
I think a separate forum for the BI tools would be a great idea, since: Power Pivot is quite different from regular pivot tables; Power Query / Get and Transform is quite different from MS Query or any of the other external data tools; and Power View is quite different to everything. For the most part, I think that people who have, and use, these tools are aware that they are different and a subforum would help, rather than confuse.
Of course, many people do not have access to them but that's Microsoft's fault!
Don
Please remember to mark your thread 'Solved' when appropriate.
Hi Don,Originally Posted by xlnitwit
I agree it would be a good idea and help those very familiar with the product they are using.
Mainly I think the confusion would be for newer uses to navigate to the specific product that they are using. That would require carefully labelling and organising ( sub dividing ) of such a sub forum. There are already some very confusing organising here of for clearly defined topic areas ( Suggestions for Improvement, Tips and Tutorials ) .
It is to be encouraged to discussion and put forward these suggestion, In my opinion.
Some good clarification of the different Topic areas , like Olly did, is also I think helpful, and probably essential to have any chance of such a Sub ForumS being started here.
Alan
Well as you can see, the TT has been working on it for about 4 years now
https://www.excelforum.com/suggestio...-subforum.html
I am bumping this again. Is it not possible for an administrator to add a sub-forum?
Boing.
We really do need this.
Yes, we do. It has started to gather serious momentum over the past few months.
I suggest a sub-forum called "PowerQuery, M Code, PowerBI & DAX".
I will look to see if I can create 1. If not, Im not going to waste my time asking the TT to do it, sorry.
We already have a bunch of forums in the list that really dont even exist, btw
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Can we just rename one of them, then?
I don't mind pestering the TT team if you want another attacking flank. I am, after all, like a dog with a bone ...
"Power Query, Power Pivot, Power BI"
"Power to the people" ?
Well, quite
Going off on a tangent here, but I think the "New Users/Basics" folder is a waste. Rename that folder.
1. Just because someone is a new user, doesn't mean their question is any less complex than some else's questions. In fact, often the new user will ask a question that a more experienced user would simply back away from.
2. Since the posts are "problem based" (i.e. finding a optimum interest rate for dodgers in Timbuktu) and problems are not selective to the experience of the user.
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
I was told I can add/change/delete forums, but am still waiting for them to tell me how.
Can't you see these options, Ford?
Modifying Forums
On the Modify Forums screen you will see a list of every forum you have, including any which are hidden from end-users. On this screen, you can set the Display Order (make sure to click Update Display Order to save your changes).
Under the Forum Controls, across from each forum title, are the following options:
Edit: Lets you modify forum settings. (see Editing Forums)
Remove: Deletes the forum, any subforums, and posts in the forum and any subforums. This action cannot be undone, so it is highly recommended that you make a backup of your database before doing this.
Add Sub-forum: This allows you to add a forum that will be a child of the forum you select this for. (see Adding Forums)
No, I cannot
Attachment 630939
(hope that came out)
What happens when you expand the threads and posts section?
I have a Forum Manager link, but in it I can only add or edit announcements, not add or edit forums and sub-forums.
Last edited by AliGW; 07-05-2019 at 01:14 AM.
NuffinkWhat do you have>
Attachment 631054
Have you fixed this yet?!
See if the attachment works this time.
Ali, is this what you see?
Here's what I have, Ford:
How about now, can we have this now?!
You've probably got more hope asking for it off Santa Olly!
You mean Ford ISN'T Santa?!
I want it NOW!!!
Most other forums have some sort of Power Tools sub-forum. As I've noted before, the number of PQ queries, in particular, has increased a lot as more people move to the latest version.
People will still post them in the wrong place a lot of the time, especially since some bright spark decided PQ should be called Get and Transform. All a bit moot unless Ford has the ability though.
Rory
Yes, but we can (and regularly do) move posts to the correct area.
Ford should, in theory, be able to do it ...
I'm not sure about that. The screenshot you showed is the Mod control panel. I think the admin one should have a 'Forums & Moderators' group below the Announcements one, but it's not there in his screenshot, so, unless it's within the Announcements section that isn't expanded in that picture, he may not have the right permissions.
How about repurposing the current Office 365 forum (which is vague, and hardly used for it's supposed purpose).
Can we rename that one "Power Query, Power Pivot and Power BI "?
Please?!
Yes, please, pretty please!!!
I think I said before, that I dont have access to do that - perhaps Jerry does?
Isn't Power BI an ecosystem for Power Query and Power with a few trashy visualisations added in? Good grief, I'm turning into an American. Ecosystem ... in technology!. I'll be making verbs out of nouns next. Time for a decent Scottish malt methinks.
Power BI is for visualisation of data. It, too, contains Power Query, but it also uses DAX. In the right hands, it’s not trashy, and for us it’s the perfect tool for disseminating our tracking data. I would like it included in the section name, if we ever get that far.
It's correct that Power Query / Power Pivot are almost identical functionally to Power BI (and SSAS Tabular Models).
There are some differences, of course:
- The underlying MDX generated is different in Excel, so there are some minor functional differences, and often some noticeable performances differences.
- Power BI is designed to be deployed as a service, via a browser / mobile device. No client software is needed to consume information.
- Not sure why you describe the visualisations as "trashy" - just like Excel, the overall look and feel of the output is controlled entirely by the developer, so Power BI reports are only as trashy as the designer makes them!
- Finally, the end user experience in Power BI is significantly enhanced over Excel - the ability for users to interactively explore data from multiple models, save, bookmark and collaborate in an intuitive environment which Excel (even with Power View) simply can't replicate.
I'm not saying Power BI is better than Excel, nor the other way round - there's a place for both, even with the huge overlap in functionality. They're both great
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks