Essentials of Performance Management & Dimensional Modeling of Vodafone
•Download as PPTX, PDF•
0 likes•145 views
The document summarizes a dimensional modeling project for Vodafone using IBM Cognos software. It analyzed Vodafone's market share, bill reports, and key performance measures across different regions. Cubes were created for assumptions, contributions, bills, market share, and reporting. The project calculated total income, EBITDA, equity returns, and cash flows. Challenges included limitations on data size and user access. Overall, the project analyzed Vodafone's financial and customer metrics across regions using dimensional modeling in IBM Cognos.
Essentials of Performance Management & Dimensional Modeling of Vodafone
- 1. Essentials of Performance Management & Dimensional Modeling of Vodafone Presented by: PMT09 Aditi Maheshwari Y13UC339 Gopal Kumar Y13UC105 Rahul Pandey Y13UC216
- 2. Objective
- 3. Overview: Vodafone Group is the world’s leading mobile operator service provider with a presence in Europe, Asia Pacific, United States, and the Middle East. It has international base customer for different services with geographic diversity. Vodafone has implemented many products such as voice calling, text messaging, mhealth service, mobile money banking services, vodafone live, vodafone mobile connect usb modem, vodafone foundation etc. Company has different types of customers like retailers which deal directly finance, other type of customer is consumer which uses services provided by the Vodafone group and stockholders. Company has different type of department to fulfill the requirements of company like IT department for network, Finance department for dealing with finance etc.
- 4. Objective: To be the communication service provider leader in an increasingly connected world by adopting new technology and maximizing the number of customers. Minimize the cost of services provided by the company and maximize the revenue generated. Expansion of business and optimization of running business operations cost. Maximize the revenue to Maintain appropriate investment in new and existing business and markets. Create and launch new value-added services around the globe to attract the new customers.
- 5. Strategy Map
- 8. Analyze Market Share We have taken on region level the Fixed revenue, Data Revenue and Other Income to generate Total Income of the company Total Income=Fixed Revenue+Data Revenue+Other Income Then we calculate Interest amount based on the interest rate provided in assumption cube Interest Amount=Total Income * Interest Rate/100 We measure EBITDA as per following formula EBITDA= Total Income-Interest-Taxes-Capital Expenditure Then we have also taken Return of Common Equity and Free Cash flow to measures the market share of each region.
- 9. Analyze Bill Report We have analyzed each individual bill status given their all call information i.e. Number of Calls, Total Minutes used, Roaming Minutes used and then we have calculated final bill amount using all other factors by the given formula Bill Amount=Fixed Rental+(Total Minutes-Total Free Minutes)*Local Charge+Roaming Minutes*Roaming Charges+Taxes
- 11. CUBES used in our Project Assumption Cube Assumption Contribution Cube Bill Report Market Share Performance Measure Reporting Cube
- 12. Screenshots:
- 38. Challenges
- 39. Challenges The software uses the RAM as a calculation so it is difficult to operate on very large scale data on personal level. There is no functionality of renaming of cubes or dimensions. Difficult to analyse the functionality parameters for a large MNC like vodafone. 2 users can’t login at the same time.
- 40. Summary
- 41. Summary and Possible Improvements Analyzed three measures of Financial and customer perspective Assigned different users with different rights for contributing or reviewing specific region Used different currencies for different region and subsequently converted the final amount in different currencies. We have not calculated employee turnover and customer churn rate as it was difficult to parameterise the values in IBM Cognos.
- 42. Any queries?? :)