Power BI for Beginners: Analysis of Data (Beta)

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

Please note that this is an experiment using AI-generated audio for this course, which was originally produced in Spanish. This is a pilot course and our plan is to retire it in July. The exercise files and in-course quizzes are available in the course's original language only. Please let us know what you think by leaving a review.

Learn how Microsoft Power BI Desktop can help you clean, transform, model and visualize data, streamlining your daily work. Get to know both its Power Query editor, for data preparation and cleaning tasks, and Power BI Desktop to carry out data modeling tasks, creation of analytical reports and visualization of these.

01 - Introduction

01 - Power BI clean, transform, model and visualize data

02 - 1. What is Microsoft Power BI Desktop

01 - Power BI definition

02 - What advantages does working with Power BI offer

03 - Work environment in Power BI

03 - 2. Work with data in Power BI

01 - Get external data from Power BI

02 - Get data from an Excel workbook

04 - 3. Transform data with Power BI have cleanliness and quality

01 - Importance of data quality and cleanliness

02 - Clean data by creating filters by rows

03 - Delete unnecessary data columns

04 - Fill in missing values by filling data rows

05 - Replace values to replace or delete content

06 - Clear spaces in a Power Query text

05 - 4. Add columns from Power Query

01 - Add necessary columns for an analytical report

02 - Create column from example with Power Query

03 - Add new column that returns conditional result

06 - 5. Prepare the data model for the Power BI report

01 - Cancel dynamization of columns (unpivot)

02 - Split columns to better structure your content

03 - Combine columns of data and prepare them for analysis

04 - Adjust the data type to the content of the column

07 - 6. Set column properties in Power BI

01 - Format a data model column

02 - Create a simple calculation with DAX in Power BI

03 - Show Values as Percentages in tables and arrays

04 - Create conditional formatting of colors in Power BI

08 - 7. Create graphs for analytical reports in Power BI

01 - Work with an array or crosstab in Power BI

02 - Analyze by levels from bar or column graphs

03 - Create analysis of changes over time with line graphs

04 - Add a trend line to a lines graph

05 - Add average line to bar or columns graph

54,900 تومان

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

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

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

تولید کننده: LinkedIn Learning (Lynda)