Master Microsoft Power BI: Beginner to Intermediate Training

Focused View

Simon Sez IT

10:38:48

112 View

1. Introduction to Power BI Beginner Course

1. Welcome and Overview.mp4

02:51

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

02:11

3.1 Power BI Course Demo Files_section 2-4.zip

3. DOWNLOAD ME Course Demo Files (Section 2-4).html

4.1 Power BI Course Demo Files_section 5-8.zip

4. DOWNLOAD ME Course Demo Files (Section 5-8).html

5.1 Power BI Exercise Files.zip

5. DOWNLOAD ME Course Exercise File.html

6.1 Power BI Course by Simon Sez IT .pdf

6. DOWNLOAD ME Course Transcript.html

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

11. Section Quiz.html

2. Beginner Getting and Transforming Data

1. Import Files from a Folder into Power BI Desktop.mp4

12:29

2. Get Data from Excel and Text Files.mp4

07:08

3. Reference Queries to Create Additional Lookup Tables.mp4

06:36

4. Merge Queries in Power Query.mp4

06:57

5. Prevent Queries from Loading into Power BI Desktop.mp4

03:05

6. Practise Exercise.mp4

00:37

7. Section Quiz.html

3. Beginner Data Modelling

1. Create Relationships Between Tables.mp4

06:49

2. Create a Dynamic List of Dates.mp4

08:53

3. Create Additional Date Columns for Analysis.mp4

09:13

4. Sort the Month and Weekday Names Correctly.mp4

02:47

5. Mark the Table as a Date Table.mp4

01:03

6. Hide Unnecessary Fields from Report View.mp4

04:59

7. Practise Exercise.mp4

00:32

8. Section Quiz.html

4. Beginner Introduction to DAX Measures

1. Calculate the Total Revenue.mp4

06:39

2. Count the Total Rows of a Table.mp4

01:56

3. Use the CALCULATE Function.mp4

05:33

4. Calculate the Total Revenue Last Year.mp4

03:10

5. Difference Compared to Last Year.mp4

05:23

6. Practise Exercise.mp4

00:36

7. Section Quiz.html

5. Beginner Adding Visualizations to your Report

1. Show Summary Information with Cards.mp4

06:48

2. Columns Charts to Compare Values.mp4

07:33

3. Map Visual to Plot Geographic Data.mp4

04:46

4. Slicers to Filter your Reports.mp4

08:05

5. KPI Card to Measure Performance Against a Goal.mp4

07:16

6. Line Graphs to Visualise Trend.mp4

05:59

7. Show Detail with the Matrix.mp4

09:45

8. Top N Lists with the Table Visualisation.mp4

07:48

9. Practise Exercise.mp4

00:38

10. Section Quiz.html

6. Beginner Report Design

1. Adding Text Boxes and Shapes.mp4

09:55

2. Use Themes.mp4

07:41

3. Conditional Formatting.mp4

07:59

4. Practise Exercise.mp4

00:34

5. Section Quiz.html

7. Beginner Editing Interactions and Filters

1. Edit the Interactions between your Visualisations.mp4

09:45

2. The Filter Pane to Filter at Any Level.mp4

07:03

3. Drill Through to More Detail.mp4

08:17

4. Practise Exercise.mp4

00:35

5. Section Quiz.html

8. Beginner Power BI Service

1. Publish Your Report to the Power BI Service.mp4

06:29

2. Different Ways to Share your Power BI Report.mp4

05:25

3. Practise Exercise.mp4

00:48

4. Section Quiz.html

9. Beginner Closing

1. Wrap Up.mp4

01:07

10. Introduction to Power BI Beyond the Basics Course

1. Course Introduction.mp4

03:11

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

02:04

3.1 Power BI Beyond the Basics Course Files.zip

3. DOWNLOAD ME Course Instructor File.html

4.1 Power BI Beyond the Basics transcription.pdf

4. DOWNLOAD ME Course Transcript.html

5. Setting Up for Success.mp4

08:18

6. Section Quiz.html

11. Intermediate Importing and Transforming Data in Power Query

1. Importing Excel Data Files from a Folder.mp4

04:21

2. Combining Files and Removing Columns.mp4

04:33

3. Splitting and Merging Columns.mp4

04:55

4. Applying Data Types.mp4

03:47

5. Importing Text and CSV Files.mp4

07:11

6. Relationships and Lookup Tables.mp4

06:41

7. Duplicate vs Reference.mp4

07:07

8. Creating a Lookup Table.mp4

03:28

9. Creating Index Columns.mp4

03:43

10. Merging Queries.mp4

05:19

11. EnableDisable Load and Report Refresh.mp4

03:22

12. Advanced Editor.mp4

04:49

13. Resolving Data Import Errors.mp4

05:07

14. Organizing Queries into Groups.mp4

03:00

15. Section Quiz.html

12. Intermediate Data Modeling

1. Troubleshooting Relationship Issues.mp4

06:21

2. Relationship Types.mp4

05:28

3. Cross Filter Direction.mp4

04:36

4. Section Quiz.html

13. Intermediate DAX - Essential Skills

1. Measures vs Calculated Columns.mp4

10:56

2. Creating a Date Table with DAX.mp4

06:45

3. Creating Additional Columns.mp4

05:16

4. Creating Conditional Columns.mp4

02:21

5. Marking Table as a Date Table.mp4

02:48

6. Using ROUNDUP to Extract Quarters.mp4

02:06

7. Creating Quick Measures.mp4

05:41

8. Creating a Key Measures Table.mp4

03:27

9. Aggregation Methods.mp4

05:12

10. Using SUMX.mp4

05:47

11. Section Quiz.html

14. Intermediate DAX - CALCULATE Function

1. The CALCULATE Function.mp4

04:33

2. Changing Context with FILTER.mp4

03:37

3. Using ALL with CALCULATE.mp4

05:26

4. Section Quiz.html

15. Intermediate Visualizations

1. Visualizations.mp4

08:37

2. Tables vs Matrix Tables.mp4

06:24

3. Formatting Visualizations - Part 1.mp4

06:46

4. Formatting Visualizations - Part 2.mp4

03:07

5. Conditional Formatting.mp4

12:41

6. Column and Line Charts.mp4

13:55

7. Card Visualizations.mp4

05:51

8. Map Charts.mp4

09:41

9. The Gauge Visualization.mp4

09:38

10. Slicers and Filter.mp4

08:28

11. Applying Design Elements.mp4

07:54

12. Section Quiz.html

16. Intermediate The Power BI Service

1. Creating a Shared Workspace in Power BI Service.mp4

04:51

2. Inviting Others to a Shared Workspace.mp4

01:53

3. Reports vs Dashboards.mp4

01:58

4. Pinning Visualizations to the Dashboard.mp4

07:09

5. Setting up Scheduled Refreshes.mp4

05:14

6. Section Quiz.html

17. Intermediate Orders Dashboard Example - Preparation

1. Orders Dashboard Example.mp4

03:30

2. Report Requirements.mp4

03:59

3. Importing Order Data.mp4

01:25

4. Section Quiz.html

18. Intermediate Orders Dashboard Example - Transformation

1. Transforming Order Data in Power Query.mp4

01:54

2. Creating Lookup Tables.mp4

05:38

3. Merging Queries.mp4

05:36

4. Creating a Dates Table.mp4

11:10

5. Creating DAX Measures.mp4

10:57

6. Section Quiz.html

19. Intermediate Orders Dashboard Example Report

1. Adding a Report Title.mp4

09:50

2. Report Navigation with Buttons and Bookmarks.mp4

10:23

3. Card Visualizations and Filtering.mp4

12:39

4. Line Chart Count of Male vs Female Customers.mp4

07:13

5. Stacked Column Chart Total Revenue by Region.mp4

06:00

6. Treemap Chart Count of Orders by YearMonth.mp4

05:59

7. Funnel Chart Age Distribution.mp4

06:18

8. Matrix Table Count of Customers by Type and Status.mp4

04:31

9. Adding Conditional Formatting.mp4

02:16

10. Section Quiz.html

20. Intermediate Orders Dashboard Example Dashboard

1. Publishing the Report to the Power BI Service.mp4

03:15

2. Pinning Media Tiles to Dashboard.mp4

06:32

3. Section Quiz.html

21. Intermediate Course Close

1. Course Close.mp4

01:50

Description

Master data analysis in Power BI and learn how to create stunning dashboards with this beginner to intermediate 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
Importing Excel, Text, and CSV files into Power BI Desktop and combining files
All about DAX including using the COUTROWS, CALCULATE, and SAMEPERIODLASTYEAR functions
How to create amazing visuals, such as clustered column charts, maps, and trend graphs
Using slicers and filters and applying design elements to your reports
How to edit the interactions between your visualizations and filter at visualization, page, and report level
How to import and transform data in Power Query
How to enable/disable load and report refresh and resolving data import errors
Data Modelling, relationship types, and troubleshooting relationship issues
Measures vs Calculated Columns and creating additional and conditional columns
How to use ROUNDUP and SUMX
Creating Quick Measures and a Key Measures Table
Using column, line, and map charts and gauge and card visualizations
Creating a Shared Workspace in Power BI Service
Creating reports and dashboards, pinning visualizations to the dashboard, and setting up scheduled refreshes

Who is this for?

Advanced Excel users

Business Intelligence Analysts

More details

Description
This course bundle includes downloadable course instructor files to follow along.

We've combined our Microsoft Power BI Beginner and Intermediate courses in this great value bundle. If you have reached your Excel limit and need to analyze and make sense of huge amounts of data, then Power BI can help take your existing data-crunching capabilities to new heights!

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.

The Power BI beginner course starts 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.

This intermediate training course is designed to be a continuation of the introductory Power BI course. We start the intermediate course by discussing the data files to be used and some Power BI desktop settings that will set you up for success. The latter part of the course is an intensive exercise to give you practice creating reports and dashboards.

What's included?

Power BI for Beginner:
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.

Power BI Intermediate:
Importing and transforming data in Power Query
Importing Excel, text, and CSV files and combining files
Enabling/disabling load and report refresh
Resolving data import errors
Data modeling, relationship types, and troubleshooting relationship issues
Measures vs. calculated columns
Creating a date table with DAX
Creating additional and conditional columns
Using the ROUNDUP and SUMX functions
Creating quick measures and key measures tables
The DAX - CALCULATE function
Tables vs. matrix tables
Formatting visualizations and applying conditional formatting
Using column, line, and map charts
Gauge and card visualizations
Using slicers and filters and applying design elements
Creating a shared workspace in Power BI service
Building reports and dashboards
Pinning visualizations to the dashboard
Setting up scheduled refreshes

This course bundle includes:
10+ hours of video tutorials
110+ individual video lectures
Course and exercise files to help you follow along
Certificate of completion

Here's what our students are saying...

5 Stars "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
5 Stars "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
5 Stars "I would highly recommend. The course was informative and easy to follow." - Thomas
5 Stars "I like everything! Everything is clear and understandable. Perfect courses!" -Jovita
Who this course is for:
Advanced Excel users
Business Intelligence Analysts

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.