Data Analysis Preprocessing Practice - Power Query

Data analysis begins with data preprocessing!
Easier with PowerQuery.

📖 Data analysis results depend on data preprocessing !

Data preprocessing is arguably the most crucial part of the data analysis process, as it determines data quality . Data analysis results derived from incorrect data cannot be considered accurate , leading to the loss of valuable insights .

-         What if you want to give gift certificates only to managers in a dataset containing all employee information ?

-         Among them, what if the training period must be at least 3 days ?

-         For those who received their education before 2019 , how about giving them a souvenir instead of a gift card?

A question that every office worker has had at least once , but is difficult to answer.
If you have the ability to handle large amounts of data easily, it is no longer difficult .

Do you feel a gap between theory and practice ?
Not sure if it will work for your actual work ?

So, we at Maso Campus have prepared this .
< Data Analysis Preprocessing Practice – Power Query > that encapsulates all concepts and can be applied immediately.

🔑 Recommended for these people

- Workers in charge of tasks that require important data preprocessing

- Office workers who want to analyze Excel data more easily and intuitively than with functions.

- Office workers who have developed turtle necks due to prolonged computer work

- An office worker who keeps getting off work late due to Excel work

- Employees who want to acquire Excel skills that will be loved by their superiors before joining the company

Maso Campus ' < Data Analysis Preprocessing Practice - Power Query > is easy and requires no coding, just a click.
This is a lecture that teaches you how to use ' Excel ' Power Query, which can intuitively preprocess data .

Automatically collect external data with just a few clicks and freely edit the data as if you were working with clay !

✨ Course Features

No to lectures that only list difficult concepts!

Skills only ? NO!
UP your fundamental data analysis capabilities!

If I focus only on skills , it will eventually be difficult to apply them to my work .

If you fail to develop data collection methods , the need for preprocessing , and analysis capabilities ,
If you fail to internalize your skills, you will not be able to use them properly in your work .

This course is designed to develop ' data capabilities ' rather than skills .

📜 Data Analysis Preprocessing Practice - After listening to Power Query

After taking Maso Campus ' < Data Analysis Preprocessing Practice - Power Query > lecture ,

You can put data analytics into practice in just 12 hours and 44 minutes .

-         Data preprocessing capabilities to collect and organize scattered data

-         Data processing capabilities that can handle data used in practical work

-         Data automation capabilities that allow changes to be applied automatically

With <Data Analysis Preprocessing Practice - Power Query>, you can use Excel, which is most familiar in daily work,
To the data analysis expert You can approach it .

📚 Learning Content

💬  Expected Questions Q&A

Q. Is prior knowledge of Excel or data analysis required ?
A. < Data Analysis Preprocessing Practical - Power Query > is an advanced Excel analysis course. Anyone with a basic understanding and knowledge of Excel and data analysis can take it relatively easily . If you want to learn the basics of Excel first, we recommend < Introduction to Practical Excel Usage for Beginners > .

Q. Are there any requirements or prerequisites for taking the course ?
A. Since this is a hands-on course, we recommend bringing a dual monitor or a spare device that can separate the lecture and practice screens . Furthermore, since the practical training will be conducted on a Windows OS , we recommend taking the course in a Windows environment .

Q. I am a complete beginner in data analysis and have never even tried coding . Is it possible for me ?
A. Of course, you can . In this course, we will mainly use Excel, which is commonly used , rather than complex coding, to develop data analysis skills .

✒ ️ Introducing the knowledge sharer

✔️ Please check before taking the class !

-         Since this is a hands-on course, we recommend bringing a dual monitor or a spare device to separate the lecture and practice screens . Furthermore, since the practical training will be conducted on a Windows OS , we recommend taking the course in a Windows environment .

-         Lecture notes and practice files are located in section 00 .