aroundBI

ORA-01830 date format picture ends before converting entire input string. (WIS 10901)

TBL_DIMN_CALN_POST.D_PERD between  to_date(trunc(add_months(sysdate,-12),'MM'),'dd-mm-yy') and  to_date(trunc(sysdate,'MM')-1,'dd-mm-yy')

Could not save the document to the repository for the following reason: [repo_proxy 30] DocumentFacade::uploadBlob - Query execute has failed : Error occurred while attempting to reconnect to CMS : Not a valid logon token. (FWB 00003) (hr=#0x80042a70) (WIS 30567)

=3 + Previous(Self)

We can use any calculation such as =3 +1.5* Previous(Self).

•       Example 2. Showing concatenated values

Suppose we have Country and City names (check below) and we want to show all City names concatenated.


 =[City]+", "+Previous(Self)

Data warehousing is an emerging field with great potential of further growth. Scope and penetration of its usage is tremendous. Almost every business domain is using and implementing business intelligence in one way or other. With increasing rate of BI deployments, Business intelligence (BI) certification has attracted the attention of associated professionals, be it a DWH developer, Business analyst, BI architect or program manager.

(Disclaimer- We are NOT debating the importance and benefits of doing certification or whether certifications are required or not for career growth.)

We are skipping WHY (certifications) part and focusing on HOW. Article talks about different available certifications in the field of Data Warehousing and Business Intelligence.

Available Data Warehousing certifications fall into two broad categories:

Vendor-Neutral:

Vendor-agnostic certification courses tend to offer more of a focus on general procedure and best practices, rather than concentrating on the details of a certain suite of hardware and software. Objective is to equip with general knowledge of process, methodology, concepts of business metrics, data visualization, deployment skills, and techniques of data warehousing.

Few prominent certifications are:

Vendor-Specific:

Vendor-dependent certification courses focus on respective vendor product details.

Major ones are:

To choose the right certification for oneself depends on many factor such as:

Job profile and role- This will be a key element in deciding the test. If I am working as an architect or program manager, in that case, will it be a good idea to go for product based certification. Professionals playing at mid-level management or higher prefer to go for general BI exams such as CBIP.

Developers or experts who want to stick with particular product line select for respective product certification that they keep current with re-certifications with latest releases. It also gives a competitive advantage during job change.

Location- Perception of certification type is different in different countries. In Europe, the vendor certification seems to be the key whereas in US BI market, it is a mixed experience.

Employer type- Stack vendor's certifications hold more weight for consultancy companies to show employees with vendor certificates. Internal employees tend to go with personal growth consideration.

Summary:

My recommendation would be to analyze my current job profile and nature of responsibilities. If I am more on designing and planning, I would go for vendor neutral certification. If my job and career goal revolves more around particular product, I would apt for exams for that product. Certifications does not prove expertise but it gives a fair understanding of subject knowledge. Besides, there is no harm in doing certification.

I would like to hear your views on certification. Please share your thoughts.