The following topics are taught, based on the areas addressed by the certification test.

Consume and Transform Data By Using Power BI Desktop (20%-25%)

  • Overview of connecting to databases, files, folders, import from Excel
  • Databases
    • Connect to SQL Server using DirectQuery
    • DirectQuery referential integrity settings
    • Connect to Azure SQL Database
    • Connect to Azure SQL Data Warehouse
    • Connect to Azure HDInsight
    • Connect to SQL Server Analysis Services Tabular and Multidimensional databases
  • Files
    • Connect to Excel
    • Connect to CSV Files
    • Connect to Folders
    • Connect to Power BI Service
  • Import PowerPivot/PowerView/PowerQuery from Excel into Power BI
  • Data transformation
    • Basic transformations
    • Advanced transformations
    • Shaping and combining data with Power BI Desktop
    • Manipulating text
    • Transposing and formatting irregular data

CTA-Register-Now-Blue-Button-JPG-Graphic-Cave-1080x565

Model and Visualize Data (45-50%)

  • Managing data relationships
    • Optimizing data models for effective visualizations
    • Optimize data models for Power BI Quick Insights
    • Enter manual data directly into model via Power BI Desktop
  • Using DAX, create calculated columns, tables and measures
    • Power BI Desktop Quick Measures
    • Create measures
    • Create columns
    • Create tables
  • Create performance KPIs
    • Calculate the actual, calculate the target, calculate actual to target
  • Create hierarchies
    • Use date and time based hierarchies
    • Use business hierarchies
    • Resolve hierarchy issues
  • Create and format interactive visualizations
    • Select a visualization type
    • Configure page layout and formatting
    • Setup visual relationships
    • Configure duplicate pages
    • Handle categories that have no data
    • Setup default summaries and categories
    • Position, align, and sort visuals
    • Enable and integrate R visuals
    • Format calculated measures
  • Manage custom reporting solutions
    • Use Power BI API
    • Use Microsoft Power BI Embedded
    • Enable developers to create and edit dashboards through custom applications
    • Enable developers to embed dashboards in applications
    • Authenticate a Power BI web application
    • Enable developers to create custom visuals

CTA-Register-Now-Blue-Button-JPG-Graphic-Cave-1080x565

Configure Dashboards in the Power BI Service (25-30%)

  • Configure a dashboard
    • Dashboards in the Power BI service
      • Configure a dashboard
        • Add text and images
        • Filter dashboards
        • Configure dashboard settings
        • Customize the URL and title
        • Enable natural language queries
  • Publish dashboards
    • Publish to web
    • Publish to Microsoft SharePoint
    • Publish to Power BI Report Server (PBIRS)
  • Configure security for dashboards
    • Create a security group by using the Admin Portal
    • Share dashboard with users or security groups
    • Integrate with Microsoft OneDrive for Business
    • Configure row-level Security
    • Configure data gateways
  • Configure organizational content packs and apps
    • Content Packs
      • Create a content pack
      • Publish a content pack
      • Edit a content pack
      • Package dashboards and reports
    • Apps
      • Process overview
      • Creating app workspaces
      • Publishing to app workspace
      • Creating app specific content
      • Publishing apps
      • Updating app content

CTA-Register-Now-Blue-Button-JPG-Graphic-Cave-1080x565