The ShiSh List

fueled with curiosity, enthused by discovery
  • The ShiSh List

    PowerBI goes Surfing

    • 0 Comments
    I use a lot of devices (and smartphone apps) that collect data on the activities that I do; and one of them is Windsurfing. On my windsurfing session last weekend, I wore a Garmin 310XT to collect location and speed data. The GPS lets me export the data...
  • The ShiSh List

    BigData at MarketMix

    • 1 Comments
    Thanks to Duane Bedard & Tina Munro of eSageGroup , I participated in a panel discussion at MarketMix with the brilliant Data Scientists: Jason Gowans of Nordstrom and Jon Francis of Nike. Duane Bedard did an excellent job of moderating the conversation...
  • The ShiSh List

    Big Data Retail Forum

    • 0 Comments
    I presented at the Big Data Retail Forum this morning and it was an interesting mix of Retail and Consumer companies. The focus of the presentation was on the convergence of "Democratization of Data" & "Democratization of Tools"...
  • The ShiSh List

    Accessing PowerBI Dashboards using Mobile

    • 0 Comments
    I recently blogged about using Bing Ads Intelligence to analyze Search trends for Outdoor Activities and visualize it using Power BI. The blog had an accompanying Power View visualization showing the search traffic for the different keywords as well as...
  • The ShiSh List

    Retailer Insights Through Search & Visualization

    • 0 Comments
    Costco, which caters to suburban families, according to a report in the Seattle Times hopes to add a new demographic through improved technology and offerings such as organic food. According to the report, Costco is taking incremental steps to draw in...
  • The ShiSh List

    Analyzing Seattle 911 Data using PowerBI

    • 0 Comments
    I just discovered that any Socrata-Powered Website supports OData feeds( http://www.socrata.com/customer-spotlight/ ). OData ( http://www.odata.org/ ) is a standardized protocol for creating and consuming data APIs. OData consumers are applications that...
  • The ShiSh List

    Using Power Map to Analyze Public Retailer Data

    • 0 Comments
    Here is a video that I put together for Retail showcasing Power Map with public data available for Nordstrom, Bloomingdale, Saks & Neiman Marcus. This is part of a visualization that we put together to showcase several layers of public data available...
  • The ShiSh List

    Visualizing Wal-mart

    • 0 Comments
    Wal-Mart opened its first store in 1962, in Rogers, Arkansas and today there are 4835 Wal-Mart stores in the United States (as of Jan 31, 2014). I was reading a paper called “ THE DIFFUSION OF WAL-MART AND ECONOMIES OF DENSITY ” describing...
  • The ShiSh List

    Lets visualize Beer because it’s 5 pm somewhere

    • 0 Comments
    Just chanced on an excellent source of brewery and beer distribution data maintained by the folks over at Seek A Brew . They have some interesting geospatial visualization of beer distribution. Seek A Brew has a community maintained distribution spreadsheet...
  • The ShiSh List

    Data Visualization: Smartphone Subscriber Market Share

    • 0 Comments
    According to comScore 156 million people in the U.S. owned smartphones (65.2 percent mobile market penetration) during the three months ending in December, up 3.2% since September. The report can be viewed here In this Power View visualization, I took...
  • The ShiSh List

    Interactive Data Visualization: What Outdoor Activity is most popular with 18-24 yr olds?

    • 3 Comments
    Bing Ads Intelligence is a powerful keyword research tool that allows you to build and expand on your keyword lists using the familiar Microsoft Office Excel interface. It enables you to easily gauge the performance of relevant keywords on the Yahoo Bing...
  • The ShiSh List

    Visualizing Seahawks vs Broncos with PowerBI

    • 0 Comments
    I’m not much into spectator sport but I do love stats and with all the buzz on the Superbowl around, decided to run some data visualizations to get a feel of the action. Since the Superbowl is one of the most watched annual events, chances are that...
  • The ShiSh List

    How the Internet of Things will impact Retail

    • 0 Comments
    I came across a fascinating blog post by Stephen Wolfram on the launch of the Wolfram Connected Devices Project . The media is abuzz with news about everyday devices having the capability of collecting data and communicating with other devices via the...
  • The ShiSh List

    Its the NRF Big Show once again #NRF14

    • 0 Comments
    Once again, this year, we will be at the NRF Big Show with some amazing Retail Solutions and Partners. New York will once again be THE place to be when the National Retail Federation’s BIG Show comes to town from January 13 - 14, 2014.  Microsoft...
  • The ShiSh List

    Analyze Real Time Hotel Availability Data using Excel

    • 0 Comments
    The Expedia Affiliate Network is an excellent source of Hotel information and has REST API’s that you can use in Excel 2013 via Power Query. You can register for an account via http://developer.ean.com/ Once you register for an API key, you...
  • The ShiSh List

    How To: Visualize Real Time Flight Data & Correlate with Local Airport Weather

    • 1 Comments
    A walkthrough of some of the research I did over the weekend on how to use Real Time Data in Excel. I used Power Query to acquire real time airport data from FlightStats, Inc. . I also experimented with converting queries generated using Power Query to...
  • The ShiSh List

    Using PowerBI to Visualize Real Time Airline Data

    • 2 Comments
    I have been curious about handling real-time flight data using Excel. One of the scenarios of interest in the Airline world is realtime data about flights, airports & delays. FlightStats.com has real-time data available on their site and interestingly...
  • The ShiSh List

    Which airline has the most cancelled flights? Find out using Data Visualization.

    • 2 Comments
    This is the time of year when airline travel is peaking and I was intrigued by the data visualization provided by FlightAware called the Misery Map . I love the real time nature of the data and the weather patterns that overlay the geospatial visualization...
  • The ShiSh List

    Brand Insights Using PowerBI

    • 0 Comments
    I have been experimenting with the Bing Ads Intelligence Addin for Excel lately and find that in addition to Keyword analysis for SEO, it can also provide excellent insights into customer trends and demographics. There are two Addins that I used with...
  • The ShiSh List

    Customer Insights with Bing Search Trends using Excel & PowerBI

    • 0 Comments
    Bing Ads Intelligence is an Excel add-in that helps you perform sophisticated keyword research and observe keyword performance on the Yahoo! Bing Network. You can install the Addin via this LINK . As we approach the holiday season, Retailers can gain...
  • The ShiSh List

    Talking Retail Correlations & Patterns

    • 0 Comments
    Thanks to Tina Munro , I had the unique opportunity of speaking at The Upstairs in downtown Seattle. The setting was interesting as it was in a homey Belltown bar. The talk was on something that fascinates me : finding unique combinations of data from...
  • The ShiSh List

    Interesting Big Data Scenarios in the Airline Industry

    • 0 Comments
    Some of the interesting things going on around Big Data & Airlines: Crowdsourcing Big Data Solutions: Alaska Airlines & GE Partnered to get the best minds in the world to contribute their algorithms to better optimize flight paths so airlines...
  • The ShiSh List

    Some Data Mining Tutorials for the Retail Industry

    • 0 Comments
    To stay competitive, retailers must understand not only current consumer behavior, but must also be able to predict future consumer behavior. This can help retailers reduce churn, improve sales, and improve customer loyalty. SQL Server 2012 offers predictive...
  • The ShiSh List

    Retail Competitor Analysis using Excel

    • 0 Comments
    For quite a while, I have been looking for data sources that enable me to import Retail Store locations for any retailer. A recent blog post (Thank you Microsoft BI Team) gave me the idea of using data from Yelp for importing Retail Store data for several...
  • The ShiSh List

    Creating Mobile Retail Store Feedback Forms using SkyDrive, Excel, QR Codes, NFC Tags

    • 0 Comments
    This is an experiment that I tried with some of the capabilities of Skydrive Survey Forms and QR Codes or NFC. The goal was to create a mobile feedback form that could be loaded either by tapping an NFC tag or scanning a QR code. To create the form I...
Page 1 of 14 (338 items) 12345»