{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Topics","dCountry","dProduct","Sheet1"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Topics","index":0,"n_rows":32,"n_cols":2,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
["Highline Excel 2016 Class 22: Data Modeling & DAX Formulas"]
[]
["Topics:"]
[1,"Reminder about Terminology for Tables in a Data Model"]
[2,"What is Data Modeling?"]
[3,"Power Pivot Data Model’s Columnar Database"]
[4,"Power Pivot Data Model’s DAX Formulas"]
[5,"DAX Calculated Columns"]
[6,"DAX Measures"]
[7,"Creating Measure in Measure Grid"]
[8,"Implicit vs. Explicit calculations in a PivotTable"]
[9,"DAX Calculated Column or DAX Measure to calculate Total Revenue?"]
[10,"Calendar Table (Dimension Table)"]
[11,"Hiding Tables and Fields not used in PivotTables"]
[12,"DAX Operators"]
[13,"Criteria in a Data Model PivotTables"]
[14,"Advantage of Power Pivot Data Model Columnar Database & Relationships & DAX Measures when you have Big Data."]
[15,"Data Modeling Step 1: Power Query to Clean, Transform & Import Fact Tables"]
[16,"Data Modeling Step 1: Import Dimension Tables from an Excel Sheet"]
[17,"Data Modeling Step 1: Create Calendar Table in Excel & Import to Data Model"]
[18,"Data Modeling Step 2: Create Relationships between Related Tables"]
[19,"Data Modeling Step 3: Create DAX Calculated Columns in Calendar Table"]
[20,"Data Modeling Step 3: Create DAX Calculated Columns in Fact Table for Revenue:"]
[21,"Data Modeling Step 3: Create DAX Measures"]
[22,"Data Modeling Step 3: Alternative Total Revenue Calculation: DAX Measure with SUMX"]
[23,"Data Modeling Step 3: More DAX Measures"]
[24,"Data Modeling Step 4: Hide Tables & Fields not used in PivotTables"]
[25,"Data Modeling Step 5: Create PivotTables and Pivot Charts"]
[26,"Data Modeling Step 6: Refresh Data Model when Source Data Changes"]
[27,"Data Modeling Step 7: Fix Calendar Table"]
[28,"Data Modeling Step 7: After Refreshing"]
[29,"Data Modeling Step 7: Create new DAX Formulas and create New Report."]

{"sheet":"dCountry","index":1,"n_rows":127,"n_cols":2,"rows_kept":127,"cut":false,"hidden":false,"merged":[]}
["CountyCode","Country"]
["AFG","Afghanistan"]
["ALB","Albania"]
["APR","Aprine"]
["ARE","United Arab Emirates"]
["ARG","Argentina"]
["ARM","Armenia"]
["AUS","Australia"]
["AUT","Austria"]
["AZE","Azerbaijan"]
["BEL","Belgium"]
["BGD","Bangladesh"]
["BGR","Bulgaria"]
["BHR","Bahrain"]
["BHS","Bahamas"]
["BIH","Bosnia and Herzegovina"]
["BLZ","Belize"]
["BOL","Bolivia, Plurinational State of"]
["BRA","Brazil"]
["BRB","Barbados"]
["BRN","Brunei Darussalam"]
["BWA","Botswana"]
["CAN","Canada"]
["CHE","Switzerland"]
["CHL","Chile"]
["COL","Colombia"]
["CRI","Costa Rica"]
["CYP","Cyprus"]
["CZE","Czech Republic"]
["DEU","Germany"]
["DNK","Denmark"]
["DOM","Dominican Republic"]
["DZA","Algeria"]
["ECU","Ecuador"]
["EGY","Egypt"]
["ESP","Spain"]
["EST","Estonia"]
["ETH","Ethiopia"]
["FIN","Finland"]
["FJI","Fiji"]
["FRA","France"]
["GBR","United Kingdom"]
["GEO","Georgia"]
["GHA","Ghana"]
["GRC","Greece"]
["GTM","Guatemala"]
["GUM","Guam"]
["HKG","Hong Kong"]
["HND","Honduras"]
["HRV","Croatia"]
["HUN","Hungary"]
["IDN","Indonesia"]
["IND","India"]
["IRL","Ireland"]
["IRQ","Iraq"]
["ISL","Iceland"]
["ISR","Israel"]
["ITA","Italy"]
["JAM","Jamaica"]
["JOR","Jordan"]
["JPN","Japan"]
["KAZ","Kazakhstan"]
["KEN","Kenya"]
["KHM","Cambodia"]
["KOR","Korea, Republic of"]
["KWT","Kuwait"]
["LAO","Lao People's Democratic Republic"]
["LBN","Lebanon"]
["LKA","Sri Lanka"]
["LTU","Lithuania"]
["LUX","Luxembourg"]
["LVA","Latvia"]
["MAC","Macao"]
["MAR","Morocco"]
["MDA","Moldova, Republic of"]
["MDV","Maldives"]
["MEX","Mexico"]
["MKD","Macedonia, the former Yugoslav Republic of"]
["MLT","Malta"]
["MMR","Myanmar"]
["MNG","Mongolia"]
["MUS","Mauritius"]
["MYS","Malaysia"]
["NAM","Namibia"]
["NGA","Nigeria"]
["NLD","Netherlands"]
["NOR","Norway"]
["NPL","Nepal"]
["NZL","New Zealand"]
["OMN","Oman"]
["PAK","Pakistan"]
["PAN","Panama"]
["PER","Peru"]
["PHL","Philippines"]
["POL","Poland"]
["PRI","Puerto Rico"]
["PRT","Portugal"]
["PSE","Palestine, State of"]
["QAT","Qatar"]
["ROU","Romania"]
["RUS","Russian Federation"]
["RWA","Rwanda"]
["SAU","Saudi Arabia"]
["SDN","Sudan"]
["SGP","Singapore"]
["SLV","El Salvador"]
["SOM","Somalia"]
["SRB","Serbia"]
["SVK","Slovakia"]
["SVN","Slovenia"]
["SWE","Sweden"]
["SYR","Syrian Arab Republic"]
["THA","Thailand"]
["TTO","Trinidad and Tobago"]
["TUN","Tunisia"]
["TUR","Turkey"]
["TWN","Taiwan, Province of China"]
["TZA","Tanzania, United Republic of"]
["UGA","Uganda"]
["UKR","Ukraine"]
["UNR","Unkown Region"]
["USA","United States"]
["VEN","Venezuela, Bolivarian Republic of"]
["VNM","Viet Nam"]
["ZAF","South Africa"]
["ZMB","Zambia"]
["ZWE","Zimbabwe"]

{"sheet":"dProduct","index":2,"n_rows":23,"n_cols":4,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
["Product","Retail Price","Standard Cost","Category"]
["Alpine",23.95,10.09,"Beginner"]
["Aspen",23.95,9.48,"Beginner"]
["Bellen",26.99,10.75,"Beginner"]
["Bower Aussie Round",45,18.45,"Competition"]
["Carlota",21.95,8.48,"Beginner"]
["Carlota Doublers",71,30.25,"Freestyle"]
["Crested Beaut",19.95,8.5,"Intermediate"]
["Darnell Tri Fly",11.95,5.25,"Beginner"]
["Eagle",23.95,8.9699999999999989,"Intermediate"]
["Fire Aspen",23.5,9.5500000000000007,"Advanced"]
["Frido Fast Catch",41.95,21.45,"Competition"]
["Fun Fly",6.99,3.25,"Beginner"]
["GelFast",26,11.04,"Competition"]
["Majestic Beaut",28.95,11.49,"Intermediate"]
["Manu LD",252,100.25,"Advanced"]
["Manu MTA",122,49.78,"Competition"]
["Phoenix",25.95,10.85,"Intermediate"]
["Quad",41.95,16,"Freestyle"]
["Sunset",25.5,10.51,"Competition"]
["Sunshine",21.95,8.65,"Beginner"]
["Sunspot",14.5,6,"Novelty"]
["Yanaki",25.99,10.02,"Intermediate"]

{"sheet":"Sheet1","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}