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.0005
My Controller Construct  0.0003
Build Nav  0.0006
Controller Execution Time ( Products / Route )  0.0754
Total Execution Time  0.0759
  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.0016  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  'b5276eeddf4a14a5e16d27cfe3bf1744'
ORDER BY `created_at` DESC 
0.0010  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  'b5276eeddf4a14a5e16d27cfe3bf1744'
ORDER BY `created_at` DESC 
0.0010  

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

SELECT *
FROM (`carts`)
WHERE `cart_id` =  'b5276eeddf4a14a5e16d27cfe3bf1744'
ORDER BY `created_at` DESC 
0.0010  

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

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

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

SELECT *
FROM (`carts`)
WHERE `cart_id` =  'b5276eeddf4a14a5e16d27cfe3bf1744'
ORDER BY `created_at` DESC 
0.0006  

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

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

SELECT *
FROM (`carts`)
WHERE `cart_id` =  'b5276eeddf4a14a5e16d27cfe3bf1744'
ORDER BY `created_at` DESC 
0.0009  

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

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

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

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

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

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

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

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

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

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

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

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

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

SELECT *
FROM (`carts`)
WHERE `cart_id` =  'b5276eeddf4a14a5e16d27cfe3bf1744'
ORDER BY `created_at` DESC 
0.0004  

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

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.0250  

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.0003  

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

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.0001  

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

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

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

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.0002  

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

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

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.0001  

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

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

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.0001  

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

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

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` =  '3907' 
0.0008  

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

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.0001  

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

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

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` =  '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.0006  

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.0001  

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

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

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

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.0002  

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.0001  

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

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.0002  

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.0006  

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.0003  

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

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