inflearn logo

Data Analysis Essentials (Power Query + Tableau + Dashboard Planning) in Just 4 Hours

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

(5.0) 1 reviews

51 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

This course was created in 2023. The Tableau interface may look a little different from the current version.

You're already busy with work, so when can you learn data analytics? 🤔

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

According to Google's Hal Varian, the ability to work well with data means processing data, extracting value, and visualizing it, and using it to communicate. If you already have extensive domain knowledge in your field, your ability to find value in data will be better than anyone else’s. However, you may lack the ability to preprocess and visualize the data itself.


Even so, organizations tell you to learn data.
You're already busy with your day job, so when can you learn SQL and build dashboards?


STEP BY STEP: Data Analysis for Everyone + Design Thinking Dashboard Planning is a course where you can quickly and easily learn the essential skills for solving problems with data in just 5 hours: 1. Data Preprocessing, 2. Data Visualization, and 3. Communication.

In this course, you will learn how to preprocess data using Excel’s Power Query and visualize data with Tableau. You will also learn the design thinking planning methodology to plan dashboards that meet real needs based on user research. After completing the course, you will be able to apply the tools and planning methodology you learned to a real-world scenario and develop an impressive dashboard.

Features of This Course

📌A course covering every step of data analysis, from preprocessing to visualization

📌A data analysis course you can take without coding

📌 A course that teaches you to select and create appropriate data visualization charts based on data characteristics and analysis objectives

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

📌 A course that condenses the essential steps of data analysis into just 5 hours

📌A course you can access for life and that is updated regularly


Recommended for these people

I want to extract big data.
For those whose organizations encourage data-driven work but who don’t have enough time to learn new tools.

I want to build a dashboard.
For those who find chart analysis difficult but want to use data to create polished reports or dashboards.

I want to get a quick overview of data analysis
For those who want to learn the fundamentals of data analysis over a short weekend.

After completing the course

  • You can easily work with over a million rows of data in Excel.

  • Even if you don’t know SQL, you can preprocess data.

  • You’ll be able to develop and design appropriate data visualization charts for reports, dashboards, and data analysis goals.

  • Using a systematic planning methodology, you can plan dashboards, report on your findings, and present them.

  • If you can access data within your organization, you’ll be better equipped to make use of that data environment.

Learn these things.

What should you learn to become good at data analysis?

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

How to preprocess data when you don’t know SQL

In this course, you’ll learn how to preprocess data without SQL, using Excel—a tool you’re already familiar with—to perform the same tasks as SQL. Extract the data you need, even from datasets with over one million rows, and analyze it easily in Excel!

How to communicate data more efficiently

Tableau is a tool already adopted and used by many companies. However, beginners may find it difficult. In this course, you’ll learn how to create and design charts in five different types of data visualization, simply by following the lessons step by step.

How to communicate using data

A dashboard is one of the most efficient ways to communicate the findings of data analysis. However, a conventional data-analytic approach fails to consider users, ultimately resulting in a dashboard that will be forgotten. Apply the design thinking problem-solving method to plan a dashboard for users!

The person who created this course

  • Graduated from the Department of Social Sciences; Ph.D. in Design.


  • Data Analyst at a Large Corporation’s Affiliate


  • Numerous papers on user data analysis and design research published in academic journals


  • Creating blog and social media content for Desearch Lab


Things to Know Before Enrolling

Practice Environment

  • The course is taught using macOS, but you can follow along on Windows using the same interface.

  • The course uses Excel. If you have Excel 2016 or later, you should be able to follow along without any problems.

  • The course uses the free version, Tableau Public. We’ll walk you through the installation process first.

Learning Materials

  • It will be provided via Google Drive.

Prerequisites and Notes

  • It would be helpful if you have experience using Excel at work.

  • This may be more useful for those who work at companies with data teams.


Recommended for
these people

Who is this course right for?

  • A working professional who wants to extract data from big data

  • An office worker who wants to try working with more than a million rows of data in Excel

  • All roles interested in Tableau

  • For those who want to add impressive charts to their reports using the free version of Tableau

  • Everyone who wants to learn data visualization

  • People at companies that have adopted Tableau but don’t know how to use it.

Need to know before starting?

  • Excel

Hello
This is Thinknod Lab

In an era where data and AI tell us everything, what is your real weapon?

Hello, I am Thinknod, a researcher and designer of 'Problem-Solving Thinking' in the face of uncertain, real-world work environments where there are no right answers.

The real problems (Wicked Problems) we face in the field cannot find their own way, no matter how powerful the data and latest AI tools are provided. What is more important than the skill of handling tools is a solid thinking system that deconstructs problems and builds conclusions on its own.

At thinknod.ai, we break down massive problems into the smallest units called 'Thinking Nodes' and transparently share the 'trajectory of thought' that relentlessly solves problems by repeating expansion and convergence across three states: Diagnosis, Strategy, and Execution.

Rather than a simple explanation of features, we share the most practical operational manual on how to break down the problems you face at work today, which tools to open, and what kind of results you need to produce.

More

Curriculum

All

76 lectures ∙ (4hr 34min)

Course Materials:

Lecture resources
Published: 
Last updated: 

Reviews

All

1 reviews

5.0

1 reviews

  • halee3081님의 프로필 이미지
    halee3081

    Reviews 2

    ∙

    Average Rating 4.5

    5

    100% enrolled

    Similar courses

    Explore other courses in the same field!

    25% off for new members

    $16.40

    25%

    $26.40