Monday, August 6, 2012

Business Focused Analytics – The Starting Point

Having been a Business Intelligence practitioner for the last 13 years, there has never been a more exciting time to practice this art, as organizations increasingly realize that a well implemented BI & Analytics system can provide great competitive advantage for them. This leads us to the question of – ‘What is a well implemented BI system?’ Let us follow the Q&A below.

Q: What is a well implemented BI system?

A: A well implemented BI system is one that is completely business focused.

Q: Well, that doesn’t make it any easier. How can we have BI that is completely business focused?

A: BI & Analytics becomes completely business focused when they have ‘business decisions’ as the cornerstone of their implementation. The starting point to build / re-engineer a BI system is to identify the business decisions taken by business stakeholders in their sphere of operations. Business decisions can be operational in nature (taken on a daily basis) and/or strategic (taken more infrequently but they tend to have a longer term impact). To reiterate, the starting point for BI is to catalog the business decisions taken by business stakeholders and collect the artifacts that are currently used to take those decisions.

Q: The starting point is fine – What are the other pieces?

A: The next step is to identify the metrics and key performance indicators that support decision making. In other words, any metric identified should be unambiguously correlated to the decision taken with the help of that metric and by whom. Next we need to identify the core datasets in the organization. Please refer to my earlier blog post titled ‘Thinking by Datasets’  on this subject.

Q: What about the operational systems in the landscape? Aren’t they important?

A: Once we have documented the relationship between Business Decisions to Metrics to Datasets, we need to focus on the transactional applications. The key focus items are:

  • Inventory of all Transactional Applications
  • Identify the business process catered by these applications
  • Identify the datasets generated as part of each of business process
  • Next step is to drill-down into individual entities that make up each of the datasets
  • Once the Facts & Dimensions are identified from the entities, sketch out the classic ‘Bus Matrix’ which would form the basis for dimensional data modeling

 

Q: All this is good if we are building a BI system from scratch – How about existing BI systems?

A: For existing BI applications, the above mentioned process could be carried out as a health-check on the BI landscape. The bottomline is that every single report / dashboard / any other analytical component should have traceability into the metrics shown which should then link to the decisions taken by business users. BI & Analytics exist to help organizations take better business decisions and that defines its purpose & role in an enterprise IT landscape.

The answers mentioned above provide the high-level view of Hexaware’s approach to Business Intelligence projects. We have worked with many organizations across industries and a business focused analytical approach has provided good value for our customers.

Thanks for reading. Please do share your thoughts.

Wednesday, July 25, 2012

Earnings Conference Call on Tuesday, July 31st 2012 at 4.00 pm IST

The Board of Directors of Hexaware Technologies is scheduled to meet on July 31st, 2012 to consider the audited results for the quarter ended June 30th, 2012 (Q2 2012).

The company is hosting an earnings conference call for investors and analysts on the same day to discuss the results.

Details of the conference call are as follows:

DateJuly 31st, 2012
DayTuesday
Time4:00 PM IST
Dial-in Access Numbers
MumbaiPrimary Access:+91 22 3065 0539
Secondary Access:+91 22 6629 0539
Hexaware ParticipantsAtul Nishar– Chairman
P. R. Chandrasekar
 – Vice Chairman & CEO
R. V. Ramanan
 – Executive Director & Head – Global Delivery
Prateek Aggarwal
 – Chief Financial Officer
Deependra Chumble
– Chief People Officer
Sreenivas V– Chief Strategy Officer

Replay Facility*

Playback number: +91 22 3065 1212

When prompted, please enter the Conference ID 32580 followed by #

*The replay facility of the conference call will be available 60 minutes after the call ends and for three days from July 31st to August 02nd 2012.

Participants are requested to kindly dial-in 10 minutes in advance.

Thank you!

For further information: please contact – Sreenivas V
[e-mail: sreenivasv@hexaware.com; phone: +91 99401 90091]

More: http://hexaware.com/news/earnings-conference-call-on-tuesday-july-31st-2012-at-4-00-pm-ist-2/



Friday, June 8, 2012

Quality Assurance and Testing Services: Strategy of Oracle BI Testing

This Document gives an overview of OBIEE Testing and commonly used in BI Components while doing validation.

1. Testing in Levels: In a typical OBIEE project, it is advisable to test in multiple areas rather than attempting to test everything at once.

a) The first set of tests can verify the accuracy of the column to column transport of the data between the source and target. This verification is typically done using SQL statements on the source and target databases.

b) The next step is to verify the accuracy of the repository (the .RPD file.) These tests will include testing with appropriate dimensional filters on the metrics and the formula used to compute those metrics. Testers can build two sets of comparable queries within the repository interface.

c) The next step in testing will be to verify the dashboard / reports against comparable queries on repository metrics. In these tests, testers verify dashboard charts / reports against corresponding results from queries they execute on metrics of the repository.

d) Finally, the functional interface tests will cover tests to verify the lookups, performance, ease of use, look and feel etc.

The first three types of tests are performed by testers who can create simple SQL statements.

Structure and organization of test cases:

The choices on test cases naming convention and structure can help organize the test artifacts better and aid a great deal in implementing the overall testing strategy.

For example: If the test cases are grouped based on the nature of the tests, like, source to target verification, RPD metrics tests, functional, security, performance and usability, it would be easier to pick and choose the tests based on the testing context and tester capabilities.

1. User acceptance criteria:
Users typically have an existing legacy mechanism to verify if what is displayed in the new solution makes sense. Testers should dig into this and understand how the end users built the project acceptance criteria. Testers should challenge the assumptions made by the business community in deriving the acceptance criteria. This activity helps get an end user perspective built into the testing efforts from early on.

2. Validating Master Detail Report: 
Master Details linking of views allows you to establish a relationship between two or more views such that one view, called the master view, will drive data changes in one or more other views, called detail views.

3. Time series functions validation: Time series functions provide the ability to compare business performance with previous time periods, allowing you to analyze data that spans multiple time periods.

Time series functions enable comparisons between current sales and sales a year ago, a month ago, and so on.

a. Ago: With ago function we can compare period to period
b. To date: Time series functions enable comparisons between current sales and sales a year ago, a month ago, and so on.
c. Period rolling: The PERIODROLLING function does not have a time series grain; instead, you specify a start and end period in the function.

4. Oracle bi-publisher validation: Oracle BI Publisher known as XML Publisher offers efficient scalable reporting solution available for complex, distributed environments. It provides a central architecture for generation and delivering information to employees', customer and business partners both security and in the right format.



Thursday, June 7, 2012

Quality Assurance And Testing Services: OBIEE Validations

Hexaware has developed a variety of accelerators that combine Oracle's technology with Hexaware's functional and technical expertise to effectively meet your business needs. Oracle E-business suite range consists of financials, supply chain, manufacturing, HRMS & CRM.

Source to target validation: Here source is represented by metadata repository and Target represents OBIEE Reports & Dashboards, BI Publishers.

1. Presentation layer object validation:
This is the layer of the logical business model that is accessible for the client through the structure query Language better known as the logical SQL. The presentation is the appropriate layer to set user permissions and to validate user permissions to reports.

2. Categorizing the metrics:
It is important to classify the metrics from multiple perspectives such as, their frequency of use, potential performance impacts, and complexity of calculations involved. Such a classification helps drive priority of testing

3. Dashboard charts and filters criteria:
User interface testing should encompass tests with multiple options in the available filter criteria. OBIEE gives enough drilldown features to verify the underlying data on the clickable components of the charts. Test cases written should be detailed enough to verify data aggregated at various layers.

4. Filter Validation
. Validate the entire filters which are available on report. Example refers below report and its filter
. Example: For Performance Measure filter- Validate filter contents against report requirement and database

Filter types:
Local filters: Filtering the records in the report level.
Global filters: Filtering the records based on user selection in Dashboard.

Dashboard Validation:
When a user selects certain request that need to display the exact results in the dashboard.

5. Data level security:
Data level security validation means user will be able to see only particular data for the given permission
Example: Both the Eastern and Western region Sales Managers will be seeing the same reports but the Data visible to them in the reports will be Eastern and Western region Sales data respectively.

Object Level security: Need to validate whether the particular user is able to access the particular dashboard or folder etc.
Example: For example, users in a particular department can view only the subject areas that belong to their department.

6. Bursting the reports:
Bursting the reports means distributing the reports based on the regions. 
Example: If there are 4 regional reports, validate to burst the reports (based on East, West, South, North regions).

7. Buzz Matrix validation: 
Need to validate the alerts in the Dashboard.

Example: We are running stock market and CEO is very much interested to know today's business weather, has it reached a certain level that which he expects compared to the last week. If the level has reached to a certain level in Dashboard Buzz (Alert), it should raise an alert saying that it has reached the level in such a way the buzz matrix validates.



Tuesday, June 5, 2012

Healthcare Services - Saving Lives On A Daily Basis

At the end of the day no matter how large your home is, how many cars you own, or what clothes you wear you will not be satisfied if your health is not at ease. Taking care of your body is what allows you to happily partake in your daily adventures and enjoy the materials you have worked so hard for. To ensure a healthy standard of living, healthcare facilities offer their patients comprehensive holistic healthcare services that promise to find a natural cure for your body.

Unlike your neighborhood clinic, comprehensive holistic healthcare services will diagnose and cure your problem through natural remediation. Stuffing another antibiotic in to your body is not their technique, yet striving for health through completing one of their many hands on services. When you report to the office with a never ending back pain, they will use their chiropractic service to fix the stressed area. They are determined to find the actual source of your problem, not just quick relief. For instance, sometimes back problems can cause so much stress to the body that headaches and migraines arise.

Although antibiotics are not part of their cure, they do provide a healthcare solutionthat offers deep analysis of your lifestyle to begin the process of freeing you of any previous malnutrition your body may be used to. Between evaluation and the use of their laboratory testing service, they are able to target the exact nutrition your body is lacking. Whether your problems are due to your metabolism, diet choice, hormones, or any related factor they are able to isolate the cause and provide you with a cure for the long run.

Once these deficiencies are targeted they will undoubtedly inform you, but it is not always easy to leave the building and begin an entirely different lifestyle. For this reason, they have created a service that allows the professionals to do a full mind and body analysis of the patient to be able to target the inner problem and heal the body from deep within.


Visit @ http://www.amazines.com/article_detail.cfm/4364215?articleid=4364215



Wednesday, January 19, 2011

SEO Changes Prediction For 2011

The industry of SEO changed massively in 2010; (see our Review of 2010 in Search). We have seen the introduction / growth of Google Places, Google Instant, and Google Preview etc. Many of these changes have been keeping webmasters busy updating their websites so they don’t lose customers or business as a result of all these changes.

One thing I wouldn’t like to bet against is Google Places / Local business listings becoming a lot more competitive and dominant. Google seem to have focussed on this strongly through the second half of 2010. The SERP has in my opinion become a lot more relevant, it gives you chance to find good information, whether it be a news feed, a blog post, local business listing or a natural organic result.

The last big PageRank update was in April 2010. This is one of the longest periods (as far as I can remember) that it has not been updated in. This gives me the impression that Google could be changing or may have changed its ranking algorithm to place a lower importance on the number of inbound links your site requires for ranking in Google Places. I would say that your location and content / service you provide are much more important than link building. Google have now even introduced reviews for local businesses, not only does it allow you to review it using Google, it also picks up reviews from big review websites (see below).. who knows, having 100 positive reviews could be better than 100 back links.

SEO 2011

A Google search for “plumbing Manchester” brought back this as the number one result. The website itself looks to have about 90 back links (Majestic SEO) and doesn’t even have a mention of “Manchester” in the title tag. The first organic result (http://www.empireplumbingandheating.co.uk/) has about 3500 back links (Majestic SEO) and has a mention of Plumbing and Manchester in the title tag. These changes could potentially confuse a lot more SEO’s during 2011.

Good Points! I have noticed a lot of these changes. Google places listings being integrated with organic was a big deal for regional/local campaigns.
This entry was posted on Thursday, January 6th, 2011 at 1:21 pm. You can follow any responses to this entry through the RSS feed. RSS Globe

Monday, January 3, 2011

Brand Management – 5 Opt-in Methods


Branding 2A big aid to the success of any online business is those customers paying attention to the site and its messages, including e-mail and newsletters. People who are following your progress on a regular basis are receiving more exposure to your product, and are more likely in the end to purchase the services or item you’re selling than someone who just chances across your site. Thus, one of the many metrics set by businesses is a high number of followers they can reach via such contact methods.

Thus there is an increasing focus on the opt-in method of list building. By means of enticements, the distributor gets interested parties to voluntarily sign up for the service. Once this has been accomplished, it can be reasonably assumed that the party is interested in continuing the service over the long term.

This means the message is more likely to be put in front of people that want to see it and are most likely to respond to it.

Of course, different strategies produce different results, and not everyone responds to the same methods. Here is a handful of opt-in methods that can be employed to begin building that list.

Method #1 – The Pop Up

This is one of the more controversial options, because it’s one of the catch phrases of the anti-advertising mentality that grows on the web. People hate pop ups, the perception says. However, research suggests that pop ups still are some of the most profitable ways to generate clicks on sites.

There are several ways to approach the pop up option that will minimize the intrusion. Some mimic a toolbar that slides in from one side of the page, for example. Others will appear for a brief period, then recede if not used. The trick is to make it interesting enough to catch the eye, but not so obtrusive as to appear irritating or forced. Do avoid bright, flashing primary colors and strings of exclamation points.

Method #2 – User-activated Pop Up

This is a different take on the pop up methodology. The idea behind a pop up is that when it appears, it catches the eye and is hard to ignore. On the other hand, they’re irritating when they interrupt something a user is reading or watching. However, if a video or article has an embedded link that asks if the visitor would like to know more, that link can be tied to a pop up. This script can then show up and since it’s tied to one of their actions, it’s less likely to get an irritated or rejecting response.

Method #3 – The Free Gift

People feel better about giving out their information for a mailing list if they feel they’ve been rewarded for it. Therefore, entice them into opting in by offering them a gift related to your service. If, for example, your brand is a publisher of ebooks, offer them one of your older titles as an incentive. If your brand specializes in small, casual web games, consider offering one such game for free, or at least a free trial. The visitor perceives an immediate benefit, and is likely to sign up as a result.

As a side note, some free gifts can take the form of contests for prizes. If you are going to go this route, make sure that the prize genuinely is winnable, is worth the winning and that you announce the winner, provided, of course, that you have their consent. Contests are increasingly seen as false options by many viewers, and the only way to circumvent this perception is to make it a genuine item that people can win, rather than a crass deception.

Method #4 – The Squeeze Page

This is a page, based on text or video, that stops the process of giving information and lets the visitor know that they should sign up in order to get the full degree of information. This makes the preceding pages they have viewed a sort of ‘teaser’ that gets them interested in the material you have to offer, followed by an invitation to continue reading in exchange for some brief contact information.

Video is an increasingly popular option for squeeze pages, because it’s so easy to engage with. You can create a short video presentation explaining the value of the e-mail list, and it will stick in the mind much more than a highlighted checklist made of text.

Method #5 – The Basic Form

The simplest methods often become classics, and why? Because they work. Many sites still use the old standby of an unobtrusive simple web form at the end of an article, with spaces for a person’s contact info provided. This has the advantage of being very simple to produce, very easy for the user to fill out, and presents a minimum of interruption compared to pop ups or squeeze pages.


Enzo F. Cesario is an online branding specialist and co-founder of Brandsplat, a digital content agency. Brandsplat creates blogs, articles, videos and social media in the “voice” of our client’s brand. It makes sites more findable and brands more recognizable. For the free Brandcasting Report go towww.BrandSplat.com or visit our blog at wwwiBrandCasting.com.

 
Design by Free WordPress Themes | Bloggerized by Lasantha - Premium Blogger Themes | Affiliate Network Reviews