Description
Microsoft Excel: Business Intelligence w/ Power Query and 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 the tools that are thoroughly explored in this course and how they work is explained in detail. If you want to become an expert in Excel software and enhance your analytics skills in this software, check out 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. You then learn how to work with Excel’s Power Query tool using simulated data from a chain store. Power Query is a tool for extracting, transforming, and retrieving information from raw files and databases that makes modeling easier for you. You will then learn how to normalize and design your database and create your own relational database. The tutor will also teach you how to use Power Pivot and DAX to model and analyze data and introduce you to the most important DAX functions and commands.
Courses taught in this course:
- Introduction to Data Modeling Tools and Business Intelligence in 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 14 minutes
- Number of lessons: 87
- Level of education: Intermediate
- tutor: Maven Analytics , chris dutton
- File format: mp4
course title
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 not currently available for Mac)
- Experience with Excel PivotTables and formulas and functions is strongly recommended
Microsoft Excel: Business Intelligence w/Power Query & DAX Picture
Sample Film
installation Guide
After extract watch it with your favorite player.
English subtitle
Quality: 720p
Previous title:
Microsoft Excel – Introduction to Power Query, Power Pivot and DAX
Change:
The number of lessons and the duration of the lessons have decreased by 1 minute in version 2022/3 compared to 2018/12. Also, the titles and contents of the courses have been changed.
download link
File Password: free download software
size
1.82 GB