Analyze your Business with Power BI

BI-PWBI16-301-ES

Create analytical solutions with Power BI from your data. Design your models, create DAX-based calculations and make the best reports.

}

Duration: 16 hours

Labs: Hands-on experience

”Muy bueno el docente. Superó mis expectativas. Su mayor fortaleza, considero, la habilidad para proveer ejemplos del mundo real.”

Objectives

 

The fundamental objective of this training is to provide students with the necessary knowledge for data integration and advanced analysis of information using Power BI. All this based on practical cases of diverse business areas, that the student can apply in his work position. Once the course is completed, the student will be able to:

  • Create solutions with Power BI and apply them in the company
  • Import data from various sources (Excel, Access, ERPs, web pages, online services, social networks, etc.)
  • Design, refine and optimize the data model
  • Create analytical calculations based on DAX
  • Exploit all this analytical information by creating reports and dashboards
  • Share them in the organization
  • Make decisions anytime, anywhere

 

 

WHERE and WHEN will this course running?

In this course you will learn…

Power BI is a new solution that improves business decision making. It is formed by a set of tools that allow to obtain data from many sources, integrate them and convert them into information so that it can be analyzed and shared through excellent visualization and collaboration tools. It allows you to focus on what really matters and avoid tedious and repetitive tasks.

Among the tools that make up this solution are:

  • Power BI Desktop, to integrate data, create analytical models and generate reports in a very simple and friendly way, from your PC
  • Power BI service, allowing you to publish and share these reports securely in your organization
  • Power BI Mobile, to facilitate analytical and decision-making capabilities from mobile devices, anytime, anywhere
  • Add-ins for Excel, if you prefer to manage certain information from your Excel

Who is this courser for?

Aimed at people from the financial, commercial and sales departments, warehouse, management control, administration; And ultimately any user familiar with Excel that has to make decisions based on information extracted from your company’s computer applications (ERP, CRM, HR, Management, Billing, etc.) and from abroad (web pages, social networks, Etc.), integrated in a common repository.

 

Pre Requirements: What do you need to know to complete the course?

Participants in this training should have knowledge in:

  • Excel
  • Notions of data analysis

 

All courses can be delivered privately and customized to meet the requirements of your company.

Temary

Module 1: Introduction
  • Business Intelligence & Analytics
  • Analysis of information
  • Power BI
  • Fundamental concepts of modeling
Module 2: Obtaining Data
  • The Query Editor (Query Editor)
  • Data Sources
  • Operations with Query
  • Other features
  • Practical cases
Module 3: Data Models
  • Introduction
  • Modeling Design
  • Treatment of Time
  • Practical cases
Module 4: DAX our ally
  • What is DAX and why do we need it?
  • Calculated Columns and Measurements • DAX Functions (Part I)
  • Inherited from Excel, aggregation, relationships between tables
  • Practical cases
  • Summary of different types of functions
  • Implementing calculations, measurements and KPIs.
  • Practical cases
Module 05: Creating Reports
  • Introduction
  • Power BI Reports
  • Visual elements
  • Reporting
  • Practical cases
Module 06: Sharing and Making Better Decisions
  • The need to share
  • Power BI Service
  • Work areas
  • Datasets
  • Reports (reports)
  • Panels (dashboards)
  • New Analytical Features
  • Practical cases

WHEN and WHERE is this course running?

This course can be scheduled in more than one region. Please check availability in your country.