The beginning of data analysis, data preprocessing!
Easier with PowerQuery.

📖 Data analysis results depend on data preprocessing !

Data preprocessing can be considered the most important part of the data analysis process in that it determines the quality of the data . Data analysis results derived from incorrect data cannot be considered accurate , and this leads to missing meaningful insights .

 

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

-         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 with ease, it is no longer difficult .

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

That's why 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 worker with turtle neck 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

Masocampus ' < Data Analysis Preprocessing Practice - Power Query > is easy and requires only a few clicks and no coding.
This is a lecture to learn 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 capabilities to analyze data!

If I focus only on skills , I will eventually have difficulty applying 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 properly utilize them 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 the < Data Analysis Preprocessing Practice - Power Query > lecture at Maso Campus ,

You can start applying data analytics straight to your 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 expert in data analysis You can approach it .

📚 Learning Contents

 

💬  Expected Questions Q&A

Q. Is prior knowledge of Excel or data analysis required ?
A. < Data Analysis Preprocessing Practice - Power Query > is an advanced Excel analysis course, so if you have basic understanding and knowledge of Excel or data analysis, you can take the course relatively easily . If you want to learn the basics of Excel usage first, we recommend taking < Introduction to Practical Excel Usage for Immediate Use > .

Q. Are there any requirements or prerequisites for taking the course ?
A. Since this is a hands-on lecture, it would be a good idea to prepare a dual monitor or extra device that can separate the lecture and practice screens . Also, since the practice is conducted based on Windows OS , we recommend taking the lecture in a Windows environment .

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

✒ ️ Introducing the knowledge sharer

✔️ Please check before taking the class !

-         Since this is a hands-on lecture, it would be a good idea to prepare a dual monitor or an extra device that can separate the lecture and practice screens . Also, since the hands-on training will be conducted on a Windows OS , we recommend taking the lecture in a Windows environment .

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