Create an at-a-glance visualization dashboard as a spreadsheet

Beginner
4 chapters · 2 hours 44 minutes
English · Japanese · Korean|Audio Korean

Check out what classmates have to say!

Skills You’ll Learn

Creating a visualization report template via DB

Input (DB) introduces the Output (visualization report) process

One-page spreadsheet visualization report

I will introduce all the interaction visualization materials on the page so that they can be seen at a glance

High quality visualization reports through LookerStudio

Here's how to easily create visualization reports with LookerStudio

About the class


Are you working by creating meaningless data tables in spreadsheets?

We need to create visualizations we want to see, not visualizations we want to see.

Hello, I'm Benny, and I've collected only the best technology from my 5th year of experience in a startup.

Everyone uses data in their heads to create wonderful results.

Now not only experts can do it, but I will help you become an expert right away through this course. A spreadsheet is a basic DB (database) format, but I'll tell you the know-how I've gained from practice so that I can easily view only the data I want to see in the DB as visualization data so that I can easily eat it.

It's definitely very easy to make, even for beginners who haven't used Google spreadsheets, and I'll teach you in detail from the basics by explaining them in easy to understand words rather than difficult words.

Course effects


  • Instead of a messy list of data, you'll be able to create reports through visualization.

  • Instead of visualizing fixed data, it will be possible to create visualization data through conditions (period, product, etc.).

  • Instead of metrics you need to see, you can create visualization data that makes people want to see it.

Recommended target


  • Those who don't know what data to use for visualization

  • Those who want to use spreadsheets useful in practice at work

  • Those who want to create interactive, responsive visualization reports

Notes before taking the course


  • Currently undecided

3 reasons why this class is special

❶ Classes are conducted based on practical work based on actual experience.

This class is taught based on practical work based on actual experience, and application skills are developed so that they can be used even in current jobs after taking the course.

In actual practice, it is not as simple as the condition “when A is B, it is C”. There are countless A's, and there are also various B's. In this class, lessons are taught based on various conditions, and various examples from creating inputs and outputs. Through this class, you can learn methods that can also be used in practice.

<Insert 2 or more images or videos>

  • The images should focus on the results after creating the class.

  • If you would like to add a personal portfolio, please fill in the details below.

  • Example) Chapters 1-3. Portfolio creation example image

❷ Create a single report through an actual spreadsheet.

As if it were “1+1=2,” a class is linked to all lessons. However, there is an attachment that you can easily follow without listening to an intermediate course. Every course is linked, so if you listen to and follow the course, you'll develop the ability to create great spreadsheet reports.

The advantage of spreadsheet reports is that they can create visualization data of the data you want to see through real-time integration and interactive actions (interactions). Through this class, you'll learn how the data you want to create is implemented in basic raw data.

<Insert 2 or more images or videos>

  • The images should focus on the results after creating the class.

  • If you would like to add a personal portfolio, please fill in the details below.

  • Example) Chapters 1-3. Portfolio creation example image

❸ Introducing 'Google Looker Studio', a professional reporting tool.

I'm sure some of your classmates are hearing Google Looker Studio for the first time.

It has professional report forms and environments, and is a tool that is more specialized in data visualization. It can also be linked with Google Spreadsheets, so you can create wonderful visualization materials by linking with a DB (database) based on a database (database). I highly recommend it if you want to use designs and luxurious forms that don't lack data created by me in a really professional business. This class will be a great class that will broaden your expertise and data visualization horizons.

<Insert 2 or more images or videos>

  • The images should focus on the results after creating the class.

  • If you would like to add a personal portfolio, please fill in the details below.

  • Example) Chapters 1-3. Portfolio creation example image

Class Kit · Coaching Session

외주 작업에 도움이 될

베니의 스프레드시트 템플릿을 소개합니다.


[템플릿] 직접 진행하고 경험한 내용을

정리한 외주 작업 스프레드시트 템플릿

기획은 외주 작업에 가장 중요한 역할입니다. 제가 작업을 진행하며 직접 기획하고 제작하였던 스프레드시트 템플릿 3종을 바로 볼 수 있는 PDF 파일로 제공해 드립니다.


🚩런칭 프로모션

2023년 12월 6일 (수) ~12월 31(일)까지

판매가 30,000원 -> 20,000원에 구매하실 수 있습니다.



스프레드시트 외주 작업 가이드 템플릿


📋 쉽게 참고할 수 있도록 외주 작업에 내용 로그와 진행한 이력에 대하여 알기 쉽게 정리해두었습니다.


🏥 병원 운영 관리

병원 진료 및 청구 관리를 스프레드시트로 진행하는 고객님의 요청으로 청구에 대한 결제를 월 단위로 진행하고 있는 조건을 확인하여 결제 대금 산출과 메시지를 쉽게 보내기 위한 외주 작업을 진행하였습니다.


image.png

청구가 되기 위한 금액 산출 조건과 메시지 조건을 반영하여 사용자가 쉽게 반영할 수 있도록 특정 셀에 특정 메시지를 기입하여 호출하여 출력되는 조건으로 해당 작업을 진행하였습니다.

🎵 음악 학원 상담

다양한 지점을 둔 음악 학원에서 본사 영업으로 상담 요청이 온 고객을 종이에 적어서 관리하는 것이 아닌 전산화 작업의 기반을 두어 구글 캘린더 연동까지 한 번에 할 수 있는 상담 관리 내역을 진행하였습니다.

image.png


버튼을 통해 개발 코드로 상담 내역을 전산화하여 관리할 수 있도록 제작하였습니다.


💪🏻 헬스장 운영 관리

지점 2개를 운영하는 헬스장 대표님의 요청으로 제작하였으며, 일일 단위로 기록하여 누락되는 부분과 매출 그리고 직원과 마케팅의 성격을 관리할 수 있는 시트를 요청하여 제작하게 되었습니다.

image.png

외주 작업을 시작한 이후 가장 처음 작업했던 외주 작업으로 아직도 생생하게 기억이 남기도 하고 위 다른 외주 작업 건들 과는 또 다른 수작업이 많이 들어갔었던 작업입니다.

이런 분들께 추천합니다.


1. 외주 작업을 시작하고 싶은데, 막상 시작하면 어떤 것을 하게 될지 짐작조차 가지 않는 분

2. 실제 작업물의 형태가 궁금하신 분




상품 구성을 소개합니다.

  • 파일 정보 : PDF 파일 3개 (병원 청구 관리 / 음악 학원 상담 관리 / 헬스장 운영 관리)

  • 추가 정보 : 각 PDF에는 사용할 수 있는 스프레드시트 링크가 있어 복사할 수 있습니다.

  • 총 페이지 수 : 23페이지 (PDF 1개 기준 7~8 페이지가 있습니다.)




🚚다운로드 상품 관련 안내 입니다.

  • 다운로드 상품은 다운로드 이후 환불이 불가합니다.

  • 단순변심으로 환불을 원하시는 경우 다운로드를 받지 않으신 경우에만 7일 이내 가능합니다.

  • 다운로드 파일은 구매 후 마이페이지 > 주문 및 배송 탭에서 다운로드가 가능합니다.

🚚 다운로드 상품 저작권 안내 입니다.

  • 문서 전체 및 일부 상업적 사용이 불가합니다.

  • 원본 문서 재가공 및 공유 불가합니다.

  • 재판매용 배포를 금지합니다.

  • 본 자료는 저작권법 등 관련 법령에 의하여 보호되는 지식재산으로 이를 무단으로 복제, 공중송신, 전시, 배포 등의 방법으로 사용할 수 없습니다. 만일 이를 위반하는 경우 관련 법령에 따라 민형사상 책임을 부담할 수 있습니다.

Curriculum

Creator

Benny

Benny

My name is Benny, who has 5 years of experience as a general secretary, and is in charge of management planning/strategy.

In order to personally learn about the rapid growth of startups, I learned about society by bumping into databases one by one. Personally, I had a strong desire for work, and I learned about spreadsheets because I had a strong desire to learn about useful things. There are parts that were awkward and sloppy, but currently I'm helping stakeholders make decisions with my spreadsheet ability to create data that must be viewed rather than data they want to see. Spreadsheets have a myriad of data separated into rows and columns. What kind of output these rows and columns produce is really limitless.


We hope that they will learn endless abilities together through spreadsheets and improve their own value by challenging themselves from practical work to outsourcing who can sell individual abilities. This class will broaden your perspective on the industry and sharpen your mind.


We wanted to reduce difficult words and theories that were difficult to understand as much as possible, and worked hard to prepare explanations and quick understanding based on practical experience.

View similar classes you might also like

Spreadsheet basics: Analyzing data with conditional dashboardsOffice Productivity  |  Benny

Notes on Copyright Protection

  • All videos and materials included in the class are protected intellectual property under relevant laws.
  • You may face legal action if you copy, distribute, transmit, modify or edit the videos or materials included in the class without permission.
CLASS 101, LLC.
1201 North Market St. Suite 111, Wilmington, DE, 19801
support@101.inc