Essential Power BI (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.

Acquire the necessary knowledge to be able to create reports and dashboards with Power BI. This instructional content will guide you, step by step, for using the tool Microsoft Power BI Desktop and its work environments. You will learn how to perform data modeling, visualization, and query tasks, as well as how to use the Power BI Service to create dashboards, share items, and perform administration tasks. Everything explained from a beginner level and without the need for prior knowledge.

01 - Introduction

01 - Learn how to create analytical reports with Power BI

02 - 1. Introduction to Microsoft Power BI

01 - What is Power BI

02 - Power BI components

03 - BI project lifecycle with Power BI

04 - Roles in a BI project with Power BI

05 - Install Power BI Desktop

06 - Power BI Desktop work environment

03 - 2. Introduction to working with Power Query

01 - Power Query work environment

02 - Queries, steps and transformations in Power Query

03 - Connect to delimited files such as CSV and TXT

04 - Connect Power BI to Excel

04 - 3. Import data from external sources

01 - Work with parameters to define file paths

02 - Import data from folders in Power BI

03 - Import data from multiple Excel files to Power BI

04 - Import content from Excel file to Power BI

05 - Import data from SQL Server database

06 - Import data from a web source into Power BI

07 - Specify data in disconnected queries in Power BI

08 - Reuse existing connections

09 - Configure data source properties

05 - 4. Transform queries in Power BI

01 - Define data types for columns in Power Query

02 - Define types from local settings in Power Query

03 - Clean data Filter by rows and columns in Power Query

04 - Combine columns in Power BI

05 - Split columns in Power BI

06 - Combine queries to define tables in Power Query

07 - Integrate data by appending queries in Power Query

08 - Reference queries in Power Query

09 - Duplicate queries

06 - 5. Advanced transformations in Power BI queries

01 - Group rows to create aggregates in Power Query

02 - Dynamize columns in Power Query

03 - Cancel dynamization in columns in Power Query

04 - Add conditional business logic in Power Query

05 - Enrich the model with columns in Power Query

06 - Load a query to the tabular model in Power Query

07 - Queries and parameters in folders in Power Query

07 - 6. Options and tasks related to data quality

01 - Identify colors in the columns quality panel

02 - Explore the columns distribution panel

03 - Activate and examine the data profiles panel

04 - Clean and crop in Power Query

05 - Remove duplicates in Power Query

08 - 7. Introduction to DAX expression language

01 - Introduction to the DAX language

02 - Language components. Syntax in DAX

03 - Create an aggregate measure from a column with DAX

04 - Add more than one column with DAX

05 - Add more than one column in different tables with DAX

06 - Differences between calculated and measured columns

07 - Examples of using functions in DAX

08 - Format of formulas, comments and good practices in DAX

09 - Advantages and details of working with variables in DAX

09 - 8. Enrich the tabular model with DAX expressions

01 - Introduction to contexts in DAX

02 - Use the CALCULATE function

03 - Make comparisons between categories with DAX

04 - Compare categories with quick measures in Power BI

05 - Tables and relationships of the tabular model

10 - 9. Work time BI with DAX expressions

01 - Times table with DAX

02 - Compare data over time with DAX

03 - Quick Measures and Times BI in Power BI

04 - Create cumulative aggregates in Power BI

05 - Set up initial table for tabular model measurements

11 - 10. Work with visualizations in Power BI

01 - Explore data by hierarchy level in graphs and arrays

02 - Model hierarchies in Power BI

03 - Categorize data into tabular model columns

04 - Default aggregate function on numeric columns

05 - Sort by another column for display

06 - Manage columns and tables visibility with Power BI

07 - Reports with integrated visual components in Power BI

08 - Graphs types available in Power BI

09 - Get external visual objects

10 - Filtering actions vs. highlighting between visualizations

12 - 11. Create advanced reports with Power BI

01 - Explore the Analytics panel in Power BI

02 - Increase or decrease results with analysis in Power BI

03 - Filter options available in reports with Power BI

04 - Filter with segmenters in reports in Power BI

05 - Sync segmenters in Power BI reports

06 - Create drillthrough filters on Power BI objects

07 - Customize pages with information about the tool

08 - Data as percentages in tables and arrays in Power BI

09 - Create conditional formatting for visualizations in Power BI

10 - Create bookmarks and stories

13 - 12. Work from the Power BI service

01 - Set up an account in the Power BI service

02 - Publish reports to the Power BI service

03 - Tour through the Power BI service

04 - Tour through my work area

05 - Work collaboratively from the Power BI service

06 - Create a new report from the Power BI service

07 - Create dashboards in Power BI

139,000 تومان

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

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

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

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