始める無料で始める

Contribute to the data set

A few pain points in entering data comes from formatting dates and categorical columns.

When formatting dates, users tend to default to their preferred date format. This is an issue because there are many ways for the date to be written.

Categorical columns, such as the source of Bing or Google marketing campaigns, can be problematic because of naming convention differences between parties. In the world of marketing, different agencies usually have slightly different campaign names, but this issue can be mitigated by only offering a finite number of options to choose from.

この演習はコースの一部です

Google Sheetsで学ぶマーケティング分析

コースを見る

演習の手順

  • For row 27, the date entered should be January 7th, 2019 and the source should be Google.
  • In the last row, 28, the source should be Bing and the date entered should be December 17th, 2018.

実践的なインタラクティブ演習

理論を実践に変える、インタラクティブな演習のひとつをお試しください

演習を開始する