Business Intelligence (Power BI)

Topic outline

• Select topic Introduction to Business Inrelligence

  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

  
  
• Select topic Topic 2: Working with Power BI Desktop Files

  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

  
  
• Select topic Topic 3:Working with Data

  Topic 3:Working with Data

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

  
  
• Select topic Topic 4: Using the Query Editor

  Topic 4: Using the Query Editor

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

  
  
• Select topic Topic 5: Data Modeling

  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

  
  
• Select topic Topic 6:Working with Reports and Visualizations

  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

  
  
• Select topic Topic 7: A Closer Look at Visualizations

  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