Data Wrangling Assignment
Table of Contents:
1. Introduction
2. Data Gathering
3. Data Merging
4. Data Analysis and Results
1. Introduction :
Local Ice-Cream Store is an Ice-cream multistore at which ice-cream sales are made across different regions, stores and sales of the different ice-creams. This report helps to understand the analysis made on the data and provides insightful information. This helps to understand more on the sales of ice creams across different regions.
2. Data Gathering :
There are different data sources shared to perform the analysis to identify ice-cream sales trend.
· Ice-Cream Sales data given at weekly level - Weekly_Sales.csv
· Regions data file given for regions wise analysis – Regions.csv
· Stores data for understand on the temperature and unemployment rate – StoreDetails.csv
3. Data Merging :
· Sales data is initially merged with the stores data using the key “Store”.
· Merged Sales data and the stores data is merged with regions file to generate a master merged file.
4. Data Analysis:
Graph -1: Mean Sales Across years
Graph-1: Analysis and Results
· Weekly Sales if aggregated to derive average sales across years 2010, 2011 and 2012.
· The above graph shows Year 2010 has highest sales compared to that of sales in 2011 and 2012.
· This trend indicates, Average Sales decreasing from 2010 to 2012.
Graph -2: Average weekly Sales Across stores.
Graph – 2: Analysis and Results
· Weekly Sales is aggregated to derive average sales across all the stores.
· Above graphs, helps to understand the sales across different stores and identify the poor performance stores in terms of revenue generation.
· It clearly states that Store 10, 13 and 20 are generating high revenue as the sales are high.
· Sales across stores 3, 5, 33, 36,38,42,43 and 44 are very low and revenue generation would not be high.
Graph -3: Average Store temperatures across all the stores.
Graph -3: Analysis and Results
· Average store temperatures, Temperatures are aggregated to calculate average store temperatures across all the stores.
· Analyzing the above graph, there is no insightful information found as most of the stores have equivalent average store temperatures.
Graph - 4: Average Employment rate across all the stores.
Graph - 4: Analysis and Results
· Average store employment rate across all the stores, given employment rate data across all the stores are aggregated to calculate average store employment rate across all the stores.
· Above Graph clearly shows Stores 12, 28 and 38 are with high employment rate.
Graph - 5: Analysis and Results
Graph - 5: Analysis and Results
· Sales across different regions are aggregated generate mean sales for all the regions
· Regions B and Region C are generating high sales compared to that of other regions A, D and E.
Analyst
Analyst| Information-Technology | Hyderabad, AP, INDIA
Job ID: 350008
Responsibilities
Responsibilities
- The Global Customer Support Center will consist of Customer Support Representatives (CSR) and Monitoring Analysts (MA)
- CSR’s will answer all customer facing phone queues, accept and respond to all customer emails, and will be primary ticket owners (first contact point for all clients)
- MA’s will identify incidents via the “Alert Management System”, assign a CSR, and engage the appropriate technical group for resolution
- Primary interface for partner service desks
- Phone ACD management
- Responsible for efficiency gains in monitoring systems
- MA/CSR should act as a tier .5 technician where he can be able to resolve repeated incidents tickets with the given SOP in any (windows / UNIX / network) domain.
Qualifications
- Engineer should have 1-2 years in the IT infrastructure customer support environment where he handled global customer’s calls, email and alerts.
- Engineer should possess very good communication in terms of listening, oral and written.
- Engineer should have hands on experience in monitoring (HPOV / Sitescope / etc) and ticketing tool (Remedy / etc)
- Engineer should have experience working in 24/7 environment.
- Engineer should have basic knowledge in Windows or UNIX or Network environment
Software Engineer
About this Opportunity
The Target Technology Services (TTS) team designs and creates innovative solutions for a variety of applications, platforms and environments. TTS not only gives Target a competitive advantage in the marketplace, but also enhances the guest experience through the smart use of technology in the retail industry.
Use your skills, experience and talents to be a part of groundbreaking thinking and visionary goals. As a Software Engineer, you'll take the lead as you
- Provides technical expertise to the project team. This includes the recommendation of solution alternatives and the identification of risks.
- Providing progress reporting to the team lead and Project Manager/Lead during the project lifecycle
- Schedules and facilitates solution walkthroughs.
- Follow software quality process and methodology standards, including those for design, data quality, code, version control, defect/change request tracking, documentation, work product review, unit testing and environment management.
- Reviewing requirements and functional specifications and providing feedback to the project team. Includes participation/input to the requirements process.
- Delivering detailed design in accordance with design documentation and ensuring that it undergoes design review by the development team.
- Working with the test team throughout the project life cycle to enable their testing efforts
- Working with the technical lead and release services to migrate code and data to production and pre production environments and working with them to execute release activities
- Other duties and projects as assigned.
Requirements
- Engineering degree in any stream
- Basic SDLC knowledge
- Has at least 2 - 3 years of prior experience
- Strong technical aptitude
- Good verbal, written and presentation skills
- Functions as an effective member of a team by modeling teamwork and team effectiveness
- Ability to learn new skills and technologies
- Effectively organizes and executes a demanding workload
- Understands the implication work assignments have on one portion of a project
Subscribe to:
Posts (Atom)
