인프런 - 라이프타임 커리어 플랫폼

Even non-majors can easily complete the 【Data Analysis-Tailored Basic Python】 course! Learn the basics of ChatGPT utilization together to create a 『starting point』 for data analysis and AI utilization. From essential prerequisites for data analysis, learning in a customized way from a 『Data Analysis Instructor』 allows you to build deep fundamentals while learning quickly, instills the courage and confidence needed for coding learning, and even suggests future directions for data analysis learning.

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

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 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!🎁

Stop using Excel based on difficult functions, and learn how to use advanced Excel functions with just a few clicks! Effectively learn advanced Excel functions that are highly useful but unfamiliar, and acquire work automation, data preprocessing, data modeling, and advanced visualization capabilities all at once, and raise your data analysis level!

This is an in-depth course on Microsoft Power BI that allows you to analyze and explore data more effectively by applying various visualization techniques. Through this course, you can learn how to connect various data sources, refresh data in the way you want, and learn various data preprocessing methods to edit data in a form suitable for analysis.

Learn Excel Power Pivot to analyze large amounts of data in a high-performance environment. Excel Power Pivot is a powerful advanced data analysis tool in Excel that allows you to connect various data sources to build a data model and perform advanced analysis using DAX.

Automate complex tasks in a snap! Excel macros and VBA, from basics to practical use!

Automating data scraped from the web using RPA to visual analysis in Excel.

Through the synergy of Excel and generative AI (ChatGPT), this practical, hands-on training covers the entire spectrum including data aggregation, cleansing, visualization, report writing, template automation, code-free schedule creation, VBA automation, and Google Sheets integration, designed to enable learners from Excel beginners to intermediate users to develop skills that can be immediately applied in real-world work through step-by-step learning.

Now you can use Python in Excel! A light lecture to try out the latest features!

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.

Learn how to aggregate and analyze data using PivotTables in Excel 2013.

Learn how to use Power Query, an add-in to Excel, to analyze large amounts of data more quickly and efficiently, and automate repetitive data tasks.

This course is a hands-on course in which you will find statistical data needed in the workplace, download it yourself, and create charts (graphs).

Team leaders, you say, if you give me an Excel file, I have to look at it one by one? Can't you organize it so that it's pretty and easy to see at a glance? I'm busy organizing and analyzing data, but when will I edit it nicely? When that happens, you think, how great would it be if there was a magical tool that visualizes the Excel data I organized beautifully? Yes, there is. Power BI, a magical tool created by MS. It's a simple visualization tool that makes it easy to see the Excel data you created at a glance, and once you create it, it's continuously updated and used later! We'll tell you very, very easily and kindly what the program is and how to use it!

This course provides 100% hands-on experience by explaining which functions and features of Excel can be used to solve tasks most quickly and efficiently in these cases through examples used in actual workplaces.

As you follow along with fun, you will naturally learn the basic concepts and techniques. You will be able to easily create visualization tools that are accurate, clear, pretty, and attractive. You will naturally understand the features and advantages of each from Excel 2007 to 2016, and learn what advantages and disadvantages they have. You will learn how to make the impossible in Excel indirectly.

Are you wondering which tool to use for data analysis? Get started easily with Excel!

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