Best Way to Develop Data Analysis Skills?

It's no secret that the job market in consulting is trending towards data science with the pandemic acting as a huge catalyst towards this shift. I studied traditional business and finance concepts throughout my undergrad and have thought to pivot into a more data-oriented role. I initially thought I could develop this skill set within the firm in my post-graduate years since assignments are the quickest ways to learn, but the pandemic threw a wrench into that plan.

iI don't intend to compete with computer science or math majors, but to give myself a better chance for analyst positions at consulting firms that tend to look for students who've had some experience in SQL, Python, R, PowerBI.

With that said, I know the tools at my disposal are: (1) Coursera, (2) Youtube, (3) LinkedInLearning, (4) Google, (4) Institutional Certificates (CFI's Business Intelligence Analyst certificate for instance)

What is the most efficient way to pick up skills in data science?

Tl;dr: I need to learn basics of data analysis for better chance at recruiting, how should I approach it? 

Comments (8)

 
Feb 4, 2021 - 9:09am

I'm finding this to be the case myself - firms like PwC expect you to have basic or intermediate understanding of SQL and PowerBi specifically. 

​​​​​​I don't know much of the courses on Udemy, do you have any recommendations or courses you've taken that have been helpful?

 
Feb 4, 2021 - 10:05am

I've not taken them myself (I'm a dinosaur) but know many who have. Udemy is similar to Coursera. Just go to their website and search the classes. Tons of useful content catering to all levels of users. I know my son took an Excel and SQL class and found them useful. The shortcuts and modeling skills learned in Excel were pretty impressive considering just spending a few hours per day for a week or so.

 
Feb 6, 2021 - 3:55am

SQL is extremely easy, trust me. It takes 2 weeks to learn and get good at all basic, intermediate and some advanced syntaxes. 

Then you go to Kaggle, download some datasets, and get some practice.

The bad thing about SQL is the no visualization part (you can write functions in SQL, but those functions are heavy and dumb). If you want more, learn Python or R as a next step. 

 

Start Discussion

Popular Content See all

LETS FKING GO BOYS
+134IBby Intern in Corporate Finance">Intern in CorpFin
You Did it Citi
+120OFFby 2nd Year Analyst in Investment Banking - Industry/Coverage">Analyst 2 in IB - Ind
HELP: Sticky Situation with Boss
+115OFFby 2nd Year Analyst in Investment Banking - Mergers and Acquisitions">Analyst 2 in IB-M&A
Idgaf anymore
+31IBby 1st Year Analyst in Investment Banking - Industry/Coverage">Analyst 1 in IB - Ind
Anyone else just want out of this shit?
+30IBby 2nd Year Analyst in Investment Banking - Generalist">Analyst 2 in IB - Gen
Evercore Target Schools?
+26BSCHby Prospective Monkey in Investment Banking - Mergers and Acquisitions">Prospect in IB-M&A
To Snitch or not to Snitch?
+21OFFby 2nd Year Analyst in Investment Banking - Industry/Coverage">Analyst 2 in IB - Ind

Total Avg Compensation

March 2021 Consulting

  • Principal (19) $274
  • Director/MD (42) $261
  • Vice President (30) $242
  • Engagement Manager (71) $215
  • Manager (123) $165
  • 2nd Year Associate (111) $137
  • Senior Consultant (259) $128
  • 3rd+ Year Associate (88) $126
  • NA (9) $126
  • Consultant (469) $114
  • 1st Year Associate (415) $113
  • Engineer (4) $110
  • 3rd+ Year Analyst (105) $106
  • 2nd Year Analyst (235) $95
  • Associate Consultant (130) $94
  • 1st Year Analyst (810) $83
  • Intern/Summer Associate (129) $82
  • Intern/Summer Analyst (360) $67

Leaderboard See all

1
LonLonMilk's picture
LonLonMilk
98.5
2
Jamoldo's picture
Jamoldo
98.4
3
Secyh62's picture
Secyh62
98.3
4
CompBanker's picture
CompBanker
97.8
5
redever's picture
redever
97.8
6
Addinator's picture
Addinator
97.6
7
frgna's picture
frgna
97.6
8
NuckFuts's picture
NuckFuts
97.5
9
Edifice's picture
Edifice
97.5
10
bolo up's picture
bolo up
97.5