Udemy – Microsoft Excel – Intro to Power Query, Power Pivot & DAX 2018-12

Description

Microsoft Excel - Intro to Power Query, Power Pivot & DAX is a training course from Udemy site that introduces you to data modeling tools and business intelligence in Excel software. Power Query, Power Pivot and DAX are tools that will be fully explored in this course and how to work with them will be explained in detail. If you want to become an expert in Excel software and improve your analysis skills in this software, watch this course.

At the beginning of the course, you will become familiar with modeling and data analysis tools in Excel and learn their importance in the world of business intelligence. Next you will learn how to work with the Power Query tool in Excel using fake data from a chain store. Power Query is a tool for extracting, converting, and loading information from raw files and databases that makes modeling easy for you. You will then become familiar with database normalization and design and learn how to create your own relational database. Finally, the instructor will teach you how to use Power Pivot and DAX to review and analyze the data model, and will introduce you to the most important DAX functions and commands.

Items that are taught in this course

Familiarity with data modeling tools and business intelligence in Excel

Learn how to use Power Query, Power Pivot and DAX

Familiarity with the most important tricks and techniques of Excel

Build quality business intelligence solutions for data analysis

Modeling data using Power Query

Learn the most important DAX functions and commands

Data analysis using Power Pivot

Microsoft Excel course specifications - Intro to Power Query, Power Pivot & DAX

English language

Duration: 7 hours and 16 minutes

Number of courses: 88

Level of education: Intermediate

Instructor: Chris Dutton

File format: mp4

Topics

88 lectures 07:16:18

Getting Started 6 lectures 10:01

Intro to Power Excel” 4 lectures 13:13

Power Query 19 lectures 01:43:21

Data Modeling 101 16 lectures 59:45

Power Pivot & DAX 101 14 lectures 01:04:56

Common DAX Functions 24 lectures 02:50:53

Wrapping Up 5 lectures 14:40

Prerequisites for Microsoft Excel - Intro to Power Query

IMPORTANT: You need a version of Excel that is compatible with Power Pivot (Excel 2013/2016/2019 Standalone, Office 365, Enterprise E3/E5, Office Professional 2016, etc.)

This course is designed for PC users (Power Pivot is currently unavailable with Excel for Mac)

Experience with Excel PivotTables and formulas & functions is strongly recommended

Installation

After Extract, watch with your favorite Player.

English subtitle

Quality: 720p