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...
650
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...
2440
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...
2940
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...
1,2500
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...
4,1090
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...
3460
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....
4,1401
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...
370
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...
550
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...
2180
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...
4240
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...
2440
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...
1910
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...
830
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...
1410
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...
1410
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...
140
Power BI
SSIS
Import .CSV files from web site
Data Refresh - Expression.Error column not found
Covid-19 Dashboard
AdventureWorksDW2017 Dashboard
Wide World Importers Dashboard
Slovakia covid-19
DAX measures for Covid-19
Tesla 2009-2020 Financial reports analysis
Covid 19 Dashboard (OWID)
Huffner Textile Dashboard
Northwind dashboard
File System Task
Sequence Container
Execute SQL Task
For Loop Container
Foreach Loop Container