OnLine Analytical Processing (OLAP) for Sagan’s Marketing Department

It’s the end of the financial year, and the marketing and sales department at Sagan’s Sports Goods

manufacturing company is heavily involved in formulating marketing strategies for the coming year.

Before investing in market surveys and market research, the management wishes to make maximum use

of the customer records contained in their information systems.

A data warehouse expert has been assigned the task of consolidating customer information from several

different data sources into a single data warehouse and developing an on-line analytical processing

(OLAP) facility. Integrating all data sources into the data warehouse is not at all straightforward. The

data warehouse has been created. It might also be available as a backup on Moodle. As the business analyst, you have to carry out the following tasks and report to the management.

The key requirements of this assignment are:

1. Identify market segments for each of the following business measures:

a. margin = (1 - TotalProductCost / TotalSalesAmount) x 100%

b. penetration = (average TotalSalesAmount per customer)

c. total profitability = (TotalSalesAmount – TotalProductCost)

and do this for different market segments (e.g., French house owners), noting (e.g.) the segment with

the largest amount of sales (items, dollars).

2. Generate reports using SQL Server Reporting Services that demonstrate for each of these segments

the relative profitability, penetration and margin - and whether these values are high or low.

3. Analyze the relationship among average NoOfDaysToShip, TotalSalesAmount per customer and

Number of Orders per customer by generating necessary reports.

4. Discuss some of the potential implications for marketing and sales of the results of your queries and

reports. (Students can make reasonable assumptions at this point, talk to the lecturer or tutors if

clarification/assurance required.) (Hint: Students should investigate the data from several

dimensions – customer, product – categories/sub-categories, sales regions/personnel, geography, etc.

to identify potential interesting areas for market research.)


Your submission should be in the format of a report. The report should be a maximum of 2250 words (as

far as words go) in addition to (e.g.) screen shots, etc. The report should contain the following:

1. Method. A description of the analysis that you undertook to identify the segments, etc.

2. Findings. Interesting (probabilistic) findings with evidence

3. Reports. Outputs of the reports that demonstrate your (probabilistic) findings

4. Summary. A business summary of what the analysis conveys

Skills: Database Administration, MySQL, Software Architecture, Software Testing, SQL

See more: what's online business, warehouse market, talk to an expert online, sports marketing business, software developing in online, segments on a line, requirements for marketing, report on online marketing, reporting services sql, reporting analyst, processing orders online, online services market, online sales market, online research reports, online research report, online research market, online moodle, online market systems, online market research surveys, online market reports, online marketing students, on-line marketing services, on line marketing services, online marketing report, on-line marketing

About the Employer:
( 1 review ) Dhaka, Bangladesh

Project ID: #5019178

6 freelancers are bidding on average $12/hour for this job


Dear, I am SQL expert and Microsoft Certified Master with over 10 years of experience in all flavors and areas of both the technologies including DataWarehouse, Data Mining, SSIS, SSAS and SSRS. As an ex-Mckinsey More

$14 USD / hour
(1 Review)

Hi i gone through your requirements . we are ready to start this Project without any initial [url removed, login to view] my PM. Skype id [url removed, login to view]

$12 USD / hour
(0 Reviews)

Dear Sir, Currently my main working is database administration and supply chain analytical system maintenace. Let me instroduce the system I am maintenacing. The system basically is a data warehouse system, the da More

$13 USD / hour
(0 Reviews)

A technocrat with 8+ Years (SQL Server2005/2008R2 +SSRS+SSIS) of extensive experience in Software Development Life Cycle (SDLC) & Project Coordination. Presently associated with ISTS InfoTech Solutions Pvt. Ltd. As T More

$14 USD / hour
(0 Reviews)

Hi Its been around 7 years of experience in the OLAP tool SAP Business Objects. worked on different version from 6.5 to 4.1 And have 3 years working experience on In Memory Technology Qlikview 11. Prior to BI tec More

$10 USD / hour
(0 Reviews)

Hello, I am interested to join you and ready to start immediately and I am sure that i can work on your requirements with confident manner. I have strong experience in Ruby on Rails, HTML, CSS, JavaScript 1.3( More

$11 USD / hour
(0 Reviews)