Framework Solutions & Services

Prayaam Analytics and Prayaam Consulting works on research & development of data warehousing, business intelligence, enterprise performance management and artificial intelligence. Prayaam Consulting provides implementation and support services in these area along with its partners.


Movalytics is a framework solution for movie industry and can help understand potential revenue generation opportunities along with the best plot process that works with the film. A movie data set is analysed on different factors such as genre, actors, directors, budget and collections. A strategic plan based on the analysis is prescribed which would have a greater impact on the audience and thus on the box office collections. This is a technology agnostic solution. Sample solutions for demo purposes are available on Qlik, MySQL, R/Python. Extended solution includes financial planning and budgeting using Oracle EPM (on premise or cloud) solutions i.e. Hyperion Planning/EPBCS, Essbase/EPBCS and Oracle Data Integrator (ODI).

Business Challenge:

Recommend a selection mechanism for genre, producer, actors, launch date that depicts the impact it has on the movie collections

Data Collection:

Data needed to solve this challenge is captured from Movie Database, Internet (websites and social media) and excel files

Solution Offered:

A Strategic Plan is Prescribed to select a combination of actors, director, producer for a movie which will have a greater impact on the Box Office Collections, based on the insights uncovered in the Business Analytics. A complete plan of action is presented.


  • Performed In-depth analysis on the extracted data to uncover meaningful Insights and Patterns in the data

  • What – If analysis is performed to understand which Actor, Director, Producer Combination can bring out the Best

  • Different Predictions are made for different combinations of actor, director and producer based on the data collected using machine learning algorithms such as Regression using R/Python

  • Other predictive algorithms such as Clustering, KNN, SVM can also be deployed to gain different degrees of accuracy

Web Scrapping:

The additional data needed such as YouTube Comments, Social Media Feeds and the relevant data present on different websites was extracted using technique Called Web Scraping using R/Python

Financial Planning:

Budgeting and forecasting solution to plan the details on daily/weekly/monthly level. The technical solutions includes Oracle EPM suite of on-premise and cloud based product EPBCS along with Oracle Data Integrator as an ETL solutions. All big data components covered earlier will be available as well to process unstructured or semi-structured data sets. Advanced analytics and Artificial Intelligence components are handled using R and Python.

Business Analytics Services

Data Warehousing/Data Lake/Data Mart/Cloud Data Store Tools Supported

Oracle DB, SQL Server DB, Essbase, Snowflake

ETL/ELT Tools Supported

Informatica, ODI, PL/SQL, SQL, Talend, OEDQ

Business Intelligence Tools Supported

Oracle BI, OBIA (Finance, HRMS, Sales, Services, Marketing), Agile PLA, OFSAA Profitability Analytics, BICS, DVD, Qlik, Tableau, Talend, SAP Business Objects, Microsoft Power BI


Prayaam Analytics specialises in Oracle EPM on premise and cloud solutions. Enterprise Performance Management (EPM) software helps you analyze, understand, and report on your business. EPM refers to the processes designed to help organisations plan, budget, forecast, and report on business performance as well as consolidate & finalize Financial Issues (often referred to as “closing the books”). EPM solutions are primarily used by CFOs and the office of finance, while other functional areas, such as HR, sales, marketing & IT use EPM for operational planning, budgeting, and reporting.

Solutions Covered

Integrated Planning, Financial Planning, Sales Forecasng & Budgeting, Consolidation, Profitability & Cost Management, Business Planning, Strategy Management, Supply Chain and Performance Management.

Supported COTS Packages

Oracle EPM (Hyperion Planning, HPCM, HFM, FDMEE, ODI, Essbase, Financial Reporting, EPBCS, PCMCS, FCCS, ARCS, Tax, EPRCS)