Customer Analytics Retail
With a large portion of its revenue being generated online, this retailer needed to better understand the buying trends associated with its e-commerce application. The legacy clickstream technology made it difficult to verify the accuracy of report results. In addition, the client wanted to integrate additional data for cross-analysis. Kinetic helped them build a data model and integrate the key elements needed to access mission-critical information. Today, business analysts are running large trend analyses and funnel reports that can highlight exactly where a drop off in purchase happens. In addition, the solution is highly maintainable by one DBA. Technologies include Oracle 10, Solaris, Cognos and KETL.
A global manufacturer of wireless and mobile computing products was entering the direct market with a new set of business requirements. Its managers needed insight into key business metrics such as campaign response, product affinity and customer purchasing history. Using MicroStrategy, Kinetic built and maintained an analytical solution that integrated Web Traffic, Sales and Fulfillment Data with advanced OLAP reporting.
Kinetic's solution allowed them to test and validate market strategies such as pricing and discounts, and execute only those initiatives that demonstrated success. In addition, it gave the client the ability to immediately respond to marketing campaigns, improving product assortment both on and offline. It also improved promotion effectiveness by allowing analysts to see the direct affect on sales from quarter to quarter.
Internet Software and Services
As a provider of online music subscriptions and services, the client knew that understanding customers' listening preferences was essential. However, they had no insight to customer behavior. The client wanted to increase visibility into subscriptions and music interest, to better understand promotion effectiveness over time. Kinetic created a data warehouse that would provide a clear view of their customers' musical tastes and desires focusing on user site activity and tracking, the ability to enhance communications and relationships, and have flexible reporting.
Data Warehouse Internet Information Provider
With unsuccessful data marts and critical reporting needs, this global online network company engaged Kinetic Networks to assist with rapid design, architecture and development of data marts. Strategically, Kinetic Networks implemented best practices including standardizing ETL procedures, improving data design and data modeling processes, streamlining business intelligence infrastructure, and improving operational efficiency. Kinetic Networks also assisted the client to ensure SOX compliance for revenue reporting systems with their MicroStrategy business intelligence tool.
Internet Software and Services / CRM
A global customer relationship management organization had an existing data mart and needed to scale it to an enterprise solution. The company needed a firm with strong expertise in core data warehousing principals and methodologies coupled with expertise and leadership in integrating and deploying the Business Objects XI suite, because one of the largest requirements included SEC reporting compliance. Kinetic Networks was selected to lead the planning, re-design and development of the multi-phase enterprise data warehouse. Kinetic Networks implemented best practices, standardized development processes, streamlined reporting, and increased security of sensitive data while improving operational efficiency.
E-Commerce / Retail / Manufacturing
A leading high technology group was entering the direct market with a new set of business requirements. Its managers needed insight into key business metrics such as campaign response, floor salesperson performance, product affinity and customer purchasing history. Speed of delivery and cost were crucial due to potential costs of a long and expensive rollout. Using MicroStrategy, Kinetic built and maintained an analytical solution that integrated Web Traffic, Sales and Fulfillment Data with advanced OLAP reporting. Kinetic's solution provided workflows used to create product promotions and kits, decide on advertising content and placement, and plan compensation of the call center sales staff.
Managed Resource Augmentation Financial Products and Services
This financial services client needed to grow their data mart into a robust data warehouse that could support their Marketing team's need for data into the future. The goal for Kinetic Networks was to handle incremental work-load and provide industry best practices and methodologies. Kinetic Networks' efforts led to assembling a cross-functional team to over 42 projects over a 19 month engagement. The client benefited from an advanced data warehouse with a new level of maturity, established processes and procedures, data modeling for accurate web activity and high usage on large volumes of data, incorporated Data QA during load processes to avoid corruption, enhanced user adoption, and development of MicroStrategy best practices and advocacy.
Internet Information Provider
Because of its growing size, this world-recognized internet information provider needed to backfill its information technology teams to create a comprehensive solutions team. Because of hiring complexities, the client decided to find highly skilled temporary resources to complement the missing members in the desired team structure. Kinetic has been providing Managed Resources Augmentation to this client for over two years in a variety of business units including IT, HR and Sales. Types of roles include full-life cycle including project management, technical leads, ETL developers, and front-end developers. Types of work have included ETL, data modeling, business intelligence, object migration, post-production support, project enhancement and user acceptance, testing and release. Technologies include Netezza, Oracle, KETL, Python, SQL, and MicroStrategy.
Internet Information Provider
A leading interactive media company manually collected data and needed to automate the presentation and distribution of their premier partner reports. The Kinetic team was engaged to supplement the existing team and design a data model that would support the required attributes and meet performance needs. The team designed and created the reports in MicroStrategy Narrowcast Server for the client. The solution is now entirely automated and triggered off of data load completion.
Master Data Management and Customer Data Integration Networking and Communication Devices
An information technology company that designs and sells Internet Protocol network products and services was having problems providing accurate and timely reports for the enterprise. The client believed that the root cause stemmed from the lack of a Customer Master. This was due to the fact, that the company maintained customer data in many separate non-integrated source systems. Kinetic Networks was engaged to perform a customer data integration (CDI) assessment. The assessment uncovered multiple opportunities for creating an enterprise customer master and identified the underlying business value it would deliver. Through extensive interviews with key business stakeholders, analyzing current applications that collect customer data and understanding the technical aspects of the Business Objects environment, Kinetic Networks was able to develop a solution architecture that; addressed the issues identified, supported the continued growth plans of the client and provided quantifiable benefits. An in-depth analysis of one current business process revealed an opportunity cost in excess of $12 million a year, with the implementation of a Customer Master.
Reporting, Analytics and Dashboard Interactive Media
A leading interactive media company manually collected data and needed to automate the presentation and distribution of their premier partner reports. The Kinetic team was engaged to design a data model that would support the required attributes and meet performance needs. The team designed and created the reports in MicroStrategy Narrowcast Server for the client. The solution is now entirely automated and triggered off of data load completion.
Financial Products and Services
This diversified financial services company wanted to offer customized campaigns and effectively manage local success. Rather than develop a full end-to-end solution through a CRM purchase, this client wanted to solve its specific problems and build a custom solution tailored to its needs. The team defined a repeatable process for loading the data, defined the business reports, developed a user-friendly dashboard for the program managers and ensured the methodology was based on scientific method of marketing and test groups for statistical significance in the results. Kineticís solution was seamless and provided the business users the information they needed with complete transparency to the complexity behind the scenes. Technologies included Teradata, Ab Initio, MicroStrategy and custom web data entry through ASP.net.
Electronic Retail Payment Network
This credit card company needed to report on fraud activity globally. The goal was to guide the regions through a set of analytical steps based on centralized intelligence how best to identify signs of high risk issuers and merchants. Large volumes of data made flexible reporting, particularly at the transactional level, a challenge. Kinetic Networks approached the project by designing a data mart to support the bulk of the application. In addition, a set of dashboard storylines were created to help regions navigate the Fraud data. Visualization was used in the form of ranking, alerts, graphs and color coding to highlight abnormal activity. Kinetic Networks' efforts resulted with an improvement on response times by aggregating data where possible and streamlined MicroStrategy application deployment for similar projects including reporting parameters, roll-out and licensure cost saving considerations.
RAXA™ Sensitive Data Governance Discovery - Financial Products and Services A market-leading financial institution worried about data proliferation and who had access to sensitive information. While the organization had undergone business process reengineering to reduce the transparency of sensitive data, they needed to verify the processes were working. Kinetic Networks used RAXA™ to provide data discovery audit. Reports included charts that outlined the highest areas of risk. This audit showed that the new processes were insufficient and paved the way for more improved processes to be developed.
De-Identification -Financial Products and Services A major financial services firm uses a data mart to analyze customer interaction with its online system. The data feeds contain confidential information, which causes risk of exposure. Kinetic Networks implemented the sensitive data solution to dynamically find and obfuscate the sensitive data fields. The solution converts data such as sensitive social security numbers to alternate values, yet maintains the contextual relationships of the data and retains its integrity. This allows data from different sources to align when brought together for analysis.