Good morning, fishes. Here at Walmart, you might say we’re a pretty big company with lots of disparate, non-homogenous data sources. Importing and processing data through excel to a useful format can be a massive pain and is often demoralizing. Can you share either:

1. a success story where you were able to import data from multiple sources into excel and make something useful, or

2. Your favorite data pipeline tool to make integrating excel easier

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

Depends on the datasources. There’s a tool for every toolbox, just need to know the size of the nut.

like

If you've got some budget, Alteryx
If not, can do it with SQL and/or VBA - not so elegant by today's standards but perfectly reliable
Have built many a VBA solution for this type of thing

like

Partly existing VBA use at the client, partly PQ was lesser known until last few years even though it was released in like 2010 or something.
Agree though that would probably work well as well, subject to specific data shape.
Bizarre as it is to say, VBA gives a perfect level of control in being able to pull out specific cell ranges from worksheets that can be hard to achieve with other tools if the worksheet structures aren't fairly clean.
Engineers would consider it solving the wrong problem, but have to consider client environment (they won't put time and effort into changing the structure of their reporting output just because I ask them to, even with a business case)

So Anaplan wasn’t the panacea it was marketed to be, huh?

Not familiar with anaplan, care to elaborate?

Followingg

Walmart- attach you will find the expense report that I created but unable .

Post Photo

Power Query works decently. You can also use power automate for certain things

Related Posts

please help me how to apply performance test engineer jobs in nagarro please let me know

like

Are we secretly being judged on how many of these admissions events we are attending / if we are participating?

like

Hi Fishes,
I have total 2 years of experience as a ServiceNow Developer. I am planning to switch from Accenture to other organization but I am not sure which offer should I take?

Infosys Or Wipro - having the same offer around 12 lpa

Which of the above organization will be a better for learning and growing opportunity as a ServiceNow Developer? Which one of the above is better?

like

At work I tend to eat just to eat. Any advice on how to break the habit?

like

Citicorp Hi, How is WLB and job security in Citicorp ? I am a java developer with 5.5 years of experience and have joining in next month. Thanks in advance!

Citi

I have a 760 gmat but think I am capable of better, all of my practice exams were higher. Should I? I am not humble bragging so serious replies only please 🙏🏻

funnylike
like

Joined EY 6months back as a tech consultant. My feedback so far has been great. What should I do to get the company sponsor my mba? I haven’t initiated the talk yet

Hey Folks ,

Can you help me understand the PF deductions in Coforge CTC, Is it just the employers contribution ? And employees share will be deducted from Gross Monthly Salary?
Also about LTA , Can i opt out of it and get it as taxable amount?

Thanks in Advance 🙂

like

Hello All,

Looking for a refferal in
Genpact .

Please let me know if anyone can help. I have the job ID.

Is it wrong if i'm 6'4 and like small woman? I'm dating a 5'2 girl rn. But she is the cutest 😍. But my friends are super judgy about it :(.

likefunny

Do you guys wear winter jackets over your suit coat? It feels super uncomfortable, even the nice Calven Clien type coats

moved from inside sales to an outside role...any tips on suit care during travel? What do you do with your jacket if you are traveling same day as a meeting?

like

Any recs on where to get a nice tux (to wear for my wedding)? Thinking ~1.5k budget

like

Anybody have workout shirt recs that are longer? I’m tired of shirts fitting at the shoulders and being too short … 6’1” 200lb

like

I am looking to enter big law. I had a clerkship on a state Business Calendar and am a current first year litigation associate where I have prepared for a trial, taken and defended depositions, and have extensive motion writing practice in tech, business, and employment cases. Is it a waste of time to try and make a move to big law with such few years of experience?

likehelpful

Thoughts on the Technology Strategy and Advisory group? What sort of projects / roles would a consultant take on? Wlb?

In your opinion, which biglaw firms have the best tax groups?

like

Currently a Wealth Advisor for Citi but I honestly hate it here with a passion it’s the worst company I’ve ever worked for in my life and I’ve been in Wealth Management in the banking channel for over a decade. Series 7, Series 63, Life, CFP, ChFC, and soon to have my MBA with a focus in Mergers & Acquisitions. I’m look to enter another area of Finance at this point instead of starting over somewhere else from scratch, but not sure what direction to go. Interested in Investment Banking or M&A.

Hi, I was promoted to Associate in March. Am I eligible for October annual hike?

like

Additional Posts in Excel Genius

How can I extract just the year into a new cell from a “yyyymmdd” cell (labeled PD here) that isn’t recognized as a date? I basically need to sort this data by year. Thanks in advance!

Post Photo
like

Recently made a job switch and have been using a lot more excel. Any free resources to help build a solid foundation / fee based courses to help improve my skills?

like

For a linear regression analysis… the equation of a line is Y=MX+B, where M is the slope. So if I’m measuring a line across 365 days and M=.2, can I say that I have increased production by 20% over a year. Or is production increasing 20% each day?

like

Has anyone had an issue with index match and lookups returning NA when trying to manipulate data from a password protected workbook?

Is it possible to round a number (say rounding $98 to $100) without losing precision in following calcs? So I only want to round visually and I want the calcs from that cell to remain off the $98 not $100

likehelpful

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

like

Vlook up isn't recognizing a couple of cells even though it's feeding off a pivot and when I check with an " if =" it comes up as being the same.
Any advice on what I need to check?
Thanks

like

Hi excel geniuses, how do I quickly copy info from one cell to blanks for same if. Semi below I have products and names, for the blank fields w same product how do I quickly copy for the rest of the blank cells?

Post Photo

Hey, I have been tasked with teaching some of my coworkers excel from the very basics to more advanced. Does anyone have recommendations on the skills to teach them about? Thank you all in advance!

helpful

Is there a way for me to automate creating columns to do this so I can drag across and create my columns? For example--
1Q2021 2Q2021 3Q2021 4Q2021 2021 1Q2022?

likesmart

Best free data sites to tap into to build a city analysis model? Basically I want to "discover" cities with certain dimensions, like: population, elevation, climate, and proximity to other things (ski resorts, particularly)?

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

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

Does anyone have any tips/tricks for knowing where to plug +1/-1 in a large table with totals across the y and x axis that contain un-rounded numbers? Every time I fix a row I throw off a column or my check figures to the true data source.

Post Photo
like

Need help building an electric schedule for a production schedule with a Gantt chart style view (sort of)

Currently have an excel list with resource (production line), start date and time, and then also the name of the item being produced.

Any ideas how to tackle this??

I’m thinking a stacked bar chart with the vertical categories to be my resources and horizontal the date/time and then each individual bar to be the name of the item being produced.

Thank you for the help Excel Gods 🙏

like

Help me save the day: have a massive excel file (600k rows) with duplicate records (column a, b and c are duplicate, not a duplicate if a and b are the same though). How can I filter for just these records? If it didn’t crash excel I could concat into one column, Conditional format for duplicates, and sort by color. What’s a work around?

likehelpful

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

likehelpful

Does anyone know what purple tables mean in Excel?

I know about green and orange, but never saw purple before and trying to figure it out.

likefunny

I am looking for a way to link my Salesforce data into excel so I can have the latest data at all times. Instead of the typical download of static data that by the time I am reporting the data has changed.

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