AdSense

Sunday, 26 January 2014

Pros and Cons of Gmail displaying images in your emails

The news from GMail is that the Google's Gmail service will finally show images by default in emails. This has been done by serving all the images users receive on its Gmail's proxy servers, instead of serving them from external host servers. 01

Usually the external images are not secured and hence are not displayed directly in emails. By hosting it on GMail's proxy server, GMail is making sure that the images are virus free.

In a post on the official Gmail blog, the company said: "Your messages are more safe and secure, your images are checked for known viruses or malware."

The new Gmail functionality will begin rolling out Thursday to the Web; Gmail mobile apps will get an update early next year.
Here is an interesting thing I would like to check on - the email marketing teams usually use images to track if the email was read by the user or not. Now that the images will be on GMail servers and displayed to user by default, the tracking may be more correct.
Earlier, I believe, that without the click on "Display Images Below", it would have been difficult for trackers to check if email was actully read or not on GMail.

Also, you can change the setting to "Display Images Below" option by using General Settings of GMail.
00

Saturday, 25 January 2014

CLT20 2013 Twitter Analysis of League

CLT20 just concluded with Mumbai Indians winning the trophy. Congratulation!!!! Mumbai take the double of the IPL and Champions League title the same year. Chennai Super Kings did it in 2010.
Sachin Tendulkar completed 50000 Runs in Cricket... AWESOME!!!
Here is how the Twitter world was discussing the different topics in Champions Trophy T20 this year (2013).

Click here to find a graphical picture of the tweets during CLT20 2013. Total list of topics are here.
This is our very own Social Media Bigdata project using Twitter Firehose - Live Tweets. There were about 300 to 1000 tweets analysed Live per second during the matches.
TWITTER ANALYSIS OF CLT20 LEAGUE 00

Babagyan CLT20 2013 Analysis

This is How it works at the technical level.

The twitter data is loaded in to the Analytics server by using Python program. This ocean of tweets is kept into the BabaGyan Gyankund (knowledge base) for further analysis.
Then another program (R with Python) scans the GyanKund tweets and uses its Intelligence to find the relevance and then sends it to BabaGyan.com database and web server.
The database is then accessed by BabaGyan.com's Analytics page to show analysis results in text and graphical format.

Thursday, 23 January 2014

ETL BI BigData Past Future

ETL BI BigData Past Future 00

Earlier, many a man years ago, there were only financial application that were used to perform transactions and log data into the database. Then came the applications to cater needs of Industries and hence begun the big volume data storage, backups and history in form of data. It was prominent even in case of financial applications, but not so visible because Financial firms were not as BIG as Industries.
The applications for industry got the term such as ERP.
Now, arise the question, why to store loads and loads of data? Can that be brought to some use? and How? This was the inception of Business Intelligence and an obvious process of Extraction Transformation and Loading (ETL).

This has, from a long time, resulted in many technologies and also jobs in the field of ETL and BI.

Now, after being a niche field for so many years, ETL + BI field has entered a transformation with addition of Big Data compliments.
The transformation has been the result of many things - Internet, discovery of various data sources in various formats such as machine logs, social website data, network logs. Then, there has been huge progress in the field on in-memory database processing and cloud computing making analysis of unbelievably huge data possible.

What was ETL and Bi is now ETL + BI + BigData + Data Mining + Data Analytic + so on and on.....

Here is a list of technologies - incomplete list but a list never-the-less
1. Technologies such as SAP BW (SAP NetWeaver Business Intelligence), SAP BO (SAP Business Objects/ Business Intelligence 4.0), Xcelsius, SAP HANA from ERP leaders SAP,
2. Oracle reports, Oracle Business Intelligence, Oracle forms, Oracle WareHouse Builder from database leaders Oracle
3. Infosphere DataStage, Cognos from mighty IBM
4. SQL Server services - SSIS. SSRS. SSAS as a part of MSBI from Microsoft
5. TeraData, SAS, Ab Initio, Microstrategy,
6. Latest in the area - Tableau, QlikView, Spotfire (Tibco), Sybase IQ, Siebel,
7. Technologies like R systems, Python, Php - all are also becoming a part of new form of ETL + BI + BigData

Soon, you will see some more projects demonstration on BabaGyan.com on BigData, Data Mining, Text Mining and many more. Stay tuned.

Tuesday, 21 January 2014

Tool: Daily Expense Tracker in excel - free to use and share

Tool: Daily Expense Tracker in excel - free to use and share How many times it has happened that you wondered where all your money went? Where did you spend all of it? How frequently do you take out cash and spend it even more frequently and immediately.
All you wanted is to know a trend of your spending so that you can plan and if necessary, control it.

There are many sites and phone applications that are available for this but not all are easy to use.
Every application has its own method of usage - some ask you to create and define bank accounts while others just don't seem to be secure. All you really want is is place where you can mention how much you spend and earn and keep a track.

Here is an option for you in our very own EXCEL spreadsheet by BabaGyan.
All you have to do is update the rows with your account transaction - both credit and debit. Also available is a Cash sheet where you should enter your cash transactions. The ATM withdrawal transaction from Account tab is added into Available Cash in your Cash tab. This way, you don't need to worry about Cash Credits at all.

There is also an optional Forecasting tab. Here you should list down all the routine transaction like Rent payment, Fuel expenses, EMI installments, etc. This will help you predict how much you can save at the end of the month. If you need more to save, just spend less - at least try for it.

In short - Update the cells in Orange before starting to use the sheet and daily update the cells in Green.

Good luck in using this. Free download and share. You can provide your feedback or queries on our Contact page or comments on this post. Here is Expense tracking Month Excel file to download.

Sunday, 19 January 2014

Ways to create a website

Ways to create a website - Parts of a Website and alternative ways for each part

This is a general question that comes to minds of anyone who want to create an online portfolio or someone running a business and wanting to take it to the web or even to any person curios about Internet.
What are the ways in which websites are made or can be made?
00

To answer this in most simple way - Many!!! You probably guessed it too. And Yes!! BabaGyan.com helps you in each of these ways of website development.

Coming back, do not worry, I am not going to stop with this answer. I will brief through some of the most popular and some of the most advance ways of website creation.

There are basically 3 parts of any website - the domain name, the user interface and the server processes. The domain name is the name of the website such as BabaGyan.com which is purchased by any Registrar. The User Interface and server processes can be separately programmed and deployed on a Website Host.

Then comes the User Interface which can be developed in many options too - like HTML, HTML5, HTML with CSS, Flash, HTML with .Net, HTML with Java, Javascripts, etc.

And then comes the Server process which run on something popularly known as a webserver in combination with a database server optional. The complexity of the webserver depends on the complexity of the things that website should perform.

These complexities provides many alternatives of Host for your website. Host is a computer/server which stores your User interface and server files and executes them for you and eventually makes your Website LIVE.

There are many big and small players in hosting and domain registration. Cost and Complexity drive the choices. Most simple web hosting can be a blog which is mostly free. Most complex kind of hosting can be webserver using cloud computing technology.

Examples of blogs are BabaGyan.com/GyanKund and blog technologies are blogger.com and wordpress.com and many more. Web hosting is also provided by many free as well as paid web hosting companies like GoDaddy.com and BlueHost.com. Whereas, Amazon Web Services aws.amazon.com and Heroku.com are examples of Cloud computing technologies which can be used for website hosting too.

Friday, 17 January 2014

LifeSaver: Business Intelligence Projects - Success and Failures

When we talk about business intelligence, we talk about how a certain project was hugely successful while some did not even walk on its feet. We analysed the situation and found few known-unknown combination of things.

Commonly, companies and CIO offices complain about many stuff during and for a BI implementation. We think the top 3 are:

  1. Data - less or more data, accessible or not-so-accessible data
  2. reports and dashboard that are slow in response and probably not suited for the need
  3. IT specific analytics tools which needs training at technical level
Even with these complaints, BI has been a top implementation priority for many years now. Organizations do recognize the value of data and analytics for decisions and outcomes.
So, there is a big need that the BI initiative does not stop and be a part of failed projects. Question is - how can you ensure this?
Answers is not specific to BI — it is same as any other project. For BI, it is even more difficult because the projects are more difficult to kick off and leap. Plus there are many examples on the list of failed BI projects. So, ensuring BI project's success is not just necessary for companies but also of immediate importance.

I always believed that the business have to drive the initiative for BI projects as they are the best judge of its usage. IT, needless to say, plays big part too. So, it ends up being a balance between the two.

We can come up with some major points as necessity for success of BI project
  1. Start from business and keep business in business intelligence
  2. Independence from IT - self service by business a priority
  3. Data as Good foundation
  4. Tools suitable for organization and people
  5. Train the users and prepare them for independence and change
Along with these, some things needs to be avoided too like AVOID
  1. IT-led - which seems easy but often ends in failure due to lack of business inputs
  2. Too strict or no process
  3. Using governance in everything
  4. Shedding responsibilities if external partners are brought to help
  5. Too much focus on development using tools
  6. Ignoring user training.
Hope this helps to achieve success in BI implementations.

Tuesday, 14 January 2014

LifeSaver: Differences between UDT and IDT

Differences between UDT and IDT - universe design tool and the information design tool from SAP Business Objects (SAP BO) version 3.x and 4.x.

The information design tool or IDT is a new modeling tool from SAP for the semantic layer that enables you to play with metadata from relational and OLAP sources, and to create and deploy SAP BusinessObjects universes.

The old Business Objects 3.1 Classic universe features available in Universe Designer have been redeveloped and incorporated in the information design tool.

This post will help you in finding the options in IDT which you must be already very familiar in Universe Designer. Thus enabling you to migrate from BO 3.1 XI to BO 4.0 with no issues.
Start using IDT based on your expertize of Universe Designer.

Universe design > Quick Design Wizard
No similar functionality

Relational universe creation workflow:
1. Click File > New > Project.
2. Click File > New > Relational Connection.
3. Click File > New > Data Foundation.
4. Click File > New > Business Layer.

OLAP universe creation workflow:
1. Click File > New > Project.
2. Click File > New > OLAP Connection.
3. Click File > New > Business Layer.

File > Import
Click File > Retrieve a Published Universe.
File > Export

Universe publishing workflow:
1. From within Local Projects, right-click the Connection (*.cnx) and
click Publish Connection to a Repository.
2. From within Local Projects, right-click the Business Layer (*.blx) and click Publish > To a Repository.

File > Metadata Exchange
No similar functionality

File > Parameters > Definition > Description
From within a Data Foundation (*.dfx), click Properties.
File > Parameters > Definition > Connection

Relational connection workflow:
1. Click File > New > Relational Connection.
OLAP connection workflow:
1. Click File > New > OLAP Connection.

File > Parameters > Summary
From within a Data Foundation (*.dfx), click Properties > Summary.
From within a Business Layer (*.blx), click Properties > Summary.

File > Parameters > Links
No similar functionality

File > Parameters > Strategies
No similar functionality

File > Parameters > Controls
From within a Business Layer (*.blx), click Properties.

File > Parameters > SQL
From within a Data Foundation (*.dfx), click Properties.
From within a Business Layer (*.blx), click Properties.

File > Parameters > Parameter
From within a Data Foundation (*.dfx), click Properties > Parameters.
From within a Business Layer (*.blx), click Properties > Parameters.

File > Print
From within the Local Projects view, right-click a Business Layer (*.blx) and click Print.
From within the Local Projects view, right-click a Data Foundation (*.dfx) and click Print.
From within a Data Foundation (*.dfx), click Print View to Bitmap.

Edit > Undo Action
Click Edit > Undo Action.

Edit > Find/Replace
Click Window > Find/Replace.
From within a Business Layer (*.blx), click Show/Hide Search Panel.
From within a Data Foundation (*.dfx), click Show/Hide Search Panel.

Edit > Hide Item(s)
From within a Business Layer (*.blx), right-click an object and click Change State.

Edit > Object Properties > Definition
From within a Business Layer (*.blx), double-click an object.

Edit > Object Properties > Properties
From within a Business Layer (*.blx), double-click an object and click Advanced.

Edit > Object Properties > Advanced
From within a Business Layer (*.blx), double-click an object and click Advanced.
From within a Business Layer (*.blx), right-click an object and click Change Access Level.

Edit > Object Properties > Keys
From within a Business Layer (*.blx), double-click an object and click Keys.

Edit > Object Properties > Source Information
From within a Business Layer (*.blx), double-click an object and click Source Information.

Edit > Object Format
From within a Business Layer (*.blx), right-click an object and click Edit Display Format.

Edit > Rename Table
From within a Data Foundation (*.dfx), right-click a table and click Edit.

Edit > Edit Derived Table
From within a Data Foundation (*.dfx), right-click a Derived Table and click Edit.

View > Arrange Tables
From within a Data Foundation (*.dfx), click Auto Arrange Tables.

View > Refresh Structure
From within a Data Foundation (*.dfx), click Detect > Refresh Structure.

View > Table Values
From within a Data Foundation (*.dfx), right-click a table and click Show Table Values.

View > Change Table Display
From within a Data Foundation (*.dfx), right-click a table and click Display.

View > Number of Rows in Table
From within a Data Foundation (*.dfx), click Detect > Row Count.

View > Grid Lines/Page Breaks
No similar functionality

View > List Mode
No similar functionality

Insert > Tables
From within a Data Foundation (*.dfx), click Insert > Tables.

Insert > Stored Procedures
No similar functionality

Insert > Derived Table
From within a Data Foundation (*.dfx), click Insert > Derived Table.

Insert > Alias
From within a Data Foundation (*.dfx), click Insert > Alias.

Insert > Join
From within a Data Foundation (*.dfx), click Insert > Join.

Insert > Context
From within a Data Foundation (*.dfx), click Aliases and Contexts > Insert Context.

Insert > Class/Subclass
From within a Business Layer (*.blx), click Insert Item > Folder.

Insert > Object
From within a Business Layer (*.blx), click Insert Item > Dimension.
From within a Business Layer (*.blx), click Insert Item > Measure. From within a Business Layer (*.blx), right-click a dimension and click New > Attribute.

Insert > Condition
From within a Business Layer (*.blx), click Insert Item > Filter.

Insert > Candidate Objects
No similar functionality

Insert > User Objects
No similar functionality

Insert > Universe
No similar functionality

Tools > Connections
From within a Data Foundation (*.dfx), click Connection.
From within a Data Foundation (*.dfx), click Connection > Change Connection.
From within Repository Resources, click Session > Connections.

Tools > Hierarchies
From within a Business Layer (*.blx), click Navigation Paths.

Tools > List of Values
From within a Business Layer (*.blx), click Parameters and Lists of values.
From within a Data Foundation (*.dfx), click Parameters and Lists of values.

Tools > Aggregate Navigation
From within a Business Layer (*.blx), click Actions > Set Aggregate Navigation.

Tools > List of Aliases
From within a Data Foundation (*.dfx), click Aliases and Contexts.

Tools > List of Derived Tables
No similar functionality

Tools > Query Panel
From within a Business Layer (*.blx), click Queries.

Tools > Automated Detection
From within a Data Foundation (*.dfx), click Detect.

Tools > Check Integrity
From within a Business Layer (*.blx), click Check Integrity.
Click Window > Check Integrity Problems.

Tools > Login As
From within the Repository Resources view, click Insert Session.

Tools > Change Password
No similar functionality

Tools > Manage Security
Click Window > Security Editor.

Tools > Options
Click Window > Preferences.

Window > Arrange/Split
From within a Data Foundation (*.dfx), click Insert > View.

Data Quality in ETL and BI - Reasons Impacts Solutions and Operations

The amount of Data that an organization stores and processes in the current time has increased many folds. This has also exposed the associated problems of poor quality of data. If the quality of data is bad then the information created by that data is not useful. Lot of efforts and money is being put in by organizations to improve the quality of data. 00
The Quality of data refers to the following
  • Accuracy
  • Consistency
  • Integrity
  • Uniqueness
Reasons for data quality issues:
  • Inaccurate data entry
  • No process or rules in application to validate data entry
  • Lack of Master Data Management (MDM) strategy
Examples:
  1. Phone number having values as 1111111111, 0000010100
  2. Customer Name as "ABC", "ZZZZ"
  3. Two records in a table like below:
Timothy, Kenny. 10 East Avenue
Tim, Kenny. 10 East Avenue
Impact of poor data quality:
  • Incomplete and misleading analysis
  • Increase in spending on incorrect data
  • Financial impacts when data is related to accounts and finance
  • Targeted market campaigns impacted adversely
  • Purchasing of data quality tools like First Logic, Trillium, etc.
  • Complicated ETL
  • Additional Cleansing in ETL process results in longer time to complete ETL cycle
Solutions for data quality:
  • Stringent data validations by means of rules in applications at source
  • Avoiding duplicate master entries by use of MDM solutions
  • If above not done, then using ETL process to handle data quality issues
  • Send feedback for bad data quality and correct at source, then reload
  • Maintain audit for data quality issues emerging from source systems
Data Cleansing Operations:
  • Removing invalid characters
remove extra and special characters from addresses, phone numbers, etc
  • Correcting data formats
formats for phone numbers, email addresses, etc
  • Identiying and removing duplicates
  • Building data quality audit and feedback system
record data quality in audit tables
automate process to send information of data quality to source system


Monday, 13 January 2014

Problem Solving Methodology - Technique for How to Solve a Problem

Problem Solving Methodology - Technique for How to Solve a Problem Problems are so very frequent in nearly everything - from work to personal life. Whether you are a project manager or just a team member, you are surrounded with and encountered by problems and you are expected to solve them.
It is always a feeling in mind that "there should have been some way to solve each and every problem". Apparently, there is a generic problem solving methodology - steps to follow - techniques to implement - for solving any problem. Follow the below steps and solve nearly every problem you ever face.

Step 1 - Identifying and diagnosing the problem
The real problem will arrive to the surface only after the facts have been gathered and analyzed. Therefore, start with an assumption that can later be confirmed or corrected.
Step 2 - Gather facts, feelings and opinions
What happened? Where? When and How? Who and what is affected? Is it likely to happen again? Does it need to be corrected? Time and expense may require problem solver to think thorough what they need, and assign priorities to more critical elements.
Step 3 - Restate the problem
The facts help make this possible, and provide supporting data. The actual problem may or may not be the same as assumed in Step 1.
Step 4 - Identify alternative solutions
Generate ideas. Do not eliminate any possible solutions until several have been discussed.
Step 5 - Evaluate alternatives
Which alternative will provide optimum solutions? What are the risks? Will the solution create new problems?
Step 6 - Implement the decision
Who must be involved? To what extent? How, When and Where?
Who will the decision impact?
What might go wrong?
How will the results be reported and verified?
Step 7 - Evaluate the results
Test the solution against the desired results. Modify the solution if better results are needed.

Sunday, 12 January 2014

What is Mentoring?

What is Mentoring: (Content courtesy - from a session attained in past)

“ If you would thoroughly know anything , teach it to others”
-Tryon Edwards.

The best leaders enjoy helping their people to learn, grow and succeed in their career. At times these relationships grow to a mentoring arrangement.
Mentoring goes beyond simply directing and instructing others. Mentors are advisers, teachers, sounding boards, cheer leaders and critics rolled into one.

Through mentoring you can give those who are less experienced an opportunity to improve their understanding of business practices, understand the policies, discuss problems , analyze and learn from mistakes of others and celebrate success. Leaders are expected to share their wisdom with people from other parts of the organization known as mentees.
The mentees tend to learn more quickly than they would through the normal process of trial and error.
Consider your mentoring commitment carefully – Don’t agree to mentor someone if you don’t have the time and/or interest.
00

  • Be clear how much time you are able to give to mentoring relationship.
  • Look for informal as well as formal mentoring opportunities
  • Consider whether your company would benefit from a formal relationship or is it done informally
  • It takes time to develop the relationship . What skills abilities , or knowledge needs improvement
  • Decide frequency of meetings
  • Notice of cancellations
  • Confidentiality
  • Topics that would off limits
  • Establish a pace that is reasonable
  • Don’t try to download your knowledge and experience all at once Remember you did not learn everything all at once
  • Keep your mentoring discussions focused on relevant goals and challenges that your protégé (protege) is facing, learning is often most effective when delivered just in time
  • Be accessible
  • You may choose weekly, biweekly or monthly meetings
  • Establish parameters for when you are available for consultations by e-mail or voice mail between mentoring sessions
  • Offer your own ideas based on your experience but don’t expect that your mentee would necessarily do things the way you do it
  • Encourage creative individual thinking
  • Be an encouraging confident
  • Encourage your protégé or mentee to aim at high standards and push him to set up challenging goals. Raise the bar when you feel they are ready
  • Balance praise and constructive criticism
  • Help protégé to do analysis but remind them that mistakes are part of learning
  • Treat your discussions as confidential as possible. Respect the trust of your protégé
  • Acknowledge and celebrate success
  • Don’t give all the answers
  • When protégé asks for your help with a problem, ask him to suggest few solutions. Encourage discussions and exploration of various courses of action, raising any significant concern or points your protégé has missed
  • Influence your protégé to take specific direction only if you feel he might be about to choose a course of action.
  • Otherwise encourage your protégé to make choices and decisions that he feels are best
  • Know when it is time to let go
  • When protégé becomes proficient and is reluctant to tell that he has out grown you or may simply be unaware that it is time to move on
  • Help your mentee to plan the future before ending your formal mentoring relationship
  • General transferable qualities of leaders across the board

Saturday, 11 January 2014

QlikView advantage over query based BI

Query-based BI tools have been in and around for decades for decision support. Variations of query-based BI software are on the market, Some are flexible and others are high-performance.
But they all share one critical flaw: they are unable to inherently maintain associations among data elements
00:

Query-based tools divorce data from its context. People making complex business decisions don’t always have full access to their supporting data, even when they have access to BI software.
Some data is available only as isolated and discrete queries, without context between one query and the next. This leaves gaps for people trying to make data-driven business decisions.

With query-based tools, creating associations among all available data elements would require a business analyst or IT professional to cram every associated field into a single query, a nearly impossible task.
The alternative hard coding associations among queries into the application layer is equally daunting.

QlikView is the world’s first associative, in-memory business intelligence platform. QlikView manages associations among data sets at the engine level, not the application level, by storing individual tables in its in-memory associative engine.
Every data point in the analytic dataset is associated with every other data point in the dataset. Datasets can be hundreds of tables with thousands of fields. Unlike traditional query-based BI tools, when the QlikView user selects a data point, no queries are fired.
Instead, all the other fields instantaneously filter and re-aggregate themselves based on the user’s selection. Selections are highlighted in green. Datasets related to the selection are highlighted in white.
Unrelated data is highlighted in gray. This provides a very intuitive, user-friendly way for people to navigate their data on their way to business insight.

Query-based BI tools separate the application layer from the data layer. This leads to long deployments while expensive developers customize the application layer to manage the specific associations required to answer a particular business question.

When the BI application needs to answer a slightly different business question, the application layer must be altered again, which is time-consuming and expensive.
With QlikView, any and all aggregates are recalculated in real time, regardless of the source fields. All associations are stored generically against the entire dataset, ready to answer any business question as it comes up without requiring any customization. The data from all tables is always available in context and ready to answer the next business question.

Friday, 10 January 2014

Types of data

We so much talk about data all the time - do we all know in how many types data can be categorized based on its structure?
I am trying to compile a similar categorization for data around which ETI, BI, BigData & DataAnalytics have evolved
Structured data
This is the base of all the database systems which have dominated the market of the ETL and BI industry for so many years. The structured data refers mainly to the relational database where all the key structures and associations are well defined and also all dimensional data is properly associated with facts.
Semi-structured data
Data in the form of excel sheets, presentations, etc which can be used as structured data to some extend for analysis but automation for direct access is not so easy. It basically would need to be somehow turned into structured data and then analysed.
Syndicated data
Home away, Thompson Reuters, etc. which provide special data in their own formats for analysis are bucketed under the category of Syndicated data.
Unstructured data
Logs from systems and devices, social media data such as twitter and facebook. Even though one may have a feel to turn this data into structured data for analysis, the volume and frequency of unstructured data makes it nearly impossible to be converted to structured data for analysis in terms of feasibility and impact. So, unstructured data is analysed using different methods and tools.

The one that will soon be published on BabaGyan.com uses Python and R language in combination with Php, MySql and HTML5 too.

Thursday, 9 January 2014

QlikView Licensing - an Overview

QlikView is an visualization and Dashboarding tool along with its own system.
There is a lot of confusion on how exactly QlikView provides licensing. Organizations take up trainings with QlikView and then they are told about it. I though it would be nice to know thing free of cost on internet.

There are basically 4 types of QlikView license
downloadqlikview
QlikView Personal Edition:
The QlikView Personal Edition allows you to create QlikView documents using available free source connections. Free, as in, the connectors for which all sources are free. Example: SAP conncetor will need additional purchase. The documents created on one Personal Edition can only be worked upon on same edition/machine. You cannot create it at one place and edit at other. It is, by all means, Personal.
QlikView Desktop Edition:
The QlikView Desktop Edition is for a small organization who does not want any server but does need multiple people work on same QlikView document. Sharing of documents is allowed.
QlikView Enterprise Edition:
The QlikView Enterprise Edition is for organizations which need to have a central place for development and update of QlikView documents. Consider this as central repository of all the developments. Here, all users have access to same set of data in QlikView documents.
QlikView Publisher:
The QlikView Publisher is an addition to QlikView enterprise. It enables having end users access only certain amount of data from QlikView documents stored on Enterprise server. The amount of data is manager by roles and restrictions.

There is also a thing called "License lease" where an Enterprise can manage which all QLikView Desktops can connect to the central server.