Thursday 26 March 2015

Lessons from Singapore's Founder : Tribute to Mr Lee Kuan Yew


Described by Time magazine as “a man of great intelligence, with no patience for mediocrity”, Mr Lee Kuan Yew is incredibly brilliant, and it shows in his words and actions. From nothings he built Singapore as a country of Everything! Mr Lee Kuan Yew passed away peacefully on 23 March 2015. While people from all over the world are paying their respect. We dedicate this post as tribute to his fantastic leadership.

As a leader who has led a team to achieve the impossible, it’ll be extremely useful to see what we can learn from this great man.


If you’ve heard his speech before, you’ll understand.He is known for giving Sincere , powerful, passionate speeches, and when he speaks, it’s difficult not to listen. 

“I have been accused of many things in my life, but not even my worst enemy has ever accused me of being afraid to speak my mind.” (1955)


If you want to please everyone you will get nowhere. Many leaders succumbed to fast decisions just to stay popular. Being able to care less about what people think, and focus on getting your facts right is something many people can learn from.

“If you can’t think because you can’t chew, try a banana.”  From a BBC article about Singapore’s ban on chewing gum, 2000



Mr Lee was a top student in Singapore, and was once again the top student when he studied overseas.Mr Lee brought a red briefcase to work, and in there, he jotted down notes about both important and “trivial” things, but they were all about Singapore, the nation he built.

“Even from my sick bed, even if you are going to lower me into the grave and I feel something is going wrong, I will get up.” — From the 1988 National Day Rally



“You lose nothing by being polite. The answer is ‘No’, but please say it politely and give the reasons… Explain to me why ‘No’. Don’t change ‘No’ to ‘Yes’. Don’t be a fool. If there was a good reason why it is ‘No’, it must remain ‘No’, but the man must be told politely.”  To Civil Servants at the Victoria Theatre, 30 Sep 1965



Turns out Mr Lee takes after Machiavelli’s philosophy in The Prince — that a good leader is a feared one. With his iron-fisted policies, he was a feared leader, but was highly respected and spoke with great confidence.


Lee Kuan Yew has always been a well-known realist.

“Because of my house, neighbouring houses cannot be built high. I said — demolish my house, change the planning rules, and the land value will go up. I don’t think my daughter or my wife or I, who lived in it, or my sons who grew up in it, will bemoan its loss.” – Hard Truths to Keep Singapore Going



All those local and international mourning shows how much respect Mr. Lee Kuan Yew has gained. Thank you Sir! Your legacy is of hard work, integrity and sacrifice will always remain bright and enduring for the people of Singapore. May you now rest in peace, Sir.


Srivatsan Aravamudan

Design and Communication

Google plus
LinkedIn

Tuesday 24 March 2015

Multiple Source Data : Conversation of Consolidation


Recently one of client came up with a requirement which was not uncommon in the projects we do. The nature of the situation prompted me to write this post which could be of use to many of you out there.  




Requirement :

So this client of ours is a Manager who is interested in Reports of the various performance dimensions of his supply chain team. Currently the data comes from different sources, like share point sites, spreadsheets, flat files, Database, etc. And this data is collected using HTML/JS compilation and stored in the spreadsheet using VBA summarized views. Now the customer is wondering whether to go for SQL to have centralized data collection and more fool proof reporting.

Our Suggestion:

The above is the model we suggested for the client. There could be two different scenario based on the type of ccustomizationthat is needed to extract data. If the data extraction process is straight forward we can use SSIS. SSIS is a platform for data integration and workflow applications. It features a fast and flexible data warehousing tool used for data extraction, transformation, and loading (ETL). 


On the other hand, PsiberTech tool Tokenizer can be used specifically for the customized Data Collection. Tokenizer is a data extraction; transformation and monitoring tool that allows the extraction of data from file formats like flat files, databases, and excel files including un-formatted files. 

Just by configuring few XML files you will be able to extract data from a source, apply your business logics and then transform and load the data into a destination in your desired format.  Assuming your source data is from a text file and you want to apply certain business rules before the data is cleansed, transformed and loaded into your destination, let’s say a SQL database table; Tokenizer is the right tool to perform this process. 

One killer feature about Tokenizer is that it allows automation of data import or transformation instantaneously, and can perform additional functions such as emailing and FTPing files. Now once the data is collected it can be stored in the central SQL Database and can be further processed using Data Mining to create OLAP cubes. Data Mining is an analytic process designed to explore Data (usually large amounts of data - typically business or market related ones like our customers. Data mining automates the process of finding predictive information in a large database.Using Data mining we can establish sophisticated mathematical algorithms to segment the data and evaluate the probability of future eventsUsing this Data Mining Data is then fed into OLAP. OLAP is a set of operations that one can do on a data set, for example pivoting, slicing, dicing, drilling. This is particularly useful to gain more insights into the data collected.

This is where PsiberTech Voyager comes in. Voyager IIG  allows the users to extract business information  from disconnected backend systems and turn that into meaningful Charts, Graphs, Gauges, Maps and tables. This easy to use tool allows interactive analysis of large amounts of  data from many perspectives.Users can analyze data, perform ad-hoc queries, and create their own reports.Voyager reports can be published to any Web portal including  SharePoint Portal.

I hope this post has helped to understand the Data extraction from multiple sources.Also take a look at the 3 Common Issues of Data Warehouse projectIts important to engage the right consultant to help you Pre plan, Analyse, and Implement the Data Warehouse Solution with reduced effort and disruption to users. Contact us to know more about Data Warehouse and how it can benefit your organisation. Thanks for dropping by and Have a fantastic day!

Best
Srivats



Srivatsan Aravamudan
Srivatsan Aravamudan

Public Relations and Social Media Manager

Srivatsan Aravamudan
General Enquiries:info@psibertech.com.sg
Sales Enquiries:sales@psibertech.com.sg
Telephone:+65 62689551
Fax:+65 62689858
Public Relations and Social Media Manager

Tuesday 17 March 2015

OLAP - Online Analytical Processing : Resource Guide


OLAP is an acronym for Online Analytical Processing. OLAP performs multidimensional analysis of business data and provides the capability for complex calculations, trend analysis, and sophisticated data modeling.

For example, a user can request that data be analyzed to display a spreadsheet showing all of a company's beach ball products sold in Florida in the month of July, compare revenue figures with those for the same products in September, and then see a comparison of other product sales in Florida in the same time period. 

Take a look at the following video for basic introduction about OLAP.



If you like to create your first OLAP cube using Microsoft server 2008 please refer to the video below.





More advanced tutorial about Slicing & Dicing with Cubes can be seen below.



To know about Optimizing Cube Performance with OLAP Services click here.

Also take a look at the 3 Common Issues of Data Warehouse projectIts important to engage the right consultant to help you Pre plan, Analyse, and Implement the Data Warehouse Solution with reduced effort and disruption to users. Contact us to know more about Data Warehouse and how it can benefit your organisation. Thanks for dropping by and Have a fantastic day!

Best
Srivats

Srivatsan Aravamudan


Srivatsan Aravamudan

Design and Communication

Google plus
LinkedIn



Monday 16 March 2015

ETL : Data Extraction - Pointers


Extract, Transform and Load (ETL) refers to three separate functions combined into a single programming tool. First, the extract function reads data from a specified source database and extracts a desired subset of data. Next, the transform function works with the acquired data - using rules or lookup tables, or creating combinations with other data - to convert it to the desired state. Finally, the load function is used to write the resulting data which can be used for further reporting or analysis.




Also take a look at the 3 Common Issues of Data Warehouse projectIts important to engage the right consultant to help you Pre plan, Analyse, and Implement the Data Warehouse Solution with reduced effort and disruption to users. Contact us to know more about Data Warehouse and how it can benefit your organisation. Thanks for dropping by and Have a fantastic day!

Best
Srivats

Srivatsan Aravamudan


Srivatsan Aravamudan

Design and Communication

Google plus
LinkedIn

Thursday 12 March 2015

3 Common Issues of Data Warehouse project

 Data Warehouse


The success of business depends on the effectively use of collective knowledge of the organization. But it is not so simple because it is not easy to understand and use this huge volume of data from multiple sources and formats. A subject-oriented, integrated, time-variant, and nonvolatile collection of data in support of management's decision-making process becomes vital to the success of business. The successful implementation of a data warehouse can bring major, benefits such as Better enterprise intelligence,cost-effective decision-making and Competitive advantage.

There are certain issues surrounding data warehouses that companies need to be prepared for. A failure to prepare for these issues is one of the key reasons why many data warehouse projects are unsuccessful.

1. Loading & Cleaning Data : There may be a need to cleanse the data, which is not getting validated by the transaction system. some experts have said that the typical data warehouse project will require companies to spend 80% of their time loading and cleaning data.

2. Data Data everywhere : The end-users may not know how to use the data, as they are so much into the existing reporting culture. As a result of this user may be interested to create various types of reports out of the data, however the data many not culminate into meaningful decision process. Data warehouse is very powerful solution to implement, however understanding the requirement of the user and creating the necessary report structure is important responsibility of the consultant.

3. Granularity problem – Sometimes the transaction system may not have the data at the lowest level.This may occur frequently in a data warehouse that is tailored towards products or customers.It is important to make sure that the information that is placed in the data warehouse is rich in detail.


Its important to engage the right consultant to help you Pre plan, Analyse, and Implement the Data Warehouse Solution with reduced effort and disruption to users. Contact us to know more about Data Warehouse and how it can benefit your organisation. Thanks for dropping by and Have a fantastic day!

Best
Srivats

Srivatsan Aravamudan


Srivatsan Aravamudan

Design and Communication

Google plus
LinkedIn

Related Posts Plugin for WordPress, Blogger...

Share Buttons