QUESTION 3 [20 marks]

Assignment 1 - Ethics and Global Strategies in Bl Summer 2023 It must be submitted through the "Assignment 1 - Ethics and Global Strategies in BI" in Assignment Submission Folder provided in the D2L. It is important that you specify your name in the DOCX file. The attachment name should follow the following convention: BUSA532 ASSIGNMENT1 FIRSTNAME LASTNAME.DOCX BI Ethical Case: You are CIO of Facebook, and you want to buy data from Google as soon as possible. However, you don't know the origins of the data and how the data was collected from Google. What should you do? 1. Identity and discuss about the ethical dilemma that you faced (1 point). 2. Stakeholders are directly or indirectly affected by your decisions. Provide at least 3 specific stakeholders affected by the situation. (1 point) 3. Discuss the challenges in addressing the ethical dilemma by identifying at least 2 key issues and their subsequent implications/ramifications (1 point). 4. How would you have responded to the ethical dilemma? Apply at least two ethical models to brainstorm the questions you want to ask (1.5 points). 5. How would you implement solutions to respond to the ethical dilemma? Apply at least two ethical models to brainstorm the solutions (1.5 points). Global Strategy Case: You are CIO of Facebook, and you want to build online video rental service like Amazon Prime or Netflix in China. However, pirated movies are very common in China, and the government lacks regulations to protect intellectual property. What should you do? 1. Develop PEST analysis for Facebook to build the service in China (1.5 points). 2. Recommend at least three strategies for Facebook to build the service (1.5 points). SQL Server Installation: Please follow the instructions in D2L to install all three components of SQL Server (SSMS, SSIS and SSAS) and provide screenshots that you successfully install them (1 point). The following criteria will be used to grade the assignment: Answers are correct, and writing are polished. ********NOTE

Your Task In response to the following scenario, students will produce a one-page infographic and a 500-750 word supporting paper detailing what would be included in a staff professional development workshop entitled 'Developing Intercultural Competence'.

Discussion Question # 2: Noting the failure of Charlie's social networking platform to achieve its intended goals of sharing information and building a community of support, what should the researchers have done? Arguably, social networking is not central to the purpose of a diabetes health care system. Should they have simply dropped this functionality, or should they have adopted a stronger role in moderating these forums? What are the tradeoffs of each decision?

Discussion Question #1: From the outset, the research team was explicitly concerned about inequality in type 2 diabetes care and outcomes. Their aim was not just to improve to improve diabetes treatment in general, but to do so for all. How can they best achieve this? Might Technology different users sometimes require different treatment protocols? Does the research team have a responsibility to single out users who are not receiving the full benefit of Charlie's interventions for special attention and/or treatment?

Discuss some major issues in implementing business intelligence (BI) as well as the support that artificial intelligence (AI) can provide to business decision makers, including the benefits of automatic and autonomous decision making.

QUESTION 1 [25 marks] 1. Using the file BOC_Store_Database.xlsx, Desktop which can be published in Power BI Service. construct a Dashboard in Power BI Follow the tasks given below in compiling the Dashboard. a) Using the power query editor in Power BI desktop, clean the data and load it onto Power BI (1 mark). b) Construct a data model in Power BI using star schema architecture (2 marks). c) Using appropriate visualizations, create the Dashboard. The Dashboard should have the data filtering capability including slicing functions. To effectively design a Power BI Dashboard, it's important to focus on a specific area to ensure that the Dashboard serves its intended purpose. (15 marks). (Submit the Dashboard as a Power BI report file) 2. Interpret the visuals presented in the Dashboard (7 marks) (this can be done in a Word document).

QUESTION 2 [5 marks] You work as a data analyst for a consultancy firm that seeks to analyse Olympic sports data. They have provided you with a dataset containing player information (Olympic_data.xlsx), including age. Your task is to first create a Power BI data model that incorporates a new column, categorizing players into different age groups based on their ages, and then produce the following visuals with the capability to distinguish between both summer and winter games. Utilize Power BI to generate a new column named "Age Group" that classifies players into specific age groups according to the following criteria: 0 to 14, 15 to 20, 21 to 25, 26 to 30, 31 to 35, 36 to 45, 46 to 55, greater than 55 (1) Present the distribution of players' ages alongside their respective age groups using a column chart and provide commentary on the observed distribution (2.5 marks). (2) Display the medals won in different age groups-Gold, Silver, and Bronze using a suitable visualization, and provide comments on the findings (2.5 marks). Submit the visuals as a Power BI report file. Interpretation can be done in a Word document.

QUESTION 2 [10 marks] a) Categorize countries into five clusters based on the relationship between total greenhouse gas emissions (kt of CO2 equivalent) and GDP per capita (constant 2015 US$). This analysis will utilize data from the World Bank World Development Indicators database for the year 2018 (File: World Bank Data.xlsx) (5 marks). b) Create a table displaying countries assigned to various clusters (use clusters as a slicer) (2 marks). c) Illustrate these five clusters on a map (3 marks). (Submit the report as a Power BI report file)

Assignment Procedure Step 1: First Phenomena Observe one phenomen on for each of the following three categories using the examples above as a reference. Your phenomena should be different from these examples. Judd D. Bradbury Ⓒ 1. Science 2. Business 3. General Observation (neither science nor business) Data Visualization Page 7 Based on your observations answer the following questions for each of the 3 types of phenomena. (refer to the model examples above for answering the following questions) a) Describe the phenomenon and procedure in your own words. Adding a photo of your phenomena is mandatory. This establishes that you know what the data is measuring. b) Capture the creation of your data for the phenomenon using excel. There should be minimum of 6 observations in your data table. Paste a screen shot of your excel data table including the date and time stamp on your screen./nc) Create a visualization of your phenomena using an excel chart. Use a chart that is appropriate for your data. Please ensure your chart has a title and meaningful labels for the X axis and the Y axis. Paste a screen shot of your visualization including the date and time stamp on your screen. d) Create a color encoded data table. Highlight the insight using the color coding. e) Provide a bullet point list of insights identified in the data set you created. Step 2: Second Phenomena a) Describe the phenomenon and procedure in your own words. Adding a photo of your phenomena is mandatory. This establishes that you know what the data is measuring. b) Capture the creation of your data for the phenomenon using excel. There should be minimum of 6 observations in your data table. Paste a screen shot of your excel data table including the date and time stamp on your screen. c) Create a visualization of your phenomena using an excel chart. Use a chart that is appropriate for your data. Please ensure your chart has a title and meaningful labels for the X axis and the Y axis. Paste a screen shot of your visualization including the date and time stamp on your screen. d) Create a color encoded data table. Highlight the insight using the color coding. e) Provide a bullet point list of insights identified in the data set you created./nStep 3: Third Phenomena a) Describe the phenomenon and procedure in your own words. Adding a photo of your phenomena is mandatory. This establishes that you know what the data is measuring. Judd D. Bradbury Ⓒ Data Visualization Page 8 b) Capture the creation of your data for the phenomenon using excel. There should be minimum of 6 observations in your data table. Paste a screen shot of your excel data table including the date and time stamp on your screen. c) Create a visualization of your phenomena using an excel chart. Use a chart that is appropriate for your data. Please ensure your chart has a title and meaningful labels for the X axis and the Y axis. Paste a screen shot of your visualization including the date and time stamp on your screen. d) Create a color en coded data table. Highlight the insight using the color coding. e) Provide a bullet point list of insights identified in the data set you created. Step 4: Submission Submit your assignment documented in Microsoft Word in eLearning.

QUESTION 3 [20 marks] A company senior executive has been provided with raw data from various divisions within the organization. She seeks guidance on how to extract valuable information from this data to make well-informed decisions concerning company operations. She has assigned you, a business analyst, a task to provide with her a comprehensive report with some interpretations using a Power BI desktop. Data are given in the following files: XYZ_Company_Database.xlsx and XYZ_Customers.xlsx. She is very keen to get information about customers in addition to other components such as sales, production costs, regions, etc. She is also eager to know the year-to-date sales and production costs in terms of calendar year as well as financial year. Follow the tasks given below in compiling the report. 1. Using the power query editor on the Power BI desktop, clean the data and load it into Power BI (1 mark) 2. Construct a data model in Power BI using star schema architecture (1 mark) 3. Using appropriate visualizations, create the report. The report should have data filtering capability including slicing, drill-down, and drill-through functions. The report can be a maximum of four pages in the Power BI report canvas. (10 marks) 4. Interpret the visuals presented in the report (this can be done in a Word document) (8 marks) Submit the report as a Power BI report file. Interpretation can be done in a Word document.