May 3
2 min

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...

Power Query: Normalizing denormalized table

Marek Vavrovic

May 3
2 min

Excel

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...

Marek Vavrovic

Apr 30
3 min

Excel

Customer Retention & Cohort Analysis

Customer cohort analysis is beneficial in marketing and business use cases. For subscription & non-subscription businesses. Companies use...

Power Query - Extracting web data using URL parts - Building functions to fetch web data.

Marek Vavrovic

Oct 21, 2021
2 min

PowerBI

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...

Marek Vavrovic

Oct 15, 2021
3 min

Excel

Seasonal Indices (Seasonal Index)

When data under analysis has a seasonal influence on it, further investigation cannot continue without deseasonalising the data. This...

Marek Vavrovic

Oct 5, 2021
3 min

DAX

Index

Information functions Filter functions Table manipulation functions Grouping and summarizing Time intelligence functions...

Calculate Lag and Lead value using power query.

Marek Vavrovic

Jun 17, 2021
2 min

PowerBI

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...

Calculate Net Working Days Using Power Query.

Marek Vavrovic

Jun 16, 2021
3 min

PowerBI

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...

Creating a Rolling Average & Rolling Total using Power Query.

Marek Vavrovic

Jun 10, 2021
5 min

PowerBI

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....

Marek Vavrovic

Jun 5, 2021
2 min

Excel

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...

Append files with different culture format

Marek Vavrovic

Jun 5, 2021
3 min

Excel

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...

Marek Vavrovic

Jun 5, 2021
2 min

PowerBI

Append tables

Power query, append tables using M code.

Marek Vavrovic

Jul 11, 2020
4 min

Excel

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...

Marek Vavrovic

Jul 3, 2020
8 min

Excel

Linear regression analysis in Excel

In statistical modeling, regression analysis is used to estimate the relationships between two or more variables: Dependent variable (aka...

Marek Vavrovic

Jun 14, 2020
7 min

Excel

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...

Marek Vavrovic

Jun 13, 2020
4 min

Excel

One-way ANOVA

The one-way analysis of variance (ANOVA) is used to determine whether there are any statistically significant differences between the...

Hypothesis testing, F-Ratio, F-Distribution

Marek Vavrovic

Jun 9, 2020
3 min

Excel

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...

Marek Vavrovic

Jun 8, 2020
3 min

Excel

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...

Hypothesis testing, p-value, test statistic, z-score.

Marek Vavrovic

Jun 6, 2020
5 min

Excel

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...

Marek Vavrovic

May 29, 2020
4 min

Excel

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...

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

Continue

Project Deployment Model

Slowly Changing Dimensions

Continue

Lookup Transformation

Continue

Derived Column

Continue

Union All vs Merge Transformation

Merge Join

Incremental Load

SSIS Access is denied

Expressions, Parameterized con.

SCD using Lookup and Conditional Split

Append tables

SSRS

DAX

Index

Continue

Pokračovat

Data Source , Data Set in SSRS

Tabular Report with Wizard

Grouped Report with Subtotals

Grouped Report with Drilldown

List: Group on Page

List: writing a letter

Headers on Each Page

Table rows on a single page

Running Total

Parameter: Get values from query

Parameter : Boolean

Parameter: Cascade

Drill Through Report

Create a Bookmark

Stored Proc with IN operator

Create a Sub Report

IIF

T-SQL Stored Procedure