Program Brief

Analyzing statistics and creating reports that help in decision-making is one of the most important things in the business world, and Microsoft Power BI is one of the most important tools for analysis and decision support, as it gives decision makers a comprehensive view of important and critical data in the organization, through a set of integrated services that Analyze, share, and transform data into interactive dashboards and reports. This training program is designed to provide participants with the knowledge and skills needed to design and build scalable data models, filter, transform and process data, learn how to create dashboards, create and optimize reports, and configure and manage workspaces.

Program Goals

At the end of the training program, the participant should be able to:

  • Discuss the various methods and best practices that are in line with business and technical requirements for modeling, visualizing, and analyzing data with Power BI.
  • Access and process data from a range of data sources including both relational and non-relational data.
  • Implement proper security standards and policies across the Power BI spectrum including datasets and groups.
  • Manage and deploy reports and dashboards for sharing and content distribution.
  • Build paginated reports within the Power BI service and publish them to a workspace for inclusion within Power BI.
Program Agenda
Module 1: Get Data from Different Data Sources
  • 1 Identify and connect to a data source

    • 2 Change data source settings

      • 3 Select a shared dataset or create a local dataset

        • 4 Select a storage mode

          • 5 Choose an appropriate query type

            • 6 Identify query performance issues

              • 7 Use parameters

                Module 2: Profile the Data
                • 1 Identify data anomalies

                  • 2 Examine data structures

                    • 3 Interrogate column properties

                      • 4 Interrogate data statistics

                        Module 3: Clean, Transform, and Load the Data
                        • 1 Resolve inconsistencies, unexpected or null values, and data quality issues

                          • 2 Apply user-friendly value replacements

                            • 3 Identify and create appropriate keys for joins

                              • 4 Evaluate and transform column data types

                                • 5 Apply data shape transformations to table structures

                                  • 6 Combine queries

                                    • 7 Apply user-friendly naming conventions to columns and queries

                                      • 8 Leverage Advanced Editor to modify Power Query M code

                                        • 9 Configure data loading

                                          • 10 Resolve data import errors

                                            Module 4: Design a Data Model
                                            • 1 Define the tables

                                              • 2 Configure table and column properties

                                                • 3 Define quick measures

                                                  • 4 Flatten out a parent-child hierarchy

                                                    • 5 Define role-playing dimensions

                                                      • 6 Define a relationship's cardinality and cross-filter direction

                                                        • 7 Design the data model to meet performance requirements

                                                          • 8 Resolve many-to-many relationships

                                                            • 9 Create a common date table

                                                              • 10 Define the appropriate level of data granularity

                                                                Module 5: Develop a Data Model
                                                                • 1 Apply cross-filter direction and security filtering

                                                                  • 2 Create calculated tables

                                                                    • 3 Create hierarchies

                                                                      • 4 Create calculated columns

                                                                        • 5 Implement row-level security roles

                                                                          • 6 Set up the Q

                                                                            Module 6: Create Measures by Using DAX
                                                                            • 1 Use DAX to build complex measures

                                                                              • 2 Use CALCULATE to manipulate filters

                                                                                • 3 Implement Time Intelligence using DAX

                                                                                  • 4 Replace numeric columns with measures

                                                                                    • 5 Use basic statistical functions to enhance data

                                                                                      • 6 Create semi-additive measures

                                                                                        Module 7: Optimize Model Performance
                                                                                        • 1 Remove unnecessary rows and columns

                                                                                          • 2 Identify poorly performing measures, relationships, and

                                                                                            • 3 Improve cardinality levels by changing data types

                                                                                              • 4 Improve cardinality levels through summarization

                                                                                                • 5 Create and manage aggregations

                                                                                                  Module 8: Create Reports
                                                                                                  • 1 Add visualization items to reports

                                                                                                    • 2 Choose an appropriate visualization type

                                                                                                      • 3 Format and configure visualizations

                                                                                                        • 4 Import a custom visual

                                                                                                          • 5 Configure conditional formatting

                                                                                                            • 6 Apply slicing and filtering

                                                                                                              • 7 Add an R or Python visual

                                                                                                                • 8 Configure the report page

                                                                                                                  • 9 Design and configure for accessibility

                                                                                                                    • 10 Configure automatic page refresh

                                                                                                                      Module 9: Create Dashboards
                                                                                                                      • 1 Set mobile view

                                                                                                                        • 2 Manage tiles on a dashboard

                                                                                                                          • 3 Configure data alerts

                                                                                                                            • 4 Use the Q

                                                                                                                              • 5 Add a dashboard theme

                                                                                                                                • 6 Pin a live report page to a dashboard

                                                                                                                                  • 7 Configure data classification

                                                                                                                                    Module 10: Enrich Reports for Usability
                                                                                                                                    • 1 Configure bookmarks

                                                                                                                                      • 2 Create custom tooltips

                                                                                                                                        • 3 Edit and configure interactions between visuals

                                                                                                                                          • 4 Configure navigation for a report

                                                                                                                                            • 5 Apply sorting

                                                                                                                                              • 6 Configure Sync Slicers

                                                                                                                                                • 7 Use the selection pane

                                                                                                                                                  • 8 Use drill through and cross filter

                                                                                                                                                    • 9 Drilldown into data using interactive visuals

                                                                                                                                                      • 10 Export report data

                                                                                                                                                        • 11 Design reports for mobile devices

                                                                                                                                                          Module 11: Enhance Reports to Expose Insights
                                                                                                                                                          • 1 Apply conditional formatting

                                                                                                                                                            • 2 Apply slicers and filters

                                                                                                                                                              • 3 Perform top N analysis

                                                                                                                                                                • 4 Explore statistical summary

                                                                                                                                                                  • 5 Use the Q

                                                                                                                                                                    • 6 Add a Quick Insights result to a report

                                                                                                                                                                      • 7 Create reference lines by using Analytics pane

                                                                                                                                                                        • 8 Use the Play Axis feature of a visualization

                                                                                                                                                                          Module 12: Perform Advanced Analysis
                                                                                                                                                                          • 1 Identify outliers

                                                                                                                                                                            • 2 Conduct Time Series analysis

                                                                                                                                                                              • 3 Use groupings and bindings

                                                                                                                                                                                • 4 Use the Key Influencers to explore dimensional variances

                                                                                                                                                                                  • 5 Use the decomposition tree visual to break down a measure

                                                                                                                                                                                    • 6 Apply AI Insights

                                                                                                                                                                                      Module 13: Deploy and Maintain Deliverables
                                                                                                                                                                                      • 1 Manage datasets

                                                                                                                                                                                        • 2 Configure a dataset scheduled refresh

                                                                                                                                                                                          • 3 Configure row-level security group membership

                                                                                                                                                                                            • 4 Providing access to datasets

                                                                                                                                                                                              • 5 Configure incremental refresh settings

                                                                                                                                                                                                • 6 Promote or certify a dataset

                                                                                                                                                                                                  Module 14: Create and Manage Workspaces
                                                                                                                                                                                                  • 1 Create and configure a workspace

                                                                                                                                                                                                    • 2 Recommend a development lifecycle strategy

                                                                                                                                                                                                      • 3 Assign workspace roles

                                                                                                                                                                                                        • 4 Configure and update a workspace app

                                                                                                                                                                                                          • 5 Publish, import, or update assets in a workspace

                                                                                                                                                                                                            • 6 Apply sensitivity labels to workspace content

                                                                                                                                                                                                              Program Requirements

                                                                                                                                                                                                              Not Available

                                                                                                                                                                                                              Program Path

                                                                                                                                                                                                              Names of the training programs that are integrated (enriched) with the training program:

                                                                                                                                                                                                              • Not Available

                                                                                                                                                                                                              Names of the training programs that after the training program:

                                                                                                                                                                                                              • Not Available
                                                                                                                                                                                                              Program Method
                                                                                                                                                                                                              • Lecture
                                                                                                                                                                                                              • Case Studies
                                                                                                                                                                                                              • Exercises and assignments
                                                                                                                                                                                                              Evaluation Method
                                                                                                                                                                                                              • Pre Exam
                                                                                                                                                                                                              • Post Exam
                                                                                                                                                                                                              Training Type
                                                                                                                                                                                                              • In Class Training
                                                                                                                                                                                                              • Online Training

                                                                                                                                                                                                              Add Comment

                                                                                                                                                                                                              CAPTCHA

                                                                                                                                                                                                              Realted Program

                                                                                                                                                                                                              Anti-Money Laundering Awareness for Insurance Sector

                                                                                                                                                                                                              Money Laundering schemes is a global phenomenon that ruins economies of entire countries from one aspect, as well as being a main source of financing terrorism. Therefore, most countries have worked together to formulate certain rules and guidelines to fight it, and the insurance industry is not safe from money laundering and is one of the industries exposed and used for money laundering and terrorism funding. This program is designed to provide candidates working in the insurance sector with a proper understanding of Anti-Money Laundering & Financing Terrorism, how to detect it, the different forms of fraud in insurance & the various strategies for combating it. Also, candidates will be exposed to the main international organizations that work in this area beside the Saudi Central Bank regulations that must be complied with.

                                                                                                                                                                                                              Details

                                                                                                                                                                                                              Introduction to Financing & Investment

                                                                                                                                                                                                              Global capital markets are rapidly evolving, which necessitates the development of skills to identify financial and security risks as well as discovering the investment opportunities for business This program aims to introduce the principles of investment and financing and the distinction between personal and corporate investments in terms of the investment environment and how to make an investment or financing decision, as well as the impact of modern financial technologies on investment and financing operations

                                                                                                                                                                                                              Details

                                                                                                                                                                                                              Preparation Program for Professional Exam for Saudi Capital Market Rules and Regulations- (General Chapter)- (CME-1B)

                                                                                                                                                                                                              This training program aims to prepare participants with the knowledge and skills necessary to pass the mandatory exam for Saudi Capital Market Rules and Regulations- (General Chapter)- (CME-1B), This exam This exam is mandatory by the Capital Market Authority that is provided in cooperation with the Chartered Institute for Securities & Investment (CISI) to those who wish to work in the capital markets. This training program gives an overview of the Saudi capital market. In addition, it covers the most prominent topics related to the CMA regulations, such as the Securities Business Regulations, the Capital Market Institutions Regulations, in addition to the Anti-money Laundering and Counter-terrorist Financing rules, prohibitions and systems and controls.

                                                                                                                                                                                                              Details

                                                                                                                                                                                                              Preparation Program for the Professional Exam for Principles of Insurance (280)- LOMA

                                                                                                                                                                                                              The Associate, Life Management Institute (ALMI) awarded by Life Office Management Association (LOMA) is a global professional qualification that focuses on knowledge and skills relevant to the insurance industry and the financial services sector, in addition to being a standard of excellence in preparing industry experts. Principles of Insurance- LOMA 280 one of the subjects required to obtain the fellowship, it covers many modules such as principles of insurance, the process of becoming insured, and the policyowner’s contractual rights. The course includes information on the features of individual and group life insurance, health insurance, and annuity products.

                                                                                                                                                                                                              Details

                                                                                                                                                                                                              Preparation Program for the Professional Exam for Insurance Administration (301)- LOMA

                                                                                                                                                                                                              The Associate, Life Management Institute (ALMI) awarded by Life Office Management Association (LOMA) is a global professional qualification that focuses on knowledge and skills relevant to the insurance industry and the financial services sector, in addition to being a standard of excellence in preparing industry experts. Insurance Administration- LOMA 301 one of the subjects required to obtain the fellowship, it covers many modules such as individual and group life coverages, in addition to focusing on underwriting, reinsurance, claims, and customer service.

                                                                                                                                                                                                              Details

                                                                                                                                                                                                              Excellence Customer Experience

                                                                                                                                                                                                              Increasing competition has forced businesses to think carefully about deepening and improving their relationship with customers. Customer experience is the driver of organizations transformation and business development. This program focuses on developing and refining the skills of employees to improve the customer experience at all stages of engagement with the customer. The program also covers how to develop a basic model for improving customer experience that ensure customer satisfaction and loyalty, which results in increasing the organization's market share and maximizing its profits, in addition to developing a positive customer experience culture within the organization at all customer touchpoints.

                                                                                                                                                                                                              Details

                                                                                                                                                                                                              Effective Sales Skills in Insurance Companies

                                                                                                                                                                                                              A salesman is a reflection of the insurance organization, and he must have technical skills, excellent communication skills, and perseverance in order to build relationships of trust with customers to whom he proposes appropriate solutions, with the primary objective of achieving the company's sales goals efficiently. This Program covers the concept of and importance of sales, its basic stages and the characteristics of a successful sales person, as well as how to handle different types of customers, sales techniques, smart targeting, attracting customers, how to maintain their loyalty to the organization and how to maximize sales, in addition to focusing on the mechanism of dealing with objections and complaints effectively.

                                                                                                                                                                                                              Details

                                                                                                                                                                                                              Preparation Program for Credit Advisor Professional Exam- 4th Edition

                                                                                                                                                                                                              This training program aims to prepare participants with the knowledge and skills necessary to pass the mandatory professional exam for the credit advisor, which is intended for all employees of service delivery channels, customer care, & financing preparation in the banking & finance sectors This program is designed to familiarize participants with all financing products, instructions for providing a real estate/mortgage financing product, the mechanism for obtaining financing, the main steps, & documents for obtaining financing products, highlighting the Saudi company for credit Information & the credit report form, in addition to the operational & credit risks that customers may be exposed to, & how to manage those risks. Objectives, their nature, principles of conduct and work ethics, as well as a review of the relevant laws & regulations, which enable them to perform their duties towards customers & the beneficiary professionally & responsibly.

                                                                                                                                                                                                              Details

                                                                                                                                                                                                              Effective Communication Skills

                                                                                                                                                                                                              Communication is the basis of success, the greater the ability to communicate effectively, the greater the chances of success in work and personal life. This training program is designed to improve and develop the verbal and nonverbal communication skills of employees, and to provide participants with communication skills to achieve the goals of the communication process, in addition to developing the skills of listening, presentation, recitation and feedback, and understanding the purposes of body language to enhance the communication process.

                                                                                                                                                                                                              Details

                                                                                                                                                                                                              Debt Capital Markets

                                                                                                                                                                                                              Bonds are a type of debt which states a promise of payment by the bond issuer to the bond holder, according to specific terms at the time the bond is issued. The government is the largest issuer of bonds; long-term government bonds are issued to finance expenditures required by governments to support their countries, banks and large corporations are also major issuers of bonds. This program is designed to provide participants with a sound understanding of dealing in the debt and bond market and gain the ability to understand the different types of bonds and methods of evaluating and pricing them according to the return and to identify the risks associated with bonds and how to make the decision to invest in bonds

                                                                                                                                                                                                              Details

                                                                                                                                                                                                              Preparation Program for Professional Exam for International Introduction to Securities and Investment- (CME-1A)

                                                                                                                                                                                                              This training program aims to prepare participants with the knowledge and skills necessary to pass the exam for International Introduction to Securities and Investment- (CME-1A), This exam is mandatory by the Capital Market Authority that is provided in cooperation with the Chartered Institute for Securities & Investment (CISI) to those who wish to work in the capital markets. This training program covers several related topics such as introduction to the financial services sector, the economic environment, assets and capital markets, investment funds, regulations, and ethical principles as well as other financial products.

                                                                                                                                                                                                              Details

                                                                                                                                                                                                              Preparation Program for Compliance Foundation Professional Exam

                                                                                                                                                                                                              This training program aims to prepare the participants with the knowledge and skills necessary to pass the Compliance Foundation Professional Exam. The program covers issues related to regulatory compliance and the principles of compliance with legal requirements for providing financial services. In addition, the program reviews money laundering legislation, terrorist financing, and anti-fraud laws.

                                                                                                                                                                                                              Details

                                                                                                                                                                                                              Teamwork Skills

                                                                                                                                                                                                              There is a Chinese proverb that says: Behind every capable person there are capable people. Collaboration is a vital part of personal and professional life, so learning team development and organizational culture is a great start to a better future. This training program is designed to provide participants with the concept of team work, the mechanisms for building it, the importance of developing the group spirit among the participants, and mechanisms for increasing the degree of team cohesion, rooting group values and unifying the vision among team members, which increases the effectiveness of work teams and reduces friction and conflict between teams within the organization through Unity of vision and goals and achieving more effective results.

                                                                                                                                                                                                              Details

                                                                                                                                                                                                              Islamic Banking Basics

                                                                                                                                                                                                              This program is designed to introduce the ethics of financial transactions in Islamic banking, in addition to acquiring basic knowledge of Islamic banking transactions by identifying the Shari’a regulations for financial transactions, and banking services with Shari’a compliant. The program enables participants to gain the ability to distinguish the characteristics of an Islamic bank from a conventional bank, as well as learn about the principles and characteristics of accounting standards for Islamic financial transactions and operations in accordance with Shari’a regulations.

                                                                                                                                                                                                              Details
                                                                                                                                                                                                              We value your feedback

                                                                                                                                                                                                              Dear visitor, we hope that you will participate in improving and developing the services provided by the academy on the website.

                                                                                                                                                                                                              Was it easy to find what you were looking for on the Academy's website?
                                                                                                                                                                                                              Was the information presented on the Academy’s website sufficient and useful?
                                                                                                                                                                                                              Please share with us your suggestions for developing the website
                                                                                                                                                                                                              Thank you!