Not Excel related, but any folks in strategy willing to suggest the best and most useful data platform to learn? I’m thinking along the lines of Tableau, Power BI, etc.

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

Power BI and Power Query. Alteryx is great but SO OVERRATED and overkill for most of what we do. I prefer PQ over Alteryx because 95% of most clients’ final output needs to be documented in Excel with flexibility in adding comments, etc.

like

You can also build a macro with VBA to pull in data from however many workbooks or worksheets you want. The more I use PQ, the more I prefer it because you can stage the raw data and transform it in the same workbook. Easier.

Only time I use Alteryx is if it's too much data for PQ to handle.

like

Alteryx

like

Alteryx and a visualization tool (tableau is generally recognized as the best option out there)

like

They aren’t really comparable - alteryx’s strength is data cleansing and structuring where tableau is better suited to analysis and visualization

like

power bi > tableau

like

everything I've read online says power bi is easier to use and gives the same quality of results. this didn't use to be the case but Microsoft has made good progress

Related Posts

How horrible is it to bounce after 1 year in big law? Debating sticking it out or just leaving after my bonus.

like

Into strategy, governance and assessments. What are my exit opps? Feel like I have none and stuck in consulting forever.

like

Been in the IT audit game for a while and tried interviewing with few companies, and realizing that my skillset is not transferable. Any tips on exiting IT audit role?

likefunny

Suggestions for HRIS certification programs ? Just trying to make sure the program is legit.

like

Anyone here currently at Medtronic? Started about a month ago and looking to network.

like

What made you choose this path? Enrolling in the military requires a particular mindset and set of circumstances. Analyzing those with a clear mind is crucial to a healthy post-service life.

like
like

I just accepted an offer in s&c utility space but I really would like to transfer to AFS in the future. I have a lot of experience in the utility space but afs is my interest area. Is this possible or will it be frowned upon? I’m an L9 likely on the higher end of the pay scale? I’m also not looking to go directly, like maybe after a year or so

like

What if you work at a company where
-your boss was not supportive
-doesn’t give guidance or feedback
-is a “yes” man to a specific dept and never says no to more work for the team
-sets unrealistic deadlines

Would you consider leaving the company?

like
like

Anyone a JD CPA that considered an LLM in taxation? Wondering if it’s worth it or not. I’ve been at both law firms and cpa firms. End goal is to go out on my own in the estate planning arena. Thus far I’ve worked on mostly tax accounting/consulting area.

like

Switching career fields - Any advice on virtual ‘Brand Strategy’ courses/certificates/tools/websites etc?

I’ve heard of classes by Mark Pollard & Julian Cole or courses via Udemy, Hubspot, Credly - would love to add a noteworthy certificate to my LinkedIn but not 100% necessary. Mostly looking to increase my knowledge in a career field I know nothing about.

like

I currently do lots of portfolio operations work as an MC but am looking to change companies. Am I better off going to a fund or staying in consulting?

like

Fellow fish, looking for advice on how to successfully exit to health tech from LS & HC strategy, e.g., what roles may be best to look out for, any skills to highlight, top companies, etc. I know this is broad, but I’m just starting to ponder exit opps and need some high-level pointers on what to consider / focus on over my (hopefully) last 6-12 mos. in consulting.

likehelpful

My background is in change management for large-scale system transformations, but I’m now less interested in implementation-type work and want to do more strategy but still in the OCM space. What kind of projects typically fall into this category and what firms have this as their bread and butter?

like

Any idea how hard it is to find work doing blockchain development? Also, what are makes someone stand out?

Hi. I'm a final year btech student, and I recently got an offer from PwC India for the post of Sr. Analyst, with the package of 4.5lpa fixed + some yearly performance bonus. How should I expect me to be my career graph in pwc? Promotions, work culture, work life balance, basically any kind of insight will be appreciated.

THANKS A TON, IN ADVANCE.

like

Has anyone here moved to strategy from account? If so, why and how has your day-to-day changed?

like

I’m torn between opportunities. A threat intel analyst role vs. a cyber strategy / advisory role (more executive-level engagements like maturity assessments, wargaming). I understand how different these are, just interested to hear other takes of pros/cons for each including career trajectory and industry trends. TIA!

like

Wipro WIPL program.. How beneficial is it for an average BSc IT professional?.. keeping in mind that the individual is average in studies and just graduated from a mediocre college.. Is there a better option for such individual to pursue his/her career?

More Posts

I am getting a thousand notifications a day via email and text about a yeti cooler back pack that I've won. I mean like ...chill.... Thanks but I already have tons of stuff..I'm sure somebody else can use it though.

funnylike

Hi, I’m a grad student in industrial/engineering management.
I’m looking for any certification for leadership skills/managerial skill.
Can anyone please suggest me, if possible for free of cost

like

How's everyone doing? Hanging in there?

Hi IBMers,
Please help me in this doubt,
I have my +2/12th from distance education from NIOS apart from that everything is regular education does ibm considers distance education?

Thanks in advance

How are fellow desi single fish spending Christmas?

like

Booz Allen Hamilton 🐠:

I've asked a few questions for my sister, passing another one along.

Is there defined promotion criteria from LA to SA? Or does it depend on admin chain, org, and/or politics?

She is looking at LA positions now as a potential comeback kid, and while she was at BAH 10+ years ago, she's forgotten the details, though they'd likely be severely outdated even if she remembered.

TIA!

like

Can someone refer me to GlobalLogic? I have the job id with me.

like

What is the current pay range for a registered dental hygienist in Phoenix Arizona area?

like

Hey Fishers please help me to get 11 💙 ?

likeupliftingsmarthelpful

When you teach a novel in class, do you assign pages for students to read at home? They never do it! How can we finish anything?

like
like

What would be the max budget for an angular developer with 8 years exp (overall)? I'm getting 9 lakhs as fixed salary?

like

IQVIA is not opting for Hybrid model? Planning to join IQVIA. Looking for more WFH.

Is anyone planning to be out in uptown tonight? Planning to going to some bars , weather is probably the best it can get.

like

Butter chicken and coconut flour tortillas

Post Photo
like

Does anybody have a recommendation for a cheaper laptop that is good at word processing and accessing the internet? My laptop recently broke and that's really what I need in a personal laptop / I want to save money so I can buy a separate gaming device

like

How does a marriage survive when one partner hates the parents of the other partner to the point they wished the parents dead?  Is it even possible for the marriage to survive such one sided hate?

like

I got approached for a manager position at Leidos. Anyone have any insight?

like

CREATIVE DIRECTOR/ART DIRECTOR NEEDED in nashville. if the idea of hot chicken and great work sounds like something you’d like, hit me up.

like

Additional Posts in Excel Genius

Anyone know of an Excel plugin that acts as a reference calendar for Federal Reserve holidays (and those observed)?

like

Any one good with Tableau I have a question

like

Excel Geniuses- I need a macro the will convert a model with all USD to show it in British Pounds, and then back easily. Anyone have experience with this?

like

In VBA when sending an email. How do I change the reply to email?

like

Story time: I was on a trip about 15 years back, doing some Excel work on a ferry ride - your basic pseudo-database work that is so common. I started talking with the guy sitting next to me and after a while he commented on what I was doing, “You know, that’s really not what I designed that for…” (continued)

likefunny

does anyone know what CVS medical excel assessment for finance analyst consist of? I have an interview in a few hours

like

My excel columns have switched to numbers (so I know have numbers for columns and rows). This has also made all of my formulas incredibly confusing. Was this part of some update? How can I switch my columns back to letters?

like

Looking for programmatic way to do this transformation...any ideas? Power query, any add ins??

Post Photo
like

What are the most useful macros you’ve seen that could be used across multiple projects?

like

Matching Data into Same Row

This may be simple or complicated:
I have a data set that is divided into 6 columns. I need to combine some of the rows together based off matching data.

What needs to happen is everyone with the same Bus Driver, needs to populate into the same row. Instead of the same Bus Driver being listed twice in the column.

For The names I plan on labeling them Person 1 | Person 2 | Person 3 | Person 4 | Person 5

I attached a smaller data set for an example

Post Photo
likehelpful

I have 4 columns on a sheet: Name (John), Status (open), Priority (high), and Due Date. How I do count how many open, high priority, past due, action items from John?

Anyone know of a formula or how to create a formula that will do the following:

If cell N3 in sheet 1 meets certain criteria it will automatically copy the data in columns B3, C3, D3, F3, G3, H3, I3, J3, and N3 onto spreadsheet 2.

Thank you in advance for any feedback!

like

Hey Geniuses,

I’m looking to teach myself how to build financial models and LBOs for some PE interviews. Do you know of any free or reasonably priced resources I could use?

like

Hi, in my excel pivot table slicer I have my options and then (blanks) option , anyway to get rid of that?

I’m looking to make a supplier list where I can just filter on certain requirements to get a smaller list…currently creating as a pivot table but is there any other options that make sense?

Post Photo
like

Hi! Disclaimer: not an excel genius…

I’m trying to use the lookup function to grab data from a worksheet within the same workbook. I want the column to reference the cost code in one worksheet, find the cost code in the other and display the billed to date associated with it. The problem is that it repeats an amount randomly. There will be multiples then a blank cell in one that I know has a cost associated with it.
Formula=LOOKUP(D3,!Sheet!$D:$D,!Sheet!$H:$H)

like

Has anybody used the COM library and python to build reports? I'm looking for somebody to chat with about my project.

like