강의

멘토링

로드맵

Inflearn brand logo image
Data Science

/

Data Analysis

Data Analysis (Power Query + Tableau + Dashboard Planning) Core 4 Hours

Data preprocessing + data visualization + dashboard planning = data-based problem solving

(5.0) 1 reviews

26 learners

  • Desearch Lab
tableau
데이터분석
차트분석
Chart Analysis
Big Data
Tableau

What you will learn!

  • Data preprocessing

  • Data Visualization

  • Communication

  • Data Analysis

  • Power Query

  • tableau

  • Tableau

  • Design Thinking

[2nd update scheduled for September, 3rd update scheduled for October]

I'm busy with my work, so when will I learn data analysis? 🤔

If you've ever thought this way, you've come to the right place.

According to Google's Hal Varian, data literacy is the ability to process data, extract value from it, visualize it, and communicate it effectively. If you already have extensive domain knowledge , you're likely to excel at extracting value from data. However, you may lack the ability to preprocess and visualize the data itself .


Even in this situation, organizations are told to learn from data.
I'm busy with my work, so when will I be able to learn SQL and develop a dashboard?


STEP BY STEP Data Analysis + Design Thinking Dashboard Planning Method for Everyone is a lecture that allows you to quickly and easily learn 1. data preprocessing , 2. data visualization , and 3. communication skills essential for solving problems based on data within 5 hours .

In this course , you'll learn how to preprocess data using Excel's Power Query and visualize it using Tableau . You'll also learn how to plan truly essential dashboards based on user research using the Design Thinking planning methodology . After completing the course, you'll be able to develop stunning dashboards based on real-world scenarios, building on the tools and planning methods you've learned.

Features of this course

📌 A course that covers all the steps required for data analysis, from data preprocessing to visualization.

📌 Data analysis course that you can learn without coding

📌 A course that allows you to select and develop appropriate data visualization charts based on data characteristics and analysis purposes.

📌 A course where you can learn Excel Power Query and Tableau.

📌 A 5-hour course that condenses the essentials of data analysis into a single, comprehensive course.

📌 Courses that can be kept for life and are updated periodically

📌 Open chat room provided for students

I recommend this to these people

I want to extract big data.
Those who encourage data-driven work in their organization but lack the time to learn new tools

I want to develop a dashboard.
Those who find chart analysis difficult but want to create reports or dashboards using data

I want to quickly look at data analysis
Anyone who wants to learn about general data analysis during a short weekend

After class

  • You can easily handle data exceeding 1 million rows in Excel.

  • Even if you don't know SQL, you can do data preprocessing.

  • You can develop and design data visualization charts suitable for reporting, dashboards, and data analysis purposes.

  • With a systematic planning methodology, you can plan, report, and present dashboards.

  • Having access to data within your organization enhances your ability to leverage that data environment.

Learn about these things.

What should I learn to be good at data analysis?

To perform data analysis efficiently, you need the ability to preprocess data, visualize it, and communicate it.

How we, who don't know SQL, preprocess data

In this course, you'll learn how to preprocess data in a SQL-like manner within the familiar Excel tool, without using SQL. Even in environments with data volumes exceeding one million rows, extract the data you want and easily analyze it in Excel!

How to transmit data more efficiently

Tableau is already a tool adopted and utilized by many companies. However, beginners may find it challenging. In this course, you will learn how to create and design charts for five different types of data visualization, step by step, simply by following the instructions.

How to communicate using data

Dashboards are one of the most effective ways to communicate data analysis findings. However, conventional data analysis approaches fail to consider users and ultimately result in dashboards that are forgotten. Apply design thinking problem-solving methods to design a dashboard that truly engages your users!

Who created this course

  • Graduated from the Department of Social Sciences, PhD in Design


  • Data analyst at a large corporation's affiliate


  • Numerous papers on user data analysis and design research have been published.


  • Desearch Lab blog and social media content creation


Things to note before taking the course

Practice environment

  • The lecture is based on MacOS, but you can also practice with the same interface on Windows.

  • This lecture uses Excel. If you have Excel 2016 or later, you should be able to follow along without difficulty.

  • This lecture will use the free version of Tableau Public. I'll start by explaining how to install it.

Learning Materials

  • We provide it through Google Drive.

Player Knowledge and Precautions

  • This is good for anyone who has experience using Excel at work.

  • If you work in a company with a data organization, this can be very useful.


Recommended for
these people

Who is this course right for?

  • Office workers who want to extract data from big data

  • Office workers who want to handle data exceeding 1 million rows in Excel

  • All occupations interested in Tableau

  • For those who want to add nice charts to their reports with the free version of Tableau

  • Anyone who wants to learn data visualization

  • People who have introduced Tableau in their company but don’t know how to use it

Need to know before starting?

  • Excel

Hello
This is

Data related content for your business and research.
업무와 연구에 활용할 수 있는 데이터 관련 콘텐츠를 제작합니다.

콘텐츠를 만드는 사람 | Desearcher 소개
데이터를 기반으로 사용자의 문제를 해결하는 데이터 분석가입니다. 대학원에서는 디자인을 공부하고, 사용자가 제품이나 콘텐츠를 바라보는 데이터를 수집하고 분석하는 방법에 대해 연구하고 있습니다.
- 사회과학부 졸업, 디자인 박사 과정
- 대기업 계열사 데이터 분석가
- 사용자 데이터 분석 및 디자인 연구 관련 논문 다수 등재
- Desearch Lab 블로그 및 SNS 콘텐츠 제작

강의
단계별로 따라하는 STEP BY STEP 태블로(Tableau) + 디자인씽킹 문제 해결
태블로(Tableau)를 활용한 생체신호 데이터 시각화

전자책
선배가 알려주는 논문 작성의 흐름
데이터 시각화로 배우는 디자인 이론

Curriculum

All

76 lectures ∙ (4hr 35min)

Course Materials:

Lecture resources
Published: 
Last updated: 

Reviews

All

1 reviews

5.0

1 reviews

  • halee님의 프로필 이미지
    halee

    Reviews 1

    Average Rating 5.0

    5

    100% enrolled

    $26.40

    Similar courses

    Explore other courses in the same field!