|
By rahul.marothia at 20 May 2013 - 10:20
|
|
Why Do We Need ERP and Business Process Automation?
Somewhere along the line we started talking about “Serious Business”, we are all “Serious” business people so this comment is not meant to slight anyone or the way business is conducted, it is meant to make people stop and assess their choices and decisions they are making in everyday business. There comes a time when the business starts to be larger than the people who started it and requires multiple people working together, sometimes in multiple locations, multiple time zones, and it just begins to press us to seriously consider how to make our lives easier and to be able to grow our Business with more profits. A few of the reasons why we need ERP and Business Process Automation.
|
|
|
|
By bikashpatel at 27 Aug 2012 - 08:01
|
|
Wel come to Infor ION
|
|
|
|
By deepakaryan at 25 Nov 2011 - 05:47
|
|
Amazing tools are available in MS Excel 2007 & Above Ver... 
.....................................................................................................
If we know VBA & SQL then we can do anything in EXCEL VBA,
because in this application we develop any type of MIS Reports using
with pivot magic & Dashboard Chart.
......................................................................................................
I have amazing experience of excel vba in job. now i'm dame sure
that i can develop any type of report for MIS in this tools.
......................................................................................................
This tool is very user friendly & not required any type of reporting tools.
......................................................................................................
|
|
|
|
By Hitesh Shah at 23 Jun 2010 - 18:23
|
|
There appears to be some concurrence emerging on BI front in the BI community. Such concurrence can be like
1. MS office (and MS excel in particular) integration with application is identified as important first & foremost component of BI for large and small enterprise equally.
2. As the company BI requirements grow, people can explore and deep dive into collaborative software Sharepoint , data warehouses , reporting tools and services etc .
Here are the links from where above conclusions seems to be emerging.
Office 2010 heeds BI propagation
Don’t dismiss Excel in your BI strategy
Microsoft Promises BI For The Masses With PowerPivot For Excel
Even Infor is buddying up with MS . So users may not have to worry for office integration at all and depend on any 3rd party products !!
|
|
|
|
By Hitesh Shah at 17 Dec 2009 - 17:44
|
|
Online dashboards coupled with in-memory analysis and predictive / statistical analytics form the major drivers of current BI solutions besides the obvious major driver routine operational reporting.
Operational baan reporting supplemented by in-memory data transformation in Excel/Baan and statistical functions in Excel substantially fulfils this need . However dashboards are an area so far unaddressed.
For online dashboards also Excel can play a good role. There is a myth that Excel can only be used with MS SQL. But that’s not correct . It can also be used with other databases like Oracle / DB2 which may be installed on non-windows system through ADO-DB connections .
Here are certain resources which can help user build Excel based dashboards.
Excellent dashboard reports in http://www.exceluser.com/dash/index.htm
Importance of using named ranges (which can be used like variables in VBA by statements like application.range(“named_range”) and functions like lookup/match etc: http://charts.jorgecamoes.com/how-to-create-an-excel-dashboard/. Very good tips to improve dashboards and having good interactivity with user with dashboards: http://charts.jorgecamoes.com/tips-improve-better-excel-dashboard/
|
|
|
|
By Hitesh Shah at 16 Nov 2009 - 18:25
|
|
Normally individual and collective wisdom / insights which takes care off latest trends outside system , historical data , seasonal fluctuations , other correlations in predicting events and data. At times such predictions need to be supplemented by statistical analytical tools especially in case of scientific researches and vast tera bytes of data.
One can understand the importance of such predictive analysis from free Oracle Spreadsheet Add-In for Predictive Analytics
|
|
|
|
By Ravishankar at 9 Apr 2009 - 07:01
|
|
Information about LN clients
|
|
|
|
By Hitesh Shah at 1 Mar 2009 - 10:25
|
|
Here is a blog on a reporting strategy for baan complemented with Excel load clients. This blog discusses various approaches to reporting in Excel and ingredients of successful Excel assisted baan reporting.
WHO SHOULD READ THIS
One should read this blog if:
- one is very much comfortable with existing authorizations and semantic layer in Baan (Read baan data dictionary ) technically ( table/domain /field codes ) and functionally (descriptions ) and
- one wishes to capitalize on existing learning and knowledge of existing semantic layer in Baan (technically as well as functionally ) and do not wish to invest (or waste??) in learning / migrating /adopting / translating / maintaining new semantic layer for reporting
- one is very much adept at using Baan reporting and programming for routine documents and
- one’s users enjoy the freedom, flexibility and functionality of spreadsheets (which may be freeware also) for analytical purposes.
- there are sufficient Office licenses already with company on PCs with high CPU and memory ( far exceeding basic Excel requirements and which have become norm rather than exceptions ) in one’s place and there is high need to optimally utilize these resources and to reduce the load on servers .
WHO SHOULD NOT READ THIS
One whose objectives are different OR who don’t have any objectives only OR who is extremely satisfied with their current reporting already.
|
|
|
You are browsing all items of this content category sorted by date (most recent first). Note that forum posts/threads are not included here.