Forward Selection to Find Predictive Variables with Python CodeRecently, I had a product discovery task to find leverages of revenue increasing. For the beginning, I decided to find the predictive…Sep 20, 2021Sep 20, 2021
Rank When Value is Changed in Not Ordered DatasetSometimes you should order your data in SQL as group of values like this:Aug 18, 2021Aug 18, 2021
A Quick Way to Access Inside of the Function in PostgreSQLWhen you are a new member in a data team like me, you need to work with the written procedures which has been saved as functions in…Dec 2, 20201Dec 2, 20201
Run Spark on Windows; Pair PyCharm & PySparkI tried to run Spark on Windows and configure it on PyCharm and Jupyter. I read some walk-through to find the comprehensive way to solve…Mar 8, 2020Mar 8, 2020
Margin Clustering over Each Category of Products with Python and MDXIn our retail store, we wanted to find a way to discover three margin boundaries dynamically for three low, medium, and high profit…Jan 18, 2020Jan 18, 2020
Monitoring SSAS with Power BI & Kill the Sessions via Dynamic Management ViewsOur company, which is a retail business, has thousands of chain stores, and we create enterprise cubes over billions of data for hundreds…Dec 31, 20191Dec 31, 20191
Cumulative Sum as Measure with MDXCalculation in MDX is fast and cheaper that T-SQL because of cube structure. one thing that is needed in business is cumulative sum…Dec 26, 2019Dec 26, 2019
Fast Cube Processing Solution: “Process Add” via MDX, XMLA, and T-SQLProblemDec 22, 20191Dec 22, 20191