One important skill that I wish I learned sooner as a marketer.
If you're tired of using dashboards to extract data or hate asking your data analyst for a favor all the time then please consider LEARNING BASIC SQL!
Knowing only basic SQL (not even advanced SQL) enabled me to:
- Write data scripts and customize them in the way I want.
- Extract data 2-5x faster than waiting for dashboard to load (of course if you know how to call data correctly).
- Organize data effectively and even create my own dashboards.
People said SQL looks complicated but in reality, it will probably take you 1-2 hours to master 10 basic SQL commands that will benefit you in the long run.
If you are interested in this topic, you can check out some below resources to kick start your learning:
- Self-learning:
- https://www.w3schools.com/sql/ to learn some basic SQL. This source will give a sample database for you to test as the first step.
- Join Datacamp: https://www.datacamp.com/ that have multiple courses from Basic to Advance as well as Bootcamp for you to try out.
2. Beside self-learning, I'd recommend to find an opportunity to use in a real database (like your company's database) to practice what you've learned. E.g pull out a spreadsheet to draw a chart for your slide/report.
3. Lastly, I think the most important thing is to find a good mentor who can guide you write a more complicated query effectively.
Check out other posts I wrote about career here.
Written by
