Download at MAXIMUM SPEED !!

Purchase a 30-days VIP membership and download using our fastest servers, up to 1Gb/s

Description

Microsoft Excel – Intro to Power Query, Power Pivot & DAX is a tutorial from Udemy that introduces you to data modeling and business intelligence tools in Excel software. Power Query, Power Pivot, and DAX are tools that are thoroughly explored in this course and how they work in detail. If you are looking to become an expert in Excel software and enhance your analytics skills in this software, watch this course.

At the beginning of the course, you will be introduced to Excel\’s data modeling and analysis tools and learn about their importance in the world of business intelligence . Then you learn how to work with Excel\’s Power Query tool using fake data from a chain store. Power Query is a tool to extract, convert, and retrieve information from raw files and databases that make modeling easy for you. You will then learn how to normalize and design your database and learn how to create your own relational database. The tutor will also teach you how to use Power Pivot and DAX to analyze and analyze the data model and introduce you to the most important DAX functions and commands.

Courses taught in this course:

  • Introduction to Data Modeling Tools and Business Intelligence at Excel
  • Learn how to use Power Query, Power Pivot and DAX
  • Learn about the most important Excel tricks and techniques
  • Build high 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 lessons: 88
  • Level of education: Intermediate
  • Tutor: Chris Dutton
  • File format: mp4

Course headings

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 course

  • IMPORTANT: You need an Excel version 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 not available with Excel for Mac)
  • Experience with Excel PivotTables and formulas & functions is strongly recommended

Microsoft Excel Images – Intro to Power Query, Power Pivot & DAX

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

Sample movie

Installation guide

View with your favorite Player after Extract.

English subtitle

Quality: 720p

download link

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

File password (s): www.downloadly.ir

Size

998 MB

Leave a Reply

Your email address will not be published. Required fields are marked *

Fill out this field
Fill out this field
Please enter a valid email address.
You need to agree with the terms to proceed

Menu