---
title: Microsoft Power BI
description: "¡ Cursos Power BI ! - ¿ Estás planeando capacitación grupal o personal para el 2018 ? 
Capacitación en Power Query, Relaciones, M vs DAX y Visualizaciones.
Análisis de Datos - Conexión a Base de Datos - Reportes - Dashboards."
---

## Inteligencia empresarial sin precedentes

## ¿Qué es Power BI?

---

**

## De los datos al conocimiento en minutos. Cualquier dato, de cualquier forma y en cualquier lugar. Una sola vista.

Microsoft Power BI.

[![Registrarse en el Curso](https://no-cache.hubspot.com/cta/default/2107302/0bc41486-b8b7-4b2d-8672-660f6ae84c47.png)](https://cta-redirect.hubspot.com/cta/redirect/2107302/0bc41486-b8b7-4b2d-8672-660f6ae84c47)

## Temario

---

**

### [** Introduction to Power BI Desktop](https://www.itechc.net/microsoft-power-bi#collapse1)

- An Overview of the Workflow in Power BI Desktop
- Introducing the Different Views of the Data Model
- Taking a Closer Look at the Query Editor Interface
- Before we Dive Deeper: Recommended Settings

**

### [** Query Editor](https://www.itechc.net/microsoft-power-bi#collapse2)

- Just to be sure: What is the Query Editor?
- Before we Start - About the Attached Project Files
- Connecting Power BI Desktop to our Data Sources
- Editing Rows
- Understanding Append Queries
- Editing Columns
- Replacing Values
- Formatting Data
- Pivoting and Unpivoting Columns
- Splitting Columns
- Creating a New Group for our Queries
- What we Achieved until Now and How to Continue
- Introducing the Star Schema
- Duplicating and Referencing Queries
- Creating the DIM Region Table
- Entering Data Manually
- Merging Queries
- Finishing the DIM Region Table
- Introducing the DIM AgeGroup Table
- Creating an Index Column
- Duplicating Columns and Extracting Information
- Creating Conditional Columns
- Creating the FACT Population Table
- Performing Basic Mathematical Operations
- Improving Performance and Loading Data into the Data Model
- Module Summary

**

### [** Data & Relationship View](https://www.itechc.net/microsoft-power-bi#collapse3)

- Module Introduction
- Query Editor vs. Data Model
- Introducing and Understanding Relationships
- Editing Relationships
- Understanding Cardinality
- Cross Filter Selection and Many-To-Many Relationships
- Active Properties
- Understanding the differences between the M-Language and DAX
- M vs. DAX applied: Calculated Columns
- M vs. DAX: Conclusion
- DAX - Basic information
- DAX and Calculated Columns
- Calculated Columns vs. Measures
- Introducing DAX-Measures
- DAX-Measures Continued
- Categorizing Data
- Module Summary

**

### [** Working with the Report View](https://www.itechc.net/microsoft-power-bi#collapse4)

- Module Introduction
- Understanding the Interface of the Report View
- Creating our First Visualizations
- Editing Interactions and Adding Tooltips
- Adding Color Saturation
- Understanding Hierarchies and Adding Drill-Down
- Formatting Charts and Sorting
- About the Slicer
- Introducing Slicers
- Adding Treemaps and Tables
- Applying different Filter Types
- Creating (Multi-Row) Cards
- Understanding Combined Visualizations and Waterfalls
- Module Summary
- One Last Thing: Additional Features

**

### [** Power BI Service & Mobile](https://www.itechc.net/microsoft-power-bi#collapse5)

- Module Introduction
- Continuing our Work and why we need Power BI Service
- Comparing Power BI Free, Pro and Premium
- Logging in to Power BI Service
- Understanding the Interface
- Importing our Data from Power BI Desktop to Power BI Service
- Understanding the Dataset Menu
- Working on Reports
- Introducing Dashboards
- Exploring our Workspace
- Understanding Gateways
- Comparing Personal and On-Premise Gateway and Installing a Gateway
- Working alone or Collaborating with Colleagues
- Collaborating in App Workspaces
- Sharing the Results
- Publishing the App
- Content Packs from Online Services
- Power BI Mobile: Installing and Understanding the Mobile App
- One Last Thing: Excluding Datasets from Sharing
- Module Summary

**

### [** Other Data Sources](https://www.itechc.net/microsoft-power-bi#collapse6)

- Module Introduction
- Importing JSON Data
- Importing Data from REST APIs
- Preparation: Setting up a MySQL Server
- Importing Data from a MySQL Server (and other SQL Servers)
- Wrap Up

**

### [** Power BI for Developers](https://www.itechc.net/microsoft-power-bi#collapse7)

- Developer Prerequisites
- Module Introduction
- How do Custom Visuals Work?
- Using Data Driven Documents (D3)
- Creating and Using a Visual
- Installing an IDE (Code Editor)
- Understanding the visuals.ts File
- Understanding the Project Structure
- Installing d3.js (Data Driven Documents)
- Adding a First Shape
- Connecting Shapes to Data
- Scaling Shapes
- Managing Visual Capabilities to Allow Data Input
- Starting the Data Extraction
- Limiting the Data Input
- Extracting Data
- Displaying the User Data
- Optimizing the Code
- Adding Dynamic Coloring
- Making Bars Selectable (Cross-Visual)
- Adding X-Axis Labels
- Adding Custom Visuals Settings
- Extracting the Visual Configuration
- Informing Power BI About the Custom Configuration
- Next Steps
- Packaging the Custom Visual
- Wrap Up
- Further Resources

## Contáctanos Hoy!

---

## ¿ No encuentras la Academia o el Curso adecuado ?

Contamos con cursos de capacitación en las últimas innovaciones que SAP ofrece en todas las industrias a nivel global..