Power Bi From Basics To Advanced Analytics With Dax

Free Download Power Bi From Basics To Advanced Analytics With Dax
Published 1/2024
MP4 | Video: h264, 1920x1080 | Audio: AAC, 44.1 KHz
Language: English | Size: 6.69 GB | Duration: 11h 9m
Master the Art of Data Visualization and Business Intelligence

What you'll learn
Introduction to Power BI
Data Import and Transformation with Power Query
Data Modeling
DAX (Data Analytics Expression)
Data Visualization with Reports and Dashboard
Advanced Analytics with DAX
Requirements
No Programming experience needed. You will learn everything you need to know
Description
Are you ready to take your Microsoft Power BI skills to the next level? Do you want to become proficient in BI Development reporting and harness the power of Power BI for Reporting and Dashboard Design? This course is designed to make you an expert in advanced Power BI techniques, Data Transformation, Reporting, Dashboard Designing, Data Modeling, Power Query and Dax (Data Analysis Expressions)**Advanced Power BI Skills:** This course will empower you with Power BI skills, including data analysis, complex data analytics expression (Dax), Power Pivot, Power Query and data visualization. You'll learn how to tackle complex tasks with ease. - **BI Reporting Excellence:** We'll delve into the world of BI reporting, teaching you how to create, manage, and present data effectively for informed decision-making. You'll gain the knowledge and practical skills needed for efficient data reporting and analysis. Certainly! "Power of Power BI" is a concise and intriguing title that suggests the potency and impact of using Microsoft Power BI for business intelligence and data analysis. If you'd like to add a subtitle to provide more context or details, here are a few options:"Unleashing Business Intelligence with the Power of Power BI""Harnessing Data Insights: The Power of Power BI in Action""Transforming Raw Data into Strategic Wisdom with the Power of Power BI""Data Empowerment: Mastering the Power of Power BI for Dynamic Analysis""Visualizing Success: The Power of Power BI in Modern Analytics""Empowering Decision-Making: A Guide to the Strategic Use of Power BI""Driving Business Excellence: The Unmatched Power of Power BI""From Data to Dashboards: Unveiling the Power Behind Power BI""Elevate Your Insights: Exploring the Untapped Power of Power BI""Maximizing Business Impact: Uncovering the Potential of Power BI"
Overview
Section 1: Basic Concept of Power BI
Lecture 1 Introduction of Power BI
Lecture 2 ETL (Extract Transformation and Load)
Lecture 3 Dimension Table and Fact Table
Lecture 4 Star Schema vs Snowflake Schema
Section 2: Power Query
Lecture 5 Data Extraction Using Import and Direct Query Mode
Lecture 6 Manage Parameters
Lecture 7 Dynamic Calendar Table Using Parameters
Lecture 8 Join and Append
Lecture 9 Index Number and Group by
Lecture 10 Manage (Delete, Duplicate and Reference) Option
Lecture 11 Conditional Column
Lecture 12 Custom Column
Lecture 13 Choose Columns and Remove Columns
Section 3: Filters in Power BI
Lecture 14 Visual Level, Page Level, Report Level and Drill Through Filters
Section 4: Slicers in Power BI
Lecture 15 Basic of Slicer
Lecture 16 Sync Slicer
Lecture 17 Edit Interactions
Section 5: Tooltips in Power BI
Lecture 18 Basic of Tooltip
Lecture 19 Report Tooltip
Section 6: Selection Pane and Bookmark in Power BI
Lecture 20 Selection Pane
Lecture 21 Create a Report with Use of Bookmark
Section 7: Reference Line
Lecture 22 Reference Line for Minimum, Average and Maximum Value
Section 8: Conditional Formatting
Lecture 23 Conditional Formatting
Section 9: Data Modeling
Lecture 24 One to One Relationship
Lecture 25 Modeling in Power BI
Section 10: DAX (Data Analysis Expression) Calculated Table
Lecture 26 DAX (UNION, INTERSECT, EXCEPT)
Lecture 27 DAX (ALL, ALLSELECTED, ALLEXCEPT)
Lecture 28 DAX (CALCULATETABLE, FILTER)
Section 11: DAX (Data Analysis Expression) for Calculated Column
Lecture 29 Calculate Tax with IF
Lecture 30 Calculate Incentive with Switch
Section 12: DAX (Data Analysis Expression) for Measure Calculation
Lecture 31 Basic Dax
Lecture 32 Filter Dax to Create a Table
Lecture 33 Sumx vs Calculate with Live Report Design
Lecture 34 Countx vs Calculate with Live Report Design
Lecture 35 Averagex vs Calculate with Live Report Design
Lecture 36 Minx vs Calculate with Live Report Design
Lecture 37 Maxx vs Calculate with Live Report Design
Lecture 38 Rankx to Calculate Rank with Dynamic Report
Lecture 39 DAX for Date Dimension Table
Lecture 40 Design Report to Compare Current Day Vs Previous Day Sales
Lecture 41 Design Report to Compare Current Month Vs Previous Month Sales
Lecture 42 Design Report to Compare Current Quarter Vs Previous Quarter Sales
Lecture 43 Design Report to Compare Current Year Vs Previous Year Sales
Lecture 44 Current Year MTD Vs Last Year MTD
Lecture 45 Current Year QTD Vs Last Year QTD
Lecture 46 Current Year YTD Vs Last Year YTD
Section 13: Charts for Visualization
Lecture 47 Card Vs Multi Row Card
Lecture 48 Table Vs Matrix
Lecture 49 Stacked Bar Vs Stacked Column Chart
Lecture 50 Clustered Bar Vs Clustered Column Chart
Lecture 51 100% Stacked Bar Vs 100% Stacked Column Chart
Lecture 52 Line Chart Vs Area Chart
Lecture 53 KPI Visual
Lecture 54 Pie Chart Vs Donut Chart
Lecture 55 Map Vs Filled Map
Lecture 56 Gauge Vs Funnel Chart
Section 14: Row Level Security (RLS)
Lecture 57 Restrict Report Access
This course is for them who want to migrate their career in Analytics and BI Development

Homepage

https://www.udemy.com/course/power-bi-from-basics-to-advanced-analytics-with-dax/

No Password - Links are Interchangeable

Вернуться назад

Навигация

Рекомендуем

Статистика

Power Bi From Basics To Advanced Analytics With Dax

Коментарии

Рекомендуем

Популярное