* Cantinho Satkeys

Refresh History
  • FELISCUNHA: dgtgtr   49E09B4F  e bom fim de semana   4tj97u<z
    15 de Fevereiro de 2025, 16:34
  • j.s.: tenham um excelente fim de semana  49E09B4F
    14 de Fevereiro de 2025, 17:06
  • j.s.: dgtgtr a todos  4tj97u<z
    14 de Fevereiro de 2025, 17:06
  • FELISCUNHA: ghyt74  pessoal   49E09B4F
    14 de Fevereiro de 2025, 11:24
  • cereal killa: ghyt74 pessoal  classic
    14 de Fevereiro de 2025, 10:08
  • JPratas: try65hytr Pessoal  classic k7y8j0 h7ft6l
    14 de Fevereiro de 2025, 03:52
  • JPratas: dgtgtr A Todos  4tj97u<z k7y8j0 yu7gh8
    13 de Fevereiro de 2025, 18:08
  • FELISCUNHA: ghyt74  pessoal   49E09B4F
    13 de Fevereiro de 2025, 11:32
  • j.s.: try65hytr a todos  4tj97u<z
    12 de Fevereiro de 2025, 21:00
  • FELISCUNHA: ghyt74   49E09B4F  e bom fim de semana  4tj97u<z
    08 de Fevereiro de 2025, 11:36
  • j.s.: tenham um excelente fim de semana  43e5r6 49E09B4F
    07 de Fevereiro de 2025, 20:23
  • j.s.: try65hytr a todos  4tj97u<z
    07 de Fevereiro de 2025, 20:23
  • FELISCUNHA: ghyt74  pessoal   49E09B4F
    07 de Fevereiro de 2025, 11:24
  • JPratas: try65hytr A Todos  4tj97u<z classic k7y8j0
    07 de Fevereiro de 2025, 04:15
  • j.s.: dgtgtr a todos  49E09B4F
    06 de Fevereiro de 2025, 14:24
  • FELISCUNHA: ghyt74  pessoal   49E09B4F
    05 de Fevereiro de 2025, 11:33
  • JPratas: try65hytr Pessoal  4tj97u<z classic k7y8j0
    05 de Fevereiro de 2025, 02:35
  • FELISCUNHA: ghyt74   49E09B4F  e bom fim de semana   4tj97u<z
    01 de Fevereiro de 2025, 11:59
  • j.s.: tenham um excelente fim de semana  49E09B4F
    31 de Janeiro de 2025, 21:20
  • j.s.: try65hytr a todos  4tj97u<z
    31 de Janeiro de 2025, 21:20

Autor Tópico: Power BI Excel Integration  (Lida 216 vezes)

0 Membros e 1 Visitante estão a ver este tópico.

Offline mitsumi

  • Moderador Global
  • ***
  • Mensagens: 118061
  • Karma: +0/-0
Power BI Excel Integration
« em: 04 de Junho de 2020, 18:38 »

Power BI Excel Integration
MP4 | Video: h264, 1280x720 | Audio: AAC, 48 KHz, 2 Ch
Genre: eLearning | Language: English + .srt | Duration: 23 lectures (1 hour, 58 mins) | Size: 1.34 GB
Using Microsoft Power BI, Excel, Power Query and Power Pivot together | G Com Solutions

What you'll learn

In this course, you will learn all the different ways of using Power BI and Excel in conjunction

Requirements

This course requires Power BI Desktop (freely available) and Microsoft Excel

Description

Microsoft Power BI and Excel form a natural pairing and work well together. In this course by G Com Solutions, you will learn all the different ways of using Power BI and Excel in conjunction and the benefits of integrating these two powerful and versatile environments.

We start the course with a side-by-side comparison of Power BI and Excel BI, using Power Query in both environments to connect with data and carry out data transformations. Then comparing data modelling and DAX in Power BI to the data modelling experience in Excel Power Pivot. And we end our side-by-side comparison by looking at how to import an Excel Power Pivot data model into Power BI and build a report from it.

We then move onto discussing the different Excel-related operations which can be initiated from within the Power BI service. Here, we'll look at techniques such as importing Excel tables and uploading entire Excel workbooks into an app workspace. We also examine the different options for exporting data to Excel from Power BI visuals, as well as using the Analyze in Excel feature to build Excel reports based on Power BI datasets.

Next, we switch over to Excel for a look at Power BI workflows which can be initiated from within Excel. In this module, we will use the Power BI Publisher for Excel add-in to pin Excel content to Power BI dashboards. We'll also discuss how we can use Power BI's dashboard subscription feature as a method of distributing Excel content throughout an organisation.

In the final module, we examine the different techniques and considerations involved in importing Excel data into Power BI desktop. This includes techniques such as connecting to hidden sheets and filtering out the total row from Excel tables.

In summary, this course will provide you with all the practical insights you need to be aware of when using Power BI in conjunction with Microsoft Excel.

Who this course is for:

This course is designed for users familiar with both Excel and Power BI
Screenshots

Download link:
Só visivel para registados e com resposta ao tópico.

Only visible to registered and with a reply to the topic.

Links are Interchangeable - No Password - Single Extraction