Identifying Context from Cell Proximity
[docxpresso file=”https://ilmoirfan.com/wp-content/uploads/2019/11/ses5_topic5-Identifying-Context-from-Cell-Proximity.odt” comments=”true” SVG=”true”] You can download your data files here C06E01
Handling sub totals
[docxpresso file=”https://ilmoirfan.com/wp-content/uploads/2019/11/ses6_topic5-handling-sub-totals.odt” comments=”true” SVG=”true”]
Unpivot 2×2 levels of Hierarchy
[docxpresso file=”https://ilmoirfan.com/wp-content/uploads/2019/11/ses6_topic4-unpivot-2×2-levels-of-Hierarchy.odt” comments=”true” SVG=”true”] You can download your data files here C06E05
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