174856.Session7-Dashboard

2-708-96 Information Technology in Organizations Séance 7: Complex Queries and Management Dashboard : 

2-708-96 Information Technology in Organizations Séance 7: Complex Queries and Management Dashboard

Wildcard characters : 

Wildcard characters Used to specify open-ended criteria or when you are not sure of how the criteria should be stated Like

Manager or Firefighter? : 

Manager or Firefighter? Changes in the Canadian dollar exchange rate require you to make Comptoir operate more efficiently. In order to maintain its historical levels of profitability. You need to look at a number of important indicators to understand how Comptoir functions. Your objective is to identify problems before they become crises. A firefighter puts out fires, a manager prevents them from occuring.

Why efficiency? : 

Why efficiency? Profit = Revenue – Expenses Comptoir exports its products to the US 1$ US is now worth fewer Canadian dollars than before which is the equivalent of a reduction in revenues but not in expenses. To maintain profitability you must either reduce expenses while maintaining revenues or increase revenues while maintaining expenses = be more efficient.

Questions to ask : 

Questions to ask Where is it possible to increase revenues ? Where is it possible to reduce costs ?

Queries related to revenues : 

Queries related to revenues Create queries to analyse sales Sales by product Sales by employee Sales by client Sales by categorie Use Grouping functions Sorting Calculated fields Save your queries

Analysis of sales queries : 

Analysis of sales queries What are your conclusions of the sales situation at Comptoir? Best and worst salesperson, revenue producing product, revenue producing category …

New information – product costs : 

New information – product costs Adding a single field to the database provides a different perspective on operations. With the product unit price we can redo our sales analysis using a margin perspective. Does this change your analysis? Does it change the actions you might take to get more efficient?

Additional considerations ? : 

Additional considerations ? Make your margin analysis more realistic by taking into account … The product discount The sales commission of 15% (a cost)

Management dashboard : 

Management dashboard Source: www.tableaudebord.com

Management dashboard : 

Management dashboard ... Includes a certain number of key indicators related to the operations ofthe company. ... Each indicator is associated with some critical success factor. ... Highlights significant results, exceptions, variabces, and trends (PUSH information to the user) ... Presents information in a summary form but allows drilldown access to the details (permits the user to PULL information from the system) www.tableaudebord.com

Different dashboards for different users : 

Different dashboards for different users Information Systems and Data Bases and External Data Sources Operations Manager dashboard Middle Manager dashboard Senior Manager dashboard

Example of a functional technology architecture : 

Example of a functional technology architecture SAP Corporate Systems Other Sources Functions Management Dashboards Decision models (Theme 3) Data models (Theme 2) Theme 4 Processes and Systems (Theme 1)