Dominio de Microsoft Power BI: De Principiante a Intermedio

Resumen

Master data analysis in Power BI and learn how to create stunning dashboards with this beginner to intermediate course! What you'll learn:

How to create stunning, interactive dashboards with Power BIHow to share your analysis and dashboards using Power BI OnlineImporting Excel, Text, and CSV files into Power BI Desktop and combining filesAll about DAX including using the COUTROWS, CALCULATE, and SAMEPERIODLASTYEAR functionsHow to create amazing visuals, such as clustered column charts, maps, and trend graphsUsing slicers and filters and applying design elements to your reportsHow to edit the interactions between your visualizations and filter at visualization, page, and report levelHow to import and transform data in Power QueryHow to enable/disable load and report refresh and resolving data import errorsData Modelling, relationship types, and troubleshooting relationship issuesMeasures vs Calculated Columns and creating additional and conditional columnsHow to use ROUNDUP and SUMXCreating Quick Measures and a Key Measures TableUsing column, line, and map charts and gauge and card visualizationsCreating a Shared Workspace in Power BI ServiceCreating reports and dashboards, pinning visualizations to the dashboard, and setting up scheduled refreshes **This course bundle includes downloadable course instructor files to follow along.**We've combined our Microsoft Power BI Beginner and Intermediate courses in this great value bundle.

If you have reached your Excel limit and need to analyze and make sense of huge amounts of data, then Power BI can help take your existing data-crunching capabilities to new heights!Power BI is an incredibly powerful, self-service Business Intelligence (BI) solution from Microsoft. It is the perfect Business Intelligence tool for people with limited technical experience.The Power BI beginner course starts by looking at Power Query, and how to use this tool to organize and clean our data.

We then show you how to build a Data Model and relate separate tables. After that, we teach you all about the data analysis language DAX in Power BI.

Finally, we look at how to present this data using the charts and graphs available.This intermediate training course is designed to be a continuation of the introductory Power BI course. We start the intermediate course by discussing the data files to be used and some Power BI desktop settings that will set you up for success.

The latter part of the course is an intensive exercise to give you practice creating reports and dashboards.What's included?Power BI for Beginner:

What is Power BI and why you should be using it.To import CSV and Excel files into Power BI Desktop.How to use Merge Queries to fetch data from other queries.How to create relationships between the different tables of the data model.All about DAX including using the COUTROWS, CALCULATE, and SAMEPERIODLASTYEAR functions.All about using the card visual to create summary information.How to use other visuals such as clustered column charts, maps, and trend graphs.How to use Slicers to filter your reports.How to use themes to format your reports quickly and consistently.How to edit the interactions between your visualizations and filter at visualization, page, and report level.Power BI Intermediate:

Importing and transforming data in Power QueryImporting Excel, text, and CSV files and combining filesEnabling/disabling load and report refreshResolving data import errorsData modeling, relationship types, and troubleshooting relationship issuesMeasures vs. calculated columnsCreating a date table with DAXCreating additional and conditional columnsUsing the ROUNDUP and SUMX functionsCreating quick measures and key measures tablesThe DAX - CALCULATE functionTables vs. matrix tablesFormatting visualizations and applying conditional formattingUsing column, line, and map chartsGauge and card visualizationsUsing slicers and filters and applying design elementsCreating a shared workspace in Power BI serviceBuilding reports and dashboardsPinning visualizations to the dashboardSetting up scheduled refreshesThis course bundle includes:

10+ hours of video tutorials110+ individual video lecturesCourse and exercise files to help you follow alongCertificate of completionHere's what our students are saying...5 Stars "Brilliant course. I'm quite new to the world of POWER and this course has shown me what it can do in a way that a newbie can understand.

Recommended. I will be looking for other courses by them." -Andrew5 Stars "Very detailed course, really enjoyed the Power BI course.

Simon has done a really good job explaining each process step. Looking forward to completing additional Power BI courses for advanced techniques." -Martin5 Stars "I would highly recommend.

The course was informative and easy to follow." - Thomas5 Stars "I like everything! Everything is clear and understandable.

Perfect courses!" -Jovita

Programa

• Introducción a Power BI
Visión general de Power BI y sus componentes
Instalación y configuración de Power BI Desktop
Comprender la interfaz de Power BI
• Preparación de Datos
Conexión a fuentes de datos
Transformación y limpieza de datos usando Power Query
Comprender y gestionar consultas
• Modelado de Datos
Introducción a los conceptos de modelado de datos
Creación de relaciones entre tablas
Fundamentos de DAX: columnas calculadas y medidas
• Visualización de Datos
Diseño de informes efectivos
Uso de tipos de visualización básicos: tablas, matrices y gráficos
Personalización de visualizaciones y uso de opciones de formato
• Visualizaciones Avanzadas
Uso de segmentadores y filtros para interactividad
Introducción a las visualizaciones personalizadas
Incorporación de mapas y visualización de datos geoespaciales
• Informes y Tableros
Creación y personalización de informes de Power BI
Construcción y ensamblaje de tableros en el Servicio Power BI
Compartir y publicar informes y tableros
• DAX en Profundidad
Funciones intermedias de DAX y sus aplicaciones
Inteligencia de tiempo en DAX
Medidas calculadas avanzadas y creación de KPI
• Mejorando Informes con Power BI Service
Introducción al Servicio Power BI
Comprender y usar espacios de trabajo y conjuntos de datos
Colaboración y compartición de datos en Power BI
• Power BI Móvil y Funciones de IA
Configuración de informes de Power BI para vista móvil
Utilización de funciones de IA: Preguntas y Respuestas, influenciadores clave y conocimientos
• Mejores Prácticas y Optimización del Rendimiento
Optimización de modelos de datos e informes para el rendimiento
Seguridad de datos y gestión de acceso
Control de versiones y gestión del ciclo de vida de los informes
• Conclusión y Próximos Pasos
Recapitulación y repaso de conceptos clave
Recursos sugeridos para aprendizaje adicional

---

Impartido por

Simon Sez IT

---

Materias

Business