[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.

This is the second in-depth course on Microsoft Power BI that will help you analyze and explore data more effectively by applying various visualization techniques. Through this course, you will be able to accurately understand the data modeling work and relationships in Power BI and grasp various concepts that you must know to effectively utilize DAX.

Is your Excel work complex and time-consuming? Excel, essential for office work [VOD] Discover Excel Functions and Macros (VBA Code) using Chat GPT. It will be a reliable assistant for your Excel work.

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!

You use 'pivot tables' a lot for data analysis, right? However, Excel provides various analysis tasks that are suitable for the situation in addition to pivot tables. In this lecture, we will organize Excel analysis tasks in 10 ways (sorting, subtotals, pivot tables, pivot charts, target value search, data tables, scenario managers, integration, advanced filters, conditional formatting)

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. :)

Using pandas, we will learn data processing patterns that frequently appear in real-world situations and analyze the processed data.

Learn Pandas' core features, comparing with SQL!

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!

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.

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 course, you can learn SQL and database fundamentals, SQL syntax, database design for practical applications, database utilization through programming, and data analysis use cases.

Excel VBA helps you use Excel faster and more efficiently. Now, learn VBA to spend your free time at work. For web data collection, please refer to this course: https://www.inflearn.com/course/python-crawling#

Based on the instructor's own failed experiences when first learning machine learning, this is a newly designed course that differs from existing lectures, making it easy to understand machine learning and apply it to real-world problems

We guide non-majors and beginners to quickly obtain the Big Data Analytics Engineer practical certification! Theory lightly, practice thoroughly - even without complex background knowledge, we focus on learning only the essential points that appear on the exam, centered around past exam questions.

Covers how to properly use the new game-changer "ChatGPT" for "Excel utilization." You can learn to create Excel formulas for practical use, easily grasp Excel functions, and write macros and VBA code using ChatGPT.

Time Series: Become a Data Analysis Expert! Let's be analysts strong in theory & practice!

A class on analyzing customer/sales data with Excel, even without R or Python!

You can learn the skills and know-how needed to improve work efficiency by utilizing Open API and Python.

Through this course, learners can develop the ability to obtain a Computer Application Skills certification. This course is structured according to the examination standards as a preparation course for acquiring the Computer Application Skills certification. You can learn and apply basic knowledge of Computer Application Skills subjects to prepare for certification acquisition. (Computer Application Skills Level 1 & 2 Written Exam - Spreadsheet General)