Power BI - amitbhilagude/userfullinks GitHub Wiki

  1. Steps
    1. Preparing Data
      1. Load Data from Data Sources
      2. Transform It.
    2. Modelling Data
      1. Relationship between Tables
      2. Reporting
      3. Basic Calculation
      4. Time Intelligence
      5. Evaluation Context
      6. Referencing and Duplicating
      7. unpivot
  2. Supported Databases
    1. On-Prem Databases
    2. Network files
    3. APIs with OData
    4. Clouds like Azure or O365
  3. Option to Connect to Power BI
    1. Direct Query
      1. Recommended for Large Data sets. Small interval of refersh
    2. Live Connect
      1. No data sets are created and Power BI directly connects to Source data set like Analysis service. Get data directly from Source
    3. Existing connectors
      1. Data sets are stored in Power BI and requires refresh
  4. Pbix and Pbit file
    1. Pbix file also keep data loaded from data source. It also compresses data so pbix file size becomes smaller than actual data size
    2. Pbit file only have template of data sources etc. it will never store data but loads on demand.
  5. Option for Transformation
    1. DAX queries
    2. Custom Functions
    3. M Language
    4. Measure
      1. Name of Measure = Choose function(use ' for table list')
      2. Click the checkbox so that Power BI will automatically create visualisation
  6. Steps to build report
    1. Finalise reports.
    2. Design model and relationship to show these reports. Includes one to many and cross filter.
    3. Finalise global filters.
    4. Look into data and start transforming to reach out to that model.
    5. Create Hierarchy