Power Query and Power BI Combo Course

Focused View

Saad Nadeem

3:15:26

18 View

1 - Power Query Course

1 - 2.Introduction-to-Excel-Power-Query.xlsx

1 - Installing and Exploring Power Query.mp4

05:33

2 - Power Query Interface.mp4

04:46

3 - Power Query Update With Pivot Tables.mp4

02:56

4 - 5.Format-Date-and-Values.xlsx

4 - Format Dates and Values in Power Query.mp4

02:28

5 - 6.Parsing-URLs-in-Excel-Power-Query.xlsx

5 - Parsing URLs in Excel Power Query.mp4

04:04

6 - 7.Split-Text-Fields-in-Excel-Power-Query.xlsx

6 - 7.Split-Text-Fields-in-Excel-Power-Query-Finished.xlsx

6 - Split Text Fields in Excel Power Query.mp4

07:11

7 - 8.Group-By-in-Excel-Power-Query.xlsx

7 - Group By in Excel Power Query.mp4

03:06

8 - 9.Unpivoting-Columns.xlsx

8 - Unpivoting Columns.mp4

03:13

9 - 10.Pivoting-Columns.xlsx

9 - Pivoting Columns in Power Query.mp4

01:44

10 - 11.Split-Columns-into-Other-Columns.xlsx

10 - Split Columns into Other Columns.mp4

04:20

11 - 12.Filtering-Rows.xlsx

11 - Filtering Rows.mp4

04:03

12 - 13.Sorting-Data-in-Power-Query.xlsx

12 - Sorting Data in Power Query.mp4

02:36

13 - 14.Transform-and-Add-Columns.xlsx

13 - 14.Transform-and-Add-Columns-Finished.xlsx

13 - Transform and Add Columns.mp4

05:54

14 - 15.Regions.rar

14 - 15.Regions-Finished.xlsx

14 - Combine Excel Data Files in Power Query.mp4

06:19

15 - 16.Auto-Clean-Up-in-Power-Query.rar

15 - Perform Auto Clean Up in Power Query.mp4

07:08

16 - 17.Extract-Data-from-Forms.rar

16 - 17.Extract-Data-from-Forms-Finished.xlsx

16 - Extract Data from Forms in Power Query.mp4

13:46

17 - 18.Extract-Multiple-Criteria-in-Excel-Power-Query.xlsx

17 - 18.Extract-Multiple-Criteria-in-Excel-Power-Query-Finished.xlsx

17 - Extract Multiple Criteria in Excel Power Query.mp4

03:37

18 - 19.Extract-Multiple-Worksheets-in-Excel-Power-Query.xlsx

18 - Extract Multiple Worksheets in Excel Power Query.mp4

04:30

19 - 20.Introduction-to-Joins.xlsx

19 - 20.Introduction-to-Joins-Finished.xlsx

19 - Introduction to Joins.mp4

01:34

20 - Merging Tables In Power Query Using Joins.mp4

06:14

21 - 22.Outer-Joins-In-power-Query.xlsx

21 - Merge Tables in Power Query With Outer Joins.mp4

03:01

22 - 23.Right-Anti-Join.xlsx

22 - 23.Right-Anti-Join-Finished.xlsx

22 - Right Anti Join In Power Query.mp4

07:26

23 - 24.Convert-Reports-To-Pivot-Table-in-Power-Query.xlsx

23 - Convert Reports to Pivot Table in Power Query.mp4

03:42

24 - 25.Modulo.xlsx

24 - 25.Modulo-Finished.xlsx

24 - Modulo to Arrange Data.mp4

06:17

25 - Get a List of File Names Through Power Query.mp4

03:46

26 - 27.Get-Files-Names-Based-on-User-Selection-Finished.xlsx

26 - Get Files Names Based on User Selection.mp4

09:21

2 - Power BI Course

27 - 1 Introduction to the Course Final.mp4

00:44

28 - Downloading and Installing Power BI.mp4

02:46

29 - 3.Car-Sales-Sample-Data-Power-BI.xlsx

29 - Loading the Data in Power BI.mp4

04:58

30 - Creating Visuals Part 1.mp4

15:49

31 - Creating Visuals Part 2.mp4

09:24

32 - Editing Power BI Interactions.mp4

07:02

33 - Finalizing the Report Visuals.mp4

14:28

34 - Add More Data and Refresh Reports in Power BI.mp4

02:30

35 - Additional Tips and Conclusion.mp4

09:10

Description

Learn Excel Power Query, Power Pivot and Power BI Tools. Learn how to analyze millions of rows of data in Power Query

What You'll Learn?

Power Query: Learn to extract, transform, and load data from various sources.
Power Pivot: Transform raw data into a data model for meaningful analysis.
Power BI: Create interactive reports and dashboards for effective data visualization.
Power Map: Craft stunning interactive sales maps to analyze geographical trends.
Turn data into insights: Quickly transform vast amounts of data into actionable information.
Build reports and dashboards: Design captivating visuals to communicate insights clearly.
Analyze data with speed and accuracy: Make informed decisions based on reliable data analysis.
Start from scratch: Build your skills from the ground up, no prior knowledge required.
Learn the latest tools: Master the current versions of Excel
Improve your Excel skills: Sharpen your general Excel knowledge for more efficient data manipulation.
Follow along with practice files: Apply your learning to real-world scenarios.
Regular course updates: Stay ahead of the curve with continuous content refreshes.

Who is this for?

Everyone who wants to master Excel Dashboards

Business analysts

Data analysts

Students

What You Need to Know?

Willingness for learning

More details

Description
Learn to do really cool stuff with data! Our awesome bundle combines two courses: one on Power Pivot, Power Query, and DAX in Excel, and another on Power BI. If you've maxed out on Excel and want to do more with your data, these tools are perfect.
Power Pivot, Power Query, and DAX Course:
This course helps you do fancy things in Excel. You'll learn to:
Get data from different places.
Make your data look nice and tidy.
Create cool charts and tables.
Use a special language called DAX to do smart calculations.
Power BI Course:
Power BI is like Excel but super easy. In this course, you'll learn:
What Power BI is and why it's awesome.
How to bring in data from different files.
Make your data look even cooler with charts and graphs.
Use simple tricks to filter and organize your data.
These courses are easy to follow, and we've included practice files so you can play around and get good at it. Start having fun with data!

More About Power Query

Power Query is available on Excel 2010 and 2013 through a free download from Microsoft as described in the course.
Lets face it, retrieving, cleaning and transforming data to report on can take hours of precious time. With Excel Power Query you can eliminate repetitive tasks freeing your time for other important tasks, like lunch and going home on time. Excel Power Query removes the hassle and complex formulas of manual tasks such as:
Finding the Data each time you need a report
Cleaning Columns of Data
Splitting or Joining Column Values
Removing unnecessary characters and extra spaces
Formatting data correctly
Filtering data needed for the report
Combining multiple Datasets into a master list
Manipulating the data layout to work with other tools, i.e. Excel PivotTables and Charts
In just 3 easy steps, you'll have a final report ready for presentation and your next raise.
Get Data
Transform/Clean Data
Report on Data
Once you've got it all setup with Excel Power Query all you need to do is hit the Refresh button to update the report with next weeks data. Microsoft Power Query remembers all the steps you performed to get, transform and clean the data all you do is refresh and your report is updated.
Sounds all too easy, right? Enroll now and let me guide you through Excel Power Query and you'll quickly be on your way to harnessing the power of managing and reporting on data with Excel Power Query.
Who this course is for:
Everyone who wants to master Excel Dashboards
Business analysts
Data analysts
Students

User Reviews

Rating

average 0

Total votes0

Focused display

I am your professional coach for this course. I have a professional Associate Chartered Accountant (ACCA) with more than 7 years experience in accounting, management and corporate training. I have successfully trained more than 500 students in various accounting software programs.And I'm here with Udemy to teach what I know in an accessible way. I began to teach the course in personPlease send me a message if you have a recommended topic for my course or need help. I may not always be able to help you directly, but I still want to talk to you!

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.