Power BI Advanced

Microsoft Power BI is a collection of software services, apps, and connectors that work together to turn your unrelated sources of data into coherent, visually immersive, and interactive insights. Whether your data is a simple Microsoft Excel…
$890
Brand
SKU:
PBA
Duration:
1 Day
Delivery:
Virtual Classroom
Adding to cart… The item has been added
Request a Quote

Power BI Advanced

Microsoft Power BI is a collection of software services, apps, and connectors that work together to turn your unrelated sources of data into coherent, visually immersive, and interactive insights. Whether your data is a simple Microsoft Excel workbook, or a collection of cloud-based and on-premises hybrid data warehouses, Power BI lets you easily connect to your data sources, visualize (or discover) what's important, and share that with anyone or everyone you want.

Audience

Power BI can be simple and fast, capable of creating quick insights from an Excel workbook or a local database. However, Power BI is also robust and enterprise-grade, ready not only for extensive modelling and real-time analytics, but also for custom development. Therefore, it can be your personal report and visualization tool, but can also serve as the analytics and decision engine behind group projects, divisions, or entire corporations. This course is for someone who already has confindence in the topics covered in the Power BI - Intermediate course.

Skills Covered

Upon successful completion of this course, you will be able to:

  • Data Refresh
  • Power BI - advanced reports
  • Power query
  • Data analysis expressions (DAX)
  • Custom visualisations

Course Content

Power BI Advanced

  • Lesson 1: DATA REFRESH
    • INTRODUCTION
      • Understanding data refresh
    • TILE REFRESH
    • REFRESH OF REPORT VISUALS
    • DATA INFRASTRUCTURE DEPENDENCIES
    • CONNECTING TO ON-PREMISES DATA SOURCES
      • Using an enterprise data gateway
      • Deploying a personal data gateway
    • ACCESSING CLOUD DATA SOURCES
      • Accessing on-premises and cloud sources in the same source query
    • CONFIGURE SCHEDULED REFRESH
      • Automatic page refresh
  • Lesson 2: POWER BI, ADVANCED REPORTS
    • GROUP VISUALS IN POWER BI DESKTOP REPORTS
      • Creating groups
      • Hide and show visuals or groups
      • Selecting visuals within a group
      • Apply background color
    • USE GROUPING AND BINNING IN POWER BI DESKTOP
      • Using grouping
      • Using binning
    • TOOLTIPS CUSTOMIZATION IN POWER BI DESKTOP
      • How to customize tooltips
      • Customizing tooltips with aggregation or quick measures
    • USE DRILLTHROUGH IN POWER BI DESKTOP
      • Using drillthrough
      • Use your own image for a back button
      • Pass all filters in drillthrough
      • Add a measure to drillthrough
    • USE CROSS-REPORT DRILLTHROUGH IN POWER BI
      • Enable cross-report drillthrough
      • Set up a cross-report drillthrough target
      • Use cross-report drillthrough
  • Lesson 3: POWER QUERY
    • THE ADVANCED EDITOR
      • Using Query Parameters in Power BI Desktop
  • Lesson 4: DATA ANALYSIS EXPRESSIONS (DAX)
    • QUICK MEASURES
      • Create a quick measure
      • Quick measure example
      • Learn DAX by using quick measures
      • Limitations and considerations
      • Additional information and examples
    • SPECIFY MARK AS DATE TABLE FOR USE WITH TIME-INTELLIGENCE
    • DATE AND TIME FUNCTIONS
      • Calendar
    • CALENDARAUTO
    • DATE
    • DAY
    • TIME-INTELLIGENCE FUNCTIONS
    • SAMEPERIODLASTYEAR
    • TOTALYTD
    • TOTALQTD
    • TOTALMTD
    • OTHER ADVANCED FUNCTIONS
    • IF
      • Logical operators
    • SWITCH
    • SUMX
    • AVERAGEX
    • RELATED
    • RELATEDTABLE
    • LOOKUPVALUE
  • Lesson 5: CUSTOM VISUALISATIONS
    • IMPORTING ORGANIZATIONAL AND MARKETPLACE VISUALS
    • CREATING CUSTOM VISUALS
      • Demonstration: Importing and using a custom visual
      • Lab: Using marketplace visualizations

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.

Buy Now

Our Most Popular Training Courses

PI2

Power BI Certification Course

$1,234

NextTech eLearning

  • Duration 3 Months
View Course
Everything you need to become a PRINCE2 Practitioner, all in one place.
Course Name Exam Access/Duration Price (Incl Tax)  
Power BI Certification Course 3 Months
$1,234
course info
BApps3

PL-300T00: Power BI Data Analyst

$2,670

Microsoft

  • Duration 3 Days
View Course
Everything you need to become a PRINCE2 Practitioner, all in one place.
Course Name Exam Access/Duration Price (Incl Tax)  
PL-300T00: Power BI Data Analyst 3 Days
$2,670
course info
BApps7

Project - Advanced

$550

Microsoft

  • Duration 1 Day
View Course
Everything you need to become a PRINCE2 Practitioner, all in one place.
Course Name Exam Access/Duration Price (Incl Tax)  
Project - Advanced 1 Day
$550
course info
PI5

Microsoft Teams - Advanced

$380

Microsoft

  • Duration 1 Day
View Course
Everything you need to become a PRINCE2 Practitioner, all in one place.
Course Name Exam Access/Duration Price (Incl Tax)  
Microsoft Teams - Advanced 1 Day
$380
course info
BApps3

Power BI Intermediate

$890

Microsoft

  • Duration 1 Day
View Course
Everything you need to become a PRINCE2 Practitioner, all in one place.
Course Name Exam Access/Duration Price (Incl Tax)  
Power BI Intermediate 1 Day
$890
course info