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
Total course bookings
Number of teachers
Classes finished
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
- There is no exam associated with this training course
Books
- Course material for Analysing Data with power BI provided
Delivery Method
- Instructor-led Classroom Training at our premises
- Live Virtual Online Training attend in real-time from anywhere
- In-House Training at your premises (4+ participants)
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
- Data Professionals
- Business Intelligence Professionals
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
The training courses are designed for participants who need to create compelling visual reports, who want to update their basic knowledge and learn the DAX language to create more complex measures, columns, and tables.
- Suite 2, 53 Dryburgh Street, West Melbourne VIC 3003
- 1300 649 299
- [email protected]