Empowering You To Achieve Success

Search
Facebook Instagram Linkedin Twitter

Power BI Administration Course

Course Overview

Our Power BI Administration Course is an interactive learning experience where participants engage with the instructor through video and audio. Explore visually engaging slides, collaborate with peers, share insights in discussions, complete assessments, and actively engage in activities and case studies.

Elevate your skills and knowledge with a course designed for maximum impact and practical application.

Who Should Attend

  • Business professionals
  • Business analysts
  • Data analysts
  • Research analysts
  • Finance professionals
  • Marketing and sales professionals,
  • HR professionals
  • IT professionals
  • Administrative staff
  • Supervisors
  • General business professionals and staff from any function who need to learn and apply state-of-the-art data analysis techniques to their daily business reporting and decision making.

Course Objectives

At the end of this learning course, participants will be able to:

  • Understand features and capabilities of Power BI
  • Edit and transform data imported from various sources and file types using Power Query
  • Develop dynamic data visuals and dashboards using Power BI Desktop version
  • Automate data reporting and dash-boarding using Power BI

Target Competencies

  • Creating dashboards
  • Reporting, analysis and visualization
  • Power BI Desktop Version
  • Power Query

Course Content

Get and transform – Power Query

  • Get data from Excel
  • Get data from TXT or CSV files
  • Get data from web
  • Get data from folder
  • Transformation
    • Pivoting and unpivoting
    • Filtering
    • Sorting
    • Adding/removing columns
    • Adding conditional columns

Data visualization – Power BI report view

  • Visuals
  • Fields
  • Basic charts
  • Formatting options
  • Filtering
  • Matrix visuals
  • Slicers and timelines
  • Cards
  • Q&A
  • Maps
  • Tooltip
  • Drill through
  • Bookmarks

Working with Data Models and DAX measures

  • Explicit and Implicit measures
  • Creating relationships between tables
  • CALCULATE and RELATED functions
  • Iterative functions e.g. SUMX, COUNTX, AVERAGEX

Table of Contents

Course Code DU0304 Category
Location: Dubai, UAE
Duration: 5 Days
Language: English
Cost: 15,760 SAR
Inquire
Search