Master Microsoft Power BI: Beginner to Intermediate Training

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

Master data analysis in Power BI and learn how to create stunning dashboards with this beginner to intermediate course!

1. Introduction to Power BI Beginner Course

1. Welcome and Overview

2. WATCH ME Essential Information for a Successful Training Experience

3.1 Power BI Course Demo Files_section 2-4.zip

3. DOWNLOAD ME Course Demo Files (Section 2-4).html

4.1 Power BI Course Demo Files_section 5-8.zip

4. DOWNLOAD ME Course Demo Files (Section 5-8).html

5.1 Power BI Exercise Files.zip

5. DOWNLOAD ME Course Exercise File.html

6.1 Power BI Course by Simon Sez IT .pdf

6. DOWNLOAD ME Course Transcript.html

7. What is Power BI

8. Install Power BI Desktop

9. A Tour of BI Desktop

10. Explore Commonly Used Power BI Options

11. Section Quiz.html

2. Beginner Getting and Transforming Data

1. Import Files from a Folder into Power BI Desktop

2. Get Data from Excel and Text Files

3. Reference Queries to Create Additional Lookup Tables

4. Merge Queries in Power Query

5. Prevent Queries from Loading into Power BI Desktop

6. Practise Exercise

7. Section Quiz.html

3. Beginner Data Modelling

1. Create Relationships Between Tables

2. Create a Dynamic List of Dates

3. Create Additional Date Columns for Analysis

4. Sort the Month and Weekday Names Correctly

5. Mark the Table as a Date Table

6. Hide Unnecessary Fields from Report View

7. Practise Exercise

8. Section Quiz.html

4. Beginner Introduction to DAX Measures

1. Calculate the Total Revenue

2. Count the Total Rows of a Table

3. Use the CALCULATE Function

4. Calculate the Total Revenue Last Year

5. Difference Compared to Last Year

6. Practise Exercise

7. Section Quiz.html

5. Beginner Adding Visualizations to your Report

1. Show Summary Information with Cards

2. Columns Charts to Compare Values

3. Map Visual to Plot Geographic Data

4. Slicers to Filter your Reports

5. KPI Card to Measure Performance Against a Goal

6. Line Graphs to Visualise Trend

7. Show Detail with the Matrix

8. Top N Lists with the Table Visualisation

9. Practise Exercise

10. Section Quiz.html

6. Beginner Report Design

1. Adding Text Boxes and Shapes

2. Use Themes

3. Conditional Formatting

4. Practise Exercise

5. Section Quiz.html

7. Beginner Editing Interactions and Filters

1. Edit the Interactions between your Visualisations

2. The Filter Pane to Filter at Any Level

3. Drill Through to More Detail

4. Practise Exercise

5. Section Quiz.html

8. Beginner Power BI Service

1. Publish Your Report to the Power BI Service

2. Different Ways to Share your Power BI Report

3. Practise Exercise

4. Section Quiz.html

9. Beginner Closing

1. Wrap Up

10. Introduction to Power BI Beyond the Basics Course

1. Course Introduction

2. WATCH ME Essential Information for a Successful Training Experience

3.1 Power BI Beyond the Basics Course Files.zip

3. DOWNLOAD ME Course Instructor File.html

4.1 Power BI Beyond the Basics transcription.pdf

4. DOWNLOAD ME Course Transcript.html

5. Setting Up for Success

6. Section Quiz.html

11. Intermediate Importing and Transforming Data in Power Query

1. Importing Excel Data Files from a Folder

2. Combining Files and Removing Columns

3. Splitting and Merging Columns

4. Applying Data Types

5. Importing Text and CSV Files

6. Relationships and Lookup Tables

7. Duplicate vs Reference

8. Creating a Lookup Table

9. Creating Index Columns

10. Merging Queries

11. EnableDisable Load and Report Refresh

12. Advanced Editor

13. Resolving Data Import Errors

14. Organizing Queries into Groups

15. Section Quiz.html

12. Intermediate Data Modeling

1. Troubleshooting Relationship Issues

2. Relationship Types

3. Cross Filter Direction

4. Section Quiz.html

13. Intermediate DAX - Essential Skills

1. Measures vs Calculated Columns

2. Creating a Date Table with DAX

3. Creating Additional Columns

4. Creating Conditional Columns

5. Marking Table as a Date Table

6. Using ROUNDUP to Extract Quarters

7. Creating Quick Measures

8. Creating a Key Measures Table

9. Aggregation Methods

10. Using SUMX

11. Section Quiz.html

14. Intermediate DAX - CALCULATE Function

1. The CALCULATE Function

2. Changing Context with FILTER

3. Using ALL with CALCULATE

4. Section Quiz.html

15. Intermediate Visualizations

1. Visualizations

2. Tables vs Matrix Tables

3. Formatting Visualizations - Part 1

4. Formatting Visualizations - Part 2

5. Conditional Formatting

6. Column and Line Charts

7. Card Visualizations

8. Map Charts

9. The Gauge Visualization

10. Slicers and Filter

11. Applying Design Elements

12. Section Quiz.html

16. Intermediate The Power BI Service

1. Creating a Shared Workspace in Power BI Service

2. Inviting Others to a Shared Workspace

3. Reports vs Dashboards

4. Pinning Visualizations to the Dashboard

5. Setting up Scheduled Refreshes

6. Section Quiz.html

17. Intermediate Orders Dashboard Example - Preparation

1. Orders Dashboard Example

2. Report Requirements

3. Importing Order Data

4. Section Quiz.html

18. Intermediate Orders Dashboard Example - Transformation

1. Transforming Order Data in Power Query

2. Creating Lookup Tables

3. Merging Queries

4. Creating a Dates Table

5. Creating DAX Measures

6. Section Quiz.html

19. Intermediate Orders Dashboard Example Report

1. Adding a Report Title

2. Report Navigation with Buttons and Bookmarks

3. Card Visualizations and Filtering

4. Line Chart Count of Male vs Female Customers

5. Stacked Column Chart Total Revenue by Region

6. Treemap Chart Count of Orders by YearMonth

7. Funnel Chart Age Distribution

8. Matrix Table Count of Customers by Type and Status

9. Adding Conditional Formatting

10. Section Quiz.html

20. Intermediate Orders Dashboard Example Dashboard

1. Publishing the Report to the Power BI Service

2. Pinning Media Tiles to Dashboard

3. Section Quiz.html

21. Intermediate Course Close

1. Course Close

189,000 تومان

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

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

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

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