With our recent client engagements in which the organization is implementing one or more master data management (MDM) projects, I have been advocating that a task to design a demonstration application be added to the early part of the project plan. Many early MDM implementers seem to have taken the
When we talk about digital customer services, it’s all about creating online self-service capabilities for our customers. This is great for everyone! We’ve made it easy for the customer to get what they need; it’s cheaper and faster for organizations to deliver the service to the customer. Need a copy
The underground economy is driving a hole in the collection of income taxes, social security, unemployment and Medicare to the tune of hundreds of billions of dollars annually within the United States. Yet significant questions remain about how big the problem is, as well as what should be done about it.
The Lancaster Centre for Forecasting is seeking Master Student Projects in Forecasting, Data Mining, or Analytics for summer of 2015. Projects normally run from mid-May to mid-August, with reports issued a few weeks after. These projects are a cost efficient way for a company to carry out analytical work by
In an era long gone by (actually not so long ago) we all interacted with computers via terminals to a mainframe or minicomputer systems. Sometimes, you had to book a slot for when you could access and exploit computer resources. The user was subject to interrupted connections or very poor
It’s that time of year again, and I have retail on my mind. Not only because we’re reaching the peak of the holiday buying season, but because we at SAS are getting ready for one the biggest events on our calendar, the National Retail Federation tradeshow in January. As I’m
How does Santa keep track of everything on his big night? I can't confirm or deny that he uses SAS software -- but if he does, it would look a lot like this! ... A couple of years ago, I blogged about a prototype dashboard that I wrote for Santa. This
I have a rule – any conversion or upgrade will require the creation of a decommission plan. A decommission plan should include the following: A list and definition of each database, table and column (source and target). A list and definition of each of the current programs in use (you
Another great year is winding down. Ed and I are taking a little time off to enjoy the season and our family. I thought I'd share the latest portrait of me. (You already knew I was gorgeous; now you also know what a good sport I am.) So, from
As a follow-up to my previous Christmas blog post, Twas the night before big data, I give you ... Bayesian network, the directed acyclic graphical (DAG) model ( yeah, yeah, I know it doesn’t quite have the same ring as last year’s title, but you'll recognize the tune) You know Linear and
The physical data model should represent exactly the way the tables and columns are designed in the in the database management system. I recommend keeping storage, partitioning, indexing and other physical characteristics in the data model if at all possible. This will make upkeep and comparison with the development, test
Last week, I had lunch with a friend who I hadn’t seen in quite some time. As I approached the table, I noticed my friend busily writing away in her journal. With a fantastic smile, my friend shared that she was writing down her personal and professional goals for the
SAS will again be participating in the Allied Social Science Association annual meetings in January. This year the event will be held in Boston, and conference organizers expect more than 12,000 participants from a variety of backgrounds, including economics, finance and many other social sciences. One of the primary functions
We've explored data provenance and the importance of data lineage before on the Data Roundtable (see here). If you are working in a regulated sector such as banking, insurance or healthcare, it is especially important right now and one of the essential elements of data quality that they look for
.@philsimon on an important question.
For a long time, master data management (MDM) practitioners boasted about their ability to build a 360° view of customers by aggregating and proactively managing information coming from various business applications such as CRM systems, ERP applications, and other operational systems. But was it really a 360° view? What about
It is clear from many of the comments arising from this year’s Insurance Times Broker Service Survey that brokers value underwriters who are open-minded and willing to adapt wordings and terms where possible to accommodate clients’ individual needs. They also value a close dialogue and partnership with underwriters who are
El costo de no ser relevante en el mercado puede ser la pérdida de un cliente. Los clientes esperan interacciones personalizadas y las organizaciones deben tener en cuenta que, factores como la calidad del producto, la facilidad y velocidad de adquisición, ya no son suficientes. Entonces, ¿cuál es el siguiente
‘Tis the season. While the season means different things to different people, its most common theme is people buying things for people. Things that become presents when they are covered in wrapping paper. Two retailers have been running television commercial campaigns this season about how presents are wrapped. One campaign
I recently posted an article about self-similar structures that arise in Pascal's triangle. Did you know that the Kronecker product (or direct product) can be used to create matrices that have self-similar structure? The basic idea is to start with a 0/1 matrix and compute a sequence of direct products
Well, Analytic Hospitality Executives, the year has once again flown by, and here we sit just before the holidays looking back on 2014, and figuring out what it all means for 2015. I traveled even more than usual this year (if that’s even possible), spending a significant amount of time
The impact of mental illness on individuals, families, the health system and even the economy is broad and significant. In this, the latest post in my mental health series, I’d like to talk about what can be done to help. Prevention and early detection are just parts of an integrated
I have a question --- do we need a logical data model for a conversion? Here are my thoughts. I believe the answer is yes if the conversion has any of the following characteristics: The target application is created in-house. This application will more than likely be enhanced in the
Flexibility and nimbleness are terms synonymous with small and mid-sized businesses. They have the ability to react quickly to changing market conditions as they are made aware of them. Traditionally these businesses have lived in the world of spreadsheets - and why not? They are easy to use, very affordable
In the last post we looked at the use case for master data in which the consuming application expected a single unique representative record for each unique entity. This would be valuable in situations for batch accesses like SQL queries where aggregates are associated with one and only one entity record.
Every time I pick up a new article about analytics, I am always disappointed by the fact that I cannot find any specifics mentioned about back-end processing. It is no secret that every vendor wishes they had the latest and greatest parallel processing capabilities, but the truth is that many
Data. It's everywhere. It can reside in many places through replication, accessibility needs or infrastructure costs. For reporting, that same data can be structurally changed (denormalized or aggregated) into additional reporting and analytic data repositories. Over time, new sources of enrichment of that data become available through traditional data sources
Like most programming languages, the SAS/IML language has many functions. However, the SAS/IML language also has quite a few operators. Operators can act on a matrix or on rows or columns of a matrix. They are less intuitive, but can be quite powerful because they enable you perform computations without
The first sensors appeared many decades ago, and have been around for quite some time in various forms, even though they’ve really only entered the popular vocabulary over the past few years thanks to the Internet of Things. How do sensors work? A sensor detects events, or changes in quantities, and
The idea of "management by walking around" has been around for a while. First brought to prominence in Tom Peters and Robert Waterman’s best-seller In Search of Excellence, the concept is that managers get out of their offices and meet employees in their work areas to get a sense of how
