Excel BI - Learn Power Pivot and DAX functions

Analyse your data with ease when you unleash the strength of DAX functions and learn how to use Excel's Power Pivot
3.9 (16 ratings) Instead of using a simple lifetime average, Udemy calculates a
course's star rating by considering a number of different factors
such as the number of ratings, the age of ratings, and the
likelihood of fraudulent ratings.
343 students enrolled
$19
$30
37% off
Take This Course
  • Lectures 34
  • Length 3 hours
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 5/2013 English

Course Description

Power Pivot is an Excel add-in, available in Excel 2010 and certain versions of Excel 2013. You can use Power Pivot, with its own DAX functions to perform powerful data analysis and create sophisticated data models. With Power Pivot, you can mash up large volumes of data from various sources, perform information analysis rapidly, and share insights easily.

LEARN HOW SET UP POWERPIVOT REPORTS AND CHARTS AND MASTER DAX FUNCTIONS USED TO PERFORM POWERFUL CALCULATIONS AND ANSLYSIS.

MICROSOFT'S EXCEL, WHICH INCLUDES POWER PIVOT, IS NOW PART OF A BI SYSTEM. IF YOU WANT TO IMPROVE YOUR EXCEL SKILLS FAR BEYOND THE BASIC LEVEL THEN THIS COURSE IS FOR YOU

CONTENTS AND OVERVIEW

In section one of this course we will start at the very basics and learn how to set up and import data to Power Pivot. In this section you will find sample data to download, so you can practice along.

Section two and three will cover the basic elements of Power Pivot such as tables, table relationships, calculated columns slicers and measures.

Once we are working well with these basic's we are going to power things up using DAX functions. DAX functions such as the Calculate function and filter and distinct will give you greater debt to your analysis.

Finally we will look in detail at the Time intelligence functions Power Pivot has to offer.

Who Should Attend?

This course is suited to those with an interest in Excel, Data Analyst's, Data Mining, BI, Reporting and Pivot tables and is well suited for Accountants, Auditors, Internal Auditors, Business Analysts, Finance staff, Banking staff, Management and those involved with Compliance and Risk assessment and BI.

• This course is meant for those involved in the Analysis of Data, Finance & Accounting and Reporting roles.

• This course is not a traditional functions and formulas based course but instead this course covers Excels Add in Power Pivot and is own function language DAX

• This course is suited to those with an interest in Excel, Fraud and Audit and is well suited for Accountants, Auditors, Internal Auditors, Business Analysts, Finance staff, Banking staff, Management and those involved with Compliance and Risk assessment and BI.

• This course is for you if you are looking to learn advanced Excels functions.

• This course is not for you if you are new to Excel.

What are the requirements?

  • Not all version of Excel include Power Pivot. You will need Excel 2010 or Excel 2013 Professional Plus edition.
  • You should already be familiar with Excel

What am I going to get from this course?

  • By the end of this course, you will be able to
  • Import data into Power Pivot from different sources
  • Set up and manipulate Pivot Tables and Pivot Charts with Power Pivot
  • Describe, set up and work with Tables, Table Relationships, Calculated Columns and Measures
  • Understand the complex DAX functions and use them in your data analysis
  • Understand and work with time intelligence functions

What is the target audience?

  • This Power Pivot course is designed for those with prior knowledge of Excel and pivot tables.
  • No DAX experience is require as we will cover this in detail
  • If you are looking for an advanced way of analysing your data in Excel then this course is for you

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Importing Data
01:45

Just a quick intro to Power Pivot and what we will cover in this course

00:59

In this section we will take a look at what will be covered in this section

01:17
How to install power pivot - where to download for excel 2010 and how to turn it on in Excel
04:16
Use the sample files given earlier to import data from Access or use your own data
01:53
Do you have a custom query, you can also use this to import data
02:35
Excel and power pivot are best friends, you can always import excel files to power pivot
01:45
Dont you hate when someone send you a text file, well not any more as you can use this in power pivot too
01:09
Once you have set up your power pivot workbook, you are going to need to save it somewhere. Watch this tutorial to find out more
01:11
So we have covered importing data, let wrap it up
13 pages

Download the notes to go along with this Section

4 questions

to review what you have covered in section 1

Section 2: The next steps
00:48

In this quick lesson you will be introduced to the topics for this section.

04:48
It is important to understand how to work with the tables that you import and in this tutorial we will have a look at what is available with the tables
08:07
Relationships between tables allows you feed columns from multiple tables to one pivot table - lets have a look now
06:24
Calculated Columns allows you add data to your table of data, lets look to see how this works
00:26

Lets make sure you understand everything from section 2

Section 3: Pivot tables and charts
Section 3 overview
01:03
10:06
Pivot tables are used to analyse the data.  We have some examples to show you in this tutorial
06:05
Pivot charts are also used to analyse data - lets look at this tutorial to see how
07:01
Slicers can be added to give greater complexity to your pivot tables and charts - we have some examples to shown you in this tutorial
Section 3 review
00:25
4 questions

To review what is covered in section 2

Section 4: Measures
02:45

This tutorial will expalin what a Measure is and the difference between calculated columns and measures

15:56
So what do our students think of measures, let go talk with the animation team
Section 3 review
00:46
4 questions
To revise what has been covered in section 3
Section 5: DAX
06:16
So power pivot produces pivot tables, big swing, but with DAX you can take this to a new dimension
06:15
Let look as some theory and examples of the x functions and countrows
11:55

      • Let look as some theory and examples of the Related and related table functions

02:19
Let look as some theory and examples of the Filter and Distinct functions
18:46
The calculate function is a very powerful function, but not simple to understand.  We have some detailed examples to show you and you may need to revisit this tutorial
Section 4 review
01:49
4 questions
To review what was shown in section 4
Section 6: Time Intelligence
17:08
The are a lot of time intelligence functions added to dax and it makes working so much easier, in this tutorial we will begin to look at what is available
07:56
Following on from the previous tutorial, we will now look at another batch of time intelligence functions
02:44
Wrapping up what we have covered in Time intelligence, the animation team are here to refresh what Paula has covered
4 questions
To review items covered in section 5
Closing lecture
00:45
Section 7: Thanks!
Bonus
Article

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Paula Guilfoyle, CPA Accountant, Online Educator & Life Long Learner

Paula is a Qualified CPA with over 15 years' experience in the fields of Accountancy, Business Management,Process improvement, Internal Audit, Group accountant, Operations management and Training. All across a broad range of industries and sectors. Paula has been Key Speaker at many Accounting Events where her talks on Excel are received very positively. Taken from her experiences in Accounting and business fields, Paula also has Udemy courses for those wishing to up skill, especially in the area of Spreadsheets, Bookkeeping and Accounting.

Now an E-learning Educator 5+ years, Paula also has a focus on E-learning and online teaching. Drawn from her online teaching experience,Paula has a number of courses available to online teachers to help bridge the skills gap for those that teach or wish to teach online.

Ready to start learning?
Take This Course