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, 20221 min read
Northwind Dashboard
Northwind dashboard created in Power BI Desktop.
3460
Marek Vavrovic
May 1, 20222 min read
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...
4,4490
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...
1660
Marek Vavrovic
Apr 13, 20221 min read
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...
2430
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...
2410
Marek Vavrovic
Mar 31, 20223 min read
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...
520
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...
1,2250