Business Intelligence ASM 2, Study Guides, Projects, Research of Business Informatics

Download Business Intelligence ASM 2 and more Study Guides, Projects, Research Business Informatics in PDF only on Docsity! ASSIGNMENT 2 FRONT SHEET Qualification BTEC Level 5 HND Diploma in Computing Unit number and title Unit 14: Business Intelligence Submission date 8/3/2022 Date Received 1st submission Re-submission Date Date Received 2nd submission Student Name Nguyen Vu Duc Student ID GDH190747 Class GCH1001 Assessor name Doan Trung Tung Student declaration I certify that the assignment submission is entirely my own work and I fully understand the consequences of plagiarism. I understand that making a false declaration is a form of malpractice. Student’s signature Grading grid P3 P4 P5 P6 M3 M4 D3 D4  Summative Feedback:  Resubmission Feedback: Grade: Assessor Signature: Date: IV Signature: D iễ n th uy ết tr ư ớ c đá m đô ng 1 01 REAL LIFE EXAMPLE OF UBER Scope: The scope of this case study is the rental cab market, particularly the success story of Uber. The case study highlights how Uber leverages real-time data to make business decisions. Problem: The problem faced by rental cab companies is to set a fair price for their services. The price should be competitive enough to attract customers, but it should also be profitable for the company. Additionally, the companies need to ensure that they have enough drivers available to meet the demand. Solution: Uber's solution to this problem is to leverage real-time data on traffic and demand for cabs to set fair prices. By analyzing this data, Uber can identify peak hours when the demand for cabs is high, and set higher fares during those times. This encourages more drivers to be available during peak hours, ensuring that the demand is met. Additionally, the higher fares during peak hours generate more revenue for the company. Result: Uber's business intelligence strategy has been successful in making the company a market leader in the rental cab industry. By leveraging real-time data, Uber can make informed decisions about pricing and driver availability, which in turn leads to higher profits. The ability to analyze data and make informed decisions has helped Uber set a benchmark for other companies in the industry to follow. BI TECHNIQUES Data visualization: Data visualization is a technique used to represent data in a graphical format, such as charts, graphs, and maps. This technique helps businesses to identify trends, patterns, and insights from large amounts of data quickly and easily. Data visualization BI TOOLS Tableau is a powerful data visualization tool that allows users to create interactive dashboards, charts, and graphs. It offers a drag-and-drop interface and can connect to a wide range of data sources TABLEAU BI TECHNIQUES Data cleaning is the process of identifying and correcting or removing errors, inconsistencies, and inaccuracies in datasets. It is an essential step in the data analysis process because raw data is often incomplete, inconsistent, and contains errors that can lead to incorrect conclusions if not corrected Data cleaning BI TOOLS Google Colab is a cloud-based platform that allows users to run Python code in a Jupyter Notebook-style environment. It is a powerful and flexible tool for BI analysis, providing users with the ability to analyze and visualize data, build predictive models, and collaborate with team members in real-time Google colab BI TECHNIQUES Regression analysis is a commonly used statistical technique in business intelligence analytics. It is a powerful tool for analyzing the relationship between a dependent variable and one or more independent variables. Here are some ways in which regression analysis is used in BI: Regression Sales forecasting: Regression analysis can be used to predict future sales trends based on historical sales data and other factors such as seasonality, marketing campaigns, and economic conditions. Customer behavior analysis: Regression analysis can be used to analyze customer behavior and identify factors that influence customer purchase decisions, such as demographics, product features, and pricing. Risk analysis: Regression analysis can be used to identify factors that contribute to risk and estimate the probability of different outcomes. . 1. 2. 3. Cleaned game dataset B EI [Z G H | J title Cees Comm Oke) rating _positive_ratio user_reviews price_final price_original discount —_steam_deck Borderlands 2: 2014-02-11 12: win 9.0 - 10.0 cry 294 0.89 2.99 vim} Bridge Constru 2013-10-16 12: win, mac, linux 7.0-7.9 vrk 716 2.39 19.99 ETSI at} Master of Orio! 2016-08-25 12 win, mac 9.0 - 10.0 90 yak: Loki) 5.99 ct) RIOT: Civil Unri 2019-02-12 12 win, mac 40-69 1,280 ER) 16.99 vm a) Danganronpa % 2016-04-18 12 win, mac, linux 8.0-9.4 20,321 7.99 utcRe}e) clo cat} Injustice™ 2 - | 2017-11-14 12: win, mac, linux 8.0-10.0 yx 2.39 5.99 60 true Bean Battles 2018-08-22 12 win 9.0 - 10.0 5,671 0.49 0.99 slo aT} Magic Reali 2019-11-22 12: win, linux 7.0-7.9 Si? 3.89 12.99 rien) BURT e relevent ee PL ed c-AOa Ltn) 20 2.99 4.99 reat) Batman™: Arkt 2015-10-28 12 win, mac, linux 7.0-7.9 0.99 1.99 50 true Street Fighter ' 2017-10-24 12 win, mac, linux 8.0-10.0 31 499 9.99 stot} Old Man's Jour 2017-05-17 12 win, mac, linux 9.0 - 10.0 3.99 7.99 Ee at} The Deal 2017-02-17 12: win, mac, linux 9.0 - 10.0 try toi) fox:}:) 90 true Mibibli's Quest 2016-08-04 12 win, mac, linux 9.0 - 10.0 62 2.99 5.99 cleat) Your Bunny Wr 2017-12-03 12 win, mac, linux 8. ca yr 1.99 TS) Toso 2017-02-07 12 win I i Ext) 16.99 Esto} cite) Cel Lul ese tele LPL ; 5 499 chek Tet) See eee ey SO Ramm ace 0.51 3.99 Eyam Mount Your Fri 2014-07-29 12 win, mac, linux 8. Ee az 4.99 Colo) APA ee) ath Oa Led 149 2.99 lem) Bit wP leh 2009-07-08 12 win, mac, linux 9.0 - 10.0 2.09 boneh:) slot} Sid Meier's Pir: 2005-07-11 12 win, mac, linux 9.0 - 10.0 2.49 Behe) Vie} LEGO® Star We 2009-11-12 12: win, linux Ate 499 19.99 Vem) Midnight Ghos 2022-03-31 12 win 9.0 - 10.0 Kei) 19.99 iO) Pr ike) Pent: Se P-L) ROL) 5.99 chek cmt The Witch & Tl 2020-11-07 12 win, mac, linux 9.0 - 10.0 3.49 6.99 ct) LU Ura Layee ee LL 9.0 - 10.0 2.99 Behe) ren) I [e)N [en =b,( Samer 0u tsa (OLR Te 9.0 - 10.0 OE 2.99 ren) The Endless Er 2018-11-03 12: win 9.0 - 10.0 0.99 3.99 ee) NTBSS: Maste! 2018-10-04 12 win 7.0-7.9 1.99 3.99 TO) Back To Ashes 2020-04-20 1: win, mac, linux 9.0 - 10.0 E42) 10.99 yl cat} ETE Te lary 2021-02-02 12 win, mac, linux 9.0 - 10.0 ERI) 8.99 ila) ONE PIECE Wo 2019-07-11 12: win rat) 499 rchehe) ELON aT} <> Wi Sea Raw steam DLC and game dataset Co ry ee ee ee ee ni o|ols|2]/—)/o)/o)/a)/o)/o ce - -) EJs) e)[e] 10 20 30 40 60 0) 440 500 Bt] 570 620 tet) 730 peut 1,200 1,250 1,256 ays aril Level Talk terol cy Team Fortress Classi: prem Pit 4 Deathmatch Classic Half-Life: Opposing F Ricochet Half-Life ere leslie elaTo) Elie Mico EU LLG Half-Life 2 fern Tessa oe loll Gy Day of Defeat: Sourcr Half-Life 2: Deathma® pr Turley 2: Episode (€ ole) Elie 2: Episode 1 ACT sel 4 Left 4 Dead Left 4 Dead 2 Dota 2 Portal 2 Alien Swarm tere leet ocd (olor Rag Doll Kung Fu Rte O lente Oat Killing Floor Killing Floor Outbreat Killing Floor: Nightfall D 3 required_age developers 0 0 RS SIS Se SS SS SS fa IS fra eel ee WEI M Elia [Gearbox Si eye ee Ela [Gearbox St wea eel VECO Elia ['Valve'] Wo Ea Elio eel Weal Ia We Col Ea ['Valve" 1 aE WEE Ul era (‘Mark Heale ['Mark Healey’ [45] F publishers ['Valve'] AAS ['Valve'] Aelia AVA U) eel ia) ELCs) Cla Ea ['Valve'] AE AAS Aelia Ela AVA U| aE ecu Clow Ae Icul ['Valve'] ave U| avo ie iewy alow AeICul aCe cc] packages vcs Sw [29] re Le}) [31] Ey) [33] ey eel yey vA} [35] el -nps-ie2 [37] EE) [25] iat a [38] eer} arr L [516, 469] [197845, ¢ [1053, 202 [2481, 22( [49307, 1¢ eye APY |e yAcK lone (‘Tripwire Int ['Tripwire Inter [63] (‘Tripwire Ini ['Tripwire Inter [1579] [‘Tripwire Int [‘Tripwire Inter [1886, 52: (‘Tripwire Int ['Tripwire Inter [2318, 52¢ La) i ay 4 platforms categories genres Elena aed ['windows', 'mac', 'linux' ['Multi-player [‘Action'] 0 ['windows’, 'mac’, ‘linux’ ['Multi-player [‘Action'] lalate (NSPE Lain MOLL Een oat | ['windows', 'mac', ‘linux’ [‘Multi-player [‘Action'] ['windows', 'mac', ‘linux’ ['Single-playe [‘Action'] Ula (h\ Soe ai LOL Eyl eee E ['windows’, 'mac'; ‘linux’ [‘Single-playe [‘Action'] ['windows’, 'mac' 'linux' ['Single-playe ['Action'] ['windows', 'mac', 'linux' ["Single-playe [‘Action'] fav Uiars yee Toon La ete oe eo lL ['windows', 'mac', 'linux' [‘Multi-player [‘Action'] Nia iiate [ox Sauua Leora ATED Gm Meta] oN COAL ['windows', ‘mac’, ‘linux’ [‘Multi-player [‘Action'] ['windows', 'mac', ‘linux’ [‘Multi-player [‘Action'] ['windows', 'mac', ‘linux’ ['Single-playe [‘Action'] ['windows’, 'mac’, 'linux' ['Multi-player [‘Action'] ['windows’, 'mac', ‘linux’ [‘Single-playe [‘Action'] ['windows', 'mac', 'linux' ["Single-playe ['Action'] faints ela Gen cite a AEN 0 [‘windows’, ‘mac’, ‘linux’ [‘Multi-player [‘Action’, 'F ['windows', 'mac'] estate| SEN a | ['windows’, 'mac', 'linux' ["Single-playe ['Action'] ['windows', ‘mac’, ‘linux’ [‘Multi-player [‘Action’, 'F ['windows', 'mac'; 'linux' ['Single-playe ['Action’, 'A faite \tea) ['Single-playe ['Action'] [‘windows’, 'mac’, ‘linux’ ['Multi-player ['Action’, 'F ['windows'] ['Single-playe ['Indie'] ['windows’, 'mac’, ‘linux’ ['Multi-player [‘Action'] ['windows'’, 'mac'’, 'linux' ['Single-playe [‘Action'] ['windows’, ‘mac’, ‘linux’ ['Single-playe [‘Action'] ['windows’, 'mac'; 'linux' ['Single-playe [‘Action'] Ls release_date 11/1/2000 4/1/1999 5/1/2003 Care| BUR Ub ee 11/1/2000 11/8/1998 3/1/2004 6/1/2001 SORA OU UPL CUPL 7/2/2010 SOUR TeLO I) UPI PLU Os) 5/1/2006 LATA) BLO aU aLOpzt ors BURP) 11/16/2009 7/9/2013 4/18/2011 7/19/2010 8/21/2012 10/12/2005 3/14/2006 BCP) 7/24/2009 5/19/2010 Cleaning steam DLC and game dataset t pandas as pd input_file_path = 'AsmtDataset/Steam—Games-and-DLC.x1sx' output_file_path = 'AsmtDataset/FinalC leaned—Steam-Games—and-DLC-new. xlsx’ pd. read_excel(input_file_path df.drop(columns=df.columns [0] ‘price'| = df|'price').apply : str(x) + ' $" df.replace('\[|\]', '' df.replace("'", '"* df.drop('rating', .to_excel(output_file_path, print(f"Cleaned file saved to {output_file_path}" VA I Chart 2: Possitive vs negarive Top 10 most rated Genres i Mostly Negative Genres > i Mostly Positive ction” D7 le "Strategy" D7 “Simulation” ae “Action”, “Adventure” [i a “Action”, "Indie" 7 777 ws "Casual", “Simulation” “Action”, "RPG" "Action", "Adventure", "Indi.. TTT "Adventure", "Indic’ EET “Adventure” OK 5K 10K 15K 20K 25K 30K 35K 40K 45K Rating.1 = Chart 3: Top Most Owned games Owners Name 20000-50000 50000-100000 200000-500000 500000-1000000 2000000-5000000 ORBITALIS e HEART e 3 Stars of Destiny e 3SwitcheD e 7 Days to Die 7 Grand Steps: What Ancients Begat 7 Wonders Il 7 Wonders of the Ancient World 7 Wonders: Ancient Alien Makeover 7 Wonders: Magical Mystery Tour e 7 Wonders: Treasures of Seven e 8BitMMO ° 9.03m e 9th Company: Roots Of Terror e 10 Second Ninja 18 Wheels of Steel: American Long H.. 18 Wheels of Steel: Extreme Trucker 99 Levels To Hell 99 Spirits e 100% Orange Juice ° 140 e 688(1) Hunter/Killer e 1001 Spikes 3079 — Block Action RPG 3089 — Futuristic Action RPG A Fistful of Gun A Hat in Time ° A New Beginning - Final Cut e A Story About My Uncle AVirus Named TOM e A Walk in the Dark e AWizard”s Lizard e A.I.M. Racing e A.R.E.S.: Extinction Agenda ° AaaaaAAaaaAAAaaAAAAaAAAAA!!! f.. e Dashboard 1: Dashboard 1 combines all of the mentioned charts to offer insightful statistics on the variety and classification of top- rated games and their genres. From here, a user can choose each product using analytical data in order to follow trends and the most popular games. There is a suitable selection from there to be able to find the appropriate games. Chart 6: Total games & DLCs for each group of platforms Platforms “windows”, “linux” | | 117 Chart 7: Amount of owners for each group of platforms Owners Platforms) 0-20000 20000-50000/50000-1000..100000-200../200000-500. /500000-100.1000000-20..2000000-50..5000000-10..10000000-2..|20000000-5.. “windows” a 1,377 5 321 a 288 a 267 281 J 143 | 136 a 71 l] 14 | 2 | 2 windows”. ¢5 4 10 5 ss 7 3 4 2 E linux 56 |s1 [> |» [29 a 2 I: 86 | 124 | 160 I. [= i 56 [| 21 ] 10 iE 5 windows”. |: (ss mac windows”, tee nen fg oad 86 mac”, “linux Dashboard 2: Dashboard 2 will show you the amount of games and DLCs got added every year since 1997, the total of games and DLCs added. It also show the amount of games that support each group of platform and the estimated amount of users that own the game in each group of platforms. This will help us see the game in which group of platforms are the most popular among the users so the game developers can create their game to support the optimal amount of platforms within their budgets. Chart 10: Top 20 games based on positive ratio Weel g=) STU aV NOL éy Pacify NBA 2K23 Py Ry) a Wy fee] 0)) 15,141 wy aA DRAGON B. re Eldar 1a Man Arkham Knight 61,510 SI-F-asf-laa |} eran WW covss tone Game of the Mog Shotgun Le] gul-leceacl Coy Colla] Dashboard 3: This dashboard displays stats for the best-ranked games based on the total number of users, as well as sales and non- sale games that are highly rated, so that we can determine if the sale influences the game's rating or not. INFLUENCE OF BI Analyzing player behavior: BI can help analyze data on player behavior, such as the time spent on the platform, games played, and in-game actions. This information can help game developers understand player preferences and tailor their games accordingly. Performance optimization: BI can help game developers analyze data on game performance, such as latency, frame rates, and load times. This information can help developers optimize their games for better performance and user experience. Revenue optimization: BI can help game developers analyze data on player spending patterns, such as the type of in-game purchases players make and how frequently they make them. This information can help developers optimize their in-game economy and pricing models to maximize revenue. Here are some ways in which BI can help the Steam platform and its game developers: 1. 2. 3. Overall, BI can help Steam and its game developers make data-driven decisions and improve player engagement, retention, and revenue. Legal issues involved in exploiting user data for business intelligence. Personal data privacy and security have been the focus of legislation and regulations. Furthermore, most websites, online services, and mobile applications include a privacy policy and terms of service agreement (also known as terms of use, user agreement, and so on) that users acknowledge by clicking or continuing to use. A privacy policy is a good business practice, but it may be mandated by law or by third- party services that gather data through a website. Privacy policies and terms of service (TOS) should be reviewed on a regular basis to ensure that they appropriately reflect business operations, particularly when it comes to the collecting, use, and sharing of personal data Privacy Legal issues involved in exploiting user data for business intelligence. In Steam Privacy laws: Steam collects and uses user data to provide personalized recommendations, advertising, and other services. They must comply with privacy laws, such as the General Data Protection Regulation (GDPR) in the European Union or the California Consumer Privacy Act (CCPA) in the United States. Steam must obtain user consent for collecting and using their data and provide transparency about how their data is being used. Data security: Steam must take appropriate measures to protect user data from unauthorized access, use, or disclosure. Data breaches can result in legal liabilities and reputational damage for Steam. Data ownership: Users have legal rights to their data, including the right to access, correct, and delete their data. Steam must ensure that they are not using user data in ways that violate these rights. 1. 2. 3. Legal issues involved in exploiting user data for business intelligence. 4. Content moderation: Steam allows users to share user-generated content, such as game mods and reviews. Steam must ensure that they are not hosting illegal or harmful content, such as copyrighted material or hate speech. 5. Consumer protection: Steam must ensure that they are not engaging in unfair or deceptive practices, such as false advertising or misleading pricing. Failure to comply with these legal requirements can result in legal liabilities, fines, and reputational damage for Steam. Therefore, Steam must ensure that they have appropriate policies and procedures in place to comply with applicable laws and protect user data and interests. In Steam