0

ecommerce/course.login

ecommerce/course.or, ecommerce/course.create_accountCreate an account in checkout page
Microsoft Products

Power BI

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

4.4
(165 ratings) 498 students



Enroll now


What you will 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 should take this training

Prerequisites

  • 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

Target audience

  • Advanced Excel users

About this training

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.

This course includes:

4+ hours of video tutorials

45 individual video lectures

Exercise files to practice what you learned

Certificate of completion

Course Language : EN
On-demand video
Full lifetime access to videos
Downloadable resources
Assignments
Certificate of Completion
Enroll now

Training options

Only Videos

$ 30

  • Full lifetime access to videos
  • Downloadable resources
  • Certificate of Completion
  • Hours of Individual Coaching

Blended

$ 450

  • Full lifetime access to videos
  • Downloadable resources
  • Certificate of Completion
  • 10 Hours of Individual Coaching
Save 10%

Blended

$ 840 $ 783

  • Full lifetime access to videos
  • Downloadable resources
  • Certificate of Completion
  • 20 Hours of Individual Coaching
Save 20%

Blended

$ 1290 $ 1032

  • Full lifetime access to videos
  • Downloadable resources
  • Certificate of Completion
  • 30 Hours of Individual Coaching

Course Content

1. Introduction
1. Welcome and Overview 02:52 mins
2. What is Power BI? 04:23 mins
3. Install Power BI Desktop 02:08 mins
4. A Tour of BI Desktop 06:55 mins
5. Explore Commonly Used Power BI Options 05:23 mins
2. Getting and Transforming Data
1. Import Files from a Folder into Power BI Desktop 12:30 mins
2. Get Data from Excel and Text Files 07:09 mins
3. Reference Queries to Create Additional Lookup Tables 06:36 mins
4. Merge Queries in Power Query 06:58 mins
5. Prevent Queries from Loading into Power BI Desktop 03:06 mins
Practise Exercise 00:38 mins
3. Data Modelling
1. Create Relationships Between tables 06:49 mins
2. Create a Dynamic List of Dates 08:53 mins
3. Create Additional Date Columns for Analysis 09:13 mins
4. Sort the Month and Weekday Names Correctly 02:47 mins
5. Mark the Table as a Date Table 01:04 mins
6. Hide Unnecessary Fields from Report View 05:00 mins
Practise Exercise 00:33 mins
4. Introduction to DAX Measures
1. Calculate the Total Revenue 06:40 mins
2. Count the Total Rows of a Table 01:57 mins
3. Use the CALCULATE Function 05:34 mins
4. Calculate the Total Revenue Last Year 03:38 mins
5. Difference Compared to Last Year 05:23 mins
Practise Exercise 00:36 mins
5. Adding Visualizations to your Report
1. Show Summary Information with Cards 06:49 mins
2. Columns Charts to Compare Values 07:33 mins
3. Map Visual to Plot Georgraphic Data 04:47 mins
4. Slicers to Filter your Reports 08:06 mins
5. KPI Card to Measure Performance Against a Goal 07:16 mins
6. Line Graps to Visualise Trend 06:00 mins
7. Show Detail with the Matrix 09:45 mins
8. Top N Lists with the Table Visualisation 07:49 mins
Practise Exercise 00:38 mins
6. Report Design
1. Adding Text Boxes and Shapes 09:56 mins
2. Use Themes 07:41 mins
3. Conditional Formatting 08:00 mins
Practise Exercise 00:34 mins
7. Editing Interactions and Filters
1. Edit the Interactions between your Visualisations 09:46 mins
2. The Filter Pane to Filter at Any Level 07:04 mins
3. Drill Through to More Detail 08:17 mins
Practise Exercise 00:35 mins
8. Power BI Service
1. Publish Your Report to the Power BI Service 06:30 mins
2. Different Ways to Share your Power BI Report 05:26 mins
Practise Exercise 00:49 mins
9. Closing
Wrap Up 01:08 mins

Request more information

Similar courses

Join our mail list for news