投稿時間:2023-05-13 14:14:21 RSSフィード2023-05-13 14:00 分まとめ(18件)

カテゴリー等	サイト名等	記事タイトル・トレンドワード等	リンクURL	頻出ワード・要約等/検索ボリューム	登録日
IT	ITmedia 総合記事一覧	[ITmedia Mobile] Twitter運営会社XのCEOにリンダ・ヤッカリーノ氏　「私は製品設計と新技術に集中」とマスク氏	https://www.itmedia.co.jp/mobile/articles/2305/13/news069.html	itmediamobiletwitter	2023-05-13 13:30:00
IT	ITmedia 総合記事一覧	[ITmedia News] VLOGカメラに進化したキヤノン「Powershot V10」　ソニーと何が違う？	https://www.itmedia.co.jp/news/articles/2305/13/news066.html	itmedianewsvlog	2023-05-13 13:28:00
python	Pythonタグが付けられた新着投稿 - Qiita	Kaggle奮闘録(Titanic編5) -スタッキング-	https://qiita.com/bazz0907/items/63aac6888975d841ecba	inelearningfromdisaster	2023-05-13 13:59:53
python	Pythonタグが付けられた新着投稿 - Qiita	Event Busを作ってみよう 仕様まとめ（随時更新予定）	https://qiita.com/shiganai/items/76996ffdc4439103d6a4	eventbus	2023-05-13 13:25:31
golang	Goタグが付けられた新着投稿 - Qiita	goのO/RマッパーGORMを使用する時、構造体の変数名に数字を付けるとどうなる	https://qiita.com/ryuken/items/1d9ab99e8bd5f3e6a1b8	構造体	2023-05-13 13:43:36
技術ブログ	Developers.IO	クラスメソッド本社、日比谷オフィス入館方法～日比谷フォートタワー 26 階がクラスメソッド日比谷オフィスフロアです	https://dev.classmethod.jp/articles/directions-to-class-method-hibiya-office/	移転	2023-05-13 04:54:03
技術ブログ	Developers.IO	[アップデート] Amazon SNS で保留中のサブスクリプションが自動削除されるまでの時間が 48 時間に変更されました	https://dev.classmethod.jp/articles/sns-automatic-deletion-unconfirmed-subscriptions/	確認作業	2023-05-13 04:32:46
海外TECH	DEV Community	Cohort Retention Analysis from A-Z in Tableau	https://dev.to/alumassy/cohort-retention-analysis-from-a-z-in-tableau-4l0a	Cohort Retention Analysis from A Z in TableauI recently learnt how to carry out cohort retention analysis in Tableau But most of the articles I came across were just using Tableau merely as a visualisation tool for the cohort retention rate results For example they d use SQL for calculation and then Tableau for visualization or use Excel for calculation and then visualise in Tableau I found there s an efficient way to do all this Calculating the cohort retention rate and also visualizing the results all in one place ーTableau Isn t that awesome In this article you ll learn What cohort retention analysis isWhy it s importantWhat data is required for cohort retention analysis amp if it s not available how to calculate it derived columns calculated field How to create the cohort retention tableHow to interpret the cohort retention rate PrerequisitesYou should have a Tableau public account to be able to create and publicly share your visualisation after you re done You should know the basics of Tableau In this article I assume you re already familiar with the Tableau environment I ll focus on teaching you how to use Tableau for cohort analysis specifically Understand cohort retention analysisCohort analysis is used by businesses to understand the behaviour patterns and trends of their customers so that they can subsequently tailor their products and services to the identified cohorts You might ask yourself what a cohort is A cohort is simply a group of people in this case who are customers that share common characteristics such as time and size Therefore Cohort Analysis is an analysis of several different cohorts to get a better understanding of their behaviour patterns and trends There are different types of cohorts to analyze They include Time based cohortsSegment based cohortsSize based cohortIn this case the type of cohorts you are going to create are time based cohorts Specifically the cohort analysis you re going to do is retention based You are going to look at the time frame a certain group of people made their first purchase and then track the percentage of them that made subsequent purchases in future quarters Get DataThe Data set that you are going to be using is the famous Superstore Dataset You can access the dataset by downloading it from Kaggle Open Tableau Public and connect to the Superstore data Go ahead and analyse the rows and columns to know what kind of data about the superstore was documented Proceed to the Sheet tab This is going to be your workspace and where you re going to subsequently create your visualisation Data points of interestTo carry out cohort analysis the following data points are required You need Unique identifier In this case your unique identifier is the Customer IDFirst purchase date This refers to the date the customer made their first purchase from the business and became a customer This initial date is going to come in handy in creating a cohort group Revenue data Create calculated fields Customers First purchase date quarter As mentioned earlier the first purchase date is used in assigning a cohort to each customer Since the first purchase date field is not readily available in the data set You are going to come up with it This is known as a calculated field A calculated field is a numeric or date field that derives its data from the calculation of the data in other fields that are readily present in the dataset Through the first purchase calculated field you re going to create quarter and year cohorts which will be assigned to customers depending on the date they made their first purchaseEarlier in this article I defined a cohort as a group of people that share common characteristics like time In this case a cohort is going to be a group of customers that made their first purchase in the same quarter and same year If you explored this Superstore dataset at the start you might have realised that this data is spanning four years if decided to make the month cohorts it would make the cohort table very big and hard to analyse at just a glance So I deemed it efficient to form cohorts based on the quarter and year in which a customer made their first purchase What I m trying to say is that you can create time based cohorts based on other time parameters like day week or month and it wouldn t matter The calculation to establish the quarter in which a customer made their first purchase is as below DATE FIXED Customer ID MIN DATETRUNC quarter Order Date Customers per first quarterThis calculated field is going to be used to establish the number of unique customers that made their first purchase in each quarter This calculation builds on the first calculated field that you ve just completed FIXED Customers First Purchase Quarter COUNTD Customer ID Retention RateCOUNTD Customer ID SUM Customers per First Quarter Assemble the cohort tableThis is about assembling the calculated fields you ve created to form a cohort retention table Step Click on Customers First Purchase field and drag it to the rows Step On the rows click on the drop down then switch the specifications from year to quarter and from continuous to discrete Step Click on the Order Date field and drag it to the columns Click the drop down in the columns to switch the specifications from year to quarter and from continuous to discrete Step Drag the Customers per first quarter field you created from the measures to the dimensions And then drag it to the rows Step Click the Retention Rate field you previously created and drag it to the text tile Click the drop down to format number to percentage of one decimal place Step Drag the Retention Rate field from the text tile to the colour tile Then drag Customer ID field to the tooltip tile On the customer ID tool tip click the drop down to change from attribute to a measure of count distinct Then finally make the values visible by clicking T on the tool bar Bonus tip You can further customize the look of the table by going over to the coolors website to pick out some unique colours that appeal to you Interpret the retention rate Going down the viewGoing down the view of the cohort table look at the first column and second column you seedifferent year and quarter groups cohorts the number of customers that made their first purchase in each of those periods Going across the viewGoing across the view rd column you see the percentage of customers that continued to make purchases at the superstore through quarters after making their first purchase For example customers made their first purchase in Q Of those customers and of them came back to make purchases in Q and Q respectively And so forth… ConclusionCreating calculated fields is inevitable in carrying out Cohort analysis in Tableau And with creating calculated fields comes the need to use functions If you are fairly new to the concept of Tableau functions I understand there might be some knowledge gaps for you to fill I recommend you check out this Tableau article on functions to gain a deeper understanding of the subject	2023-05-13 04:07:48
海外TECH	CodeProject Latest Articles	Developing a PC-speaker MIDI Player for the IBM PC XT	https://www.codeproject.com/Articles/5360300/Developing-a-PC-speaker-MIDI-Player-for-the-IBM-PC	developing	2023-05-13 04:41:00
海外TECH	CodeProject Latest Articles	Exploring PCx86, an IBM PC Emulator Written in JavaScript	https://www.codeproject.com/Articles/5358401/Exploring-PCx86-an-IBM-PC-Emulator-Written-in-Java	javascript	2023-05-13 04:41:00
海外科学	NYT > Science	‘A Bit Spooky’: The New Shark Species With Bright, White Eyes	https://www.nytimes.com/2023/05/12/science/demon-shark-new-species-australia.html	australia	2023-05-13 04:42:41
海外ニュース	Japan Times latest articles	Five women taken to hospital after car driven by elderly man slams into store in Aichi	https://www.japantimes.co.jp/news/2023/05/13/national/aichi-traffic-accident/	Five women taken to hospital after car driven by elderly man slams into store in AichiOne of the five was seriously hurt while the other four sustained minor injuries in the incident Police believe the driver may have pressed the	2023-05-13 13:41:05
海外ニュース	Japan Times latest articles	G7 leaders’ summit statement to target China’s ‘economic coercion’	https://www.japantimes.co.jp/news/2023/05/13/business/g7-us-china-economic-coercion/	G leaders summit statement to target China s economic coercion G leaders are set to discuss concern about China s use of economic coercion in its dealings abroad as part of their larger joint statement a	2023-05-13 13:25:18
ニュース	BBC News - Home	Turkish opposition dares to dream of Erdogan defeat	https://www.bbc.co.uk/news/world-europe-65568647?at_medium=RSS&at_campaign=KARANGA	erdogan	2023-05-13 04:04:15
ニュース	BBC News - Home	Swiss village of Brienz evacuated over risk of imminent rockslide	https://www.bbc.co.uk/news/world-europe-65580427?at_medium=RSS&at_campaign=KARANGA	dairy	2023-05-13 04:35:18
ニュース	Newsweek	モスクワ市内で「謎の赤いバツ印」の発見が相次ぐ...「ドローン攻撃の目印？」「いたずら？」	https://www.newsweekjapan.jp/stories/world/2023/05/post-101627.php	それに先立って発見されたバツ印をめぐっては、ウクライナが戦勝記念日にモスクワに攻撃を仕掛ける計画があるのではないか、ドローンやミサイルによる攻撃の標的として印が付けられているのではないかなど、いくつかの憶測も浮上した。	2023-05-13 13:17:00
海外TECH	reddit	THE GOLDEN STATE WARRIORS HAVE BEEN ELIMINATED FROM CHAMPIONSHIP CONTENTION	https://www.reddit.com/r/nba/comments/13g7hb7/the_golden_state_warriors_have_been_eliminated/	THE GOLDEN STATE WARRIORS HAVE BEEN ELIMINATED FROM CHAMPIONSHIP CONTENTIONWith a series loss against the Los Angeles Lakers the Golden State Warriors have been eliminated from NBA Championship contention Fade em submitted by u Nyhrox to r nba link comments	2023-05-13 04:45:32
海外TECH	reddit	[Post Game Thread] The Los Angeles Lakers (4-2) advance to the Western Conference Finals as they defeat the Golden State Warriors (2-4) in game 6 by 122 - 101. LeBron James with 30 points, 9 rebounds and 9 assists	https://www.reddit.com/r/nba/comments/13g7h9h/post_game_thread_the_los_angeles_lakers_42/	Post Game Thread The Los Angeles Lakers advance to the Western Conference Finals as they defeat the Golden State Warriors in game by LeBron James with points rebounds and assists Box Scores NBA Yahoo nbsp GAME SUMMARY Location Crypto com Arena Clock Q Officials Courtney Kirkland John Goble and Mark Lindsay Team Q Q Q Q Total Golden State Warriors Los Angeles Lakers nbsp TEAM STATS Team PTS FG FG P P FT FT OREB TREB AST PF STL TO BLK Golden State Warriors Los Angeles Lakers nbsp PLAYER STATS Golden State Warriors MIN PTS FGM A PM A FTM A ORB DRB REB AST STL BLK TO PF ± Gary Payton IISF Andrew WigginsPF Draymond GreenC Klay ThompsonSG Stephen CurryPG Jordan Poole Donte DiVincenzo Kevon Looney Moses Moody Jonathan Kuminga Patrick Baldwin Jr Anthony Lamb JaMychal Green Andre Iguodala Ryan Rollins Los Angeles Lakers MIN PTS FGM A PM A FTM A ORB DRB REB AST STL BLK TO PF ± Austin ReavesSF LeBron JamesPF Anthony DavisC D Angelo RussellSG Dennis SchroderPG Lonnie Walker IV Rui Hachimura Jarred Vanderbilt Shaquille Harrison Malik Beasley Troy Brown Jr Tristan Thompson Max Christie Wenyen Gabriel Mo Bamba rnbapgtgenerator by u fukr submitted by u Nyhrox to r nba link comments	2023-05-13 04:45:29