Marek Vavrovic's BI Blog

07479 744442

Power BI

Import .CSV files from web site

Data Refresh - Expression.Error column not found

Covid-19 Dashboard

Northwind Dashboard

AdventureWorksDW2017 Dashboard

Wide World Importers Dashboard

Slovakia covid-19

DAX measures for Covid-19

Tesla 2009-2020 Financial reports analysis

Excel topics

How to Import Data from a Website to Excel

Append tables using M code

Append with different culture formats

Append tables using a function

Rolling average / total using power query

Custom function: NetWorkingDays

LAG and LEAD using power query

Statistics

Binomial Distribution

Poisson Distribution

Normal DIstribution

Hypothesis testing, z-score

Hypothesis testing, T-Distribution

Hypothesis testing, F-Ratio

One-way ANOVA. Post hoc test.

Two-Way ANOVA

Simple linear regression

Multiple linear regression

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

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

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

Latest articles on MaVaAnalytics.com

MaVa Analytics

Naturally Curious

Contact