Excel Power Pivot & Excel Power BI Masterclass

Learn Excel Power Pivot - Power Map and Excel Power BI Tools. Build Excel Data Analyst Models with Microsoft Excel 2013
4.4 (84 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.
1,948 students enrolled
$19
$95
80% off
Take This Course
  • Lectures 45
  • Length 2 hours
  • Skill Level Intermediate Level
  • 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 3/2015 English

Course Description

*** Completely up-to-date for November 2016 ***

Learn PowerPivot and Power Business Intelligence Tools that are rarely found on Excel users and transform to an Excel Star!

These days almost any job requires data analysis & presentation of results. While anyone can put a list of values in Excel & sum them up, not everyone can do advanced analysis, create interactive charts, summarize data intelligently using PowerPivot and PowerBI tools, and finally present output in stunning Dashboards.

Content and Overview

This course is a guide with simple step by step instructions to walk you through creating business intelligence reports and dashboards in Excel, quickly and efficiently. The course has been created with the version of Microsoft Excel 2013

Excel Dashboards are powerful if you want to present and report data. However building a Dashboard is a complex process. In this course I'll walk you through the most effective ways and tools to build Excel Dashboards that will wow management both visually and substantively. We'll use Microsoft Excel free Power Pivot, Power View tools and DAX Formula Language to analyze huge amounts of business data fast and transform data into bottom-line results – no programming required!

Note: Power View is a new interactive tool available only in Excel 2013 (PowerPivot is available in both versions - Excel 2010 and Excel 2013)

You'll have lifetime access to watch the videos whenever you like. If you're not 100% satisfied there is a 30 day money back guarantee!

Plus you will get fast and responsive support within 24 hours.

Free downloadable Excel working files are included to allow you to follow along using the same material I use throughout the lectures. You can download all of them.

What are you waiting for? Enroll now and make your Excel Dashboards look amazing!


What you'll learn:

  • Dashboard design principles, tips and tricks
  • Understand and install the Excel Power Pivot and Power View add-ins
  • Import data from spreadsheets, Access, SQL, text files and other sources
  • Add calculated fields and columns with Data Analysis Expressions (DAX) formula language
  • Create complex reporting systems
  • Design your Excel Dashboard with link buttons
  • What are KPI's and add key metrics
  • Create mind blowing Excel Pivot Charts from PowerPivot
  • Create powerful reports using Slicers and Timeline
  • Make an amazing interactive sales map using Excel 2013 Power View powerful add-in
  • Summarize data with Matrices, Cards and Tiles
  • Perform simple-to-sophisticated calculations like Month to date and Year to date
  • Analyze multiple tables together without the need to ever write VLOOKUP formulas again

Enroll now and master the creation of interactive Excel Dashboards!

100% risk free – 30 day money back guarantee! - Lifetime access


Who is this course for?

This course assumes that you have a basic knowledge of Excel 2010 or Excel 2013. You don't need to be a master of Excel. Only basic prior experience in Excel or Spreadsheets is required to get the most out of this Excel course.

This course is also ideal for data analysts, MIS professionals, business analysts, managers, dashboard makers, business intelligence professionals and students.

At the end of this Excel class you will be given a Certificate of Completion.


STUDENT REVIEWS:

"I highly recommend this course. It was exactly what I needed to jump start my career. I learned far more than I expected. The instructor is excellent !!!!!!!!" - Troy Newman

===================================================================

"A thorough tutorial on using charts, pivot tables, etc to create dashboard reporting. Very well presented and explain complex issues in a simple way. It is clear and easy to understand and has helped me develop reporting dashboards. Excellent!" - Albert Loomer

===================================================================

"Knowing how to create charts and how to create charts USEFULLY are different skills. Andreas helps the viewer use Excel skills to produce truly useful dashboards. Highly recommend for those looking to learn data presentation." - David Anderson

===================================================================

Enrol now and enjoy!

What are the requirements?

  • To have Excel 2010 or later version installed, so you can open the workbooks and practice what you learn
  • PowerView is a new interactive tool, available only in Excel 2013
  • PowerPivot is not available in Office Standard 2013
  • Willingness for learning

What am I going to get from this course?

  • Create business intelligence reports and dashboards
  • Quickly turn mass quantities of data into meaningful information using Excel PowerPivot add-in
  • Make amazing interactive sales maps using Excel 2013 Power View powerful add-in
  • Analyze huge amounts of data fast and accurate
  • Learn in depth PowerPivot and Power View tools
  • Improve general Excel knowledge
  • Follow along with included Excel project files
  • Learn the most current version of Microsoft Excel
  • Course updated regularly
  • Learn from an instructor with over 16 years of experience, teaching thousands of students in his own computer learning school
  • An instructor ready to answer your questions in less than 24 hours
  • Watch high-quality video lectures with lifetime access
  • Certificate of completion

What is the target audience?

  • Everyone who wants to master Excel Dashboards
  • Business analysts
  • Data analysts
  • Students
  • Entrepreneurs

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: WELCOME! (& DOWNLOAD THE FILES PLEASE!)
Introduction
Preview
01:55
01:53

I answer to the following questions:

  • What does this course teach?
  • What will I be able to do after completing this course?
  • Who is this course for?
  • What will I need to know before starting this course?
  • Where can I ask for help?
Be a Great Student!
00:53
Download the Excel Project Files + Course Study Tracker
Article
Introduce Yourself!
Article
I need your help!
01:02
Section 2: GET STARTED WITH POWER PIVOT AND POWER VIEW
What is PowerBI?
01:33
02:45

Microsoft Power Pivot for Excel is an add-in that you can use to perform powerful data analysis in Microsoft Excel, bringing self-service business intelligence to your desktop.

Power View is an interactive data exploration, visualization, and presentation experience that encourages intuitive ad-hoc reporting. Power View is a feature of Microsoft Excel 2013

02:50
In this lecture you are going to learn how to Install the PowerPivot and Power BI add-ins.
03:14
In this lecture you'll learn how to install easy the PowerPivot and Power View add-in. Download the Excel workbook used in the video tutorial and try the lesson yourself.
The Powerpivot Interface (Excel 2016)
01:47
03:45

Importing relational data through the Power Pivot add-in is often a faster and more efficient alternative to importing in Excel.

Download the Excel workbook used in the video tutorial and try the lesson yourself.

02:06

In this lecture we will see how we can consume data from Excel in PowerPivot so that the updates in Excel are readily reflected in PowerPivot. PowerPivot has a feature called "Linked Tables" which allows us to address this requirement.

Download the Excel workbook used in the video tutorial and try the lesson yourself.

01:39
Let’s learn how to create a pivot table from Microsoft Access Data.
02:22

Add more power to your data analysis by creating relationships between data in different tables. A relationship is a connection between two tables of data, based on one column in each.

Download the Excel workbook used in the video tutorial and try the lesson yourself.

Article
Use relationships to quickly link multiple tables together, entirely bypassing VLOOKUP() or similar tedious formulas.
2 pages

You can download the PDF file

How can I help you?
Article
CHEAT SHEET ~ Get started with Powerpivot and Powerview
1 page
2 questions
QUIZ OF SECTION:2
Section 3: CALCULATED FIELDS - COLUMNS & DAX FORMULA LANGUAGE
Introduction to DAX Formula Language
01:33
04:56

Calculated fields, also known as measures in Excel 2010 version of Power Pivot and in Analysis Services Tabular models, are calculations used in data analysis. Examples commonly found in business reports include sums, averages, minimum or maximum values, counts, or more advanced calculations that you create using a Data Analysis Expressions (DAX) formula.

Download the Excel workbook used in the video tutorial and try the lesson yourself.

07:37

With calculated columns, you can add new data to a table in your Power Pivot Data Model. But instead of pasting or importing values into the column, you create a Data Analysis Expressions (DAX)formula that defines the column values.

Download the Excel workbook used in the video tutorial and try the lesson yourself.

04:17

The Data Analysis Expressions (DAX) language is a new PowerPivot formula language that allows users to define custom calculations in PowerPivot tables (calculated columns) and in Excel PivotTables (measures). DAX includes some of the functions that are used in Excel formulas, and additional functions that are designed to work with relational data and perform dynamic aggregation.

Download the Excel workbook used in the video tutorial and try the lesson yourself.

02:56

Filtering is especially useful if you have a large list and you want to work with only a subset of the records in the list.

Download the Excel workbook used in the video tutorial and try the lesson yourself.

Case Study: Company Sales Table Part:1 - COUNTROWS Function
06:14
Case Study: Company Sales Table Part:2 - Slicers & Timeline
04:22
HELP > If you need more help for DAX formula language
Article
CHEAT SHEET OF SECTION:3 ~ Calculated fields and columns - DAX formula language
1 page
2 questions
QUIZ OF SECTION:3
Section 4: KPI, KEY METRICS AND DESIGN YOUR DASHBOARD > PART:1
03:49
Dashboards can be powerful tool in communicating your organization's important measurement data at a glance.

Learn the best design principles - 10 golden rules

02:28

Key Performance Indicators, also known as KPI or Key Success Indicators (KSI), help an organization define and measure progress toward organizational goals.

Learn how to create them in this lecture.

Download the Excel workbook used in the video tutorial and try the lesson yourself.

07:08

Start designing your Dashboard with link buttons.

Download the Excel workbook used in the video tutorial and try the lesson yourself.

04:05

Enrich the Dashboard with key metrics and Pivot Tables.

Download the Excel workbook used in the video tutorial and try the lesson yourself.

You can also download the Character Map
Section 5: DESIGN YOUR DASHBOARD > PART:2
04:22

Learn how to create Pivot Charts.

Download the Excel workbook used in the video tutorial and try the lesson yourself.

05:25

Slicers provide buttons that you can click to filter PivotTable data. In addition to quick filtering, slicers also indicate the current filtering state, which makes it easy to understand what exactly is shown in a filtered PivotTable report.

A timeline is a type of chart which visually shows a series of events in chronological order over a linear timescale. The power of a timeline is that it is graphical, which makes it easy to understand critical milestones, such as the progress of a project schedule. Timelines are particularly powerful for project scheduling or project management.

Download the Excel workbook used in the video tutorial and try the lesson yourself.


2 questions
QUIZ OF SECTION:5
Section 6: CREATE AN AMAZING SALES MAP WITH POWER VIEW
01:59
Excel now provides you with a flexible, powerful and complete business analysis solution that lets you analyze data and discover insights in your own way. Find and connect to data, shape, model and analyze data, and design rich reports. Download the Excel workbook used in the video tutorial and try the lesson yourself.
01:50
In this lecture you'll learn in detail all the tools of Power View feature, like Matrices, Cards and Tiles. Download the Excel workbook used in the video tutorial and try the lesson yourself.
03:07
Maps in Power View display your data in the context of geography. Maps in Power View use Bing map tiles, so you can zoom and pan as you would with any other Bing map. To make maps work, Power View has to send the data to Bing through a secured web connection for geocoding, so it asks you to enable content. Download the Excel workbook used in the video tutorial and try the lesson yourself.
CHEAT SHEET ~ Create an amazing sales map with Powerview
1 page
2 questions
QUIZ OF SECTION:6
Section 7: COMPLETING YOUR DASHBOARD
04:36
Complete your awesome Dashboard with more tips & tricks. Download the Excel workbook used in the video tutorial and try the lesson yourself.
My Final Thoughts & Thank you!
00:44
Section 8: BONUS SECTION
Amazing discount for my other courses!
Article
02:01

Master the Microsoft Excel through just 10 keyboard shortcuts

9 pages

This lecture provides an overview of the most common types of functions supported in the DAX language.


2 pages
10 TOP EXCEL KEYBOARD SHORTCUTS
BONUS ~ 3 unknown methods to select an Excel Data Range
4 pages

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Andreas Exadaktylos, Teacher|Msc Computer Scientist

Hi, I am Andreas and I'm a teacher. I really love learning and teaching whenever I can.

I have over 16 years of experience in teaching as an instructor, especially in Microsoft Excel. I have my own computer learning school, called Futurekids, from 2001 to now. I am the founder of Mellon Training, an online video tutorials learning school.

I have a Master's Degree in Computer Science and a Degree in Electronic Engineering.

I always wanted to create my own business. Being your own boss is an incredibly liberating experience but difficult as well.

I have a passion for software products that make people's lives easier. I teach Python Programming, Microsoft Excel and all Microsoft software products for over 17 years. I am a professional Forex Trader for over 5 years.

I love to create websites and optimize them with Search Engine Optimization techniques. I created my online e-shop, called Bite me not jewels, with my wife.

I live in Rodos, a beautiful Greek island. When I am not working, I love being with my family and my two kids. Travel, forex trading, and reading books are my favorite hobbies.

Ready to start learning?
Take This Course