Air France Demo by Mediaserv: Microsoft Office and SQL Server Demo

Air France Demo by MediaServ
Microsoft Office and SQL Server demo

Demonstration Positioning
Appropriate Presenter

The presenter should be very familiar with Excel 5.0 and SQL Server Airlines Solution Provider developers Companies considering the MS Office suite of products
Appropriate Audience
Approximate Duration of the Demonstration This demonstration will take between 3 and 4 minutes to complete
Installation
Required Equipment:

386 33 or higher PC 4 MB RAM minimum, 8 MB recommended 20 MB free hard disk space
Required Applications
The following applications should be installed on your PC. Should you need to install, you can find them on \\PRODUCTS2\RELEASE Excel 5.0 Word 6.0 MS Mail
Files to Copy Add Demo Icons
pg. 1
Air France/MediaServ Demo
6/11/2011
Preparation
Introduction(Please begin demo with this introduction)
Like many large global companies, Air France must be able to monitor results from many dispersed locations. The client-server sales management system that you will see today greatly improved Air France managements access to sales and ticketing information from over 40,000 travel agents across the U.S.. Before the implementation of the Agency Information Monitoring System(AIMS), Air Frances sales data was trapped on a mainframe in a proprietary database. Reports ran slowly, produced inconsistent results, and were almost impossible to maintain. Managers had no easy to use, on-line system, and therefore had to wait until the paper reports were distributed to review their sales data. Working with MediaServ, a Microsoft Solution Provider, Air France developed a client-server EIS system based on Microsoft SQL Server for Windows NT and Microsoft Office. Topic Script The AIMS system was developed using the MS Office suite of products. The interface you see when you first enter the system was developed in Excel 5.0 using the Visual Basic for Applications macro language. Being able to customize the application and glue the Office components such as Excel, Word, and Mail using Visual Basic for Applications were both critical requirements in the development of the AIMS system. Enterprise wide data access was also critical Through the ODBCs SQL driver, Excel 5.0 is able to dynamically access enterprise data off SQL Server running on Windows NT. We are now in the sales management module. Table builder allows us to select any data we want and then it builds an Excel 5.0 table for us. The data is accessed through a live connection to SQL Server on Windows NT. Lets take a look at the sales data from Los Angeles. We want to understand how our different sales representatives are performing and we will use Excel 5.0 pivot table technology to do that. Action Double click on Air France icon Sign in User Name Matt Wilson(no password is required) Click Sales Management
AIR FRANCE
DEVELOPS CLIENT SERVER SALE MANAGEMENT SYSTEM
MS OFFICE AND SQL SERVER NT

BASED ON
Click Los Angeles Check Sales(in table builder) Check Travel Agent, Sales Rep., and District Check Premier, Business, and Economy Click Create Summary Table
PIVOT TABLES
PROVIDE DYNAMIC, MULTI-DIMENSIONAL
From here the managers can use the pivot table technology and charting capabilities in Excel 5.0 to get different views of their
Click Month and drag above Ticket Class
pg. 2
6/11/2011
DATA ANALYSIS
data. We are interested to see total ticket sales by sales rep. broken out by ticket class. This is easy to do using the pivot table.
Check OK to Replace conents of Destination Cells? Click Ticket Class and drag to column in table
EXCEL 5.0S
POWERFUL CHARTING CAPABILITIES PROVIDE FLEXIBILITY IN DATA DISPLAY
With chart builder, we can create a chart of our data. Now we are looking at a chart showing total ticket sales for the past 10 months. It is broken out for each of the sales reps. and by ticket class. We can rotate the chart to show any view we want using these custom controls We can also easily change the chart type so the sales manager can display the data in the most effective format. Lets go back to the column chart. It displays our data better It looks like Eric Goering is having some problems. With the AIMS system, the sales manager can quickly identify an underperforming sales rep. and put together a plan to get the rep. back on track. We can also drill down on a specific number and use the autofilter capabilities in Excel 5.0 to better understand the data. Looks like Jane is doing an incredible job of selling Economy class tickets. Lets try to understand why. We now have a breakdown of the $604,372. Lets create a custom autofilter to display the agencies that are the big hitters for Jane. We can see that Jane has established a lucrative business with Mill-Run Tours. We may want to better understand why that agency is so successful Using the AIMS system, we can also create reports using Word 6.0 and OLE 2 automation, export the SQL server data to a local Access database, and route the sales data using MS Mail. Air France initially plans to deploy this system to the regional managers to help them manage their sales reps. Later, however, they may deploy a cross platform version on both Windows based
Click Chart Builder
Use scroll bars to rotate right then rotate down. Click 3-D Area Chart Click 3-D Column Chart Click Variation from Avg.
Click Return to Sales Table at the bottom of the screen Double click on $604,372
EXCEL 5.0S NEW

AUTOFILTER CAPABILITY ALLOWS YOU TO CREATE CUSTOM QUERIES IN A MATTER OF SECONDS
Highlight First Row Click Autofilter (funnel with = sign) Click Arrow by Sales column Right mouse click Choose > Scroll to 30256 Press Contol and Page Down on the keyboard once. You should return to the Sales table screen Point to Report Builder, Export to Access, and Route Sales Data
IN THE FUTURE, AIMS WILL BE A

CROSS PLATFORM SYSTEM, RUNNING ON BOTH
Click Return to Table Builder(to the right of Route Sales Data) Click Return to Main Menu
WINDOWS
pg. 3
6/11/2011
AND
MACINTOSH
PCs and Apple PowerBooks to all the sales reps across the US
pg. 4
6/11/2011

Air France Demo by Mediaserv: Microsoft Office and SQL Server Demo

Uploaded by

Copyright:

Available Formats

Air France Demo by Mediaserv: Microsoft Office and SQL Server Demo

Uploaded by

Document Information

Original Description:

Original Title

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

Air France Demo by Mediaserv: Microsoft Office and SQL Server Demo

Uploaded by

Copyright:

Available Formats

Air France Demo by MediaServ

Microsoft Office and SQL Server demo

386 33 or higher PC 4 MB RAM minimum, 8 MB recommended 20 MB free hard disk space

Files to Copy Add Demo Icons

Air France/MediaServ Demo

MS OFFICE AND SQL SERVER NT

Click Month and drag above Ticket Class

Air France/MediaServ Demo

Click Chart Builder

EXCEL 5.0S NEW

IN THE FUTURE, AIMS WILL BE A

Air France/MediaServ Demo

Air France/MediaServ Demo

You might also like