Power Bi Mastery: Expert Techniques For Dynamic Dashboards

Power Bi Mastery: Expert Techniques For Dynamic Dashboards
Published 4/2024
MP4 | Video: h264, 1920x1080 | Audio: AAC, 44.1 KHz
Language: English

| Size: 894.44 MB[/center]
| 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