Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certification Network & Security Hardware Operating Systems Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design Design Thinking 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition Yoga Mental Health Dieting Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA Amazon AWS CompTIA Security+ AWS Certified Developer - Associate
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Personal Development Mindfulness Meditation Personal Transformation Life Purpose Emotional Intelligence Neuroscience
Web Development JavaScript React CSS Angular PHP WordPress Node.Js Python
Google Flutter Android Development iOS Development Swift React Native Dart Programming Language Mobile Development Kotlin SwiftUI
Digital Marketing Google Ads (Adwords) Social Media Marketing Google Ads (AdWords) Certification Marketing Strategy Internet Marketing YouTube Marketing Email Marketing Google Analytics
SQL Microsoft Power BI Tableau Business Analysis Business Intelligence MySQL Data Modeling Data Analysis Big Data
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Online Business Business Plan Startup Blogging Freelancing Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
2021-02-15 15:32:18
30-Day Money-Back Guarantee
Office Productivity Microsoft DAX

Excel Power Query, Power Pivot, Power Map & DAX Masterclass

Learn Excel Power Query, PowerPivot, DAX, Power View & Power BI Tools. Build Excel Data Analyst Models with Excel 2019
Bestseller
Rating: 4.5 out of 54.5 (1,100 ratings)
6,646 students
Created by Andreas Exadaktylos
Last updated 2/2021
English
English
30-Day Money-Back Guarantee

What you'll learn

  • Learn in depth Power Query, PowerPivot, Power View and Power Map tools
  • 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 Power View powerful add-in
  • Analyze huge amounts of data fast and accurate
  • Improve general Excel knowledge
  • Follow along with included Excel project files
  • Learn the most current version of Microsoft Excel (Excel 2019 & Office 365)
  • 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
Curated for the Udemy for Business collection

Requirements

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

Description

COMPLETELY REDONE ON FEB 2021 WITH NEW VIDEOS!


Learn Power Query, Power Pivot, DAX, Power View, Power Map (3D Maps) and Power BI Desktop 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 Power Pivot and Power BI 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 2019 and Microsoft 365, but it's compatible with older versions of Excel.

This course aims to introduce the Excel user to the brave new world of self-service BI using the Excel BI Toolkit.

We'll use Microsoft Excel Power Query, Power Pivot, Power View, Power 3D Maps tools and DAX Formula Language to analyze huge amounts of business data fast and transform data into bottom-line results – no programming required!

Finally, we’re going to explain the Power BI Desktop application, that lets you share interactive dashboards based on your Excel data.

At the end of the course, we will create a beautiful dashboard, combining all the excel BI tools together.

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 48 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 take your business intelligence analysis to a whole new level!


What you'll learn:

  • Understand and install the Excel Power Query, Power Pivot, Power Map, Power View and Power BI Desktop add-ins

  • Import data from spreadsheets, Access, SQL, text files and other sources

  • Add calculated fields, columns and Measures with Data Analysis Expressions (DAX) formula language

  • Create complex reporting systems

  • How to use the Power View presentation and analysis tool.

  • Learn from start to finish the powerful features of Excel Power Map

  • Explain the Power BI Desktop application, that lets you share interactive dashboards based on your Excel data.

  • Design your Excel Dashboard with link buttons

  • What are KPI's and add key metrics

  • Create mind blowing Excel Pivot Charts from Power Pivot

  • Create powerful reports using Slicers and Timeline

  • Make an amazing interactive sales map using Excel 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 . 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 all the Excel BI Toolkit,  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

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

"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 this course is for:

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

Course content

11 sections • 85 lectures • 7h 18m total length

  • Preview08:26
  • Preview02:30
  • Preview02:00
  • Preview01:43
  • HOMEWORK-1
    00:15
  • Introduction
    3 questions

  • Install Power Query for Excel
    02:49
  • Preview03:17
  • Loading Data with Power Query (Get & Transform)
    13:20
  • Preview03:25
  • Filtering Data in Power Query
    04:33
  • Preview07:15
  • Powerful Data Table Transformations
    14:47
  • DEMO: Transform APPLE stock data with Power Query
    07:54
  • Grouping, Aggregating and inserting Calculated Columns
    04:02
  • Append, Duplicate and Merge Queries
    06:37
  • EXERCISE: Transposing a data set with Power Query
    03:23
  • EXERCISE: Transform a data set using Split Column
    03:50
  • CASE STUDY: Create A Macro Using Power Query
    08:28
  • Understanding column-level actions
    02:39
  • Understanding table actions
    01:49
  • GET STARTED WITH POWER QUERY
    5 questions

  • The Excel Data Model
    02:35
  • The Powerpivot Interface
    03:22
  • Making a User-Friendly Model
    04:23
  • Data Model or Query?
    01:56
  • Managing and Preparing Power Pivot Data for Analysis
    08:36
  • Creating Table Relations and Hierarchies
    05:15
  • Creating and Managing Relationships
    02:20
  • Perspectives
    02:19
  • Limitations of the Data Model
    00:38
  • Optimizing File Size
    01:43
  • HOMEWORK:2 - Loading Data into Power Pivot
    01:53
  • THE EXCEL DATA MODEL (POWER PIVOT)
    8 questions

  • Introduction to DAX Formula Language
    04:56
  • DAX Syntax and Data Types
    08:00
  • DAX Basic Calculations
    05:35
  • Preview04:05
  • DAX Text Functions
    03:45
  • DAX COUNTROWS & RELATEDTABLE functions: Counting Reference Elements
    04:10
  • DAX IF() & ISBLANK() functions: Simple Logic
    09:45
  • Complex Logic (IF, AND, OR functions)
    05:10
  • DAX CALCULATE() Function
    03:40
  • DEMO: DAX COUNTROWS Function, Slicers & Timeline
    09:38
  • HOMEWORK:3 - Creating Calculated Columns into Power Pivot
    00:35
  • DAX CALCULATIONS
    8 questions

  • Introduction to DAX Measures
    04:58
  • Creating Common Aggregates in DAX
    03:28
  • Calculating Measures
    06:43
  • Cross-Table Measures
    04:52
  • Filtering Data in Measures
    08:00
  • Using DAX ALL() Function
    03:29
  • Understanding DAX Errors
    01:00
  • Preview05:00
  • DAX MEASURES
    6 questions

  • Simple Date Calculations
    10:18
  • Creating a Date Table in Power Pivot
    20:38
  • Adding Sort By Columns to the Date Table
    04:46
  • Adding the Date Table to the Data Model
    01:23
  • Applying Time Intelligence (YearToDate, QuarterToDate, MonthToDate)
    03:47
  • ANALYZING DATA OVER TIME WITH DAX
    3 questions

  • The Power View Interface
    04:18
  • Creating Tables in Power View
    04:58
  • Enhancing Tables in Power View
    05:16
  • Matrix Tables
    07:32
  • Card Visualization
    03:47
  • Filtering Data in Power View
    08:11
  • Advanced Filters
    05:32
  • Charts in Power View
    10:11
  • GET STARTED WITH POWER VIEW
    6 questions

  • Power Map Basics
    04:40
  • Power Map Format
    02:25
  • Power Map Category
    01:08
  • Power Map Scene
    03:55
  • Power Map Annotation & Text Box
    01:55
  • Power Map 2D Chart
    02:54
  • Power Map Time Feature
    08:03
  • Power Map Capture Screen & Video
    03:00
  • GET STARTED WITH POWER MAP
    4 questions

  • Getting Started With Power Bi Desktop
    04:26
  • Importing and preparing data in Power BI
    06:19
  • Building An Interactive Report With Power Bi Desktop
    09:36
  • Publishing To Power Bi
    03:23
  • GET STARTED WITH POWER BI DESKTOP
    4 questions

  • Design your Dashboard with link buttons
    09:13
  • Add key metrics and create our first Powerpivot pivot table
    05:52
  • Create pivot charts
    04:04
  • Complete the dashboard using slicers and timeline
    04:11
  • Getting started with Power View
    04:11
  • Create a sales map from Power View
    03:12
  • Complete the Dashboard adding different Pivot Charts
    06:29

Instructor

Andreas Exadaktylos
Best Selling Teacher | Msc Computer Scientist
Andreas Exadaktylos
  • 4.6 Instructor Rating
  • 5,749 Reviews
  • 25,476 Students
  • 7 Courses

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. 

  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Impressum Kontakt
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.