What is the best way to learn SQL for use in finance, namely FP&A? I've watched videos on YouTube but most of them are focused on the syntax. I do know that SQL is used in some type of DBMS like IBM / Oracle / Microsoft Excel. So, when job applications list SQL experience (like for FP&A Analyst positions), what DBMS are they referring to? Microsoft Excel? Oracle? Does it matter? If I learn the syntax, is that enough?
I have searched for resources but again, they seem to be focusing on the syntax. https://sqlzoo.net/ https://www.reddit.com/r/SQL/wiki/index
Can someone who works in FP&A please explain or recommend a MOOC or other sources that will show me how to use SQL just like you do on the job?
Thanks.
So I don't work in FP&A but do have sql experience. The DBMS doesn't matter too much cause most sql syntax is pretty standardized. MySQL, sql server, Postgres, oracle, etc. all have their nuances, but once you have a grasp of how to write queries in one, it's pretty easy to move to another.
Job postings are probably referring to one of the above or maybe ms access. Personally, I would avoid any place that relies on access as a primary tool, and there is a special place in hell for people that use excel as a database tool. Frankly, that practice is downright dangerous.
I'm pretty certain your primary reason for using sql in FP&A is to access data. Any decent size organization will have a whole IT unit dedicated to maintaining everything. Focus on learning how to use select statements; the select statement will be your workhorse and is also often the base for creating objects.
Probably the most important skill beyond mastering the basic syntax is knowing how to assess the grain of an object. That is, learn how to assess the structure of a table or view in terms of the level of data it contains (lookup table vs one record per primary key vs multiple records per primary key, etc.). Eventually you'll want to get to the point where if given the grain of an object, you can manipulate its data without really knowing that data very well.
Those resources you linked look fine. I'd guess most people don't take formal sql classes and learn everything on the job. Google is definitely valuable for this.
I'm not familiar with much of the terminology but I think I get what you're saying. https://www.thoughtco.com/primary-key-definition-1019179
This is a bit of a Catch-22. Whenever I apply to FP&A roles, I never get a response. I tried using a recruiter and even they won't entertain me since I don't know SQL, despite knowing how to model + good grades + experience. Not having been exposed to this at work, I don't know how I would gain the relevant SQL skills.
Thank you!
I work in fp&a and have interest in learning SQL but do not know/use it today. We have a bunch of business intelligence support folks. I think this is pretty typical for larger businesses.
https://corporate-childrensplace.icims.com/jobs/28962/financial-plannin… Overview:
Skills and Behaviors: Quantitative skills (SQL a plus) Strong Microsoft Excel skills (experience writing macros a plus) Strong analytical skills with experience in creating reports using Hyperion financial planning and Oracle Essbase Ability to perform and remain organized in a fast-paced, deadline driven environment by multi-tasking Ability to take initiative and work independently in a sometimes unstructured environment with frequently changing priorities Strong attention to detail and exceptional organizational skills with desire to grow in finance profession
Right. Do you have Hyperion and essbase experience? Those are the more major components with excel as well.
Nope. For someone who is competent in financial modeling/bloomberg, how difficult are these programs to learn? Because there is no way I would be exposed to this in ER. I'm assuming they're not difficult; if so, what exactly do recruiters and hiring managers want? To select people who've only worked in FP&A?
I haven't used essbase or Hyperion. My company uses cognos.
It's a little different to use multidimensional budgeting software if you never have. It's all about managing your data. Generally this software is used for budgeting giant businesses for reporting purposes. I think we currently have up to six dimensions in our models but this will increase dramatically once we upgrade before long.
For example, you may have an expense budget for 1500 cost centers. The dimensions that could be involved are of course the account, the cost center, the business unit, a time dimension, actual/forecast/budget and versioning (January forecast, February forecast, etc.). All of these dimensions provide you a way to look at and manipulate your data, as well as allow you to look at your data from perspectives necessary for reporting purposes to end users.
It's kind of tough to articulate what all is involved n
Do you use BPC? If so, which version?
Voluptatibus ut sunt qui voluptatibus consequuntur. Exercitationem repudiandae sunt ea est.
Consequuntur beatae magnam maiores. Nihil et sit rerum dolorem eligendi quo maxime totam. Omnis est rerum aut dicta. Reprehenderit totam impedit soluta praesentium. Dicta veritatis illum tempora vel eos. Natus voluptatum aut sunt sint.
Earum omnis facilis ab. Alias vitae nostrum incidunt.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...