Enterprise Analytics

RahulGupta6 - PeerSpot reviewer
30000 people affected
100 people managed
36 month project

Project Description

Sales dashboard for Sales Persona. Sales leaders can view different near runtime cuts of the following KPIs:

  • TQF & Booking DSO & Billing Sales Bonus
  • Win/Loss Trend
  • Booking Achievement
  • Funnel Movement
  • Top 10 Accounts

Delivery dashboard for Delivery Persona. Delivery leaders can view different near runtime cuts of the following KPIs:

  • Revenue, Project Margin, PM%
  • CSAT
  • Order Booking
  • Resource Mix
  • Resource Utilization
  • Project Expenses

These dashboards are taking source data from SAP, SQL Server, SFDC & other .NET applications. ETL is designed in Qlik and then Dashboards are creating from underlying data.

With the implementation of DWH and Qlik Reporting Capabilities, the end user has been provided with an enormous amount of freedom to create a wide range of visually stunning, feature-rich dashboards and reports. User can take advantage of the flexibility offered by drill up and down through data to achieve the appropriate context and level of detail to meet specific data analysis needs. Using the multidimensional analytical reporting feature, decision makers at all levels of project management able to generate analytical reports and respond quickly to changes in the business needs if required.

Highlights

Received a promotion
Received recognition / award
Support from colleagues

Difficulties

Management had to be convinced
Large no. of people impacted

Technical Skills Used

  • Qlik Sense, SQL Server, SFDC, MSD
  • Chennai (IN)13.087880.2785
  • Hyderabad (IN)17.384178.4564
  • Bangalore (IN)12.971977.5937
  • Noida (IN)28.5877.33