Description
Microsoft Excel: Business Intelligence w/ Power Query & DAX; It is a training course from Udemy that introduces you to data modeling and business intelligence tools in Excel software. Power Query, Power Pivot and DAX are the tools that are fully explored in this course and how to work with them is explained in detail. If you are planning to become an expert in Excel software and increase your analysis skills in this software, watch this course.
At the beginning of the course, you will get to know the modeling and data analysis tools in Excel and their importance in the world Business Intelligence you learn In the following, you will learn to work with the Power Query tool in Excel using fake data from a chain store. Power Query is a tool for extracting, transforming, and loading data from raw files and databases, making modeling easy for you. You will then be introduced to normalization and database design and learn how to create your own relational database. Finally, the instructor of the course will teach you how to use Power Pivot and DAX to check and analyze the data model and introduce you to the most important functions and commands of DAX.
Items taught in this course:
- Familiarity with data modeling tools and business intelligence in Excel
- Learning how to use Power Query, Power Pivot and DAX
- Getting to know the most important tricks and techniques of Excel
- Building high-quality business intelligence solutions for data analysis
- Data modeling using Power Query
- Teaching the most important DAX functions and commands
- Data analysis using Power Pivot
Specifications of the Microsoft Excel: Business Intelligence w/ Power Query & DAX course:
- English language
- Duration: 7 hours and 14 minutes
- Number of courses: 87
- Education level: Intermediate
- teacher : Maven Analytics , Chris Dutton
- File format: mp4
Course headings
Course prerequisites
- 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
Pictures
Sample video
Installation guide
After extracting, watch with your favorite player.
English subtitle
Quality: 720p
Previous title:
Microsoft Excel – Intro to Power Query, Power Pivot & DAX
Changes:
The version of 2022/3 compared to 2018/12 has reduced the number of 1 lesson and the duration of 2 minutes. Also, the titles and contents of the course have been changed.
download link
Password file(s): www.downloadly.ir
Size
1.82 GB
Be the first to comment