✉️ Training@almawred-uae.com
Power BI: Data Visualization and Dashboards AL Mawred Speciality Training

Power BI: Data Visualization and Dashboards

Why Attend

Professionals are faced with the challenge of presenting data analysis on a platform where management can easily access, quickly interpret and intelligently use for decision making. Many different platforms are available but certainly Microsoft’s Power BI is one of the most useful and increasingly popular tools. In this course, we will go over several functionalities used in Power BI – Desktop version to create dashboards and present data visually. A powerful tool normally used alongside Power BI is Power Query which is mainly used to get data from external sources, transform it, prepare it for analysis and automate all this process. Typically data is loaded into Power BI using Power Query which will be covered in this course as well.

AL Mawred Speciality Training
Overview
Course Methodology

Live online course where participants will be able to interact with instructor (video and audio), view slides, collaborate with others, comment on discussions, complete assessments, activities and case studies. 

Course Objectives

By the end of the 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 dashboarding using Power BI
Target Audience

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.

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

This is a hands-on training course. Participants are required to use their computers and download Power BI Desktop version.

Course Outline
  • 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
    • 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
Mawred Certificate
Mawred Certifications
Al mawred Professional Certificate (Mawred Certificate)

Mawred Certificate courses by Al mawred Training & Consulting are designed for those willing to challenge themselves and go the extra distance. Participants who fully attend an Mawred Certificate course and successfully complete the test on the last day, will receive a Al mawred Professional Certificate (Mawred Certificate), in addition to the one they receive for full attendance. Mawred Certificate certificates are regionally recognized and can be quite valuable when applying for more senior roles within the organization or outside.

List of Certified Courses
Schedule & Fees
Virtual Learning

This course is also offered in Virtual Learning, click on the course below.


Quick Enquiry Ask Call


Related Courses