I was scrolling through the ColorStack Slack today and BEHOLD! I came across the opportunity to participate in a mini Data Analyst sprint later this month. The main skills to be used? SQL and analysis skills.
A Mini Data Analyst sprint is coming - time to prepare!#
Today was the first day I heard about clicked!
I signed up and the first class for this (yes, you need to attend or watch the replays of the sessions before being approved for the sprint) and it happened to be TODAY (July 10).
I put my Tableau learning on a brief hold this evening to attend this session on Airmeet. It was called “Essential SQL as a Data Analyst”. This was a much needed review and brought back memories of the Relational Databases class I took at university. I was reminded of the excitement I felt of learning SQL and seeing the tables. I can’t wait to use SQL to extract data from Kaggle datasets before creating beautiful data visualizations in Tableau.
We used DB Browser for SQLite, which is different from the Oracle Database that I used for class - but the concepts were all the same.
The instructor is Amy Russ, a VP of Customer Analytics. She mentioned data warehouses, data definition language, data query language, data manipulation language, data control language, and transaction control language. I felt glad to be in the (digital) presence of someone so knowledgable who would kindly let me know that knowing these terms in an interview will give me some brownie points.
I will definitely be making a quizlet of all the new terms I learn this week. Yes - that’s right - I will be treating my self-development like another semester of college!
To keep the joke going…what classes am I taking this summer semester again? Lets see…
- Tableau
- R
- SQL
Pretty intuitive, me thinks.
We were not only taught SQL, but how to think like a Data Analyst.#
Most of being a data analyst is coming up with the right questions to ask for the task at hand. There are also many nuances and tidbits of information that was relayed such as…
Never drop a table! You should not be dropping tables
Yes ma’am.
There were also some other fun discussions, such as - which sql database is best to use?
Now, I wish I could write more - but I spent some time and effort on a job application that really caught my eye (I could not ignore the opportunity!). It is late at night and I need to get up for another day of work and learning! Tomorrow I will write more about my experiences with SQL and my continued Tableau learning.
See ya!
