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


Binomial Distribution

Poisson Distribution

Normal DIstribution

Hypothesis testing, z-score

Hypothesis testing, T-Distribution

Hypothesis testing, F-Ratio

One-way ANOVA. Post hoc test.


Simple linear regression

Multiple linear regression


Latest articles on MaVaAnalytics.com


MaVa Analytics

Naturally Curious



Thanks for submitting!