Microsoft Power BI Data Analyst

Outline

• Discover data analysis
  • Overview of data analysis
  • Roles in data
  • Tasks of a data analyst
  • Check your knowledge
  • Summary
• Get started building with Power BI
  • Use Power BI
  • Building blocks of Power BI
  • Tour and use the Power BI service
  • Knowledge check
• Create interactive reports using Copilot for Power BI
  • Prepare your data for use with Copilot for Power BI
  • Use Copilot for Power BI to model your data
  • Create reports with Copilot for Power BI
  • Create summaries with Copilot for Power BI
  • Knowledge check
• Get data in Power BI
  • 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
  • Exercise - Prepare data in Power BI Desktop
  • Check your knowledge
• Clean, transform, and load data in Power BI
  • 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
  • Exercise - Load data in Power BI Desktop
  • Check your knowledge
• Describe Power BI Desktop models
  • Star schema design
  • Analytic queries
  • Configure report visuals
  • Check your knowledge
• Choose a Power BI model framework
  • Describe Power BI model fundamentals
  • Determine when to develop an import model
  • Determine when to develop a DirectQuery model
  • Determine when to develop a composite model
  • Choose a model framework
  • Knowledge check
• Design a semantic model in Power BI
  • Work with tables
  • Create a date table
  • Work with dimensions
  • Define data granularity
  • Work with relationships and cardinality
  • Resolve modeling challenges
  • Exercise - Model data in Power BI Desktop
  • Check your knowledge
• Write DAX formulas for Power BI Desktop models
  • Write DAX formulas
  • DAX data types
  • Work with DAX functions
  • Use DAX operators
  • Use DAX variables
  • Check your knowledge
• Add measures to Power BI Desktop models
  • Create simple measures
  • Create compound measures
  • Create quick measures
  • Compare calculated columns with measures
  • Check your knowledge
  • Exercise - Create DAX Calculations in Power BI Desktop
• Add calculated tables and columns to Power BI Desktop models
  • Create calculated columns
  • Learn about row context
  • Choose a technique to add a column
  • Check your knowledge
• Use DAX time intelligence functions in Power BI Desktop models
  • Use DAX time intelligence functions
  • Additional time intelligence calculations
  • Exercise - Create Advanced DAX Calculations in Power BI Desktop
  • Check your knowledge
• Optimize a model for performance in Power BI
  • Introduction to performance optimization
  • Review performance of measures, relationships, and visuals
  • Use variables to improve performance and troubleshooting
  • Reduce cardinality
  • Optimize DirectQuery models with table level storage
  • Create and manage aggregations
  • Check your knowledge
• Enforce Power BI model security
  • Restrict access to Power BI model data
  • Restrict access to Power BI model objects
  • Apply good modeling practices
  • Exercise: Enforce model security
  • Knowledge check
• Scope report design requirements
  • Identify the audience
  • Determine report types
  • Define user interface requirements
  • Define user experience requirements
  • Explore report designs
  • Check your knowledge
• Design Power BI reports
  • 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
  • Exercise - Design a report in Power BI desktop
  • Check your knowledge
• Create visual calculations in Power BI Desktop
  • Understand visual calculations
  • Create visual calculations
  • Use parameters in visual calculations
  • Exercise - Create visual calculations in Power BI Desktop
  • Knowledge check
• Configure Power BI report filters
  • 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
  • Check your knowledge
• Enhance Power BI report designs for the user experience
  • Design reports to show details
  • Design reports to highlight values
  • Design reports that behave like apps
  • Work with bookmarks
  • Design reports for navigation
  • Work with visual headers
  • Design reports with built-in assistance
  • Tune report performance
  • Optimize reports for mobile use
  • Exercise - Enhance Power BI reports
  • Check your knowledge
• Perform analytics in Power BI
  • Introduction to analytics
  • Explore statistical summary
  • Identify outliers with Power BI visuals
  • Group and bin data for analysis
  • Apply clustering techniques
  • Conduct time series analysis
  • Use the Analyze feature
  • Create what-if parameters
  • Use specialized visuals
  • Exercise - Perform Advanced Analytics with AI Visuals
  • Check your knowledge
• Create and manage workspaces in Power BI
  • Distribute a report or dashboard
  • Monitor usage and performance
  • Recommend a development life cycle strategy
  • Troubleshoot data by viewing its lineage
  • Configure data protection
  • Check your knowledge
• Manage semantic models in Power BI
  • 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)
  • Check your knowledge
• Create dashboards in Power BI
  • Introduction to dashboards
  • Configure data alerts
  • Explore data by asking questions
  • Review Quick insights
  • Add a dashboard theme
  • Pin a live report page to a dashboard
  • Configure a real-time dashboard
  • Set mobile view
  • Exercise - Create a Power BI dashboard
  • Check your knowledge
• Implement row-level security
  • Configure row-level security with the static method
  • Configure row-level security with the dynamic method
  • Exercise - Enforce row-level security in Power BI
  • Check your knowledge