Blog

ByAkanksha Bhadoria

KPIs for Ecommerce Industry

The advent of internet has made business easier than ever before. Moreover, internet has not only reduced the time span of reaching the BEP, it has also made business analytics accessible and easy. These days, with Google providing analytics, it becomes cost effective and time saving to find the loop holes, leading to better and faster decision making ...

Read more

ByAkanksha Bhadoria

KPIs for Law Firms

For an industry that is service based, it becomes tough to define the pricing strategy as the costs incurred are mostly, implicit in nature, and therefore profit estimation becomes a hard nut to crack. One such industry is of the Law firms, here the business entity practices law, as a result advises clients about their legal rights and responsibilities. [caption ...

Read more

ByAkanksha Bhadoria

Application of BI

Business Intelligence comprises of various elements, each element playing the role of a building block and preaching towards enlightenment (Effective Decision Making). This composite structure of Business Intelligence delivers a bundle of services. The back stage centralised data warehouse or the front stage, data visualisation, each playing an equivalent ...

Read more

ByAkanksha Bhadoria

Prerequisites for BI

Even though open source technologies have made BI tools easily available and affordable, yet the entire process of implementation requires certain prerequisites.Business Intelligence is not an easy nut to crack. The concepts of Business Intelligence are easy to understand but the implementation is rather difficult. If you still aren't aware of what ...

Read more

ByAkanksha Bhadoria

BI- Fuel to your Data Engine

It is all a number game! A phrase we all have been hearing as a part and parcel of each function and department in the business world. Be it Finance, Sales or even HR, facts form the basis of decision making. For generation of these facts, that enlighten the path towards achieving business goals; there is only one prerequisite and that is DATA. Why ...

Read more

ByAkanksha Bhadoria

Introduction to BI

Canny Informatics deals in Business Intelligence Services. That is what we have propagated and conveyed to all the prospects. There have been a few instances, where people have asked us the meaning of Business Intelligence and what exactly is that Canny Informatics does. The subject sounds tricky but couldn’t be simpler. As quoted on Wikipedia, Business ...

Read more

ByVibha Tiwari / Akanksha Bhadoria

Sales Performance, CXO Dashboard

To me, job titles don't matter. Everyone is in sales. It's the only way we stay in business.                                                                                                                            - Harvey Mackay Revenue ...

Read more

ByVibha Tiwari / Akanksha Bhadoria

Supplier Behavior, CXO Dashboard

Supplier Behavior, CXO Dashboard The business processes are not very intricate; it follows a simple transactional structure with each of its stakeholders. The process begins with purchasing raw materials from the suppliers, processing the raw materials to make finished products and reaching out to the customers and delivering the products. Seemingly, ...

Read more

ByVibha Tiwari / Akanksha Bhadoria

Customer Behaviour- CXO Dashboard

Customer Behavior- CXO Dashboard Business Intelligence helps generate insights through dashboards, which has an interactive interface and can pull near real-time data from multiple sources to allow flexible and intuitive visualization. As an ensemble, the representations convey a story.  There are various features of interactivity, filters, drill ...

Read more

ByJinal Thakkar / Akanksha Bhadoria

Microsoft Power BI - Rajya Sabha - Attendance Analysis (2015-16)

Rajya Sabha- Attendance Analysis (2015-16) The Parliament of India follows a bicameral structure, i.e. it has two houses, Rajya Sabha (Council of States or Upper House) and Lok Sabha (House of the People or Lower House). The members of the Lok Sabha are directly elected by the public where as the members of Rajya Sabha are indirectly elected by ...

Read more

ByHardik Patel / Akanksha Bhadoria

Talend - Alternate Option when tPosgresqlRollback fails

Alternate Option when Rollback fails There are two ways to complete a transaction or job in Talend, as follows- When the data does not require changes and thus could be made permanent, then we must commit the transaction. Whereas, when you might want to restore the data, in that case, one must stick to Rollback. Rollback is the operation ...

Read more

ByMahir Mansuri / Akanksha Bhadoria

The app file you are attempting to load from is corrupt - Connecting Google Sheets to Qlik Sense

The app file you are attempting to load from is corrupt Connecting Google Sheets to Qlik Sense   Our company was willing to find the analytics based on the Sales Activities. A sales tracker that defines the trend analysis related to the activities. This way we intended to promote accountability and responsibility within the Sales Team. When ...

Read more

ByCanny Informatics

India Power Generation 2016-17 (Qlik Sense)

Qlik Sense is a query based BI-tool that allows working on cloud ready data analytics on its platform. Data visualisation tools form the basis of good analytics. As there are various BI tools available, we here have created analytics with Qlik Sense. The purpose behind such a choice has been to help you compare results of various BI tools. Previously, ...

Read more

ByCanny Informatics

Wi-Fi Analytics - A White Paper

A customer visits your store, strolls for an hour enquiring about various products and leaves. He then visits your competitor’s store, and purchases a product in 10 minutes at a higher price!. Such observations create mind-boggling questions. Such questions baffle the mind of the marketers.   Imagine 100 such prospect customers, each behaving ...

Read more

ByCanny Informatics

Business Intelligence With Heat Maps

There are various ways to depict data information, through types of graphs and tables along with various filters, making it interactive and more informative. One such visual representation is a Heat Map. The term 'heat map' was originally coined and trademarked by software designer Cormac Kinney in 1991, to describe a 2D display depicting financial ...

Read more

ByCanny Informatics

ETL for Calendar 2018

There are always some prerequisites which each dashboard or report follows. These are the parameters which form the foundation, the basis of comparison and evaluation. Such foundations are called “dimensions” Thus for each report one has to set certain dimensions which need to be prepared keeping previous formats in mind so that standardisation ...

Read more

ByCanny Informatics

Punch Data Analysis - A White Paper

Executive Summary I was in a conversation with a very close friend and co-founder of an IT company. We began discussing the various problems he was facing in the business; all problems directing towards one solution. In other words, there were various internal problems in the organisation which after discussion and a thorough examination was being ...

Read more

ByCanny Informatics

Insights of Power Generation in India - FY - 2016-17

Data source is: https://data.gov.in/catalog/power-generation Introduction Electricity pays a pivotal role in the lives of mankind. It is one of the basic elements for infrastructural facilities that affect economic growth and well being of the nation. Being a universal energy source, electricity is obtained from methods such as solar power, hydro ...

Read more

ByHardik Patel

Database Connectivity in Pentaho 5.4.x using JDBC

There are many ways you can fetch the data from a database in Pentaho which are given in the below image. In This post, we will discuss two methods of fetching data which are shown below MDX Queries, Mdx over mondrianjdbc, SQL Queries, Sql over sqljdbc. Before getting into the actual stuff let us see what is JDBC. JDBC (Java DataBase Connectivity) ...

Read more

ByHardik Patel

Install Pentaho BI Server 5.4.x in Windows

This post will explain the sequence of steps to install Pentaho BI Server-CE-5.4.0.1.130. Prerequisites - Install JDK 7 from http://www.oracle.com/technetwork/java/javase/downloads/jdk7-downloads-1880260.html, Here, in the above image download JDK 7 as per your processor architecture and install Java in your system. You should now have the Java SDK ...

Read more

ByGaurang Acharya

Business Intelligence in Human Resource

“Right” people are the greatest assets of any organization. Assets which give good returns must be retained and their retention, asks for investment through various Human Resource Policies. At the same time, there are multiple challenges to understand patterns of employee attrition. These challenges increase multi-fold when employee strength is ...

Read more

ByJinal Thakkar / Nishee Prajapati

Talend Open Studio - tFileList, tFlowToIterate, tIterateToFlow Components

tFileList can be used to merge data of multiple files having same schema and same file mask into a single file or into a database. It supports four file extensions viz .xls, .xlsx, .csv, .txt. This component iterates over the files present in given folder. Remember - tFileList will not iterate the files recursively. However, if we want to merge ...

Read more

ByHardik Patel / Jinal Thakkar

Talend  Open Studio -  MSSQL connection using windows authentication

Step by step tutorial to connect MS SQL Server to Talend Open Studio using windows authentication. Summary : Download jtds-SQL server JDBC driver from https://sourceforge.net/projects/jtds/ Copy jtds-1.3.1.jar to ‘plugins’ of Talend folder Based on your CPU architecture, copy ntlmauth.dll from x64/SSO OR x86/SSO OR IA64/SSO ...

Read more