1 of 28

Team Analysis Presentation

By: Bochen Lu, Sydney Peterson and Amanda Goldsmith

2 of 28

Meet the Team!

Meet Our Organization!

Bochen

Sydney

Amanda

3 of 28

Company Overview

Current State of BI

Data Visualizations

Text/Web Analytics

Emerging Trends

Recommendations

Data Warehousing

Data Mining

Outline

Mission & Structure

Sony’s current usage of BI and data visualizations

Strategic opportunities this could create & operational problems this could solve

Our BI recommendations for Sony

Data Warehousing and Data Mining opportunities in the Sony ecosystem

4 of 28

Company Overview

01

Sony Group Corporation

5 of 28

Sony Group Corporation

Kando - “To fill the world with emotion”

  • Founded in 1946.

​

  • International conglomerate and technology company valued at $103.4 billion (Stock Analysis, 2023).

​

  • Known for leading the industry in music, gaming, consumer & professional electronics.

​

  • Divided in 6 distinct business functions.

6 of 28

Sony’s 6 Business Functions

7 of 28

02

Sony’s Current State of BI

8 of 28

Sony Music Entertainment

  • Sony Music Entertainment is the largest record label and publishing company in the US by revenue (Zippia, 2023)

​

  • Key decisions supported by BI include artist support, artist investments, fan engagement, dynamic marketing.

​

  • Proprietary Artist Portal and Grooveforce BI platforms.

9 of 28

ArtistPortal

Impact:

​

  • Evolutionary digital artist payment platform.
  • Transformed artist payment cycle from ~9 months to real-time.
  • Instant cash-out & advances.

BI Capabilities & Opportunities:

​

  • Real-time trend analysis.
  • Robust trend forecasting.
  • Enables higher ROI from automated dynamic artist investmenting through real time advances.

​

10 of 28

Grooveforce Analytics

Sony developed analytics platform

​

  • Combines data sources including user, streaming, live, media, and partner data.
  • Visualizations support business improvement for fan engagement, interest trends, targeted marketing, and sales.

​

11 of 28

Grooveforce Analytics

User locations, preferences, and trends is used for targeted promotions, live event planning.

​

Opportunities:

​

  • Analytics: Large data pool

​

  • SaaS: Centralized data channels

​

  • True audience understanding

​

​

12 of 28

Sony Interactive Entertainment

  • Sony Interactive Entertainment is the 2nd largest video game company in the US by revenue (Newzoo, 2023)

​

  • Key decisions supported by BI include pricing, marketing, and sales.

​

  • Centralized data sources for automated reporting, and PS Plus subscription service.

​

​

13 of 28

Sony Interactive Digital Marketing

Impact:

  • Centralized ~500 data channels.
  • Decreased lead time from 10 days to 24 hours.
  • Decreased error margin from 5% to 2.3% (Patterson, 2021)

BI Capabilities & Opportunities:

  • Personalized, cross-platform marketing.
  • Subscription based product model.

​

14 of 28

Sony’s BI Challenges

  • Sony is a global conglomerate organization with various departments. Defining a common data strategy is difficult under such conditions.

​

  • Highly specialized business functions require different BI platforms, presenting synergistic challenges

​

  • Lack of cross-functional and predictive BI processes causes frequent supply chain disruptions and customer dissatisfaction.

15 of 28

03

Data Warehousing

&

Data Mining

16 of 28

Data Warehousing

Support

Dynamic Marketing

Supply Chain Analysis

Competitive Analysis

Trend Forecasting

17 of 28

Data Warehousing

  • Data Sets
  • Dashboards
  • Data Quality
  • Granularity

18 of 28

Data Warehousing

Applications

Challenges

  • Product Analysis
  • Marketing
  • Data Consolidation
  • Scalability
  • Buy-In

19 of 28

Data Mining

20 of 28

Data Mining

  • Marketing
  • Sales
  • Data Preparation
  • Data Freshness
  • Company Culture

Challenges

Applications

21 of 28

04

Text & Web Analytics

Strategic opportunities this could create and operational problems this could solve for Sony

22 of 28

Marketing & Advertising

Supply Chain & Product Quality

Customer Retention

Text Analytics

Knowledge discovery from unstructured text-based data

23 of 28

Websites & Ecommerce Sites

Customer &

User Insights

Competitive Analysis

Web Analytics

Discovering patterns and drawing insights from web-based data

24 of 28

Centralization

Diversification

Analytics

BI Recommendations

Centralized source to empower data driven decisions

Framework built with diverse tools and resources

​

​

Adopt a robust supply chain management system

25 of 28

Thank you!

​

Any Questions?

26 of 28

Resources

Adams, S., & Filous, A. (2020, December 8). 5 ways to develop a data-driven mindset. Built In. Retrieved January 15, 2023, from https://builtin.com/founders-entrepreneurship/data-driven-mindset

Bloomberg. (2022, January 20). Sony Bank to differentiate its business by adopting Bloomberg's value-added data and cutting-edge delivery technology for fully cloud-based computing | press | Bloomberg LP. Bloomberg.com. Retrieved January 15, 2023, from https://www.bloomberg.com/company/press/sony-bank-to-differentiate-its-business-by-adopting-bloombergs-value-added-data-and-cutting-edge-delivery-technology-for-fully-cloud-based-computing/

Commercient. (2019, June 18). 5 reasons why real-time data is crucial for your business. Commercient. Retrieved January 29, 2023, from https://www.commercient.com/5-reasons-why-real-time-data-is-crucial-for-your-business/

Data Engineer at Sony PlayStation. GameJobs.co. (n.d.). Retrieved January 15, 2023, from https://gamejobs.co/Data-Engineer-at-Sony-Playstation-5363

DataUntold. (2022, February 22). Top 13 data mining challenges and pitfalls. DataUntold. Retrieved February 3, 2023, from https://datauntold.com/data-mining-challenges/

Executive Insights by Decisive Data. (2017, May 24). Microsoft Power BI Community. Retrieved January 23, 2023, from https://community.powerbi.com/t5/Data-Stories-Gallery/Executive-Insights-by-Decisive-Data/td-p/181742

expert.ai. (2022, May 20). 10 practical text mining examples to leverage right now. expert.ai. Retrieved February 12, 2023, from https://www.expert.ai/blog/10-text-mining-examples/

Farmer, D. (2021, January 11). 6 top business benefits of real-time data analytics: TechTarget. Business Analytics. Retrieved January 22, 2023, from https://www.techtarget.com/searchbusinessanalytics/feature/6-top-business-benefits-of-real-time-data-analytics

Fatima, N. (2022, November 14). What is a data warehouse – definition, Example & Benefits. Astera. Retrieved January 29, 2023, from https://www.astera.com/type/blog/data-warehouse-definition/

Fernandez, R. (2023, January 5). Sony says its PlayStation 5 shortage is finally over, but it’s still hard to buy. NPR. Retrieved January 22, 2023, from Sony says PlayStation 5 shortage is over after surpassing 30 million units sold : NPR

Forbes Content Studio. (2020, August 26). How Sony Music Uses Data To Connect Artists With Fans. Forbes. https://www.forbes.com/sites/forbescontentmarketing/2020/08/26/how-sony-music-uses-data-to-connect-artists-with-fans/?sh=731c3c7d5e1c

GameJobs. (2022). Data Warehouse Engineer at Sony PlayStation. GameJobs.co. Retrieved January 29, 2023, from https://gamejobs.co/Data-Warehouse-Engineer-at-Sony-Playstation

​

​

​

GeeksforGeeks. (2022, December 11). Web mining. GeeksforGeeks. Retrieved February 12, 2023, from https://www.geeksforgeeks.org/web-mining/

Gupta, A. (2022, December 22). The best applications of Data Warehousing. DataChannel. Retrieved January 29, 2023, from https://www.datachannel.co/blogs/best-applications-of-data-warehousing#:~:text=The%20warehouses%20can%20be%20used,maximize%20profits%20at%20both%20ends.

Jigsaw Academy. (2022, November 2). Data Mining Challenges: A comprehensive guide(2021). Jigsaw Academy. Retrieved February 3, 2023, from https://www.jigsawacademy.com/blogs/data-science/data-mining-challenges

Kure, M. S. C. (2022, August 30). Sony Pictures Entertainment’s Acclaimed Sequel to its 2004 ERP Implementation. CIO. https://www.cio.com/article/405599/sony-pictures-entertainments-acclaimed-sequel-to-its-2004-erp-implementation.html

Lawton, G. (2021, February 26). Top 8 business intelligence challenges and how to handle them: TechTarget. Business Analytics. Retrieved January 7, 2023, from https://www.techtarget.com/searchbusinessanalytics/tip/Top-11-business-intelligence-challenges-and-how-to-overcome-them

Maguire, J. (2020, June 15). Top 10 benefits of a Data Warehouse. Datamation. Retrieved January 29, 2023, from https://www.datamation.com/big-data/top-10-benefits-of-a-data-warehouse/

Medical products - sony pro. Products - Sony Pro. (n.d.). Retrieved February 14, 2023, from https://pro.sony/ue_US/products/medical

Mitra, S. (2020, September 29). Top 5 challenges of data warehousing. DWBI.org. Retrieved January 29, 2023, from https://dwbi.org/pages/13

Naeem, T. (2021). Data warehouse concept: Kimball vs. Inmon approach. Astera. https://www.astera.com/type/blog/data-warehouse-concepts/

Otremba, C. (2019, October 10). What you need to know about CCPA. Bidtellect. Retrieved February 12, 2023, from https://bidtellect.com/2019/10/what-you-need-to-know-about-ccpa/

Patterson, C. Newzoo. (2023, February 17). Top Public Video Game Companies | By Revenue. https://newzoo.com/insights/rankings/top-25-companies-game-revenues(2022, February 28). How Sony Interactive Entertainment built a winning marketing data strategy. MarTech. https://martech.org/how-sony-interactive-entertainment-built-a-winning-marketing-data-strategy/

PDG. (2022, December 20). Sony Pictures Entertainment: Revenue pipeline management. PDG. Retrieved January 29, 2023, from https://pdgc.com/clients-sony-pictures-entertainment/

Perry, T. (2021, December 17). Sony looks to improve data management at universities through Blockchain Technology. GOOD. Retrieved January 10, 2023, from https://www.good.is/education/sony-blockchain-schools-data

​

27 of 28

Resources

Privacy statement. (n.d.). Retrieved January 10, 2023, from https://pro.sony/pro/pages/privacy/Privacy_statement_en_EU.html

Rajashree, & Sinha, V. (2023, January 9). The need for Data Warehouse in 2022. Hevo Blog - Transformative ideas and real insights on all things Data. Retrieved January 29, 2023, from https://hevodata.com/blog/need-for-data-warehouse/#:~:text=The%20need%20for%20Data%20Warehouse%20is%20to%20generate%20reports%2C%20feed,(Extract%20Load%20Transform)%20process.

Rawat, S. (2016, June 18). Decision-making under certainty, risk and uncertainty. Essays, Research Papers and Articles on Business Management. Retrieved February 15, 2023, from https://www.businessmanagementideas.com/decision-making/decision-making-under-certainty-risk-and-uncertainty/3371

Reed, C. (2022, May 27). Sony data breaches: Full timeline through 2022. Firewall Times. Retrieved January 15, 2023, from https://firewalltimes.com/sony-data-breach-timeline/#:~:text=Sony%20initially%20discovered%20that%20an,17%20and%20April%2019%2C%202011

Reed, C. (2022, May 27). Sony data breaches: Full timeline through 2022. Firewall Times. Retrieved January 31, 2023, from https://firewalltimes.com/sony-data-breach-timeline/

Robinson, A. (2022, November 1). PS5 hits 25 million, but Sony gaming profits fall 49% due to rising costs. VGC. https://www.videogameschronicle.com/news/ps5-hits-25-million-but-sony-gaming-profits-fall-49-due-to-rising-costs/

Samuel, N. (2022, May 10). Role of web mining in business intelligence simplified 101 - learn. Hevo. Retrieved February 12, 2023, from https://hevodata.com/learn/web-mining-in-business-intelligence/#:~:text=The%20goal%20of%20Web%20Mining,mining%2C%20and%20web%20usage%20mining.

Schneider, J. (2021, November 25). Sony: Global chip shortage 'more serious' than expected. PetaPixel. Retrieved January 22, 2023, from https://petapixel.com/2021/11/24/sony-global-chip-shortage-more-serious-than-expected/

Shafique. (2017, November 22). Top10 Dashboard Design Errors (and How to Avoid Them). FusionBrew. Retrieved January 23, 2023, from https://www.fusioncharts.com/blog/page-404/

Sharda, R. (2023b). Business Intelligence, Analytics, And Data Science: A Managerial Perspective, 4/E. PEARSON INDIA.

Software Testing Help. (2023, January 11). Data mining examples: Most common applications of data mining 2023. Software Testing Help. Retrieved February 3, 2023, from https://www.softwaretestinghelp.com/data-mining-examples/

​

​

Sony - Technology. (2022, December 5). Sony Group | Empowering Artists Through Data Analytics. YouTube. Retrieved January 15, 2023, from https://www.youtube.com/watch?v=AHpRy7kljUw

Sony - Technology. (2022, December 6). Sony Group | Empowering artists through data analytics. YouTube. https://www.youtube.com/watch?v=AHpRy7kljUw

Sony Bank to differentiate its business by adopting Bloomberg’s value-added data and cutting-edge delivery technology for fully cloud-based computing. (2022, January). Bloomberg. Retrieved January 16, 2023, from https://www.bloomberg.com/tosv2.html?vid=&uuid=37935a33-95e2-11ed-8cb5-484544454664&url=L2NvbXBhbnkvcHJlc3Mvc29ueS1iYW5rLXRvLWRpZmZlcmVudGlhdGUtaXRzLWJ1c2luZXNzLWJ5LWFkb3B0aW5nLWJsb29tYmVyZ3MtdmFsdWUtYWRkZWQtZGF0YS1hbmQtY3V0dGluZy1lZGdlLWRlbGl2ZXJ5LXRlY2hub2xvZ3ktZm9yLWZ1bGx5LWNsb3VkLWJhc2VkLWNvbXB1dGluZy8=

Sony Corporate Report 2022. (2022). Sony.Com. Retrieved January 9, 2023, from https://www.sony.com/en/SonyInfo/IR/library/corporatereport/CorporateReport2022_E.pdf

Sony Corporate Strategy Meeting FY2022. Sony Group Portal - Sony Global Headquarters. (2022, May 18). Retrieved January 7, 2023, from https://www.sony.com/en/SonyInfo/News/Press/202205/22-021E/

Sony Corporate Strategy Meeting FY2022. Sony Group Portal - Sony Global Headquarters. (2022, May 18). Retrieved January 8, 2023, from https://www.sony.com/en/SonyInfo/News/Press/202205/22-021E/

Sony Corporate Strategy Meeting FY2022. Sony Group Portal - Sony Global Headquarters. (2022, May 18). Retrieved January 8, 2023, from https://www.sony.com/en/SonyInfo/News/Press/202205/22-021E/

Sony Group Corporation (SONY) Market Cap & Net Worth. (n.d.). Stock Analysis. https://stockanalysis.com/stocks/sony/market-cap/

Sony Group Portal - AI Initiatives - AI Technology. (n.d.). https://www.sony.com/en/SonyInfo/sony_ai/technology/

Sony Group Portal - Corporate Data. (2022). Retrieved January 7, 2023, from https://www.sony.com/en/SonyInfo/CorporateInfo/data/

Sony Group Portal - Sony Global - Corporate Info. (n.d.). Retrieved January 9, 2023, from https://www.sony.com/en/SonyInfo/CorporateInfo/

Sony Group. (2022, January 5). Vision-S exhibiting at CES 2022, entering a new phase. Sony Group Portal - Sony Global Headquarters. Retrieved January 15, 2023, from https://www.sony.com/en/SonyInfo/News/Press/202201/22-002E/

Sony harnesses music streaming data to optimize marketing efficiency with. (2022). Tableau. https://www.tableau.com/solutions/customer/sony-harnesses-music-streaming-data-optimize-marketing-efficiency-tableau

28 of 28

Resources

Sony Leans On Automation To Drive Digitization, Cut Costs: FT. (2021, July 12). Yahoo. Retrieved January 9, 2023, from https://finance.yahoo.com/news/sony-leans-automation-drive-digitization-113527835.html?guccounter=1&guce_referrer=aHR0cHM6Ly93d3cuZ29vZ2xlLmNvbS8&guce_referrer_sig=AQAAAGafm_nhojHbQ43wOrwbIDx_xjK99fEKzwd_3celvHadEk4pRKuyPNPo3D2u3EUbYalf_NwPZvmQh0LAtE-ZIFa8XLS_KkpVw9dvmC9YHh-NGfHG_sRhKldpqDGjnlr100hDHowh8XNVxd7jX3wM125hkPpSLkdqqIB05zGYkAmt

Sony Net Worth 2010-2022: Sony. Macrotrends. (n.d.). Retrieved January 21, 2023, from https://www.macrotrends.net/stocks/charts/SONY/sony/net-worth

Sony. (2023). About our group. About Our Group | About Us | Sony Financial Group. Retrieved February 15, 2023, from https://www.sonyfg.co.jp/en/company/about_group.html

Sony. (2023). Sony Group Portal: R&D center: Research areas: Image & video. R & D Center. Retrieved February 15, 2023, from https://www.sony.com/en/SonyInfo/research/research-areas/image-video/

Sony’s struggle with Music. (2016, November 18). Technology and Operations Management. https://d3.harvard.edu/platform-rctom/submission/sonys-struggle-with-music/

Sony's Purpose & Values. Sony Group Portal - Home. (n.d.). Retrieved January 8, 2023, from https://www.sony.com/en/SonyInfo/CorporateInfo/purpose_and_values/

Studio, F. C. (2022, December 14). How Sony Music uses data to connect artists with fans. Forbes. Retrieved January 10, 2023, from https://www.forbes.com/sites/forbescontentmarketing/2020/08/26/how-sony-music-uses-data-to-connect-artists-with-fans/?sh=4c36fe705e1c

The 10 Largest Record Labels In The United States – Zippia. (2023, March 1). https://www.zippia.com/advice/largest-record-labels/

Treder, M. (2019). Becoming a data-driven organization: Unlock the value of data. Springer Vieweg. https://www.springer.com/gp/book/9783662603031

What is a data warehouse? IBM. (n.d.). Retrieved January 22, 2023, from https://www.ibm.com/topics/data-warehouse#:~:text=Smarter%20decision%2Dmaking%3A%20A%20data,smarter%20decisions%20in%20virtually%20every

Worldwide Data Collection System. Sony Group Portal - Worldwide Data Collection System. (2019). Retrieved January 10, 2023, from https://www.sony.com/en/SonyInfo/csr_report/environment/data/method/system.html#:~:text=Sony%20uses%20a%20cloud%2Dbased,from%20sites%20around%20the%20world.

Yaddow, W. (2020). Avoid these mistakes on your data warehouse and BI projects. Dataversity https://www.dataversity.net/avoid-these-mistakes-on-your-data-warehouse-and-bi-projects/

​