Microsoft Power BI – beginners to advance Level Exam PL-300
Microsoft Power BI – beginners to advance Level Exam PL-300, available at $19.99, has an average rating of 4.58, with 158 lectures, 4 quizzes, based on 43 reviews, and has 1112 subscribers.
You will learn about Build professional business intelligence reports from the ground up While working on real world project, clean and Transform raw data into professional interactive dashboards and Reports Data Analytics Expressions (DAX), Data Modelling, Creating and managing relationships among tables Data Visualisation using Microsoft Power BI Desktop & Service Creating and managing workspace, Apps, data refreshes , assigning roles and other settings Become Master in Microsoft Power BI Desktop and Service This course is ideal for individuals who are Data related Professionals or Students who want to learn Data Cleaning, Transformation, Modelling, DAX, visualisation using MS Power BI with deployment and managing assets in MS Power BI Service It is particularly useful for Data related Professionals or Students who want to learn Data Cleaning, Transformation, Modelling, DAX, visualisation using MS Power BI with deployment and managing assets in MS Power BI Service.
Enroll now: Microsoft Power BI – beginners to advance Level Exam PL-300
Summary
Title: Microsoft Power BI – beginners to advance Level Exam PL-300
Price: $19.99
Average Rating: 4.58
Number of Lectures: 158
Number of Quizzes: 4
Number of Published Lectures: 158
Number of Published Quizzes: 4
Number of Curriculum Items: 164
Number of Published Curriculum Objects: 164
Original Price: $19.99
Quality Status: approved
Status: Live
What You Will Learn
- Build professional business intelligence reports from the ground up
- While working on real world project, clean and Transform raw data into professional interactive dashboards and Reports
- Data Analytics Expressions (DAX), Data Modelling, Creating and managing relationships among tables
- Data Visualisation using Microsoft Power BI Desktop & Service
- Creating and managing workspace, Apps, data refreshes , assigning roles and other settings
- Become Master in Microsoft Power BI Desktop and Service
Who Should Attend
- Data related Professionals or Students who want to learn Data Cleaning, Transformation, Modelling, DAX, visualisation using MS Power BI with deployment and managing assets in MS Power BI Service
Target Audiences
- Data related Professionals or Students who want to learn Data Cleaning, Transformation, Modelling, DAX, visualisation using MS Power BI with deployment and managing assets in MS Power BI Service
Welcome to this comprehensive course on Microsoft Power BI for business intelligence and data analytics. Designed by industry expert trainer and professional in the field of Data analysis using Power BI, in such a way that it takes the learners from beginner’s level to advance level step by step. This course implements real-world project, guiding you through the creation of interactive reports and dashboards from scratch. Aligned with the PL-300 certification exam, our curriculum covers all the features of MS Power BI while providing insider tips on effective visualisation techniques, such as deploying custom filter panes.
Our Claim is that once you learned using this course, you will not be needing to buy any other course for MS Power BI, it is so comprehensively designed.
Throughout the program, you’ll dive into practical scenarios, transforming raw data into dynamic reports that uncover sales trends, campaign performance, product analytics, and regional revenue insights. Starting with an introduction to Power BI Desktop, you’ll gain mastery over its interface, learning data cleaning and transformation techniques to prepare your datasets effectively.
Delving deeper, you’ll explore data modeling, understanding relationships, cardinality, and filter contexts to build flexible data models. Leveraging Data Analysis Expressions (DAX), you’ll create dynamic measures and calculated columns, extracting valuable insights from your data. Our course emphasises the importance of effective visualisation, guiding you through the deployment of various Power BI visuals, including AI-powered options, and optimising report performance for responsiveness and speed.
A highlight of this course is the transition from Power BI Desktop to Power BI Service, where you’ll learn to collaborate and share reports securely in the cloud. From data security concepts to configuring auto-refresh schedules, you’ll ensure your reports are always up-to-date and accessible to relevant stakeholders. By course completion, you’ll possess the skills to develop advanced, interactive reports and dashboards independently, preparing you for success in both professional endeavours and the PL-300 certification exam.
Course Curriculum
Chapter 1: Introduction
Lecture 1: Introduction – What to expect from the course
Lecture 2: Know Your Trainer
Lecture 3: Download Resources
Lecture 4: Downloading & Installing Power BI Desktop
Lecture 5: Introduction to Power BI Desktop Interface
Chapter 2: Data Cleaning and Transformation with Power BI Desktop
Lecture 1: Connecting to Data
Lecture 2: Remove Rows from Table
Lecture 3: Adjusting or Changing Data Types of Columns
Lecture 4: Adding Index Column and understanding alternate rows removal
Lecture 5: How to Keep Rows
Lecture 6: Choose Columns
Lecture 7: Renaming Columns
Lecture 8: Column Sorting
Lecture 9: Column Profiling and Distribution
Lecture 10: How to enable column profiling and distribution for entire rows in table
Lecture 11: Concept of Appending Tables
Lecture 12: Appending Queries
Lecture 13: Adjusting Column Data Types in our Project
Lecture 14: Splitting a Column
Lecture 15: Arithmetic on Column
Lecture 16: Adding a Conditional Column
Lecture 17: Merging Queries – Price Column
Lecture 18: Understanding & Exploring different mergers available in Power BI
Lecture 19: Adding a Custom Column
Lecture 20: Adding Column by Example
Lecture 21: Duplicating a Column
Lecture 22: Column Formatting
Lecture 23: Extracting from a Column
Lecture 24: Scientific Calculations on a Column
Lecture 25: Trigonometric Calculations on a Column
Lecture 26: Rounding Numbers in a Column
Lecture 27: Information on Columns
Lecture 28: Date & Time Column Transformations
Lecture 29: Group By Transformation
Lecture 30: Transpose of a Table
Lecture 31: Reversing Rows of a Table
Lecture 32: Count Rows
Lecture 33: Fill Rows
Lecture 34: Pivot columns
Lecture 35: Unpivot Columns
Chapter 3: Data Modelling and Data Analytics Expression (DAX)
Lecture 1: Introduction to DAX
Lecture 2: Understanding Time Intelligence Part 1
Lecture 3: Understanding Time Intelligence Part 2
Lecture 4: Date Table by Calendar ( ) Function
Lecture 5: Date Table by CalendarAuto ( ) Function
Lecture 6: Understanding and Creating Date Hierarchies in Date Table
Lecture 7: Extracting Year with Year ( ) Function
Lecture 8: Extracting Month with Month ( ) Function
Lecture 9: Extracting Week number with Weeknum ( ) Function
Lecture 10: Extracting Quarter number with Quarter Function
Lecture 11: Implementing Date Hierarchies Manually
Lecture 12: Creating a Separate Table for Measures
Lecture 13: DAX Function SUM ( )
Lecture 14: DAX Functions MAX ( ) & MIN ( )
Lecture 15: DAX Function COUNTROWS ( ) & AVERAGE ( )
Lecture 16: DAX Function CALCULATE ( )
Lecture 17: DAX Function TOTALYTD ( )
Lecture 18: DAX Function DATEADD ( )
Lecture 19: DAX , Arithmetic among measures
Lecture 20: DAX Function IF ( ) Part 1
Lecture 21: DAX Function IF ( ) Part 2
Lecture 22: DAX Function SWITCH ( )
Lecture 23: DAX VARIABLES
Lecture 24: DAX Functions FIRSTNONBLANK ( ) and LASTNONBLANK ( )
Lecture 25: Adjusting Stock Table Dates Hierarchy
Lecture 26: DAX Function SAMEPERIODLASTYEAR ( )
Lecture 27: Data Model View – Properties pane and Display Folders
Lecture 28: Data Model View – Properties pane Continue
Lecture 29: What is Data Modeling?
Lecture 30: Why Data Modeling?
Lecture 31: Types of Data Model
Lecture 32: What is Cardinality? one-to-many Relation
Lecture 33: Cardinality – one-to one Relation
Lecture 34: Cardinality – many-to-many
Lecture 35: Hiding Tables using Model View
Lecture 36: Data modeling for our Project – Part 1
Lecture 37: Data modeling for our Project – Part 2
Chapter 4: Data Visualisation and Creating Dynamic Reports and Dashboards
Lecture 1: Giving Stylish Heading to Dashboard – Shapes & Text
Lecture 2: Deploying Card Visual and its formatting
Lecture 3: Card Visual with Currency Sign
Lecture 4: Deploying 2nd Card Visual
Lecture 5: Quick Deployment of Card Visual with formatting copied – adding one more measure
Lecture 6: Deploying Line Chart
Lecture 7: Formatting the Visuals e.g. Line Chart – Part 1
Lecture 8: Formatting the Visuals e.g. Line Chart – Part 2
Lecture 9: Formatting the Visuals e.g. Line Chart – Part 3
Lecture 10: Deploying Column Clustered Chart with Hierarchical X-Axis
Lecture 11: Understanding Filter Context and Relationships in Data Model View
Lecture 12: Deploying Donut Chart
Lecture 13: Star Schema Data Model Flexibility and Dataset Adjustment
Lecture 14: Adding Constant Lines in Line Chart
Lecture 15: Enabling Map Visuals from Settings
Lecture 16: Deploying Filled Map Visual
Instructors
-
Adnan Ali
Manager Data Insights & Operations
Rating Distribution
- 1 stars: 0 votes
- 2 stars: 1 votes
- 3 stars: 1 votes
- 4 stars: 12 votes
- 5 stars: 29 votes
Frequently Asked Questions
How long do I have access to the course materials?
You can view and review the lecture materials indefinitely, like an on-demand channel.
Can I take my courses with me wherever I go?
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!
You may also like
- Top 10 Video Editing Courses to Learn in November 2024
- Top 10 Music Production Courses to Learn in November 2024
- Top 10 Animation Courses to Learn in November 2024
- Top 10 Digital Illustration Courses to Learn in November 2024
- Top 10 Renewable Energy Courses to Learn in November 2024
- Top 10 Sustainable Living Courses to Learn in November 2024
- Top 10 Ethical AI Courses to Learn in November 2024
- Top 10 Cybersecurity Fundamentals Courses to Learn in November 2024
- Top 10 Smart Home Technology Courses to Learn in November 2024
- Top 10 Holistic Health Courses to Learn in November 2024
- Top 10 Nutrition And Diet Planning Courses to Learn in November 2024
- Top 10 Yoga Instruction Courses to Learn in November 2024
- Top 10 Stress Management Courses to Learn in November 2024
- Top 10 Mindfulness Meditation Courses to Learn in November 2024
- Top 10 Life Coaching Courses to Learn in November 2024
- Top 10 Career Development Courses to Learn in November 2024
- Top 10 Relationship Building Courses to Learn in November 2024
- Top 10 Parenting Skills Courses to Learn in November 2024
- Top 10 Home Improvement Courses to Learn in November 2024
- Top 10 Gardening Courses to Learn in November 2024