Home: SQL

Search

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...

SQL

Marek Vavrovic

Apr 22, 20223 min read

Change Data Capture (CDC) In SQL Server

Incremental load for inserts (no updates or deletes) Incremental load for insert, update, delete Overview SQL Server Change Data Capture...

SQL

Marek Vavrovic

Apr 16, 20227 min read

Using T-SQL to create a bank loan statement

CREATE PROC sp_LoanAmount ( --Supplying default values @LoanAmount Money = 1000, @RateOfInterest decimal(5,2) = 5, @TimePeriod tinyint =...

BI Solutions

Marek Vavrovic

Apr 6, 20221 min read

Update table using join statement

Examples of SQL Update Join RIGHT JOIN LEFT JOIN INNER JOIN WHERE clause CASE statement Computed Columns create table MyTarget (id int...

BI Solutions

Marek Vavrovic

Apr 5, 20223 min read

SQL Server Transactions

What is a Transaction in SQL Server? A transaction is a set of SQL statements that should be executed as one unit. That means a...

BI Solutions

Marek Vavrovic

Apr 4, 20225 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...

BI Solutions

Marek Vavrovic

Mar 31, 20223 min read

HuffnerTextile - Multidimensional Model

Links to download: MDX - CALCULATIONS Gross Profit Gross Profit Margin Gross Profit Y-o-Y % Growth Cost Ratio Error Ratio Error Meters...

BI Solutions

Marek Vavrovic

Mar 30, 202210 min read

HuffnerTextile - Tabular Model

HufferTextileDW.abf HuffnerTextile.sln This solution contains 4 Perspectives. The way you create them is when you click on the New...

BI Solutions

Marek Vavrovic

Mar 30, 20222 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...

BI Solutions

Marek Vavrovic

Mar 30, 20224 min read

Huffner Textile - Data Warehouse Design

Files to download: -sql database backup -SQL Server Database Project Types of Data Warehouse Schema STAR SCHEMA The simplest and the most...

BI Solutions

Marek Vavrovic

Mar 30, 20223 min read

Huffner Textile - Relational database

Database Design Objective Eliminate Data Redundancy: the same piece of data shall not be stored in more than one place. This is because...

BI Solutions

Marek Vavrovic

Mar 30, 20223 min read

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

Continue

Project Deployment Model

Continue

Slowly Changing Dimensions

Continue

Lookup Transformation

Continue

Derived Column

Continue

Union All vs Merge Transformation

Continue

Merge Join

SSIS Access is denied

Expressions, Parameterized con.

SCD using Lookup and Conditional Split

Append tables

Power BI

SSRS

DAX

Continue

Pokračovat

Data Source , Data Set in SSRS

Tabular Report with Wizard

Pokračovat

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

Pokračovat

Running Total

Pokračovat

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.5 HuffnerTextile - MDX

1.6 HuffnerTextile - Data Visualisation

BI Solution

ExcelTopic

Excel - Power Query

Statistics

Back to Top

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

LAG and LEAD using power query

Power Query - Extracting web data

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

Seasonal Indices

Latest articles on MaVaAnalytics.com

html, css, javascript websites

How it works: 1. The app will show you 18 playing cards. 2. Pick one card in your mind. Just remember it. 3. You’ll be shown a few groups...

Jul 7, 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"...

May 21, 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...

May 10, 20221 min read

Home: Blog Feed

Home: Video

Video Channel

Watch Now

MaVa Analytics

Naturally Curious

Home: Welcome

Home: Subscribe

Contact

Back to Top

Home: Contact

Data Warehouse Dimension Loading Using Lookup and Conditional Split Transformations.

Change Data Capture (CDC) In SQL Server

Using T-SQL to create a bank loan statement

Update table using join statement

SQL Server Transactions

HuffnerTextile - Data Visualisation PowerBI Desktop

HuffnerTextile - Multidimensional Model

HuffnerTextile - Tabular Model

HuffnerTextile - SSIS Initial data load.

Huffner Textile - Data Warehouse Design

Huffner Textile - Relational database

Power BI

SSIS

SSRS

DAX

BI Solutions

Excel - Power Query

Statistics

Latest articles on MaVaAnalytics.com

html, css, javascript websites

this is a testing page...

How to efficiently copy - paste a code

Morning Rush

Into the Blue

Beach Patrol

Towering Heights

Stick with Me

The Standoff

A Long Wait

Swish

Video Channel

MaVa Analytics

Contact