[Episode] Excel + Python (Basic)

A current professional data analysis instructor at a large company who passed the Big Data Analysis Writer and Practical exams in one go will help you prepare quickly by summarizing the key points.

The easiest explanation of R-based data visualization📊. (Almost) everything you need to know😎. At the end, we will plot COVID-19 💉vaccine vaccination data on a map🗺️!

A friendly R class from a professional instructor who teaches data analysis for over 1,000 hours a year! We've renewed the existing lectures and will also inform you of the latest trends.

Quickly pass the Comhwal Level 1 written exam with Wang Dumo Saem, who has 20 years of experience. Only study the Dumo keywords that frequently appear on the exam! Wang Dumo Comhwal

As you learn how to use functions with detailed explanations and practical examples, you will experience that functions become fun and easy to use, that your work efficiency will increase as you apply functions to your work, and that functions will no longer seem difficult, making Excel easier.

You know the importance of 🔥Big Data🔥 in your business, but you gave up on data analysis tools with difficult names like Python, R, SQL... before you even started? Don't worry anymore 😉 A beginner's course that teaches anyone how to analyze data and discover valuable insights using Excel, which is highly accessible!🎁

Are you using Excel well in your work? Small tips for Excel can help you reduce mistakes and increase work efficiency! In this course, we will carefully select 16 useful Excel tips and explain them in detail.

Learn Pandas' core features, comparing with SQL!

Statistics learned in school, was it too hard to understand? No matter how much you listened to the explanation, statistics were confusing, but we will help you understand them. If you implement them one by one by hand using Excel, you will understand statistical concepts that you didn't understand! A new experience that makes boring statistics fun! We will give you a gift. :)

This course is a course that practices the basics of machine learning mathematics and statistics using Python. Machine learning and deep learning require programming skills, but they also require a mathematical background to understand the principles. Through this course, you can gradually learn the basic mathematics required for artificial intelligence.

Unlike existing lectures, this course has been newly designed based on the instructor's initial failures in learning machine learning, enabling easy understanding and application to real-world problems.

Even those with no coding experience can automate Google Sheets and Apps Script tasks! I will teach you the easiest way by creating examples that can be used in actual work.

Even complete beginners who don't know anything about Excel are OK! Just follow the lectures and you can get an A grade in ITQ Excel.

Analyzing customers, markets, and revenue patterns—you no longer need to learn it yourself. Just ask AI, and expert-level analysis and strategies are completed in an instant!

Learn Macro VBA with Excel 2019!! However, you can also practice with 2016 and 2013 versions. Macros and VBA fill in the gaps that Excel alone lacks.

Is it possible to automate Excel without uploading company data? AI utilization secrets revealed that maintain security while reducing work hours!

This course focuses on developing practical visualization skills that can be immediately applied in the workplace by utilizing Seaborn, a core tool for data visualization, and plotly/Dash for building interactive dashboards. Through various hands-on exercises, you can enhance both your ability to create insight-driven visual materials and implement web-based dashboards.

Through this lecture, you can learn about understanding SQL and databases, SQL syntax, database design for practical application, database utilization through programming, and even data analysis application cases.

Building Your Own Data Analysis Portfolio with Free GEMINI CLI Vibe Coding Data Collection, Analysis, Reports, and Dashboard Creation for Work Automation Even if you're new to data collection, by learning the principles, prompt writing methods, and VSCode usage, you can perform data collection, analysis, visualization, reports, and dashboard creation like a data analyst. From Python Data Collection to Analysis Report Writing with GEMINI CLI and VSCode Prompt Writing and Error Resolution Methods for Foolproof Data Collection and Analysis

In Part 3 of Creating a Python Trading Room for Quant Investment, you will learn about portfolio theory and concepts necessary for real investment, as well as how to implement them with code. In Parts 1 & 2, you mainly learned about code implementation methods for analyzing financial data, and in Part 3, you will learn about 'portfolios', which are an important part of quantitative investment. With the question of why you should create a portfolio, you will learn portfolio theory, implement it in Python, and practice the code necessary for real portfolio investment. I hope this lecture will be helpful for your own portfolio investment.

Finally, the Probability and Statistics course for everyone is here! Learn the principles of probability and statistics step by step through theory and coding practice. Reference book "Probability and Statistics for Everyone" https://wikidocs.net/book/18165

I will guide non-majors and beginners to quickly pass the Big Data Analysis Engineer practical exam! Theory lightly, practice thoroughly. Even without complex background knowledge, focusing on past questions, we intensively study only the points sure to appear on the exam.

Learn NoSQL technology, which can handle Big Data, one of the fundamental technologies in full-stack and data science utilized by modern startups. MongoDB is the easiest and quickest technology to utilize among NoSQL databases. In this lecture, you will learn the basics of MongoDB in a short time, and also acquire the skills to manipulate and utilize MongoDB with Python.