Customer Relationship Management and Business Intelligence

CRM(Customer Relationship Management) {9}

The Customer relationship management (CRM) is about the management of the clientele, their records and their relation and to use this data to further develop the customer relation policies and management decisions. Basically the CRM is the integration of people, technology and the business process in the quest to protect the existing clientele and provide opportunities to further enhance the circle of customer’s satisfaction. According to the company Arvato a leader in CRM, “develops and operates customer clubs, customer loyalty programs, and individualized bonus programs for end customers and business partners, as well as carrying out special promotions and other personalized incentive arrangements.” So in the quote above the company states that without their CRM they would not be able to achieve customer clubs and loyalty program. CRM is the reason why such things as flyer miles and credit card points exist. The CRM is the catalyst that provides useful help about the customer and the business dimensions that is defined by the customer reviews and satisfactions. This useful information provides highly useful insight about the customer and their behaviors. This in turn helps the marketers establish their target audience and such.


Data Warehouse {2}

Data Warehouse

Data warehousing has been evolving since 2008 to analytical architecture that includes data marts, ETL, near line storage, exploration warehouses.

The SQL Server has also evolved since started with small amounts of data on a personal computer with basic functions until now that serves mid-size and large amounts of data for warehousing and it is one of the preferred technology platform for advanced data warehouse.


Comparing your site performance using Competitive Analysis Tools {5}

Today, companies are more competitive than ever and with the e-commerce boom companies are constantly competing to be on top. This is when competitive analysis tools come to play. What is this mysterious thing called competitive analysis tool? It is an application that helps compare your company with the competition. Well, what are we comparing? We are comparing the keywords used, how our site structured, to have some kind of social media presence and many, many more. Later, I will list some popular websites that companies use to stay on top of the competition. It will allow companies to see where they stand and whether to change certain tactics to either get ahead or to stay ahead. There are many advantages as well as some disadvantages. It can put companies in a very risky scenario that could prove costly, but the benefits outweigh the negatives.


Designers Must Do the Modeling {2}

In his article Designers Must Do the Modeling, which was published in IEEE Software , Volume 15 Issue 2, Brian Lawrence enunciates on the fact that designers for database, or any other project, must do the modeling. Lawrence defines the stepping stone as figuring out the customer’s problem rather than figuring out requirements for the project. In his logical breakdown, Lawrence cites ERD models as only an output of the requirements process which will dictate database  design later on in the process. He pursues this opinion with another, saying that producing the ERD diagram (or whichever type of diagram you may be working with) has the benefit of allowing ourselves to understand the customer’s problem better so we can design better solutions. Because the designers have to produce the requirements model, Lawrence embraces the not-so-popular opinion that the designers themselves are the owners of the model.  Citing a quote by Dwight Eisenhower, the author embraces the planning process over the actual plan. To further reinforce this statement, Lawrence says that managers must help persuade designers to understand that they must model requirements – no matter if the designers see it as their duty or not. Similar to the statement of “Learning by Doing”, Brian Lawrence embraces a brilliant model in saying that it is during the planning phase that we learn the most, not in the implementation of the plan. Personally, I agree with this worldview because I have experienced the  same euphoria myself. When I was younger, around 11 or 12, years old I would sit down to learn HTML as a hobby (yes, HTML was my hobby). Although my websites churned out to look like absolute trash and functioned on a pretty depressing level, in the process of research, working with clients, figuring out bells and whistles, I was able to generate a more holistic understanding  of what I was learning and still retain that knowledge today. On these terms, I agree that the designers – the individuals who actually work with the client to figure out their problems and solve them – are the people who should create the requirements needed for their projects; in our case: a databaase. Lawrence, B. (1998). Designers must do the modeling. Software, IEEE, 15(2). Retrieved from

Big Data and Language: How do they relate? {Comments Off on Big Data and Language: How do they relate?}

In an interview between and Martin Wattenberg, a mathmatician and computer scientist at IBM’s Watson Research Center in Cambridge, Wattenberg expresses the importance of “Big Data”. Wattenberg specializes in large texual data sets, meaning that he focuses on terabytes of language. peruses Wattenberg’s brain in inquiring why is he so captivated by reading such data sets – Wattenberg points out the importance of language. Language is one of humanity’s core mediums in which we are able to read, explore, and encode our identity as human beings, much like the blog post I’m typing right now. For example, one may have a database in the petabytes of words, literature, books, and yet we can see that even twelve words from voltaire, and example given by Wattenberg, can hold a lifetime of experience. And so when there are petabytes upon petabytes of information to analyze, Wattenberg has created a visual representation of everyone’s favorite quick-information website: Wikipedia. The visual representation assigns a color to each word in the dictionary and then maps out the usage amount of each word – this helps Wattenberg analyze data easily.


QR codes used for quick access to health information {2}

In an article from, the author talks about emergency personnel using QR codes to quickly get access to health information from people. A start up company in silicon valley, LifeSquare, has started implementing this technology with two emergency response agencies in Marin County. They will be using QR codes placed on stickers so that emergency workers can get quick access to information such as any previous injuries and if allergic to any treatments or medication. Due to privacy concerns, users of this new technology must sign up on their website to be able to get a QR code. LifeSquare hopes this will improve on a previous method of retrieving such information that was written on paper. Now it can be easily accessed from a database and possibly reduce the time it takes to take the patient to the hospital. This is a great technology to use. It is cheap and efficient. I see that people will adopt this and register their information with LifeSquare and their maybe some discounts added to patients insurance premiums by using this technology.


Benefits of RFID’s in Libraries {4}

In an article found in the Faulkner Information Services database, an article written by James G. Barr explains how RFID’s help libraries run and operate their services, staff and other tasks. An RFID is a either a chip or tag that contains data thats transmitted wirelessly to a reader in range. It is more efficient than conventional barcodes and can also be a great theft deterrent for books and other assets. For libraries, it is one of the best information systems solution for their dynamic inventory and tracking their large amount of assets. TAGSYS is a specialized company who provides the tags, readers and software needed. They not only provide for libraries but also pharmacies and textile services. Some benefits from these tags are the data contained in them can tell what the author, title and genre of a book and also keep a more consistent inventory since tags can be read through covers and pages. One big benefit is loss prevention.


Data Mining & Tax Evasion {3}

The article I chose touches on how tax authorities are challenged with collecting and identifying businesses that do not pay their correct taxes. Believe it or not, businesses and everyday people cheat on their taxes, whether it be for a higher refund or to elude from paying more money back to the government. Of all agencies, the IRS is stated to have limited amounts of resources when it comes to detecting fraud. To try and combat this, a screening system using data mining techniques was created in order to try and “value-added tax” reports, or any other type of suspicious activity. Once these particular activities are recognized, then they can be further audited and have proven effective.


FBI Wants More Power {5}

For this weeks post, I read an article by Sara Yin titled “Report: FBI Wants to Wiretap Facebook, Twitter, Google”. The article states that the FBI wants some legality to help them expand their surveillance capabilities to cover a good portion of the Internet. The FBI wants “…social networks, e-mail providers, and other peer-to-peer services to become “wiretap-friendly”…” (Yin, 2012). Some of these services include: Twitter, Microsoft, Yahoo, Facebook, Google, Apple iChat, AOL Instant Messenger, GMail Chat, and XBox Live’s in-game chat. The FBI wants to include these surveillence into their already established “Communications Assistant to Law Enforcement Act (CALEA). CALEA was established in 1994, where cell phone operators and broadband network providers “…must have built in backdoors giving law enforcement agencies direct access to user data during warranted investigations. ” (Yin, 2012).


Oracle’s Rightnow CX Suite {Comments Off on Oracle’s Rightnow CX Suite}

According to Oracle, the global CRM market will surpass 18.2 billion in 2012. It was anticipated that the acquisition of Rightnow enables Oracle to expand its use of Cloud Computing but Oracle has recently unveiled a new product roadmap for end-to-end customer experience. Rightnow has spent fourteen years on building customer experience products and brings a well refined set of applications to empower Oracle CRM tools. Oracle’s CX Suite includes a wide array of customer experience products and will now be able to offer “the best, most complete, and most advanced solution in the world,” according to Oracle President Mark Hurd. According to Rightnow’s survey, eighty-six percent of customers would choose not to do business again because of poor customer experience. Companies embracing CX as a strategy have potential to see ten to thirty percent reduction in contact-center labor costs, increased customer retention, and accelerated customer acquisition.