Microsoft Power BI Certification: DA-100 | PL-300 Exam Prep
11 modules
Lifetime access
Get certified in Microsoft Power BI with our comprehensive exam preparation course!
Overview
Description:
This course is designed to help you prepare for the Microsoft Power BI Certification exams DA-100 and PL-300. Gain the essential skills and knowledge required to pass these exams and become a certified Power BI professional. Throughout this course, you will learn the key concepts and techniques of using Power BI to analyze and visualize data effectively. You will explore various data modeling techniques, data preparation strategies, and learn how to create compelling visualizations and reports. By the end of this course, you will be equipped with the necessary expertise to confidently tackle the certification exams and demonstrate your proficiency in Microsoft Power BI.
Key Highlights:
- Thorough coverage of topics required for the DA-100 and PL-300 exams
- Hands-on exercises and real-world examples for practical understanding
- Insights from experienced instructors with industry expertise
- Access to additional study materials and resources
- Preparation strategies and tips for exam success
What you will learn:
- Learn Data Modeling Techniques
Master the art of designing effective data models to meet business requirements. - Explore Data Preparation Strategies
Discover various data preparation techniques and best practices for efficient data analysis. - Create Engaging Visualizations
Learn how to create visually appealing and interactive dashboards and reports in Power BI. - Gain Insights into Advanced Analytics
Understand how to leverage advanced analytics features in Power BI for data-driven insights. - Practice with Real-world Examples
Apply your knowledge to real-world scenarios through hands-on exercises and projects.
Modules
Introduction to Microsoft Power BI
3 attachments
Course Project Introduction:
Course Outline
Setting Expectations
Preparing for the DA 100 Exam
6 attachments
Recent Changes in Exams
Skill Measured
Exam Question Types
Knowledge-Based Questions
Case Study Question
Scheduling the Exam
Getting Started with Power BI
4 attachments
Downloading and Installing Power BI
Coming Soon
Setting up Power BI Account
Coming Soon
Navigating Power BI Interface
Coming Soon
Creating First Workspace
Data Preparation: connecting to different data source
9 attachments
Introduction
Connecting to data Source
Query Editor
Connecting to JSON Files
Connecting to PBDIS Files
Connecting to the Microsoft Dataverse
Connecting to SSAS
Connecting to SharePoint Online
Data Source Settings
Data Preparation and Transformation
4 attachments
Introduction to profiling
The View Menu
Column Quality and Distribution
Column Profile
Cleaning Transforming and loading
11 attachments
Basic Table Transformations
Index Columns
Conditional Columns and Example
Grouping & Aggregation
Pivoting & Unpivoting
Merging Queries
Appending Queries
Modifying Queries
Intro to M Code & Editing Applied Steps
The Advanced Editor
Common M Function Categories
Data Modeling
8 attachments
What is a Data Model?
Data Tables vs. Lookup Tables
Creating Table Relationships
Relationship Cardinality & Filter Flow
Active & Inactive Relationship
Creating "Snowflake" Schemas
Automatic Date Tables
Date Table Requirements
Dax Calculation
13 attachments
What Is DAX?
Calculated Columns
Measures and Quick Measures
Common DAX Function Categories
Basic Aggregation Functions
Iterator Functions
DIVIDE
CALCULATE and Modifiers
USERELATIONSHIP
ALL
FILTER
TOPN
Time Intelligence Functions
Creating Reports and Dashboard
11 attachments
Power BI Report View
Objects & Basic Charts
Small Multiples
Editing Report Interactions
Drill-through Filters
Bookmarks
Tooltips
Importing Custom Visuals
Accessibility Features
Creating a Dashboard in Power BI Service
Dashboard Interface
Enhancing the report
6 attachments
Chart Types Based on Analysis
Chart Analytics Options
Q&A Visual
Filtering Options
Slicers
Key Influencers Visual
Deploying and maintaining reports
4 attachments
Scheduled Dataset Refresh
Static Row-Level Security
Dynamic RLS
Apply RLS in Power BI Service
FAQs
How can I enrol in a course?
Enrolling in a course is simple! Just browse through our website, select the course you're interested in, and click on the "Enrol Now" button. Follow the prompts to complete the enrolment process, and you'll gain immediate access to the course materials.
Can I access the course materials on any device?
Yes, our platform is designed to be accessible on various devices, including computers, laptops, tablets, and smartphones. You can access the course materials anytime, anywhere, as long as you have an internet connection.
How can I access the course materials?
Once you enrol in a course, you will gain access to a dedicated online learning platform. All course materials, including video lessons, lecture notes, and supplementary resources, can be accessed conveniently through the platform at any time.
Can I interact with the instructor during the course?
Absolutely! we are committed to providing an engaging and interactive learning experience. You will have opportunities to interact with them through our community. Take full advantage to enhance your understanding and gain insights directly from the expert.
Rate this Course
₹ 699.00
Order ID:
This course is in your library
What are you waiting for? It’s time to start learning!
Wait up!
We see you’re already enrolled in this course till Lifetime. Do you still wish to enroll again?
