Using PowerBI to Visualize Real Time Airline Data

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 also have an API that can be accessed using a developer account. To begin with I…

2

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

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. Check it out if you haven’t already: http://bit.ly/1bITHc6 . This set…

2

Brand Insights Using PowerBI

  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 Excel to obtain the data:   1.       Twitter Analytics Addin for Excel…

2

Customer Insights with Bing Search Trends using Excel & PowerBI

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 a lot of insight from Search Trend information. For instance, an Outdoor Gear Retailer can…

0

Talking Retail Correlations & Patterns

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 multiple public sources and determining correlations and patterns hidden within. It…

0

Interesting Big Data Scenarios in the Airline Industry

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 can reduce cost, avoid bad weather, and get to their destinations on time. This is…

0

Some Data Mining Tutorials for the Retail Industry

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 analysis through data mining, empowering users with actionable insight across the organization. SQL Server 2012 and Microsoft…

0

Retail Competitor Analysis using Excel

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 chains around an area and analyzing data including…

0

Correlating Retail Store Sales with Demographic Data

Retailers are facing growing challenges extracting business value from their data. The growth of data continues, due to new devices and sensors and rapidly declining hardware cost. Data complexity is increasing as retailers handle both structured data and unstructured data. Microsoft’s vision is to provide business insights to all users from any data, including insights…

0