this is a testing page...
HTML code <iframe src="https://apps.powerapps.com/play/46fa0XXXXXbb43-e86da93bdc60?tenantId=XXXXX-4cd1-9ead-21a8XXXXX" frameborder="0"...
top of page
07479 744442
Home: SQL
Search
Marek Vavrovic
- May 9, 2022
- 1 min
Northwind Dashboard
Northwind dashboard created in Power BI Desktop.
1680
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...
9220
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...
410
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...
410
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...
330
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...
210
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...
2940
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...
610
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...
4,1090
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...
3460
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....
4,1401
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...
370
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...
550
Marek Vavrovic
- May 11, 2021
- 1 min
Tesla Financial Reports 2009-2020 analysis
Link to dashboard: https://app.powerbi.com/view?r=eyJrIjoiNzFlNmM3YzEtYzE2ZC00Mjk1LWE1MDctNGM4MzgxZjhkYTUwIiwidCI6IjQyNTFlNjhmLTEzZjctNG...
980
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
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