Adam S. Flath
  • PhotoBlog
  • Nerd Blog
  • About
  • Contact

Where is the nerd?

11/22/2016

Comments

 
Yes, I have been AFK recently on the blog.  I do have a couple posts queued up, but they nee some more refinement.  In addition, most of my nerd free time has been dedicated to completing my CPE credits to maintain my CPA certification.  The courses I am currently taking are:
  • Break-even Analysis
  • Relevant Costs and Decision Making
  • Linear Programming (Really fun)
  • Transfer Pricing
  • Investment Appraisal Techniques
  • Pricing Strategy
  • Risk and Uncertainty in Decision Making
  • Risk Management (Hey, I need some easy ones too)
I have until 12/31/2016 to finish them up!
Comments

Best Purchases under $100

11/3/2016

Comments

 
One of the fun questions Tim Ferriss asks his guests on his 4 hour work week podcast is What’s one item you’ve purchased in the past six months for under $100 that’s had the biggest positive impact on your life?
Here are mine in no particular order.
1. CardNinja (Card Wallet for Cell Phone): $8. As a NYC commuter, you live and die by the card.  From metro card to credit card, to Corp ID card.  This $8 purchase has made my life SO MUCH easier.  I recommend not putting more than 3 cards in there since the purpose is NOT to replace your wallet, but rather a quick way to get your most frequently used cards out.  Also, I am more likely to forget my metro card than my cell phone, but since the metro card is now WITH the cell phone, I never have to worry about it.

2. SoundPEAT Bluetooth Headphone: $23.   These are the best. Long battery life, super light weight, great sound and fits any ear shape.  If i somehow forget to bring these to my daily workout at the gym... i seriously consider not doing anything since I love my music and these headphones.

3. Gymnastic Bodies: $99+ Specifically I did the Handstand course, but you will see there are many others.  What is great about Chris Sommers (creator) is that he expects you to not just "do" the exercise, but to MASTER IT.  Therefore the workouts are stair stepped from a very beginner level stretch all the way to a 10 minute long hand stand.  It is very cool to understand the underlying muscles and mobility needed to accomplish the final goal of a handstand.  What is even cooler is seeing your progress!  My next workout I will buy is a SPLIT mobility course...I always wanted to be able to do a full split.  

​4. Casio wrist watch: $10 You just can not go wrong with a Casio watch.  I went from a fitbit that died a couple months ago to this watch, and I have to say, I do not miss the fitbit that much. This little sucker tells the correct time, water proof, light weight, durable and cheap.  If I lose it, scratch, decide I want a new color; it is  $10 for a new one. 
Comments

Thank you British Airways for reminding me...

10/14/2016

Comments

 
I am in the hunt for a spring break vacation with the family so I am searching "where in the world" should we go.  I came across the British Airways website and immediate got a chuckle: 
Picture
Now, I can not tell if they are saying that my dollar will go further because BA is offering me such a great deal... or that their home town (my birthplace) is taking a beating on their currency:
Picture
Either way, they are right!  But I think we will pass on the UK, i mean England. We are eyeing Bali, Hawaii or dare I say it... Disney World. 
Comments

How a Pareto convinced me to downgrade my Camera Lens

9/28/2016

Comments

 
In case you have not heard, Panasonic recently announced an awesome upgrade to their great G7 camera; the new G85: 
https://www.dpreview.com/reviews/panasonic-lumix-dmc-g85-first-impressions-review

I knew I wanted this, but that would mean I would have to sell my G7 which came with a 28-280mm lens.  Amazon would buy back this camera kit for a very fair price and I would take those funds to buy the new G85 with the included 24-120 lens.

The problem is that I LOVE the reach of the 280mm and not sure I could replace it with a lens that could only reach 120mm in distance.  At the same a 24mm range for the new lens is a HUGE difference in getting a wider angle shot.  Here are some examples of the different zoom ranges I took this past year: 28, 60, 280:
The big question was: Do I really even use the lens at the zoomed in range?
Let us Find out! In order to do so I went into the past year's worth of photos that are were marked as "5 Stars" meaning these photos would be printed out at the end of the year in my annual photo book. I then copied the metadata of these shots into an excel document.
Picture
The next steps were to figure out what graphic representation can best convince me that I fully utilize my 28-280mm lens to it's full potential.
1. A very straight forward breakout of all of different focal lengths and the # of shots taken at each one. 
Picture
I can obviously see the two most used focal length were the very wide shot @ 28mm and the long shot @280mm.  Overall this is too much information, lets group all the focal lengths into the potential new lens which would be 28-120mm and then the extra length of the current lens which would be 121-280mm.
Picture
Much better.  I can now easily see that 70% of my shots would be satisfied with the new lens.  At the same time, I feel that I still do not have a sense of my shooting habits related to the different focal lengths; and this is where the Pareto comes in to the save the day: 
Picture
This graph really helps me understand the rate of photos I take relative to the maximum focal length I have available.  After the data, I was curious to see which 5 star pictures were shot at the longest 280mm length. I cringed, because the majority of them were all AIRPLANE shot from two airshows I attended. DOH! I mean, the shots are great! But I really should have removed them since they are a subject I could care less about in getting "that shot." (Plus I have another camera system for that kind of work). 

Doing this exercise supplied me with a big surprise in that I fully thought most of my shooting was done at the long focal range.  The data shows that since the majority of my shots were taken at the widest angle of 28mm, it questions how many shots could have been "better" or photos that were missed since I did not have a wider lens like a 24mm lens.

So I sold the G7 and 28-280 lens to amazon, got the cash and now I am just waiting for the new camera and lens to be released!

The Power(BI) of the Accumulative formula

One of the primary formulas that was needed to create all of these graphs was the DAX accumulative formula which I have a separate posting on.  This is one of the most basic formulas, yet by understanding the details, it helps unlock the mystery of the "evaluation contexts."

Comments

22 Immutable Laws Applied to Tidal & Spotify

9/19/2016

Comments

 
I recently attended the Budweiser Made In America Music Festival in Philadelphia, PA and one sponsor really caught my eye: Tidal (The streaming music service). They did a great job promoting their product from interactive tents to having one of the stages named "Tidal".  The thing that tipped me over was that they were recording the entire festival, every stage with what looked like very high end video gear.  We are talking dollies, cranes, perches, zooms in the back... let us just say it looked very expensive.

As a paying Spotify customer I went home and signed up for the free Tidal trial, looked at the concert videos and honestly have not logged back on in almost 2 weeks. WHY!? I really could not see the value let alone the "extras" that would have me leave Spotify.  The concert videos were "eh" and it made me realize that watching "Live Concerts" are HORRIBLE compared to the real thing. And as far as the underlying product I am consuming, both services provide the same thing: music to my ears.

Loving Tidal's advertising at Made in America, trying them out, yet never signing up for their service got me thinking of the book, 22 Immutable Laws of Marketing which is now 22 years old(1994), yet reads like it was published this year. 

I took my own thoughts on the two companies to see how they stacked up against the 22 laws:
Picture
One thing that stuck out was that in my opinionated analysis, Spotify is doing AMAZING, but I will get to one aspect that authors Al Ries and Jack Trout did not anticipate in the crazy no profit billion dollar valuation games.

​As far as Tidal, I think 3 huge laws that they have broken will pretty much explain why they will most likely have to fold in the coming months/years.
  1. The Law of Hype:  Everyone remembers when Tidal first launched.  Famous artist changed their twitter/profile avatar to a turquoise  square and announced a soon to be MUSIC HISTORY game changer will be coming.  Huge parties were thrown around the country to celebrate with some of the top celebs and what came? Another streaming service.
  2. The Law of Success: I love this one.  You had some of the MOST SUCCESSFUL musicians become investors in this new service with Jay Z leading the way.  I mean how can this new service fail with all this talent!  Simple: selling music is different than recording music.  Hubris is a bitch. 
  3. The Law of Duality: In most markets and categories there will eventually be only two very large players in the room.  And it is currently Spotify and Apple who are #1 and #2.  Tidal broke to many other laws to try and crack this duality.
Now, going back to Spotify. Though they are leaps and bounds the #1 Market leader with no signs of slowing down, it still will not matter if they can not make money!  The last law is 22 The Law of Resources: It says that you basically need money to make money to become the marketing leader.  But what if the market you are in was never going to make money.  Where the bigger you became, the bigger the loses? I hope Spotify will turn a profit, because I love listening to my all i can listen music.  
Comments

MTA Chairman / CEO Turnover

8/19/2016

Comments

 
Since 1968 (Official consolidation of New York City transit services) there have been 12 MTA Chairman, which means only average each one served 4.1 years.  Since 2007, the average has been 2 years!
Picture
Poor J. Lhota: 1/9/2012 through 12/31/2012.  He probably was not even able to witness a Purchase Order go through and see it delivered.

Being the CEO at the MTA, is very different than being a CEO for a Public Company. The primary reason is because the MTA Chairman is the position that links all of the operating agencies together (LIRR, MNR, NYCT, MTA Bus, Bridge and Tunnel).  Without the chairman, there can be no consolidation of operations and effecienies.  In 2016, the MTA is finally starting to combine procurement offices; no one needs 5 different people buying pens and pencils from 5 different vendors.  

So when you have that kind of turnover over a 5 year stretch from 2007 through 2012, you have delayed that process of trying to get everyone on the same page.  Thankfully the current CEO, Tom P. has been in the position for over 3 and half years (plus decades running other transit operations) and the NY Governorship will not be changed until 2018 which means Tom should be able hit 6 years in the position and provide much needed continuity to the MTA as well as push long term projects that would not be possible with leaders that last only 1 to 2 years. 
Comments

How to Measure Process Performance between 99.8% and 99.9% (Process Sigma)

8/16/2016

Comments

 
I have seen a couple of examples where industries or departments show a KPI where it always hovers around 99.7% to 99.9%.  Almost all the time the KPI chart will look like this:
Picture
Picture
Sure, you could zoom the chart in even more, but it still would not communicate what the difference between 99.8% and 99.9% is.

 Let us take a closer look at an MTA metric around the percent of required buses and operators available in the AM peak period.(Pictured above) (Note they say "required", not "scheduled")   It is a metric to ensure that the minimum/required amount of service is available.  You have two main factors on why the buses would not be able to go out: No operable bus, or no driver to drive the bus.  From the graph above, we can see that the previous 12 month average is 99.8%... Impressive!
​
Displaying the data this way is great to show the awesome performance, but it does a poor job of calling out how to make the process even better. 

So what is the difference between a process that is 99.8% vs 99.9%?   The classic example is the up time your electricity is on.  In the United States, we expect it operating 99.9% of the time while some countries are grateful they can have it on for a couple hours a day.

Electricity Uptime:
- 99.38%: Equivalent to 60 minutes a week of no electricity (Hope you save your work often!
-99.87%: Equivalent to 13 minutes a week of no electricity (Not bad, but I cant imagine knowing that we would be on backup power 15 mins every week)
- 99.977%: Equivalent to 10 mins a month of no electricity.(This is probably normal, summer storm knocks power out for 2 hours on a mid august day, that is still a 99.977% uptime for the year.
- 99.99966%: Equivalent to less than 2 minutes a year of no electricity.


So we can easily see that there is no way I am accept a 99.4% success rate of electricity transmission, let alone 99.87%.  I want to see MULTIPLE 9's.

ANSWER: USE PROCESS SIGMA of 1 through 6

I will let the pros explain what Process Sigma is:
https://www.dmaictools.com/what-is-six-sigma/sigma-level/

When we look at the Bus metric and see the capability of dispatching the required buses continuously approaches 99+%, we should convert that to a Process Sigma rating of 1 through 6.  Here is the conversion table at a high level:
Picture
Now we can have a much more dynamic looking graph as well as easily see a difference when we are talking about 99.87% (4.5) vs 99.997% (5.5).  
Here is the same Bus Chart converted to Process Sigma numbers:  I also like to tell my audience that if you see a process that is 1.0 sigma values different, then THAT IS A HUGE DIFFERENCE. ​
Picture
****Yes, of course your can keep zooming into the original graph to get the same shape as the Process Sigma, but the shape is not the point, The point is to simplify the true capability of the process and work towards improving towards the next Sigma Level. Seeing something that is 3.7 vs 4.5 is much easier to grasp than something that is 0.0002 different than the other.

To determine your performance, you need to set a goal as to what the process capability should be.  Is 4 Sigma our goal or should we strive for 5 Sigma.  Remember, the difference between the two is so small on an absolute scale (2.7^-5) yet from a large operation you are talking about an extra 6,000 defects per million. 
Data Source:
http://web.mta.info/mta/news/books/
​
Comments

Entrances and Exits for 7 Train

8/10/2016

Comments

 
#7TrainBlues
​Ever wonder where all the exits and entrances are for the 7 train line?  
Here you go: http://web.mta.info/developers/data/nyct/subway/StationEntrances.csv

Just Kidding, I made it easier for everyone:
  • The color represents what kind of entrance.
  • Click on a dot to see what station it belongs to
  • Most, probably all Easements really means stairs.  It is just that the stairs are located inside a building not on the sidewalk.
Comments

Size of MTA

7/21/2016

Comments

 

As a new New Yorker, I find it intriguing how upset some individuals get if the subway is delayed 5 minutes.  Yes, 5 minute delay at Grand Central waiting for the 7 train in afternoon rush hour can look like the end of times with so many people on the platform.  Back in St. Louis rush hour scheduling was one train every 12 mins!  

So let us all take a step back and appreciate how large of a public transit city we are and the scale of how big our MTA transit system is when compared to some other cities and and modes of transit:
​
First we should understand the size of other public transportation entities by focusing on the amount of passengers they carry PER YEAR.
**The following numbers include Rail and Bus passengers
​

Amtrak vs DC Transit

Picture
Even combining those two entities: they are still too small to even make a comparison to the MTA.  Let us add some more Transit Systems throughout the United States (Top 7). 
Picture

Top 7 US Public Transport System

Picture

​We are getting closer now, but we still need more entities to get a good comparison to the MTA.

Top 10 World Wide Airlines

Picture

​Now that we have a better understanding of how big the largest US transit systems are well as the largest world wide airliners, we can now compare them to the MTA.
Picture

The MTA still moves over 25% more passengers than the Largest 10 world wide airlines and Largest 7 US Transit system COMBINED.

Picture

And that does not even include all the cars, buses, trucks that travel through the 7 MTA Bridges and 2 Tunnels!

Picture
Comments

Metrocard cheapest in 43 YEARS!?

2/11/2016

Comments

 

A round trip ticket for New York City residents while factoring in minimum wage increases and access to the new Commuter Benefits program is probably the cheapest it has been in over 4 decades.

Here is the BIG picture below based on the following assumption:
  1. You work full time(8 hours) with minimum wage
  2. You buy a round trip ticket to get the bonus and REUSE YOUR CARD every week
  3. You sign up for the Commuter Benefits Program: (For the sake of your basic financial health, please sign up for this!) 
What the RED LINE in the graph below represents: The % of your DAILY gross pay earning minimum wage that goes towards the purchase of a round trip metro card factoring in the commuter benefits and metro bonuses. The years selected were every year a Metro Card price increase occurred.
here has been some extremely favorable factors that have reduced the TRUE COST of a round trip ticket.
1.       Minimum Wage
Yes, Minimum Wage in New York City has been very well positioned to combat any increase in Metro Card prices.  In the above interactive report; the two graphs on the far right side show the similar increase in both pay and metro car prices. This is showing that inflation/minimum wage is keeping up with the basic cost of public transportation.

2.       MTA Metro Card BONUS
The Bonus was introduced back in 1998 with a 10% bonus when spending $15.00 or more.  You can see from the table below that the MTA has played around with the % bonus as well as the minimum purchase amount to obtain that bonus.  This year the equation changed and is one of the most favorable bonus allocation ever: 11% when you buy a round trip ticket.
Picture
History of MTA Bonus Table
3.       New NYC Transit Tax Deduction
In 2015 NYC requires employers with 20 or more full time employees to offer pre-tax earnings to purchase transit options. (http://cdn2.hubspot.net/hubfs/383308/NYC_Local_Law_53-1-1.pdf) For those of you in the minimum wage bucket: State Tax: 4.5% / Federal Tax: 15% / City Tax: 3.5%
That is an additional 23% savings, and if you are higher up in the tax brackets, we are talking 40% off your metro card.  
*An ironic side affect of the commuter benefit program is that it takes away a small chunk of tax dollars away from New York City and thus allows for less money to be invested in public transportation.  ooppsss
​
References:
Metro Card and bonus Rates: http://web.mta.info/mta/investor/pdf/2015/AppendixASupp51215.pdf
Minimum wage: https://www.labor.ny.gov/stats/minimum_wage.asp
Commuter benefits:
http://cdn2.hubspot.net/hubfs/383308/NYC_Local_Law_53-1-1.pdf
Comments
Forward>>

    Fav Tools

    PowerBI
    cartodb
    ​excel

    Archives

    April 2018
    January 2018
    September 2017
    July 2017
    June 2017
    May 2017
    April 2017
    March 2017
    January 2017
    November 2016
    October 2016
    September 2016
    August 2016
    July 2016
    February 2016

    Categories

    All

    RSS Feed

Proudly powered by Weebly
  • PhotoBlog
  • Nerd Blog
  • About
  • Contact