Business Intelligence (Power BI)
Section outline
-
- 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
-
- Connecting to Data Sources with Power BI Desktop
- Connecting to an Excel Workbook
- Viewing All Connection Options
- Creating a Manual Dataset
- Managing Data Sources
- Connecting to Data Sources with Power BI Desktop
-
- Transforming and Sanitizing Data
- Using Data View
- Cleaning Irregularly Formatted Data
- Managing Columns
- Sorting Table Data
-
- Opening the Query Editor
- The Query Editor Interface
- Query Settings Pane
- Merge Queries
- Append Queries
-
- 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
-
- 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
-
- 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
- Summary
- Matrixes, Tables, and Charts