Sale!

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

(10 customer reviews)

$18

Category:

Description

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

Show moreShow less

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.

IMPORTANT NOTE: To make sure that your version is compatible before you go on with that course, please check the Microsoft Excel compatibility page. You can watch the 3rd lecture of the course: Versions, Compatibility and Install Power Pivot, Power Map & Power View. (it has a free preview)

Power Pivot is currently not available for Mac and is only available in specific Excel versions for windows.

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

  • Introduction
  • GET STARTED WITH POWER QUERY
  • THE EXCEL DATA MODEL (POWER PIVOT)
  • DAX CALCULATIONS
  • DAX MEASURES
  • ANALYZING DATA OVER TIME WITH DAX
  • GET STARTED WITH POWER VIEW
  • GET STARTED WITH POWER MAP
  • GET STARTED WITH POWER BI DESKTOP
  • MILESTONE PROJECT: CREATE AN INTERACTIVE DASHBOARD

10 reviews for Excel Power Query, Power Pivot, Power Map & DAX Masterclass – Udemy

  1. Donny Phan

    Super practical. Lessons are catered towards anyone looking to find work in this industry. It felt very comprehensive and gave me a broad understanding of the programming spectrum

  2. Madhav raj Verma

    Thanks for your great effort. i am fully satisfied with this course the way you teach and your explanation are very clear ,The content you provide in your course no one can do this at this price.

  3. Sachin Gupta

    I really didn’t want to leave a low rating as Angela is a great teacher. The 1st half of this course was terrific. The 2nd half was terrible. Under the justification of “teaching students how to figure things out on their own”, pretty much all videos and all explanations were dropped. You were just told what to do, given links to documentation and told to figure it out on your own. I understand doing that to some degree, but to revert to that entirely for nearly half the content barely makes this a course. It’s just a list of things for you to learn, then you’re left on your own to learn them. The 2nd half was so bad, especially the data science component, that I didn’t bother finishing the course.

  4. Vincent Beaudet

    Amazing 40 days course.
    Angela is a great teacher.
    The other 60 days are all about web developement, interacting with web pages, on your own with little to no explanations. I did not expect that at all. I wanted to learn more about software and scripting.
    This left me disappointed , confused and i started to doubt myself. Not a fun experience after the amount of effort i’v put in this course.

    Exercices format and explanations for the first 40 days were worth it tho.

  5. Ben K

    Not just an introduction to python, but really helps you learn fundamental aspects of python and coding in general. Some parts may require some knowledge on the subject (data science comes to mind) and there is quite some web development in the course. So, a few areas were not completely to my liking (I would have liked to see it done differently), but this course deserves the 5 stars in my opinion.

  6. Omid Alikhel

    I found the method a bit difficult when a code is written and then changed back to something different, with no enough explanation of how something happened and where it came from or a step by step explanation of why something is happening, i have no doubt in the instructors talent, but we are beginners!

  7. Alica Cverdeľová

    I love this course, Angela explained it very easily and clearly from the beginning, but I loved her 1 minute final videos, which ended later: What a pity.
    BUT I felt a little disappointed now with the project Day 39/40. Where I was maximally lost, I could not come out of where to look for anything and it was poorly explained and the biggest mistake was that there were no videos with explanations, I think it was quite a complicated project where many things were used and no explanation, only the final results. And they carried a few things in the projects before, so I had her project run once and it showed her the mistake as well as me, so in that case you have to leave it at that and what else is a shame. It’s hard to do a project when you don’t see what’s going on there.
    I’m a little worried about the next few weeks, and I hope it won’t be a waste of time.

  8. Szymon Kozak

    I think that the course tutor is really good in giving right information to learn at the right time. Thanks to this fact, my understanding of coding in python after 29 days of learning is above my expectations.

  9. Begoña Ruiz Diaz

    Ha sido la mejor elección que podría haber hecho.

  10. Vaibhav Sachdeva

    I want to thank Angela for making such an amazing course. It really helped me explore more things with python.

Add a review

Your email address will not be published.