Customers

With more than 70 business models serving 1500 active users and 600 reports this high availability solution serves as the Enterprise BI solution for the largest retail company in Israel.

Shufersal has 250 branches in Israel under 5 different brands, distributed all over Israel. It also runs a Large Ecommerce operation “Yashir” for selling to the end customer Via web.

The Project : This state of the art implementation included a complete redesign and rebuild of the enterprise BI solution for Shufersal

Business scope: A complete picture of all business aspects of Shufersal. The business models built enable a variety of business users in the organization to manage, analysis, review and control the entire business domains of the organization.

Partial list : Sales,Inventory,Loyalty,FInance,HR,Energy consumption

Technology: MS SQL Server 2008 as DWH, Analysis services 2008 R2 as Olap engine , customized Panorama 6.2 as user interface .
Full support for High availability was implemented using MS Cluster services.

Advanced business analytics solution over 700 Petrol stations and C-Stores distributed in Europe.

This high-end solution enables decision makers a comprehensive , near real time analysis of Sales & Finance domains .

The project :  Together with our business partner Ratio ltd  we provided to the customer a complete picture of all aspects of Texaco and BP site operations (Petrol, Restaurants ,Hotels ,Car wash  & Bakery) in Belgium ,Luxemburg ,Netherlands  & France.

Main users : Executive management, analysts . ~ 75 users.

Main features of the solution  :

• Actionable analysis for every critical aspect of the business.
• Analysis & Monitoring for sales, staffing, daily management, CRM, and finance
• Fuel Cards fraud analysis

Technology  : SQL Server 2008 R2 as DWH infrastructure and BI suite. Intellysis as user interface. Tokheim & Envoy as source systems.

Azerfon is a major player in the Telco  Business , Azerbaijan.

This was a pure design project we have delivered.
In this project we were working closely with top decision makers  to define and design business needs and modeling for an enterprise DWH.

We have designed 15+ comprehensive models for various business areas such :

CDR Analysis, Charges, Payments, Balances, Subscribers, Geo Spatial analysis, Churns, Activations, Stock Balance,  Stock Movements, Network statistics.

iMingle – real time BI solution for Facebook app startup .

iMingle is a fast growing startup in the internet/Consumer business.

Working with  top management & company’s investors we have created  Big data & analytics solution with focus on business value in the following domains : acquisition ,activation, retention, referral & revenue.

Volume : millions of users and billions of impressions monthly.

Data load : Real time

Technology : SQL Server 2012 BI suite

Highly complex BI implementation over CRM & Operations using advanced technologies.

Roche is  a Swiss global health-care company that operates worldwide under two divisions: Pharmaceuticals and Diagnostics.

We have designed and implemented complex BI models over CRM & operations domains serving dozens of users operating in the iL site .

Technologies used : Informatica, SQL Server DB 2008, SSIS 2008, Oracle 11g  ,QlickView

John Bryce hi-tech college : BI trainings
John Bryce hi-tech college is the top IT college in iL with more than 500 courses in Professional IT, Computerization and Management Skills .
SenseOr professionals are leading the MS SQL server & BI department in this college.
We instruct various MS BI courses bringing our hands-on experience back to the community as certified trainers.

National insurance institute of Israel – MS BI OEM Project
Israel’s National Insurance Institute provides a wide range of services to the israeli people in health insurance, unemployment payments, monthly child supplements and more.
This unique project was focused on building an OEM MS BI solution integrated into an operational web application for this institute.
This web application directs institute’s personnel all over Israel in their daily tasks.
It is a fine example for how BI can serve an operational process in an organization.
Technology : MS BI, OEM solution