Below is a team work by my team and I at Georgia Tech for our Data Analytics for Business summer 2022 Project. The data for the project is fictional and all information provided is for our project purpose only and not to be used for any decision making. Authors of the project are : Vincent […]
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 […]
