PowerQuery > PowerBI .. thoughts ?

Got the offer Amazon L5 Cloud Support Engineer, what is ideal salary for this position.

Anyone else not getting points / nights for recent Marriott stays? Account activity isn’t working in the app

During the warm weather months I try to set up impromptu events (Storefronts, etc.) where I can be in front of people at little/no cost. How do you guys proceed to take advantage of the summertime?

Does anyone in here work exclusively with B2B enterprise marketing using paid ads on Google and Facebook?

I love scientists online, but in person, sometimes it's hard to converse with y'all.

Can anyone help me wrap my head around this post Series C start-up equity offer? It’s an IP director position, the the base is $170 with 10% bonus (both lower than I was expecting). There’s also an equity component: 0.15% of current fully diluted equity. This equates to about 30000 shares at a strike price of $2. They also indicate the preferred stock price is $6 and preferred stock equity is $188k (whatever that means). They are in the middle of a new financing and valuation round.

I want to buy my current rental house from my landlord (she wants to sell) and we both want to not use a real estate agent and split the savings in commissions between us.

Does anyone know how much a real estate attorney might charge for helping us with a very standard sales contract in California. Or maybe an agent/broker ago would just handle the contract for a flat fee.

What would be a competitive earning for a Director of Sales at a SaaS company in Israel?

Searching for Abinitio Support roles.
Current technical support lead in TCS with total 6.10yrs exp. Relevant experience 4+.

Pls share opportunities.

What is the usual procedure companies do follow while giving offer letter to a potential employee with a notice period? How the date of joining and all will be decided ?

Hey guys!!! I have an interview with BDO for an audit role in the DC area. Any suggestions/ advice/ things to work on specifically? Wish me luck!

Anyone else have a formatting pet peeve and get annoyed when people don’t have a blank first column and row in tabs? I.e headers/data in cell A1

My first manager told me this, and I’ve followed it to a T since.

Any weekend or online excel course recommendations?

I have a large dataset in PowerBI (7m rows) and I’m trying to condense it to pivot in Excel by aggregating the data. Does anyone have experience doing this? How do you pivot and export in Power BI?

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

Would anyone be willing to teach me vlookup?

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

Can anybody recommend any excel courses to take for financial analysis? Modeling, valuations, etc. Any direction would be helpful.@

How can I add multiple characteristics within one cell and make sure that a pivot table can read both values independently if needed? E.g., I have a column titled “color” and in one cell I write “red” and the other “red, blue”. I’d like a pivot table / formula to be able to count that there are technically two “reds” in this data set. Any tips?

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!

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?

Anyone have a good source to learn sql

Is there a way to identify duplicate URLs within labeled hyperlinks on multiple columns/rows/cells?

I was thinking conditional format, but it’s identifying duplicate labels. I have over 80,000 cells, so extracting URLs manually isn’t going to work for me.

Thanks in Advance!

Hey everyone! I am working on a report with the intention of updating the products that a specific customer uses. Currently, the data is arranged with the unique ID in Column A, and associated products in Column B. However, each product has its own row so company 1234 might have 5 rows and company 5678 might have 20. What I need to do is collect the product data for each unique company and put it into a single row, separated by a comma(s). I am at a crossroads, any suggestions?

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?

What’s the best way to summarize multiple amortization schedule. I have each schedule on a separate tab. On a master sheet can I do something where I can input a specific month and show my ST/LT ...

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?

Is Tableau it Power BI better for dashboards? You cannot really do true dashboards in Excel.