What are your recommended resources for learning how to do pivot tables and SQL? Was not covered in my training....

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

Biggest way to get good at both is practice. For pivot tables, one video from YouTube and you’ll probably be set. SQL I learned by looking at queries other people made and deciphering the syntax: select...from... where... it’s all repetitive as long as you know how to locate your data. Stack overflow is a great resource once you try to develop more intricate queries. I have had previous coding experience with other languages and can say that SQL was by far the easiest one to learn. Good luck!

like

Youtube

Related Posts

I am currently working as an implementation manager/client onboarding role. I want to switch to program management or product management. What would be the right way to go about it?

like

What’s the hierarchy in Slalom Strategy Consulting? Is MD different from a Principal/Partner?

like

What is procedure for power programmer bridge candidates after completing power programmer training? How and when will the role change to specialist programmer?

Anyone here exited to a think tank or know of someone who has?

like

Hello, I applied for a controller job and they are considering me. I am currently a senior 3 but jumped firm and took a lower level to get in big 4. I think I can do the job but am freaking out now lol 😂. I am a CPA, I also have an MBA and a CFA , not that the MBA and CFA are relevant. I need help , how hard is the controller work?

like

How hard should I push to come in as a ASC2/C2? As an MBA + 5, I asked my recruiters about this and they pushed back pretty hard. Objective would be to fast track title and TC.

like

Hi all,
Can someone guide me on how should a person start learning for transition into a data engineering role at a beginner level. Currently I have known Python and SQL in my job. Not able to figure how to go forward?
Any advice would be great!!

like

Quality engineering VS software engineering. I am currently a quality engineer in medical device. I have 4.5 years of experience. I’m stuck between getting a degree and continuing in quality / manufacturing or switching to software where I know money is great. Thoughts?

likehelpful

Hi! I’m running a startup after work for this neat web app idea for the last year and although we’re still building it, I feel like I’ve learned and directly applied the product management role. And I love it! My question is: should I list this as experience in my resume? I want to do this full time at a real tech company to get more experience just not sure if it would be helpful to get noticed. Currently F100 internal consulting for five years.

like

Looking for advice on how to move into advisory and if it’s recommended as the primary caregiver for 2 young children in regards to WLB. I have been in financial services audit for 5 years and it really isn’t a fit for my personality. Have a BS in accounting and CPA, do I need to go back for an MBA?

like

Is it worth it to get a professional certification like SHRM/PHR? Not many of my colleagues have one and it’s not a requirement for my role, but I’m curious if it’s worth it in the long run

like

I have been working at a small healthcare consulting company focused on Market access and I am hoping to branch out. What are good healthcare consultancies to go for?

like

Hi Everyone,

I am 6.5 years experienced i am relieved as senior software engineer from my last organization and the company I joined gave me senior analyst position and when I joined in they gave me designation as just engineer it feels like demotion to me some of them say skills and work experience and monetory growth matters not a title and some say otherwise what are your opinion?

like

Hi fishes, Yoe - 3.8 years. Skills - java spring boot microservices. Please let me know which company to choose from the below. For teksystems, i will be working at client's location (Ford). So it will be like third party payroll.

Pls Suggest me in terms of my inhand salary, learning opportunities, work life balance , career growth. Please comment your views. Thanks.

Infosys Tata Consultancy Tata Communications Coforge Accenture

Post Photo
like

I currently work as a personal injury lawyer at a small law firm, 5 years experience, graduated from T30 law school in 2015. Our subject area is pretty niche, and I am looking to branch out. Not big law, but a different subject area, and hopefully something with a better work life balance (have a small child with hopes for more). Open to leaving the law for a compliance/HR/other type position. Am I even marketable for something like that? Am I being unrealistic?

like

Joined a start-up as the first product marketer. Been here a few months and the product is completely broken- I was def sold a pack of lies. Is it dumb to quit without another job lined up?

How difficult is it for producers to transition from pharma to general consumer?

like

Hello guys! I am a new master graduate from rutgers graduated from last summer. I am actively looking for consulting positions in life science and healthcare industry, where I have found most interest and enjoy doing it to me. I have a MS is healthcare data analytics and Intelligence and a BA in Biological Science. Could anyone kindly gives me some suggestions for how to find a good firm for me to start me career and suggestions for the the career path and some interview tips?

like

How to get into Human Resources with a Master Degree in Psychological Organization Leadership

like

I’ve been in my current position (Bookkeeper) for 4 years now. I’m highly interested in taking the PHR, and I’m wondering if I would qualify for the 4 year HR professional job requirement to be eligible to test for the certificate. I work for a small business, therefore I do all the on boarding paperwork/payroll. Any advice is appreciated.

like

More Posts

like

1) What is the best suggestion to start a business ?
2) Do we need to do some pre requisites before starting a business ?
3) Do we need to go for franchise or own labelling ?
4) What are the things that business needs to be started like GST ?
5) what are the best businesses that we look at ?

Please give your valuable suggestions. Thank you fishes

likesmart

Hi Fishes I am looking for a change however not getting any good opportunity.
Currently associated with Genpact as a Management Trainee. I am quite in Accounting, Reporting and Monitoring.
Let me know if if having any opportunity or should I go for some kind of cource something like that.
If yes please suggest.
Appreciate your support 🙂

like

How do you find a healthy balance between your job and your personal life?

like

What does the bowl think of this Hublot Fusion? Black alligator strap with the white dial - I think it’s sharp but want additional opinions on it. TIA!

Post Photo
like

When is the appraisal cycle at PwC?

like

Sunday Wordle

Wordle 274 5/6*

🟩⬛⬛🟩⬛
🟩⬛⬛🟩⬛
🟩⬛⬛🟩⬛
🟩🟩⬛🟩⬛
🟩🟩🟩🟩🟩

Do I need a car in LA? I really want to go client side there and want new experiences but coming from a city where a car is not a necessity. Would hope to live close to work for an Uber or close walk?

like

Promotion from Staff 3 to Senior 1.
Lead Category - Differentiating.
QMRTE - Met Expectation.
YOE - 5.5 yrs. CTC - 6.50.
Hike and bonus ? Business Consulting

PwC is seeking individuals at all levels (especially experienced associates through senior managers) within the following consulting practices: Risk & Controls (general, HI, FS); and Enterprise Technology Solutions (Salesforce, SAP, Workday, cloud). Feel free to DM me if you are qualified and I’d be happy to facilitate a referral.

like

How to get from 18 LPA to 50LPA, presently have architecture exposure along with DevOps and Operations for microservices with automation
I can guess few replies , still checking :D

like

Anyone going to the Swedish House Mafia concert in September?

like

Are people here allowed to use AI advertising tools at their work? I got beta access to one and made a bunch of ads and didn't tell my boss because it saved me so much time..... Scared to bring it up. Are you allowed to use AI advertising tools at work?

like

What do you do to increase the chance of your content going viral?

like

Why have people started putting a space at the end of their sentences like this ? Or like this ! It is def intentional a lot of the times....

like

If I'm an SM up for promo, does Deloitte re-adjust me to an EB-1? I can't imagine PMDs dealing with this visa extension hassle every 3 years.

like

Hi,

My h1b petition was approved till September 2022. I was not able to get it stamped through previous employer and now my current employer is willing to transfer the H1b. Since the petition got expired can someone guide me what is the process for this ?

like

Has anyone had experience turning down an offer from FANG but then begging for it back within a month 😅

like

Comment if interested

Post Photo
like

Additional Posts in Finance

How many bald Managing Directors do you have in your office? Considering using Rogaine to delay the inevitable...

like

Ladies, do you like getting flowers or would you prefer getting something else? And what would the something else be (in a comparable price range?

like

I wonder if I would attract the same level of good looking women if I omitted to tell them what I do...

like
like

'21 Grad who just got laid off a year after starting with a RE Developer. I'm lost right now and not sure what to do. My main focus was around project valuations, and proforma analysis. Has anyone gone through this? Especially so early on in my career.

like

Bad idea to leave job before background check for new job clears? Ik it will come back clean

like

Went grocery shopping today and I was the only non-Instacart shopper there. Pro tip: 11am is the best time to go if you can get away with it

like

What are some personal mottos you live by?

like

Any opinions on Bank of China (NYC)? Good place to work? Good benefits/compensation?

like

Seeking nonfiction book recommendations on startups, tech, leadership, or investing. Finishing up Shoe Dog and need to find the next one.

like

Anyone know starting salaries for Insurance underwriters currently? Salary suggestions five years in ? Thank you in advance

like

How much is the salary of a VP and/or ED in a back office role?

like

Is white the only acceptable shirt color for an interview? Do we always have to be so still and conservative?

like

Potential opportunity to join a crowdfunding platform in a biz ops role. Can anyone provide context on if this offer is fair /what my TC expectations should be given the below high level stats. $150k + 10% target + undisclosed equity potential (options). YOE: 6

like

I’ve been promoted to vp in IBD at a MM. how should one think about eating a one year demotion to Asso3 in order to move to an EB?Stakes are much higher than a 2nd year analyst doing the same

like

I just found a notebook from my first year in my desk drawer and it's just full of doodles from when I was bored/irrelevant in teleconference meetings.

like

Where are all the hot guys at?! NYC is a disappointment so far....

like

What industries does everyone on here cover?

like

Actually asking for a friend, but anyone know of S&T openings? He's a fixed income trader covering LatAm

like

1st year looking to upgrade the quality of my work shirts to something more comfortable. Pretty cheap person so not trying to break the bank either. Any good options in the $50-$100 range?

like

New to Fishbowl?

Download the Fishbowl app to
unlock all discussions on Fishbowl.