Tuesday, July 19, 2022

Fremont's most prestigious schools - 30 year history

TLDR

  • MSJHS, Joshua Chadbourne, Mission San Jose Elem, William Hopkins Jnr high have received 5+ California Distinguished school award
  • Hirsch, Weibel, Irvington, Grimmer, Warm Springs elementary, Ardenwood elem, forest park elem, John Gomes elementary have won 3+ California distinguished awards 
  • William Hopkins Junior high has received 3 National Blue Ribbon School awards (only school to get it multiple times)
  • The highest concentration of awards are in the Mission San Jose and Irvington high feeder schools. Their dominance over a 30 year time frame is clearly visible

Goal

The goal of this post is to dig deeper and look at some of Fremont's most storied schools and their 30 year history of receiving California's top school awards. Great schools has reduced schools ratings to a yelp like review. This kind of research and awards from California Department of Education will help parents make more informed decision about the school district before buying a home. 

Overview

We will be covering 3 awards

  • California Distinguished school award
  • National Blue ribbon school award
  • California Gold ribbon school award



Sunday, July 17, 2022

Recession proof Bay Area SFH school districts

Over the last 10 years, zero interest rates and reduced housing supply has led to indiscriminate rise in home prices. However as interest rates rise, some pockets of real estate will hold their prices while others wont. As has been noticeable in the 2008 crash, good school district SFHs retain value through recessions and price drops are minimal. The goal of this post is to illustrate why and also look at what good school district mean. Hang in there as 8+ greatschool rating doesnt mean anything and lot of shitty schools are rated 8 on greatschools based on equity scores. 

Why do good school districts go for premium ? 

  • SFH
    • The regular factors that go behind SFH are still at play
    • Own and independent lot
    • Ability to extend the home in future
  • Inflation
    • Raw material Inflation
      • Homebuilding prices like lumber, copper, raw materials and labor increase with inflation
      • Cost of building a brand new home goes up
    • Tuition inflation
      • Private school tuitions go up with inflation. For example : Challenger tuition fees in 2007-08 were 10k per year. In 2022, Challenger tuition is 23k per year. 
      • At 2022 prices, cost of private school education for a kid is 250k and for 2 kids is 500k. 
      • If you chose to go the public school route, then you pay the 500k into the mortgage which is an investment without compromising on education quality or outcome. More on the quality and outcome later. 
      • As inflation rises, private school tuition will only increase from here and the SFHs with top public schools will be indexed to inflation
      • This is why condos/townhomes in top school districts like Cupertino and Mission San Jose sell higher than SFHs in poor school districts
    • Wage inflation
      • This is applicable to all homes. Home prices rise with wage growth and inflation will lead to wage growth. 
  • Supply constrained
    • SFHs are lesser in supply. SFHs in good school districts are further lesser. 
    • During downturns, this works to the advantage as the restricted supply still ensures there is enough demand
    • During downturns, home values in these neighbourhoods generally go down last and are the first to come back up when the market improves
    • This is what supply constraint looks like irrespective of school district
    • During periods of inflation, prices of anything with limited supply goes up

  • Upgrade demand from surrounding areas
    • During sellers markets, lot of buyers get stuck in homes in poor school districts. Due to bidding wars, they dont get choice. A lot of them also have equity. For eg : somebody in Newark or Washington high school will always try to upgrade to Irvington or American high in Fremont. Somebody stuck in Leigh high/San Jose will try to upgrade to Cupertino/Mission when they realize that some kids in Leigh high also end up in community colleges. 
  • Security
    • Good school districts generally come with families which leads to area with better security
  • Rental demand
    • Homes in good school districts generally attract good strong renters reducing vacancy rate and increasing rental yield
    • During rising rate environment, lot of people get priced out of the market. This leads to increased rising rental demand
  • Stocks vs real estate
    • During stock markets declines people panic sell and buy real estate because housing never goes to zero. Also if you are able to buy and hold the house then you are guaranteed to have that standard of living in the future, while with stocks you can be underwater for the next 10 years
What does good school district look like ?

Before answering that question, 7-8 rating on great school doesnt mean anything and doesnt mean a good school district. Great school ratings factor in equity scores by 40% which a lot of the buyers are not aware of. While whether this is the right methodology or not is a subject of another post, I like to use a different metric to evaluate good school district which is more consistent with home value retention during recessions and the actual value a buyer will derive out of the home. 

I use Berkeley admission rates and compute the 5 year, 10 year and 15 year average. 
Bay area has 13 schools which are in the top 100 US STEM schools. Out of these, Mission San Jose (Fremont), Irvington high(Fremont), Monta Vista(Cupertino) and Lynbrook(Cupertino) send 50 kids per year to Berkeley on Average. SFHs and condos in these schools tend to hold value in buyers markets because of the above reasons mentioned. 

Pleasanton and San Ramon also have amazing schools as linkedin above. But they have another factor which is distance from bay area which adversely affects them in recessions. The price drops are largest the further you move out of bay area. 



Monday, July 11, 2022

Bay area Top 100 US STEM High Schools

TLDR

Dougherty High(San Ramon), Mission San Jose High(Fremont), Irvington High(Fremont), Lynbrook(Cupertino), Monta Vista(Cupertino) send ~50 kids to Berkeley every year on average over the last 5 years and also rank in the Top 100 US STEM High Schools. This makes homes feeding to any of these high schools attractive investment. 

Context

Bay area is a great place with amazing public high schools. Among the top 100 US STEM high schools, 13 are from bay area making the region a centre for amazing education. Cherry on top, some of the best school districts in the bay area boast of multiple high schools in the top 100. Being in california, bay area schools feed directly into UC Berkeley. 

Goal

  • Review bay area high schools in the top 100 US News STEM Rankings
  • Review historical 14 year, 10 year and 5 year admission rates to Berkeley
  • Review school districts with multiple presence at the top
Here is the list of the 13 bay area schools making it into top 13 US STEM Rankings. Also included is the 14, 10, 5 year berkeley admission rates from these schools.

As you can see, some of the well known school districts Cupertino, Fremont, Pleasant contribute multiple entries to this list. Cupertino leads with 4 entries : Cupertino high, Homestead, Lynbrook and Monta Vista. Fremont follows with Mission, Irvington and American high - all well known schools. 

There is a surprise winner if we look at the 5 year average Berkeley admits

We are using averages to remove yearly variance and to get a better measure of consistency. Dougherty valley from San Ramon leads the Berkeley admits race with 76.2 kids being admitted to Berkeley every year. Mission and Monta vista both sent >50 kids per year over the last 5 years and Lynbrook and Irvington came in a close to the 50 mark too. 

Hopefully this post helps readers look deeper than the superficial great schools ratings available on zillow as they pay for their homes. 


Sunday, July 10, 2022

Pitfalls of Poorly Designed PM Roles

In my decade-long journey navigating the realms of FAAMG giants and pre-IPO startups, I've encountered a multitude of Product Managers (PMs) ensnared in a web of stress, dissatisfaction, and an overwhelming urge to seek new horizons due to challenges with their current roles.

But what exactly delineates a great PM job? Let's delve into the intricacies of what constitutes an exemplary PM role and how companies can endeavor to retain their prized PM talent.


1. Dedicated eng team with frontend (app + web engineers)

Being a PM without an eng team is a farce. These roles are highly ambiguous, without no line of direct impact/delivery in sight and no way of attributing success back. Often times there are competing PMs with engineering teams who are actually delivering value. These roles tend to feel more like Program or initiative management. These roles can be high visibility, high accountability roles without much power in the organization to move the needle. Often times, these roles tend to be on the chopping block first and lead to the greatest frustrations.


Yet, these positions are everywhere. These positions tend to have the highest attrition.


PMs need to build and deliver features that impact users. This is impossible without engineers (or “ops” or “tech design” - people who release features). A magical ratio is 7:1 engineers to a PM.


2. Dedicated design analytics, & user research team members

Although lack of design works for certain backend teams, most those PMs end up in the position of needing to ask other teams for support to make impact. They end up in the same position as PMs without dedicated eng.


Similarly, analytics are critical for good prioritization and experiment analysis. PMs who are shipping lots of features don’t have time to write SQL queries and build dashboards.


Finally, working to do user research (UXR) on your own as a PM is time traded off with other activities. Discovery and usability testing are sciences best performed by experts. Also easy to lose credibility even after going the extra mile the experimental feature fails, its easy to say that the hypothesis was incorrectly built because of lack of thorough user research. 


Most PMs need at least half a resource of design, analytics, & user research. PMs doing these jobs trades off with driving execution, developing strategy, and bringing along the company. This causes PMs to either underperform or work long hours - driving attrition.


3. PMing a backend team or ML/AI team

While PMs can be successful in backend and AI teams, but these roles can be very hard to deliver on. Backend and AI teams generally have a lot of technical complexity and have Staff/Senior engineers for technical direction and strategy. Most of big tech companies hire/promote high agency engineers with direction/strategy sense to Staff roles. It becomes very hard for PMs to demonstrate value in those scenarios that engineers cannot bring to the table making the role less essential compared to user facing frontend teams. Backend teams can be user facing too and the users can be other developers. These kind of PM roles are platform PM roles. Generally engineer to PM converts in the team are happier in these roles compared to external PM hires for whom the rampup curve can be steep. 


4. Lack of clear charter and ownership

Often times teams have overlapping charter. For eg : retention can be part of growth and also engagement. Lack of proper org structure is far too common leading to lack of clarity of goals, collaboration nightmares, resourcing prioritization, unpredictability of roadmap, leading to lots of frustration. 


5. PM can be a lonely role

A PM role is all about bringing everyone together : engineering, design, user research, partner teams, etc. Yet the PM role can be lonely as no one role has this full view and at the same time shares all the frustrations described above. 


6. Working for a great line of product leadership

There is no formal training for product management. (The few that exist are not to standard.) Most PMs have to learn on the job.


As a result, leadership matters. Great product leaders teach specifically via feedback, 1:1s, and career sessions. They also teach by example. Decisions aren’t made by gut, but by discovery. Features aren’t graduated just because, but due to metrics.


Bad product leadership, on the other hand, is ubiquitous. It’s not uncommon to find product leaders who haven’t even been individual contributor PMs. They can rarely coach how to execute and influence. They don’t have the context.


7. Empowered to determine your own roadmap and strategy

Product managers who are glorified project managers rarely stay. Yet, this is all too common. PMs are handed roadmap and strategy by execs.


On the other hand, there are few thrills quite like leading an empowered product team. These PMs feel empowered to make an impact and change the world.


8. Collaborate with supportive cross-functional colleagues

Often, it’s an influential sales team blaming the product team. Other times, it’s marketing, partnerships, finance, analytics, design, or legal. Whomever the culprit, once other functions point the finger, PMs leave.


If you are a PM struggling with some of these issues, feel free to drop me a note with your story. Happy to advice. 



Monday, May 23, 2022

Meta Messaging and Commerce Strategy

  • Recently $FB / $META organized a Conference called Conversations 2022 which show cased their progress and strategy on messaging including Kustomer acquisition. 


    Seems like most of Fintweet and US investors are oblivious to it. Heres a thread with the highlights 

     
  • 1/ Zuck : "Businesses want to be where people are. We saw that with Feed, Stories, now Reels and Messaging. Already more than 1Bn users connect with a business account across $META 's messaging services every week. Users use messaging for discovery, checkout, etc"

  • 2/ $META launching whatsapp cloud API. Key features - Any business can customize their experience on whatsapp, speed up response times - Customer to biz conversations grew 50% over last year - $META will provide hosting service, network, compute for free - results from partner

  • 3/ Customer experience and improving touch points - 1800 numbers are 1960s technology - teenagers dont read email - 1-2 hours wait time connecting on phone - 7/10 people prefer to connect businesses via msg - 65% ppl feel more connected to businesses that respond over messaging

  • 4/ Momentum behind this trend of customer business messaging - By 2025, 80% of customer service orgs will abandon native mobile apps in favor of 3rd party msging platforms - Gartner - 50% of US online adults use chat for commerce - Forrester

  • 5/ Takeaway for brands : Brands that have made the switch by embracing messaging as a customer service strategy and are meeting where the customers are have experienced more agent efficiency, customer satisfaction and improvement in marketing and sales.

  • 6/ Example 1 : KLM Royal Dutch airlines : call volumes increased by 500% during COVID-19 peak. KLM reduced wait times for most urgent calls to almost 0 by introducing Messaging based automated responses to simpler queries.

  • 7/ Example 2 : C&A global fashion brand invested in whatsapp integration in brazil : 50% of their digital revenue in Brazil, which last year was 900M Reals came through Whatsapp

  • 8/ Example 3 : Aldi reduced response times for what items are in stock from 3 mins to 3 secs by deploying an AI backed assistant on messenger

  • 9/ Example 5 : Indosat inspired by customer service on whatsapp, introduced prepaid services, refills growing revenue 5x

  • 10/ The sooner you are able to turn down your call centres (cost centres) to profit centres through messaging by enabling you to upsell and cross sell. Messaging is the best way to generate and qualify leads.

  • 11a/ $META portfolio of products to help businesses - WA business app - small business and entrepreneurs. Lightweight business inboxes in messenger / insta - Meta business suite - for larger businesses - omnichannel capabilities to interact cross app wa/msngr/insta

  • 11b/ $META portfolio of products to help businesses - Kustomer - omnichannel - messaging first CRM platform comes with many enterprise integrations. - META is working with 100+ partners that help build customizations on top of the APIs META recently closed this acquisition.

  • 12/ $META launching a startup accelerator with PlugnPlay - a VC firm

  • 13/ "For many businesses whatsapp is their business, its their website, store counter, their livelihood" - Ami Vora, WA VP. Example 6: of an ad on facebook that clicks over to a whatsapp chat. These first party conversions will also be ATT resilient and be first party data


  • 14/ Example 7 : Test feature on whatsapp in Sao Paolo : Businesses can get listed in a directory, right inside whatsapp

  • 15/ Example 8 : catalog feature enabling checkout on whatsapp in India. This is how mom and pop retailers are selling in India now, something which US investors have no idea about. "For many people WA is their first e-commerce experience, it is making commerce more accessible"


  • 16/ Example 9 : $GM found a new way to sell cars through whatsapp when COVID-19 forced them to close stores and sales went from 15k to almost 0 across the country. If $GM closes Whatsapp today, they have to open 25 stores to mitigate the volume. The entire CAC can move to WA.

  • 17/ $META launching Recurring Messenger Notifications to re-engage customers on Messenger. Throughout testing Recurring Notifications vastly outperformed other channels like email and sms driving sales. Most examples from emerging and developing markets.

  • 18/ $META also batted for SMBs : 90% of all businesses and 50% of employment.

  • 19/ $UBER CEO Dara also showed up in the conf. $UBER is now thinking as a messaging first company because the real world is messy, there are lot of stakehodlers : eater, courierer, restaurant, rider, driver and messaging works better fundamentally to give a delightful experience

  • 20/ In India you can call $UBER on WA, its a product WA to Ride. 33% of the riders coming on WA are new riders (for such a well known app like Uber). Huge incrementality working with Whatsapp. Significant younger customer base. Expansion coming to delhi and brazil.

  • Thank you for reading, here is the tweet thread

Wednesday, April 27, 2022

Microsoft Q3, 2022 Earnings analysis

Summary

  • Revenue : 49.4B up 18%
  • Operating income : 20.4B up 19%
  • Net income : 16.7B up 8%
  • EPS : $2.22 up 9%
  • Microsoft Cloud 23.4B up 32%

Segment Breakdown

Productivity and Business Processes (15.8B up 17%)

  • Office commercial products and cloud services up 12% 
    • Office 365 revenue up 17%
  •  Office consumer products and cloud services up 11% 
  • Linkedin revenue up 34%
  • Dynamic products and cloud services up 22% and Dynamics 365 up 35%

Intelligent Cloud (19.1B up 26%)

  • Server products up 29%
  • Azure up 46%

Personal Computing (14.5B up 11%)

  • Windows OEM revenue increased 11%
  • Windows commercial products and cloud services up 14%
  • XBOX content and services revenue increased 4%
  • Search advertising revenue up 23%
  • Surface revenue increased 13%

Subscriptions

  • Microsoft consumers subscribers up 58.4MN
  • Paid office commercial seats grew 16% to 345M
  • Developer SAAS
    • Visual studio has more than 31M active users
    • 90% of fortune 100 use github
  • Azure Cloud
    • Microsoft is the market leader for all SAP applications in the cloud
    • The number of 100M+ azure deals more than doubled YoY
    • Cosmos DB transactions and data volume grew 100% YoY for the third year in a row
    • Synapse data volume more than doubled year over year
    • Azure ML inference requests grew 86% YoY
  • Power platform 
    • 2BN in revenue in the past 12 months up 72% YoY
    • Power BI has more than 200k customers
  • Linkedin 
    • 830M professionals
    • Talent solutions up 43% marking 6 consecutive quarter of accelerating growth
    • 28M subscribers to atleast 1 newsletter, up 51% YoY
  • Teams
    • differentiation : only solution with meetings, chat, video, collaboration and business process automation
    • 1000+ collaboration apps like asana and zendesk
    • Teams is a platform and companies have built custom apps on teams to bring business processes into workflows
    • Viva has more than 10M MAUs
    • Linkedin's glint employee engagement tool also got added to viva
  • Windows
    • More than 100M PCs have shipped in each of the last 8 quarters
    • Windows 11 and windows 365 enabling switch between cloud and local PC
    • 500M MAU of Microsoft personalized content feed - Microsoft start
    • Flywheel : content consumption and commerce, microsoft edge helping people save through commerce deals
  • Security
    • 24 Trillion threat signals each day
    • Azure active directory has 550M MAUs
    • 785k customers for security solutions, grew 50% YoY
    • 15k partners in security ecosystem
  • Gaming
    • XBox cloud gaming - 10M people have streamed games
    • Azure gaming revenue fiscal grew 66% YTD


Books I am reading