Hi Fishes,
I am preparing for data analyst job so learning Power BI and Excel.

Could you tell me what are the ADVANCED Power BI and Excel concepts I need to know.
In Power BI, I am aware of DAX Functions such as ALL,ALLSELECTED,Filter and ROW context,Measures and Calculated Columns, QTD,MTD.

In Excel what are the advanced concepts, is learning VBA Coding essential?

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

I would suggest to learn Python and not to waste your time in VBA .


Learn Vlookup, Hloopup, Index match, Pivot tables and Charts, Power Pivot in MS Excel, VBA scripts are being replaced by Python based scripts, so learn any one way of automating stuff in excel (VBA/Python)


Hey i have the above skills and also learning data analysis with python, could you please guide me how I can get into EY

Related Posts

TD hardo showed up in green pants socks and shoes 😭😭

Post Photo

Can anyone share the support model and intake process for Workday Financials AMS ?


How do you date as a physically unattractive man?


Apart from job, What are the other ways of earning which are legit and proven. I want to utilise my 2-2.5 hours on daily basis. Expert suggestions pls.


Can anyone please let me know what does lead mean in TCS? What can be the expected salary bracket for this level?

Post Photo

Hi fishes, I want to submit broadband connection reimbursement request via Global Claim System GCS. Is there any chances of background varification regarding the broadband bills??
Thanks in advance.


Looking to break my lease: Had plans to get married in October after my lease ends, but because of Corona want to push it up to end of August. I spoke to my landlord and she said she's not breaking it. Looked at my lease and doesn't even give me the option to forfeit my deposit. What should I do?


When you want 3 kids eventually and ideally want to be married before children, live with your partner a while etc etc before… what age is it worth worrying that you’re still single at 👀 (for women)


Have a Senior Program Manager interview at Microsoft Azure AI next week? Any advice on prep?


Deloitte USI Discussion is in progress with Deloitte USI . Already holding an offer with Morgan Stanley

If Deloitte matches Morgan Stanley or gives more package, is it wise to choose Deloitte usi over Morgan Stanley or will ask for counter offer from Morgan stanley and choose it?


What undergraduate GPA is the cutoff for a T3 business school? I know there are other factors but I’m curious about the ballpark



My offer letter has relocation allowance mentioned , but it is not mentioned in
How much amount i can reimburse. Can someone say where I can view the amount?


Amgen Data Scientist salary anyone ? Location: Thousand Oaks , California


Holding 2 offers. 1 from Accenture and One from Hexaware. Hexaware paying 2lakhs more than Accenture. Which one I Can choose. Accenture taken me for Cloud. Hexaware taken me for Devops. Friends pls suggest. Confused lot


Does tcs give house rent allowance to bps trainees?
I'm going to join tcs kolkata day after tomorrow and my joining formalities guidelines session is tomorrow but still haven't got the joining letter. What should I do?


Hello Everyone!

I am looking for pre occupied sharing flats near JP Morgan towers (Hyderabad) or else Hitechcity, Madhapur, Kondapur, Gachibowli.

Budget: 10-12k (negotiable depends on amenities)

Any leads please let me know.

Thank you!!!!!!


So here's a random one. I'm considering the Samsung Galaxy Flip 3 (not the larger Fold). Anybody already make that leap? If so, what do you think so far? I'm nervous about the battery life, which is reported to be quite limited.


Did anyone here move to tech from consulting?


Seeing local parents reacting to the public school lottery results in DC, got me super nervous about when it’s my kids turn.

I hate the idea of having so little control.


Additional Posts in DataScientists Network

Any one working in Aegon life in analytics domain?
Wanted to know more about company in terms of WLB,job security and work in analytics domain.
Please help.


Can anyone please refer me for a data science job?


At Fractal , we have multiple positions for Data Scientist & Machine learning engineer with more than 2 years of experience at multiple locations.

If interested dm me or comment for further details.


Hi all.

Unfortunately I've lost my job yesterday (laid off) and I'm looking for a new job.
I've 2.4YOE as a data scientist and I can join immediately.

Please DM me if you have any openings to share.



I am Data scientist with 4.5 years of total experience. Looking for opportunity in AI & Machine learning.
4 years relevant to Data science.

Skills : Python, Scikit, Pandas, Numpy, Keras,
Databricks, Pyspark, GCP, SaS etc.


Now we are a family of 10K Whales.

Post Photo

Hello, anybody has any idea about wlb and job security at Hitachi Payment Services (Mumbai)


Hello Fishes,

I was a ETL developer and Data Analyst with experience of 6+ years. I have started my data science journey before 6moths and completed couple of projects.

I am planning to expand my knowledge on Deep Learning now. But i have a confusion by seeing roles which is asking experience in Big data/spark. I'm confused, i have interest in learning both and each one is big at its own.

Can you guys help me in choosing between Data Engineer or Data Scientist role?? Thanks in Advance 🙂


Hi Fishes,
I want to switch my career into Data analysis. Currently I work in Technical support, I want to know the path to move ahead. I am not from a computer background. But keen interest in Data analysis. Any roadmap to learn essentials?


Hi fishes,

I am looking for a job switch in Data Science and serving notice period in my current company. My current CTC is 13-14lpa with 2.5+ YOE in data science and 4+ overall. Please suggest which companies i should apply to..

Also if anyone can refer me please let me know


Hi all,
I am currently working in DATA SCIENCE Domain and would rate myself as Intmed Level in this domain.

I want to join DS Division of Major orgs like FAANG or Big Three Consulting.

Timeframe :1.5 to 2 years

Need guidance from the Expert member of the group regarding the Learning Path I should follow to achieve my Goal.

P.S. Lots of material available online but I would prefer a tried -tested-specific approach.
Don't want to waste time in jumping Blogs or switching 1 book to another.


Hi fellow members,
Can you please suggest which company should I join.

1. Infocusp (small company with good projects, based out of Ahmedabad) - Sr. ML Engineer
2. Nagarro - Data Scientist
3. t-systems - Data Scientist

Yoe - 6


What is the best way to switch to Data science Field given that we know the Machine Learning and Deep Learning Theory but not practically?

Also generally how is the work life balance in the job for different companies? Any input is valuable


Hi guys how much salary should I negotiate for machine learning engineer role in one of the unicorn company..
Yoe 1 year..
Current CTC 6lpa..
Tech stack spark ml dl..
Need suggestion as I don't have salary data for this role on Glassdoor for that company..


How's IDEMIA for Python Developer role?


Can anyone help with a Resume format/sample for a Data scientist with 3+ years of experience? I don't get any interviews calls even with referrals, I am thinking it is because of my resume!!


Can someone please share how was the interview experience and interview questions for data scientist in Pubmatic, Pune


Hey Fishers,

I have 3 offers for a data scientist role....
KGS- 13 fixed
Accenture ai- 16.33 ctc 13.5 fixed
Hexaware- 17.5 ctc 16 fixed

Can someone help me out which company to join... I am preferring KGS


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


Embed this post

Copy and paste embed code on your site


Download the
Fishbowl app

See what’s happening in your industry
from the palm of your hand.

A phone with Fishbowl app

Send download link to your phone


Scan your QR code to download
Fishbowl app on your mobile

By continuing you agree to Terms of Use and Privacy Policy.

Messaging rates may apply

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