PL-300 | DA-100 Microsoft Power BI Certification - Exam Prep
- Offered byUDEMY
PL-300 | DA-100 Microsoft Power BI Certification - Exam Prep at UDEMY Overview
Duration | 9 hours |
Total fee | ₹399 |
Mode of learning | Online |
Credential | Certificate |
PL-300 | DA-100 Microsoft Power BI Certification - Exam Prep at UDEMY Highlights
- 30-Day Money-Back Guarantee
- Certificate of completion
- Full lifetime access
- Learn from 80 downloadable resources,12 articles and 2 practise tests
PL-300 | DA-100 Microsoft Power BI Certification - Exam Prep at UDEMY Course details
- The only course you need to PASS the PL-300
- exam: Become Microsoft Certified: Power BI Data Analyst Associate!
- Full Practice Exam including explanations!
- Master Power BI and become an expert
- Learn Data Prep and Data Transforming
- Create high-performing Data Models
- Master Data Visualization and enhance your reports
- Analyze your Data and deliver real insights
- Deliver the reports to your audience and manage Power BI in the Cloud
- The ONLY course you need to prepare and PASS the PL-300
- DA-100 exam and become Microsoft Certified: Power BI Data Analyst Associate!Make your exam preparation and learning Power BI fun & easy but very effective: By learning with real-life & hands-on projects, quizzes, case studies and a full practice exam!This course teaches you every single topic you need to master the exam with ease.Why is this the ONLY course you need to take to pass the PL-300 exam?Learn everything you need to know to master Microsoft Power BI and to prepare and pass the PL-300 exam.Every single topic is covered in depthAll new topics for the updated PL-300 exam are also included!Full practice examTips for successEverything you need to know about the exam itselfMany quizzes to test your knowledgeLearn all the practical knowledge to master Power BI in the real worldThis course guides you step-by-step to prepare in the best possible way for the examDon't waste your time but focuses on what really matters to master the exam!The instructor:Hi, my name is Nikolai, and I have just passed my PL-300 exam. I am teaching Power BI in 150+ countries and one of the best-rated courses. My mission with the course: Take the stress out of your exam prep, make it fun but very effective to make the most out of your preparation time. I want to make sure you have the best chances of succeeding and moving your career forward with the PL-300 exam and Power BI in your professional career.Enroll now and get:Lifetime access including all future updates9 hours video lecturesAll project files and source files to downloadFull practice exam with explanationsTips for success30-days-money back guarantee (no questions asked!)
PL-300 | DA-100 Microsoft Power BI Certification - Exam Prep at UDEMY Curriculum
Introduction
Welcome to this course!
Who is the course for?
Understanding the exam
How to learn with the course
Our project
Installing Power BI Desktop
Peparing the Data (15-20%)
-- Getting data from different data sources I --
Connect to a data source
Change the data source settings
-- Clean, transform and load the data --
The Query Editor
Shape and transform tables
User-friendly naming conventions
Resolving inconsistencies & nulls
Evaluate and transform column data types
Append queries
Merge queries
Pivot & Unpivot
Conditional columns
Columns from examples
Transpose
Data Profiling
Resolve data import errors
-- Getting data from different data sources II --
Files from folders
Relational SQL database
Select a storage mode
Dataverse
Data Loading with parameters
Preparing the Data
Model the Data (30-35%)
-- Design a data model --
Why a data model?
The star schema
Creating relationships
Cardinality
Cross filter direction
Table and column properties
Common date table (using DAX)
Common date table (using Power Query)
Mark as date table
Hierarchies
Data Granularity
Role playing dimensions
-- Create model calculations by using DAX --
Calculated columns
Measures
Iterator functions
CALCULATE
FILTER
ALL
Time intelligence
Semi-additive measures
Statistical functions
Quick measures
-- Optimize model performance --
Optimize model performance
Identify poorly performing measures, relationships, and visuals
Model the Data
Visualize and Analyze the Data (25-30%)
-- Create reports --
Table and matrix
Column charts, line charts and area charts
Combo charts and treemaps
Card, multi-row card, and gauge visual
Pie chart, donut chart and funnel
Scatter chart, waterfall chart and maps
Customize and configure visuals
Custom tool tips
Configure report page
Conditional formatting
Applying slicing and filtering
Sorting
-- Enhance reports for usability and storytelling --
Synch slicers
Using themes
Drillthroughs and drill downs
Bookmarks
Page navigation
Edit interactions
Analyze feature
Identify outliers
Create groups, bins and clusters
Analytics pane
Forecast feature
AI features
Visualize and Analyze the Data
Deploy and Maintain Assets (20-25%)
-- Manage workspaces --
How to go on from here
Subscription models
Sign up for Power BI service
Power BI interface
Publish reports and export data
Sensitivity labels
Create a workspace
Assign workspace roles
Create a workspace app
Publish, import, or update assets in a workspace
-- Create dashboards --
Manage tiles in a dashboard
Pin live page to a dashboard
Q&A feature
Apply a dashboard theme
Configure mobile layout
Get insights
-- Manage files and datasets --
Identify when a gateway is required
Configure a dataset scheduled refresh
Subscriptions
Data alerts
Promote or certify content
Define RLS roles in Power BI Desktop
Configure row-level security group membership
Dynamic RLS
Providing access to a dataset
When to use paginated reports
Import custom visuals
Analyze in Excel feature
Deploy and Maintain Assets
Case studies & final practice test
Mastering the case studies
Case study
Tips for the final exam simulation
Final exam simulation
Scheduling the exam & final tips
Schedule the exam & start the exam
Exam tips
Post your certification
Renewing your certification
Bonus lecture