Thursday, June 19, 2014

World Cup 2014 -Predictive Analytics Showdown

Are you in World Cup 2014 friendly pool? Get help from 'experts' on statistically predicting 'who would advance and win the 2014 World Cup'.

If your betting window is closed, enjoy the game.

The models being off-target and you lose, it's very likely you will forget the loss (Freakonomics, bad predictions are rarely punished). Statistical models always learn from past recent events and refine the variables. Hope you win next time.

Here are the collections of World Cup 2014 Data Analytics and Visualizations

Nate Silver Vs. Goldman Sachs Vs. Bloomberg

Remember Nate Silver, 2008 US General Elections Prediction?, He and his team at FiveThirtyEight have statistical models on various subjects- Politics, Economics, Science, Life and Sports.

I like the visualization of the model.

FiveThirtyEight explains the statistical models which calculates the probability of teams advancing to the World Cup 2014 final. This model uses ESPN's SPI (Soccer Power Index).

Bloomberg with BSports have a good visualization, you can add your predictions and visualize.

The third model is by Goldman Sachs (they have been doing this since last four World cups)

SAP vs SAS vs R

SAP Lumira has fun facts and profitability.

There is not much analysis by SAS team, except this blog.

R-Bloggers contributors have posted statistical predictions -one favoring Germany and other Brazil.

Statsinthewild has interesting stats and data visualization.
Data Visualization

My favorite tool to visualize and learn World cup data is Google Trends. It uses real-time search data and uses interesting visualization techniques. I LOVE IT !!!

Tableau uses ESPN SPI statistics

What's is the difference between Prediction and Forecasting?
Prediction is a estimate of a specific event in the future. Forecasting is identifying all possible outcomes with each having its own probability, the total probability of all events will be close to 1.

The world just woke up now to 'Predictive Analysis'. The below Google Trends graphs seems to agree

Tuesday, May 27, 2014

SAP Smart Financials 1.0

We see the next evolution of SAP Business Suite on HANA for Financials in Smart Financials 1.0

SAP Smart Financials 1.0 has new functional features, thanks to the underlying SAP HANA. The is to have
  • More granularity for better reporting, and
  • Faster close (by removing the reconciliation effort)
SAP Smart Financials is not just a technical change, to implement a good Change Management strategy and high adoption rate is required.

Financial Planning with SAP Smart Financials 1.0
  1. The one area which interests me is Financial Planning, Smart Financial data is not available in ERP (as of release 1.0) . This is not a major issue if users report variance in BI. (The release note says the data is stored in BI). 
  2. Any processing of financial planning is not supported. This implies users loose 'Integrated' planning scenarios in ERP. It is not good news for clients which use the Integrated Financial Planning feature in SAP ERP.
This above changes should not be a surprise as SAP has been commited on SAP EPM as the planning solution.

To read more about the release note click here SAP Smart Financial Release Notes. Select SAP solutions > SAP ERP Add-Ons > Smart Financials

Comparison of SAP Smart Financials, New GL and Old GL

Smart Financials 1.0 (SAP ERP on HANA) (2013)
New General Ledger (2005)
Old General Ledger

Compatible with New GL only

Data Storage
Document tables and line item tables
Document tables, line item tables, indexes
Document tables, line item tables, indexes, has different FI/CO tables
Totals table
None, no inconsistencies between FI
documents and totals tables
Yes along with document/line item tables
Yes along with document/line item tables
Tables (index) are replaced by views. View are available for BSIS, BSAS, GLTO, FAGLFLEXT

Special Purpose Ledgers (SPL)
Not available
Available, Can use ‘Ledgers’ concept
Credit Management
Recommends FSCM-Credit Management (FSCM-AR)
Asset Accounting
New Asset Accounting replaces Classical Asset Accounting
Classical Asset Accounting
Classical Asset Accounting
-          Balance Sheet Planning no longer available
-          Reports for comparing planning data and actual data in Profit Center Accounting
-          Destruction of data or deletion of FI documents (Information Lifecycle

New Features in SAP Smart Financials 1.0

New Asset Accounting: Ledger Approach and Accounts Approach

·         With Smart Financials both the actual values of the leading valuation and the values of parallel valuation in real time.

Line Item Based Controlling with Period Close Optimizations (Enhanced) 
Variance Calculation for Cost Centers (Changed)
·         Option to process the controlling area currency only or both the controlling area currency and the cost object currency.
·         The execution time for processing the controlling area currency only is around half that required for processing the controlling area currency and object currency
WIP Calculation and Results Analysis (Changed)
·         The production orders are valued at actual cost for the selected plant with the defined legal valuation for a single result analysis version
·         Customer enhancement and WIP calculation for product cost collectors and process orders are not supported
·         Multiple valuations is not supported

Variance Calculation for Production Orders (Changed)

·         Accelerated collective variance calculation on production orders compares the target costs (in the form of standard costs) with the control costs (actual cost less scrap cost) of all production orders in the plant, and assigns the resulting variances to variance categories

Smart Financials Reporting (New)
·         Line items reports supported SAP HANA

Integrated Business Planning (New)
·         In the first release of this new planning solution, the development of functionality has been focused on enabling plan data capturing in a very user-friendly way.
·         If further plan data processing is necessary, releasing them to the classic FI/CO plan data tables may be considered in future releases

Tuesday, February 4, 2014

SAP EPM 10- Matrix Security

I have posted a video here, to demonstrate the Matrix Security in SAP EPM10. You can use multiple dimensions to build you data access profile. This allows administrators to have a complex scenario, and also reduces the total number of data access profiles.

In the video i have demonstrated, how you can create a DAP using a Region and Product combination.

Data Access Profile
Africa, AsiaPac, Europe
Africa, AsiaPac, Europe, N America, S America
Africa, AsiaPac, Europe, N America, S America
N America, S America
Read Only
Read Only

Is it possible to create a Matrix Profile with three dimensions- Region, Product and Time?
The above scenario will be useful when e.g. a Footwear Sales Manager's role evolves (FY 2015, FY 2016
) and is responsible for apparel and accessories in three year planning cycle. Or a Sales Manager's role will be shrunk  (in FY 2015, 2016) to only Footwear, as the company grows it adds apparel and accessories to a new sales manager.

Subscribe to Updates