Training agenda
  1. Introduction
    • Discussing Power BI Desktop & On-Line
    • What is Business Intelligence
    • The essential benefits from the use of Power BI
  2. Connection with data coming from different sources
    • Files (among others Excel, CSV, TXT)
    • Folders
    • WWW websites
    • Relative databases
    • Other
  3. Relation management
    • Automatic relations detection
    • Manual adding relations
    • Modifying the existing relations
    • The features of connections (cardinality)
    • The role and the use of filtering directions
  4. How to deal with the low quality data – Power Query editor
    • Power Query editor capabilities
    • Operating on verses, columns
    • Changing the type of data
    • Separating and merging
    • Unpivot
    • Creating simple functions
  5. Data analysis
    • What is DAX (Data Analysis eXpressions) language
    • Making calculations with the use of the most important DAX functions
      (among others SUM, SUMX, AVERAGE, COUNT, COUNTROWS, DISTINCOUNTNOBLANK, CALCULATE, RELATED)
    • Creating calculation columns
    • Adding readymade calculations for visualisation
  6. Creating visualisation in Power BI
    • Website settings – size and proportions
    • A review of available visualisations
    • Discussing optimal ways to use the most popular visualisations
    • Filtering on the level of page, report, visualisation and measure
    • Modifying settings of formatting in the report
    • How to use calculation context in visualisations
    • The settings of visualisation’s interaction
    • Arranging and levelling visualisation
    • Downloading non-standard visualisation
  7. Report views
    • A view for computer
    • A view for telephone, tablet
  8. Publishing reports for Power BI Online service
    • Discussing Power BI Online (Working areas, Data sets, Reports, Desktops, Natural language) website services
    • Sharing reports