Section outline

  • Introduction to Business Inrelligence

    Collapse all Expand all

      •  Business Intelligence Concepts and Platform Capabilities
      • Introduction to Power BI

        • What is Power BI?
        • The Building Blocks of Power BI
        • The Power BI Desktop Interface
        • Important Information about Power BI Updates
        • Working with Power BI Desktop Files
        • Opening Files
        • Saving Files
        • Creating a New File


  • Topic 2: Working with Power BI Desktop Files

      • Connecting to Data Sources with Power BI Desktop
        • Connecting to an Excel Workbook
        • Viewing All Connection Options
        • Creating a Manual Dataset
        • Managing Data Sources


  • Topic 3:Working with Data

      • Transforming and Sanitizing Data
      • Using Data View
      • Cleaning Irregularly Formatted Data
      • Managing Columns
      • Sorting Table Data


  • Topic 4: Using the Query Editor

      • Opening the Query Editor
      • The Query Editor Interface
      • Query Settings Pane
      • Merge Queries
      • Append Queries


  • Topic 5: Data Modeling

      • What is DAX?
      • Creating a New Table
      • Creating a New Calculated Column
      • Creating a New Measure
      • Managing Relationships
      • Using the Relationships View
      • Creating Relationships
      • Editing Relationships
      • Deleting Relationships
      • Using the Manage Relationships Dialog
      • Summary
      • Review Questions


  • Topic 6:Working with Reports and Visualizations

      • Managing Report Pages
      • Navigating Through Pages
      • Showing and Hiding Pages
      • Adding Pages
      • Deleting Pages
      • Renaming Pages
      • Changing Page Order
      • Changing Report View Options
      • Setting Page View Options
      • Customizing Your View
      • Using Phone vs. Desktop Layout
      • Understanding Drill through Options
      • Changing Category and Summarization Options
      • Arranging Visualizations
      • Editing Interactions
      • About Custom Visualizations
      • Adding Static Objects to a Report
      • Inserting Pictures
      • Inserting Text Boxes
      • Inserting Shapes
      • Working with Static Objects
      • Summary
      • Review Questions


  • Topic 7: A Closer Look at Visualizations

      • Matrixes, Tables, and Charts
        • Creating a Table
        • Creating a Matrix
        • Overview of Chart Types
        • Creating Charts
        • Maps
        • Tree map
        • Bubble Map
        • Filled Map
      • Cards, Gauges, and KPIs
        • Creating a Card
        • Creating a Gauge
        • Creating a KPI
        • Slicers
      • Creating a Slicer
        • Using Slicers
        • Customizing Slicer Display
        • Changing Slicer Mode
        • Changing Slicer Orientation
        • Summary
        • Review Questions and Project works
      • Creating Bookmarks, "what if" parameters and role level securities
        • Summary
        • Review Questions and Project works