![Anastasia K](/img/default-banner.jpg)
- 39
- 1 308 419
Anastasia K
Sweden
Приєднався 4 тра 2020
Hi everyone!
My name is Anastasia and I am a Data Scientist at a Stockholm-based music startup.
During the last 6 years, I lived in Russia, France, and Sweden, earned two Master's degrees in Business Intelligence and Computer Science, and grown from a recent graduate to a Senior role in just 3 years.
I'm a strong believer that 'fear has big eyes, and that the lack of access to relevant career progression information prevents people from trying. Here, I'll be sharing my experience and hopefully show on my example that building a satisfying career in Europe is not as hard as it seems.
My name is Anastasia and I am a Data Scientist at a Stockholm-based music startup.
During the last 6 years, I lived in Russia, France, and Sweden, earned two Master's degrees in Business Intelligence and Computer Science, and grown from a recent graduate to a Senior role in just 3 years.
I'm a strong believer that 'fear has big eyes, and that the lack of access to relevant career progression information prevents people from trying. Here, I'll be sharing my experience and hopefully show on my example that building a satisfying career in Europe is not as hard as it seems.
Should ChatGPT write your SQL queries? An unscientific study of how well can ChatGPT write SQL.
After playing around with ChatGPT for all my SQL wants and needs I decided it could be fun to make a video, where I ask it to do a few exercises, answer questions, and write queries typical for data analysis work and interview processes.
An important disclaimer: I think it may get better with more precise and detailed prompts, however, when I started learning how to write proper prompts, I realized that writing the query myself would be easier for me. The outcome didn't seem too enticing for me to invest so much time into fine-tuning the prompts.
So this is a raw experiment, on how a human can ask questions about SQL to ChatGPT.
Enjoy!
An important disclaimer: I think it may get better with more precise and detailed prompts, however, when I started learning how to write proper prompts, I realized that writing the query myself would be easier for me. The outcome didn't seem too enticing for me to invest so much time into fine-tuning the prompts.
So this is a raw experiment, on how a human can ask questions about SQL to ChatGPT.
Enjoy!
Переглядів: 5 957
Відео
SQL 101.4 Arrays, window functions, LAG, LEAD
Переглядів 1,7 тис.Рік тому
Hey there! Unlock the power of arrays and window functions in SQL for data analysis. In this tutorial, you will learn how to work with arrays and perform complex data manipulations in SQL. Discover the basics of window functions, and how they can help you analyze your data effectively. This video is perfect for beginners and intermediate users who want to expand their SQL skills and tackle more...
SQL for Data Analysis 101.3 Date and time manipulations, working with strings.
Переглядів 1,4 тис.Рік тому
Hey there! Take your SQL skills to the next level with this tutorial on a basic date and time manipulations and string operations. Learn how to extract, format, and manipulate date and time values in SQL for practical data analysis. Discover various techniques to work with strings and make data transformations. Whether you are a beginner or just looking to improve your SQL knowledge, this video...
SQL for Data Analysis 101.2 CASE WHEN, IFNULL, grouping and other basic calculations.
Переглядів 2,2 тис.Рік тому
Hey there! A long overdue follow-up to my SQL basics for data analysis video, here we'll walk through the most common groupings, CASE WHEN, IFNULL, and other frequently used calculations for data science and data analysis roles. Hope you enjoy!
Outrageous prices 💸 for food & groceries in Stockholm 🇸🇪 | A week of eating in and out for two
Переглядів 7 тис.Рік тому
Hi all! Wanted to give you an update on food prices in Stockholm, after I made this video about Stockholm prices. ua-cam.com/video/IlA2d44cYT0/v-deo.html Inflation is at full speed here, and the most I notice that on food prices. SO here's a little something on how much we spend on food/eating out during a week in Stockholm, as usual, you can check the prices out yourself if you look at the web...
Mental health reset: Monthly review and a trip to Vienna vlog
Переглядів 7 тис.2 роки тому
Hi there! Just wanted to vlog a bit on my trip to Vienna, to talk about the value of reflections, mental health, and how I try to sustain it in these 'unprecedented times'... Hope you enjoy it and get something valuable for yourself! :) Cheers! 00:00 Intro 03:13 Hotel Zola 06:24 Evening walk and dinner 08:44 Morning routine vibe 10:14 How I do the monthly review 16:59 Why I find it valuable for...
A week of working from home as a Data Scientist at Spotify | Stockholm, Sweden 🇸🇪
Переглядів 13 тис.2 роки тому
#workweekinmylife #spotify #datascientist Hi there! Decided to pop back here with a vlog of my typical work week in Stockholm :) 00:00 Monday 05:35 Tuesday 12:55 Wednesday 17:53 Thursday 25:34 Friday Music licensed by Epidemic Sound tempura - Justnormal www.epidemicsound.com/track/KXZ9FnxaBi/ Dark Lord - Ian Luxton www.epidemicsound.com/track/HxTZedKxow/ Motivation - Henyao www.epidemicsound.co...
How I hacked my habit loop to read 30x more books in 2021 + 5 top books of 2021
Переглядів 8 тис.2 роки тому
For someone, this may not seem like a big achievement, but I am super proud that I managed to get back into a habit of reading books! After many years of reading things I needed to, either for work or for studies, I can finally read for my own joy again! In this video, I'm sharing my book reading journey, how I accidentally experimented with the habit loop to read more and what I enjoyed readin...
Tools I use almost daily as a DS: JupyterLab, Github, BigQuery, RStudio, Cmd, Data Studio, etc.
Переглядів 15 тис.2 роки тому
Hi there! Just wanted to list the tools I use often at work as a Data Scientist: Tech & Data: 1. BigQuery CLI and UI 2. Jupyter Notebook, Jupyter Lab, Sublime, Xcode, Intellij 3. RStudio 4. Git github 5. iTerm with zshell 6. Dashboard tools: RShiny, Data Studio, Tableau, Looker, QlikView Work presentation: 1. Sheets integration with BQ 2. Slides 3. Powerpoint 4. Pen and paper, or iPad and penci...
Data Science VS Machine Learning | Are you a DS if you don't do ML? | Who does ML&AI day to day?
Переглядів 13 тис.2 роки тому
Controversial topic alert! A lot of people seem to think that being hired as a Data Scientist means that you'll deploy Machine Learning models and research AI applications. But in many companies that's not actually the case! Here I am reviewing requirements and responsibilities for "Data Scientist" roles in some of the FAANG companies, choosing those as a proxy for big tech companies with a lot...
Noise VS Bias in Data | Female Data & ML creators | You are who you want to be | Visual Storytelling
Переглядів 15 тис.2 роки тому
Hi there! Here's what I am talking about this month: 1. Cassie Kozyrkov 1. ML course (part 1: [ua-cam.com/video/fgF6XzcK3jw/v-deo.html], part 2: [ua-cam.com/video/bk2i5AIz-us/v-deo.html]) 2. Blog - [kozyrkov.medium.com/] 2. Fullstack React with Typescript [www.newline.co/fullstack-react-with-typescript] 3. Amelia Wattenberger - D3.js book and course - [wattenberger.com/] 4. Damsel in Data - [ua...
How to nurture the ONE skill you need for confidence and success
Переглядів 11 тис.2 роки тому
I've been thinking quite a bit about what powers my confidence and motivation to achieve my goals and do challenging projects, both at work and in life. Comparing myself to colleagues and friends, I realized that the people I admire the most for taking on risks and trying new things have a specific skill or mindset in common, they have a strong feeling that they could deal with whatever comes t...
The world is not as dramatic as it seems | 5 lessons from Factfulness by Hans Rosling
Переглядів 8 тис.2 роки тому
Here I want to share 5 very important lessons for everyone who works with or makes decisions based on data. The quotes are taken from the book "Factfulness: Reasons We're Wrong About the World, and Why Things Are Better Than You Think" Book by Anna Rosling Rönnlund, Hans Rosling, and Ola Rosling. Some TED talks by Hans Rosling: ua-cam.com/video/hVimVzgtD6w/v-deo.html ua-cam.com/video/Sm5xF-UYgd...
Factfulness in the dramatic world | Can money buy happiness? | GROW towards your SMART goals
Переглядів 10 тис.3 роки тому
What I talk about: 1. "Factfulness: Ten Reasons We're Wrong About the World. And Why Things Are Better Than You Think" by Anna Rosling Rönnlund, Hans Rosling, and Ola Rosling 2. Hans Rosling TED talks: 2.1. ua-cam.com/video/hVimVzgtD6w/v-deo.html 2.2. ua-cam.com/video/Sm5xF-UYgdg/v-deo.html 3. "The Psychology of Money: Timeless lessons on wealth, greed, and happiness" by Morgan Housel 4. "Unfla...
4 reasons why you may HATE BEING a Data Scientist, but LOVE DOING Data Science
Переглядів 36 тис.3 роки тому
There are so many different flavors of Data Scientists, the name of the role and responsibilities depend so much on the company and their level in the Data Hierarchy of needs. (medium.com/hackernoon/the-ai-hierarchy-of-needs-18f111fcc007) But, I've noticed that to get into Data Science and Analytics field, the best mindset you could have is "I want to do Data Science" rather than "I want to be ...
We also need to talk to the employment service, the social security office, etc. why it is still very mildly said completely mathematically impossible to earn a living in the country full time and it has not improved over the decades. Fredrik
when are you posting again! hope you are doing well wherever you are
I failed an interview last week because I was nervous and didn't talk about my previous projects in a logical way. I'm looking for the solutions now. This is really helpful for me! Thank you so much for sharing!
1U$D = 10SEK 10 = 100 100 = 1000
Can you make a video about how it felt when you had just graduated?
Ur very beautiful ma'am
Very Informative
Is it very hard to bear the lack of sunshine in Sweden ?
yes :(
@@AnastasiaKVL 😥
Hi Ana! Thank you for making an informative video. I am planning to do my masters in Sweden and hence I have been looking for the job market and salary expectations in Sweden for quite a while and finally this video popped up and gave a lot more clarity about everything.
hello Pretty Wonderful Anastasia and Family Whatever happen you know. ❤,,,❤,,,❤,,,
Thank you! This was really helpful.
🚀 **Beware these 2 Silent Killers of PMO Success!** 🚀 🥷Navigating #PMO setup can be fraught with hidden dangers like overwhelming tasks, conflicting priorities, constant firefighting, and lack of clear direction. 🥷The quest for seamless integration across functions like #engineering, #finance, and #marketing adds another layer of complexity. 🔑 **Unlock PMO Excellence** 🔑 💡Hit the ground running by leveraging real-world experience. 💡Avoid reinventing the wheel with our blend of scientific frameworks and proven best practices. 💡Get the most comprehensive guide on PMO Pillars, PMO Integration, PMO Knowledge Management, and PMO Leadership. 🌟 **Why Choose Project Management Office From Basics to Brilliance Course?** 🌟 📕134 focused lectures, 📕7.5 hours of content, 📕500+ slides, and 📕400+ practical questions await! 🎉 **Special Offer on Udemy** 🎉: Transform your PMO approach from basics to brilliance! 🔖 Original $89.99, now just $36.99 for the first 100 enrollees! Don’t miss out! ⏳⏳⏳ 👉Secure your spot: www.udemy.com/course/pmaas-pmo-mastery/?couponCode=PMO100SEATS3699 #ProjectManagement #PMOIntegration #Leadership #UdemySale #PMO #ProjectManagementOffice #EnterpriseIntegration
Please, continue! We are waiting for you!
How much taxes do Swedish pay for free education?
Very informative
Really good video 👍👍
watching this video 2nd time. Really great and simple explanation, yet covering mostly every aspect from a product perspective. Thanks a lot.
Many thanks Anastasia for this nice, well-structured, and highly informative video. I am a Flutter developer too and it would be nice if you add your LinkedIn link to get connected
Damn! USA remains the best - concluded after watching this video :D
😫😳😕omg not what I thought it was! Sounds like a massive headache. A rabbit hole into merging with Artificial Intelligence. jeez how do humans live like this? Typical Reply “I actually enjoy some aspects of it, I like it “ 🤥
Thank you for the video, Anastasia!
how about that?
1800SEK for me and cat per month, I dont eat out.
Hi I need some help if you live near kth about accommodation please let me know how to do is wise
hello which editing software, camera and mic do you use? The quality is amazing
С удовольствием посмотрел видео. Сам мечтаю релоцироваться в Швецию. Осталось подтянуть английский и можно смело идти продакт дизайнером в компанию)
Hello Anastasia! As a Data Scientist I admire you and love your UA-cam channel. I wanted to ask you if by any chance you know a company in Sweden that's willing to give a job permit when hiring people, or in any case open to worldwide remote opportunities. I'm looking forward to moving there, hopefully soon :) it's been a bit rough because I know some companies offer these for more experienced roles only. Any suggestion or advice would be much appreciated!
Hi Anastasia, Thanks for sharing this very informative video. How is the job market in Stockholm for recently certified Full stack developers and data scientists with an advanced degree such as MBA?
in sweden
Hi Anastasia can you tell me which university is good to do MS in data science since i am an it professional can you please suggest
Been testing it for a month or so. 3.5 does a decent job better than Bard. Wil need to test version 4 i.e paid version. But its helpful if you go through the fundamentals of SQL the HARD WAY. That way you will be able to spot mistakes. This AI is meant to assist and replace humans
why did not u give upload or copy paste the sql table data of both the table and u can ask the details of order between two consecative events .. so it would have made more sense ... i think ...
I like doing research but i hate to become Excel master. I like programming and i want to make something i can use. Just more management oriented than just backend-programmer
You not even need to write queries , Vinchi modal can generate result on the basis of natural language processing like " give me the average salary from table 1" 😅🥲
Нормально, так, Настя английский прокачала!
I worked in Stockholm in the 70/s as a car mechanic and assembling furniture to set up new offices. I already spoke Swedish. Then I came to California and started a software company. "Pacific Software" a DBA in L.A. County. I still run that and I have ran that remotely from Stockholm and Helsinki, both. My old Personnummer was no more, which I discovered trying to get DSL back then. I suppose they'll give me a new one. I am a Finnish citizen. California is no longer what it once was. I have ran onto corruption with no recourse. Many of my friends have left. So, I am looking around.
5:58 - none of the EU citizens need to apply for a work permit in Sweden. The only thing which an EU citizens need to have is a valid EU passport. EU passport = residence permit. One more matter required to acquire is a personnummer. That's basically it, what's needed for an EU citizen. I myself moved to Sweden being an EU citizen and lived in couple of other EU countries being Latvian citizen. It's like that in every EU country.
Thanks for your videos. I have a question... if I accept an offer that I know is lower than the range for that position, in how much time would you say that I would be able to renegotiate it?
Bonjour, quel est le salaire minimum en Suède 🇸🇪 ??? Merci
Thank you so much Anastasia for this content, I love it! 👩🏻💻💖
I lived in my van in Stockholm, but usually spent the night at a girlfriend's place.
Hi Anasthasia do you teach data analysis? I’m interested to learn in case if you do.
Very insightful and informative! I learned a lot. As a new comer HR professional in Stockholm, the labour law is quite vague. Thanks for the tips!
Hi girl! Long time no see, so glad to see you back! Great video, funny but I never actually used big query, so that’s a great motivation to try it out. A lot has happened since your last video, I was able to get my first data analyst job thanks to you and your advices which helped me feel more sure of myself 🎉 Hope to see you here regularly
Amazing! Very happy for your new job, hope it all goes well :)
well summarized thanks!
So finally our dear sister is back. 😊
Excelente video 😋
You can ask it some pretty complicated questions, don't be fooled. This thing will be able to teach calculus to a 2nd grader once it's able to use formulas and graphs etc. Everyone needs to approach it with clear intentions to get what they need, just in general.
Such an insightful video, Anastasia and the rest of your SQL videos as well. I have been doing a lot of analysis work using SQL lately and it's definitely not my strongest suit but this was such a great refresher. These functions are basically what we need and use on a daily basis. Really appreaciate the time and effort you have invested. :)
Great to see you back streaming!