![]() Task 3: Create Sub Category Pivot Table / Pivot Chart ![]() Create a, filterable by country, stacked column pivot chart based on the created pivot table. ![]() Count how many of the category projects were successful, failed, canceled or are still active (live).Add a pivot table to the new sheet that analyzes the orignal worksheets category column.Create a new sheet in the workbook and name it Kickstarter Categories.The steps I took to create the category pivot table and pivot chart are as follows. First I had to make a stacked pivot bar chart that looked at the categories of the projects. Now that the original dataset was modified to better identify Kickstarter campaign trends, I now had to create some visualizations to communicate what those trends are. Task 2: Create Category Pivot Table / Pivot Chart Create a formula that converts the Unix Timestamp in launched_at and deadline columns to normal dates and place into the appropriate column.Create columns in letter S and T, name them "Date Created Converstion" and "Date Ended Conversion".Create a formula to seperate the sub-category from category and place them in the corresponding column.Create columns in letters Q and R, name them "Category" and "Sub-Category".Create column in letter P, name it "Average Donation" and have it calculate each campaigns average pledge.Use conditional formatting on the Percent Funded column and apply a three-color scale of red, green and blue.Create column in letter O, name it "Percent Funded" and use a formula to display how much money each campaign made.Use conditonal formatting and fill the "state" column cells with colors for successful, failed, canceled or live projects.The steps I took to create the Excel Table are as follows. To more accurately identify trends, I added percent funded, category, sub-categoy, date created conversion and date ended conversion columns. In order to better analyze the data, I added color to cells for clearer identification of differences. The table had to be readable in such a way as to identify market trends. Task 1: Organize / Stylize Datasetįor this section of the challenge, I had to modify the provided table with the use of conditional formatting and column creation. For this reason, companies will spend months researching past projects to uncover successfull trends. ![]() Only one third of all Kickstarter campaigns find enough funding to go into production. To get funded through a Kickstarter project, the funding must be equal to or greater than the orignal set goal. Kickstarter has been hugely successful as a crowdfunding service, but all of the projects have not seen success. This project required me to organize and analyze a database of 4,200 past Kickstarter campaigns to incover any hidden trends. Whether you wish to play as a silent hunter or a guns blazing dreadnought, arrange your crew members and weapons to fit your playstyle.Excel: Kickstarter Campaigns Analysis Excel Pivot Tables and Pivot Charts Discover numerous types of cannons and torpedoes to help you overcome the dangers of the deep, and assemble your own unique crew to brave it alongside you. Discover the remnants of civilization in numerous unique towns and learn their local lore, trade stories and treasure, and hire crew new members.Ĭontinuously improve each of the game’s 9 unique pilotable submarines using a deep upgrade system, and gain access to new areas and loot. About the gameĮxplore the dangers of the depths in this beautifully realized flooded world, and unearth untold riches and glory. No sense in doing so if you won't buy it, as that does more harm than good. If you would actually buy it, be sure to give your support in that forum topic. On the Steam forum the developer recently said this: QuoteTo update, we're considering supporting Diluvion in the main Linux branches, but not all of them. Could be an awesome game to get lost in and just explore away. Accept Cookies & Show Direct LinkI think it looks fantastic! Love the visual work, especially when it's dark and they find stuff that glows. YouTube videos require cookies, you must accept their cookies to view.
0 Comments
Leave a Reply. |