Business Analyst Essay

Submitted By gdstan
Words: 845
Pages: 4
Open Document
Case Studies: Reporting & Predictive Analytics Sr. No. | | Clients | | Domain | | Business Objective | | Approach | | Result | | Tools / Technique Used | | 1 | | A leading hardware manufacturer | | ROI analysis | | To measure ROI of a marketing program and prioritize future spend for similar programs | | A test and control group was designed for pre and post program measurement and ANOVA was performed on sales of both test and control stores to see if there was significant ROI differences in sales of test stores | | The analysis suggested that there was significant ROI in only two retailers. This helped the client direct spend for the 2 retailers towards other programs | | ANOVA | | 2 | | A large retailer | | Interactive reporting | | To develop an interactive dashboard to compare and benchmark sales performance of various stores | | A MS-Excel based dashboard was developed to perform drill down analysis by division within store, segment and store characteristics. Ranking functionality enabled to differentiate best /worst performing stores on any user selected metric | | The dashboard can be monitored on a real time basis and corrective actions can quickly be taken to improve performance of selective stores | | SAS , SQL, EXCEL & VBA | | 3 | | A leading Credit card company | | Cross sell / up sell | | Develop sell/Cross sell strategy for credit card portfolio | | Predictive models were developed to identify customers with higher propensity to purchase products based on past spend behavior | | The predicted leads resulted in significant lift in conversion rate of leads prioritized by the model as compared to the leads prior to model | | Segmentation, Logistic Regression | | 4 | | A leading Re-insurance company | | Risk Scorecard | | To develop an Insurance Risk Scorecard | | Key risk drivers were identified that need to be monitored on regular basis for entire reinsurance business | | This score card used by multiple groups within the client and reported on a periodic basis | | Explanatory Data Analysis | | 5 | | A leading charge and credit card company | | Performance Scorecard | | To track performance of newly acquired accounts | | The analysis compared performance of different offers /campaigns over a period of time for the newly acquired accounts | | KPI was compared with the projected finance data to better understand the profitability by product mix/offers | | Exploratory data analysis | | 6 | | A large CPG company | | Customized tool development | | To view various sales performance metrics by region | | An interactive map dashboard was developed which allowed users to select any region and view corresponding sales metrics in an easy to comprehend manner | | Almost real time view of sales performance across various regions. Various business defined metrics can also be monitored for quicker & effective decision making | | Xcelsius, Dundas Charts | | 7 | | A large CPG company | | Data management | | To have access to latest and accurate data by automating routine and time consuming aspects of data preparation | | A tool was developed in VB and MS-Access which could integrate different data sources and apply business rules (like weights, cut-offs, etc) for data cleaning | | Reports were available almost real time, with latest data. Users were able to spend more time in interpreting data for taking effective decisions rather than collating data | | VB, MS-Access, Excel | | 8 | | A large retailer | | Dashboard | | To develop an interactive dashboard to compare and benchmark merchandize performance of various brands across stores | | A VBA based MS-Excel dashboard Behavior | | The dashboard can be monitored on a real time basis and corrective actions can quickly be taken to improve performance of selective stores/brands | | SPSS, SQL, Excel & VBA
Show More

Related Documents: Business Analyst Essay

Essay on Golden Rules for Business Analysts

Abstract Like all professions, business analysis has its golden rules – rules that are fundamental to the design of successful business systems. They might seem like common sense but it’s surprising how often we forget them and get ourselves into hot water. Here’s a short list of some of the more relevant ones… The sooner you find a problem, the cheaper it is to fix Get the specifications right Recognise the total cost of a system Don’t design the solution before you’ve analysed the problem…

Words 3078 - Pages 13

Role In Agile Project

INTRODUCTION This essay reflects to view the role of analysts in agile projects as put across by the writers of system analysis and design. According to Satzinger, Jackson and Burd (2012, p.6) agile development is an information system development that emphasizes flexibility to anticipate new requirements during development. The information regarding the role of analysts in agile project, the impact of analysts in agile projects, how they contribute to team success, how they adapt to the change in…

Words 1633 - Pages 7

Essay on Management Analysts

Management Analysts The career that I have chosen for my prevalence would be Management Analysts. This occupation pertains to the following ; Management Analysts , often called Management Consultants provide ways to improve an organization’s efficiency.They advise managers on how to make organizations more profitable through reduced costs and increase revenues. The duties of a management analysts or consultant is( are ) the following: * Gather and organize information about the problem to…

Words 846 - Pages 4

Isys 110 - Applied Business in Is Essay

ISYS 110 → Week 1 LECTURE (30/07/12) Applied Business in IS Description: • This unit introduces system design and analysis concepts in developing information systems • This unit also provides a practical approach to the use of commonly available spread sheet, database and accounting packages and their application in supporting business information systems requirements in business and other organisations Assessment: 1. EXCEL 2007 Practical Exam (open book) – week 4 tutorial → 15% 2. ACCESS…

Words 1077 - Pages 5

Reflective Paper

in Business Analysis Division, I had a vague idea of what that position would entail. A future role of business analyst seemed to be both very challenging yet rather exciting. Going into my first day I wasn’t sure as to what is expected of me as an intern and how I would add value. Right before the start of my internship term, I was recommended to read a book “Business Analysis: Best Practices for Success” by Steven P. Blais. My intention was to get familiar with the mindset of a business analyst…

Words 2422 - Pages 10

Accounting Major

am currently an accounting major however, by the end of the semester, I will change my major to finance. With that being said, I will be talking about careers in the finance world. What these two majors have in common is that they are both in the business field, play big roles in businesses, and involve working with numbers. However, finance works more with numbers than accounting. In this essay, I will briefly explain some research about the projected demand and salaries for a finance major. First…

Words 544 - Pages 3

Is Concentration And Career Analysis

IS Concentration and Career Analysis Introduction Coming from a family that owns a small business, I decided to pursue a degree in business administration with concentration in management and marketing. By the time I graduated from college, I realized how important it is to implement information technology into a small business like ours. Our competitors have created online shopping websites which result in increasing sales and expanding territories. It would be cost insufficient for us to hire…

Words 1825 - Pages 8

Career Research Essay

Career Research Business Systems Analysis/Design/IT-210 January 13, 2013 Career Research Technology is the making, modification, usage, and knowledge of tools, machines, techniques, crafts, systems, methods of organization, in order to solve a problem, improve a preexisting solution to a problem, achieve a goal, handle an applied input or output relation or perform a specific function. (technology). This paper focuses on careers in the technology field. There are…

Words 466 - Pages 2

Ethics in Financial Reporting Essay

Significant Points of a Financial Analyst Career | * An individual with a great financial analyst salary in most cases has great interpersonal skills and an aptitude for working with numbers are among the most important qualifications for financial analysts and personal financial advisors. * Keen competition is anticipated for these highly paid positions, despite rapid job growth; those who have earned a professional designation or an MBA are expected to have the best opportunities.…

Words 3462 - Pages 14

Essay on Ecomomic Project

Economic Project After graduating high school, two of my potential career paths are to pursue pharmacist or a financial analyst. Pharmacist is a person who is professionally qualified to prepare and dispense medicinal drugs, advises the medical staff about drug selection and effects, monitors drug regimens, and prepares sterile IVs. An entry level job for a pharmacist is a Pharmtech, Pharmacy Technicians are referred to as pharmacy technologist, assistants, or aids. To become a pharmacist, you have…

Words 591 - Pages 3