Business IQ Analytics (BIQA)
BIQA is an open-source business intelligence platform that empowers local businesses with data-driven insights. The platform aggregates customer's feedback and social presence data into actionable metrics, allowing businesses to gain competitive edge in their local market.
GitHub repo: Business IQ Analytics
Platform Demo: A Case Study on the Restaurant Business
The context:
  • Imagine you are the owner of Mastro's Ocean Club, a sophisticated steakhouse restaurant located in the vibrant heart of Las Vegas.
  • Your restaurant is one of the 158 steakhouses within the city's landscape, and one of 3990 opening restaurants in the whole city.
  • You want your restaurant to stay ahead of the competition in a highly competitive market like Las Vegas;
  • You want a comprehensive, data-driven view with metrics and insights of your business' service quality, online social presence, and competition in your geographical area.
All steakhouses in Las Vegas Table 1: Top 5 most frequent phrases in positive reviews. Table 2: Top 5 most frequent phrases in negative reviews.
The Challenges
As a business owner, you have to consider the following factors...
  • Customers looks up where they should eat in their area, and almost certainly they will see your restaurant's reviews and ratings (alongside those of other restaurants).
  • A recent survey revealed that 86% of users prefer using the internet to find authentic information about products and services.
  • In the F&B industry, for example, this translates into potential revenue if customers choose to visit your business.
You seek a data-driven approach that guarantees a competitive edge in running the business; an all-in-one platform capable of consolidating scattered data from various sources and extracting the critical insights necessary to make informed decisions.
About the Platform
What we provide ...
  • Data aggregation and valuable business metrics across various social platforms, including Yelp, TripAdvisor, OpenTable, Google, Instagram, and more, into a single dashboard.
  • Insights of your service quality, monitor your online presence, and secure a competitive advantage by benchmarking your performance within your geographical area.
Roadmap
For Service Quality Monitoring, netrics included in current iteration:
  • Review & Rating Trend over time
  • Positive & Negative Review Trend over time
  • Most Frequent Positive & Negative Phrases in Reviews
Metrics included in upcoming iteration:
  • Data and metrics from additional sources (TripAdvisor, OpenTable, Twitter, Instagram)
  • Enhanced Customer Feedback and Sentiment Analysis metrics.
  • Search Engine Results Pages (SERP) data from Google
  • SafeGraph point-of-interest (POI) traffic data
  • SafeGraph point-of-interest (POI) customer spending data
  • Google Local insights
For Macro-level Business Intelligence, metrics included in current iteration:
  • Competitive Benchmark of Yelp, TripAdvisor, Google Business profiles
  • Competitive Benchmark business websites
Metrics included in upcoming iteration:
  • Expanded Competitive Benchmarking
  • Google's SERP Business Ranking
About our target user base
  • In 2022, there are 33.2 million small businesses exist across the U.S. (U.S. Small Business Administration).
  • There are 1 million small businesses in the Hospitality industry in the US. (U.S. Small Business Administration), which takes up 3% of the total small businesses in the US.
  • Our earliest iteration focuses on the Hospitality industry. This includes Food and beverage services (restaurants, bars), hotels and other lodging services.
Built with
  • Plotly Dash for data apps framework.
  • Python (Pandas, NumPy).
  • Heroku for Public Dash App deployment.