this is a testing page...
Excel embedded HTML code <iframe src="https://apps.powerapps.com/play/46fa0XXXXXbb43-e86da93bdc60?tenantId=XXXXX-4cd1-9ead-21a8XXXXX"...
top of page
07479 744442
Home: SQL
Search
Marek Vavrovic
- May 9, 2022
- 1 min
Northwind Dashboard
Northwind dashboard created in Power BI Desktop.
2670
Marek Vavrovic
- May 1, 2022
- 2 min
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...
3,0390
Marek Vavrovic
- Apr 30, 2022
- 2 min
Cohort Analysis
Excel blog about Cohort analysis: Customer Retention & Cohort Analysis (mavaanalytics.com) Sample Data First thing I need to do is to add...
1310
Marek Vavrovic
- Apr 13, 2022
- 1 min
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...
1620
Marek Vavrovic
- Apr 12, 2022
- 1 min
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...
1680
Marek Vavrovic
- Mar 31, 2022
- 3 min
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...
380
Marek Vavrovic
- Oct 21, 2021
- 2 min
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...
8690
Marek Vavrovic
- Sep 23, 2021
- 2 min
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...
1630
Marek Vavrovic
- Jun 17, 2021
- 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...
8,8271
Marek Vavrovic
- Jun 16, 2021
- 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...
5600
Marek Vavrovic
- Jun 10, 2021
- 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....
7,7721
Marek Vavrovic
- Jun 5, 2021
- 2 min
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...
550
Marek Vavrovic
- Jun 5, 2021
- 3 min
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...
1140
Marek Vavrovic
- May 11, 2021
- 1 min
Tesla Financial Reports 2009-2020 analysis
Link to dashboard: https://app.powerbi.com/view?r=eyJrIjoiNzFlNmM3YzEtYzE2ZC00Mjk1LWE1MDctNGM4MzgxZjhkYTUwIiwidCI6IjQyNTFlNjhmLTEzZjctNG...
1260
Marek Vavrovic
- Dec 31, 2020
- 1 min
Covid-19 new cases in Slovakia
A look at the new covid-19 cases through the 14 day period.
590