Am I crazy and or inept or is power query absolutely horrible? It locks down the entire excel instance while open, uses not one but two Microsoft proprietary “coding” languages, the built in ETL tools are at the level home ribbon excel tabs and can only write to excel sheets or the power BI service… am I missing something here aside from it being free? Or should I just put my time into python and/or SQL instead since I’ll have to code for anything beyond single use, elementary transformation?

like
Posting as :
works at
You are currently posting as works at

For context, I’m a regular alteryx user, but clients always ask for automated tools/workflows in ~power BI~ or over-worked, macro and/or manually dependent spreadsheets because it’s free.

Yeah it's not perfect. But my company won't fork out for alteryx so 🤷🏻‍♂️.

I've never understood why some steps takes soooo long to refresh.

Related Posts

Anyone know how to import Storybook elements into Figma? 🤯

like

Good luck everyone ..... One hour to go until results

like

Be honest, do you see yourself staying in the game to make partner?

likehelpful

Hello, I am looking for a apartment in noida 62, 61, city centre, botanical, indrapuram or nearby locations. Please let me know you are also looking for same(female) or have any leads.

What’s your theme song? The song that helps you get your head in the game when you have a big hearing or meeting

like

I’m 30, should I consider joining S& Middle East as Senior Associate in attempt to make Manager and leave? Is it too exhausting? Will I burn out before I get there? And how long to Manager?

like

Have a really good relationship with current company, but got an amazing offer and very likely gonna leave (signed the offer, waiting for all the background checks to come back). How do you tell your boss you are leaving the company (if boss is not a dick lol) and not ruin relationship?

like

Hi Fishes, Does Pwc AC Bangalore give Mobile phone reimbursement of 34k like in Kolkata AC? Is there WFH one time allowance given now for new joiners post august 2022?

I’ve been seeing a junior copywriter opening at DDB on LinkedIn for a few weeks now. Does anyone know if that actually exists?

Also, major bonus points if you have a good person to email there.

like

What's the annual salary of a traveling sterile processing supervisor

like

Not every person in the comments saying how great of a parent they are

Post Photo
like

Wondering if anyone has a good example of a brand that originally sold a commodity/mass food and successfully introduced a premium/luxury line, under the same brand name. Kicker is the brand has to have started as mass then gone upmarket, nor vice versa.

like

Anyone here broken into real estate private equity from big 4 consulting? What steps did you take to jump into RE PE? What gaps in knowledge did you have and how did you fill them? Outside of the knowledge gaps what other things do you think you needed in order to get into RE PE?

like

What is KPMG's parental leave policy for partners versus employees (MDs and below)? Trying to plan life and figure out if it makes a difference to have a child before or after one makes partner in terms of parental leave benefits. Thanks!

like

Hi,

Any idea about the C&SP department in comcast? working culture, WLB and all..

I was selected in Comcast for a developer role.. Will Comcast provide work from home?

so if anyone knows about that please share your thoughts.

like

Experience:7.9 years
Profile: python automation testing
CCTC: 11LPA
How much CTC can I expect in HCLT please anyone suggest.

likehelpful
like

Do you like humor incorporated into resumes? Why or why not?

like

Can someone share interview experience for DevOps Engineer Today i will be having interview with hpe

like

Additional Posts in Excel Genius

Does anyone from PwC have a list of the favorite groups shortcuts for excel? Please provide. Much appreciated .

like

I’m referencing a cell (numeric) to a text cell. Is there a way to format that number to include commas? See example in comments.

Client sent over a 90 MB model this evening. Took 10 minutes to open and a fraction of that to crash. Can’t wait for tomorrow 😭

like

Struggling with this:
Suppose I want to shortlist companies that serve the priority industry vertical of a country. So I have the industries served by company (one column for each industry) and (cont)

What are your top excel functions you use in finance / accounting - besides vlookup - Pivots - sumifs - count - index. I have an interview coming up which will have excel based technical questions. Not sure what other functions are considered important in the accounting finance world.

like

Excel Rookie looking for a super simple formula to bring all information linked to a certain date in tab 1 to be organized under said date in tab 2.

like

HELP!
I have raw sales data on one tab, which includes a sales rep ID number. My second tab has that sales rep ID number in column 1 and the rep name in column 2. How can I get the rep name added to the correct line items in the raw data?

How do I set the formula to calculate “If x falls between 1-10, return 1-10, if it falls between 11-20, return 11-20, and so on”

like

Any ideas on turning string data into numerical data in excel that’s faster/easier to automate/better than using text to columns? Wish I could use alteryx, but not an option for this use case.

like

Will need to migrate to office 365 soon. What’s the difference for excel from the 2013 version?

likehelpful

How do I compare two sheets to make sure they are identical?

like

Can dates be grouped just by Month-Year in pivot tables on a Mac without having the year as its own dimension?

Post Photo
like

How do you fix microsoft excel cannot paste data error?

like

This is dumb, but. How can I pull and average the numbers in column b associated with the 4 values in column a? So, (sum of all As/total number of As) without filtering?

Post Photo
like

Anybody know if there is a way to automate a Gantt chart in excel when building out a roadmap? Essentially want to recreate the functionality of ms project because my client does not have project and wants a nice visual for the roadmap

like

What’s the keyboard shortcut to get into the “insert options” dialogue when you’ve inserted a new row with Ctrl+Shift+Plus?

like

I created a macro to help me save time on this onetime task and now whenever I open my excel, a blank excel opens with the name of the macro. How do I get rid of it?

like

Best websites to get more of a handle on Excel as a beginner-intermediate?

like

Any suggestions for a formula to calculate a running count of the number of incidences in a list? For example, in a list with A, B, C, B; I want to label A = 1, then the first B =1, and first C = 1, and then the second B = 2, etc. The list is in a column and there are thousands of names. TIA for your help!

EY trying to move away from Excel . Think it’s possible? Want to see it happen?

like

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.
That was just a preview…
Sign Up to see all discussions
  • Discover what it’s like to work at companies from real professionals
  • Get candid advice from people in your field in a safe space
  • Chat and network with other professionals in your field
Sign up in seconds to unlock all discussions on Fishbowl.

Already a user?
Login here

Share

Embed this post

Copy and paste embed code on your site

Preview

Download the
Fishbowl app

See what’s happening in your industry
from the palm of your hand.

A phone with Fishbowl app

Scan your QR code to download
Fishbowl app on your mobile

Download app

Sign up for free to view this conversation on Fishbowl

By continuing you agree to Terms of Use and Privacy Policy

Already have an account? Log in

Sign up for free to continue using Fishbowl

By continuing you agree to Terms of Use(New) and Privacy Policy(New)
Messaging rates may apply

Already have an account? Log in

For account settings, visit Fishbowl on Desktop Browser or

General

Legal