Power BI

Welcome to my Power BI eBook and Power BI blog.

Contents

  1. Introduction
    1. Why I Love Power BI – Top 10 Reasons
    2. Getting Started with Power BI – What is Desktop, Service, Free, Pro, Premium, Embedded and Mobile
    3. Power BI Training Resources
  2. Administration
    1. Assign Power BI Service Administrator Role
    2. Adding Power BI to Microsoft Teams
    3. Power BI Admin Portal
    4. Assign Power BI Licenses
    5. Office 365 Groups and Power BI
    6. Audit Log
    7. Power BI Home – Announcement
    8. Power BI Home – Exploring the Features
  3. Configuration
    1. Featured Dashboard
  4. Gateway
    1. Installation
    2. Setup Data Sources
  5. Power BI Desktop
    1. Installing Power BI Desktop
    2. DirectQuery Limitation
    3. Enter Data with Ad-Hoc Tables
    4. Version
    5. Query Folding
  6. Power BI Report Server
    1. Installing Power BI Report Server
    2. Install Power BI Desktop for Power BI Report Server
    3. Creating a Report in Power BI Report Server
  7.  Development
    1. DAX (Data Analysis Expressions)
      1. Introduction to DAX
      2. Calculated Columns
      3. DAX YEAR
      4. DAX PREVIOUSYEAR
      5. DAX Single Date Return
      6. USERELATIONSHIP with Multiple Dates
      7. UNION
      8. RELATED
      9. Year over Year with SAMEPERIODLASTYEAR
    2. M (Power Query Formula Language)
      1. Start of the Week
  8. Dashboards
    1. Pin Visual from One Dashboard to Another
    2. Create a Dashboard within Power BI Service
  9.  Reports
    1. Forecasting and Analytics
    2. Goals and Targets
    3. Creating a Report in Power BI Service
  10. Visualizations
    1. Timeline Slicer
    2. Table Heatmap
    3. Word Cloud
  11. Sharing
    1. Groups, Sharing and Editing Reports
    2. Sharing an App with Users
    3. Deep Dive into Comments and Mentions
  12. Apps and Content Packs
    1. Updating Reports and Content Packs
    2. Install Dynamics 365 for Sales Content Packs
    3. Install Dynamics 365 for Financials Content Pack
    4. Salesforce Content Pack
    5. Creating Apps and App Workspaces
    6. Installing the Sales Analytics for Dynamics 365 Content Pack
    7. Installing the Customer Service Analytics for Dynamics 365 App
    8. Finding Reports and Datasets in Apps
    9. Voice of the Customer Analytics for Dynamics 365
    10. Setting up an App Workspace and Assigning Permissions
  13. Solution Templates
    1. Solution Templates on Github
    2. Sales Management for Dynamics 365
  14. Excel
    1. Power BI Service and Importing and Uploading Excel spreadsheets
    2. Local Excel File Data Refresh
    3. Power BI Publisher for Excel
    4. Getting Data in Excel 2016
    5. Publish to Power BI from Excel 2016
    6. Analyze in Excel Feature
  15. Security
    1. Row Level Security (RLS)
  16. Dynamics 365
    1. Power BI and Dynamics 365 Overview
    2. Power BI Tiles in Dynamics 365
    3. Option Sets in Dynamics 365
    4. Add a Power BI Dashboard to D365
    5. Process Analyzer Content Pack
    6. Dynamics 365 Data Security
    7. Content Pack PBIX Source Code
    8. Building Your First Power BI Report for Dynamics 365
  17. Datasets
    1. Streaming PubNub
    2. Dynamics Flow Streaming
    3. Using Quick Insights
  18. Troubleshooting
    1. Desktop Data Refresh Issue
    2. Dates in Column Chart Issue
  19. Case Studies
    1. Power BI and American Football
  20. Resources
    1. Useful Power BI Links and Resources
    2. Top Power BI Learning Resources
    3. Overview of REST API
    4. Power BI REST API Reference