Posts Tagged ‘analytics’

After passing into the new millennium, myself and many of my peers saw an increase in the use of innovative marketing terminology relative to technology.  Just around the turn of the century, the term “Big Data” surfaced in conjunction with analytics. Soon thereafter, it was being applied to large volumes of data exceeding 1 terabyte in […]

In the healthcare technology space, we are all working toward the same general end goals of improving patient care while lowering costs. Healthcare organizations are all looking for ways to more broadly use technology that not only focuses on each encounter, but looks beyond that toward the continuum of care for the individual and the […]

2013 will be a momentous year in which banks and financial services companies will be forced to innovate or get left behind, transform or face regulatory challenges, and embrace change or see profits dwindle.  Perficient showcased its new E-book, “2013 Bank Transformation Guide” at Bank Innovation where we engaged in similar discussions with some of […]

We can use FOR XML PATH to combine rows.  For example, have the following data:   And I want to combine the value of column SRC_ID_SEED from all rows to a single row as:   We can achieve this by using FOR XML PATH(): select stuff((select ‘,’+cast(src_id_seed as varchar(20))          from DATA_SOURCES          FOR XML PATH ( […]

If you’ve never heard of it, the Google Font directory is an online repository of free, open-source fonts that have been web optimized and ready for your use.  There are hundreds of them from Display to Handwriting, Serif to Sans Serif.  The Sans Serif is the home of Open Sans by Steve Matteson. http://www.google.com/fonts#Analytics:total With the release […]

  Scenario: Data source is a flat file and we want to load this data into the target. The problem is the source file name keeps on changing.  Here we go: Use a pre-session script that creates a file list. Windows dir /b part_of_file_name*.txt > FILELIST_NAME.LST UNIX ls part_of_file_name* > FILELIST_NAME.LST                 In Workflow Manager […]

A few days ago when I was browsing some information categorized in data mining and machine learning, I heard that Google had released a large dataset called Wikilinks Corpus which contains 40 million mentions over 3 million entities. What does mention and entity mean here? Apple is also rumored to be working on a new, […]

Healthcare organizations need to better understand the factors leading patients to make hospital visits in the first place and then effectively treat those issues in the first visit. Predictive analytics allows healthcare organizations to do just this by managing chronic conditions, engaging patients in their own care, and identifying factors that make readmission likely. Perficient […]

Introduction Regarding to “NullReferenceException”, which is familiar to most of the programmers, because it is very likely to occur “NullReferenceException” when accessing a nested object property. For instance, opportunity.Contact.HomeAddress.Street, if any of the opportunity, Contact or HomeAddress is null, it throws “NullReferenceException”. This blog, will introduce you a easy extension method, which can void redundant […]

On the heels of the Bank Innovation conference we attended, the Financial Services team has published a new Perficient Perspectives, a series of informal Q&A sessions with our subject matter experts on hot technology topics and industry issues.  In our new Perspective, “The Future of Bank Product Strategies: How Creating a 360-degree View of the […]

In year of 2012 I was involved in a datastage ETL project to load data from external flat files, as well as Oracle CRM data source into Teradata data warehouse. Comparing to other ETL appliances, IBM Datastage offers much flexible stages, components to accommodate each type of data feed business requirement. I would like to […]

Last week while at the annual Microsoft Dynamics Convergence in New Orleans (with 10,000 other people- partners, clients and MS employees) there was a great session on Advanced Analytics for Microsoft Dynamics CRM. Many of these options have been available for the last few years since the release of CRM 2011 (both online and on-premises) […]