Have you heard the term aggregation or composition of classes in python? This can be a little tricky but let me share a simple scenario to explain the concept. Let’s assume we have a class employee and another class salary. The salary class has capability to calculate annual salary given the pay and the bonus. […]
I want to quickly go over some useful analytic functions introduced in sql server 2012 and how you can use it to accomplish some cool tasks in your data warehouse. Lets take a scenario where you have many employees who makes sales to various customers over the years. You are interested in generating report which […]
We have many functions for aggregating data in SQL such as AVG,MIN,MAX etc. Apart from these functions, there are sql server extensions to the group by clause which can be used to provide summarized data and give some powerful use of the data. In this post l will illustrate the operator called ROLLUP which is […]
Well, this is my first post in 2020 and it better be good and helpful to you out there. Happy new year!!!. I want to discuss data profiling using SSIS in this post. If you are not familiar with data profiling, its a process of looking at a data set to make general sense of […]