Using a parameter for a path name
[docxpresso file=”https://ilmoirfan.com/wp-content/uploads/2019/11/ses8_topic1-using-a-parameter-for-a-path-name.odt” comments=”true” SVG=”true”]
Pivoting Tables of Multiline Records
[docxpresso file=”https://ilmoirfan.com/wp-content/uploads/2019/11/ses7_topic5-Pivoting-Tables-of-Multiline-Records.odt” comments=”true” SVG=”true”] You can download your data files here C07E04
Reversing an incorrected Unpivoted table
[docxpresso file=”https://ilmoirfan.com/wp-content/uploads/2019/11/ses7_topic4-Reversing-an-incorrected-Unpivoted-table.odt” comments=”true” SVG=”true”] You can download your data files here C07E04
Create FnUnpivotSummarizedTable
[docxpresso file=”https://ilmoirfan.com/wp-content/uploads/2019/11/ses7_topic3-create-FnUnpivotSummarizedTable.odt” comments=”true” SVG=”true”] You can download your data files here C07E02
Unpivoting N×M Levels of Hierarchy 3
[docxpresso file=”https://ilmoirfan.com/wp-content/uploads/2019/11/ses7_topic1-Unpivoting-N×M-Levels-of-Hierarchy-3.odt” comments=”true” SVG=”true”] You can download your data files here C07E01
Splitting Delimiter Separated values into rows
[docxpresso file=”https://ilmoirfan.com/wp-content/uploads/2019/11/ses2_topic6-Seprating-Delimeter-Seprated-values-into-rows.odt” comments=”true” SVG=”true”] You can download your data files here C02E08
Handling Dates with two locales
[docxpresso file=”https://ilmoirfan.com/wp-content/uploads/2019/11/ses2_topic5-Handlling-dates-with-two-locale.odt” comments=”true” SVG=”true”] You can download your data files here C02E06
Use and implement of Column by Example
[docxpresso file=”https://ilmoirfan.com/wp-content/uploads/2019/11/ses2_topic4-use-and-implementation-of-Column-by-Example.odt” comments=”true” SVG=”true”] You can download your data files here C02E02
Create Relationships manually
[docxpresso file=”https://ilmoirfan.com/wp-content/uploads/2019/11/ses2_topic3-Create-relationship-manually-1.odt” comments=”true” SVG=”true”] You can download your data files here C02E02
Managing Relationships in Power BI
[docxpresso file=”https://ilmoirfan.com/wp-content/uploads/2019/11/ses2_topic2-Manage-relationships-in-Power-BI.odt” comments=”true” SVG=”true”] You can download your data files here C02E07