Skip to content
Product cover

Want to Improve Your Portfolio? Call a Scientist

June 20, 2016 | David Kiron, Sam Ransbotham | Data, AI, & Machine Learning

In a conversation with MIT SMR's David Kiron and Sam Ransbotham, associate professor of information systems at the Carroll School of Management at Boston College and guest editor for the Data and Analytics Big Idea Initiative for the MIT Sloan Management Review, Jeffrey Bohn, chief science officer at State Street Global Exchange discusses how he is developing better trading and risk strategies for clients using State Street's proprietary data and analytics.

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.1345
Total Execution Time  0.1350
  GET DATA  
No GET data exists
  MEMORY USAGE  
1.5619 MB
  POST DATA  
No POST data exists
  URI STRING  
store/want-to-improve-your-portfolio-call-a-scientist
  CLASS/METHOD  
products/route
  DATABASE:  MITSLOAN_DEV   QUERIES: 68  (Hide)
0.0061  

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

SELECT *
FROM (`carts`)
WHERE `cart_id` =  'e073a70b69c4e880c72aa00e13a1cefc'
ORDER BY `created_at` DESC 
0.0017  

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

SELECT *
FROM (`carts`)
WHERE `cart_id` =  'e073a70b69c4e880c72aa00e13a1cefc'
ORDER BY `created_at` DESC 
0.0005  

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

SELECT *
FROM (`carts`)
WHERE `cart_id` =  'e073a70b69c4e880c72aa00e13a1cefc'
ORDER BY `created_at` DESC 
0.0012  

SELECT *
FROM (`carts`)
WHERE `cart_id` =  'e073a70b69c4e880c72aa00e13a1cefc'
ORDER BY `created_at` DESC 
0.0007  

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

SELECT *
FROM (`carts`)
WHERE `cart_id` =  'e073a70b69c4e880c72aa00e13a1cefc'
ORDER BY `created_at` DESC 
0.0033  

SELECT SQL_CALC_FOUND_ROWS cat_id
FROM (`product_categories`)
WHERE `status_id` =  'A'
AND `url_friendly` =  'want-to-improve-your-portfolio-call-a-scientist'
AND `parent_id` =  1 
0.0226  

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 = 'want-to-improve-your-portfolio-call-a-scientist' OR
                            if(c.format_id = 'Certificate', '', p.url_friendly) = 'want-to-improve-your-portfolio-call-a-scientist'
                        )
                    LIMIT 1 
0.0002  

SELECT `parent_id`
FROM (`products`)
WHERE `prod_id` =  2745 
0.0017  

SELECT *
FROM (`products`)
WHERE `products`.`prod_id` =  '2745' 
0.0056  

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

SELECT `cat_id`
FROM (`product_categories__products`)
WHERE `prod_id` =  '2745' 
0.0044  

SELECT *
FROM (`product_flags__products`)
WHERE `prod_id` =  '2745' 
0.0032  

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

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 ('276') 
GROUP BY `products`.`parent_id`
ORDER BY COUNT(*) DESC
LIMIT 6 
0.0002  

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

SELECT *
FROM (`products`)
WHERE `products`.`prod_id` =  '701' 
0.0011  

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

SELECT `parent_id`
FROM (`products`)
WHERE `prod_id` =  '3943' 
0.0001  

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

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

SELECT `parent_id`
FROM (`products`)
WHERE `prod_id` =  '3049' 
0.0001  

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

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

SELECT `parent_id`
FROM (`products`)
WHERE `prod_id` =  '3433' 
0.0001  

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

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

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

SELECT *
FROM (`products`)
WHERE `products`.`prod_id` =  '3497' 
0.0009  

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

SELECT `parent_id`
FROM (`products`)
WHERE `prod_id` =  '4191' 
0.0001  

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

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

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` =  '2745'
AND `kind` =  'image_600x600'
ORDER BY IF(position = 0, 1, 0) ASC , `position` 
0.0002  

SELECT *
FROM (`media`)
WHERE `media`.`media_id` =  '1251' 
0.0014  

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

SELECT *
FROM (`media_metadata`)
WHERE `media_id` =  '1251' 
0.0003  

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` =  '2745'
AND `kind` =  'gallery_image'
ORDER BY IF(position = 0, 1, 0) ASC , `position` 
0.0003  

SELECT *
FROM (`products`)
WHERE `avail_id` IN ('A', 'B', 'C', 'H') 
AND `parent_id` =  '2745'
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` =  '2746'
LIMIT 1 
0.0003  

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` =  '2746'
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` =  '2745'
AND `product_categories`.`parent_id` =  1
AND `product_categories__products`.`cat_id` NOT IN (1, 261)  
0.0004  

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

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