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

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

(5.0) 1 reviews

39 learners

Level Beginner

Course period Unlimited

Chart Analysis
Chart Analysis
Big Data
Big Data
Tableau
Tableau
Chart Analysis
Chart Analysis
Big Data
Big Data
Tableau
Tableau

What you will gain after the course

  • 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 Thinknod Lab

The Architecture of Business Persuasion, Thinknod

"In the face of problems without answers, we turn persuasion into the right answer."

By combining the research of a Ph.D. in Design with the practical logic of a working BI Lead, we propose a persuasion framework based on empathy, form, and logic that goes beyond simple tool usage to pierce the essence of a problem and move your audience.

🎓Expert Introduction

  • Ph.D. in Design

  • Active Data Analyst · BI Lead

  • Tableau Ambassador (2x) · Seoul Tableau User Group Leader

  • Tableau DataFest Presentation

     

🚀The value proposed by Thinknod

  • [Empathy] Data storytelling that opens the minds of decision-makers.

  • [Logic] A seamless analytical framework built with data.

  • [Form] The technology of materializing ideas into persuasive realities.

More

Curriculum

All

76 lectures ∙ (4hr 35min)

Course Materials:

Lecture resources
Published: 
Last updated: 

Reviews

All

1 reviews

5.0

1 reviews

  • halee3081님의 프로필 이미지
    halee3081

    Reviews 1

    Average Rating 5.0

    5

    100% enrolled

    Similar courses

    Explore other courses in the same field!

    $26.40