Thesis Defense - Improving a dashboard efficiency - 2010 - EN

50 %
50 %
Information about Thesis Defense - Improving a dashboard efficiency - 2010 - EN
How-to & DIY

Published on December 5, 2010

Author: SonnyBx

Source: slideshare.net

Description

This presentation is talking about my thesis defense (Computer Science), on the subject: Improving a dashboard efficiency. The PPT is in english and has some animations.
My grade on this thesis was 19.25/20.
------------------
Il s'agit de la présentation de ma défense de mémoire (Informatique), dont le sujet est: Améliorer l'efficacité d'un tableau de bord. Le PPT est en anglais et possède quelques animations.
J'ai obtenu la note de 19.25/20 pour cette thèse.

Improving a dashboard efficiency Author : Sonny Brabez

Table of content Describing the job and SAP AG Discovering ad-serving The business needs Analyzing the thesis subject Defining the term « dashboard » The dashboard process Work and results Summary and conclusion

Describing the job and SAP AG

Discovering ad-serving

The business needs

Analyzing the thesis subject

Defining the term « dashboard »

The dashboard process

Work and results

Summary and conclusion

Describing the job and SAP AG Goal : enable the support of online promotions by using the ad-serving platform (OpenX) Tasks: Develop web-based tools Build an automated weekly reporting system Implement an ad-serving performance dashboard 1/3 The job description

Goal : enable the support of online promotions by using the ad-serving platform (OpenX)

Tasks:

Develop web-based tools

Build an automated weekly reporting system

Implement an ad-serving performance dashboard

Describing the job and SAP AG Large enterprise: 48,021 employees worldwide Annual revenue: $14 billion Provides enterprise software applications and support for more than 100,000 companies Main product: SAP ERP Vision : Make the world run better Mission : Make every customer a best-run business 2/3 SAP AG

Large enterprise: 48,021 employees worldwide

Annual revenue: $14 billion

Provides enterprise software applications and support for more than 100,000 companies

Main product: SAP ERP

Vision : Make the world run better

Mission : Make every customer a best-run business

Describing the job and SAP AG Main team : Marketing Sub-team : Online advertisement marketing Director : Michael Aidane Sub-team of 3 people 3/3 The team Richard Rogers Michael Aidane Pamela Mattes Sonny Brabez Marketing Online advertisement

Main team : Marketing

Sub-team : Online advertisement marketing

Director : Michael Aidane

Sub-team of 3 people

Discovering ad-serving Goal : Manage the advertisements on your website Serve the ads on the website (banners) Monitor the traffic of the ads (page view/click) Organize the ads (campaigns) 1/2 What is the ad-serving platform?

Goal : Manage the advertisements on your website

Serve the ads on the website (banners)

Monitor the traffic of the ads (page view/click)

Organize the ads (campaigns)

Discovering ad-serving Ad-server : OpenX Server Serves multiple types of ads formats Monitors the view, clicks and forms Organizes the ads in a russian puppet system 2/2 OpenX Server SERVE MONITOR ORGANIZE … Images Flash Videos Impressions -> nb of view Clicks -> nb of clicks Conversions -> nb of filled forms BANNERS CAMPAIGNS ADVERTISERS … …

Ad-server : OpenX Server

Serves multiple types of ads formats

Monitors the view, clicks and forms

Organizes the ads in a russian puppet system

Impressions

-> nb of view

Clicks

-> nb of clicks

Conversions

-> nb of filled forms

The business needs Why does SAP need to know the success of the various online advertisements on its website? Let us know the customer behavior Let us discover the best online advertisements Let us prioritize the best online advertisements 1/2 Why the ad-serving project? Understanding the customer selection is understanding our future orientation!

Why does SAP need to know the success of the various online advertisements on its website?

Let us know the customer behavior

Let us discover the best online advertisements

Let us prioritize the best online advertisements

The business needs 2/2 Example on SAP.COM Advertisement 1 Advertisement 2 Advertisement 3 Advertisement 4

Analyzing the thesis subject 1/2 Improving a dashboard efficiency ‘’ Improving a dashboard efficiency ‘’ Audiences use it often, results are easy to understand…

Analyzing the thesis subject Information harder to get nowadays Bonds between Computer Science and Business Guide for a dashboard project Why the subject “Improving a dashboard efficiency”?

Information harder to get nowadays

Bonds between Computer Science and Business

Guide for a dashboard project

Defining the term « dashboard » A dashboard is a control panel located under the windshield of an automobile 1/2 In everyday life DISPLAY MANAGE INDICATE QUICK GLANCE TO MAKE A DECISION

A dashboard is a control panel located under the windshield of an automobile

Defining the term « dashboard » A representation of key indicators in one panel with the goal of letting us monitor and make decisions 2/2 As an application UNIQUE VIEW COLORFUL SIMPLE MAIN MEASURES CURRENT DATA QUICK GLANCE + + + + =

A representation of key indicators in one panel with the goal of letting us monitor and make decisions

The dashboard process Find out the data to show Doing research Studying the system Interview the users Find out the main measures KPI Wheel Define a dashboard design Aesthetic and layout Navigation Select a dashboard solution Vendor Technology and features 1/3 Step 1: Understand KPI WHEEL XCELSIUS 2008

Find out the data to show

Doing research

Studying the system

Interview the users

Find out the main measures

KPI Wheel

Define a dashboard design

Aesthetic and layout

Navigation

Select a dashboard solution

Vendor

Technology and features

The dashboard process Extract the data Know the source type of the data Gather data in one data source Transform the data Fixed data to be understandable Plan where the transformation must occur Check out the final result Load the data Check out the type of source your dashboard application can load 2/3 Step 2: Implement ETL APPLICATION

Extract the data

Know the source type of the data

Gather data in one data source

Transform the data

Fixed data to be understandable

Plan where the transformation must occur

Check out the final result

Load the data

Check out the type of source your dashboard application can load

The dashboard process A dashboard application must be revised frequently The business needs change frequently Correct issues the audience may encounter: audit the solution Think about the audience Let them give you feedback Key of the success 3/3 Step 3: Update Think about us! We are the « customers » of your solution!

A dashboard application must be revised frequently

The business needs change frequently

Correct issues the audience may encounter: audit the solution

Think about the audience

Let them give you feedback

Key of the success

Work and results Three tasks Additional web tools for OpenX Automatic weekly scheduled reporting system Performance dashboard Task 1: “Checkers” development Check out issues from broken ads Check out the images Task 2: Ad-serving reports delivery Data extracted, transformed from OpenX Week delivery of data in multiple reports Task 3: On-demand dashboard New technology: BI OnDemand User driven 1/2 My work

Three tasks

Additional web tools for OpenX

Automatic weekly scheduled reporting system

Performance dashboard

Task 1: “Checkers” development

Check out issues from broken ads

Check out the images

Task 2: Ad-serving reports delivery

Data extracted, transformed from OpenX

Week delivery of data in multiple reports

Task 3: On-demand dashboard

New technology: BI OnDemand

User driven

Work and results Only the third task wasn’t completed Reasons Limited resources Pilot project Unknown audience Draft 2/2 Results

Only the third task wasn’t completed

Reasons

Limited resources

Pilot project

Unknown audience

Draft

Summary and conclusion Learned Dashboard ETL Application Ad-serving On-demand technology Improving a dashboard efficiency Understand the notion of dashboard and the business needs Implement the dashboard in 3 steps Have a clear perception of the audience

Learned

Dashboard

ETL Application

Ad-serving

On-demand technology

Improving a dashboard efficiency

Understand the notion of dashboard and the business needs

Implement the dashboard in 3 steps

Have a clear perception of the audience

Q&A and Thank you Q ? &A

Q ?

Add a comment

Related presentations

Related pages

Improving: Trust Changes Everything

Best Place to Work. Improving recognizes that our employees' careers involve a considerable amount of time, effort, and investment. As a result, it is ...
Read more

Theses Completed| | Energy Policy & Modelling Group UCC

... Minor Thesis UCC, Sept. 2010 ... Sept. 2010. Rogan F. 2009 Improving Ireland’s National Energy Efficiency ... Energy Policy and Modelling Research ...
Read more

TechStat: Improving Government Performance | whitehouse.gov

Chief Information Officer Vivek Kundra discusses how the federal government is using the IT Dashboard combined ... January 2010. A TechStat ... Defense ...
Read more

Executive Order -- Improving Performance of Federal ...

... to execute Federal permitting and review processes with maximum efficiency and ... (Improving Regulation and ... Infrastructure Projects Dashboard ...
Read more

Energy Savings at Home - ENERGY STAR | The Simple Choice ...

energy savings at home. Improving your home's energy efficiency with ENERGY STAR can help to lower high ... your new dashboard to ... Recursos en Español;
Read more

Brake pad - Wikipedia, the free encyclopedia

Still others have a soft metal tab embedded in the pad material that closes an electric circuit and lights a dashboard ... 2010 will limit the amount of ...
Read more

Utah Building Energy Efficiency Strategies

Improving your home's energy efficiency with ENERGY STAR ... Fifty percent of state buildings have been benchmarked by the end of 2010, ... Recursos en ...
Read more

Efficacy - Wikipedia, the free encyclopedia

(December 2010) Efficacy is the capacity for beneficial change ... Efficiency (disambiguation) Placebo (origins of technical term) Potency (pharmacology)
Read more