Please enable JavaScript.

Coggle requires JavaScript to display documents.

Power BI, Get Started, Import Data - Coggle Diagram

- - - - Power BI Service (Pro)
        
        Power BI Mobile
        
        Mobile App > Access Anywhere
        
        Website Login > Visuals + Reports + Dashboards
        
        Collaboration & Sharing
      - Windows Only > Datasets + Visuals + Reports
- - - - Regional Settings
        (Default - English (US))
    - - Data Load > Unselect Type detection and relationships
        Regional Settings (Default - English (US))
- - - - Load = Allows you to visualize directly
        
        Analyzing Data
        
        Visualizing Data
      - Transform Data = Allows you to go for data preparation
        
        DATA PREPARATION
        
        Power Query Editor
        After Connect, Perform Queries
        Covert to Number (Text to Number); Pre-check If row/column contain numbers only
        
        Basic Cleaning & Shaping
        
        Connecting to Source Files
        
        Keeping & Removing Rows
        
        Use Row as Header
        
        Using Filters (Manual ones only) (Filters applies to all columns)
        
        Indicative Bars (Remove Empty Rows (Null/Blanks)) or Remove Rows > Remove Blank Row
        
        Append Queries
        
        Replacing Values
        
        YYYY = Whole Number
        
        Formatting Data & Handling Formatting Errors > Detect Data Type > Use Replace to remove errors
        
        Pivoting & Unpivoting
        
        Splitting Columns
        
        Creating Groups and cleaning up projects
        (Moving Columns + Multiple Filters)
        
        1 more item...
        
        Left
        
        Data Queries
        
        Right
        
        Applied steps
        Undo or See
        
        Up
        
        Formula Bar
        
        Ribbons
    - - DATA VISUALISATION
        
        Reports View
      - DATA MODELLING
        
        Model/ Relationship View
        
        Useful in different tables
        
        Data View
        
        You can see your data, majorly used for calculations