critwire · Learn · Learn's data

All tracks

Power BI

4 modules, 7 hours. Work through them in order: each module lists the ones it needs first.

  1. p1 Power Query

    • Power BI Desktop
    • 1.5 hours

    Prerequisites: Star schemas (d6)

    Skills: Power Query: Web.Contents on critwire's CSV files; types with an explicit culture; refresh

    • How do I load the star from critwire.com so that it refreshes, on any locale?

  2. p2 The data model

    • Power BI Desktop
    • PostgreSQL with PostGIS
    • 2 hours

    Prerequisites: Power Query (p1)

    Skills: Relationships, cardinality, filter direction, conformed dimensions, factless facts

    • How do I filter records and habitat areas by the same country?

  3. p3 DAX measures

    • Power BI Desktop
    • PostgreSQL with PostGIS
    • 2 hours

    Prerequisites: The data model (p2)

    Skills: Measures: COUNTROWS, DISTINCTCOUNT, CALCULATE, ratios

    • How many sample records per 1,000 km² of forest, by country?

  4. p4 Maps and reports

    • Power BI Desktop
    • PostgreSQL with PostGIS
    • 1.5 hours

    Prerequisites: DAX measures (p3)

    Skills: Map visuals, honest labels, publishing and scheduled refresh

    • How do I build a report that maps records and never calls them a range?