Power BI Intermediate

Course Content

Power BI Intermediate

• Lesson 1: DATA CONNECTIONS
  • INTRODUCTION
  • THE PARTS OF POWER BI
    
    • The flow of work in Power BI
    • Building blocks of Power BI
  • DATA SOURCES IN POWER BI DESKTOP
  • DATA SOURCES
    
    • File data sources
    • Database data sources
    • Power Platform data sources
    • Azure data sources
    • Online Services data sources
    • Other data sources
  • CONNECTING TO A DATA SOURCE
    
    • Using PBIDS files to get data
    • PBIDS file examples
• Lesson 2: QUERY TRANSFORMATIONS
  • INTRODUCTION
  • USING POWER QUERY EDITOR
    
    • The query ribbon
    • The left pane
    • The center (data) pane
    • The query settings pane
  • LAB: SHAPING & COMBINING DATA
• Lesson 3: DATE / TIME TABLES
  • APPLY AUTO DATE/TIME IN POWER BI DESKTOP
    
    • How it works
    • Work with auto date/time
    • Configure auto date/time option
  • AUTO DATE/TIME GUIDANCE IN POWER BI DESKTOP
  • SET AND USE DATE TABLES IN POWER BI DESKTOP
    
    • Setting your own date table
    • Marking your date table as the appropriate data type
• Lesson 4: DATA ANALYSIS EXPRESSIONS (DAX)
  • CALCULATIONS
    
    • Measures
    • Calculated columns
    • Calculated tables
    • Formulas
    • Functions
    • Data types
    • Operators
    • Process and refresh
    • Troubleshooting
    • Let's look at an example
    • Organizing your measures
  • DEMONSTRATION: CREATE YOUR OWN MEASURES IN POWER BI DESKTOP
    
    • Prerequisites
    • Automatic measures
    • Create and use your own measures
    • Create a measure
  • LAB: MODELLING DATA
• Lesson 5: VISUALIZATIONS INPOWER BI REPORTS
  • USE CONDITIONAL FORMATTING IN TABLES
    
    • Format background or font color
    • Color by color scale
    • Color by rules
    • Color by color values
    • Color based on a calculation
  • ADD DATA BARS
    
    • Add icons
    • Format as web URLs
    • Considerations and limitations
  • INTRODUCTION TO POWER BI Q&A VISUALIZATIONS
    
    • What are Q&A visualizations?
    • Demonstration: Create a Q&A visual using a suggested question
    • Create a Q&A visual using a natural language query
    • Format and customize the Q&A visual
    • Convert your Q&A visual into a standard visual
    • Advanced features of the Q&A visual
    • Considerations and troubleshooting
• Lesson 6: POWER BI SERVICE
  • POWER BI - SHARING
    
    • Collaborate in a workspace
    • Distribute insights in an app
    • Share a dataset
    • Share dashboards and reports
    • Annotate and share from the Power BI mobile apps
    • Print or save as PDF or other static file
    • Embed in secure portals
    • Publish to public web sites
    • Create and deploy template apps
  • NEW WORKSPACE IN POWER BI
    
    • Create one of the new workspaces
    • Workspace contact list
    • Workspace OneDrive
    • Give access to your workspace
    • Distribute an app
  • APPS IN POWER BI
    
    • What is a Power BI app?
    • Advantages of apps
    • Get a new app
    • Publish an app in Power BI
    • Licenses for apps
    • Publish your app
    • Change your published app
    • Design the navigation experience
    • Considerations for using the new navigation builder option
    • Automatically install apps for end users
    • Unpublish an app
    • View your published app

FAQs

• How do I enrol in this online training?

  You can enrol in this training on our website and make an online payment using any of the following option

  • Visa Credit or Debit Card
  • MasterCard
  • American Express
  • Diners Club
  • PayPal

  Once payment is received, you will automatically receive a payment receipt and access information via email.