Power Bi Mastery: Expert Techniques For Dynamic Dashboards
Published 4/2024
MP4 | Video: h264, 1920x1080 | Audio: AAC, 44.1 KHz
Language: English
| Duration: 2h 7m
Power BI, Data Analytics
What you'll learn
Research methods for collecting and storing data in Power BI.
Learn different approaches to building efficient and visually appealing reports using Data Storytelling standards.
Explore advanced data analysis techniques such as AI, Outlier Detector, Linear, Percentile Line, and Clustering Technique.
Study various DAX expressions used in data analysis.
Requirements
Experience with Power BI is required
Description
The PL-300 course is designed to provide a comprehensive understanding of Microsoft Power BI and data analytics. Whether you are a finance professional, an accountant, a human resources specialist, a marketer, or a student seeking to enhance your knowledge and prepare for the workforce, this course offers a solid foundation in the concepts and practical applications of Power BI.Throughout the course, you will gain in-depth knowledge of Power BI, including its capabilities, features, and tools. You will learn how to efficiently collect, transform, and analyze data from various sources, enabling you to make data-driven decisions and derive valuable insights for your organization.The course covers a wide range of topics, including data visualization techniques, data modeling, creating interactive dashboards and reports, implementing advanced analytics, and leveraging Power BI's collaboration and sharing capabilities. Practical examples and real-world case studies will be provided to help you understand how to apply Power BI to solve business problems effectively.By the end of the PL-300 course, you will have acquired the skills necessary to become proficient in Power BI and data analytics. You will be able to build compelling visualizations, perform data exploration, create interactive reports, and share your insights with stakeholders. Whether you are a beginner or have some prior experience with Power BI, this course will empower you to leverage the full potential of Power BI for data analysis and decision-making.Join the PL-300 course today to embark on a learning journey that will equip you with the essential knowledge and practical skills to succeed in the field of Microsoft Power BI and data analytics.
Overview
Section 1: Introduction
Lecture 1 Introduction
Lecture 2 Lecturer Information
Section 2: Business Understanding
Lecture 3 Understand business requirements, what questions are on table
Lecture 4 Raw data overview
Lecture 5 Relationship table
Section 3: Data Transformation & Modelling
Lecture 6 Get data
Lecture 7 Use First Row as Header, New Dimension Table: Manager
Lecture 8 Delete Relationship, Change correct one
Section 4: Data Visualization
Lecture 9 More about Date Table
Lecture 10 Format date columh to Mmm - yy
Lecture 11 Create a table of measure: Revenue & First Measure
Lecture 12 Advanced Line Chart
Lecture 13 Fix X-axis label issue
Lecture 14 Dynamic Chart Title
Lecture 15 MoM Growth Rate (DAX)
Lecture 16 Variance Month (DAX)
Lecture 17 Subtitle
Lecture 18 Subtitle (Fix)
Lecture 19 Color Formatting
Lecture 20 Revenue Reporting Year (Missing)
Section 5: Advanced KPI Chart
Lecture 21 What is OTD?
Lecture 22 OTD Formula - Understand the logic
Lecture 23 OTD DAX Function (P1)
Lecture 24 OTD Report Month
Lecture 25 OTD Report Year
Section 6: Combo Bar Chart - RY vs LY vs Target
Lecture 26 Chart to compare RM vs LY vs Target
Lecture 27 Revenue RM Chart
Lecture 28 Revenue LY Chart
Lecture 29 Target Point with Error bars
Lecture 30 Formatting Charts: Layout, Background & Others
Lecture 31 Organize Chart for Grouping
Section 7: Combo Chart & Lollipop
Lecture 32 Introduction to Lollipop & Overlap bar Chart
Lecture 33 Top 3 Companies bring most Revenue (RM vs RY)
Lecture 34 Calculate Average Order By Month & Year using DAX
Lecture 35 Overlap bar Chart
Lecture 36 Lollipop Chart
Section 8: Get Value from TOPN Table
Lecture 37 How Get Value (from Text) looks like
Lecture 38 Groupby Table
Lecture 39 Get Value Text from TOP1 Using DAX
Lecture 40 Decorate/ Write down insight, info for Dashboard using Text Box
Students, university students, marketing employees, human resources department, finance and accounting
Free search engine download: Power BI Mastery Expert Techniques for Dynamic Dashboards
