Capacitación en línea en aula virtual, e-learning
y otras formas de entrega para tu teletrabajo

Encuentra más información

Power BI Desktop Training (PBID)

 

Resumen del Curso

With the Power BI Online Portal, Microsoft offers an almost unlimited number of analysis tools for evaluating complex data models. Any type of data source can be integrated and used in the portal. No matter whether they come from the company's own ERP systems or are even provided from Google Analytics data. With the Power BI Desktop client software, Microsoft extends the possibilities even further and facilitates access to complex data models.

Quién debería asistir

Advanced users in the area of ​​Excel, Access data analysis

Prerrequisitos

Basic knowledge of Windows and good Excel or Access skills are required

Contenido del curso

Power BI data sources • Retrieve from external data sources • Reading in CSV / text files • Read Excel workbooks • Establish database connections • Connect to SQL Server • Access to multiple sources in parallel Query editor • Merge multiple queries • Select and name fields of a query • Create user-defined fields • Remove unnecessary columns from the query • Show / hide tables in field lists • Disable loading of tables • Add additional sorts • Enter your own data as a new table • Merging the tables • Set up the sorting according to an additional table • Apply sort by feature to existing fields • Duplicate existing tables • Remove empty records • Grouping of records • Create calculated columns Structure of a data model Link data sources • Add multiple tables as a data source at the same time • Automatic relationships from Power BI Desktop • Create and change relationships between tables Introduction of measures • Introduction to DAX (Data Analysis Expressions) programming • Editing of interactions via format ribbon • Add custom columns for formatting / calculation • Configuration of combined diagrams Introduction to calculated tables • DAX programming for your own tables • Linking calculated tables • Relationship types between calculated tables • Filter problems in data models Complex query methods • Combination of calculated tables, columns and measures • DAX code for expanding queries Individual visualizations • Choice of standard visualizations • Creation of own visualization types • Specific use cases for custom diagrams • Highly compressed dashboard views DAX in data models • Examples of DAX programming in data models

Classroom training

Duración 2 días

 
Calendario

Por el momento no hay fechas programadas para este curso  Solicitud de fecha de entrenamiento