For the Love of Data

For the Love of Data
By For the Love of Data
About this podcast
For the Love of Data is a monthly podcast devoted to all things data from industry news, new products, and cool data visualizations. Host Robert Furr and others hold discussions, interviews, reviews, and arguements to determine where the information technology industry is heading, with an emphasis on Business Intelligence (BI), Information Management (IM), and data analytics. Topics like data science, analytics, strategy, and governance are just a few of the topics on the table. SQL, NoSQL, Tableau, R, Oracle, MySQL, SQL Server... these are just a few of many tools we will noodle on during each episode.
In this podcast

Love of Data

Machine generated. There may be errors. Report errors to us.
Latest episodes
Jan. 31, 2018
Background: Google used learned indexes , machine learning models, to access data and compared these to B-Tree, Hash, and Bloom Filter indices Trained a model using multiple stages where the earlier stages could approximate a location and later stages would work with a subset to improve accuracy. Each stage could choose a different model to advance the search further. FYI, the diagram below looks like a decision tree, but it is not. Each stage/model could have different distributions and could repeat the model used above or below. They achieved access time and space savings across the board, even without using GPUs or TPUs (Tensor Processing Units) “Retraining the model” – the tests were performed on a static data set, so no retraining or index maintenance was required. Observations / Questions: Used Tensorflow with Python as the front end — apparently a lot of initial overhead with this as a test stack. B-Tree indexes to some extent are a model, especially if they don’t store every key and instead store the first key in a page. The paper made some rudimentary assumptions, such as using a random hash function. What if the data is not static? How long would it take to retrain the model vs. maintain an index? What if data profiling caused you to index certain attributes and not others? What are the best practices with this newer approach The power of being able to use different models at different stages is intriguing. You could also potentially maintain traditional indexes as a backup / failsafe that would upper bound to the performance of a B-Tree. Load times – The folks from Google commented that they could retrain a simple model on a 200M data set in “just [a] few seconds if implemented in C++” Recursive question: do you need an optimizer to optimize the optimization path? Room for improvement: GPUs/TPUs Incorporating common queries into the model to know what questions people are asking Music Deep Sky Blue by Graphiqs Groove via Sources:
Dec. 30, 2017
This episode reflects on some of the hottest topics from 2017 and their impact their data has on our lives this year and into 2018. Cryptocurrency Many of these data points come from here. Since the year began, the aggregate market cap of all cryptocurrencies combined has increased by more than 3,200% as of Dec. 18 Bitcoin went through the roof, hitting an all-time high of 1 BTC = $19,891 on 12/17/2017. BTC makes up 54% of the aggregate $589 billion market cap of all cryptocurrencies The graphics-card hardware needs of miners has been a big reason why NVIDIA and Advanced Micro Devices have seen a double-digit percentage surge in sales recently Back on Dec. 10, CBOE Global Markets (NASDAQ:CBOE) became the first to introduce bitcoin futures trading, with CME Group (NASDAQ:CME) following a week later 612 new cryptocurrencies began trading in 2017 Top 10 cryptocurrencies in 2017 as of 12/29 according to (pretty similar list on Cryptocurrency Price in USD Price in BTC First Trade Exchange volume 24h BTC Bitcoin $ 15,030.33 +9.79% ($1,340) in 12h +9.56% ($1,312) in 7d 1 BTC +0% in 12 hours +0% in 7 days 2010-07-17 100,317 BTC 100,316.59 BTC 1,250,728,823.58 USD XRP Ripple $ 1.4 +11.79% ($0.15) in 12h +28.92% ($0.31) in 7d 0.000093 BTC +1.82% in 12 hours +17.67% in 7 days 2014-08-14 462,239,606 XRP 36,699.78 BTC 551,610,001.98 USD ETH Ethereum $ 750.82 +9.3% ($63.9) in 12h +12.07% ($80.9) in 7d 0.05 BTC -0.45% in 12 hours +2.29% in 7 days 2014-09-30 784,632 ETH 34,510.75 BTC 518,708,138.27 USD BCH Bitcoin Cash $ 2,571.87 +8.04% ($191) in 12h +6.17% ($149) in 7d 0.171 BTC -1.59% in 12 hours -3.1% in 7 days 2017-08-01 209,597 BCH 33,824.21 BTC 508,389,215 USD LTC Litecoin $ 255.88 +11.54% ($26.5) in 12h +0.89% ($2.26) in 7d 0.017 BTC +1.59% in 12 hours -7.91% in 7 days 2012-07-13 1,156,615 LTC 18,070.26 BTC 271,602,057.82 USD IOT IOTA $ 3.87 +11.04% ($0.38) in 12h +2.12% ($0.08) in 7d 0.00026 BTC +1.14% in 12 hours -6.8% in 7 days 2017-08-30 37,838,946 IOT 9,288.14 BTC 139,603,822.48 USD XMR Monero $ 366.67 +7.1% ($24.3) in 12h +9.42% ($31.6) in 7d 0.024 BTC -2.46% in 12 hours -0.13% in 7 days 2014-06-04 275,568 XMR 6,354.54 BTC 95,510,916.21 USD DASH Dash $ 1,126.09 +10.81% ($110) in 12h +2.5% ($27.5) in 7d 0.075 BTC +0.93% in 12 hours -6.45% in 7 days 2014-02-20 85,797 DASH 6,073.26 BTC 91,283,097.97 USD XVG VERGE $ 0.168 +41.89% ($0.05) in 12h +60.02% ($0.06) in 7d 0.000011 BTC +29.23% in 12 hours +46.05% in 7 days 2016-02-18 606,321,139 XVG 5,940.19 BTC 89,283,020.8 USD ICX ICON $ 5.73 +4.78% ($0.26) in 12h +183.99% ($3.72) in 7d 0.00038 BTC -4.56% in 12 hours +159.21% in 7 days 2017-11-11 13,061,177 ICX 5,072.57 BTC 76,242,347.41 USD Data Breaches Equifax – 9/7/2017 – 143mm US consumers affected Stock plunged nearly $4bn in the aftermath RNC Voter List – nearly every registered voter, ~200mm Americans Yahoo’s 2013 breach revelation – affected accounts went from 1bn to 3bn Uber – 57mm user accounts and drivers, paid to keep it under wraps 560mm Passwords – a massive list of 560mm credentials compiled into one database of breaches from at least 10 services You can check if your account is part of a compromise at have i been pwned or SpyCloud.   World Affairs The World Bank has a fascinating article with 12 charts covering food assistance, climate change, education, nutrition, elections, energy and a tribute to Hans Rosling, who made us see the world in new ways with breathtaking visualizations. Other Data Tidbits Most popular Instagram Post: Beyonce – Most retweeted Twitter Post: Carter’s quest for Wendy’s Chicken Nuggest – Oracle bought API management firm Apiary. Be on the lookout for how that evolves for the tool and for Oracle RPA saw continued growth and implementations. Expect more in 2018. Kubernetes is becoming the de facto standard for container management and was upgraded to Adopt by TechRadar. Expect it to continue to gain steam and start influencing data solutions more in 2018. Music: Auld Lang Syne by Fresh Nelly, from Free Music Archive. Sources:—exponential-automation/a/d-id/1330648?  
Nov. 30, 2017
Zip file of all the sample data, Maestro flows, and Tableau workbook I used to get a first impression: E022_maestro_demo_files. Screenshots Sample Flow from Tableau Field Selection Data Profiling Filters Join Clause Refresh / Run Flow File Output Options Pros: Has the clean, intuitive feel of Tableau. I did my hands-on test with no training or previous exposure Lots of features for a first release – joins, unions, type conversion, calculated fields, data connectors, etc. Easy to click into any part of your flow and see data Ability to edit inline – much like tweaking an Excel pivot table Data profiling is a nice visual cue to begin working with data Ability to sort, filter, rename, add calculated fields anywhere along the way Great for quick and dirty data prep that you know is heading into Tableau for ad-hoc analysis Cons: Ability to sort, filter, rename, add calculated fields anywhere along the way – this can get messy for others to come behind you to maintain or see what is happening Reconciliation issues between reports will now be complicated by similar flows doing slightly different things You have to remove header fields from Excel if you want Maestro to latch onto and display field names from table. By default, it looks at first row and gives generic names if column headings aren’t there (i.e., F1, F2, …) Can only have one flow open at any time Performance seems a tiny bit slow on my example with ~13,000 rows. Curious to see how it will perform against larger data sets, RDBMS, and big data connectors Only outputs to TDE or Hyper formats currently. No ability to save as CSV, XLSX, PDF, or write back to a data store Unable to source data from a TDE or Tableau Workbook No reuse of common transformations or logic across different flows NO community generated content yet – since it is very new, you can’t Google for answers or YouTube videos. Established, mature ETL and data prep tools will continue to have a leg up on this front for a while. Music Deep Sky Blue by Graphiqs Groove Sources:
Oct. 31, 2017
Just in time for Halloween this year, we take a look at the way people will spend their money on Candy and other goods during this spooky time. Spending People in the US are expected to spend $9.1 billion on Halloween this year, according to a study by the National Retail Federation. Several predictions about this year’s Halloween season include: U.S. consumers are projected to drop $82.93 on average, up almost 12 percent from $74.34 last year. More than 171 million consumers are expected take part in Halloween festivities. Adults ages 18-34 are projected to spend on average $42.39, compared with $31.03 for all adults. According to the survey, consumers plan to spend: $3.4 billion on costumes (purchased by 69 percent of Halloween shoppers), $2.7 billion on candy (95 percent), another $2.7 billion on decorations (72 percent) and $410 million on greeting cards (37 percent). Among Halloween celebrants: 71 percent plan to hand out candy, 49 percent will decorate their home or yard, 48 percent will wear costumes, 46 percent will carve a pumpkin, 35 percent will throw or attend a party, 31 percent will take their children trick-or-treating, 23 percent will visit a haunted house and 16 percent will dress pets in costumes. Top Costumes More than 3.7 million children plan to dress as their favorite action character or superhero, 2.9 million as Batman characters and another 2.9 million as their favorite princess while 2.2 million will dress as a cat, dog, monkey or other animal. Proving that Halloween isn’t just for kids, a record number of adults (48 percent) plan to dress in costume this year. More than 5.8 million adults plan to dress like a witch, 3.2 million as their favorite Batman character, 3 million as an animal (cat, dog, cow, etc.), and 2.8 million as a pirate. Pets won’t be left behind when it comes to dressing up for Halloween. Ten percent of pet lovers will dress their animal in a pumpkin costume, while 7 percent will dress their cat or dog as a hot dog and 4 percent as a dog, lion or pirate. Candy released data from 10 years of bulk candy online sales that show favorite candies by state. STATE TOP CANDY POUNDS 2ND PLACE POUNDS 3RD PLACE POUNDS TX Starburst 1952361 Reese’s Cups 1927663 Almond Joy 837525   STATE TOP CANDY POUNDS 2ND PLACE POUNDS 3RD PLACE POUNDS AL Candy Corn 55274 Hershey’s Mini Bars 54369 Tootsie Pops 42533 AK Twix 4678 Blow Pops 4578 Kit Kat 3892 AZ Snickers 904633 Hershey Kisses 817463 Hot Tamales 527843 AR Jolly Ranchers 225990 Butterfinger 215897 Hot Tamales 89027 CA M&M’s 1548990 Salt Water Taffy 1345782 Skittles 1034527 CO Milky Way 5620 Twix 5478 Hershey Kisses 4087 CT Almond Joy 2457 Milky Way 1985 M&M’s 1023 DE Life Savers 20748 Skittles 18072 Candy Corn 10217 FL Skittles 630938 Snickers 587385 Reese’s Cups 224637 GA Swedish Fish 130647 Hershey Kisses 109672 Jolly Ranchers 55049 HI Skittles 267872 Hershey Kisses 264728 Milky Way 139874 ID Candy Corn 85903 Starburst 60826 Reese’s Cups 39847 IL Sour Patch Kids 155782 Kit Kat 151786 Reese’s Cups 95627 IN Hot Tamales 95092 Starburst 78920 Snickers 34589 IA Reese’s Cups 58974 M&M’s 53982 Butterfinger 25782 KS Reese’s Cups 231476 M&M’s 230082 Dubble Bubble Gum 159092 KY Tootsie Pops 67829 3 Musketeers 60273 Reese’s Cups 30865 LA Lemonheads 102833 Reese’s Cups 89738 Jolly Ranchers 45092 ME Sour Patch Kids 58290 M&M’s 45938 Starburst 16782 MD Milky Way 38782 Reese’s Cups 30748 Blow Pops 12093 MA Sour Patch Kids 75638 Butterfinger 73892 Salt Water Taffy 45982 MI Candy Corn 146782 Skittles 135982 Starburst 87740 MN Tootsie Pops 195783 Skittles 194672 Almond Joy 98726 MS 3 Musketeers 109783 Snickers 103993 Butterfinger 57829 MO Milky Way 42739 Dubble Bubble Gum 34751 Butterfinger 24780 MT Dubble Bubble Gum 24675 M&M’s 14673 Twix 13784 NE Sour Patch Kids 106728 Salt Water Taffy 78624 M&M’s 23674 NV Hershey Kisses 322884 Candy Corn 203746 Skittles 167837 NH Snickers 63876 Starburst 62468 Salt Water Taffy 25987 NJ Skittles 159324 Tootsie Pops 157893 M&M’s 110673 NM Candy Corn 83562 Milky Way 65682 Jolly Ranchers 45721 NY Sour Patch Kids 200008 Candy Corn 101292 Reese’s Cups 56776 NC M&Ms 96110 Reese’s Cups 95763 Candy Corn 62308 ND Hot Tamales 65782 Jolly Ranchers 61829 Candy Corn 51827 OH Blow Pops 150324 M&M’s 146782 Starburst 105752 OK Snickers 20938 Dubble Bubble Gum 10283 Butterfinger 8892 OR Reese’s Cups 90826 M&M’s 67626 Tootsie Pops 42774 PA M&M’s 290762 Skittles 281847 Hershey’s Mini Bars 150372 RI Candy Corn 17862 M&M’s 13894 Twix 9003 SC Candy Corn 114783 Skittles 98782 Hot Tamales 41892 SD Starburst 24783 Jolly Ranchers 22983 Candy Corn 7827 TN Tootsie Pops 59837 Salt Water Taffy 34859 Skittles 20938 TX Starburst 1952361 Reese’s Cups 1927663 Almond Joy 837525 UT Jolly Ranchers 475221 Reese’s Cups 29823 Tootsie Pops 198564 VT Milky Way 29837 M&M’s 27811 Skittles 17662 VA Snickers 26783 Hot Tamales 26178 Candy Corn 18726 WA Tootsie Pops 223850 Salt Water Taffy 210981 Hershey Kisses 78662 DC M&M’s 26092 Tootsie Pops 21364 Blow Pops 14763 WV Blow Pops 43776 Hershey’s Mini Bars 23554 Milky Way 18911 WI Starburst 116788 Butterfinger 115982 Jolly Ranchers 42998 WY Reese’s Cups 32889 Salt Water Taffy 26555 Skittles 20812   FiveThirtyEight took a different approach by analyzing data from 269,000 head-to-head matchups between candies. Their findings: Reese’s took 4 of the top 10 spots! They boiled it down into the following elements: Music In This Creepy, Sleepy Backward Town by Squire Tuck via Free Music Archive Sources
Sept. 27, 2017
If you’re in crisis, text 741741 if you’re in the US to talk with a counselor now. In this episode we speak with the people behind Crisis Text Line and Crisis Trends, two services that use data to make a difference for those going through a crisis or looking for someone with whom to talk. Overview Texters contact the hotline by texting the shortcode 741741. Volunteers are logged onto “the platform”, which is on CTL’s internal site, to receive these messages and access counselor tools. Their data is collected in real time and is updated in close to real time: This is the TED talk where the founder introduced her idea for the organization: This is the TED talk 3 years later where the founder shared an update on CTL’s success and shared information about how they use data intelligently on their platform: Key Stats Over 1 million messages transmitted per month 75% of texters are under 25 10% under age 13 65% say they have shared something with Crisis Text Line that they haven’t shared with anyone else Usually at least one active rescue per day Take people based on severity and have the ability to initiate an active rescue (via 911) Words like ibuprofen, aspirin, tylenol are more indicative of active rescue need than the words die, overdose, suicide emoji is 4x more of an indicator Roots of CTL go back to 1906 when Save-A-Life League started via newspaper ads The Samaritans was the first phone suicide hotline and started in November 1953 Founded by Nancy Lublin, who is also the CEO of, in 2011 Introductions – background, how they got their start, how they got involved in CrisisTextLine Staci – volunteer Scotty – Data Scientist History of Crisis Text Line and high-level structure (where they operate, # of locations, # of employees / volunteers) Staci’s experience What was training like? Where do she take sessions and how often? How do she feel after a session? Her experience as a counselor and thoughts on the impact, data, etc. What ways they collect data #s of texters UI platform for counselors Types of data they collect Types of technologies used to collect/manage it – both publicly, behind the scenes, for presentations, etc. What ways they use data site Anonymity, opt-in/opt-out options and how frequent each occur Key stats they feel are most important/surprising/alarming, etc. How has data made an impact to those in need? How has data made an impact to counselors? How has data made an impact to the organization? How has data made an impact to the crisis advocacy sector as a whole? What ways can other people can use their data Do they encourage that visitors explore to find their own insights? Will data be available by zip code at some point? Data Science What tools and techniques do they see being most important in the near term? What do they see as becoming less important in the near term? What is something they could have told their earlier selves that would have made their path to this point easier? Organization Info How someone can get involved What they need most What is in store for the future? New technologies, platforms for contact, etc. How someone can contact them Music Deep Sky Blue by Graphiqs Groove Sources – TED talk about origin
Aug. 20, 2017
Join me as I chat with my colleague and Cognos guru John Frazier about the latest release of Cognos, leading up to the anticipated release of the next version, 11.0.7, near the end of Q3. The latest version of Cognos (11.0.6) debuted on March 21, 2017. You can sign up for a perpetually free trial (like Tableau Online) here. Version 11 was originally released in December 2015 and was mainly a UI redesign on top of Cognos 10 features. Analysis and Query Studios will eventually be deprecated. New Features in 11 vs. 10 New UI – responsive web design on UI, but not on reports Better self-service capabilities and collaboration for teams Upload data files – upload delimited text or Excel files to be stored in a columnar format (Parquet) on the file system (not in memory or in the DB). These are immediately usable in dashboards and don’t require entry into FM. Data modules (intent based modeling based on Watson) similar to FM packages Note: Dashboards only use uploaded files and data modules Available on cloud Mobile and desktop from a single report Active reports as prompts Free cloud trial Admin console is unchanged New Features in 11.0.6 Mapping enhancements Multiple admin boundaries, add’l postal code support Dashboarding enhancements Direct access to OLAP packages (Framework packages accessible since 11.0.5) Widgets using data from the same source are connected by default New grid widget Color gradient by measure Date filters can include blanks Portal enhancements Share/embed through overflow menu Folder customizations can be done directly through the UI more easily (without uploading JSON configs) Create shortcuts and report views Storytelling enhancements New guided journey templates New animations (side fade, slide, scale, zoom, pivot) Better pins (smart named, better search and filter) Timelines – smart names Change scene template while working on your story/dashboard Reporting enhancements Better lineage support for FM packages Business glossary (w/IBM InfoSphere Information Governance Catalog integration) Better freeze list column heading control Better query support when editing data modules Report templates – can save for your team or save as style reference reports Support for Planning Analytics Dashboard support for TM1 / Planning cubes REST connectivity to planning analytics Support for attribute hierarchies Support for localized Planning Analytics cubes Data server enhancements Support for Google BigQuery and Google Cloud SQL via the BigQuery JDBC and MySQL JDBC drivers, respectively. JDBC URL for Data Server Connections Test connection feedback (this is not just in admin console now) John’s Likes/Dislikes with v11: For those who are “used” to ReportStudio there is a pretty “steep” learning curve to locate where particular tools or components have been moved. To be fair, ReportStudio had some counter-intuitive placements for some of these same tools (e.g. Hierarchy of design elements, etc.) that caused major headaches for new report designers. Overall the new interface is more “intuitive” and the novice report developers I’ve worked with have picked it up remarkably quickly. There are some changes that are really “nice” – like being able to see which Lists/Graphs use a particular query right from the query tree without having to “search” for where it is used on the “right click” menu. Music Deep Sky Blue by Graphiqs Groove Sources
July 30, 2017
What if you could store your data in the cloud, encrypted, for a fraction of the cost of Amazon S3, Google, or Azure? With Sia, a decentralized file storage solution that leverages blockchain, you can. Learn more about how it works in this episode. Blockchain Overview A blockchain is a permissionless distributed database that maintains a continuously growing list of transactional data records. The system’s design means it is hardened against tampering and revision, even by operators of the nodes that store data. The initial and most widely known application of the block chain technology is the public ledger of transactions for bitcoin, but its structure has been found to be highly effective for other financial vehicles. [Illustration by Matthäus Wander (Wikimedia)] Timestamp: The time when the block was found. Reference to Parent (Prev_Hash): This is a hash of the previous block header which ties each block to its parent, and therefore by induction to all previous blocks. This chain of references is the eponymic concept for the blockchain. Merkle Root (Tx_Root): The Merkle Root is a reduced representation of the set of transactions that is confirmed with this block. The transactions themselves are provided independently forming the body of the block. There must be at least one transaction: The Coinbase. The Coinbase is a special transaction that may create new bitcoins and collects the transactions fees. Other transactions are optional. Target: The target corresponds to the difficulty of finding a new block. It is updated every 2016 blocks when the difficulty reset occurs. The block’s own hash: All of the above header items (i.e. all except the transaction data) get hashed into the block hash, which for one is proof that the other parts of the header have not been changed, and then is used as a reference by the succeeding block. Sia Overview Decentralized network that places encrypted pieces of your data on dozens of notes Aims to be fastest, cheapest, most secure storage solution and compete with AWS, GCP, Azure Users pay in Siacoins, a cryptocurrency like Bitcoin Must go USD -> Bitcoin -> Siacoin -> Wallet -> File Upload Open source Started by David Vorick and Luke Champine through a VC backed Boston-based company called Nebulous Inc Origins in the HackMIT 2013 conference Uses ASICs (application specific integrated circuits) for mining These are purpose built integrated circuits, not general multi-use devices Evolution from CPU -> GPU – ASIC Faster and less vulnerable to attacks than GPUs Why? See here. Created a company to make ASICs called obelisk. ~$2,500 per machine Current price is about 124 Siacoin to $1USD Pros Decentralized, peer-to-peer Encrypted and immutable Hosts can earn money by renting free disk space to renters Must maintain 95% uptime to preserve collateral Possible Issues Renters uploading illegal content to hosts However, renters would have to pay for the bandwidth leechers use to download files Slow at this point Low number of users Music Deep Sky Blue by Graphiqs Groove Sources: Website: Wiki: Github: Slack: Forum: Sia vs. USD: How to get started: Conversion:
June 29, 2017
In this episode we cover the new features in Tableau 10.3. This version debuted on May 31st, and a 10.3.1 update was released on 6/21/17. Data Driven Alerts Only on Tableau Server Receive an alert when a mark crosses a visual threshold Can use on any viz with a continuous numeric axis Can sign up yourself and others; then each person can self-administer Default check rate is 60 minutes or when an extract is refreshed. Can customize with this command: tabadmin set dataAlerts.checkIntervalInMinutes tabadmin restart Tableau Bridge – Limited Release Connect to live, on-premise data from Tableau Online Replaces the sync client – is basically the sync client + live query functionality. Client is installed and ran behind your firewall and pushes data to Tableau Online. Live connections must be enabled by administrators. Limited to RDBMSs (MySQL, SQL Server, etc.) Oracle cloud hosted DBs must use Tableau Bridge Must run as a service to enable live connections Must embed credentials in Tableau Bridge if you want it to automatically update on a schedule Will restart every hour minimum. You can set this window with this command: tabonlinesyncclientcmd.exe SetDataSyncRestartInterval –restartInterval=<value in seconds> Best Practices ( Split bridges into two machines: one for extract refreshes and another for live queries, unless usage is extremely low Run the bridge continuously (ideally on a VM in a data center) Tune dashboards and queries to leverage extracts for summarized data Smart Table and Join Recommendations – Machine Learning will recommend tables and joins (even on non-similar names) based on previous usage metrics PDF Connector Connect to PDFs, identify tables, and pull data out Less copying/pasting/massaging of data to get it ready for Tableau Somewhat limited at this time, but continuing to be developed More Union support in more connectors DB2 Hadoop Teradata Netezza New connectors Amazon Athena MongoDB BI OneDrive ServiceNow Dropbox JSON – scan entire file, not just a sample Automatic Query Caching – Tableau server can pre-cache queries in recent workbooks after an extract refresh to speed up performance on initial load. Miscellaneous More options in Web Authoring (drills, formats, changing displays) Story points navigator – more streamlined Mobile – Android improvements, banner to Tableau Mobile, universal linking that allows you to click and open in Tableau Mobile Tooltip selections – highlight data from tooltip links Latest date filter Distribute evenly Maps – French, Netherlands, Australian, and New Zealand updates Apply table calc filters to totals Custom subscriptions – days/hours, etc. APIs – various REST updates (tags on sources and views, switch sites, get sites list, etc.) Music is Deep Sky Blue by Graphiqs Groove Sources
May 31, 2017
In this episode, data sheds some (sun)light on what Rob did wrong on a recent trip to the Caribbean and explains the terrible sunburn he has right now. Just in time for Memorial Day and Summer, we take a look at many recent findings and how they will lead us to a healthier outdoor lifestyle. A LOT of this content came from the Environmental Working Group (EWG). Please visit their site for more great info and the source of much of this episode. EWG recently released it’s 2017 EWG Sunscreen Guide with research and guidance on sunscreen efficacy, ingredients, and health risks. It is chock full of great information to keep you safe and dispels many misconceptions that most people hold. Why are sun rays harmful? UV radiation penetrates the skin and produces genetic mutations that can cause cancer UVA Less intense than UVB, but 30-50x more prevalent Dominant tanning ray UVA rays penetrate deeper, suppress the immune system, cause harmful free radicals to form, and are associated with higher risk of melanoma UVB UVB rays are the primary cause of sunburns and non-melanoma skin cancer. Most intense from 10AM-4PM April through October Most reflected by snow or ice The chemicals in sunscreen help combat UVB rays more than UVA Why the Sun (UV Exposure) is Harmful3 New melanoma cases among American adults has tripled since the 1970s, from 7.9 per 100,000 people in 1975 to 25.2 per 100,000 in 2014 (NCI 2017) Melanoma death rate for white American men, the highest risk group, has escalated sharply, from 2.6 deaths per 100,000 in 1975 to 4.4 in 2014 Since 2003, the rates of new melanoma cases among both men and women have been climbing by 1.7 and 1.4 percent per year, respectively, according to the federal Centers for Disease Control and Prevention (CDC 2016) More than 3 million Americans develop skin cancer each year (ACS 2017) Most cases involve one of two disfiguring but rarely fatal forms of skin cancer – basal and squamous cell carcinomas. Studies suggest that basal and squamous cell cancers are strongly related to UV exposure over years. Several researchers have found that regular sunscreen use lowers the risk of squamous cell carcinoma (Gordon 2009, van der Pols 2006) and diminishes the incidence of actinic keratosis – sun-induced skin changes that may advance to squamous cell carcinoma (Naylor 1995, Thompson 1993) Researchers have not found strong evidence that sunscreen use prevents basal cell carcinoma (Green 1999, Pandeya 2005, van der Pols 2006, Hunter 1990, Rosenstein 1999, Rubin 2005). Both UVA and UVB rays can cause melanoma, as evidenced by laboratory studies on people with extreme sun exposures. In the general population, there is a strong correlation between melanoma risk and a person’s number of sunburns, particularly those during childhood (Dennis 2010). The use of artificial tanning beds dramatically increases melanoma risk (Coleho 2010). People who rely on sunscreens tend to burn, and sunburns are linked to cancer. When people use sunscreen properly to prevent sunburn, they often extend their time in the sun. They may prevent burns, but they end up with more cumulative exposure to UVA rays, which inflict subtler damage (Autier 2009, Lautenschlager 2007). However, research isn’t conclusive how the link between UV exposure and sunscreen. Scientists don’t know conclusively whether sunscreen can help prevent melanoma. There are studies on both sides that say it helps or it does not. Several factors suggest that regular sun exposure may not be as harmful as intermittent and high-intensity sunlight. Paradoxically, outdoor workers report lower rates of melanoma than indoor workers (Radespiel-Troger 2009). Melanoma rates are higher among people who live in northern American cities with less year-round UV intensity than among residents of sunnier cities (Planta 2011). Researchers speculate that higher vitamin D levels for people with regular sun exposure may play a role in reduced melanoma risk (Godar 2011, Newton-Bishop 2011, Field 2011). So DRINK MILK! The consensus among researchers is that the most important step people can take to reduce their melanoma risk is to avoid sunburn but not all sun exposure (Planta 2011). What is SPF? SPF = Sun Protection Factor How much longer it will take for sun to redden skin than without it (i.e., SPF 15 = 15x longer for the sun to redden you. IBISWorld, a market research company, reports that sunscreen product sales grew 2.6 percent a year between 2011 and 2016, and generated $394 million annually (IBISWorld 2016)3 Effects by Age Baby skin is thinner and absorbs more water Infant and toddler skin has less melanin, which protects from UV light The older you are the thicker and more pigmented you get, which is more protective Very few studies are done on the effects on small children Adults older than 60 are also more sensitive to sunlight Tanning beds are BAD! Emit up to 12x the UVA of the sun People who use tanning beds are 1.5-2.5x more likely to get cancer. The risk of melanoma goes up when you use a tanning bed at any age, but the  International Agency for Research on Cancer calculates that if you start using tanning beds before age 30, your risk of developing melanoma jumps by 75 percent3. Vitamin A is a bad ingredient Vitamin A in the form of retinyl palmitate can harm skin when combined with sunlight. Luckily its usage has been falling. Sprays are convenient, but not the best option Inhaling the chemicals in the spray can be bad, most people apply too light of a coat, and people miss spots. Despite this their use is on the rise, increasing 27%. High SPFs are deceiving2 Correctly applied SPF 50 blocks 98% of UVB rays; SPF 100 blocks 99% The higher the SPF, the more UVB it blocks, but the less UVA it blocks The way sunscreens are measured may not reflect real world conditions In lab measurements, small changes in light can change an SPF 100 sunscreens rating to SPF 37 People spend more time in the sun when they wear a higher SPF Higher doses of ingredients may be harmful when absorbed into the skin If you don’t apply enough, or misapply, an SPF 100 sunscreen’s actual rating could be as low as SPF 3.2. T-Shirts are SPF 5. Most countries cap advertisements at 50+ (Europe, Japan, Canada, etc.); Australia caps at 30 European Sunscreens > American Sunscreens? Several European companies have developed chemicals that are better at blocking UVA, but these have not yet been approved by the FDA. Europe also requires that the advertised SPF (which is its UVB rating) be no more than 3x the UVA rating. Tips to Stay Safe in the Sun Know how intense the sun is Check a site like Know your ingredients and pick the right SPF Know what protects you best. Check if a sunscreen’s claims are accurate, and check how harmful the ingredients may be at FDA-Approved Sunscreens Side Effects Active Ingredient/UV Filter Name Range Covered UVA1: 340-400 nm UVA2: 320-340 nm UVB: 290-320 nm Chemical Absorbers: Aminobenzoic acid (PABA) UVB Avobenzone UVA1 Relatively high skin allergen Cinoxate UVB Dioxybenzone UVB, UVA2 Ecamsule (Mexoryl SX) UVA2 Ensulizole (Phenylbenzimiazole Sulfonic Acid) UVB Homosalate UVB Slight skin penetration; disrupts some hormones Meradimate (Menthyl Anthranilate) UVA2 Octocrylene UVB Relatively high allergen Octinoxate (Octyl Methoxycinnamate) UVB Slight skin penetration; acts like hormone in body; moderate allergen Octisalate ( Octyl Salicylate) UVB Oxybenzone UVB, UVA2 Penetrates skin significantly; acts like estrogen in the body; relatively high allergen Padimate O UVB Sulisobenzone UVB, UVA2 Trolamine Salicylate UVB Physical Filters: Titanium Dioxide UVB, UVA2 Inhalation concerns Zinc Oxide UVB,UVA2, UVA1 Inhalation concerns Table From Follow these tips Seek the shade, especially between 10 AM and 4 PM. Do not burn. Avoid tanning and UV tanning booths. Cover up with clothing, including a broad-brimmed hat and UV-blocking sunglasses. Use a broad spectrum (UVA/UVB) sunscreen with an SPF of 15 or higher every day. For extended outdoor activity, use a water-resistant, broad spectrum (UVA/UVB) sunscreen with an SPF of 30 or higher. Apply 1 ounce (2 tablespoons) of sunscreen to your entire body 30 minutes before going outside. Reapply every two hours, or immediately after swimming or excessive sweating. Keep newborns out of the sun. Sunscreens should be used on babies over the age of six months. Examine your skin head-to-toe every month. See your physician every year for a professional skin exam. Don’t forget to sunscreen your lips Most tips From At a glance, do these things: Other places to protect yourself Car windows block a lot of UVB, but not UVA Two studies found significantly more melanoma on the left side of the body/face, suggesting long exposure in cars puts you at more risk Car windshields block a lot of UVB and UVA because of the plastic in the middle (around SPF 50); side windows do not do so well (around SPF 16) Transparent window films block out almost 100% of both UVA and UVB Skip the sunroof and convertible Check office windows and skylights to see if they are glass or plastic and if they are treated with a UV film Tips if you get a Sunburn17 Take frequent cool baths or showers to help relieve the pain. As soon as you get out of the bathtub or shower, gently pat yourself dry, but leave a little water on your skin. Then, apply a moisturizer to help trap the water in your skin. This can help ease the dryness. Use a moisturizer that contains aloe vera or soy to help soothe sunburned skin. If a particular area feels especially uncomfortable, you may want to apply a hydrocortisone cream that you can buy without a prescription. Do not treat sunburn with “-caine” products (such as benzocaine), as these may irritate the skin or cause an allergic reaction. Consider taking aspirin or ibuprofen to help reduce any swelling, redness and discomfort. Drink extra water. A sunburn draws fluid to the skin’s surface and away from the rest of the body. Drinking extra water when you are sunburned helps prevent dehydration. If your skin blisters, allow the blisters to heal. Blistering skin means you have a second-degree sunburn. You should not pop the blisters, as blisters form to help your skin heal and protect you from infection. Take extra care to protect sunburned skin while it heals. Wear clothing that covers your skin when outdoors. Tightly-woven fabrics work best. When you hold the fabric up to a bright light, you shouldn’t see any light coming through. Tips from Music “Wear Sunscreen Commencement Speech” by Mike Harper, KNVE Sources
April 30, 2017
Join me and my special guest, Colby “meat whore” Pritchett (@colbypritchett) on this BBQ showdown where we pit the Big Green Egg against the Green Mountain Grill Pellet Smoker. We also cover the history, styles, stats, and health facets of different types of BBQ.  History Bbq evolves from the spanish word ‘barbacoa’, but where the word actually originated is still debated. BBQ dates back to the colonial era. George Washington even attended bbq’s Woods commonly selected for their flavor include mesquite, hickory, maple, guava, kiawe, cherry, pecan, apple and oak. Woods to avoid include conifers. These contain resins and tars, which impart undesirable resinous and chemical flavors. The most popular foods for cooking on the grill are, in order: burgers (85 percent), steak (80 percent), hot dogs (79 percent) and chicken (73 percent). MAY is national BBQ month Only 10% of grill owners have a backyard kitchen, equipped with premium furniture and lighting? The longest barbecue measured 8,000 m (20,246 ft) and was created by the people of Bayambang, (Philippines), in Bayambang, Pangasinan, Philippines on 4 April 2014. The record attempt took place during the Malangsi Fish-tival in order to celebrate the 400th anniversary of the city Bayambang. The barbecue was made up of 8,000 grills connected to each other, each measuring 1m in length, 58 cm in height and 21 cm in width. 50,000 kg of fish, 2,000 kg of salt, 480 blocks of ice and 6,000 bags of charcoal were used. 8,000 people were involved.  Styles There are different regional barbecue styles all across the country. Although they all cook their meat low and slow, that’s where the similarities stop. Some cook pig, some smoke different cuts of beef, some lamb, and some chicken. Sauces are also varied: some are vinegar and pepper-based; others utilize brown sugar and molasses; in some, mustard is the predominant flavor; and tomato is the primary flavor in others. While there are plenty of nuances and micro-regional styles, there are four styles that anyone who claims to be a barbecue lover should know about. In North Carolina, barbecue revolves around the pig: the “whole hog” in the east and the shoulder in the west. The pork is chopped up and usually mixed with a vinegar-based sauce that’s heavy on the spices and contains only a small amount of tomato sauce, if any. In Memphis, it’s all about the ribs. Wet ribs are slathered with barbecue sauce before and after cooking, and dry ribs are seasoned with a dry rub. You’ll also find lots of barbecue sandwiches in Memphis: chopped pork on a bun topped with barbecue sauce, pickles, and coleslaw. Kansas City barbecue uses a wide variety of meat (but especially beef) and here it’s all about the sauce, which is thick and sweet. Kansas City is a barbecue melting pot, so expect to find plenty of ribs, brisket, chicken, and pulled pork there, all served with plenty of sauce. Brisket burnt ends are also a specialty here. And there are a few different styles native to Texas, but the most famous variety is the Central Texas Hill Country “meat market” style: heavy on the beef brisket, which has been given a black pepper-heavy rub. Sauce and side dishes usually play second fiddle, because in Texas it’s all about the meat, be it ginormous beef ribs, pork ribs, chicken, brisket, or sausage. –   Brisket Cuts USDA Utility, Cutter, Canner Beef. These are the lowest grades of beef and used primarily by processors for soups, canned chili, sloppy Joe’s, etc. You will not likely see them in a grocery. USDA Standard or Commercial Beef. Practically devoid of marbling. If it does not have a grade on the label it is probably standard or commercial. These grades are fine for stewed or ground meat, but they are a bad choice for the grill. About 2% fat. USDA Select Beef. Slight marbling. If you know what you are doing you can make this stuff tender. Otherwise, get a higher grade. About 2 to 4% fat. USDA Choice Beef. Noticeable marbling, but not a lot. This is a good option for backyard cooks. About half of all beef is marked USDA Choice. There are actually three numbered sublevels of USDA Choice. Certified Angus Beef (CAB) is limited to only the top two levels. Reliable sources tell me that Walmart “Choice Premium” is USDA Choice. The word “premium” is all about marketing and not to be confused with USDA Prime. 4-10% fat. A 12 ounce ribeye typically sell for about $8 to 10 retail at the time of this writing in 2010, and prices fluctuate depending on supply and demand as well as weather which impacts the cost of feed. USDA Prime Beef. Significant “starry night” marbling. Often from younger cattle. Prime is definitely better tasting and more tender than Choice. Only about 3% of the beef is prime and it is usually reserved for the restaurant trade. About 10 to 13% fat, about $20-30 for a 12 ounce ribeye at retail. A dry aged steak can be15-18% fat and $30-35 or more for a 12 ounce ribeye. Black Angus. Black Angus cattle are considered by many to be an especially flavorful breed. Alas, it is almost impossible to know if what you are buying really is Angus. Certified Angus Beef. The Certified Angus Beef (CAB) brand is a trademarked brand designed to market quality beef. To wear the CAB logo, the carcass is supposed to pass 10 quality control standards and CAB must be either USDA Prime or one of the two upper sublevels of USDA Choice. Most of it is USDA Choice. CAB costs a bit more because the American Angus Association charges a fee to “certify” the cattle and higher markups take place on down the line. Interestingly, CAB does not actually certify that the beef labeled Certified Angus Beef is from the highly regarded Angus breed. Their major control is that the cattle must have a black hide, which is a genetic indicator that there are Angus genes in the cattle, but not a guarantee. Wagyu Beef. Wagyu cattle have Japanese blood lines and are now raised in the US and other countries. Their genetic heritage can be any of a number of Japanese cattle breeds. American Wagyu does not have to adhere to the standards as Kobe beef (below), and many of the Wagyu are cross bred with local breeds to make them better adapted to the local climates and diseases. Wagyu and Angus crosses are frequent, and they make mighty fine meat. Wagyu is usually extremely marbled, usually 4 to 10 BMS, more than USDA Prime, but not as much as Kobe, and the flavor and texture is distinctive. It is also about twice the price of USDA Prime. One can only wonder how long before the cross breeding and lack of enforceable standards dilute the quality. Nutrition Facts Brisket Sales Beef Brisket unit sales (in millions of pounds) 2014 Brisket Sales by Holiday in US (millions of pounds) 538 – Where’s the Beef US Cattle Herds are shrinking (97mm in ’07 –> 88.5mm in ’14) Fertilizer, fuel, and feed rose Droughts hit Prices are rising  2016 Sales by Restaurant Pecan Lodge Ten 50 BBQ Franklin’s Austin Brisket 6,700 2,100 10,662 Sausage 1,525 2,000 1,200 Ribs 1,823 Mac & Cheese 4,000 Potato Salad 75 Beans 1,600 600 Peach Cobbler 340 Sides 600 Torpedos 6,500 Rolls/Bread 4,200 4,000 Notes Brisket is their single largest expense – more than rent, electricity, etc. Dickey’s – uses BigData and near real-time analytics of store data (synced every 20 min.) to analyze sales trends, inventory, etc. If ribs aren’t selling well, they can send a text message coupon out to affect sales Tools: iOLAP vendor, implemented Yellowfin BI and Syncsort DMX ETL on Amazon Redshift Other Stats  75% of U.S. adults own a grill or smoker. The majority of grill owners (63%) use their grill or smoker year-round and 43% cook at least once a month through winter. Nearly a third of current owners plan to grill with greater frequency this year. Barbecuing isn’t just an evening activity: 11% of grill owners prepared breakfast in the past year. The five most popular days to barbecue, in order are: July Fourth; Labor Day & Memorial Day (tied); Father’s Day; Mother’s Day. The top three reasons for cooking outdoors, in order are: to improve flavor; for personal enjoyment; for entertaining family and friends. Gas grills are easily the most popular style, the choice of 62% of households that own a grill. Pellet Grills Traeger patent granted in 1986 and expired in 2006 Continuous fuel source like gas; indirect heating like a traditional smoker, so no flame ups, precise temperature control For people who approach cooking as a science rather than an art (but there’s still art to it) Induction fan makes grill like a convection oven Hopper -> Auger -> firebox -> induction fan Pro Tips: MAKE SURE YOU DON’T RUN OUT OF FUEL Have your vent open almost all the way Turn off in proper way to prevent clogs and lock-ups Taking it apart to clean it is fraught with peril It may still have hot spots like any other grill or oven Use food grade pellets, not cheap ones for heaters (these can be scrap wood, shredded pallets, etc.) Wifi sounds cool and is, but sometimes it is temperamental and easier just to use w/o it, particularly if in a hurry Use your own remote thermometers to watch different parts of grill and multiple pieces of meat at once I still use a gas grill to do direct heat or searing Can use a thermal blanket to insulate during winter or in cold locations – will use less pellets when you do this Get the smallest grill you can stand. The bigger the grill the more pellets required to cook, so you may just be paying to heat air What to look for: Variable temperature setting (not three positions) Hopper capacity Meat probes Shelves and hooks Wifi / smart phone connectivity – verify whether it is only on local Wi-fi or internet capable Larger temperature range offers more options for cold smoking, steaks, etc. Some have options for pizza stones, sear plates, etc. Cool infographic about pellet grills – Infographic from Grilling with Rich   Big Green Egg The design is based on ancient clay cooking vessels up to 3,000 years old. Kamado style clay pot grills with removable lids originated in Japan. Kamado means “cooking range” or “stove” in Japanese. Very fuel efficient as they hold heat extremely well regardless of the weather. The fact that is holds heat and traps in moisture causes  the meat to stay juicy and not dry out. US Air Force servicemen started bringing Kamado style grills back to the US after World War II. In the 1960s people started manufacturing them in the US. Ed Fisher discovered these grills overseas and returned to the US to start the Big Green Egg company in 1974. Health Tips Grilling Danger #1: Char While char marks in grilled meat look appealing and give a tasty flavor, the char is laden with cancer-causing compounds called heterocyclic amines (HCAs) that form when meat and high heat are combined to create a blackened crust. The more char that’s created, the more carcinogens result that coat your food. High levels of HCAs can cause cancer in laboratory animals exposed to them, and epidemiological studies show that eating charred meats may be associated with an increased risk of colorectal, pancreatic and prostate cancer. Grilling Danger #2: Smoke Barbecue smoke contains polycyclic aromatic hydrocarbons (PAHs), toxic chemicals that can damage your lungs. As meat cooks, drippings of fat hit the coals and create PAHs, which waft into the air. If you are a grill chef who loves to stand over the barbeque, you are inhaling these toxins. The smoky smell on your clothes and in your hair is also coating the inside of your lungs. The more your grill smokes, the more PAH is generated. The toxins are absorbed along with that delicious smoky flavor right into your food. Grilling Danger #3: Harmful byproducts When food is cooked at very high temperatures, a chemical chain reaction can occur that creates inflammatory products called advanced glycation end products (AGEs) that are harmful to your cells and associated with cellular stress and aging. As suggested by the name ‘end product,’ your body cannot digest them or get rid of them easily. Over time, AGEs accumulate in your organs and cause damage. Where do you find AGEs in the barbeque? In the char. How to avoid the dangers Use marinades and rubs – Coating the meat in herbs with a rub containing rosemary, thyme, pepper or smothering with thick marinades not only adds delicious flavor but can also help reduce the creation of carcinogens by grilling by up to 96%. A tasty marinade also reduces dripping fat and smoke and helps prevent char, thereby lowering the amount of all 3 threats – HCAs, PAH, and AGEs – in your food. Take home message: Boosting flavor can reduce risk. Pre-cook your meat – As easy way to decrease toxins created by the barbecuing is to pre-cook your meat halfway over low heat in a skillet or the oven before putting them on the grill. Precooking removes some of the fat that can drip and smoke, and it greatly reduces the amount of time your meat sits on the grill being exposed to toxins. Less time at high heat also means fewer AGEs are created in your meat. Extra bonus: with precooking, you can barbeque the food much faster to feed the hungry troops. Marinate the food in alcohol before barbecuing it. According to research published by the Journal of Agricultural and Food Chemistry, soaking meat in a marinade of beer – especially stout or black beer – reduces the creation of PAHs (cancer-causing ­carcinogens) when it’s grilled by around 50% Reduce drippings – Using a simple piece of aluminum foil as a protective barrier under the meat helps prevent drippings from smoking, thereby reducing the amount of PAH blowing into your food and your lungs. Keeping drippings in the foil can also help to keep your food moist. Another great way to reduce drippings is to choose leaner cuts of meat and trim off any excess fat before you put them on the grill. Grill veggies – Grilled vegetables do not contain the HCA carcinogens even when charred. Vegetable kabobs made with peppers, cherry tomatoes and red onions are great on the grill, and offer many healthy nutrients and cancer fighting substances you can’t get from a steak or chicken breast.   Music: Good BBQ by the Riptones via   Sources: