top of page

Marek Vavrovic's Blog

07479 744442

Home: SQL

Search

SSIS Append data

Marek Vavrovic

Apr 23, 20223 min read

SSIS Append data

Union All Transformation Merge For Each Loop Container Appending data using Union All Transformation Sorted input not requires Number...

Data Warehouse Dimension Loading Using Lookup and Conditional Split Transformations.

Marek Vavrovic

Apr 22, 20223 min read

Data Warehouse Dimension Loading Using Lookup and Conditional Split Transformations.

I will be doing incremental dimension loading amoung 3 databases. All 3 of them are on the same server. I have a transactional DB Salome...

SSIS Expressions

Marek Vavrovic

Apr 19, 20222 min read

SSIS Expressions

Parameterized Connection Precedence Constraint Expression Execute SQL Task Expression Parameterized Connection I want to create a...

Connecting to Integration Services Access is Denied in SQL Server

Marek Vavrovic

Apr 9, 20221 min read

Connecting to Integration Services Access is Denied in SQL Server

Connection to the Integration Services service on the computer " XXX " failed with the following error: "Access is denied" By default...

HuffnerTextile - SSIS Initial data load.

Marek Vavrovic

Mar 30, 20224 min read

HuffnerTextile - SSIS Initial data load.

Examples of BI joins -Dimensions DimEmployee Select [EmployeeID] [EmployeeKey], case when [EmployeeID] = 2 then 1 when [EmployeeID] in...

SSIS - Incremental Load

Marek Vavrovic

Oct 25, 202111 min read

SSIS - Incremental Load

Data source: http://www.planecrashinfo.com/database.htm. This is an article describing how I have been extracting data from that data...

Merge Join Transformation in SSIS

Marek Vavrovic

Aug 25, 20213 min read

Merge Join Transformation in SSIS

The Merge Join Transformation in SSIS is used to perform SQL Joins such as Inner Join, Left Outer Join, Full Outer Join and Right Outer...

Union All vs Merge Transformation in SSIS

Marek Vavrovic

Aug 24, 20212 min read

Union All vs Merge Transformation in SSIS

Main differences: Union All Merge Sorted input: not requires requires Number of inputs: unlimited only two Sorted...

Derived Column Transformation in SSIS

Marek Vavrovic

Aug 24, 20211 min read

Derived Column Transformation in SSIS

We can create the required expression using those built-in functions, Columns, Operators, and variables. SSIS Derived Column...

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 Solutions

1.1 HuffnerTextile - Relational Database

1.2 HuffnerTextile - Data Warehouse

1.3 HuffnerTextileDW - Initial data load

1.4 HuffnerTextile - Tabular Model

1.5 HuffnerTextile - MDX

1.6 HuffnerTextile - Data Visualisation

Update table using JOIN

Bank Loan Stored Proc

CDC Insert operations

BI Solution

ExcelTopic

Excel - Power Query

Statistics

How to Import Data from a Website to Excel

Append tables using M code

Append with different culture formats

Append tables using a function

Rolling average / total using power query

Custom function: NetWorkingDays

LAG and LEAD using power query

Power Query - Extracting web data

Cohort Analysis

Power Query: Normalizing a table

Power Query : Accessing Records, Rows

Binomial Distribution

Poisson Distribution

Normal DIstribution

Hypothesis testing, z-score

Hypothesis testing, T-Distribution

Hypothesis testing, F-Ratio

One-way ANOVA. Post hoc test.

Two-Way ANOVA

Simple linear regression

Multiple linear regression

Seasonal Indices

Latest articles on MaVaAnalytics.com

html, css, javascript websites

Jul 7, 20221 min read

html, css, javascript websites

Tic Tac Toe - online game How to play? Create a room and share the room name with your friend. Only two people are allowed per room. The...

this is a testing page...

May 21, 20221 min read

this is a testing page...

Excel embedded HTML code <iframe src="https://apps.powerapps.com/play/46fa0XXXXXbb43-e86da93bdc60?tenantId=XXXXX-4cd1-9ead-21a8XXXXX"...

How to efficiently copy - paste a code

May 10, 20221 min read

How to efficiently copy - paste a code

1.add this extention to your web browser (Blackbox - Select. Copy. Paste & Search) https://chrome.google.com/webstore/detail/blackbox-sel...

Home: Blog Feed

Home: Video

Video Channel

Video Channel

Watch Now

MaVa Analytics

Naturally Curious

Home: Welcome

Home: Subscribe

Contact

Home: Contact

bottom of page