Did you know? Actually, Shikoku is not rectangular. Neither is your life.

Add this entry to Hatena Bookmarks
shikoku_transition

Putting the Shikoku Shape into Words

Picture the shape of a map of Japan.

In that, yes, for example.Shikoku (smallest of the four main islands of Japan)Let's imagine the shape of

And good luck to those who don't know the shape of the map of Shikoku.Try to explain it in words only.

....... How would you feel if you were told that?

Words cannot describe the "exact form of Shikoku."

Think for a minute what you would say if it were you.

."Rectangular.Or something like. "It has a rectangular shape with bumps.I think the only thing I can say is, "I'm sorry.

Or, depending on who you ask "For the most part.Ellipses.Some people might say, "I don't know.

SEE ALSO. "Shaped like a squashed appleSome might say, "I'm not a fan of that.

There may be many different ways for people to express themselves.

even

I actually have a visual map of Shikoku, There are various ups and downs. There are various ups and downs, here this, there that, and so on,

At that level.The exact form cannot be described in words.

in other words

I think language is essentially the art of summarizing.

Life and Career

Let me turn the subject around.

I think the difference between "life" and "career" is similar to the difference between "the exact shape of a square country" and "a rectangle"!

Life is full of ups and downs, And I am deeply moved by the unique shape of life.

Words to describe it, "Rectangular.All I can say is, "I'm sorry.

Sometimes people are bothered by the fact that my carrier is neither a "circle" nor a "rectangle" and has a delicate shape... but I don't think they need to worry about it.

It is not a shape (career) that is easy to explain to others, such as a circle or a rectangle, but the beauty of a person really lies in his or her unique, undulating shape (life) itself.

I'd rather just have fun and wonder what I should say when I explain it to people.

  • Where the taiyaki has lost its shape in your hand.
  • Shaped like a cross section of garlic viewed from the side
  • Form of ink stain left on edge of old map
  • Shape of an overcooked pizza left uncut
  • The shape of the pattern on the back of a cat that is still in a sleeping habit

You might say a lot of things.

If you get a new point of view from it, it's a great experience.

If I were a career consultant, I would tell you that story, What are you talking about? I'd probably be told, "What are you talking about?

go, go, go, go, go!

How to Hold the Prefectures [enlarged edition].
created by Rinker.
Idea switch!
created by Rinker.
Adopted by Softbank, NTT Data, Mitsui Fudosan, and more! Only 5 minutes to understand and 30 minutes to get ideas! A completely new way of thinking! The popular training program for companies and schools is now available in book form! Just by following the 4 steps, anyone can automatically turn on the "Idea Brain" and get a flood of new ideas!

The King of Reggae You Don't Know: Bob Marley Teaches You How to Deal with Mental Health in the Workplace

Add this entry to Hatena Bookmarks
Bob

Bob Marley, the king of reggae, said

"One good thing about music; when it hits you, you feel no pain."

The nice thing about music is that if you hit people with it, they don't get hurt (rough translation)."

... and...

I sincerely and truly agree with you.

But when it's words, people get hurt very easily.

When you hit people with words, you hurt them.

"When words hit you, you feel pain" it would seem that

And words can sometimes cause pain to others, even when the person who spoke them had no intention of doing so!

In the business world, mental health of office workers has long been an issue in the workplace.

Some of you may be thinking, "What a hard world we live in!

Muse Bubble

But wait, what?

I think...

According to someone's theory,All human languages originally began with music.I think I heard that

If this is the case, then words are a derivative of music and conversation is a piece of music!

If so, I wonder if we can apply Bob's theory to words as well.

If so,

For example, if you think someone has attacked you in a terribly strong tone, don't get hurt, because it's just music!

No need to feel Pain.

If you get a heavy metal word, if it's music, it's music, it's pleasant music.

good feeling

Some people talk like grunge rock,

Some people talk in a jazzy atmosphere,

Some people talk in odd time progressions.

I think I'm talking like Bach.
People say I look like Schoenberg.

Too snobbish?

After all, in the end, it's all about nostalgia for the good old days.
I want to talk in easy-going folk songs.

Trenchtown Rock [Analog].
created by Rinker.

The words at the beginning of this article are also part of the lyrics of the refrain that comes from the beginning of the song Trenchtown Rock.

Idea switch!
created by Rinker.
Adopted by Softbank, NTT Data, Mitsui Fudosan, and more! Only 5 minutes to understand and 30 minutes to get ideas! A completely new way of thinking! The popular training program for companies and schools is now available in book form! Just by following the 4 steps, anyone can automatically turn on the "Idea Brain" and get a flood of new ideas!

Learn from Barley Tea and Valentine's Day! Gutsy know-how on business branding that you can use right away.

Add this entry to Hatena Bookmarks

Learning from anniversaries and barley tea, how to create a market position

Valentine's Dayschool (e.g. of ikebana)

An example of great success in the history of marketingsomething like that

There seem to be many theories as to who and where this was first set up,

On February 14, ladies give chocolates to their lords.

It is a great accomplishment to have artificially created such a crazy habit and to have kept it up for half a century!

It seems to have started in the 1970s.

What is amazing about this campaign, which was launched by the chocolate industry in this country, is that it had never been done before."The New Normal"I've made a

However, these days, "friend chocolates" and "personal chocolates" are more popular than "honmei chocolates.

I think the term "real life" will soon be a dead word.I've heard a few people say that...

Even so, even in the 2020s, about 10% of annual chocolate sales are related to Valentine's Day... It is still an incredibly powerful commercial campaign.

no longerMore of an annual event than a campaign - no, a cultureThis is a good example of how it has turned out to be.

Choco.

Marketers in Edo

Isn't there a similar story in history? 

I went back and looked at it,

In the late Edo period, a similar

I found a perfect example.

."Eels are eaten on the day of the Ox in the dog days of DoyouIt's a custom.

This was created during the An'ei and Tenmei periods (1772-1788).

According to a popular theory, the inventor of theHiraga GennaiThe teacher thought of it, or no, no, no, no, the mad poet.Shu-Shan (one of the Three Kingdoms competing for control of China after the fall of the Han Dynasty)I hear it was the brainchild of

Well, there is no solid proof,

Apparently, in those days in Edo, the sales of eels were slow in the summer time.

Therefore, the "Today is the day of the Ox!It is widely believed that we should put up a sign with a big sign that reads

And it hit the mark, and has been ever since,

Eels in summer have become an annual event.

This is exactly what a marketer does.

It is exactly the same as Valentine's Day in the sense that it is an anniversary marketing campaign,

Hey, hey, hey, this is a pro,

That's how the pros do it!

Unagi Eel

The monster event of our time, "Bachelor's Day."

Now, let's look back in time to the present day,

againOutrageous anniversary marketingthere is

China is a major e-commerce company, and Alibaba has set up a "Bachelor's DayYou know what they say.

The date November 11, with its four 1's in a row, is associated with the word "single," so the idea of "celebrating this day with a big party" was born.

In China, it is known as the Guangcun Festival (guāng gùn jié), or commonly known as the "Festival of the Light Cudgel" with two 11s.double elevenI don't know what they call it.

This is, well, more than just celebrating anniversaries.

We've made it a big sale, an extra big sale, an extra big sale, so the whole country is on a shopping spree!

2020 is an 11-day sale period.Sold over 8 trillion yenThat's exactly what I'm saying."Shopping Olympics"is.

Chart created in 2021 Bachelor's Day GMV (for 2020, the period 11/1-11/11)

And then "barley tea" appears.

So far, the story has been "I know, I know.I'm sure many of you are saying, "Oh, no!

Then one more thing,

Closer to home,

More standard,

moreover

Everyone has unintentionally fallen for it.

Let's give an example of a very successful marketing campaign called

it

...

...

...

barley teaIt is.

No, no, no, don't laugh.

 

This is another well-written story.

Barley tea, you know. Have you ever had barley tea, ma'am?

That's right, there is,

You say,

What in the world was that all about, you ask?

Barley tea is...The juice of roasted and boiled barley.It's about the

I see there is not a single piece of tea leaf in it.

In other words, this isIt's not really "tea."

And yet, because its name is barley tea, it is strangely treated as a "tea companion.

Ladies and gentlemen, the juice from boiling barley,

In the summer, every day, "Tea please~And then he opens the refrigerator and drinks it.

I'm also getting a good feeling about it, and I'm thinking, "You know what?Yes, I'll have tea.The "Namesake" is pushing the "Namesake" button,The bastards with the barley tea.

And so are we,

"Do you want coffee or tea? Tea?" What a question,

"Oh, tea, do you want green tea or barley tea?" I usually talk about it in a normal and natural way,

I didn't expect to see "tea" in the name,

."Which tea do you prefer, green tea or barley tea?I've said, "I'm not a fan of that,

If you think about it calmly, barley tea is a drink that has nothing to do with tea at all,

"Do you want coffee or tea? Tea?"

Oh, tea,Do you prefer green tea or cola for tea?"

It's not much different from saying, "I'm not a good person.

If you say, "Yes, tea," and a Coke is served,

ulp (consternation)

And then, "Oh, no, I'm not going to do that,

I don't want to bother you at this house anymore.

So, it's like...

But no one ever says that.

No one will say it's weird.

Why is this?

...

...

That's because someone first named it "barley tea.

That's all there is to it.

If this,

For example, yes,

What if it was "mugi-jiru" (barley juice) instead of barley tea?

Do you want tea? Mugi-jiru?"

I'm afraid I'm going to have to say no, thanks.

Barley tea strategy has theoretical support

This "Barley Tea StrategyActually.Supported by management strategy theoryThere is a

In the marketing world, it's calledpositioningIt's...Category DesignI've been called "the

Al Reiss and Jack Trout's "ThepositioningIn "Where to take the shelf in the customer's headHe says the key is "to be the best.

Barley tea has taken the "tea shelf" by storm!

positioning strategy
created by Rinker.

In the book "Play Bigger" by Al Ramadan et al.Design your own market category and be its champion.He says.

Category King How did Airbnb, Google, and Uber get to the top of the world?
created by Rinker.

In Robert Cialdini's Weapons of Influence.One way of labeling can change perceptions.And..."

Weapons of Influence [New Edition] Seven Principles for Moving People
created by Rinker.

Seth Gaudin said, "Decide for yourself what you want to be compared to.And..."

THIS IS MARKETING Moving the market
created by Rinker.

I heard you say something like that,

Well, barley tea is just that,I picked my spot so I could compare it to tea.I can see that you are a good person, but I can also see that you are not.

This self-categorization, or, well, what we categorize ourselves as, shows what we are.Important root in branding and marketing activitiesand that's why

We have that in common, don't we?

There are parts of each that say different things,

We ROCKETS, for example,

Product Market Fitand in product development for venture businesses (including startups and new businesses of mature companies).Self-categorization is fatally destructive in customer development and other areas.So, from that perspective, I think I can give you a big update on the story here, but that's a story for another time.

If you are interested, you may want to read some of the books.

It's not a trick, it's a call to the future.

This kind of strategy, if you make a mistake, you can't just say, "I'm not going to do it.It just makes it look better than it really is.It is easy to think, "Oh, no, I'm not a good person.

Especially in the early stages of a new company or new business, there is inevitably a gap between "what we can do now" and "what we want to be in the future.

Therefore, the "This is what we were meant to be.and flags and speaks for itself within that framework.

Then, customers, friends, and investors who resonate with it and support it will appear.

And that support piled up,When you find yourself getting closer and closer to looking like you declared you would.There are times, aren't there?

So this is not "cheating."A magnet to attract the future."so that's why

even if incompleteIf it's not a lie.after thatAre you prepared to be faithful and committed to the future and to do what you say you are going to do?Please, sir.

WeWork - Light and Shadow of the Barley Tea Strategy

I guess we have to take the bad examples too.

In a way, this barley tea strategy on a large scale was born in the United States in 2010.WeWorkSo, the company was called

This is a company that rents out stylish office space,

."We are an office rental company.You didn't say "the" word.

in return (for)

."Community Workspace"

."Platforms that change the way we work"

He called himself.

At that time, technology and sharing companies such as Airbnb and Uber were very popular with investors.

Thanks to WeWork putting itself in that context, its valuation ballooned quickly, peaking at about $47 billion (¥5 trillion). It expanded its branches all over the world.

However, in 2019, the documents submitted with the aim of listing the company revealed a huge deficit and problems with the management structure, the IPO was cancelled, the valuation plummeted, and the company filed for bankruptcy protection in 2023.

This is an example of both light and shadow.

We are not a real estate agency, we are a company that changes the way people work." This self-categorization has brought in a lot of money and people.

However, there were too many big lies there, and

He was not a man of integrity and integrity...

So that's why it was such a rhapsody.

WeCrashed ~Startup Madness~ (TV program)
created by Rinker.

I have given you many examples,

Even if it's the same thing,What do you call it and what do you call it?

What category would you say it is and what would you call it?

It changes the future--that's what the barley tea is telling us.

...

Well, I've talked too much, and now I'm thirsty.

Let's have a cup of tea here,

No, no, no, let's have some barley tea.


Every time you drink barley tea

With that in mind,

Let's have a delicious meal.

(ENDS)

summary

  • Valentine's Day and the day of the Ox are examples of artificially created events that have turned into culture.
  • Bachelor's Day is a very large marketing case study that has succeeded in the same structure in modern times.
  • Mugi-cha is a masterpiece of the self-categorization strategy of being recognized as tea even though it is not tea
  • Names, classifications, and labeling can significantly change product value and market position

Marketing is not just a promotional technique, but a long-term culture-building process that rewrites the map in people's minds.

The next time you market something, will you call it "barley tea" or "wort"? That choice may determine future sales.

Extra (conversation at a later date)


Marcy.
Marcy: I'm not sure if I'm going to be able to do it. I'd like to have a separate discussion about the importance of how you categorize yourself in business development."
Go.
Go:. Thanks, and yes, maybe we can do it again separately on ROCKETS RADIO."
Marcy.
Marcy: I'm not sure if I'm going to be able to do it. But this time, Go-san's tone is kind of old."
Go.
Go:. Haha, I just had to give it a try."
Marcy.
Marcy: I'm not sure if I'm going to be able to do it. I thought it was something like that, but then I realized it was Mito Komon. I thought it looked like something, but it's Mito Komon.
Go.
Go:. Uh, no, I don't."
Marcy.
Marcy: I'm not sure if I'm going to be able to do it. It's the Mito Komon way of laughing. That's it, that's Mito Komon's way of laughing.
Go.
Go:. 'No, it's changing gradually, and I'm not saying whoo-whoo.'
Marcy.
Marcy: I'm not sure if I'm going to be able to do it. I'm so glad I figured one thing out today. I'm like Mito Komon.
Go.
Go:. I don't know. I don't know... (kind of disapproving)"

continue

Idea switch!
created by Rinker.
Adopted by Softbank, NTT Data, Mitsui Fudosan, and more! Only 5 minutes to understand and 30 minutes to get ideas! A completely new way of thinking! The popular training program for companies and schools is now available in book form! Just by following the 4 steps, anyone can automatically turn on the "Idea Brain" and get a flood of new ideas!

(Free) How Non-Engineers Can Sigodeki with Huge Data Analysis

Add this entry to Hatena Bookmarks
Big CSV to pass

Scenes from a large CSV

Need to work with CSV files that are too large to open in ExcelHave you ever come across such a situation?

For example,

  • Sales data in the hundreds of thousands to millions of lines

  • Survey results and log data

  • Report CSV spit out from the business system

...Cases where you want to look at this kind of data and consider or analyze it a little. 

I think it's a very common case if you work in the corporate world 📓.

How big are these files? I would say

for example

A company with annual sales of 500 million yen and a unit sales price of about 10,000 yen

...then there are 50,000 lines of basic sales data alone.

For 5 years, 250,000 lines.

When this is combined with data on product types, discounts, and other measures, the total number of rows can quickly grow to more than 1 million!

Naturally, if sales are large, such as 5 billion yen or 50 billion yen...

Data will increase proportionally.

That's just one example, but it's someone who works in a company,It is a rather common case that you want to analyze data from millions of rows of data.I think that's what it means.

DB icon

CSV file, not database.

In a company of a certain size, there is usually an IT department and an engineer, and the engineer may be someone who works with databases on a daily basis,

As an engineer, it is normal to deal with millions of rows of dataabout.

When analyzing data within the IT department,Set up and work on a database for this purpose.I know you do.

However, it is often the case that the people in a company who want to do data analysis in the first person are in the marketing department, product department, sales department, human resources department, etc. ・・・・

Sometimes they're not in the IT department.

And,

suchNo database for data analysis for non-IT departmentsI'm sure there are many companies that have

The alual in such cases is,IT department only gives me CSV.This is a pattern called

IT department engineer: "I've pulled 5 million rows of CSVs from the database, and you can do whatever analysis you want with them."

Engineer and marketer

He looks at the huge file he handed me and says, "Hmmm...

...I think there are quite a few phases like this.

What to do in such a situation

If possible, I wish I could analyze it in Excel, which I am familiar with, but unfortunately Excel is not.When the number of lines exceeds several tens of thousands (depending on the performance of the computer), the operation becomes very slow and tiring.

Also, if the number of lines exceeds 1,040,000, it cannot be opened in the normal way

The Excel Power Query method can be used to open the data, but it does not avoid the fact that the analysis will take time,Heavy operation and risk of crashes can be a bottleneck

However, uploading to some unknown cloud is not a security measure.

Of course, it's hard for me to say, "Well, I'll set up a database in-house," like an engineer.

Similarly, "Let's implement a BI tool such as Tableau or Power BI" is a good suggestion for a future plan, but not something you can do today or tomorrow on your own.

I need to analyze it today and I'm stuck...

We want to do it.I just want to handle large data quickly on my local PC! (If there were just a few more lines, I could do it in a snap with Excel...!)something like ...

 

Therefore, in this issue.DBBrowser for SQLiteto and AI (Chat GPT, CoPilot, Gemini, Claude.... Any AI that can be consulted in a chat format) approaches to


 

Why DB Browser for SQLite?

DB Browser fro SQLite is SQLite is an ultra-lightweight database with GUI operation and has the following features

  • ✅ fully localNo net connection or server required

  • ✅ High capacity OKLightweight operation even with hundreds of thousands to millions of lines

  • ✅ Free and easy to install

All of the following can be operated with a mouse

  • Data import (CSV → table)

  • Extraction by conditions (search filter)

  • Editing and deleting

  • Export results (e.g., re-CSV)

Only when we do the final analysis, we use a language called SQL, but this can be solved in an instant with the support of AI.

  • Analyze using SQL → Solve using AI

 

 

Operation Procedure (Preparation of DB Browser for SQLite)

1. download and install the tool

Let's download it first!

For Windows users, choose "DB.Browser.for.SQLite-*.win64.exe".

The screen images from here on out will be done on a Mac.

 Homebrew is a command line installation from the terminal

Here we will use the installer (.dmg file on Mac)

When you open the dmg file, you will see a screen like this, so copy it to Applications by drag & drop

 

Double-click DB Browser for SQLite in the Applications folder to open it

 

 You may get a screen like this, but it will open.
 DB Browser for SQLite has been opened. If you want to configure Japanese settings, please click  You can configure it by going to DB Browser for SQLite → Preferences
 Now ready for use

Create a new database file

 

Choose File→New Database
Choose where to save the database

 

Next is the table definition screen.
 

Import CSV files as tables

After this, import the CSV file so that it can be handled as a database (table)
A table is data in table form

File→Import→CSV File to Table

 

 

In this case, we have prepared two CSV files as samples
This is a sample, so it is 900 rows, but it works with CSVs more than 100 times larger than this.
  1. sales detail data
  2. Merchandise Cost Master

The sales detail data is an image of the data in the POS data or sales management system, with columns like this inside

  • SalesID (Serial number of the sales invoice)
  • SalesDate
  • ProductID (product ID of the sold product)
  • Category (Category of sold products)
  • Gender (whether the product sold is men's or women's)
  • Size (size of item sold)
  • SalesValue
The product cost master is an image of the master that manages the product cost of each product and contains columns such as
  • ProductID (Product ID)
  • ProductCost (the cost amount of the item)
This is a completely fictitious sample, but I am sure similar examples are common. 
If you open it in Excel, you will see an image like this