Skip to content
Product cover

Making Data Visible So You Can Act On It

December 11, 2012 | Nina Kruschwitz | Social Responsibility
There's a scene early in the 1996 movie "Jerry Maguire" where a sports agent, played by Tom Cruise, decides that his company needs to pursue a more noble path. He writes a manifesto about how the sports management business ought to operate and presents it in a grand overture to the entire staff, peers and executives. He expects to get a big pat on the back. Instead, he gets canned. John Schulz says he had his own "Jerry Maguire moment" with his company, AT&T, about five years ago. "My memo essentially said, 'Look, we really need to take a leadership position around sustainability because we do have such a large portfolio, which means we have a large opportunity,'" Schulz says. "Our technology can be an enabler as well, and that's somewhat unique — not only can we take care of our operations and our own house, but we also have the ability to look at how our technology can be developed for our customers to be more efficient and to reduce their impacts." Schulz didn't get fired for his memo. Instead, he got a different job. AT&T, unbeknownst to him, was already having this kind of conversation at the executive level, getting ready to hire its first Chief Sustainability Officer. He moved from doing a data-centric systems job to working with the company's energy team to assemble AT&T's first greenhouse gas emissions inventory. Today, Schulz is part of AT&T's corporate sustainability group and is a director of sustainability operations, working closely with several business units on integrating sustainability into their operations. In a conversation with MIT Sloan Management Review's Nina Kruschwitz, Schulz talks about AT&T's work to identify and manage its energy and water use and how it goes about framing sustainability work in a business case.
Purchase Options

Educator and Student Discounts Available. Learn more »

  BENCHMARKS  
Loading Time: Base Classes  0.0231
My Controller Construct  0.0198
Build Nav  0.0112
Controller Execution Time ( Products / Route )  0.8996
Total Execution Time  0.9227
  GET DATA  
No GET data exists
  MEMORY USAGE  
1.5565 MB
  POST DATA  
No POST data exists
  URI STRING  
store/making-data-visible-so-you-can-act-on-it
  CLASS/METHOD  
products/route
  DATABASE:  MITSLOAN_DEV   QUERIES: 68  (Hide)
0.0262  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '7a06ba66152267f413a50e5ed2e272e1'
ORDER BY `created_at` DESC 
0.0027  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '7a06ba66152267f413a50e5ed2e272e1'
ORDER BY `created_at` DESC 
0.0003  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '7a06ba66152267f413a50e5ed2e272e1'
ORDER BY `created_at` DESC 
0.0002  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '7a06ba66152267f413a50e5ed2e272e1'
ORDER BY `created_at` DESC 
0.0001  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '7a06ba66152267f413a50e5ed2e272e1'
ORDER BY `created_at` DESC 
0.0001  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '7a06ba66152267f413a50e5ed2e272e1'
ORDER BY `created_at` DESC 
0.0001  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '7a06ba66152267f413a50e5ed2e272e1'
ORDER BY `created_at` DESC 
0.0021  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '7a06ba66152267f413a50e5ed2e272e1'
ORDER BY `created_at` DESC 
0.0002  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '7a06ba66152267f413a50e5ed2e272e1'
ORDER BY `created_at` DESC 
0.0002  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '7a06ba66152267f413a50e5ed2e272e1'
ORDER BY `created_at` DESC 
0.0001  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '7a06ba66152267f413a50e5ed2e272e1'
ORDER BY `created_at` DESC 
0.0001  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '7a06ba66152267f413a50e5ed2e272e1'
ORDER BY `created_at` DESC 
0.0001  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '7a06ba66152267f413a50e5ed2e272e1'
ORDER BY `created_at` DESC 
0.0002  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '7a06ba66152267f413a50e5ed2e272e1'
ORDER BY `created_at` DESC 
0.0001  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '7a06ba66152267f413a50e5ed2e272e1'
ORDER BY `created_at` DESC 
0.0003  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '7a06ba66152267f413a50e5ed2e272e1'
ORDER BY `created_at` DESC 
0.0002  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '7a06ba66152267f413a50e5ed2e272e1'
ORDER BY `created_at` DESC 
0.0001  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '7a06ba66152267f413a50e5ed2e272e1'
ORDER BY `created_at` DESC 
0.0002  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '7a06ba66152267f413a50e5ed2e272e1'
ORDER BY `created_at` DESC 
0.0002  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '7a06ba66152267f413a50e5ed2e272e1'
ORDER BY `created_at` DESC 
0.0001  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '7a06ba66152267f413a50e5ed2e272e1'
ORDER BY `created_at` DESC 
0.0001  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '7a06ba66152267f413a50e5ed2e272e1'
ORDER BY `created_at` DESC 
0.0001  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '7a06ba66152267f413a50e5ed2e272e1'
ORDER BY `created_at` DESC 
0.0001  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '7a06ba66152267f413a50e5ed2e272e1'
ORDER BY `created_at` DESC 
0.0001  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '7a06ba66152267f413a50e5ed2e272e1'
ORDER BY `created_at` DESC 
0.0001  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  '7a06ba66152267f413a50e5ed2e272e1'
ORDER BY `created_at` DESC 
0.0077  

SELECT SQL_CALC_FOUND_ROWS cat_id
FROM (`product_categories`)
WHERE `status_id` =  'A'
AND `url_friendly` =  'making-data-visible-so-you-can-act-on-it'
AND `parent_id` =  1 
0.0348  

SELECT c.parent_id, c.format_id
                    FROM products AS p, products AS c
                    WHERE p.prod_id = c.parent_id AND
                        c.avail_id IN ('A','B','D') AND
                        c.type_id = 'V' AND
                        (
                            c.sku = 'making-data-visible-so-you-can-act-on-it' OR
                            if(c.format_id = 'Certificate', '', p.url_friendly) = 'making-data-visible-so-you-can-act-on-it'
                        )
                    LIMIT 1 
0.0003  

SELECT `parent_id`
FROM (`products`)
WHERE `prod_id` =  2925 
0.0084  

SELECT *
FROM (`products`)
WHERE `products`.`prod_id` =  '2925' 
0.0070  

SELECT *
FROM (`authors`)
JOIN `products__authors` ON `authors`.`author_id` = `products__authors`.`author_id`
WHERE `products__authors`.`prod_id` =  '2925'
ORDER BY `sort` ASC 
0.0021  

SELECT `cat_id`
FROM (`product_categories__products`)
WHERE `prod_id` =  '2925' 
0.0038  

SELECT *
FROM (`product_flags__products`)
WHERE `prod_id` =  '2925' 
0.0029  

SELECT `sku`
FROM (`products__xsell`)
WHERE `prod_id` =  '2925'
ORDER BY IF(position = 0, 1, 0) ASC , `position` 
0.2781  

SELECT `products`.`parent_id`
FROM (`transaction_lines`)
JOIN `products` ON `products`.`sku` = `transaction_lines`.`sku`
JOIN `product_categories__products` ON `products`.`parent_id` = `product_categories__products`.`prod_id`
WHERE `products`.`avail_id` =  'A'
AND TO_DAYS(transaction_lines.updated_at) < (TO_DAYS(NOW()) - 90)
AND `product_categories__products`.`cat_id` IN ('300') 
GROUP BY `products`.`parent_id`
ORDER BY COUNT(*) DESC
LIMIT 6 
0.0003  

SELECT `parent_id`
FROM (`products`)
WHERE `prod_id` =  '4706' 
0.0019  

SELECT *
FROM (`products`)
WHERE `products`.`prod_id` =  '4706' 
0.0021  

SELECT *
FROM (`authors`)
JOIN `products__authors` ON `authors`.`author_id` = `products__authors`.`author_id`
WHERE `products__authors`.`prod_id` =  '4706'
ORDER BY `sort` ASC 
0.0017  

SELECT `parent_id`
FROM (`products`)
WHERE `prod_id` =  '2875' 
0.0003  

SELECT *
FROM (`products`)
WHERE `products`.`prod_id` =  '2875' 
0.0012  

SELECT *
FROM (`authors`)
JOIN `products__authors` ON `authors`.`author_id` = `products__authors`.`author_id`
WHERE `products__authors`.`prod_id` =  '2875'
ORDER BY `sort` ASC 
0.0004  

SELECT `parent_id`
FROM (`products`)
WHERE `prod_id` =  '5' 
0.0022  

SELECT *
FROM (`products`)
WHERE `products`.`prod_id` =  '5' 
0.0017  

SELECT *
FROM (`authors`)
JOIN `products__authors` ON `authors`.`author_id` = `products__authors`.`author_id`
WHERE `products__authors`.`prod_id` =  '5'
ORDER BY `sort` ASC 
0.0002  

SELECT `parent_id`
FROM (`products`)
WHERE `prod_id` =  '969' 
0.0002  

SELECT *
FROM (`products`)
WHERE `products`.`prod_id` =  '969' 
0.0008  

SELECT *
FROM (`authors`)
JOIN `products__authors` ON `authors`.`author_id` = `products__authors`.`author_id`
WHERE `products__authors`.`prod_id` =  '969'
ORDER BY `sort` ASC 
0.0001  

SELECT `parent_id`
FROM (`products`)
WHERE `prod_id` =  '3907' 
0.0002  

SELECT *
FROM (`products`)
WHERE `products`.`prod_id` =  '3907' 
0.0022  

SELECT *
FROM (`authors`)
JOIN `products__authors` ON `authors`.`author_id` = `products__authors`.`author_id`
WHERE `products__authors`.`prod_id` =  '3907'
ORDER BY `sort` ASC 
0.0008  

SELECT `parent_id`
FROM (`products`)
WHERE `prod_id` =  '297' 
0.0002  

SELECT *
FROM (`products`)
WHERE `products`.`prod_id` =  '297' 
0.0002  

SELECT *
FROM (`authors`)
JOIN `products__authors` ON `authors`.`author_id` = `products__authors`.`author_id`
WHERE `products__authors`.`prod_id` =  '297'
ORDER BY `sort` ASC 
0.0052  

SELECT SQL_CALC_FOUND_ROWS media_id, position
FROM (`media`)
WHERE `foreign_key_table` =  'products'
AND `foreign_key_column` =  'prod_id'
AND `foreign_key_value` =  '2925'
AND `kind` =  'image_600x600'
ORDER BY IF(position = 0, 1, 0) ASC , `position` 
0.0025  

SELECT *
FROM (`media`)
WHERE `media`.`media_id` =  '1337' 
0.0045  

SELECT *
FROM (`mime_types`)
WHERE `mime_types`.`extension` =  'jpg' 
0.0032  

SELECT *
FROM (`media_metadata`)
WHERE `media_id` =  '1337' 
0.0004  

SELECT SQL_CALC_FOUND_ROWS media_id, position
FROM (`media`)
WHERE `foreign_key_table` =  'products'
AND `foreign_key_column` =  'prod_id'
AND `foreign_key_value` =  '2925'
AND `kind` =  'gallery_image'
ORDER BY IF(position = 0, 1, 0) ASC , `position` 
0.0010  

SELECT *
FROM (`products`)
WHERE `avail_id` IN ('A', 'B', 'C', 'H') 
AND `parent_id` =  '2925'
AND `type_id` =  'V'
ORDER BY IF(position = 0, 1, 0) ASC , `position`, `title` 
0.0002  

SELECT `c`.`format_id`, `c`.`price`, `c`.`sale_price`
FROM (`products` AS c)
WHERE `c`.`prod_id` =  '2926'
LIMIT 1 
0.0004  

SELECT SQL_CALC_FOUND_ROWS media_id, position
FROM (`media`)
WHERE `foreign_key_table` =  'products'
AND `foreign_key_column` =  'prod_id'
AND `foreign_key_value` =  '2926'
AND `kind` =  'thumbnail'
ORDER BY IF(position = 0, 1, 0) ASC , `position` 
0.0014  

SELECT `product_categories__products`.`cat_id`
FROM (`product_categories__products`)
JOIN `product_categories` ON `product_categories__products`.`cat_id` = `product_categories`.`cat_id`
WHERE `product_categories__products`.`prod_id` =  '2925'
AND `product_categories`.`parent_id` =  1
AND `product_categories__products`.`cat_id` NOT IN (1, 261)  
0.0031  

SELECT `cat_id` AS id, `parent_id` AS parent, `status_id`, `name`, `description`, `url_friendly`, `page_title`, `meta_keywords`, `meta_description`, `position`, `updated_at`
FROM (`product_categories`)
WHERE `cat_id` != 1
ORDER BY `parent_id`, IF(position = 0, 1, 0) ASC , `position`, `name` 
0.0045  

SELECT *
FROM (`product_categories`)
WHERE `status_id` =  'A'
AND `parent_id` =  1
AND `cat_id` NOT IN (1, 261) 
ORDER BY `name` 
0.0175  

SELECT *
FROM (`site_settings`)
WHERE `option_key` =  'announcement' 
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)