Collective Brain: recently joined a new company and the intercompany is a real mess. Lots of entities are out of balance.

For context it's ~100 entities. So the IC matrix is huge and not particularly easy to read, as in my priority is to filter out the "noise" and only see out of balance ones.

Want to have a user-frinedly interface to so regional finance managers which of their balances are out of balance.

Source data I have is the big 100x100 matrix. I'm thinking Power BI dashboard.

How do you make a burn report on Jira from tickets?

Hey fishes, I have offer from UST global for 37 lpa including 17% variable.
YOE - 15
Role - Agile coach

Can someone tell me how is the variable payout at UST, how much percentage of variable does it generally payout?

How much a qualified chartered accountant working in Big4 with 5 years of post qualification experience can expect from Industry?

Does anyone have any leads for government contracting roles that involve international travel. I also have a security clearance

Hi Team,

I have an offer from Walmart.
Fix : 20 LPA and Variable+Stock =7L
Loc : Chennai

I have got a new offer Fix: 28.5 with Joining bonus 4.5L
Loc: Hyderabad

In little confusion as 10 days to go for joining.
Should i ask Walmart HR for the match will they agree?
#Walmart

YOE : 5.5 year
Tech: Azure, GCP, Spark, Scala

Thanks in advance your suggestions always helps 🙏

Hey folks, what is average fixed CTC of supervising associate in RM profile, also what is appraisal and bonus cycles in EY GDS. is there any wellness program like Deloitte.

Hello folks,
What is expected package for 8.8 YOE, Oracle Apps DBA?

Hey All,
Exp : 8.6
Exp On Mulesoft : 4.8
CTC : 20 LPA
Offer holding :
31 Fixed Infinite Computer Solutions
32 fixed from @Nahil (Saudi based gave 32 fixed (no TDS))

Current company: Infosys
I am waiting for the offer letters from
EPAM Systems asked 35, but selected for D3 role so 31/32 LPA.
Genpact (Enquero global) asked 35, not sure they can give or Match?

Which one to join, I am planning for long term commitment. Please provide your thoughts.

Hi fishes I need your help. I joined a company 3 days back. Onboarding is completed. Now I have got offer from an organisation that is near my home town and ctc is also more. I want to join there. What should I do. FYI I checked service history in uan portal my pf account is not created yet for new organization. Need your humble opinion.

Which one better option interms of saving more money
1 lac Tech M in hand salary in hyderabad
Or
1.6 lac in hand tcs onsite salary in Budapest ?

Curious what’s a fair salary in MA? Was just told that there is likely not going to be a chance for a raise during my upcoming performance review due to my salary already being “above average for the industry” based on my employer’s questionable research. I’ve been with the company 8.5 years & am the only one in my role, which they can’t operate without. I execute tasks from two investment advisors and two financial planners - they make the decisions of what should happen & I make it happen.

What’s a typical AE salary (mid market / enterprise) in London?

Any books that you found very helpful to read as expecting parents? We’re just nine weeks along, but would love to start preparing however we can!

Moving to Boston in June! Any recommendations for areas to avoid/look at when looking for apartments? How early should I look into signing a lease? Any info would be helpful as I’m not from the area

Hey Folks,

Help me to unlock DM!

Thanks.

Anymore rumors about PwC selling the Global Mobility practice?

My utilization is 90% but all of my clients are small jobs. Does that look worse than someone who works on the larger, higher revenue generating jobs with all else equal (utilization/performance)?

I really wanna get into management consulting/PAS, from tax. I hate tax. Don't wanna waste my youth doing this when I know I can be my best elsewhere. Any recs on how?

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

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?

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.

What’s the symbol that you can type in a cell so you can input a text, but that text would not appear in the spreadsheet? I want to describe the formula without using a text box, which uses more space.

The equivalent of this is in SQL, you can use the apostrophe in the beginning of and end of a text. That text will not affect the function of the query, but that text can be seen if you proofread the query.

What is the best FP&A tool, Anaplan, Jirav, Planful, Vena? Any other recommendation?

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)?

I’m verrrrrry new to excel and am going crazy because is there not a way to “clip” text in cells like you can in google sheets? I read about a “fill” option, but then noticed that cells that aren’t filled just repeat text. 😂🤯

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.

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?

Presenting data in 2 tables that refer to the same pivot table as source. However, one requires a filter on the pivot table and when filter undone, values change back to original. How to tackle this?

Any book recommendations on excel modeling for real world business applications?

Is there an easy way to switch XLOOKUPS to INDEX MATCH? Have a large file with bunch of formulas that don't work on all client machines (different excel versions).

How can I update the range in one location for a tab whose data source, a second tab, is connected to SAP and the range updates on the source tab depending on quarterly activity?

How do I look up values from a column in a row? E.g. Values in A1:A6 in B2:F2?

My job often has me conducting analyses where we try to identify if product launch A has had an impact on B (cannibalization analyses) but super often they are inconclusive. I feel I need statistics / rudimentary data science here. Any idea what to study?

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

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?

What are some of the unique use cases you have leveraged excel for?