Category: Data Analytics

I have the data and power BI but will send u after selection. for this assignment I need to create interactive dashboards for tactical crime analysis focused on an LAPD division. This includes four main components. First, the Crime Overview Dashboard will summarize crime trends, types, and geographic distribution within the division, featuring interactive visuals and maps. Second, the Repeat-Incident Analysis Dashboard will identify addresses with multiple incidents, using tables and maps to display these locations and their details. Third, the Serial Incidents Dashboard will analyze potential serial crimes using spatial techniques like buffer zones, visualized on maps. Finally, the Weekly Crime Bulletin Dashboard will provide a recent summary of crime incidents for street-level officers, including filters for specific reporting districts. The goal is to create a comprehensive and dynamic analytic report to inform law enforcement practices.

Project Summary:
As an intern in the Marketing Department at AIU, you will undertake a critical capstone project that focuses on creating a comprehensive set of analytics and Key Performance Indicators (KPIs) for our marketing efforts. This project will encompass all social media channels, our website, and visitor information, providing valuable insights to inform strategic decision-making and enhance our marketing strategies.
Objectives:
Develop Advanced Analytics: Implement cutting-edge analytics techniques to gather and analyze data from various marketing channels.
Use statistical and machine learning methods to derive actionable insights.
Create KPIs: Define and develop KPIs that align with the university’s marketing goals and strategic plan.
Ensure KPIs are specific, measurable, achievable, relevant, and time-bound (SMART).
Provide Business Use Cases: Demonstrate how the analytics and KPIs can be used to inform strategic decisions in both the Marketing and Admissions departments.
Include examples and case studies from leading consulting firms on how they utilize marketing and social media data.
Instructions:
Data Collection and Integration: Collect data from all social media channels (Facebook, Twitter, Instagram, LinkedIn, etc.), the university website, and visitor information.
Ensure data is clean, accurate, and comprehensive.
Analytics Framework: Develop a robust framework for analyzing the collected data.
Utilize tools such as Google Analytics, social media analytics platforms, and advanced statistical software (e.g., R, Python).
KPI Development: Identify key areas of performance to measure (e.g., engagement, reach, conversion rates).
Create detailed definitions and calculation methods for each KPI.
Ensure KPIs reflect the goals of enhancing brand awareness, increasing student enrollment, and improving engagement with stakeholders.
Strategic Insights: Use the analytics to provide insights into current performance.
Develop predictive models to forecast future trends and outcomes.
Suggest actionable strategies based on the insights derived from the data.
Reporting and Visualization: Design dashboards and reports that effectively communicate the KPIs and insights to stakeholders.
Use data visualization tools (e.g., Tableau, Power BI) to create intuitive and interactive reports.
Examples and Case Studies: Include examples of how top consulting firms utilize similar analytics and KPIs in their marketing strategies.
Provide sample data and calculations to illustrate the application of your proposed KPIs.
Key Performance Indicators (KPIs):
Engagement Rate: Definition: The percentage of people who interact with your content out of the total number of people who viewed it.
Significance: Measures how effectively content is resonating with the audience.
Calculation: (Total Engagements / Total Impressions) * 100
Conversion Rate: Definition: The percentage of users who take a desired action after engaging with your marketing content.
Significance: Indicates the effectiveness of your content in driving actions like registrations, sign-ups, or applications.
Calculation: (Conversions / Total Clicks) * 100
Reach: Definition: The total number of unique users who have seen your content.
Significance: Helps assess the potential audience size and the effectiveness of content distribution.
Calculation: Unique Impressions
Website Traffic: Definition: The number of visits to the university website.
Significance: Indicates the overall interest in the university’s online presence and the effectiveness of marketing campaigns.
Calculation: Total Visits
Bounce Rate: Definition: The percentage of visitors who leave the website after viewing only one page.
Significance: Helps identify the quality of website content and user experience.
Calculation: (Single Page Visits / Total Visits) * 100
Average Session Duration: Definition: The average amount of time users spend on the website per visit.
Significance: Indicates the level of engagement and interest in website content.
Calculation: Total Duration of All Sessions / Total Sessions
Click-Through Rate (CTR): Definition: The percentage of people who click on a link or advertisement out of the total number of people who viewed it.
Significance: Measures the effectiveness of calls to action and content attractiveness.
Calculation: (Total Clicks / Total Impressions) * 100
Follower Growth Rate: Definition: The percentage increase in followers on social media channels over a specific period.
Significance: Reflects the growth of the audience and the effectiveness of content in attracting new followers.
Calculation: ((End Period Followers – Start Period Followers) / Start Period Followers) * 100
Social Share of Voice (SOV): Definition: The percentage of conversations about the university compared to the total conversations about competitors.
Significance: Measures the university’s brand presence and competitiveness in the market.
Calculation: (University Mentions / Total Mentions of University and Competitors) * 100
Customer Satisfaction Score (CSAT): Definition: The average score of customer satisfaction surveys.
Significance: Reflects the overall satisfaction of stakeholders with marketing efforts and content.
Calculation: (Sum of All Scores / Number of Respondents)
Examples and Case Studies:
Deloitte: Utilizes advanced analytics to drive personalized marketing campaigns. They focus on segmentation, targeting, and real-time data analysis to optimize engagement and conversion rates.
PwC: Implements predictive analytics to forecast market trends and customer behavior, helping clients to make informed strategic decisions.
EY: Leverages social media sentiment analysis to gauge public perception and adjust marketing strategies accordingly.
KPMG: Uses KPI dashboards to monitor and report on the effectiveness of digital marketing campaigns, ensuring alignment with business objectives.
Accenture: Employs machine learning algorithms to analyze customer data, providing insights that enhance marketing efficiency and effectiveness.

1. Define the PROBLEM (in one or two sentences). In this definition make sure it is clear whose problem it is, and why it is so important that somebody should worry about it. If there are several problems in the case, you must either choose the most important one or define the problem broadly so that the sub-problems are part of it. This is the most important part of the analysis, since you must aim at the right target in order to hit it.
2. Define the METHOD. (4Ps Methode) In one or two sentences explain what method you are going to use to solve the problem. A method could be interest arbitrage to pick the best investment, or hedging techniques to find the least-cost hedge, or some other theory or technique. The method is NOT the solution to the case.
3. Do the ANALYSIS. In this section, use most of your 1000 words to solve the problem. This should be reasonably easy, since you have already defined the problem carefully and told me what method you are going to use to solve it.
4. Draw some CONCLUSIONS. This may be a final paragraph in which you emphasize your solution to the problem and why it is best.

You are a project manager on a project that uses earned value management. The project has the following budget and status:
Project Duration (months):
14
Current Reporting Period (month):
6
BAC:
$387,000
Cumulative PV:
$68,345
Cumulative AC:
$78,379
% of the project completed through the reporting period:
19%
Estimate to Complete:
$294,677
Part 1:
Based on this information, determine the following:
Cumulative EV
Schedule Variance (SV)
Schedule Performance Index (SPI)
Cost Variance (CV)
Cost Performance Index (CPI)
EAC (bottom-up)
VAC (bottom-up)
TCPI
Based on your calculations above, respond to the following:
What is the status of project accomplishment performance through the current reporting period? Why?
What is the status of project cost performance through the current reporting period? Why?
Is the project projected to complete overbudget or underbudget? Why?
Interpret the TCPI metric.
Part 2:
Based on your calculations above, an inexperienced and arrogant project analyst from the project management office has computed an additional metric: Cost Schedule Index, which equals SPI * CPI. He wants you to report this metric to the customer, instead of SPI and CPI separately. What should you do and why?
The program manager doubts your numbers. In particular, he does not believe your EAC number and requests that you calculate the EAC not assuming future performance will behave like past performance.
Compute EAC when cost performance is negative and schedule dates must be met: EAC = AC + [(BAC – EV) / (CPI × SPI)]
Compute EAC using actual costs to date and assuming ETC uses budgeted rate: EAC = AC + (BAC – EV)
Interpret the results of the EAC in a.
Interpret the results of the EAC in b.
Based on these new calculations, what do you think the program manager will request from you regarding the bottom-up EAC?
Part 3:
You are having a hallway conversation with the same project analyst who is now realizing that he may not know as much about earned value management as he thought when he joined the company. Still, he is convinced that the following statements below are correct. How would you respond to him based on each statement (i.e., formulate a specific response and supporting rationale for each statement below)?
EAC becomes Cumulative AC at project completion.
Cumulative EV can be greater than BAC at project completion.
EAC can be smaller than BAC at project completion.
ETC can be greater than 0 at project completion.
Submit an MS Excel file showing your completed calculations and including your responses to the indicated question

Please see the attached documents to complete the assignment.
Textbook (Not Required but recommended): Cost-Benefit Analysis: Concepts and Practice (4th Edition) by Anthony E. Boardman, David H. Greenberg, Aidan R. Vining, and David L. Weimer, Prentice Hall, Inc., Upper Saddle, NJ, 2011 (ISBN-10: 0137002696). Include additional resources.

The purpose of the Internship Report is offer students to describe their accomplishments and
demonstrate what they learned through participation at Saudi Electronic University. The report
should be submitted within two weeks after you finish your Co-op training Program. In
addition, the report should be approximately 3000 – 4000, single –spaced and consider taking
the following format
1. First Page
First page should display student’s full name, internship start and finish dates, working hours
per week, company/institution name.
This page should be signed by the work and university supervisor off the intern student.
Cover page form
Internship Report
Student`s name :
Student`s ID # :
2. A Brief Executive Summary of the Internship
A one-page summary of the company/institution and a short account of the major activities
carried out during the internship period.
Training Organization: Trainee Department:
Field Instructor Name: Faculty Member:
Field Instructor Signature: Faculty Member Signature:
Internship Start Date: Internship End Date:
Course: CRN:
Academic Year/Semester:
3. Table of Contents
Contents of the report with page numbers, list of tables, and list of figures.
4. Description of the company
This section should answer the following questions:
• What is the full title of the company/institution? Give a brief history of the company, full
mailing address and relevant web links
• What is the type of ownership of the company/institution? State the main shareholders and
their shares.
• What is the sector that the company/institution operates in? Specify the products and services
produced and offered to its customers/clients.
• Who are regarded as the customers/clients of your internship company (consider the end users,
retailers, other manufacturers, employees, etc.)?
• Provide an organization chart of the company, along with information on the number of
employees.
• Provide a list of functions performed by different departments/divisions in the internship
organization.
5. Internship activities
This is the main body of your report. During the internship period, an intern may focus on the
following types of analysis and questions. You do not have to answer all the questions in the
list:
• Describe your working conditions and functions, such as: Who is your supervisor (include
his/her name and his/her position); other team members or co-workers and what their functions
are to complement yours.
• Provide an organization chart of the internship organization.
• Provide the department or division layout of the internship organization.
• Provide an overview off the production system or service procedure (what are the
resources, inputs, outcomes, and constraints?)
• Provide a process chart of a major product and/or service.
• What kind of accounting/finance/IT//quality/marketing standards and principles are used in
the organization?
• Discuss telecommunication technologies (Database, Instant Messenger,
Networking, Ecommerce tools) used in the company.
• Describe the quality planning and control activities in the internship organization.
• Describe the quality control activities throughout the life cycle of the product/service groups.
• What kind of financial analysis and decision-making methods are used by corporate treasurers
and financial managers in the internship organization?
• What kinds of incentives are used in order to create more effective and efficient organization?
• What types of marketing, selling, and human resources analysis are performed (cost
system, evaluation of consumers, needs, product strategy, distribution strategy, promotional
strategy)?
• Describe what kind of working documents and analysis you did there and what experiences
you have gained throughout your training.
•A comparison between theory (things you have learned in the classroom) and practice (things
you did or observed at the company) must be made and highlighted.
• Show some work samples that you have encountered/conducted at the company through
graphs, pictures, data, drawings, or design calculations and include them in your report.
I am interning in an online store as a business analyst and have sent you the internship information.
https://alnasejtex.com/jZGddzD
I hope the presentation is simple in selecting terms.

Use this info to draw a business diagram if you think you can add something go ahead and do it.
[Client approaches the bank]
|
V
[Client chooses the method of contact: branch, website, mobile app]
|
V
[Application is directed to the decision-making unit]
|
V
[Bank’s automated system checks the client and returns a response]
|
V
[Decision-making unit contacts the credit bureau for credit history check]
|
V
[Decision-making unit contacts the risk assessment department]
|
V
[Bank evaluates the client’s financial situation]
|
V
[Bank offers the client optimal loan or credit terms]
|
V
[Client agrees to the proposed terms]
|
V
[Bank makes a decision on granting the loan or credit]
|
V
[Bank disburses the loan or credit to the client]

Team – B: [Every document and screenshot should be named as ‘Team-B’]
Overview:
This week you will work with your group on your final project.
Objectives
Apply concepts learned about Hadoop Ecosystem
Apply concepts learned in data preparation to preprocess data
Construct an external table using basic SQL commands in BigQuery
Develop queries in BigQuery.
Construct a well-defined schema using basic HQL commands in Hive
Develop queries in Hive
Develop queries in Spark
Instructions
Each group will research their assigned use case. They will select a static dataset and streaming data source from the approved list provided or locate another and obtain the instructors’ approval.
Each group will create an executive summary. This summary should be between 400 and 550 words, not including the title page, references, or other supporting documents. It should read like a summary of your presentation, giving the use case project, stepping through the data lifecycle, identifying tools/applications used during certain phases of the data lifecycle, and concluding with the next steps for the data science or analyst teams. The executive summary is in Times New Roman, 12-point, with one-inch margins.
Each group will create a document with screenshots that includes the project and storage they created for their use case in GCP, setting up their Hadoop ecosystem, performing data processing with their static and streaming data, and performing queries in BigQuery, Hive, and Spark to ensure the quality of their data for the data science or analysts teams. Through each step, the team will take screenshots of their work and present them in a word document with brief explanations of the screenshots. The desciption should include the application used, the task performed, and why it was performed. Do not include how-to instructions.
Each group will create a presentation that tells a story using the data lifecycle as a guide, and they will present their work during the designated time. You may be creative with the presentation with PowerPoint. The presentation is a professional business presentation. Each member of the group should speak. After the presentation, the group will entertain questions from the audience. The presentation should be at least 10-15 minutes in length.
Meeting_Notes_Template:
I have provided the ‘Meeting_Notes_Template.docx’, please fill the provided template.
Approved Data Sources:
I have provided ‘Approved Data Sources.pdf’ please select a two datasets from any USE CASES Approved Data Sources provided in the pdf.
PPT and Word:
Topic: Use cases from the discussion post
Data: Use approved data sources (two or more)
Executive Summary (25%): This paper should be between 400 and 550 words, not including the title page, code, and references.
Screenshots (25%): These screenshots should show how you applied what you learned. Create a new project in GCP for this use case.
Presentation (50%): The group will present
Grading: This project is worth 20% of your final course grade. The Executive Summary will comprise 25% of this grade, screenshots 25%, and the presentation will be 50%
Document Type: Word and PPT
Executive Summary Requirements:
400 to 550 words, not counting the title page, references, or supporting documents.
Title page: Organization Name, Logo, Use case, group number, and group members
Introduction: Introduce the use case and its purpose (Example: Data Engineering Request)
Body: Step through the data lifecycle with your use case and the tasks you did
Conclusion: Summarize and discuss the next steps for the data science and analyst teams
Double-spaced Word Document
References
Application Screenshots Requirements:
GCP project & storage
Hadoop
OpenRefine
BigQuery
Hive
Spark
Include an explanation (3-10 sentences) with the screenshots telling the application used and the task performed.
Supporting Documents:
Reference page
Meeting notes or Task board
Data Sheet – List of Data sources and any
additional information such as the website
address
Other documents
Word Document
Meeting Notes Template:
Date:
Start and End time:
Attendees:
Note-taker:
Notes:
Decisions:
Action Items:
Task board:
Create a Task board using MS Teams – Planner,
Excel, or Word
Task board Columns
To-Do
In Progress
Review
Done
Task Info: Description, Owner, Due Date
Presentation Requirements:
Business casual
TELL A STORY
Every group member must present
10-15 minutes to present
2 minutes for questions
10-20 PowerPoint Slides
Title page: Organization Name, Logo, Use case, group number, and group members
Outline or Agenda
Every step of the data lifecycle – No definitions
Hive and Spark SQL comparison chart
A few of your screenshots (No more than 5)
Cite the source on the slide if not your own words
Word document regarding rubrics instructions.

Sure, here’s an example outline for a CRJ101 (Introduction to Criminal Justice) course at Strayer University, focusing on Week 4’s topic: “Modern Day Policing, Society, And The Future”:
I. Introduction to Modern Policing
Definition and Evolution of Policing
Historical Context: From Early Forms to Modern Law Enforcement
II. Contemporary Issues in Policing
Police-Community Relations
Use of Force and Police Brutality
Racial Profiling and Bias in Policing
III. Technology and Policing
Role of Technology in Law Enforcement
Surveillance and Privacy Concerns
Predictive Policing and Data Analysis
IV. Challenges and Opportunities
Mental Health and Policing
De-Escalation Techniques
Community Policing Models
V. Future Trends in Policing
Policing in the Digital Age
Predictions for Law Enforcement Practices
Potential Impact of Societal Changes on Policing
VI. Case Studies and Examples
Analysis of Recent Policing Incidents
Success Stories in Community Policing
Innovations in Law Enforcement Technology
VII. Discussion and Reflection
Group Discussion: What are the most pressing issues in modern policing?
Reflective Exercise: How can individuals contribute to positive changes in policing?
VIII. Conclusion
Summary of Key Concepts
Importance of Adaptation and Reform in Policing
IX. References
Scholarly Articles, Books, and Reports
Relevant News Sources and Websites
This outline provides a structured approach to explore various aspects of modern policing, from historical perspectives to future trends, while encouraging critical thinking and discussion among students. Each section can be further expanded with readings, multimedia resources, and interactive activities to enhance student engagement and understanding.