More Productivity “At A Glance” with Sentieo’s Redesigned Dashboard

Sentieo’s customizable Dashboards got streamlined and sped-up in the v4.0 release this week. This very flexible part of the product lets you do many things “at a glance”: monitor your team’s research activities, follow industry-specific docs and saved searches, watch financial metrics (prices, performance, reported and estimated financials, alt data, and more), visualize data, and more. Best of all, you can save multiple Dashboard formats if you wear multiple hats, or if you follow very different industries. 

In this videos-heavy blog post, we will cover several of these use cases. In the last video, we will go over the building of a dashboard from scratch. 

Sentieo’s Dashboard is based on customizable widgets that pull and visualize data and documents from across the platform. The extensive collection of widgets include price monitor (“all” things financial, similar to the fields in our Screener), documents (filings, transcripts, broker research, and more), internal notes and theses, charts through our data viz tool Plotter, valuation tables, and more. These widgets display either information either for a single ticker, or for watchlists. Confusing? Watch the short videos below, and it will all make sense. 

Using Dashboard for Documents and Notes

If you are using Sentieo primarily for Documents and News we recommend using the following widgets:

  • All Documents
  • Research Reports (if you have broker entitlements)
  • Saved Search
  • LexisNexis Articles
  • Notes
  • Document Highlights

Using Dashboard for Research Management and Collaboration

If you are using Sentieo primarily for research management, note taking, and collaboration, we recommend using the following widgets:

  • Price Monitor with Thesis Fields
  • All Documents
  • Notes
  • Company Thesis
  • Recent Activity
  • Document Highlights

 

Using Dashboard as a Customized Financial Data Terminal

If you are using Sentieo primarily as a financial data terminal we recommend using the following widgets:

  • Price Monitor
  • All Documents
  • LexisNexis Articles
  • Tweets
  • Stock Price Graph
  • Intraday Price Graph
  • Plotter Templates
    • Use “Plotter” for any static charts that you build (e.g. Macro or Market Performance)
    • Use “Plotter Templates” for any charts you charts that you want to instantly replicate for different tickers
      • Try this with the Sentieo Templates or simply create your own
      • Select from some of our pre-built plotter templates. Add Widget -> Graphs -> P/E Relative to SPX for example

 

Building Your Dashboard (step-by-step)

In this final video, we go over how to build a dashboard from scratch. We discuss, add and customize several different types of widgets, geared towards a retail company watchlist. 

 

If you like what you are seeing, please get in touch

14 Stock Picks for H1 2020

Today, we’re excited to bring you our H1 2020 stock picks. This has become a bit of a fan favorite over the last couple of years—a report that is requested by our customers, the online community, and our internal staff in equal measure.

We know that incorporating alternative data into the equity research workflow empowers analysts to pick up digital breadcrumbs and turn them into signals. We first launched our semi-annual “Stock Picks” report in January 2019 to demonstrate the power of this approach—and demonstrate it did. In the first report, we used Sentieo to publicly pick 11 stocks. Halfway through the year, these 11 long ideas returned an average (mean) of 60%, compared to the leading S&P 500 index ETF at just under 20% YTD—its best H1 performance in two decades!

To choose our stock pics, we use a combination of fundamental analysis along with alternative data from our platform and broad “themes” including high-growth industries, megatrends, revenue growth, and industry leadership. Next, we plot the data looking for telling trends and finally apply our team’s 60+ years of collective fundamental, qualitative investing experience to make our picks.

The H1 2020 edition highlights 14 new picks and takes a look back at our 2019 picks, why we selected them, and how they’re doing today. Last year’s H1 picks returned over 70% for the full year, while the H2 batch performed slightly above the SPY ETF since publication date to year-end (8.42% vs. 8.39%). We also did a retail-focused “Back To School” portfolio that further showcased our alternative data integration across the platform: we combined document search (to identify “back to school” stocks) with screening (looking for acceleration in the most predictive metrics). An equal-weighted basket, pun intended, of these 11 most actionable “Back to School” retailers outperformed the retail ETF XRT over the following month, as our alt data indicated they should: the basket was up around 13% vs. flat performance for the XRT. See our retrospective for details on each stock. 

Sample H1 2020 ideas (download the full report here)

CROX

Megatrends: casual wear 

Casual footwear company CROX was one of our H1 and H2 long ideas for 2019, and it’s also back for 2020. After overcoming some company issues in H1 2019, the company had an outstanding H2, more than doubling its June 2019 numbers. We are seeing excellent revenue and earnings estimates revisions, with solid alternative data index vs. expectations for revenue growth in the current quarter. The stock now trades at around 21x P/E for FYE Dec 2020: while there has been some multiple expansion since the summer, we still see room to run towards the premier names in footwear, all at 30x and above (for Nike, Adidas, Puma, Under Armour, Asics). 

 

 

CHGG

Megatrends: online learning, cloud

The dominant US online learning aid and textbook rental player Chegg (CHGG) has several levers to pull operationally in 2020: better bundling, better password sharing control, international, and execution around the recently acquired IT “boot camp”. With remarkable brand recognition, highly scalable content platform (across a variety of subjects), personalized learning aids (including tutoring), and affordable pricing ($15-$20/mo), the ROI for CHGG customers is undeniable versus tuition/remedial classes/dropping out. Yet the company trades at around 9x EV/Sales for FYE 12/2020, below similar high-growth, high-margin, defensible SaaS stories. We see an opportunity for catchup in 2020 (backed by strong search trends), very similar to what we saw with CROX in 2019. Also notable is the nearly 17% short interest, based on float.   

 

DOCU

Megatrend: cloud

Similar to our returning pick COUP, DOCU is at the forefront of changing business processes, but in contracts. The ubiquitousness of contracts across every enterprise and every department means a very large TAM, and DOCU has the sales growth and KPIs to prove it. Our alternative data for the upcoming reporting quarter indicates better than expected sales growth. The company trades at around 11x EV/Sales for FYE Jan 2021, with very strong revenue estimates revisions.  

 

To get the full H1 2020 list, and to see our full 2019 retrospective, download the full reportEquity Research Guide: How to deliver alpha without spending millions on data science projects”

 

 

Sentieo Document Search: Updates in the Newly Released v 4.0

With the latest release, Sentieo’s industry-leading Document Search got even better! 

As a part of our continuous improvement, we have added both new document sources to our very extensive collection, and additional functionalities to improve your complete workflow. In addition, to help users navigate through our non-English language documents, we have added language filtering. 

In the new version, users can now search documents from the US Food and Drug Administration (FDA), the US Environmental Protection Agency (EPA), and PubMed, totaling about one million new documents. In detail, we have over 20 years of history for PubMed (primarily the MEDLINE database), six years for FDA documents (press releases, recalls, withdrawals and others), and three years of EPA documents (press releases, enforcement announcements, superfund and brownfield updates). These document sets come on the heels of our private company data and LexisNexis news sources integrations last year. 

These documents can be integrated into your workflow just like the rest of our other docs: fully searchable (including our ML-based synonym search, saved searches and saved search alerts), with the ability to highlight and capture screenshots for your Notebook for future use, as well as our extensive Boolean operators. Some of the documents from the FDA and the EPA are tagged to publicly traded or private entities. 

To find these documents, use the Source drop-down anywhere in our Document Search. 

In this short instructional video, we go over the new document sources with some searches, and we show how these additions can be seamlessly integrated into your workflow. We show how to search FDA documents for mentions of listeria, a frequent cause of product recalls, highlight, label and save these passages; we then look for EPA documents containing mentions of superfund site Newtown Creek, and we save this search so new mentions will be pushed to us. Finally, we look at the PubMed database, where we find an interesting article, and we use our screenshot function to grab a chart with study results from it. 

 

 

In this second video, we show how to filter for documents in different languages in our Document Search, and how to use non-English search queries with our Booleans. We then show how to highlight and label the doc just like one can do with an English language doc. 

 

Productivity as an Edge in Equity Research

Investing is an ever-evolving industry. In recent years, we have seen the rise of indexing, quantitative strategies, an explosion of alternative data, and fee compression. Specific tools and data sets have delivered some improvements, for example, the addition of alternative data to analysts’ resources; however, the research workflow has remained relatively static and anchored to last generation tools from the legacy data terminal providers, or make-shift solutions through consumer-grade apps. 

Simply put: the workflow used for investment analysis has simply not kept up with the reality of the structured and textual data that must be parsed to produce a thesis with the potential to deliver alpha. At the same time, the adoption of homegrown or empty shell RMS solutions has failed to deliver substantive improvements in the investment research workflow. With costly document integration, poor user experience, and missed insights, the time has come for a new approach. 

While the need to “research different” to maintain an edge is greater than ever, there is one thing all successful investors do: correctly identify trends. Building alternative data into the research workflow empowers investors, so they can stop relying on hunches, intuition, or biased views and start quantifying and visualizing trends in seconds by overlaying relevant financial metrics—and ultimately generate alpha faster. However, repeatability is also important here. IP Security and compliance documentation are imperative to winning at scale. It’s why simplifying the research workflow and improving productivity is the key to longterm success. 

By bringing together each of the historically separate capabilities of equity and market data, document search, analytics and modeling, collaboration, and an auditable RMS into a single, integrated solution investment leadership enables their analysts to discover uncharted insights that they would not have been able to find with isolated tools. 

Want to learn how some investors are already applying this approach? Listen to CEO Alap Shah and me as we discuss this approach with Senvest Analyst King van den Berg in our on-demand webinar “Productivity as an Edge in Equity Research”.

 

 

The Power of Sentieo In Your Pocket: Stay Productive with Mobile Apps for iPhone and iPad

We realize that it is crucial to have access to your research documents, data, news, notes, and alerts — anytime, anywhere. This is why we’ve created a Sentieo mobile experience with our iPhone and iPad apps. Stay productive on the road and never miss important developments about the companies and industries you care about.

Document Search on Sentieo Mobile 

Sentieo’s Document Search web application features are also available in our mobile apps:

  • Search through all types of documents exactly as you do in the web app, using the exact same filters (and ability to save filters), as well as the same “IN:” commands to search keywords within specific documents.
  • Read company documents even when you don’t have an Internet connection with automatic, offline sync.
  • Highlight and annotate documents — both online and offline. Redline documents easily in the iPad app.
  • Save time and don’t risk missing material insights, signals, and trends, with Smart Summary™ transcript analysis
  • Find the right search phrases with query autocomplete, powered by Sentieo’s natural language processing
  • Stay organized by bookmarking documents, sharing them via email, and even exporting to PDF on mobile 

 

Alerts and Push Notifications

  • Keep getting real-time alerts from the platform: in your email inbox or via push notifications on mobile
  • Get customizable alerts on anything you want to follow, whether it be news, new documents, financials, search results, and more

 

Data and Visualizations 

Sentieo’s data and visualization features are also accessible on-the-go.

  • Continue to follow tickers and receive real-time price updates for your Watchlists
  • View your financial models and metrics via iPhone, iPad, or offline, including income statement, balance sheet, cash flow, ratios, company valuation, and comps tables with customized metrics 
  • Access your Sentieo charts via iPhone, iPad, or offline, including: historical price charts, intraday charts, trading multiples, estimates charts, and growth charts
  • Stay on top of your News Stream of social media, news, company documents, market data, multiples, and more

 

 

Research Management 

Get a constant live stream of the content your team is sharing. Save your email inbox from overflowing by using the Sentieo Notebook app.

  • Create notes that are searchable across mobile – and access all of your custom note templates.
  • Highlighting and annotating documents — both online and offline (any highlight or annotation you make is automatically tagged and saved to your Notebook)
  • Forward any email (with or without attachments) to your Sentieo account, and the email content will automatically be tagged, saved to your Notebook, and made searchable
  • Clip and tag any website or article to send it directly to your Notebook with Mobile Clipper
  • Collaborate with others via mobile by sharing any note or saved asset with a colleague, team, or your entire organization. Eliminate long email chains with our commenting functionality.
  • With mobile offline access, all of the above features are available with or without an Internet connection!

 

Download The Apps:

 

Available for use by existing Sentieo users.

Available for use by existing Sentieo users.

Available for use by existing Sentieo users.

 

Don’t have Sentieo yet? Sign up for a trial here.

Taking a Data-Driven Approach to Alpha Generation: Part 3

From the rise of indexing and quantitative strategies to an explosion of alternative data and fee compression, we’ve seen an evolution of the market. The need to “research different” to maintain your edge is greater today than ever before. 

In our three-part blog series, “Taking a Data-Driven Approach to Alpha Generation,” we’re covering three different strategies to overcome overreliance on hunches, intuition, or biased views. We’re also recommending ways to start quantifying and visualizing investable trends— to ultimately generate alpha faster. In the last few weeks, we’ve discussed how to make alternative data work for you and how to capitalize on your internal datasets for alpha generation. Today, we’re wrapping up the series with how to create powerful visualizations over time using sector-level financial metrics.

If you had an idea about leverage trends in US Consumer Staples, you could chart the quarterly Net Debt to EBITDA ratio for a basket of stocks and then calculate a simple average of these to see the overall trend. The example below shows that after a decade of low interest rate policies, consumer staples companies are now substantially riskier, from a credit perspective.   

Interactive public viewer chart link 

Or if you combine the market caps of the publicly-traded US homebuilders and chart it against the US 30-year fixed mortgage rate, you see the really high sensitivity of the builders’ collective market capitalization against the mortgage rates. 

Interactive public viewer chart link

Innovative combinations and visualizations of traditional data sets are another proprietary approach to supporting your research efforts. Successful investors identify new trends and develop winning investment theses every day.  The question is: who will identify the trend first? It’s no longer enough to simply be accurate; today you need to be accurate the fastest. Technology is key here. From using alternative data and building out internal proprietary datasets, to combining traditional datasets, technology is enabling analysts to take advantage of the large and growing number of data sources out there.

We hope you enjoyed this series. Download the full guide to go even more in-depth on these three data-driven approaches.

Who Won Black Friday and Cyber Monday? Sentieo Uncovers 5 Winners and 1 Loser

For investors in Consumer Discretionary and corporates operating in that space (retailers, consumer products), monitoring various sources of alternative data is of paramount importance. Search trends (and their year-over-year change), Twitter mentions (with year-over-year changes), web traffic (also with year-over-year changes) alone or together can provide important, real time insights during this critical holiday shopping period. We used a number of these sources, by themselves and combined, to look for standout products and companies. 

All indications point to the 2019 holiday shopping season remaining very strong, with 3.8%-4.2% spending growth expected. Online spending on Thanksgiving Day itself was up almost 15% to a new record high. Adobe’s shopping tracker reported $7.4 bn in online spending on Black Friday, up almost 20% YoY, and another $3.6 bn Cyber Monday, up 18% YoY. 

5 Holiday Winners

 

1. Peloton

Maybe you’ve seen The Ad, and maybe you’ve read about the controversy. Perhaps you liked the ad, or perhaps you did not. But what really matters here is that Peloton, a relative newcomer to the public markets, was able to dominate the conversation for a few days (!) and insert its $2,000 stationary bike + $39/mo sub plan as a possible holiday gift for many consumers this year. Step aside, Lexus! 

Interactive public chart viewer 

 

2. Roku:

We really liked Roku in early 2019 when we released our Sentieo 11 alternative data stock picks: it was the top performing pick in H1. We also included it in our July 13 picks for H2 2019. We discuss the idea in detail, as well as the overall alternative data methodology used, in this webinar from July with our CEO/co-founder Alap Shah and VP of Product Arib Rahman. 

Our alternative data composite index (a multivariate regression for the most predictive basket weights of the available data sets) is pointing to an exceptionally strong holiday season for Roku. We would not be surprised to see a revenue beat (street estimates of quarterly revenue are the dotted green line in the chart; actuals are the solid green line). 

Interactive public chart viewer 

 

3. Airpods: 

Airpods are… seasonal? 

The bluetooth audio/mic earbuds by Apple are hot this season much to our surprise. (Did everyone lose theirs at the same time, or are they now a discretionary accessory?) We can’t be sure, other than what we see in the data: highest ever search interest and seasonal high Twitter mentions (30-day moving average) for the product (starting at $159 in the US for the basic version).

Interactive public chart viewer 

 

4. Rosetta Stone:

Rosetta Stone is a language learning software company that has had its ups and downs over the last few years. We spotted the alternative data index acceleration in our Screener, and we were immediately interested. 

Interactive public chart viewer

The acceleration is due to web traffic: we are seeing a 100%+ spike on a year-over-year basis on rolling 30- and 91-day moving average basis. 

Interactive public chart viewer  

 

5. Five Below:

The discount retailer was also another one of our H1 picks, like Roku and Nintendo above. They reported strong results on December 4th (retailer fiscal years are generally on a January year-end so their earnings season is later than most: see our Q3 machine learning/NLP Transcript Smart Summaries here on real Q3 calls from Facebook, YUM! Brands, Beyond Meat and Merck). We see strong data sets for Five into the holiday season (yet to be reported). 

“Stacked” search trends show annual search trends for the entire year, “stacked” on top of prior years. We see that 2019 has been very good for Five Below, including the current holiday season. 

We are also seeing good web traffic. 

Interactive public chart viewer 

The momentum has meant a great looking Sentieo alternative data composite index for the FIVE revenue growth for the quarter that was just reported, and likely continued strong performance through the holiday season. 

Interactive public chart viewer 

1 Holiday Loser: Victoria’s Secret 

Our pick for the loser this holiday season is Victoria’s Secret, a unit of L Brands. The lingerie brand has seen years of declining search interest and weak comparable store sales, as shown in the table below, which uses our one-click table chaining and extraction tool.

We are seeing very weak search trends compared with the last 10 years!

Note that VS is one of two brands for the parent company, L brands. The other one, Bath and Body Works, has been strong over the last few years. 

To try analyzing alternative datasets for yourself, try Sentieo today.

Taking a Data-Driven Approach to Alpha Generation: Part 2

Over the last few years, we have seen the not-so-gradual evolution of investment marketing, from the rise of indexing and quantitative strategies to the explosion of alternative data and fee compression. The need to “research different” to maintain your edge is greater today than ever before. But despite the changes, there remains one major thing all successful investors do: correctly identify trends. 

Over the coming weeks, we will cover three different strategies to overcome overreliance on hunches, intuition, or biased views and start quantifying and visualizing investable trends, to ultimately generate alpha faster. You can skip ahead and read the full report here.

A couple weeks ago, we covered everyone’s favorite industry buzzword: alternative data. Today, we switch gears and focus on how to capitalize on your internal datasets for alpha generation.

When looking to “supercharge” research, it’s important to include internal proprietary data sets, such as search statistics on corporate documents, like earnings call transcripts. Unlike alternative data sets, which are widely available for purchase, document search statistics are your own internal proprietary data set. These can be a powerful source for trend identification and verification.

One example of this is the short-lived “gluten free” fad. A quick search of conference call transcripts that mention “gluten free” show that while gluten intolerance is in fact a real issue, it really only impacts a small percentage of the population. As a result, the corporate response clearly came and went

Another example is the opioid crisis. In this case, search statistics help quantify metrics for risk management purposes. For example, we can see that the number of 10-K filings with Risk Factors that mention “opioid” or “opioids” have increased substantially over the years

Search statistics for documents can also be combined with financial metrics to spot trends in an industry group as a whole. For example, combining restaurant industry transcript mentions of “wage inflation” against the average adjusted EBIT margin for a group of US casual dining chains shows that the margin peaked and started to decline shortly after document statistics pointed to increasing wage pressures

But these internal datasets can do more than just verify or quantify trends, they can also help you spot trending terms as well as “equivalents” to help you generate ideas and develop a thesis. For example, looking at all corporate documents for YUM! Brands (global parent of KFC, Pizza Hut, and Taco Bell), we can identify company-specific trending topics.  

This same concept can be applied to searches for document types: searching 10-K filings with the SEC for Vietnam and other Southeast Asian countries are trending in the mix.

Most importantly, search statistics for documents are entirely your own proprietary data set. Because they’re not available from the data vendors, they are your own competitive advantage and enable you to preserve your edge for longer.

Next week, we’ll cover how to create powerful visualizations over time using sector-level financial metrics. If you can’t wait that long, you can download the full report here.

Taking a Data-Driven Approach to Alpha Generation: Part 1

Over the last few years, we have watched the not-so-gradual evolution of investment marketing, from the rise of indexing and quantitative strategies to an explosion of alternative data and fee compression. The need to “research different” to maintain your edge is greater today than ever before. But despite the changes, there remains one major activity that all successful investors do: correctly identify trends. 

Over the coming weeks, we will cover three different strategies to help you surpass your overreliance on hunches, intuition, or biased views — and start quantifying and visualizing investable trends (so you can ultimately generate alpha faster). You can skip ahead and read the full guided report here.

Today we’re covering everyone’s favorite industry buzzword: alternative data.

“Alternative data,” a broad term that refers to newer data sources, has become increasingly popular over the last few years. From credit card data to search trends, app rankings, and even Twitter mentions, alternative data has become a buzzword as well as a useful tool for research. 

Alternative data can be powerful. But to identify alpha-generating trends, we need more than just one data source, and we need to combine data sources. For example, let’s take a look at clear aligners (the clear plastic trays used for teeth alignment). You might be familiar with the leader in the space, Align Technologies (makers of Invisalign), but there are a good number of recent entrants in the space. These include SmileDirectClub, a DTC (direct to consumer) clear aligner company that recently completed an initial public offering. 

Starting with a very basic alternative dataset, search trends, we can gauge both the direction and the seasonality of the topic. An important point to make here is the distinction between search term (the exact term) versus the broader search topic (which bundles a number of related search terms together). 

Plotting the search interest, we can see that interest in clear aligners has been growing very steadily for the last few years, with peak levels (indexed to 100) happening in 2019. We can also see distinctive seasonality: a drop off into the December holidays, followed by a spike to new highs in January, consistent with self-improvement trends post-New Year.  

Interactive chart http://snt.io/KEF8ejHb8

But search is just a part of the picture. 

Using Alexa web traffic data, we can combine the search interest with web traffic data for the major players in the clear aligner space. While there are “web traffic share” gains and losses, we can see that, as a whole, traffic is increasing across all players: Align, Smile Direct, Snap Correct, Candid Co and Smile Love. 

Interactive chart: http://snt.io/MfF8emuTG

As the final step here, we can overlay the financial and valuation metrics for Align Technologies as the public company in the group with the longest trading history. For clarity, we are “hiding” the non-ALGN traffic metrics. We can see that the search trends correspond very nicely to quarterly revenues (2-year correlation is 0.8), while valuation (EV/Sales here) seems to move based on web traffic direction on shorter time frames. 

Interactive chart http://snt.io/BSF8epB5B

You don’t have to focus on individual securities to use trends in alternative data—it can also be used to detect changes in macroeconomic trends. 

For example, using Twitter as a “repository” for live conversations, we can see that tweets containing “new job” (30-day moving average for smoothing) foreshadowed the increase in the non-farm quits rate by months around 2012-2013. 

Interactive chart http://snt.io/NcF8et44S

Effortlessly combining traditional and alternative data sets in compelling visualization lets you not only see more but speed up your idea velocity in the pursuit of alpha. In the case of clear aligners we can see that there is a very strong, and growing, underlying demand for more convenient, “tech first” cosmetic dental care.

Next week we’ll cover how to capitalize on your internal datasets for alpha generation. If you can’t wait that long, you can download the full report here.

[Videos] How to Use Sentieo’s Table Explorer To Extract Data and Save Hours

In this “how to” post, we will review how to use our Table Explorer table chaining function in SEC documents, as well as the major updates we integrated with our recent v3.9 release. 

Broadly speaking, you can do a LOT with tables in Sentieo. 

  1. Export one or all document tables into Excel 
  2. Search only within table (s) using our popular “in:table” shortcut 
  3. See side-by-side historical tables (very useful for annual filings like proxy statements)
  4. Export PPT/PDF tables to Excel 

But none of these functionalities come close to what Table Explorer can do. Table Explorer uses a machine learning model to identify, chain, and visualize reported data. This is done in an auditable, transparent fashion, with added one-click flexibility for elements such as YoY and QoQ changes, common size statement conversion, and more. Analysts save countless hours with this ability to quickly chain tables, as well as visualize data and trends.

We will start with a simple example: the income statement. Table Explorer chains either 8-Ks, or 10-Qs/10-Ks. Since Q4s are not always reported, we create “synthetic” Q4 statements with one click. We use Adobe’s income statement as an example. Watch the video to find out more. 

In this second video, we cover the balance sheet. Similar to the income statement video above, we have an easy adjustment for Q4 balances. We go over the Netflix balance sheet, starting with their most recent filing. 

In this next video, we cover the cash flow statement. Cash flow statements are often presented in a cumulative fashion: 3-month in Q1, 6-month in Q2, 9-month in Q3, and 12-month in Q4. In this specific example, we use Mondelez International, the global snacking giant. We convert to quarterly with just one click. (We even came up with a new word for this function: “to quarterize”).

Table X does not stop here. You can export your chained data to Excel and to our data visualization tool, Plotter, for further work. You can save the data into your Sentieo Notebook to add to a full thesis.

The video below reviews these steps. We extract and chain Adobe’s income statement, convert it to “common size,” then visualize and export the percentage split of service vs. product revenues for the company. We then export to our main data visualization tool Plotter, where we overlay two of the thousands of data sets included in Sentieo, and finally, we save the chart in our Notebook for use in our full-blown thesis on the company.  

Table X works on other tables too. For example, you can extract your own KPIs or any other table-based data. While some KPIs might be available from the standardized data providers, not all are, and extracting your own means greater confidence in your data through our on-screen auditing function. In this fifth video, we show you how. We extract and chain Chipotle’s KPI tables, and we quickly visualize the trends in average unit volumes and comparable store sales. 

After Table X was released to rave reviews earlier this year, the number one request was handling line item renaming. With the latest product release, we created a Row Merge/Demerge capability to address this workflow. We show you how in this video. In the example here, Crocs, a footwear company with a wholesale and a retail business, reports a quarterly store count by geographic region. However, the company changed its line item name from “Europe” to “EMEA” recently, creating a discontinuity in this specific data set. We show how to merge the two rows and how to check that the mapping is correct. 

In the final, and most technical, video we show you how Table X handles a specific type of table called a “roll-forward” table. A standard use case for this is a company reporting a change in balance over the quarter, where we have the starting balance on top of the table, any changes below that, and then we have the ending balance at the bottom. In this specific example, we chain Chipotle’s unit openings/closings table from their 10-Qs and 10-Ks, and then make a few quick adjustments to add a Q4 column with the correct starting/ending balance, and intra-quarter additions. We also demonstrate the importance of visualizations. Unit openings are clustered in Q4, and this plays a role in forecasting the annual revenues due to the backend loading. 

To find out more about Sentieo’s Table Explorer, or any of the other features in our complete workflow research platform, please get in touch with us.