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+ Microsoft AZ-900
Graphic Design Photoshop Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Personal Development Mindfulness Personal Transformation Life Purpose Meditation CBT Emotional Intelligence
Web Development JavaScript React CSS Angular PHP Node.Js WordPress Vue JS
Google Flutter Android Development iOS Development React Native Swift 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 Retargeting
Microsoft Power BI SQL Tableau Business Analysis Data Modeling Business Intelligence MySQL Data Analysis Blockchain
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Business Plan Startup Online Business Freelancing Blogging Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
30-Day Money-Back Guarantee
Business Business Analytics & Intelligence Microsoft Power BI

Microsoft Power BI Masterclass 7 Learn DAX, R, and Gateways

How to become a bi data analyst. Microsoft Power BI online training
Rating: 4.6 out of 54.6 (137 ratings)
979 students
Created by Dan We
Last updated 4/2021
English
English [Auto]
30-Day Money-Back Guarantee

What you'll learn

  • You can quickly create stunning reports in Microsoft Power BI
  • You master advance DAX calculations and build on your prior acquired knowlege from the other Masterclass courses
  • Taking the Power BI Masterclass series on udemy will prepare you to start your data analytics career
  • You learn how to set up you personal data gateway
  • Improve look and feel of standard dashboards
  • You can use R in Power BI
  • You can generate valuable insights for yourself and your company

Requirements

  • This course extends my exclusive Power BI Masterclass on udemy
  • Power BI can be downloaded for free, no additional costs
  • All additional files and material will be provided
  • Your interest and willingness to learn new things and grow and explore new opportunities
  • I highly recommend to check out the first Masterclass "Power BI Masterclass - beginners to advanced" first
  • If you want to master Power BI completely I recommend taking all complementary courses of the masterclass series

Description

Master Microsoft Power BI and create  your succesful business analyst / data analyst career

Business Intelligence / Business Analytics is in high demand. Companies are constantly searching for ways to make better and faster decisions. Therefore they rely heavily on data. Data driven decision making is the key to success for any business in the world of tomorrow.

Because of that companies are constantly searching for skilled employees and freelancers with the necessary capabilities to help with analyzing data and creating valuable highly profitable insights. This will be the key advantage to succeed in business.

MS Power BI is an andvanced yet easy to get started self service business analytics / business intelligence solution provided by Microsoft which is currently in very hot demand. From my personal experience I can tell you that companies will actively searching for you if you master Power BI. Diving into data & analytics can not only immensly improve your career opportunities but also your job satisfaction!

Power BI is also a great tool for datascience too. A lot of data scientists like to use it for visualizing and presenting the findings. Therefore learning to use this tool can also be a valuable skill for datascience jobs.

Power BI has a very strong active community and with Microsoft pushing this solution to it's enterprise customers, Power BI has a bright future ahead. And you can be part of this future!

There is no coding required! Power BI allows you to do that but it's not necessary.

To help you getting into this highly rewarding and interesting career path the Power BI Masterclass Series has been created.

It's an exclusive series currently consisting of these courses on udemy.


Update: The complete Power BI Masterclass Series on udemy

1.Power BI Masterclass - beginners to advanced

2.Microsoft Power BI Masterclass - Expand Excellence

3.Power BI Masterclass - Data Analysis Deep Dive

4.Business Intelligence with Microsoft Power BI

5.Power BI Masterclass - DAX, Excel And More

6.Power BI Masterclass - Your future in data analytics

7.Power BI Masterclass - Learn Advanced DAX, R and Gateways

8.Power BI Masterclass - Python, Finance and advanced DAX

9. Power BI Masterclass - How to use CALCULATE in DAX

Tips and Tricks courses:

10. The Power BI Masterclass - Tips and Tricks

11. The Power BI Masterclass - Additional Tips and Tricks

12. Power BI - Tips for your next data analytics project

13. Microsoft Power BI Desktop - simple tips and tricks edition

14. Power BI Desktop - Data Prep Challenges

15. Power BI Masterclass - the next level


 Each Microsoft Power BI Masterclass course will add to your knowledge base and enhance your skills further. After attending the complete series you will have honed your skills to an very advanced level and be able to succesfully dive into your Microsoft Power BI data analytics career.


In this 7th Masterclass you will

  • learn and apply additional advanded DAX expressions and calculations and dive deep into a business dataset

  • getting an introduction on how to use R in Power BI

  • learn how to set up your personal data gateway to refresh your on premise data in the Power BI service

  • apply new custom visuals

  • create your own Sales dashboards

What we learn in this course might also help you later with your Power BI certification exam.

You can follow along with the provided learning material in Power BI on your own computer at your own pace. Exited? You should be. So let's answer the question on how to master Power BI Desktop. Buckle up and meet me in the first lecture starting today!

Who this course is for:

  • Students how have already taken courses of my Power BI Masterclass series on udemy
  • Everyone interested in Microsoft Power BI is welcome to join and explore the advantages of this tool for her/himself
  • You want to master self service bi with Microsoft Power BI
  • Students who know that legacy tools like Powerpoint and Excel will be replaced and want to acquire knowlege about the new tools
  • You want to excel at your job OR explore a new career opportunity in data analytics
  • You want to lay the foundations for a successful future in the era of data with Microsoft Power BI
  • You want to learn a better tool than Qlickview and IBM Cognos
  • You want to take advantage of the data driven opportunity ahead

Course content

1 section • 23 lectures • 2h 56m total length

  • Preview02:49
  • Download all resources here
    00:01
  • Preview11:16
  • 5 Advanced DAX - How to handle price adjustments in Power BI
    14:55
  • 6 Power BI DAX - How to calculate Ages
    08:31
  • 7 Advanced DAX - Total open Customer Complains in Power BI
    09:37
  • 8 Additional Timeintelligence for your Power BI Toolbox
    17:31
  • 9 How to automatically always show the latest data in our Report
    06:06
  • 10 Advanced DAX - Which product was ordered first by each customer
    07:22
  • 11 R in Power BI - Visualizing data using R Scripts
    10:03
  • 12 R in Power BI - Importing and transforming data with R example
    08:26
  • 13 R Visuals in Power BI - lets get a little help to plot amazing visuals
    03:16
  • 14 Advanced DAX - Which where the last products the customer has ordered from us
    09:58
  • 15 Advanced DAX - Recurring Customers and their sales calculation
    07:56
  • 16 Lets build our final report
    09:50
  • 17 Excourse - A quick introduction to publishing Reports to the Power BI Service
    15:55
  • 18 Excourse - How to create a Dashboard in the Power BI Service online
    03:53
  • 19 Excourse - Setting up a data gateway to refresh local files in the Power BI S
    07:38
  • Logging out - my final words for you
    01:37
  • Bonus - SUMX vs SUM in Power BI Whats the difference and when to use which examp
    09:48
  • BONUS - How to create your own BUMP chart in Power BI
    09:36
  • Your complete Power BI Masterclass Journey
    00:42
  • NEW - A free resource for bonus videos tips and tricks
    00:04

Instructor

Dan We
BI Expert, Trainer, Datalover
Dan We
  • 4.4 Instructor Rating
  • 9,973 Reviews
  • 42,404 Students
  • 51 Courses

Dan is a 31 year old entrepreneur ,data scientist  and data analytics / visual analytics consultant. He holds a master degree and is certified in Power BI as well as a Qualified Associate in Tableau software. He is currently working in Business Intelligence field and helps major companies to get key insights from their data to deliver long term growth and outpace their competitors.

He is committed to support other people by offering them educational services to help them accomplishing their goals and becoming the best in their profession or explore a new career path.

"Helping others is the greatest joy"

"In order to do the impossible you need to see the invisible"

"If you don't like where you are then change. Life is too short!" 

You can do it!

  • 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.