Power BI Desktop - Solving Data Prep Challenges
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
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
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
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
Course content
- Preview01:12
- 00:46Before you start
- 00:02Download latest course files
- 13:31Power BI Data Prep Challenge 1 - DateTime Conversion
- 19:45Power BI Data Prep Challenge 2 - Bulk replacement of text values in 1 shot NEW
- Preview09:48
- 15:00Power BI DAX Challenge 4 - How many subscriptions do we have at this time
- 10:26Power BI Data Prep Challenge 5 - Handling missing values in Power BI
- 10:21Power BI Data Prep Challenge 6 - How to handle various local date types
- 21:18Power BI Data Prep Challenge 7 Currency Conversion - Exchange Rates for specific
- 10:13Power BI Data Prep Challenge 8 - How to fix the pivoting Issue
- 00:04NEW - A free resource for bonus videos tips and tricks
- 00:46The complete Power BI Masterclass Course Series on Udemy - all you want to know
- 00:29Log out and final words
Instructor
![Dan We](data:image/svg+xml,%3Csvg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 64 64"%3E%3C/svg%3E){kind=avatar}
- 4.4 Instructor Rating
- 9,724 Reviews
- 41,596 Students
- 53 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!