Most data analyses start with organizing the data, at least starting with organizing in tabular format. This implies tables are the most fundamental formats to deal when analysing data. Here I crafted an infographic showing the most commonly performed merge or join operations among tables. Hope you will find this useful. Feel free to share... Continue Reading →
Generating Date Dimension data in Microsoft Excel
Generating data for populating Date Dimension table using familiar Microsoft Excel
A White Paper – Solving Relational Division problem in SQL – The Analyst Way
Hi readers..!! Here I go posting a white paper on one of the classical and intellectually challenging problems that an analyst might come across. The paper is titled - "Understanding and Solving Relational Division problems in SQL - The Analyst way". Hope you enjoy reading this paper. Please leave your comments and suggestions, if any, here.... Continue Reading →
MS Excel Keyboard Shortcuts
Hi.. Here I have composed a comprehensive listing of keyboard shortcuts for Microsoft Office Excel 2010 in downloadable PDF format. Please do share the keyboard shortcuts if you know any that are missing in this list and help improve this listing. Do share your comments or suggestions, if any.. Happy time until my next blog... Continue Reading →