Marek Vavrovic's Blog
Get In Touch
T-SQL
Types of Joins
Control Flow
Subqueries
Ranking Func.
Most expensive produtcs
Grouping
View
Stored Procedure
Window Functions
Calculating Average
Power BI
PowerBI
DAX
Grouping with DAX
SelectColumns,Row
Joins
TREATAS,Unrelated tables
Filter functions, part 1
Filter functions, part 2
Information functions, part 1
Copy of Information functions, part 2
Create a calendar
Time Intelligence functions,part 01
Time intelligence functions, part 02
Time intelligence functions, part 03
Time intelligence functions, part 04
Customer Analysis
Mixed Scenarios
SSIS
Data types & Query Errors
File System Task
Sequence Container
Execute SQL Task
For Loop Container
Foreach Loop Container
Project deployment model
Slowly Chg. Dimension
Lookup transformation
Derived Column
Union All vs Merge Trans.
Merge Join
Incremental Load
SSRS
Data sources & Data sets
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 on the single page
Runnig total by subcategory
Parameter: Text
Parameter: Boolean
Parameter: Cascade
Drill Through Report
Bookmark
StoredProc with IN operator
Sub Report
IIF
Excel
Statistics
Seasonal Index
Power Query
Fetch web data
Contact
Subscribe
Welcome
More
Use tab to navigate through the menu items.
07479 744442
All Posts
SQL
PowerBI
Excel
SSIS
SSRS
DAX
Search
Log in / Sign up
Marek Vavrovic
Mar 24
0 min read
sLOVEnsko 2-tyzdnove zmeny.
Recent Posts
See All
SSIS - Incremental Load
Power Query - Extracting web data using URL parts - Building functions to fetch web data.
Calculating Average using T-SQL
