Udemy – Microsoft Excel: Business Intelligence w/ Power Query & DAX 2024-11

Microsoft Excel: Business Intelligence w/ Power Query & 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: Business Intelligence w/ Power Query & DAX Profile:

• English language
• Duration: 7 hours and 19 minutes
• Number of lessons: 88
• Level of education: Intermediate
• Tutor: Maven Analytics , Chris Dutton
• File format: mp4

Course headings

Prerequisites for Microsoft Excel: Business Intelligence w/ Power Query & DAX course

• 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 NOT available for Mac)
• Experience with Excel PivotTables and formulas & functions is strongly recommended

Microsoft Excel: Business Intelligence w/ Power Query & DAX Picture

Sample movie

Installation guide

View with your favorite Player after Extract.

English subtitle

Quality: 720p

Previous title:

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

Changes:

Version 2022/3 compared to 2018/12 has decreased the number of 1 lesson and the duration of 2 minutes. Also, the titles and contents of the course have been changed.

The 2024/11 version has increased by 1 lesson and 5 minutes in duration compared to 2022/3.

Download link

Download Part 1 – 1 GB

Download Part 2 – 735 MB

Size

1.7 GB