Microsoft Power BI for Beginners: Get Started with Power BI

Focused View

Simon Sez IT

4:07:04

266 View

1 - Introduction

1 - Welcome and Overview.mp4

02:51

2 - WATCH ME Essential Information for a Successful Training Experience.mp4

02:03

3 - DOWNLOAD ME Course Demo Files Section 24.html

3 - Power-BI-Course-Demo-Files-section-2-4.zip

4 - DOWNLOAD ME Course Demo Files Section 58.html

4 - Power-BI-Course-Demo-Files-section-5-8.zip

5 - DOWNLOAD ME Course Exercise File.html

5 - Power-BI-Exercise-Files.zip

6 - DOWNLOAD ME Course Transcript.html

6 - Power-BI.pdf

7 - What is Power BI.mp4

04:22

8 - Install Power BI Desktop.mp4

02:08

9 - A Tour of BI Desktop.mp4

06:54

10 - Explore Commonly Used Power BI Options.mp4

05:23

2 - Getting and Transforming Data

11 - Import Files from a Folder into Power BI Desktop.mp4

12:29

12 - Get Data from Excel and Text Files.mp4

07:08

13 - Changing Query Source.mp4

04:14

14 - Reference Queries to Create Additional Lookup Tables.mp4

06:36

15 - Merge Queries in Power Query.mp4

06:57

16 - Prevent Queries from Loading into Power BI Desktop.mp4

03:05

17 - Practise Exercise.mp4

00:37

3 - Data Modelling

18 - Create Relationships Between Tables.mp4

06:49

19 - Create a Dynamic List of Dates.mp4

08:53

20 - Create Additional Date Columns for Analysis.mp4

09:13

21 - Sort the Month and Weekday Names Correctly.mp4

02:47

22 - Mark the Table as a Date Table.mp4

01:03

23 - Hide Unnecessary Fields from Report View.mp4

04:59

24 - Practise Exercise.mp4

00:32

4 - Introduction to DAX Measures

25 - Calculate the Total Revenue.mp4

06:39

26 - Count the Total Rows of a Table.mp4

01:56

27 - Use the CALCULATE Function.mp4

05:33

28 - Calculate the Total Revenue Last Year.mp4

03:38

29 - Difference Compared to Last Year.mp4

05:23

30 - Practise Exercise.mp4

00:36

5 - Adding Visualizations to your Report

31 - Show Summary Information with Cards.mp4

06:48

32 - Columns Charts to Compare Values.mp4

07:33

33 - Map Visual to Plot Geographic Data.mp4

04:46

34 - Slicers to Filter your Reports.mp4

08:05

35 - KPI Card to Measure Performance Against a Goal.mp4

07:16

36 - Line Graphs to Visualise Trend.mp4

05:59

37 - Show Detail with the Matrix.mp4

09:45

38 - Top N Lists with the Table Visualisation.mp4

07:48

39 - Practise Exercise.mp4

00:38

6 - Report Design

40 - Adding Text Boxes and Shapes.mp4

09:55

41 - Use Themes.mp4

07:41

42 - Conditional Formatting.mp4

07:59

43 - Practise Exercise.mp4

00:34

7 - Editing Interactions and Filters

44 - Edit the Interactions between your Visualisations.mp4

09:45

45 - The Filter Pane to Filter at Any Level.mp4

07:03

46 - Drill Through to More Detail.mp4

08:17

47 - Practise Exercise.mp4

00:35

8 - Power BI Service

48 - Publish Your Report to the Power BI Service.mp4

06:29

49 - Different Ways to Share your Power BI Report.mp4

05:25

50 - Practise Exercise.mp4

00:48

9 - Closing

51 - Wrap Up.mp4

01:07

Description

Learn to analyze data and create beautiful dashboards with this Microsoft Power BI beginners course

What You'll Learn?

How to create stunning, interactive dashboards with Power BI
How to share your analysis and dashboards using Power Bi Online
To import CSV and Excel files into Power BI Desktop
All about DAX including using the COUTROWS, CALCULATE, and SAMEPERIODLASTYEAR functions
All about using the card visual to create summary information
How to create amazing visuals, such as clustered column charts, maps, and trend graphs
How to use Slicers to filter your reports
How to edit the interactions between your visualizations and filter at visualization, page, and report level

Who is this for?

Advanced Excel users

What You Need to Know?

A good knowledge of MS Excel is advised but not necessary

Power BI Desktop installed on your machine is required to take the practice exercises

More details

Description
This course includes practice exercise files and LIFETIME access
Learn Microsoft Power BI with this brilliant beginner course from Microsoft experts Simon Sez IT.

Power BI is an incredibly powerful, self-service Business Intelligence (BI) solution from Microsoft. It is the perfect Business Intelligence tool for people with limited technical experience.
In this Power BI course, we start by looking at Power Query, and how to use this tool to organize and clean our data. We then show you how to build a Data Model and relate separate tables. After that, we teach you all about the data analysis language DAX in Power BI. Finally, we look at how to present this data using the charts and graphs available.

In this course you will learn:

What is Power BI and why you should be using it.
To import CSV and Excel files into Power BI Desktop.
How to use Merge Queries to fetch data from other queries.
How to create relationships between the different tables of the data model.
All about DAX including using the COUTROWS, CALCULATE, and SAMEPERIODLASTYEAR functions.
All about using the card visual to create summary information.
How to use other visuals such as clustered column charts, maps, and trend graphs.
How to use Slicers to filter your reports.
How to use themes to format your reports quickly and consistently.
How to edit the interactions between your visualizations and filter at visualization, page, and report level.

Exercise and demo files included
This course includes:
4+ hours of video tutorials
45 individual video lectures
Exercise files to practice what you learned
Certificate of completion

Hereâ€™s what our students are sayingâ€¦
"Brilliant course. I'm quite new to the world of POWER and this course has shown me what it can do in a way that a newbie can understand.Â Recommended. I will be looking for other courses by them."
- Andrew
"Very detailed course, really enjoyed the Power BI course. Simon has done a really good job explaining each process step. Looking forward to completing additional Power BI courses for advanced techniques."
- Martin
"I would highly recommend. The course was informative and easy to follow."
- Thomas
"Great match! Learning so much and I love the quick step by step videos."
- Vikki
Who this course is for:
Advanced Excel users

User Reviews

Rating

average 0

Total votes0

Focused display

Microsoft Power BI

Simon Sez IT

Instructor's Courses

Since 2008, individuals, small businesses, and Fortune 500 companies with thousands of employees have benefited from the easy and hands-on software training offered by Simon Sez IT. With over 8,000 video tutorials on a range of software programs, Simon Sez IT ensures stress-free eLearning and enhanced employee productivity - no matter whether you are implementing new software or a technological upgrade for your workplace. With over 630,000 Udemy students in over 180 countries, Simon Sez IT is the preferred online learning choice for individuals and businesses everywhere.

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.