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.
2150
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...
1,7490
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...
980
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...
1030
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...
670
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...
270
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...
5690
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...
970
Marek Vavrovic
- Jun 17, 2021
- 2 min