[A Hundred Words are Not as Good as Seeing Once] SQL Practical Guide for Data Analysis (Free Mini Course)
Datalian's SQL practical lecture with over 10,000 cumulative students and rich online/offline lecture experience.
How is SQL used in practice? Let's become a data analyst who solves problems using real data from Microsoft's Yammer service.
Seeing is believing! SQL & Data Analysis Learn more about practical application ✨
SQL for data analysis, Are you confident in your work?
I learned SQL because I thought it was necessary for data analysis, and I took several analysis classes... 🤔 I learned SQL, but I don't know where or how to use it. If you're not sure how actual service data analysis is done !
Using SQL A taste of real-world analysis.
For data analysis capabilities Learn real-world SQL!
Our goal is to show how to apply it to real work . Utilize and analyze SQL It's about getting used to it.
Attention, these people! ✅
Those who were curious about how to conduct analysis using SQL in actual work
Those who want to experience data and projects most similar to actual work
Those who are wondering how to build practical data analysis skills
So, you need to learn this. 📖
Extracting and processing actual service data using SQL
Real-world data analysis using actual service data
How do data analysts analyze data in the real world? This course is for those who have been curious about how to use SQL to analyze real-world service data . To do so, you need to experience data and projects that are as similar to real-world applications as possible .
In this lecture, we'll work through three projects that use data structured identically to Yammer , an enterprise social networking service, to explore data in a way similar to real-world scenarios. If you're interested in learning how analysts actually use SQL in their work, give this lecture a try!
Closest to practical use!
When taking classes Installing a separate program or No setup required .
My SQL skills in practice How much is it? You can test it.
Through actual service data Data analysis practice You can taste it.
Field Data Analyst, Datarian tells us Bonus points for valuable analysis tips !
As a mini project Have fun learning!
Warm-up - SQL Analytics Training Describes the platform Mode solution for project progress.
Project 1 - Analyzing the Causes of Declining User Engagement We are conducting a project to analyze the causes of the decline in user engagement in Yammer services.
Project 2 - Search Function Analysis Analyze the effectiveness of the search function in Yammer services and suggest improvements related to the search function.
Project 3 - A/B Testing Let's review the results of an A/B test conducted on the Yammer post upload feature. We'll identify errors during the experiment and consider the conditions for conducting accurate testing.
Helpful for learning I will give you the class materials.
This course is a mini-course based on the Analytics Training provided by Mode. The data and analysis used in all three projects are based on materials provided by Mode.
A summary of the three analysis projects covered in the lecture can be found inthe [Analysis] Project Summary (Text Lecture) .
Expected Questions Q&A 💬
Q. Who will benefit from this lecture?
1) Those who are curious about the work of field analysts 2) Those who know they need to study SQL, but don't know why they need to learn it or how to use it. 3) I recommend this to those who are curious about what data actually accumulates in a company and have no idea what they can do with that data.
Q. I don't know much about SQL, and I'm curious about how to analyze data. Can I learn more?
For those interested in analytics but haven't yet studied SQL, we've separated the SQL-related content into separate lectures within each session, allowing you to skip the SQL portion. We recommend starting by skipping the SQL portion of each session and then completing the SQL portion after you've studied SQL.
Q. Do I need to set up any special settings to take the course?
No, there's no need to set up any special settings or install any programs for data extraction. Instead, please take the course in an environment with a good internet connection. If you'd like to study the entire course, including the SQL section, be sure to register on the Mode website.
Q. Is there anything I need to prepare before taking the class?
For a more accurate understanding of the project, we recommend that you carefully read the original Analytics Training materials provided by Mode before attending the lecture.
I didn't expect much because it was free, but I was surprised that it really followed the actual process flow and checked it in detail. I'm really grateful that it's a free lecture.