Analyzing Data with Microsoft Power BI
Learning Objectives
After completing this course, you will be able to:
- Ingest, clean, and transform data Model data for performance and scalability
- Design and create reports for data analysis
- Apply and perform advanced report analytics
- Manage and share report assets
- Create paginated reports in Power BI
Prerequisites
Successful Data Analysts start this role with experience of working with data in the cloud.
Specifically:
- Understanding core data concepts.
- Knowledge of working with relational data in the cloud.
- Knowledge of working with non-relational data in the cloud.
- Knowledge of data analysis and visualization concepts.
Who Should Attend?
The audience for this course are data professionals and business intelligence professionals who want to learn how to accurately perform data analysis using Power BI. This course is also targeted toward those individuals who develop reports that visualize data from the data platform technologies that exist on both in the cloud and on-premises.
Course Outline
Module 1: User and Group Management
After completing this module, students will be able to:
- Create and manage user accounts.
- Describe and use Microsoft 365 admin roles.
- Plan for password policies and authentication.
- Describe the concepts of Zero Trust security.
- Explain the Zero Trust model.
Lessons:
- Identity and Access Management concepts
- The Zero Trust model
- Plan your identity and authentication solution
- User accounts and roles
- Password Management
- Lab: Initialize your tenant - users and groups
- Set up your Microsoft 365 tenant
- Manage users and groups
- Lab: Password management
- Configure Self-service password reset (SSPR) for user accounts in Azure AD
- Deploy Azure AD Smart Lockout
Module 2: Identity Synchronization and Protection
After completing this module, students will be able to:
- Explain directory synchronization.
- Plan directory synchronization.
- Describe and use Azure AD Connect.
- Configure Azure AD Connect Prerequisites.
- Manage users and groups with directory synchronization.
- Describe Active Directory federation.
- Enable Azure Identity Protection.
Lessons:
- Plan directory synchronization
- Configure and manage synchronized identities
- Azure AD Identity Protection
- Lab: Implement Identity Synchronization
- Set up your organization for identity synchronization
Module 3: Identity and Access Management
After completing this module, students will be able to:
- Describe the concept of conditional access.
- Describe and use conditional access policies.
- Plan for device compliance.
- Configure conditional users and groups.
- Configure role-based access control
- Describe the concepts of identity governance
- Configure and use Privileged Identity Management
Lessons:
- Application Management
- Identity Governance
- Manage device access
- Role-Based Access Control (RBAC)
- Solutions for external access
- Privileged Identity Management
- Lab: Use Conditional Access to enable MFA
- MFA Authentication Pilot (require MFA for specific apps)
- MFA Conditional Access (complete an MFA roll out)
- Lab: Configure Privileged Identity Management
- Manage Azure resources
- Assign directory roles
- Activate and deactivate PIM roles
- Directory roles
- PIM resource workflows
- View audit history for Azure AD roles in PIM
Module 4: Security in Microsoft 365
After completing this module, students will be able to:
- Describe several techniques attackers use to compromise user accounts through email.
- Describe techniques attackers use to gain control over resources.
- List the types of threats that can be avoided by using EOP and Microsoft Defender for Office 365.
- Describe the benefits of Secure Score and what kind of services can be analyzed.
- Describe how to use Secure Score to identify gaps in your current Microsoft 365 security posture.
Lessons:
- Threat vectors and data breaches
- Security strategy and principles
- Microsoft security solutions
- Secure Score
- Lab: Use Microsoft Secure Score
- Improve your secure score in the Microsoft 365 Security Center