May 21
1 min

this is a testing page...

HTML code <iframe src="https://apps.powerapps.com/play/46fa0XXXXXbb43-e86da93bdc60?tenantId=XXXXX-4cd1-9ead-21a8XXXXX" frameborder="0"...

Marek Vavrovic

May 9
1 min

PowerBI

Northwind Dashboard

Northwind dashboard created in Power BI Desktop.

Compound Annual Growth Rate (CAGR) using DAX

Marek Vavrovic

May 1
2 min

DAX

Compound Annual Growth Rate (CAGR) using DAX

What Is the Compound Annual Growth Rate (CAGR)? The compound annual growth rate (CAGR) is the rate of return (RoR) that would be required...

Marek Vavrovic

Apr 30
2 min

PowerBI

Cohort Analysis

Excel blog about Cohort analysis: Customer Retention & Cohort Analysis (mavaanalytics.com) Sample Data First thing I need to do is to add...

Marek Vavrovic

Apr 13
1 min

SSRS

SSRS Loan Statement

Using T-SQL Stored Procedure to create a report in Power BI Report Builder. Data set: Using T-SQL to create a bank loan statement...

Marek Vavrovic

Apr 12
1 min

PowerBI

Disconnected Table / Dimension

Power BI Model: I have two tables. Sales with transactions and dimension table for filtering. 1. If no filter is applied. Chart 1: shows...

HuffnerTextile - Data Visualisation PowerBI Desktop

Marek Vavrovic

Mar 31
3 min

BI Solutions

HuffnerTextile - Data Visualisation PowerBI Desktop

Data Models Data are loaded from the data warehouse database. Using Import Mode. Can't use DirectQuery Mode for Live Connection because I...

Marek Vavrovic

Mar 29
0 min

PowerBI

Huffner Textile Dashboard - Power BI

Marek Vavrovic

Jan 25
0 min

PowerBI

Covid 19 dashboard created in Power BI

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 5, 2021
3 min

DAX

Index

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

Marek Vavrovic

Sep 23, 2021
2 min

DAX

M code, DAX, create a calendar.

Create a calendar in Power Query or using a DAX language. example 1 > M code. This calendar starts from 01. 01.2010 and the dates are...

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

Tesla Financial Reports 2009-2020 analysis

Marek Vavrovic

May 11, 2021
1 min

PowerBI

Tesla Financial Reports 2009-2020 analysis

Link to dashboard: https://app.powerbi.com/view?r=eyJrIjoiNzFlNmM3YzEtYzE2ZC00Mjk1LWE1MDctNGM4MzgxZjhkYTUwIiwidCI6IjQyNTFlNjhmLTEzZjctNG...

Marek Vavrovic

Dec 31, 2020
1 min

PowerBI

Covid-19 new cases in Slovakia

A look at the new covid-19 cases through the 14 day period.

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