Fakhredin KhorasaniForward 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…3 min read·Sep 20, 2021----
Fakhredin KhorasaniRank When Value is Changed in Not Ordered DatasetSometimes you should order your data in SQL as group of values like this:2 min read·Aug 18, 2021----
Fakhredin KhorasaniData Modeling with Apache Spark + Delta Lake + PrestoIntro4 min read·Feb 5, 2021----
Fakhredin KhorasaniA 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…2 min read·Dec 2, 2020--1--1
Fakhredin KhorasaniRun 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…3 min read·Mar 8, 2020----
Fakhredin KhorasaniMargin 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…3 min read·Jan 18, 2020----
Fakhredin KhorasaniMonitoring 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…2 min read·Dec 31, 2019--1--1
Fakhredin KhorasaniCumulative 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…2 min read·Dec 26, 2019----
Fakhredin KhorasaniFast Cube Processing Solution: “Process Add” via MDX, XMLA, and T-SQLProblem4 min read·Dec 22, 2019--1--1