Learn Excel Power Query, Power Pivot, DAX & Power BI

Udemy Learn Excel Power Query, Power Pivot, DAX & Power BI

Register & Get access to index
Ri6Etdk.jpg

Learn Microsoft's popular and highly demanded business intelligence tools Power Query, Power Pivot, DAX & Power BI


What you'll learn
  • Connect, shape and transform data from a wide range of sources using Power Query
  • Create a data model based on the underlying data using using database methods in Power Pivot
  • Create columns and measures using the DAX formula language for advanced analysis and insight
  • Explore trends using Pivot Tables, charts, slicers, cube functions & dashboards in Excel
  • Design an interactive dashboard using Power BI
  • Learn Microsoft's most important Business Intelligence tools in 1 course

Requirements
  • A version of Excel compatible with Power Pivot (Microsoft 365, Standalone 2013/2016, Professional Plus 2013/2016, Professional/Home & Business 2019)
  • Intermediate Excel knowledge is assumed including Pivot Tables
  • A PC (Use of these tools not available on a Mac Computer)

Description
This course will go a step further than the standard Excel course and teach tools which are even more advanced and powerful for the serious analyst.
With this course you will learn all of Microsoft's most important business intelligence tools Power Query, Power Pivot, DAX & Power BI all in a single course. The 8 hours of video content, quizzes, and assignments have been carefully designed to help you progress to a data analyzing wizard in the most logical way possible. The course comes with lifetime access, downloadable materials and 30 day money back guarantee
Throughout the course we will use many data sets as examples and will even conclude by creating a Data Model and Dashboard based on the Microsoft 'Northwind' sales data set
You could be 8 hours away from becoming an Excel expert!
Contents
  1. Power Query
  2. Power Pivot
  3. DAX
  4. Power BI
Who this course is for:
  • Intermediate users of Excel looking to take their data analysis skills to the next level
  • Both students with no experience and those with some experience of these tools will benefit from the course
  • Anyone looking to to develop their career in the data analysis field
Author
TUTProfessor
Downloads
10
Views
256
First release
Last update
Rating
0.00 star(s) 0 ratings

More resources from TUTProfessor