DA-100 Analyzing Data with Microsoft Power BI

Lenght

1

Price

$123

Version

22

Course Detail:

About This Course

The Analysing Data with power BI is an instructor-led, hands-on certification training course. This course covers various methods and best practices that meet the business and technical requirements for modelling, visualising, and analysing data with Power BI. The course also covers how to access and process data from a variety of data sources, including both relational and non-relational data. Candidates learn how to explore and implement the correct security standards and policies across the Power BI spectrum, including data sets and groups. How to manage and deploy reports and dashboards for sharing and content distribution. Finally, this course will show how to create reports with pages in Power BI and publish them to a workspace for inclusion in Power BI.

This service allows users to make better business decisions by analysing company data. With Power BI, users can create dashboards or reports that will allow them to track metrics and help them extract different data into cloud systems.

This certification training course is available in Melbourne, Sydney, Brisbane, Australia and Live Virtually

Register Now

Name

Phone Number

Location

Timing

Total course bookings

0 +

Number of teachers

0 +

Classes finished

0 +

Total students learning

Pre-requisites

Working knowledge of Microsoft Excel
Understanding of basic 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 visualisation concepts

Exams

Books

Delivery Method

Skills Gained

Data entry, cleaning, and transformation
Data modelling for performance and scalability
Design and create reports for data analysis
Apply and perform advanced report analysis
Manage and share reporting assets
Build reports with pages in Power BI

Audience

Course Outline

Data Analytics and Microsoft
What is Power BI?
Acquire Data from Different Data Sources
How to Optimise Performance?
Resolving Data Errors
About Data Shaping
Understand How to Enhance the Data Structure?
What is Data Profiling?
Introduction to Data Modeling
Understand Working with Tables
What are Dimensions and Hierarchies?
How to Create Model Relationships?
Configure Tables
Model Interface Review
Make Quick Measures
Form Many-to-Many Relationships
Row-Level Security
What is DAX?
Data Analysis Expressions (DAX) Context
Understand Advanced DAX
Form Calculated Tables
Make Calculated Columns
Create Measures
Usage of CALCULATE () Function to Manipulate Filter Context
Time Intelligence Functions
Optimise DirectQuery Models
Understand Creating and Managing Aggregations
Designing a Report
Understand How to Enhance the Report?
Make a Live Connection in Power BI Desktop
How to Design a Report?
Configure Visual Fields ADN Format Properties
Creating and Configuring Sync Slicers

Course Outline

Creating Drill Through Page
Apply Conditional Formatting
Bookmarks Creation and Usage
Creating a Dashboard
About Real-time Dashboards
Develop a Dashboard
Create a Dashboard
Pin Visuals to a Dashboard
Configure a Dashboard Tile Alert
Use Q&A to Create a Dashboard Tile
Paginated Report Overview
How to Create Paginated Reports?
Usage of Power BI Report Builder
Designing the Multi-Page Report Layout
Data Source and Dataset
Creating a Report Parameter
Exporting a Report to PDF
Understand Advanced Analytics
Data Insights over AI Visuals
How to Create Animated Scatter Charts?
Use the Visual to Forecast Values
Work with
Decomposition Tree Visual
Key Influencers Visual
How to Create a Workspace?
Share and Manage the Assets
Map Security Principals to Dataset Roles
Sharing Dashboard
Publishing an App
Understand Parameters
What are Datasets?
Power BI Security