Right now I’m a data analyst with TSQL/PLSQL/MySQL experience. I have experience writing complex queries/views/stored procedures/etc. I have intermediate excel skills and have dabbled in Power BI. I also taught myself PowerAutomate and now am automating my weekly/monthly tasks. My question is what will make me more marketable as a data analyst? Will getting my certificate in PowerBI help? What is a good ETL tool to learn?

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

Python

like

I wouldn’t worry about getting certified in Power BI. Just focus on Python

like

Okay… my “Python” response was rather empty. In terms of SQL, make sure you can do the following:
1. Design a normal schema (star/snowflake)
2. Perform analytic queries ( OVER / PARTITION BY )

For Python, get familiar with dataframes and Pandas and Numpy

If you want to progress to Data Science, scikitlearn

like

Don’t forget business and marketing skills. A data analyst with technical skills only will face challenges as it relates to career growth. The market wants you to be technical but also commercially aware.

like

Yea Power BI is pretty intuitive and easy to learn (very similar to tableau). As everyone said, I’d focus on Python at this point. It’s pretty straight forward as well.

Best of luck!!

like

The ole "storytelling" comes to mind. What does that mean? Be able to demonstrate that you can crunch the numbers (hard skills) but also interpret what happened and why/what influenced the observed performance or business outcomes (be commercially aware), and then also understand a bit of strategy and come to the table with recommendations or answers to:

So what? Why should your stakeholders care?
What should your stakeholders do about it? What do you want or need from them [to drive business success]?
What are the next steps?

It's insufficient to just dump out what happened and to a lesser extent why it happened. Stakeholders need guidance around what to do about it.

like

Related Posts

I’m sick of content creation, my heart is in interactive experiences/product design... I’m thinking of switching to UX/UI. Is there any hope of being hired at a sr level? How would you approach it?

like

Hello everyone. I am currently in the job search just graduate with my bachelor of science emphasis in community health but having a hard time when it comes to job roles. Any job roles advice? My area of expertise are : Social Services, Behavioral Health , Case Management, Community Engagement , Health Coach Public health

like

Has anyone ever posted a general marketing position? We have an open position on our marketing team but we are unsure what type of position to offer. We have a wide variety of needs but don’t necessarily need to have this future person have all these skills. For example we need someone with great copywriting skills and also need someone who is great at digital marketing. This person doesn’t necessarily need to have both skills but if they did great, but if only one, great too.

like

How do non-generalists roles at MBB compare with generalist/BA roles? Roles like digital/implementation/data /research analysts.

like

Do you ever just want to leave this industry? But what do people exit to

like

What are the chances of exiting Deloitte as a SC in a t ech role and landing in a equivalent role in MBB?

Looking for insight from anyone that left public to become a controller. I have about 7 years of experience and received an offer to become a controller. It sounds like the hours could be closer to 50 hour weeks on close weeks. Only 15 days of PTO and a 10% salary increase. The company appears to be stable and I would mostly be looking to gain in house experience. I don’t think I want to become a partner (current manager). Partners in my office never take pto and are working constantly

like

Any actuarial consultants move into other insurance roles? What was the change and why did you make it?

I have 12 years exp of software domain and currently pursuing ai and ds course to move to Data science space.

Please suggest is it good, will I get desired opportunity at this exp and changing domain.

like

Has anyone ever taken gap in their job career

like

I tried out a career and I'm currently miserable in it and want to figure out how to use the degrees I have to find something I find fulfilling. I don't want to go back to school and start over with that process. If anyone has any advice on what websites or resources to explore to figure out what careers and jobs are comparable with my degrees or if anyone has any information or experience with this please hit me up. I have a degree in biology and teaching credential

like

Frontend Folks, need your experience here

After 2 years of slogging my ass in a service based organisation working in Perl, I finally worked my way around into a big Indian startup as a frontend developer in React.

Now, how to plan my career ahead in JavaScript tech? What all things should I be focusing on in the next 2-3 years.

Any suggestions would be appreciated

What is Grade in Cognizant. It is like 65, 75, 85 and so on for different Associates. Can anyone explain this?

like

Any MC folks move into industry? What role and what was the comp like?

Hi Everyone currently i am working as Business Analyst n got offer from IBM to join as a Senior Project Manager , is it good time to leave existing organizations based on current market situation and what would be the role of SBM as i don't have any experience in project management ?

like

What’s the likelihood of a 1st year commercial litigation associate transferring to corporate, hopefully tech transactions and privacy?

like

What advice would you give to someone who wants to quit consulting and start their own business? Is this something you would encourage your younger self?

like

Thoughts on carbon management/ reduction certifications and masters programs when trying to pivot into sustainability?

like

What are typical exit roles from LS strategy into government organizations like FDA, NIH, CDC, etc?

like

More Posts

Hi All

I am getting an offer of Business analyst in Shell and they are giving 22fixed and 3 lakh variable

Other hand I am getting Technical business analyst where 24fixed in Telstra and 1.5 lakh as variable

Which one should I opt

like

An agency recommended we invest heavily in Smart campaigns in G.Ads. WTF?
Why am I paying this agency?

funny

I have half of my cash in a HYSA(Marcus) and the other half in a brokerage(some stocks and ETFs, nothing crazy and just going to go long).

What do you all think is the ideal relationship between cash in a solid savings account and a brokerage? I am leaning towards 75/25 with the 25 being the savings cash with little growth but basically an emergency 6 months of expenses.

like

Hello everyone, i am looking for job opportunities in IT sales. I have overall 8 YOE. Please share references

like

What book has changed your life? Looking for personal growth/motivational books for summer

like

Feel like I’ve come to dread the monthly check-ins with my counselor. Even though I’ve got good feedback, healthy utilization, etc., it seems like it’s not enough in these conversations. Advice?

like

Will there ever be a day that brown women aren’t judged by their single/married status?

like

Has anyone bought a robo vacuum like Roomba for their parents back home?

like

Brads Macros FTW

like

In honor of National Voter Registration Day, The New Yorker released the transcript of a previously unpublished interview with James Baldwin, who gave a first-hand account of "Freedom Day 1963," a Black voter-registration drive in Selma, Alabama. Baldwin's descriptions from that day are so vivid and detailed that you can feel the fear and anger of the event. If you have a couple of minutes, I highly recommend you read it.

like

So... given the downturn, anybody have stories of friends or family (or perhaps you personally) who have quit their jobs because of crypto income?

Hi,
Tech : Mainframe Dev
YoE: 7

Current CTC : 10.

What CTC should I ask for in RBS, NatWest ?
Any pointers would be very helpful.
Thank you in advance

I’m ~5800 MQMs short of making Platinum on Delta, and have 1 trip remaining from NYC to Seattle. Direct flights only get me 4800 MQMs, a stop DTW or MSP barely adds any. Any tips to add ~900 MQMs?

How long to get SPG points for delta cross awards flight? It’s been 2 weeks for me...

like

Is it harder to meet billables in certain practice areas? I’m in T&E and in busy times I’ll be working on 15 different clients in a single day. I feel like I lose so much time task-switching and my billable hours also don’t reflect the mental load I carry around thinking about all the moving parts for so many different clients. Has anyone else had a similar experience? Have you found any time entry or organizational tools that have helped you?

like

Looking for opportunities in startups, where I can explore multiple positions with (design, photography, cinematography, editing) and help with the growth by using my experience of working in several fields over the years.

like

Did anybody else come into FDD clueless… I’m so lost and no one has time to explain

like

Does anyone know what the UHC copays are for Ginger Therapy vs. Psychiatry sessions?

like

Additional Posts in Data and Analytics in Advertising & Marketing

I’m in a growth marketing position, handling mostly influencer marketing, for a startup and this is my first year working full-time. I’m living in the Bay Area (with my parents bc I just finished undergrad) and my base salary is $66,000. I was told when I was hired that that’s a pretty good salary, but I’m not entirely sure. A front desk coordinator at my dad’s private practice gets paid more than me… is $66k good for my position?

like

If there's any other industry you could do analytics in, what would you choose? I'd really like to work in tech, more interesting, better pay, and I've heard if you can get over the wlb it's worth it.

likehelpful

Wondering if anyone knows of part-time gigs in this field. My current job is great, but I want to pay off debt faster, while maintaining some of my "data" skills.

I have written plenty of Stored Procs, ad-hoc, Functions, etc. in SQL Server. Administered SQL Server for a while as well, with permissions and roles and such. Was an ETL developer for a little while. Also did a lot of SSRS, some PowerBI, and a lot of just moving/transforming data, all over 5ish years. Any help is appreciated!

likesmart

Anyone know how TBWA NY analytics department is?

like

ah, when accounts try to push forward a data project without any actual analysts in the room... then they get a reminder of the deadline, analysts are finally invited, and chaos ensues. 😏😂

likefunny
like

Idea: I noticed my signs along the road get taken away but political signs don’t.
What if I make a political party for my company so my campaign signs (ads) can’t be taken down legally? Anyone here know why this is a dumb idea?
Thinking about doing this in both my stomping grounds (NY and Ontario), businesses include a real estate management company and landscaping.

like

I’m at 110k in a super cheap city and I’m not that talented. I got a 140k offer recently but it’s banking 🤮. I turned it down. The raise I was promised fell through. Now I’m bitter. Help?

like

THIS 👏 IS 👏 NOT 👏 NORMAL 👏

Post Photo
likefunny

Has anyone ever prepared a Demand Gen waterfall conversion rate chart while using standard Salesforce reports? I know I can't create a full chart in SF dashboard. I want to build it in Excel. But I can't figure out which report will give me converted dates through the whole stage. Appreciate any suggestions! Thank you.

like

Change my mind

Post Photo
likefunny

I’m going to be leaving Square in a month because I got a Sr Director role at ViacomCBS Inc. My old role as Marketing Insights Manager is up for grabs. If you think you’d be a fit, shoot me a message.

like

I'm an analyst who prefers managing data systems and data operations than doing the actual analysis work. Is there a market for this? Ad ops?

likehelpful

Analytics folks who moved from agency to in house, what advice would you have for someone just about to start? What can I do to better prepare for the switch?

like

I’m not being trained much on my new entry level business/data analyst position so I’d like to do an online course /certification - maybe sql, python, powerbi, etc. There’s so many courses online though I don’t know which to pick. Any recommendations? Which look the best on cv? Preferably for free/cheap pls

like

I need an analytics manager to join my team in Chicago and recruiters have been slacking. If you’re interested shoot me a message.

Hello guys, I have been working on databases and complex sql all my life, so I need guidance to progess 1 step further. Should I learn ETL/ python or azure data factory/ datalakes ? Please suggest.

like