Microsoft Power BI Desktop for Business Intelligence (2023)

سرفصل های دوره

Master Power BI Desktop for data analysis with hands-on assignments & projects from top-rated Power BI instructors

01 - Getting Started

001 READ ME Important Notes for New Students.html

002 Course Introduction

003 Course Structure & Outline

004 AdventureWorks-Images.zip

004 AdventureWorks-PBIX-Files.zip

004 AdventureWorks-Raw-Data.zip

004 DOWNLOAD Course Resources.html

004 Power-BI-for-Business-Intelligence.pdf

005 Introducing the Course Project

006 Setting Expectations

02 - Introducing Microsoft Power BI Desktop

001 Section Introduction

002 Meet Power BI Desktop

003 Downloading Power BI

004 IMPORTANT Adjusting Settings

005 Power BI Desktop Interface & Workflow

006 Resources & Monthly Updates

03 - Connecting & Shaping Data

001 Section Introduction

002 Power BI Front-End vs. Back-End

003 Types of Data Connectors

004 The Power Query Editor

005 Basic Table Transformations

006 ASSIGNMENT Table Transformations

007 SOLUTION Table Transformations

008 PRO TIP Storage & Connection Modes

009 Connecting to a Database

010 Extracting Data from the Web

011 Data QA & Profiling Tools

012 Text Tools

013 ASSIGNMENT Text-Specific Tools

014 SOLUTION Text-Specific Tools

015 Numerical Tools

016 ASSIGNMENT Numerical Tools

017 SOLUTION Numerical Tools

018 Date & Time Tools

019 Change Type with Locale

020 PRO TIP Rolling Calendars

021 ASSIGNMENT Calendar Tables

022 SOLUTION Calendar Tables

023 Index & Conditional Columns

024 Calculated Column Best Practices

025 Grouping & Aggregating

026 Pivoting & Unpivoting

027 Merging Queries

028 Appending Queries

029 PRO TIP Appending Files from a Folder

030 Data Source Settings

031 PRO TIP Data Source Parameters

032 Refreshing Queries

033 PRO TIP Importing Excel Models

034 Power Query Best Practices

04 - Creating a Data Model

001 Section Introduction

002 Data Modeling 101

003 Database Normalization

004 Fact & Dimension Tables

005 Primary & Foreign Keys

006 Relationships vs. Merged Tables

007 Creating Table Relationships

008 Managing & Editing Relationships

009 Star & Snowflake Schemas

010 ASSIGNMENT Table Relationships

011 SOLUTION Table Relationships

012 PRO TIP Active & Inactive Relationships

013 Relationship Cardinality

014 Connecting Multiple Fact Tables

015 Filter Context & Filter Flow

016 Bi-Directional Filters & Ambiguity

017 Hiding Fields from Report View

018 ASSIGNMENT Filter Flow

019 SOLUTION Filter Flow

020 PRO TIP Model Layouts

021 Data Formats & Categories

022 Creating Hierarchies

023 ASSIGNMENT Hierarchies

024 SOLUTION Hierarchies

025 Data Model Best Practices

05 - Calculated Fields with DAX

001 Section Introduction

002 Data Analysis Expressions 101

003 DAX vs. M Languages

004 Intro to DAX Calculated Columns

005 Intro to DAX Measures

006 Implicit vs. Explicit Measures

007 Quick Measures

008 RECAP Calculated Columns vs. Measures

009 PRO TIP Dedicated Measure Tables

010 Understanding Filter Context

011 Step-by-Step DAX Measure Calculation

012 DAX Syntax & Operators

013 Common DAX Function Categories

014 Basic Math & Stats Functions

015 Counting Functions

016 ASSIGNMENT Math & Stats Functions

017 SOLUTION Math & Stats Functions

018 Conditional & Logical Functions

019 The SWITCH Function

020 ASSIGNMENT Logical Functions

021 SOLUTION Logical Functions

022 Common Text Functions

023 ASSIGNMENT Text Functions

024 SOLUTION Text Functions

025 Basic Date & Time Functions

026 ASSIGNMENT Date & Time

027 SOLUTION Date & Time

028 Joining Data with RELATED

029 The CALCULATE Function

030 DAX Measure Totals

031 ASSIGNMENT CALCULATE

032 SOLUTION CALCULATE

033 The ALL Function

034 ASSIGNMENT CALCULATE & ALL

035 SOLUTION CALCULATE & ALL

036 The FILTER Function

037 Iterator (X) Functions

038 ASSIGNMENT Iterators

039 SOLUTION Iterators

040 Time Intelligence Patterns

041 ASSIGNMENT Time Intelligence

042 SOLUTION Time Intelligence

043 DAX Best Practices

06 - Visualizing Data with Reports

001 Section Introduction

002 The 3 Key Questions

003 Dashboard Design Framework

004 Sketching the Dashboard Layout

005 Adding Report Pages & Objects

006 Naming & Grouping Objects

007 Cards & Multi-Row Cards

008 ASSIGNMENT Cards

009 SOLUTION Cards

010 Building & Formatting Charts

011 Line Charts

012 PRO TIP Trend Lines & Forecasts

013 ASSIGNMENT Line Chart & Trend

014 SOLUTION Line Chart & Trend

015 KPI Cards

016 Bar & Donut Charts

017 Basic Filtering Options

018 ASSIGNMENT Donuts & Filters

019 SOLUTION Donuts & Filters

020 Table & Matrix Visuals

021 Conditional formatting

022 Top N Filtering

023 ASSIGNMENT Tables

024 SOLUTION Tables

025 Top N Text Cards

026 ASSIGNMENT Top N Text Cards

027 SOLUTION Top N Text Cards

028 Map Visuals

029 Report Slicers

030 ASSIGNMENT Slicers

031 SOLUTION Slicers

032 PRO TIP HASONEVALUE

033 Gauge Charts

034 PRO TIP Advanced Conditional Formatting

035 Area Charts

036 Drill Up & Drill Down

037 ASSIGNMENT Drill Up & Drill Down

038 SOLUTION Drill Up & Drill Down

039 Drillthrough Filters

040 Editing Report Interactions

041 ASSIGNMENT Report Interactions

042 SOLUTION Report Interactions

043 Adding Bookmarks

044 ASSIGNMENT Bookmarks

045 SOLUTION Bookmarks

046 PRO TIP Custom Navigation Buttons

047 PRO TIP Slicer Panels

048 Numeric Range Parameters

049 Fields Parameters

050 ASSIGNMENT Fields Parameters

051 SOLUTION Fields Parameters

052 PRO TIP Custom Tool Tips

053 Importing Custom Visuals

054 Managing & Viewing Roles

055 Mobile Layouts

056 PREVIEW Publishing to Power BI Service

057 Data Visualization Best Practices

07 - Artificial Intelligence (AI)

001 Section Introduction

002 Anomaly Detection

003 Smart Narratives

004 Q&A Visuals

005 Decomposition Trees

006 Key Influencers

08 - Power BI Optimization Tools

001 Section Introduction

002 The Optimize Ribbon

003 Pausing Visuals

004 Optimization Presets

005 Applying All Slicers

006 Performance Analyzer

007 External Tools

09 - BONUS PROJECT Maven Market

001 Introduction.html

001 Maven-Market-CSV-Files.zip

001 Maven-Market-Report-COMPLETE.zip

001 maven-market.zip

002 PART 1 Connecting & Shaping the Data.html

003 PART 2 Creating the Data Model.html

004 PART 3 Adding DAX Measures.html

005 PART 4 Building the Report.html

10 - BONUS LESSON

001 BONUS LESSON.html

179,000 تومان

افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: Udemy