Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Power BI Desktop - Solving Data Prep Challenges
Rating: 4.7 out of 5(24 ratings)
294 students

Power BI Desktop - Solving Data Prep Challenges

How to do data preparation in Power BI Desktop - data cleaning with Power BI Desktop - data processing in Power BI
Created byDan We
Last updated 10/2023
English
English [Auto],

What you'll learn

  • We will solve common Power BI Data preparation issues
  • We will improve our Power BI skills
  • We will learn how to use the Powerquery Editor of Power BI more efficiently
  • We will improve our Power BI skills which we already have gained from the other Power BI Masterclass courses on udemy

Course content

2 sections • 16 lectures • 2h 2m total length

  • Power BI Desktop - Data Prep Challenges Introduction1:12

    Explore data prep challenges in Power BI Desktop and learn how properly formatted data enables accurate visualizations, equipping you with in-demand data prep and visualization skills for your next job.

  • Before you start0:46
  • Download latest course files0:02
  • Power BI Data Prep Challenge 1 - DateTime Conversion13:31

    Master date time prep in Power BI: convert dispatch date and time in Power Query, fix leading zeros, and create a unified date time column.

  • Power BI Data Prep Challenge 2 - Bulk replacement of text values in 1 shot NEW19:45

    Master bulk text value replacement in Power BI data prep: use translation lookup tables, merge queries, and custom M code to replace abbreviations with full names in one shot.

  • Power BI Data Prep Challenge 3 - Count of Customer Ratings and Sorting9:48

    Learn Power BI data prep by counting customer ratings per product, cleaning and reshaping the rating data, and sorting with a custom sorting table for accurate bar-chart rankings.

  • Power BI DAX Challenge 4 - How many subscriptions do we have at this time15:00

    Master the Power BI DAX challenge by building a measure that counts active subscribers at a chosen date using a date table and start/end date logic.

  • Power BI Data Prep Challenge 5 - Handling missing values in Power BI10:26

    Calculate per-product averages to fill missing values in Power BI with Power Query. Pivot by date and product and add slicers for clear visualization.

  • Power BI Data Prep Challenge 6 - How to handle various local date types10:21

    Learn to standardize diverse local date formats in Power BI Desktop by transforming data, duplicating columns, converting to dates with locale-aware logic, and merging to a final date column.

  • Power BI Data Prep Challenge 7 Currency Conversion - Exchange Rates for specific21:18

    Learn to fetch ECB exchange rates via a web API, build a dynamic date-based currency conversion in Power BI, and convert foreign sales to euros.

  • Power BI Data Prep Challenge 8 - How to fix the pivoting Issue10:13

    Pivot a two-column dataset in Power BI to fix a data prep issue, using an index helper, fill down, and no aggregation to align product detail, id, name, and kind.

  • DAX Motivation Never give up keep going1:02

    Keep motivation high while learning data prep in Power BI, start small, dissect your code, and keep going; never give up through challenges to turn frustration into progress.

  • Log out and final words0:29

    Celebrate completing the data challenges and apply new insights that may open up career opportunities, then explore additional learning materials from the instructor's profile.

Requirements

  • I highly recommend to take the Power BI Masterclass - beginners to advanced course first
  • You should have prior Power BI knowledge
  • Power BI Desktop installation (download for free on windows)

Description

Microsoft Power BI Masterclass - Solving Data Prep Challenges

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

Because of that companies are drastically increasing to step up their efforts to find skilled employees and freelancers with the necessary capabilities to help with analyzing data and creating valuable highly profitable insights. 

Since there is way more demand than supply it is a "War for talent". And the competition will increase further. This environment is a bless for anyone who acquires the necessary capabilities and positions herself/himself


MS Power BI is an advanced 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 immensely improve your career opportunities but also your job satisfaction!

Power BI is also a great tool for data science 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 data science jobs.


Let's talk about data!!!


This course is inspired by students and extends my Power BI Masterclass series on udemy. This course is not a visual course like the other parts of the series. This time it's all about data preparation in Power BI Desktop. How can we leverage the Power Query Editor to prepare our data. Data preprocessing is key so we want to make sure to have to right data for visualizing in our reports


So let's dive into various Power BI Data prep challenges and find out a possible solution to solve them. Are you ready?


Update: The complete Power BI Masterclass Series on udemy (I have aggregated some classes together to provide more content value per class for you. I really hope that serves you better!


1. Power BI Masterclass - beginners to advanced

2. Microsoft Power BI Masterclass - Expand Excellence

3.Power BI Masterclass - DAX, Excel And More

4. The Power BI Masterclass - Additional Tips and Tricks

5. Power BI Desktop - Data Prep Challenges

6. Power BI Masterclass - DAX, R and Gateways

7. Power BI Masterclass - Python Finance and Advanced DAX

8. Power BI Masterclass - the next level

9. Power BI DAX Fundamentals Mastering the Key Concepts

10. Power BI Masterclass Calculation Groups with Tabular Editor

11. The Power BI Service Masterclass

12. How to build a profit and loss statement in Power BI Desktop


We got a lot to do so let's get into it!

Who this course is for:

  • Power BI User
  • Data Analysts
  • Every Power BI Desktop user who wants to use and understand advanced DAX calculations
  • Students interested in Data analytics and Data science
  • Everybody who wants to visualize data with Power BI Desktop

Report abuse