Difference between revisions of "ANLY482 AY2017-18T2 Group30 Data Analysis"
Jump to navigation
Jump to search
| Line 49: | Line 49: | ||
<div align="center"> | <div align="center"> | ||
<div style=" width: 85%; background: #E6EDFA; padding: 12px; font-family: Arimo; font-size: 18px; font-weight: bold; line-height: 1em; text-indent: 15px; border-left: #8c8d94 solid 32px;"><font color="#5A6B96">Data Source</font></div> | <div style=" width: 85%; background: #E6EDFA; padding: 12px; font-family: Arimo; font-size: 18px; font-weight: bold; line-height: 1em; text-indent: 15px; border-left: #8c8d94 solid 32px;"><font color="#5A6B96">Data Source</font></div> | ||
| − | <div | + | </div> |
| − | < | + | |
| − | < | + | <div align="left"> |
| − | + | <div style=" width: 85%; padding:75px; font-family: Arimo; font-size: 14px; font-weight: bold; line-height: 1em; text-indent: 15px;"> | |
| + | <font> | ||
For data files from <i>Facebook Insights Data Export (Post Level)</i>, the sponsor provided exported data from different periods of the year, with different metric tabs in Excel format. The tabs included are: | For data files from <i>Facebook Insights Data Export (Post Level)</i>, the sponsor provided exported data from different periods of the year, with different metric tabs in Excel format. The tabs included are: | ||
# Key Metrics | # Key Metrics | ||
| Line 58: | Line 59: | ||
# Lifetime: Number of people who have clicked anywhere in your post, by type (unique users) | # Lifetime: Number of people who have clicked anywhere in your post, by type (unique users) | ||
# Lifetime: Number of people who have given negative feedback on your post, by type (unique users) | # Lifetime: Number of people who have given negative feedback on your post, by type (unique users) | ||
| − | + | </font> | |
| − | + | </div> | |
| − | < | + | </div> |
<div align="center"> | <div align="center"> | ||
<div style=" width: 85%; background: #E6EDFA; padding: 12px; font-family: Arimo; font-size: 18px; font-weight: bold; line-height: 1em; text-indent: 15px; border-left: #8c8d94 solid 32px;"><font color="#5A6B96">Data Preparation</font></div> | <div style=" width: 85%; background: #E6EDFA; padding: 12px; font-family: Arimo; font-size: 18px; font-weight: bold; line-height: 1em; text-indent: 15px; border-left: #8c8d94 solid 32px;"><font color="#5A6B96">Data Preparation</font></div> | ||
| − | <div | + | </div> |
| − | < | + | |
| − | < | + | <div align="left"> |
| + | <div style=" width: 85%; padding:75px; font-family: Arimo; font-size: 14px; font-weight: bold; line-height: 1em;"> | ||
| + | <font> | ||
To help us have an overview of the data throughout the year, we consolidated the various tabs, whilst concatenating the various periods of data for the same columns, into one combined file. This was carried out using the software, IBM JMP Pro, in the following steps: | To help us have an overview of the data throughout the year, we consolidated the various tabs, whilst concatenating the various periods of data for the same columns, into one combined file. This was carried out using the software, IBM JMP Pro, in the following steps: | ||
* With Post ID, Permalink (permanent link of the campaign content), Post Message, Type, Countries and Posted columns as key identifiers among the different tabs for the excel files, we appended desired columns from the other tabs to the end of the Key Metrics. They included the Share, Like, Comment columns from Tab 2; Other Clicks, Link Clicks, Photo View, Video Play columns from Tab 3; Hide_Clicks , Hide_all_clicks, Unlike_page_clicks, report_spam_clicks columns from Tab 4. <br>This was conducted using the <i>Tables > Join </i>function, with “Matching Specification” as the key identifiers and “Output Columns” of the appended desired columns. | * With Post ID, Permalink (permanent link of the campaign content), Post Message, Type, Countries and Posted columns as key identifiers among the different tabs for the excel files, we appended desired columns from the other tabs to the end of the Key Metrics. They included the Share, Like, Comment columns from Tab 2; Other Clicks, Link Clicks, Photo View, Video Play columns from Tab 3; Hide_Clicks , Hide_all_clicks, Unlike_page_clicks, report_spam_clicks columns from Tab 4. <br>This was conducted using the <i>Tables > Join </i>function, with “Matching Specification” as the key identifiers and “Output Columns” of the appended desired columns. | ||
| Line 73: | Line 76: | ||
* Finally, we check for missing data in the different columns. For example, under the column Type, we have five different types, namely: Link, Photo, Shared Video, Status and Video. However, in the instances of missing data, we will cross check with the permalink of the campaign post, and check the Type of medium was posted and fill it in accordingly. | * Finally, we check for missing data in the different columns. For example, under the column Type, we have five different types, namely: Link, Photo, Shared Video, Status and Video. However, in the instances of missing data, we will cross check with the permalink of the campaign post, and check the Type of medium was posted and fill it in accordingly. | ||
| − | </ | + | </font> |
| − | + | </div> | |
| − | < | + | </div> |
| − | |||
<div align="center"> | <div align="center"> | ||
<div style=" width: 85%; background: #E6EDFA; padding: 12px; font-family: Arimo; font-size: 18px; font-weight: bold; line-height: 1em; text-indent: 15px; border-left: #8c8d94 solid 32px;"><font color="#5A6B96">Exploratory Data Analysis</font></div> | <div style=" width: 85%; background: #E6EDFA; padding: 12px; font-family: Arimo; font-size: 18px; font-weight: bold; line-height: 1em; text-indent: 15px; border-left: #8c8d94 solid 32px;"><font color="#5A6B96">Exploratory Data Analysis</font></div> | ||
| − | |||
</div> | </div> | ||
| − | < | + | <div align="left"> |
| + | <div style=" width: 85%; padding:75px; font-family: Arimo; font-size: 14px; font-weight: bold; line-height: 1em; text-indent: 15px;"> | ||
| + | <font> | ||
| + | <!---------Enter Text Here -------> | ||
| + | </font> | ||
| + | </div> | ||
| + | </div> | ||
<div align="center"> | <div align="center"> | ||
<div style=" width: 85%; background: #E6EDFA; padding: 12px; font-family: Arimo; font-size: 18px; font-weight: bold; line-height: 1em; text-indent: 15px; border-left: #8c8d94 solid 32px;"><font color="#5A6B96">Final Application: Learning Dashboard</font></div> | <div style=" width: 85%; background: #E6EDFA; padding: 12px; font-family: Arimo; font-size: 18px; font-weight: bold; line-height: 1em; text-indent: 15px; border-left: #8c8d94 solid 32px;"><font color="#5A6B96">Final Application: Learning Dashboard</font></div> | ||
| − | |||
</div> | </div> | ||
| − | + | <div align="left"> | |
| − | < | + | <div style=" width: 85%; padding:75px; font-family: Arimo; font-size: 14px; font-weight: bold; line-height: 1em;"> |
| − | + | <font> | |
| + | <!---------Enter Text Here -------> | ||
| + | </font> | ||
| + | </div> | ||
</div> | </div> | ||
Revision as of 16:42, 7 February 2018
| HOME | ABOUT US | PROJECT OVERVIEW | PROJECT FINDINGS | PROJECT MANAGEMENT | DOCUMENTATION | MAIN PAGE |
| Facebook Post | Facebook Video | Youtube | Blog Post |
|---|
Data Source
For data files from Facebook Insights Data Export (Post Level), the sponsor provided exported data from different periods of the year, with different metric tabs in Excel format. The tabs included are:
- Key Metrics
- Lifetime: Number of unique people who have created a story about your Page post by interacting with it (unique users)
- Lifetime: Number of people who have clicked anywhere in your post, by type (unique users)
- Lifetime: Number of people who have given negative feedback on your post, by type (unique users)
Data Preparation
To help us have an overview of the data throughout the year, we consolidated the various tabs, whilst concatenating the various periods of data for the same columns, into one combined file. This was carried out using the software, IBM JMP Pro, in the following steps:
- With Post ID, Permalink (permanent link of the campaign content), Post Message, Type, Countries and Posted columns as key identifiers among the different tabs for the excel files, we appended desired columns from the other tabs to the end of the Key Metrics. They included the Share, Like, Comment columns from Tab 2; Other Clicks, Link Clicks, Photo View, Video Play columns from Tab 3; Hide_Clicks , Hide_all_clicks, Unlike_page_clicks, report_spam_clicks columns from Tab 4.
This was conducted using the Tables > Join function, with “Matching Specification” as the key identifiers and “Output Columns” of the appended desired columns.
- Next, for each period of data files (appended with new columns) from multiple tabs, we concatenate the data across different time periods to have a full year collection of data.
This was conducted using the Tables > Concatenate function, while adding multiple data tables into “Data Tables to be Concatenated”.
- Finally, we check for missing data in the different columns. For example, under the column Type, we have five different types, namely: Link, Photo, Shared Video, Status and Video. However, in the instances of missing data, we will cross check with the permalink of the campaign post, and check the Type of medium was posted and fill it in accordingly.
Exploratory Data Analysis
Final Application: Learning Dashboard
