wordpress.simplitrain.com

course

Home / Courses / DP-605T00 Develop dynamic reports with Microsoft Power BI

Agenda

  • Get data from files
  • Get data from relational data sources
  • Create dynamic reports with parameters
  • Get data from a NoSQL database
  • Get data from online services
  • Select a storage mode
  • Get data from Azure Analysis Services
  • Fix performance issues
  • Resolve data import errors

  • Shape the initial data
  • Simplify the data structure
  • Evaluate and change column data types
  • Combine multiple tables into a single table
  • Profile data in Power BI
  • Use Advanced Editor to modify M code

  • Work with tables
  • Create a date table
  • Work with dimensions
  • Define data granularity
  • Work with relationships and cardinality
  • Resolve modeling challenges

  • Create simple measures
  • Create compound measures
  • Create quick measures
  • Compare calculated columns with measures

  • Create calculated columns
  • Learn about row context
  • Choose a technique to add a column

  • Design the analytical report layout
  • Design visually appealing reports
  • Report objects
  • Select report visuals
  • Select report visuals to suit the report layout
  • Format and configure visualizations
  • Work with key performance indicators

  • Introduction to designing reports for filtering
  • Apply filters to the report structure
  • Apply filters with slicers
  • Design reports with advanced filtering techniques
  • Consumption-time filtering
  • Select report filter techniques
  • Case study – Configure report filters based on feedback

  • Distribute a report or dashboard
  • Monitor usage and performance
  • Recommend a development life cycle strategy
  • Troubleshoot data by viewing its lineage
  • Configure data protection

  • Use a Power BI gateway to connect to on-premises data sources
  • Configure a semantic model scheduled refresh
  • Configure incremental refresh settings
  • Manage and promote semantic models
  • Troubleshoot service connectivity
  • Boost performance with query caching (Premium)
Tags
Technical Core Type: Core 1 Vendor: Other Product Line: Microsoft Technical
FREE

Interested in course?

Buy Course

Course Type: Instructor Led