Normalization using M language method
[docxpresso file=”https://ilmoirfan.com/wp-content/uploads/2019/11/ses4_topic4-Normalization-using-M-language-method.odt” comments=”true” SVG=”true”] You can download your data files here C05E02 – Bikes
Using an Index Column as a Cue
[docxpresso file=”https://ilmoirfan.com/wp-content/uploads/2019/11/ses5_topic4-Using-an-Index-Column-as-a-Cue.odt” comments=”true” SVG=”true”] You can download your data files here C05E04 – Products
Post-Append Preservation of Titles
[docxpresso file=”https://ilmoirfan.com/wp-content/uploads/2019/11/ses5_topic3-Post-Append-Preservation-of-Titles.odt” comments=”true” SVG=”true”] You can download your data files here C05E04 – Products
Unpivot other columns
[docxpresso file=”https://ilmoirfan.com/wp-content/uploads/2019/11/ses6_topic1-unpivot-other-columns.odt” comments=”true” SVG=”true”] You can download your data files here C06E02
Unpivot Grand totals
[docxpresso file=”https://ilmoirfan.com/wp-content/uploads/2019/11/ses6_topic3-unpivot-Grand-totals.odt” comments=”true” SVG=”true”] You can download your data files here C06E05
Pre-Append Preservation of Titles
[docxpresso file=”https://ilmoirfan.com/wp-content/uploads/2019/11/ses5_topic2-Pre-Append-Preservation-of-Titles.odt” comments=”true” SVG=”true”] You can download your data files here C05E02 – Bikes
Unpivot selected columns
[docxpresso file=”https://ilmoirfan.com/wp-content/uploads/2019/11/ses6_topic2-unpivot-selected-columns.odt” comments=”true” SVG=”true”] You can download your data files here C06E03
Custom Column Technique to Preserve Context
[docxpresso file=”https://ilmoirfan.com/wp-content/uploads/2019/11/ses5_topic1-Custom-Column-Technique-to-Preserve-Context.odt” comments=”true” SVG=”true”] You can download your data files here C05E02 – Bikes
Normalization Approach
[docxpresso file=”https://ilmoirfan.com/wp-content/uploads/2019/11/ses4_topic3-Normalization-Approach.odt” comments=”true” SVG=”true”] You can download your data files here C04E04 – Conversion Table
Combining tables with mismatched columns with a large number of columns
[docxpresso file=”https://ilmoirfan.com/wp-content/uploads/2019/11/ses4_topic2-Combining-tables-with-mismatched-columns-with-a-large-number-of-columns.odt” comments=”true” SVG=”true”]