Oil and Gas Analytics with Power View for SharePoint

Oil and Gas industry requires highest quality of decision-making based on correct and intuitive data. The industry becomes more innovative and requires faster usage of new production methods paying attention to eliminate risks at the same time.

Microsoft Business Intelligence provides tools to analyze historical data in intuitive and interactive way.

In this demo, team of Oil and Gas Company solves business issue through collaboration of following persons:

  1. Chief Executive Officer develops strategy, monitors operating efficiency, and achieves growth of profit and company value.
  2. Business Unit Manager works to ensure business continuity, improve technology, and drive excellence.
  3. HR Executive is responsible for improvement of personnel performance through training and appraisals.

All of them are using the same company portal built on SharePoint portal with a set of pages containing interactive reports (dashboards). These reports based on Business Intelligence Semantic Model (BISM) and visualized with Power View for SharePoint.

title

role1

role1-1

role1-2

role1-3

role2

role2-1

role2-2

role3

role3-1

role3-2

Microsoft Customer Analytics Solution for Banking

Understanding customers is the foundation to a sustainable competitive advantage in banking. Such problems as customer churn are very difficult to mitigate and much better just to prevent these events using analysis of customer behavior and preferences. To make it possible it is necessary to extract more value from internal and external data sources, and to be able interactively analyze intuitive data.

Microsoft Business Intelligence allows to solve problem of customer churn, provide better customer service, improve cross-selling, up-selling and enhance share of wallet.

Understanding importance of these tasks Microsoft created Customer Analytics Solution for Banking. In this blog post, I am presenting brief demonstration of this solution. After seeing video recording of demonstration (see below), you will find that marketers and other business users can easily use this solution to answer complex inquiries.

During the demonstration, I will act from points of view of different persons.

  1. The goal of Chief Retail Executive is to develop more profitable customer relationships with end-to-end customer insight with following tasks.
    1. Engage and retain the most profitable customers
    2. Assess segmentation performance and opportunities
    3. Optimize product  mix and pricing strategy
  2. The goal of Chief Marketing Officer is to understand and improve brand perception by integrating a broader set of data with following tasks.
    1. Understand brand perception & consumer sentiment.
    2. Gain insight into customer preferences.
    3. Identify key influencers & social media channels.
  3. The goal of Operator of Call Center is to provide support having complete view of the customer with following tasks.
    1. Provide best customer service quality.
    2. Combine customer sentiment analysis and profitability data.
    3. Track personal performance.
  4. The goal of Contact Center Executive is to maximize customer retention and satisfaction through improved service with following tasks.
    1. Improve  customer service quality.
    2. Track call center performance for each Agent.
    3. Combine customer sentiment analysis and profitability data.

banking-rolesbanking-role1role1-1role1-2role1-3banking-role2role2-1role2-2banking-role3role3-1banking-role4role4-1

Banking Future Vision

Please take a look at following videos which reflect current vision of Microsoft on future banking.