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...
top of page
07479 744442
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
Incremental Load
SSIS Access is denied
Expressions, Parameterized con.
SCD using Lookup and Conditional Split
Append tables
Power BI
SSRS
DAX
Index
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
Parameter: Get values from query
Parameter : Boolean
Parameter: Cascade
Drill Through Report
Create a Bookmark
Stored Proc with IN operator
Create a Sub Report
IIF
T-SQL Stored Procedure
Grouping and summarizing
SELECTCOLUMNS, ROW
Joins with DAX
Unrelated tables, TREATAS
Filter Functions, part one
Filter Functions, part two
Information functions, part one
Information functions, part two
Creating a Date dimension table
Time intelligence functions, part 01
Time intelligence functions, part 02
Time intelligence functions, part 03
Time intelligence functions, part 04
Customers Analysis
Mixed Scenarios
Disconnected table
Cohort Analysis
COGR by DAX
SSRS
BI Solution