* Cantinho Satkeys

Refresh History
  • cunha45: Entendido
    16 de Julho de 2025, 20:33
  • j.s.: reafirmo 15/07/2026 o forum encerra
    16 de Julho de 2025, 18:26
  • j.s.: o que foi dito é que este ano está pago, e para bom entendedor foi dito que após desinteresse nos membros, ficam já avisados que a 15/07/2026
    16 de Julho de 2025, 18:25
  • j.s.: boa tarde
    16 de Julho de 2025, 18:22
  • cunha45: Com a colaboração de 6 membros, aos quais agradecemos e com custos muito elevados, por parte da administração, foi pago mais um ano , do domínio e nome do fórum, num servidor externo.  Como o fórum é dos dos seus membros, e como estes mostraram total desinteresse numa pequena ajuda para a sua manutenção informamos que  a partir de 15/07/2026 o fórum encerra as suas portas.  Para todos os membros que não nos quiseram ajudar, e que fazem neste fórum, os seus downloads do que aqui disponibilizamos, para seu proveito e de borla, iremos cancelar essa função, apenas podendo vizualizar o forum.  A administação
    16 de Julho de 2025, 13:43
  • cunha45: ainda nao encerrou
    16 de Julho de 2025, 13:42
  • FELISCUNHA: ghyt74  pessoal   49E09B4F
    16 de Julho de 2025, 11:46
  • m1957: Obrigado pelo cuidado em informar!
    16 de Julho de 2025, 00:45
  • cereal killa: boas gomes, 4tj97u<z
    14 de Julho de 2025, 21:32
  • j.s.: cereal enviei pm  4tj97u<z
    14 de Julho de 2025, 21:13
  • j.s.: Entre as 20h do dia 13 de agosto de 2025 e as 10h do dia 14 de agosto de 2025 (horário CEST).
    14 de Julho de 2025, 20:55
  • j.s.: foi refeita nova data para migração
    14 de Julho de 2025, 20:55
  • j.s.: 43e5r6
    14 de Julho de 2025, 16:49
  • j.s.: por isso o forum deve estar off line  Início: 16/07/2025 às 20:00 (CEST) Fim: 17/07/2025 às 10:00 (CEST)
    14 de Julho de 2025, 16:49
  • j.s.: vai ser efectuada migração de servidores
    14 de Julho de 2025, 16:48
  • j.s.: dgtgtr a todosc 49E09B4F
    14 de Julho de 2025, 16:47
  • cunha45: ja
    14 de Julho de 2025, 08:25
  • j.s.: passem por aqui p.f. [link]
    13 de Julho de 2025, 16:29
  • FELISCUNHA: Votos de um santo domingo para todo o auditório  4tj97u<z
    13 de Julho de 2025, 11:31
  • j.s.: tenham um excelente domingo 49E09B4F
    13 de Julho de 2025, 09:07

Autor Tópico: Master Excel PowerPivot - Data Analysis & DAX for Beginners  (Lida 131 vezes)

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

Offline mitsumi

  • Sub-Administrador
  • ****
  • Mensagens: 121842
  • Karma: +0/-0
Master Excel PowerPivot - Data Analysis & DAX for Beginners
« em: 13 de Agosto de 2020, 16:25 »

Master Excel PowerPivot - Data Analysis & DAX for Beginners
Video: .mp4 (1280x720, 30 fps(r)) | Audio: aac, 44100 Hz, 2ch | Size: 1.44 GB
Genre: eLearning Video | Duration: 29 lectures (2 hour, 43 mins) | Language: English
 Use the PowerPivot Data Model & DAX functions to speed up your data analysis. Learn KPIs, Measures & Custom Hierarchies.

What you'll learn

    This is a complete course on mastering PowerPivot
    You'll learn basic data structure techniques.
    You'll learn common data relationship definitions.
    You'll learn basic DAX patterns.
    You'll learn to construct PivotTables with PowerPivot.

Requirements

    You should have access to Excel 365 or Excel 2019
    There are no other requirements except for an interest in learning PowerPivot

Description

A brief glimpse of PowerPivot's usefulness and capabilities...

This course is designed for all Excel users - not just power users capable of building incredible Excel worksheets with functions, VBA, and mystical trickery. Even if you never write a single formula, this course will teach you to build basic relationships and create PivotTables from multiple mapped tables without a single formula.

The course will also introduce you to the DAX formula language. DAX is very similar to Excel formulas; however, you do not need to have experience with Excel formulas in order to use them. DAX and it's concept of context can allow you to replicate many complex Excel formulas with very simple DAX formulas.

You'll learn to write formulas that are deceivingly simple yet generate results that seem like magic tricks.

Dramatically increase the your data crunching capabilities with PowerPivot

Learn how to weave datasets together within Excel to create flexible and dynamic reports unlike any you've built before. Incorporate KPIs to give your PivotTable reports dynamic visual cues. Incorporate DAX formulas to create intelligent PivotTables that look-up, link, and allocate values for you.

This course is for anyone new to PowerPivot and applicable to any level of Excel user. You will learn DAX from the beginning stages and you don't need to be an expert in Excel to take this course.

Change your view of PivotTables

Ever spent hours building a table to load into a PivotTable through lookups, references, and connections?

How about creating additional columns of complex calculations using SUMIFS or AVERAGEIFS?

With some basic DAX, you don't need to understand these complex and challenging functions in order to create complex and powerful analytical computations. You can take advantage of the context-based computations within PowerPivot with the relationship definitions you'll learn about to generate tables of data faster than you can imagine.

Never look at a PivotTable the same way again with PowerPivot.

Make your data more accessible.

How many reports have you either interacted with or built that used strict tables that required a knowledgeable Excel analyst to either pull more data from or simplify the view?

Ever gone back because your boss needed you to break all of the report entries down from annual to quarterly or from sector to department?

PivotTables have that functionality built in with their rows and columns, but getting data into that format has been a hassle ... that is, until you learn how to use PowerPivot.

Define custom hierarchies for your qualitative data to make expanding and contracting data a one-click experience.

Put your co-workers, clients, and boss in awe when they ask for a drill-down and you can provide it on the spot. When they ask a question about the data, give them the workbook to drill into from any angle they want with no need to worry about cell formulas!

PowerPivot gives you time back to spend time analyzing the data instead of preparing the data.

Open yourself to new avenues of success

This course will help you become more capable with PowerPivot, but PowerPivot is only the tip of the iceberg.

Set yourself on the path to mastering basic self-service business intelligence tools and prepare yourself to extend beyond Excel with the concepts covered within. You'll be introduced to relational data structures, problem solving skills, and data concepts that will serve as a foundation for many different tools and problems.

Take next steps into PowerQuery to improve your ability to extract, transform, and load data from a SQL database or take your starting knowledge of DAX and relationships and jump into Power BI to begin building fluid and dynamic visuals that simply blow Excel away.

Join the course today and take the first step to becoming the master of your data.

Who this course is for:

    This course is for any level of Excel user that needs to be able to slice and dice data to derive useful information to assist                                                                                                                                                                                                       in making business decisions.
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