Power BI Desktop - Solving Data Prep Challenges

Focused View

Dan We

2:00:40

110 View

1. Power BI Desktop - Solving Data Prep Challenges

1. Power BI Desktop - Data Prep Challenges Introduction.mp4

01:12

2. Before you start.html

3.1 Power BI Data Prep Challenges.zip

3. Download latest course files.html

4. Power BI Data Prep Challenge 1 - DateTime Conversion.mp4

13:31

5. Power BI Data Prep Challenge 2 - Bulk replacement of text values in 1 shot NEW.mp4

19:45

6. Power BI Data Prep Challenge 3 - Count of Customer Ratings and Sorting.mp4

09:48

7. Power BI DAX Challenge 4 - How many subscriptions do we have at this time.mp4

15:00

8. Power BI Data Prep Challenge 5 - Handling missing values in Power BI.mp4

10:26

9. Power BI Data Prep Challenge 6 - How to handle various local date types.mp4

10:21

10. Power BI Data Prep Challenge 7 Currency Conversion - Exchange Rates for specific.mp4

21:18

11. Power BI Data Prep Challenge 8 - How to fix the pivoting Issue.mp4

10:13

12. DAX Motivation Never give up keep going.mp4

01:02

13. More POWER Learning Resources for you.html

14. Log out and final words.mp4

00:29

2. Bonus

1. How to create a dynamic KPI card showing different KPI values in Power BI.mp4

07:35

2. NEW - A free resource for bonus videos tips and tricks.html

Description

How to do data preparation in Power BI Desktop - data cleaning with Power BI Desktop - data processing in Power BI

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

Who is this 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

More details

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

User Reviews

Rating

average 0

Total votes0

Focused display

Microsoft Power BI

Dan We

Instructor's Courses

Dan is a 33 year old entrepreneur ,data enthusiast consultant and trainer. He holds a master degree and is certified in Power BI, Tableau, Alteryx (Core and Advanced) and KNIME (L1-L3).He is currently working in Business Intelligence field and helps companies and individuals to get key insights from their data to deliver long term growth and outpace their competitors.He has a passion for learning and teaching and 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."The dots will connect"Just do it!

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.