Category: Data Analytics

I want info transferred from website in excel sheet. the name/address/phone #/Grades/ contact name=Dean priority if not seen than principle / email of Dean or principle.This info can be found on https://www.philasd.org/contactus/ Under schools then school directory. Examples of how excel should look is uploaded below

You are a data analyst working for GlobalTech Solutions, a multinational company that provides training to employees across different departments. The company’s training programs are categorized into various types, such as Technical, Soft Skills, Leadership, and Compliance. The HR department is seeking insights into how training resources are allocated, employee satisfaction with different training types, and how training costs compare across departments.
The HR team has tasked you with analyzing the training data to help them make informed decisions about future training investments and identify opportunities to improve employee satisfaction with the programs offered.
Your Objective:
Using Tableau, you are required to visualize key aspects of the training data to support the HR department’s decision-making process. Your analysis should focus on the following tasks:
Key Data Points:
Department: The department that the training was conducted for (e.g., HR, Marketing).
Training Type: The type of training offered (e.g., Technical, Soft Skills, Leadership, Compliance).
Number of Employees Trained: The number of employees who attended the training.
Training Cost (USD): The cost incurred for conducting the training.
Training Duration (Hours): The length of the training session in hours.
Employee Satisfaction Rating: The satisfaction rating provided by employees (on a scale from 1 to 5).
Frequency Distribution of Training Types:Task: Create a frequency distribution chart to show how often each Training Type (Technical, Soft Skills, Leadership, Compliance) is conducted. Present the results in a bar chart. This task should be completed using Tableau.
Reflection Question: What patterns can you identify from the frequency of each training type? How might this information influence decisions about future training investments?
Pie Chart of Departments:Task: Create a pie chart to represent the proportion of employees trained in each Department (HR, Marketing, etc.). This task should be completed using Tableau.
Reflection Question: Which departments are receiving the most training? What could be the reasons behind this allocation, and how could the company ensure a more balanced distribution if needed?
Histogram of Training Costs:Task: Visualize the distribution of Training Costs (in USD) using a histogram. This will help the HR team understand the variance in spending on different training programs. This task should be completed using Tableau.
Reflection Question: What does the distribution of training costs reveal? Are there any outliers or significant variations that should be addressed by management?
Box and Whisker Chart – Comparing Training Hours by Department:Task: Use a Box and Whisker Chart to compare Training Duration (Hours) across different Departments. This will help analyze variations in training time across the departments. This task should be completed using Tableau.
Reflection Question: How do the training hours vary by department? What insights can be drawn about departmental efficiency or commitment to training?
Crosstabulation of Training Cost, Training Duration, and Employee Satisfaction Ratings:Task: Develop a crosstab that analyzes the relationships between Training Costs, Training Duration (Hours), and Employee Satisfaction Ratings. This task should be completed using Tableau.
Reflection Question: Is there a correlation between training cost, duration, and employee satisfaction? How could this information inform the company’s strategy for allocating resources to future training programs?
Submission Requirements:
All visualizations should be created using Tableau.
Export the visualizations as a PDF report and submit them as part of your final submission.
Executive Summary: Write a brief (500-word) report summarizing key insights from your visualizations, including recommendations for optimizing training investments and improving employee satisfaction based on the data.

The Natural Language Toolkit (NLTK) is a popular library for natural language processing (NLP) in Python used to develop NLP applications and analyze text data. In this assignment, you will use NLTK to analyze tweets made by President Brank Obama to address the following questions:
Import the text data (tweets) into Python from https://raw.githubusercontent.com/kirenz/twitter-tweepy/main/tweets-obama.csv
Transform the text data to lowercase.
Tokenize the data.
Remove the stop words.
Remove infrequent words.
Lemmatize the text data
Build a world cloud for the most frequent words.
Create the most frequent words in the document.
Complete sentiment analysis using a sentiment intensity analyzer.
Include popularity score.
Include screen prints of your Python codes and results when submitting your assignment.

Individual Report (600 words) (15 Marks)
As an individual, perform some research and provide answers to the following: (USE ATTACHMENT BELOW)
How do graph databases and the format of the data used by them differ from traditional SQL databases? Illustrate your answers.
Discuss two industry applications of graph databases with illustrations.
List and briefly explain one challenge in relation to using graph databases to explore patterns and relationships.
Marking Guide:
Has demonstrate achievement in all or most of:
– Explaining with illustrations, how graph databases differ from traditional SQL databases. (5 marks)
– Discussions on two industry applications of graph databases with illustrations (5 marks)
– Discussions on the challenge in relation to using graph databases to explore patterns and relationships. (3 marks)
– The individual report was engaging and well structured. (2 marks)

Kingdom of Saudi Arabia
Ministry of Education
Saudi Electronic University
المملكة العربية السعودية
وزارة التعليم
الجامعة السعودية الإلكترونية

College of Administrative and Financial Sciences
Assignment 1
Introduction to International Business (MGT 321)
Due Date: 05/10/2024 @ 23:59
Course Name: Introduction to International Business
Student’s Name:

Course Code: MGT321
Student’s ID Number:

Semester: First
CRN:

Academic Year:2024-25-1st

For Instructor’s Use only
Instructor’s Name: Dina Sharqawi

Students’ Grade:/Out of 10
Level of Marks: High/Middle/Low

General Instructions – PLEASE READ THEM CAREFULLY
The Assignment must be submitted on Blackboard (WORD format only) via allocated folder.
Assignments submitted through email will not be accepted.
Students are advised to make their work clear and well presented, marks may be reduced for poor presentation. This includes filling your information on the cover page.
Students must mention question number clearly in their answer.
Late submission will NOT be accepted.
Avoid plagiarism, the work should be in your own words, copying from students or other resources without proper referencing will result in ZERO marks. No exceptions.
All answered must be typed using Times New Roman (size 12, double-spaced) font. No pictures containing text will be accepted and will be considered plagiarism).
Submissions without this cover page will NOT be accepted.

Learning Outcomes:
Knowledge:
1.3 Explain the forces driving and evaluating the impact of globalization.
Skills:
2.2 Identify the major components of international business management.
Values:
3.1 Carry out effective self-evaluation through discussing economic systems in the international business context.
Case study
Please read Case 5: “Woolworths’ Corporate Responsibility Strategy” available in your e-book (International business: Competing in the global marketplace (13th ed.), at page no.632, and answer the following questions:

Assignment Question(s):
What challenges do you think a company like Woolworths Group is facing when developing and implementing a companywide corporate social responsibility strategy that considers more than 205,000 employees, diverse interests, and stakeholders? Discuss. (Minimum words: 400, Mark:2)
Woolworths Group is trying to reduce its carbon emissions or footprint by 10 percent. Based on where we are as a world, is 10 percent enough of a reduction? Perhaps global warming is not real, albeit the vast majority of scientists clearly suggest it is; what do you think? Give logic in support of your answer.
Woolworths’ targets are to achieve a top quartile ranking in how the business engages fairly and equitably with its suppliers. How do supplier relationships and the fairness in dealing with suppliers relate to sustainability and “doing good” for society (and the company)? Explain. (Minimum words: 400, Mark:2)

(Minimum words: 600, Mark:6)

Important Notes:
This is an individual assignment.
All references must be cited using APA format. This includes both in-text citations and the reference list at the end of the document.
Originality, Similarity and Plagiarism Check: Your work must be original. All papers will be submitted through SafeAssign software to check for similarity and plagiarism. Any instance of academic dishonesty will result in a grade of zero for the assignment. No exceptions and no second chances!
Answers

Answer-
Answer-
Answer-

Go through the steps listed in “Type 2 – Market-Sizing & Guesstimate of the Case Interview Questions. MConsulting Prep” (https://mconsultingprep.com/case-interview-questions)
Answer the below questions:
– How many mini shampoo bottles are made in a year?
– Will, there be more made next year, and five years from now?
– For the clarifying steps, list what questions you had and make and record your assumption on the answer.
– If you do not agree with the number presented to you. What adjustments or recommendations would you make?
Correct APA in-text citations and references are used.

Pick a decision you make and turn it into a decision tree with at least four nodes. Make some assumptions and label the probability of each branch and result.
What are your thoughts on the decision tree and the probability assigned to the nodes? What would you add, if anything, in terms of branches?
Resources:
How To Do A Decision Tree In Word. (n.d.). How200.
http://how2oo.com/how-to-do-a-decision-tree-in-word/
Decision tree examples: Problems with solutions. (n.d.). Intellspot.
https://www.intellspot.com/decision-tree-examples/
Correct APA in-text citations and references are used.

Analyzing Patriots Sales Data for Strategic Insights
Background:
Patriots Corporation is a nationwide company operating across multiple states and regions in the United States. The company has provided three key datasets containing monthly sales, sales by state, and regional sales data over a 15-year period. The goal of this case study is to leverage Tableau and advanced data visualization techniques to generate key insights, assist decision-makers, and improve sales strategies for the upcoming fiscal year.
Objective:
Following the steps outlined in Appendix 2.2, “Creating and Modifying Charts with Tableau,” of the textbook, complete the assignments below by analyzing the provided sales data using Tableau. Your task is to create various visualizations, modify them based on given criteria, and analyze data trends to provide actionable insights for Patriots Corporation.
The attached “Sales” file contains a sheet titled “Sales by Month,” which shows Patriots Corporation sales data for twelve months.
1. Begin by creating a column chart in Tableau with the sales amount on the vertical axis and the months on the horizontal axis, following the example in Figure T2.3.
Modify the chart as follows:
Adjust the axis range by setting the Fixed start to 0 and the Fixed end to 50,000, ensuring the peak sales value fits comfortably within this range.
Label the horizontal axis as Sales Month and the vertical axis as Sales Amount.
Standardize the font size across all textual elements by setting it to size 11.
Update the chart title to “Patriots Sales by Month.”
Remove any unnecessary grid lines from the chart.
2. Recreate a similar graph, but this time with the sales amount on the horizontal axis and the sales months on the vertical axis, following the layout shown in Figure T2.5.
Modify the chart as follows:
Adjust the axis range by setting the Fixed start to 0 and the Fixed end to 50,000, ensuring the peak sales value fits comfortably within this range.
Label the horizontal axis as Sales Month and the vertical axis as Sales Amount.
Standardize the font size across all textual elements by setting it to size 11.
Update the chart title to “Patriots Sales by Month.”
Remove any unnecessary grid lines from the chart.
The attached “Sales” file contains a sheet named “Sales by States,” which contains Patriots Corporation sales data across 25 U.S. states.
1. Create a scatter plot using the “Sales by States” data, with the average price on the vertical axis and the sales amount on the horizontal axis, following the layout shown in Figure T2.8.
Modify the chart as follows:
Label the axes, with the horizontal axis labeled as Sales Amount and the vertical axis as Average Price.
Adjust the axis range so that the peak sales value comfortably fits within the chart.What would you recommend for the Fixed Start and Fixed End?
Standardize the font size for all textual elements to size 11.
Update the chart title to “Patriots Sales by State.”
Remove any unnecessary gridlines from the chart.
2. Using the same dataset, create a scatter chart for sales, including data labels with state names. Refer to Figure T2.9 in the textbook for guidance.
Modify the chart as follows:
Label the axes as follows: the horizontal axis as the Sales Amount and the vertical axis as the Average Price.
Adjust the axis range to ensure that the peak sales value fits comfortably within the chart.What would you recommend for the Fixed Start and Fixed End?
Standardize the font size for all text elements to size 11.
Update the chart title to “Patriots Sales with Data Labels for States.”
Remove any unnecessary gridlines from the chart.
3. Using the same dataset, create a Choropleth Map, following the format shown in Figure T2.24.
Modify the chart as follows:
Standardize the font size across all text elements to size 11.
Update the chart title to “Patriots Choropleth Map Sales.”
Remove any unnecessary gridlines from the chart.
4. Using the same dataset, create a bubble chart for sales with data labels displaying the state names. Refer to Figure T2.11 in the textbook as an example.
Modify the chart as follows:
Label the axes as follows: the horizontal axis as the Sales Amount and the vertical axis as the Average Price.
Adjust the axis range to ensure that the peak sales value fits comfortably within the chart.
What would you recommend for the Fixed Start and Fixed End?
Standardize the font size for all text elements to size 11.
Update the chart title to “Patriots Sales with Data Labels for States.”
Remove any unnecessary gridlines from the chart.
The attached “Sales” file contains a sheet titled “Sales by Region,” which contains 15 years of regional sales data.
1. Create interlaid line charts for the two regions, similar to the example in Figure T2.18.
Modify the chart as follows:
Label the axes with the horizontal axis as years and the vertical axis as sales amount.
Standardize the font size across all text elements to size 11.
Update the chart title to “Patriots Sales by Region.”
Remove any unnecessary gridlines from the chart.
2. Using the same dataset, create a Clustered Column Chart following the format shown in Figure T2.21.
Modify the chart as follows:
Label the axes with the horizontal axis as years and the vertical axis as sales amount.
Standardize the font size across all text elements to size 11.
Update the chart title to “Patriots Sales Clustered by Regions.”
Remove any unnecessary gridlines from the chart.
3. Using the same dataset, create a Stacked Column Chart, following the example in Figure T2.22.
Modify the chart as follows:
Label the axes with the horizontal axis as years and the vertical axis as sales amount.
Standardize the font size across all text elements to size 11.
Update the chart title to “Patriots Sales Stacked by Regions.”
Remove any unnecessary gridlines from the chart.
Policy Implications and Strategic Decision-Making:
Based on the data analysis and visualizations you create, what are the potential policy implications for Patriots Corporation regarding its sales strategies across different states and regions? Consider how regional performance trends, state-specific sales, and monthly fluctuations might influence strategic decision-making. What policies could Patriots Corporation implement to enhance sales performance, and how should leadership adjust its approach to allocating resources, developing targeted marketing campaigns, or addressing underperforming regions?
Submission Requirements:
All assignments must be submitted in a well-formatted and clearly presented Word file.
Ensure that the file includes all visualizations, a written summary of key insights, strategic recommendations, and suggested policy actions.
Charts and graphs should be properly labeled and formatted as described in each task.
The document should be professional and easy to follow, with headings and sections clearly defined.

Individual Report (600 words) (15 Marks)
As an individual, perform some research and provide answers to the following: (USE ATTACHMENT BELOW)
How do graph databases and the format of the data used by them differ from traditional SQL databases? Illustrate your answers.
Discuss two industry applications of graph databases with illustrations.
List and briefly explain one challenge in relation to using graph databases to explore patterns and relationships.
Marking Guide:
Has demonstrate achievement in all or most of:
– Explaining with illustrations, how graph databases differ from traditional SQL databases. (5 marks)
– Discussions on two industry applications of graph databases with illustrations (5 marks)
– Discussions on the challenge in relation to using graph databases to explore patterns and relationships. (3 marks)
– The individual report was engaging and well structured. (2 marks)

Kingdom of Saudi Arabia
Ministry of Education
Saudi Electronic University
المملكة العربية السعودية
وزارة التعليم
الجامعة السعودية الإلكترونية

College of Administrative and Financial Sciences
Assignment 1
Introduction to International Business (MGT 321)
Due Date: 05/10/2024 @ 23:59
Course Name: Introduction to International Business
Student’s Name:

Course Code: MGT321
Student’s ID Number:

Semester: First
CRN:

Academic Year:2024-25-1st

For Instructor’s Use only
Instructor’s Name: Dina Sharqawi

Students’ Grade:/Out of 10
Level of Marks: High/Middle/Low

General Instructions – PLEASE READ THEM CAREFULLY
The Assignment must be submitted on Blackboard (WORD format only) via allocated folder.
Assignments submitted through email will not be accepted.
Students are advised to make their work clear and well presented, marks may be reduced for poor presentation. This includes filling your information on the cover page.
Students must mention question number clearly in their answer.
Late submission will NOT be accepted.
Avoid plagiarism, the work should be in your own words, copying from students or other resources without proper referencing will result in ZERO marks. No exceptions.
All answered must be typed using Times New Roman (size 12, double-spaced) font. No pictures containing text will be accepted and will be considered plagiarism).
Submissions without this cover page will NOT be accepted.

Learning Outcomes:
Knowledge:
1.3 Explain the forces driving and evaluating the impact of globalization.
Skills:
2.2 Identify the major components of international business management.
Values:
3.1 Carry out effective self-evaluation through discussing economic systems in the international business context.
Case study
Please read Case 5: “Woolworths’ Corporate Responsibility Strategy” available in your e-book (International business: Competing in the global marketplace (13th ed.), at page no.632, and answer the following questions:

Assignment Question(s):
What challenges do you think a company like Woolworths Group is facing when developing and implementing a companywide corporate social responsibility strategy that considers more than 205,000 employees, diverse interests, and stakeholders? Discuss. (Minimum words: 400, Mark:2)
Woolworths Group is trying to reduce its carbon emissions or footprint by 10 percent. Based on where we are as a world, is 10 percent enough of a reduction? Perhaps global warming is not real, albeit the vast majority of scientists clearly suggest it is; what do you think? Give logic in support of your answer.
Woolworths’ targets are to achieve a top quartile ranking in how the business engages fairly and equitably with its suppliers. How do supplier relationships and the fairness in dealing with suppliers relate to sustainability and “doing good” for society (and the company)? Explain. (Minimum words: 400, Mark:2)

(Minimum words: 600, Mark:6)

Important Notes:
This is an individual assignment.
All references must be cited using APA format. This includes both in-text citations and the reference list at the end of the document.
Originality, Similarity and Plagiarism Check: Your work must be original. All papers will be submitted through SafeAssign software to check for similarity and plagiarism. Any instance of academic dishonesty will result in a grade of zero for the assignment. No exceptions and no second chances!
Answers

Answer-
Answer-
Answer-