Power BI

Northwind Dashboard

Northwind dashboard created in Power BI Desktop.

Compound Annual Growth Rate (CAGR) using DAX

Marek Vavrovic

May 1, 20222 min read

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, 20222 min read

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, 20221 min read

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, 20221 min read

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, 20223 min read

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, 20220 min read

Huffner Textile Dashboard - Power BI

Marek Vavrovic

Jan 25, 20220 min read

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, 20212 min read

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, 20213 min read

DAX

Index

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

Marek Vavrovic

Sep 23, 20212 min read

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, 20212 min read

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, 20213 min read

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, 20215 min read

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, 20212 min read

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, 20213 min read

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, 20212 min read

Append tables

Power query, append tables using M code.

Tesla Financial Reports 2009-2020 analysis

Marek Vavrovic

May 11, 20211 min read

Tesla Financial Reports 2009-2020 analysis

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

Marek Vavrovic

Dec 31, 20201 min read

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

Project Deployment Model

Slowly Changing Dimensions

Lookup Transformation

Derived Column

Union All vs Merge Transformation

Merge Join

SSIS Access is denied

Expressions, Parameterized con.

SCD using Lookup and Conditional Split

Append tables

Power BI

SSRS

DAX

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