Buying for a Team? Gift This Course
Wishlisted Wishlist

Please confirm that you want to add Excel Power Pivot & Excel Business Intelligence Masterclass to your Wishlist.

Add to Wishlist

Excel Power Pivot & Excel Business Intelligence Masterclass

Learn Excel Power Pivot - Power Map and Excel Power BI Tools. Build Excel Data Analyst Models with Microsoft Excel 2013
4.6 (100 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.
2,141 students enrolled
Last updated 12/2016
English
$10 $50 80% off
21 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 2 hours on-demand video
  • 6 Articles
  • 17 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Have a coupon?
What Will I Learn?
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
View Curriculum
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
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!

Who is the target audience?
  • Everyone who wants to master Excel Dashboards
  • Business analysts
  • Data analysts
  • Students
  • Entrepreneurs
Students Who Viewed This Course Also Viewed
Curriculum For This Course
Expand All 46 Lectures Collapse All 46 Lectures 02:08:20
+
WELCOME! (& DOWNLOAD THE FILES PLEASE!)
6 Lectures 06:38

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?
About this course
01:53

Be a Great Student!
00:53

Download the Excel Project Files + Course Study Tracker
00:26

Introduce Yourself!
00:29

I need your help!
01:02
+
GET STARTED WITH POWER PIVOT AND POWER VIEW
13 Lectures 22:48
What is PowerBI?
01:33

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

What are Excel Power Pivot and Power View add-ins?
02:45

In this lecture you are going to learn how to Install the PowerPivot and Power BI add-ins.
Install the PowerPivot and Power BI add-ins
02:50

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.
Preview 03:14

The Powerpivot Interface (Excel 2016)
01:47

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.

How to import data from PowerPivot Tab
03:45

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.

How to link data from PowerPivot tab
02:06

Let’s learn how to create a pivot table from Microsoft Access Data.
Importing Access Data & Create Pivot Table
01:39

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.

The diagram view and the relations between data
02:22

Use relationships to quickly link multiple tables together, entirely bypassing VLOOKUP() or similar tedious formulas.
An alternative way to create a lookup relationship
00:20

You can download the PDF file

Power Pivot Differencies between Excel 2010 and Excel 2013
2 pages

How can I help you?
00:26

CHEAT SHEET ~ Get started with Powerpivot and Powerview
1 page

QUIZ OF SECTION:2
QUIZ OF SECTION:2
2 questions
+
CALCULATED FIELDS, COLUMNS & DAX FORMULA LANGUAGE
10 Lectures 36:06
Introduction to DAX Formula Language
01:33

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.

Preview 04:56

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.

Calculated Columns & using Date Functions in PowerPivot
07:37

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.

Create calculated fields using DAX formula language
04:17

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.

Create filtered calculations - Using COUNTX & FILTER Functions
02:56

In this video tutorial, we are going to learn how to use CALCULATE DAX Function, one of the most useful and favorite functions in Data Analysis Expressions

Using Dax CALCULATE() Function
03:52

PROJECT #1 - Part:1 - COUNTROWS DAX Function
06:14

PROJECT #1 - Part:2 - Slicers & Timeline
04:22

HELP > If you need more help for DAX formula language
00:19

CHEAT SHEET OF SECTION:3 ~ Calculated fields and columns - DAX formula language
1 page

QUIZ OF SECTION:3
QUIZ OF SECTION:3
2 questions
+
KPI, KEY METRICS AND DESIGN YOUR DASHBOARD > PART:1
4 Lectures 17:30
Dashboards can be powerful tool in communicating your organization's important measurement data at a glance.

Learn the best design principles - 10 golden rules

Preview 03:49

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.

What are KPI’s and how to create them?
02:28

Start designing your Dashboard with link buttons.

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

Design your Dashboard with link buttons
07:08

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
Add key metrics and create our first Powerpivot pivot table
04:05
+
DESIGN YOUR DASHBOARD > PART:2
2 Lectures 09:47

Learn how to create Pivot Charts.

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

Create pivot charts
04:22

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.


Complete the dashboard using slicers and timeline
05:25

QUIZ OF SECTION:5
QUIZ OF SECTION:5
2 questions
+
CREATE AN AMAZING SALES MAP WITH POWER VIEW
4 Lectures 06:56
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.
Preconditions and features of Power View
01:59

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.
Using Matrices, Cards and Tiles to visualize Power View Data
01:50

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.
How to create an amazing sales map and other useful charts
03:07

CHEAT SHEET ~ Create an amazing sales map with Powerview
1 page

QUIZ OF SECTION:6
QUIZ OF SECTION:6
2 questions
+
COMPLETING YOUR DASHBOARD
2 Lectures 05:20
Complete your awesome Dashboard with more tips & tricks. Download the Excel workbook used in the video tutorial and try the lesson yourself.
Completing Dashboards with Pivot Charts
04:36

My Final Thoughts & Thank you!
00:44
+
BONUS SECTION
5 Lectures 03:27
Amazing discount for my other courses!
01:26

Master the Microsoft Excel through just 10 keyboard shortcuts

BONUS ~ 10 Top Powerful Excel Shortcuts
02:01

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


BONUS ~ The most important types of DAX Functions
9 pages

10 TOP EXCEL KEYBOARD SHORTCUTS
10 TOP EXCEL KEYBOARD SHORTCUTS - pdf version
2 pages

BONUS ~ 3 unknown methods to select an Excel Data Range
4 pages
About the Instructor
4.6 Average rating
711 Reviews
10,534 Students
7 Courses
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.

Report Abuse