Microsoft Power BI Desktop : The Practical 2024 Bootcamp!

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

Learn Microsoft Power BI from scratch with hands-on exercises for Data Cleaning, Data Modelling and Data Visualization!

1 - Introduction

1 - Download the Course Datasets.html

1 - PowerBI-HawkEye-Dataset.zip

2 - Say Hello to Power BI Desktop

2 - Downloading Power BI Desktop

3 - What is ETL

4 - ETL Power BI

5 - The Power BI Lifecycle

6 - First Look at the Interface

3 - Connecting to and Preparing Data

7 - Introduction to Data Connectors

8 - Loading in a CSV file

9 - The Power Query Interface

10 - Renaming Fields and Data Types

11 - EDA Column Quality

12 - EDA Column Profile and Distribution

13 - Dropping Preserving Rows and Columns

14 - Split Columns

15 - Format Tool

16 - Merge Columns

17 - Transform vs Add Column

18 - Extract Tool

19 - Conditional Columns

20 - Duplicating Columns and Adding Indexes

21 - Date Tool

22 - Numerical Tools

23 - Statistics and Count Rows

24 - Append Queries

25 - Group By

26 - Data Source Settings

27 - Imp Connecting to a Folder

28 - Bringing it all together

29 - EnableDisable Load

4 - Data Modeling

30 - What is Normalization

31 - Primary Keys

32 - Foreign Keys

33 - Fact and Dimension Tables

34 - Star Schema

35 - Snowflake Schema

36 - Whats a Join

37 - Merge Queries

38 - Cardinality

39 - Configuring our Data Model

40 - Configuring our Data Model Contd

41 - A simple enhancement to our data model

5 - Visualizing Data Creating Dashboards

42 - Imp settings

43 - Creating a Matrix

44 - Creating a Bar Chart

45 - Creating Stacked Clustered Bar Charts

46 - Creating a Line Chart

47 - Creating Area Charts

48 - Trick Formatting

49 - Line and Stacked Column Chart

50 - Adding Cards

51 - Adding more Cards

52 - Pie Chart

53 - Donut Chart

54 - Conditional Formatting a Matrix

55 - Funnel Chart

56 - Treemap

57 - Gauge Chart

58 - KPIs

59 - Filtering

60 - Slicers

61 - Map Visuals

6 - Conclusion

62 - Bonus Lecture.html

139,000 تومان

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

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

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

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