BUS 195B University of California Davis Business & Data Analyst Job Description & Skills Paper In this assignment, you will be using the job descriptions b

BUS 195B University of California Davis Business & Data Analyst Job Description & Skills Paper In this assignment, you will be using the job descriptions below for a Business Analyst and a Data Analyst, to determine what parts of this class/business analytics are relatable to a potential job interview. Highlight 5-7 skills per job description, within each job below that relate to your skills you have learned. Then write a brief description on how those highlighted skills apply to what you have learned.
Submission: Submit this document with 5-7 highlights and a short paragraph per job. You will be submitting one for each job description. 
I will provide Course Syllabus for you to understand what we’ve learned in this course, and you can ask me any queations.
Assignment page will also be upload. Name: Job Description Skills. College of Business, Department of Marketing & Business Analytics
BUS2 195B, Data Visualization, Section 01, Spring 2020
Course Description
This course focuses on state-of-the-art data techniques for creating effective visualizations for structured and
unstructured data. The course targets students who are interested in using visualizations to better understand information
and communicate with other people.
Course Learning Outcomes (CLO)
Upon successful completion of this course, students will be able to:
1. Obtain hands-on experience using Data Visualization software/programs
2. Understand the importance of context and audience
3. Determine the appropriate type of graph for your situation
4. Recognize and eliminate the clutter clouding your information
5. Direct your audience’s attention to the most important parts of your data
6. Think like a designer and utilize concepts of design in data visualization
7. Leverage the power of storytelling to help your message resonate with your audience
Course Format
Technology Intensive, Hybrid, and Online Courses
This course will be technology intensive and will require students to have a functional laptop/notebook with necessary
software. For specific information, refer to the Required Texts/Readings section in this Syllabus.
Faculty Web Page and MYSJSU Messaging
Course materials such as syllabus, handouts, notes, assignment instructions, etc. can be found on my faculty web page at
http://www.sjsu.edu/people/firstname.lastname and/or on Canvas Leaning Management System course login website at
http://sjsu.instructure.com. You are responsible for regularly checking with the messaging system through MySJSU at
http://my.sjsu.edu (or other communication system as indicated by the instructor) to learn of any
Spring 2020
Required Texts/Readings
Textbook
Storytelling with Data: A Data Visualization Guide for Business Professionals
Author: Cole Nussbaumber Knaflic
Publisher: Wiley; 1 edition (November 2, 2015)
Language: English
ISBN-10: 1119002257
ISBN-13: 978-1119002253
*Paperback version or PDF version is acceptable for the purpose of this course.
Other Readings
Other text will be provided via PDF or website through the instructor.
Other technology requirements / equipment / material
All students must have a functional laptop in order to complete and submit assignments. The following software will be
required for the purpose of this class:
-Microsoft Word & Microsoft Excel 2010 or higher
-Power BI Desktop (More details to come for free download) – only available on Windows computer
-Tableau (More details to come for free download)
Course Requirements and Assignments
Success in this course is based on the expectation that students will spend, for each unit of credit, a minimum of 45 hours
over the length of the course (normally 3 hours per unit per week with 1 of the hours used for lecture) for instruction or
preparation/studying or course related activities including but not limited to internships, labs, clinical practice. Other
course structures will have equivalent workload expectations as described in the syllabus.
Final Examination or Evaluation Information
There will be a Final Examination that will cover all topics discussed in the course. The Final Exam will consist of a
theoretical question and answer portion and a practical hands-on portion. Preparation for Final Exam will be provided
closer to the exam date.
The Final Exam will take place on Friday, May 15th 2020 from 7:15AM-9:30AM.
Grading Information
Determination of Grades
All assignments and project work must be submitted on time for full credit. Any late assignments will be deducted 25%
credit for every day late from the original due date, up to 3 days late max. There may be an opportunity for an extra credit
assignment as the class progresses.
Assignments – 25%
Midterm Examination – 25%
Final Examination – 25%
Final Project – 25%
Spring 2020
Grading Scale
Grade
Percentage
A plus
A
A minus
B plus
B
B minus
C plus
C
C minus
D plus
D
D minus
97 to 100%
93 to 96%
90 to 92%
87 to 89 %
83 to 86%
80 to 82%
77 to 79%
73 to 76%
70 to 72%
67 to 69%
63 to 66%
60 to 62%
Spring 2020
BUS2 195B, Data Visualization, Section 01, Spring 2020
Course Schedule
Schedule is subject to change with fair notice. Any changes to the schedule will be provided ahead of time.
Course Schedule
Week
Date
Topics, Readings, Assignments, Deadlines
1
Th 1/23
Class Introduction & Syllabus Review
2
T 1/28
2
Th 1/30
Intro to Data Visualization
Due: Learning Assignment #1 (Introduction Discussion)
Data Visualization Software Introduction & Group Work
3
T 2/4
3
Th 2/6
4
T 2/11
4
Th 2/13
5
T 2/18
5
Th 2/20
6
T 2/25
6
Th 2/27
7
T 3/3
7
Th 3/5
Lecture: Ch. 5 – Think Like a Designer
Due: Learning Assignment #6 (Project Dataset)
Hands-on: Review for Midterm
8
T 3/10
MIDTERM: Ch. 1-5 + Hands-On Activities
8
Th 3/12
Hands-on: Introduction to Power BI
9
T 3/17
9
Th 3/19
Lecture: Ch. 6 – Dissecting Model Visuals + Ch. 7 – Lessons in Storytelling
Due: Learning Assignment #7 (Power BI – Part 1)
Hands-on: Creating Visuals & Dashboards in Power BI
10
T 3/24
Spring 2020
Lecture: Ch. 1 – Importance of Context
Due: Learning Assignment # 2 (Application of Data Visualization)
Hands-on: Introduction to Excel
Lecture: Ch. 2 – Choosing Effective Visuals + Infographics Introduction
Due: Learning Assignment #3 (Dataset Briefing & Formulas)
Hands-on: Creating Graphs & Visuals in Excel
Lecture: Ch. 3 – Clutter is Your Worst Enemy + Infographics Debrief
Due: Learning Assignment #4 (Excel Visuals + Infographic Briefing)
Hands-on: Infographics- From Data to Information
Lecture: Ch. 4 – Focus Audience ’s Attention
Due: Learning Assignment #5 (Create Infographics)
Hands-on: Intro to Final Project & Dashboard Tools Activity
Lecture: Ch. 8 – Pulling it Together + Ch. 9 – Case Studies
Due: Learning Assignment #8 (Power BI – Part 2)
Week
Date
Topics, Readings, Assignments, Deadlines
10
Th 3/26
Hands-on: Advanced Power BI Techniques
11
T 3/31
No Class – Spring Break
11
Th 4/2
No Class – Spring Break
12
T 4/7
12
Th 4/9
Lecture: Ch. 10 – Final Thoughts + Project Workday
Due: Download Tableau + R
Hands-on: Intro to Tableau
13
T 4/14
13
Th 4/16
14
T 4/21
14
Th 4/23
Lecture: Guest Speaker – Local Bay Area BI
Due: Learning Assignment #10 (Tableau – Part 2)
Hands-on: R GGPlot Visuals
15
T 4/28
Presentations & Feedback Exercise (3)
15
Th 4/30
Presentations & Feedback Exercise (3)
16
T 5/5
Presentations & Feedback Exercise (3)
16
Th 5/7
Final Exam Review
F 5/15
7:15-9:30AM
FINAL EXAM Ch. 6-10 + Hands-on Exam
Final
Exam
Spring 2020
Hands-on: Creating Visuals in Tableau
Due: Learning Assignment #9 (Tableau – Part 1)
Hands-on: Pulling it together in Tableau
Job Description & Skills Assignment
In this assignment, you will be using the job descriptions below for a Business Analyst and a Data Analyst, to
determine what parts of this class/business analytics are relatable to a potential job interview. Highlight 5-7 skills
per job description, within each job below that relate to your skills you have learned. Then write a brief description
on how those highlighted skills apply to what you have learned.
Submission: Submit this document with 5-7 highlights and a short paragraph per job. You will be submitting one
for each job description.
Job 1: Associate Business Analyst
Responsibilities:
•
•
•
•
•
•
We are seeking an entrepreneurial, data-driven Business Analyst to join our Strategy and Analytics team. The
Business Analyst will be instrumental in helping to analyze our business operations and identify opportunities for
the company to cost-effectively better serve our subscribers. The Business Analyst will also evaluate strategic
opportunities both inside and outside our company to drive growth. Successful candidates will possess deep
analytical capabilities, love working with data, and demonstrate an ability to work collaboratively across functional
teams. Your primary responsibilities include:
Combine great data analytics skills with strong business acumen to provide insights that will drive company
growth
Work closely with our Operations team to provide ad hoc analyses, dashboards, and reports to improve
performance
Identify and execute other cross-functional analyses with cross-functional partners to provide insights around
our customers, our products, new initiatives, new markets, etc.
Work successfully across the organization to support implementation of key recommendations
Work with executive staff on improving and updating of company key success metrics, as well as monthly
business / financial projection model
Utilize tools such as SQL, Looker, Excel, etc. to perform analyses
Requirements:
As a company celebrating creativity and development, we believe and encourage the same in our team. We seek
team players with an infectious positive energy, great initiative, and a get-it-done attitude. Candidates must thrive in
ambiguity and love a rapid pace. You must have a strong desire to learn and improve.
•
•
•
•
•
•
•
•
The ideal candidate has great attention to detail and a analytical mind with a drive to improve bottom line results.
Excellent organizational, analytical, and multi-tasking skills are musts. Required skills and qualifications include:
BA/BS in a quantitative major (math, engineering, business, economics, statistics, physics, etc.)
1+ years of experience in an analytical role at an investment bank, consulting firm, or high growth startup
Advanced modeling skills using Excel, scenario analysis, pivot tables
Enthusiastic and excited about data, especially to understand ways of how to apply it to unstructured business
questions
Entrepreneurial, quick learner, and eager to dive into new problems
Excellent verbal and written communication skills, including presenting to executives
Proficient with Powerpoint or other presentation tools
Ability to work quickly and accurately on multiple projects concurrently, occasionally under tight timelines
Bonus:
•
•
•
Past experience utilizing SQL to access, join and manipulate large data sets
Familiarity with Looker, Tableau, or other data visualization tools
Past experience in role supporting operations with inventory and supply chain management analysis
Job 2: Data Analyst
About the Role
We are looking for an exceptional data analyst with 3-5+ years of experience to empower internal and
external products with actionable insights. You will be responsible for building this program from the
ground up: partnering with stakeholders, understanding all aspects of the products, interacting with crossfunctional business and technical teams, manipulating and analyzing data, and building metrics and
dashboards to influence and drive business decisions.
•
•
•
•
•
•
What You’ll Do
Work from inception of a specified business problem identified by data to delivery of a solution
Identify opportunities to fix or improve processes that make the company better in the long term
Work closely with your team to put together seemingly disparate pieces of data, build out the data
pipeline and create interactive dashboards
Proactively communicate data methodology and results to a diverse set of stakeholders
Write queries, contribute to larger scale products/projects and perform ad hoc analyses as needed
Comfortable with working in fast-paced environments to find answers to critical questions with data
and be decisive in an ambiguous situation
•
•
•
•
•
•
•
What You’ll Need
4+ years in quantitative/analytic role, preferably within tech
3+ years experience with BI Tools such as Tableau, MicroStrategy, Power BI or Looker
SQL expert and general understanding of databases, data relationships and data integrity
Demonstrated ability to think strategically about business, product, and technical challenges
Strong communication skills and customer empathy, capable of pushing for the best solution with tact
Excellent planning and project management skills
Bachelor’s degree in Computer Science, Mathematics, Statistics, or a related technical field
•
•
•
•
•
Bonus Points if
Experience handling structured and unstructured data from internal and third party sources
Experience with Python, Javascript and R are plus
Strong communication and interpersonal skills
Exposure to Web Analytics such as Google Analytics, Adobe Analytics/Omniture, Heap Analytics
Understanding of basic statistics (confidence intervals, statistical significance, etc)

Purchase answer to see full
attachment