The Power Pivot, Power Query in Excel and Power BI Bundle
Genre: eLearning | MP4 | Video: h264, 1280x720 | Audio: aac, 44100 Hz
Language: English | VTT | Size: 3.08 GB | Duration: 17 section | 94 lectures | (7h 49m)
What you'll learn

Learn to unlock advanced Excel tools Power Query and Power Pivot as well as Power BI in this two-course bundle!
Analyze huge buckets of data to make informed business decisions
Become confident cleaning, sorting and linking data from various sources
Learn via expert instruction and exercises designed to have you performing complex analysis
How to create stunning, interactive dashboards with Power BI
How to share your analysis and dashboards using Power BI Online
To import CSV and Excel files into Power BI Desktop
All about DAX including using the COUTROWS, CALCULATE, and SAMEPERIODLASTYEAR functions
All about using the card visual to create summary information
How to create amazing visuals, such as clustered column charts, maps, and trend graphs
How to use Slicers to filter your reports
How to edit the interactions between your visualizations and filter at visualization, page, and report level

Requirements
You'll need a copy of Microsoft Excel that is compatible with the Power Pivot tool.
A good understanding of MS Excel. This is an advanced level course.
Power BI Desktop installed on your machine is required to take the practice exercises
A good knowledge of MS Excel is advised but not necessary
Description
**This course includes practice exercise files**

Learn Microsoft Power BI and Power Pivot, Power Query and DAX in Excel in this two-course bundle from Microsoft experts Simon Sez IT.

We've combined two of our best data analysis courses to create this huge-value bundle. If you have reached your limit in Excel and you need to analyze and make sense of huge amounts of data, then you need Power Pivot, Power Query and Power BI. These tools can help you take your existing data-crunching capabilities to new heights!

Power Pivot, Power Query and DAX

In this advanced Excel course, we look at three crucial advanced Excel features Power Pivot, Power Query, and DAX. This suite of Excel functions allows you to manipulate, analyze, and evaluate millions of rows of data from Excel or other databases.

We first look at how to bring your data together, merge, and clean it using Power Query before moving onto creating relationships between our data tables and building out a data model. We then look at performing calculations on our data model using DAX, and finally, we look at displaying our analysis using PivotTables and PivotCharts.