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