Power BI Zero to Pro w/ Data Analysis Masterclass & ChatGPT

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

2 courses in 1: Starting from Zero, Master Power BI & Data Analysis in Power BI, leveraging tools like DAX, & ChatGPT

1. Introduction & Getting Started

1. Introducing Power BI - Download & Install

2.1 Business Data lecture file.xlsx

2. Download the course data file.html

3. Welcome to Power BI! Getting started

4. Formatting the Data

5. Adding the Calendar Table

6. Connecting the Tables - Data Modeling

7. Adding & Exploring our first Visual

8. Formatting the Visual

9. Quick yet Amazing Dashboard

2. Exploring Other Amazing Visuals & Features

1. Introduction to the section

2. Tables - Reorganize Data & Make it Insightful!

3. Slicers - Look at any specific parameters

4. Drill through - From Dashboard to underlying transaction in a second

5. Filters - Filter out clutter

6. Matrix - The Magical Way to Prepare Insightful Reports!

7. Bar & Column Chart - StackedClustered100% Stacked

8. LineAreaStacked Area100% Stacked Area Chart - Tracing Trends

9. Line & Column Chart - The Most Powerful Chart to Corelate things

10. Ribbon Chart - Visualizing the Change in Relative Position

11. Waterfall Chart - Identify the Drivers of Change!

12. Funnel Chart - The Way to Measure Conversion

13. Scatter Chart - Unveil Patters & Correlations

14. PieDonut Chart & Tree Map - Show Composition

15. Cards & Multirow Cards - Present the Absolute Value

16. Maps & Filled Maps - Show Values over Map

17. Other Charts and the plan

3. Calculations in Power BI with DAX

1. Introduction to DAX

2. Adding columns with DAX - Part 1

3. Adding Columns with DAX - Part 2

4. Adding columns with DAX - Part 3 - Conditional Columns

5. IF Statement IF OR IF OR IN

6. IF AND

7. Homework - IF OR AND.html

8. Homework answers - IF OR AND

9. Merging Columns - CONCATENATE

10. Data from Other Tables - RELATED

11. Basic Calculations in Calculated Columns

12. Adding Calendar Table with DAX

13. LookupValue

14.1 3. Section 3.zip

14. Section file.html

4. Calculations in Power BI - Measures

1. Introducing Measures

2. AVERAGE

3. SUMX - Row by row calculation first, then Sum

4. RELATED in Measures

5. Practice - SUMX & RELATED, and transforming the data in professional way

6. Section files.html

7. Getting ready for our next DAX Measures

8. CALCULATE - The Golden DAX function - Filter data like a pro!

9. Homework answers - CALCULATE

10. DIVIDE

11. Dividing in Matrix

12. MIN & MAX

13. ALL - Bypassing Filters

14. Section end file.html

Files.zip

5. Measures with DAX - Part 2 - Time Intelligence

1. Introduction to the section

2. YTD - Year to date totals

3. QTD - Quarter to date MTD - Month to date

4. TTD - Total to date

5. Rolling Sum & Moving Average

6. Rolling Sum & Moving Average - Excluding Initial Days

7. Homework.html

8. Homework Answers

9. Section file.html

Files.zip

6. Measures with DAX - Comparative Values

1. Previous Period Value

2. Making PP Dynamic - Calculating Dynamic Number of Months in the Period

3. Period on Period Growth

4. Previous Corresponding Period Value

5. PCP Growth

6. Visualizing these Values in a Stunning Chart

7. Section end file.html

Files.zip

7. Other Amazing DAX formulas & concepts that you MUST know

1. Homework Ready your Power BI file for the section.html

2. Introduction and setting up the file

3. SWITCH - The magical way to conditional calculations!

4. Homework SWITCH.html

5. Homework answers and SWITCH with OR

6. VAR in DAX

7. Challenge Homework.html

8. Homework answers

9. Incorporating Dynamic Holidays

139,000 تومان

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

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

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

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