70-778 Microsoft Power BI Certification

Power BI Logo

70-778 Microsoft Power BI Certification Analyzing and Visualizing Data with Microsoft Power BI

Microsoft Power BI Certification is now available and below is more details about it.

Skills measured

This exam measures your ability to accomplish the technical tasks listed below. The percentages indicate the relative weight of each major topic area on the exam. The higher the percentage, the more questions you are likely to see on that content area on the exam. View video tutorials about the variety of question types on Microsoft exams.

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

  • Connect to data sources
    • Connect to databases, files, folders; import from Excel; connect to SQL Azure, Big Data, SQL Server Analysis Services (SSAS), and Power Query
  • Perform transformations
    • Design and implement basic and advanced transformations, apply business rules, change data format to support visualization
  • Cleanse data
    • Manage incomplete data, meet data quality requirements
Model and Visualize Data (45-50%)
  • Create and optimize data models
    • Manage data relationships, optimize models for reporting, manually enter data, Use Power Query
  • Create calculated columns, tables, and measures
    • Create DAX queries for calculated columns, tables, and measures
  • Create performance KPIs
    • Calculate the actual, calculate the target, calculate actual to target
  • Create hierarchies
    • Use date 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
Configure Dashboards in the Power BI Service (25-30%)
  • Configure a dashboard
    • Connect to the Power BI service, publish connections to services by using SQL Server Analysis Services (SSAS), publish visualizations including dataConfigure 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 SQL Server Reporting Services (SSRS)
  • 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 gateways
  • Configure organizational content packs and apps
    • Create a content pack, publish a content pack, edit a content pack, package dashboards and reports, configure app workspace

Preparation options

Instructor-led training

  • 20778A: Analyzing Data with Power BI
From the community
Follow @MSLearning

Price $165.00 USD*

If you have any question feel free to comment.

Be the first to comment

Leave a Reply

Your email address will not be published.