MICROSOFT CERTIFIED: ANALYSING DATA WITH POWER BI

This course will discuss the various methods and best practices that are in line with business and technical requirements for modeling, visualizing, and analysing data with Power BI.

The course will also show

• how to access and process data from a range of data sources including both relational and non-relational data.
• how to implement proper security standards and policies across the Power BI spectrum including datasets and groups.
• discuss how to manage and deploy reports and dashboards for sharing and content distribution.
• how to build paginated reports within the Power BI service and publish them to a workspace for inclusion within Power BI.

Audience Profile

The audience for this course is 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.

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

You can gain the prerequisites and a better understanding of working with data in Azure by completing Microsoft Azure Data Fundamentals before taking this course.

After completing this course, students 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

COURSE OUTLINE

Module 1:  Get Started with Microsoft Data Analytics

This module explores the different roles in the data space, outlines the important roles and responsibilities of a Data Analysts, and then explores the landscape of the Power BI portfolio.

Lessons

• Data Analytics and Microsoft
• Getting Started with Power BI

Module 2: Prepare Data in Power BI

This module explores identifying and retrieving data from various data sources. You will also learn the options for connectivity and data storage, and understand the difference and performance implications of connecting directly to data vs. importing it.

Lessons

• Get data from various data sources
• Optimize performance
• Resolve data errors

Module 3: Clean, Transform, and Load Data in Power BI

This module teaches you the process of profiling and understanding the condition of the data. They will learn how to identify anomalies, look at the size and shape of their data, and perform the proper data cleaning and transforming steps to prepare the data for loading into the model.

Lessons

• Data shaping
• Enhance the data structure
• Data Profiling

Module 4: Design a Data Model in Power BI

 This module teaches the fundamental concepts of designing and developing a data model for proper performance and scalability. This module will also help you understand and tackle many of the common data modelling issues, including relationships, security, and performance.

Lessons

• Introduction to data modelling
• Working with tables
• Dimensions and Hierarchies

Module 5: Create Model Calculations using DAX in Power BI

This module introduces you to the world of DAX and its true power for enhancing a model. You will learn about aggregations and the concepts of Measures, calculated columns and tables, and Time Intelligence functions to solve calculation and data analysis problems.

Lessons

• Introduction to DAX
• DAX context
• Advanced DAX

Module 6: Optimize Model Performance

In this module, you are introduced to steps, processes, concepts, and data modeling best practices necessary to optimize a data model for enterprise-level performance.

Lessons

• Optimize the model for performance
• Optimize DirectQuery Models
• Create and manage Aggregations

Module 7: Create Reports

This module introduces you to the fundamental concepts and principles of designing and building a report, including selecting the correct visuals, designing a page layout, and applying basic but critical functionality. The important topic of designing for accessibility is also covered.

Lessons

• Design a report
• Enhance the report

Module 8: Create Dashboards

In this module, you will learn how to tell a compelling story through the use of dashboards and the different navigation tools available to provide navigation. You will be introduced to features and functionality and how to enhance dashboards for usability and insights.

Lessons

• Create a Dashboard
• Real-time Dashboards
• Enhance a Dashboard

Module 9: Create Paginated Reports in Power BI

This module will teach you about paginated reports, including what they are how they fit into Power BI. You will then learn how to build and publish a report.

Lessons

• Paginated report overview
• Create Paginated reports

Module 10: Perform Advanced Analytics

This module helps you apply additional features to enhance the report for analytical insights in the data, equipping you with the steps to use the report for actual data analysis. You will also perform advanced analytics using AI visuals on the report for even deeper and meaningful data insights.

Lessons

• Advanced Analytics
• Data Insights through AI visuals

Module 11: Create and Manage Workspaces

This module will introduce you to Workspaces, including how to create and manage them. You will also learn how to share content, including reports and dashboards, and then learn how to distribute an App.

Lessons

• Creating Workspaces
• Sharing and Managing Assets

Module 12: Manage Datasets in Power BI

In this module, you will learn the concepts of managing Power BI assets, including datasets and workspaces. You will also publish datasets to the Power BI service, then refresh and secure them.

Lessons

• Parameters
• Datasets

Module 13: Row-level security

This module teaches you the steps for implementing and configuring security in Power BI to secure Power BI assets.

Lessons

• Security in Power BI

MICROSOFT CERTIFIED AZURE FUNDAMENTALS

This course will provide foundational level knowledge on cloud concepts; core Azure services; security, privacy, compliance, and trust; and Azure pricing and support. This is a fundamental level course designed for learners who wish to initiate learning about cloud concepts.

There are no prerequisites for taking this course. However, the more technical knowledge a student has the more they will understand about the cloud.

Intended Learning Outcomes (ILOs)

After completing this course, students will be able to:

• Define cloud computing and its key advantages.
• Explain public, private, and hybrid cloud models.
• Explain IaaS, PaaS, and SaaS cloud services.
• Identify core Azure architectural components, such as regions, geographies, and resource groups.
• Identify usage cases for Azure core services and products, such as virtual machines and storage.
• Identify usage cases for Azure solutions, such as the Internet of Things and Machine Learning.
• Identify what Azure management tools are available such as Azure PowerShell and the CLI.
• Describe virtual network security connectivity options such as Network Security Groups.
• Describe Azure identity authentication and authorization options.
• Describe usage cases for the Security Center, Key vault, threat and information protection options.
• Describe Azure policies and role-based access control.
• Describe usage cases for Azure Monitor and Azure Service Health.
• Describe privacy, compliance, and data protection standards.
• Use an Azure subscription.
• Plan and manage costs.
• Explain Azure support options.
• Describe Azure SLAs.
• Explain Azure service lifecycles.

COURSE OUTLINE

Understand cloud concepts

• Describe the benefits and considerations of using cloud services
• Describe the differences between Infrastructure-as-a-Service (IaaS), Platform-as-a-Service (PaaS) and Software-as-a-Service (SaaS)
• Describe the differences between public, private and hybrid cloud models

Understand core Azure services

• Understand the core Azure architectural components
• Describe some of the core products available in Azure
• Describe some of the solutions available on Azure
• Understand Azure management tools

Understand security, privacy, compliance, and trust

• Understand securing network connectivity in Azure
• Describe core Azure Identity services
• Describe security tools and features of Azure
• Describe Azure governance methodologies
• Understand monitoring and reporting options in Azure
• Understand privacy, compliance and data protection standards in Azure

Understand Azure pricing and support

• Understand Azure subscriptions
• Understand planning and management of costs
• Understand the support options available with Azure
• Describe Azure Service Level Agreements (SLAs)
• Understand service lifecycle in Azure

MICROSOFT 365 CERTIFIED: FUNDAMENTALS

This course provides foundational knowledge on the considerations and benefits of adopting cloud services and the Software as a Service (SaaS) cloud model, with a specific focus on Microsoft 365 cloud service offerings.

This course is designed for Business Decision Makers and IT Professionals who aspire to deploy cloud services in their organization, or who are simply looking to acquire foundational knowledge on cloud fundamentals.

COURSE OUTLINE

Module 1: Cloud concepts

Explore the core concepts of cloud computing and how it can help your business.

Lessons

• Principles of cloud computing
• What is Microsoft 365?
• Select a cloud deployment

Module 2: Microsoft 365 productivity and teamwork capabilities

Learn about the productivity and teamwork solutions in Microsoft 365 and the capabilities that help people be more productive using Microsoft 365 – The World’s Productivity Cloud.

Lessons

• Microsoft 365 productivity and teamwork solutions
• Engage employees with Microsoft Stream, Teams, and Yammer
• Get more done with Office across all devices
• File storage and sharing with OneDrive and SharePoint

Module 3: Microsoft 365 business management capabilities

Learn about the business management solutions in Microsoft 365 and the capabilities that help organizations be more productive using Microsoft 365 – The World’s Productivity Cloud.

Lessons

• Manage your business with Microsoft 365
• Simplify device management with Microsoft Endpoint Manager
• Get more done and stay secure with Windows 10
• Harness business intelligence with Microsoft 365 analytics and reporting

Module 4: Microsoft 365 security and compliance

Learn about the Microsoft 365 security and compliance solutions areas and the capabilities available to help enterprises secure their enterprise and meet regulatory requirements.

Lessons

• Security principles and solution areas
• Identity and access management
• Threat protection
• Cloud security
• Information protection and governance
• Compliance management
• Manage risk, discovery, and audit

Module 5: Microsoft 365 Licensing and support

Learn more about Microsoft 365 licensing, service, and support options.

Lessons

• Identify licensing options available in Microsoft 365
• Describe support offerings in Microsoft 365 services
• Describe the service life cycle in Microsoft 365