Power BI SharePoint Online and Mastering SharePoint 2019

RegisterInquiry
Power BI SharePoint Online and Mastering SharePoint 2019
Loading...

B1795

Kuala Lumpur (Malaysia)

02 Nov 2026 -13 Nov 2026

10240 €

Overview

Introduction:

Business intelligence and enterprise collaboration platforms play a significant role in organizing corporate information, strengthening data accessibility, and supporting informed decision making across organizational functions. Microsoft Power BI, SharePoint Online, and SharePoint Server 2019 provide complementary capabilities for data visualization, document management, information governance, business collaboration, and enterprise content administration. This training program explores Power BI data modeling and reporting frameworks, SharePoint Online architecture, Microsoft 365 integration, and SharePoint Server 2019 administration and configuration principles. It also examines enterprise information management, workflow automation, access control structures, business intelligence integration, and governance requirements across cloud based and on-premises SharePoint environments.

Program Objectives:

By the end of this program, participants will be able to:

  • Analyze Microsoft Power BI architecture, data connectivity, and business intelligence reporting frameworks.

  • Evaluate data modeling principles, DAX calculations, and interactive visualization structures.

  • Assess SharePoint Online architecture, collaboration capabilities, and Microsoft 365 integration.

  • Examine SharePoint Server 2019 administration, content management, and enterprise configuration requirements.

  • Explore integration, information security, automation, and governance considerations across Power BI and SharePoint environments.

Targeted Audience:

  • Business Intelligence Analysts and Data Reporting Professionals.

  • SharePoint Administrators and IT Infrastructure Specialists.

  • Microsoft 365 Administrators and Collaboration Platform Managers.

  • Information Management and Digital Transformation Professionals.

  • Business Systems Analysts and Enterprise Application Specialists.

Program Outline:

Unit 1:

Microsoft Power BI Architecture and Business Intelligence Fundamentals:

  • Power BI ecosystem components and business intelligence architecture.

  • Power BI Desktop, Power BI Service, and reporting environments.

  • Data connectivity models and enterprise data source classifications.

  • Import, DirectQuery, and semantic model connectivity considerations.

  • Business intelligence reporting structures and data governance principles.

Unit 2:

Data Preparation, Modeling, and DAX Analytics in Power BI:

  • Power Query transformation capabilities and data preparation frameworks.

  • Data modeling principles, table relationships, and star schema structures.

  • Data Analysis Expressions (DAX) functions, measures, and calculated columns.

  • Filter context, evaluation context, and analytical calculation principles.

  • Data model performance, accuracy, and optimization considerations.

Unit 3:

Advanced Power BI Visualization and Reporting:

  • Interactive dashboards, reports, and data visualization principles.

  • Advanced charts, matrices, slicers, and drill-through capabilities.

  • Time intelligence calculations and comparative performance analytics.

  • Report navigation, bookmarks, and interactive filtering structures.

  • Visualization design standards and executive reporting requirements.

Unit 4:

Power BI Service, Collaboration, and Data Security:

  • Power BI workspaces, applications, and report distribution structures.

  • Semantic model refresh, gateway connectivity, and scheduling requirements.

  • Row-Level Security (RLS) and data access management principles.

  • Power BI collaboration, sharing permissions, and licensing considerations.

  • Power BI administration, usage monitoring, and information governance.

Unit 5:

SharePoint Online Architecture and Microsoft 365 Integration:

  • SharePoint Online architecture and Microsoft 365 service relationships.

  • Communication sites, team sites, and hub site structures.

  • SharePoint site collections, navigation, and information architecture.

  • Integration with Microsoft Teams, OneDrive, and Microsoft 365 services.

  • SharePoint Online administrative roles and tenant governance requirements.

Unit 6:

SharePoint Online Content Management and Collaboration:

  • Document libraries, Microsoft Lists, and content organization frameworks.

  • Metadata, content types, and document classification structures.

  • Document versioning, approval, and content lifecycle management.

  • Enterprise search, navigation, and content discovery capabilities.

  • Collaboration permissions, document sharing, and access control requirements.

Unit 7:

SharePoint Server 2019 Architecture and Administration:

  • SharePoint Server 2019 architecture and on-premises deployment models.

  • Server farm topology, service applications, and infrastructure components.

  • Web applications, site collections, and content database structures.

  • SharePoint Central Administration and administrative configuration.

  • Authentication, service accounts, and infrastructure security considerations.

Unit 8:

SharePoint Server 2019 Content Services and Enterprise Management:

  • SharePoint Server 2019 document management and collaboration capabilities.

  • Managed metadata services, content types, and information architecture.

  • Enterprise search architecture and search service configuration.

  • User Profile Service and organizational information management.

  • SharePoint backup, recovery, monitoring, and maintenance requirements.

Unit 9:

Power BI and SharePoint Integration with Workflow Automation:

  • Power BI report integration within SharePoint Online pages.

  • SharePoint Lists as structured data sources for Power BI reporting.

  • SharePoint Online data connectivity and Power BI refresh considerations.

  • Power Automate workflows and SharePoint process automation structures.

  • Integration limitations between SharePoint Server 2019 and cloud services.

Unit 10:

Enterprise Governance, Security, and Hybrid Information Management:

  • SharePoint Online and SharePoint Server 2019 governance frameworks.

  • Identity management, permissions, and enterprise access control structures.

  • Information classification, retention policies, and compliance requirements.

  • Hybrid SharePoint architecture and cloud–on-premises integration considerations.

  • Power BI and SharePoint administration, audit monitoring, and information lifecycle governance.