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?

like
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 .

like

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)

like

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
funnylike

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

like

How do you date as a physically unattractive man?

funnylike

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.

like

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

Post Photo
like

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.

like

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?

likehelpful

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)

likehelpfulfunny

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

like

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?

like

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

like

Hi

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?

like

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

like

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

like

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?

like

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!!!!!!

like

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.

like

Did anyone here move to tech from consulting?

like

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.

like

Additional Posts in DataScientists Network

Hi,
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.

like

Can anyone please refer me for a data science job?

like

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.

like

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.

TIA.🙏

like

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.

like

Now we are a family of 10K Whales.
🙏

Post Photo
likeuplifting
like

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

like

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 🙂

like

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?

like

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

like

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.

like

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

like
like

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

like

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..

like

How's IDEMIA for Python Developer role?

like

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!!

like

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

like

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

like

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

Share

Embed this post

Copy and paste embed code on your site

Preview

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

OR

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

General

Legal