#5 Examining data over time (7 ways with Netflix stock prices)
#4 Bullet charts & enhancements: making Stephen Few's invention even better
Read the rest of this entry »
Add Your Comment HereA dashboard to select high-quality stocks with high yield and low volatility
Selecting a "safe" stock with a solid dividend is quite popular in the current economic climate. The traditional "safe" investments are paying extremely low interest rates while many American companies are growing revenues while paying out strong dividend yields (4% and higher) that exceed those of government bonds. In late December, I selected a set of stocks with solid financial strength ratings, positive revenue growth in the past year, dividends of 4% or more and lower than average stock price volatility (also called the beta of a stock.)
After some data cleanup, I assembled this into a dashboard for quick review and exploration. This dashboard allows you to select higher yields, higher revenue growth or lower levels of volatility. By clicking on an individual stock, you are taken to MSN Money web site (below initial dashboard) for their current "StockScouter" rating.
Read the rest of this entry »
Add Your Comment HereTableau 6 – how it can change your world
The following article features Tableau 6
Whether you are exploring your data for new insights, answering specific questions or even deciding what questions to ask, Tableau gives you unprecedented control to investigate, communicate and take action with the valuable information hidden in your data! Tableau has it all - a wide variety of options to graph your data, the ability to adjust your data so that you are using the right data in the right form for the questions at hand, and a user-friendly interface that’s designed around how people think about analysis, allowing you to follow your thoughts as you question and explore your data. You can work with every major data source, from Excel workbooks to the largest databases. You can even extract data from larger sources into a local “extract” file that will make your data exploration more efficient and allow offline analysis when you are away from the office.
Profit and planned profit by product
Red is below plan, green is above
Percentage is actual versus plan
Black line in 2010 shows prior year profit amount
Displaying profit versus sales by region and customer segment Average profit ratio = size of bubble;
Minimum and maximum percents labeled per region
Colors are customer segments
Read the rest of this entry »
→ 1 Comment- Add Yours
Examining data over time, part 1- Netflix stock price history presented 7 ways
It is fascinating how much information you can uncover with just a few years of price data in Tableau. In this example, we use just two data items to examine the history of Netflix stock price (NASDAQ NFLX.) The data items used are date and closing price, adjusted for splits.
→ 2 Comments- Add YoursLinkedIn (NYSE symbol LNKD) IPO, some analysis and insights from their SEC filing and estimates
LinkedIn, undervalued and underloved?
After examination of the data against peers, I believe LinkedIn is priced for great growth potential in the coming years. Don’t get me wrong, it’s an IPO and they can be very volatile. However, I prefer to make my investments in companies based on long-term outlook rather than speculate on short-term trading gains.
It is estimated that LinkedIn (NYSE: LNKD) will price at $42-$45 per share tomorrow, valuing the company at $4.1B which implies approximately 94.5M shares in float. Based on revenue over the past 4 quarters, this values LinkedIn at 14.1 times revenue (Price/Sales).
Read the rest of this entry »
tableau public – share your visual insights with the world!
tableau public is now available! What’s not to love? Free web hosting of your visualization and a free desktop license of tableau public, based on the award-winning, rapid data visualization tools in Tableau Desktop and Tableau Server. With tableau public, you can learn the breadth of Tableau while sharing your insights with the world on any blog or web site.
Freakalytics is excited to be featured on the home page of tableau public, highlighting our stock market returns dashboard!
Click here to read the details about this dashboard, from our blog post last June.
Embedding tableau public content is simple and quick. Your web site visitors will need NO software installation, since Tableau depends on native Ajax functionality used by sites like GMail. Although not officially supported in the current release, tableau public is viewable and functions interactively on the iPhone based on our simple tests!
On your Tableau journey, consider…
Read the rest of this entry »
Did the super-smart (numerati) cause the near economic collapse?
This editorial highlights a fascinating yet simple theory, that super-smart people (the numerati) have created extremely complex and little understood financial instruments that helped drive us to the brink of economic ruin. These instruments originally had applications of merit that were reasonable. However, the profit potential was too large and the opportunity for application in almost any area of investing was simply too great a temptation. Over the past decade, derivatives have become the instrument of choice for a variety of hedge funds, investment firms and even once staid and conservative insurance companies.
AIG is an excellent example of where these instruments can take a company. To date, AIG has required “just” $183 billion in taxpayer bailouts to date. That’s $183,000,000,000.00 or greater than the combined endowments of the top 15 universities in the US (ranked by endowment as of 2008.) Wow, we could have endowed another 15 top universities in the US with just the losses created by AIG!
→ 1 Comment- Add Yours
Follow Freakalytics on Twitter
RSS for Freakalytics.com
