Power Query : Get the last / max record from a subset
Sample data: I have a table where 1 Order Number has multiple record in that. I want to retrieve just the most recent one. 1. Group by...
top of page
07479 744442
Home: SQL
Search
Marek Vavrovic
- May 3, 2022
- 2 min
Power Query: Normalizing denormalized table
Sample data: I have this Denormalized table, and I want to put the table into 3rd normal form. Load table into Power Query 2. Duplicate...
2040
Marek Vavrovic
- Apr 30, 2022
- 3 min
Customer Retention & Cohort Analysis
Customer cohort analysis is beneficial in marketing and business use cases. For subscription & non-subscription businesses. Companies use...
5380
Marek Vavrovic
- Oct 21, 2021
- 2 min
Power Query - Extracting web data using URL parts - Building functions to fetch web data.
Web source: Database index (planecrashinfo.com) Goal is to extract the accident details for each year and date. That means get a access...
8690
Marek Vavrovic
- Oct 15, 2021
- 3 min
Seasonal Indices (Seasonal Index)
When data under analysis has a seasonal influence on it, further investigation cannot continue without deseasonalising the data. This...
7,3210
Marek Vavrovic
- Jun 17, 2021
- 2 min
Calculate Lag and Lead value using power query.
Lag and Lead are functions used in many programming languages that provides access to a row at a specified physical offset which comes...
8,8231
Marek Vavrovic
- Jun 16, 2021
- 3 min
Calculate Net Working Days Using Power Query.
We want to calculate number of days between start date and end date. Then we want to exclude weekends. And at the end holidays. Source...
5600
Marek Vavrovic
- Jun 10, 2021
- 5 min
Creating a Rolling Average & Rolling Total using Power Query.
A rolling average also known as moving average is a statistical method that calculates the average of a data series for a given period....
7,7721
Marek Vavrovic
- Jun 5, 2021
- 2 min
Excel append tables
I have a multiple excel files in one folder with the same metadata (structure). These tables are not proper tables, require some...
550
Marek Vavrovic
- Jun 5, 2021
- 3 min
Append files with different culture format
I have couple of files with different date and value formats. Will use a function which will format them correctly... Source files: There...
1140
Marek Vavrovic
- Jul 11, 2020
- 4 min
Multiple Linear Regression
Multiple linear regression model is the most popular type of linear regression analysis. It is used to show the relationship between one...
3990
Marek Vavrovic
- Jul 3, 2020
- 8 min
Linear regression analysis in Excel
In statistical modeling, regression analysis is used to estimate the relationships between two or more variables: Dependent variable (aka...
6870
Marek Vavrovic
- Jun 14, 2020
- 7 min
Two-Way ANOVA
A two-way ANOVA test is a statistical test used to determine the effect of two nominal predictor variables on a continuous outcome...
3940
Marek Vavrovic
- Jun 13, 2020
- 4 min
One-way ANOVA
The one-way analysis of variance (ANOVA) is used to determine whether there are any statistically significant differences between the...
3270
Marek Vavrovic
- Jun 9, 2020
- 3 min
Hypothesis testing, F-Ratio, F-Distribution
When to use f-distribution? In investing, variance is used to compare the relative performance of each asset in a portfolio. Because the...
1080
Marek Vavrovic
- Jun 8, 2020
- 3 min
Hypothesis testing, T-Distribution.
Hypothesis testing is just a method for testing a claim or hypothesis about a parameter in a population [mean, proportion]. In hypothesis...
1730
Marek Vavrovic
- Jun 6, 2020
- 5 min
Hypothesis testing, p-value, test statistic, z-score.
Hypothesis testing is just a method for testing a claim or hypothesis about a parameter in a population [mean, proportion]. In hypothesis...
1530
Marek Vavrovic
- May 29, 2020
- 4 min
The Normal Distribution
Statisticians call a distribution with a bell-shaped curve a normal distribution. You may have heard of a bell curve. A bell curve...
220