Power BI Beginners to Intermediate Course: Beyond the Basics
With this intermediate Power BI course from Microsoft Experts, Simon Sez IT, you will learn how to build visually stunning visualizations.
What you’ll learn
Power BI Beginners to Intermediate Course: Beyond the Basics
- In Power Query, you may learn how to import and transform data.
- Using Excel, Text, and CSV files to import and combine data is possible.
- Loading and Report Refreshing can be enabled or disabled.
- Data Import Errors and How to Fix Them
- Data modeling, relationship types, and troubleshooting relationship issues are all covered in this course.
- Columns with Measures versus Columns with Calculations
- DAX is used to create a Date Table.
- Adding additional and conditional columns to a table
- How to make use of the ROUNDUP and SUMX functions
- Making Quick Measures and a Key Measures Table is a simple process.
- In DAX Tables, the CALCULATE function is used differently than in Matrix Tables.
- The use of Column, Line, and Map Charts to format visualizations and apply Conditional Formatting are examples of this.
- Visualizations of gauges and cards
- Slicers and filters, as well as the application of design elements
- In Power BI Service, you may create a shared workspace.
- Creating reports and dashboards is an important part of your job.
- Visualizations can be pinned to the dashboard.
- Scheduled Refreshes: How to Configure Them
Requirements
- Because this is an intermediate course, it is necessary to have a basic understanding of Power BI and its interface.
- It is necessary to have Power BI Desktop installed on your computer in order to participate in the practice exercises.
- A working familiarity with Microsoft Excel is recommended but not required.
- The Power BI Beginner course is highly recommended, but it is not required prior to taking this course.
Description
To assist you in following along with the course, downloadable course instructor files are included.
Microsoft’s Power BI is a robust Business Analytics service that is easy to use. Interactive visualizations and corporate intelligence solutions are among the services that the company wants to deliver.
This Power BI training course begins by going over some of the fundamentals of Power BI before moving on to demonstrate how to use Power BI to visually present data in a report. This course will focus on some of the intermediate skills in Power BI; however, we will make sure to cover the fundamentals of this fantastic Business Intelligence tool before moving on to the more sophisticated aspects of it.
We begin by going through the data files that will be used in this course, as well as some Power BI Desktop settings that will help you succeed in studying Power BI in the future. The second portion of the course is a large exercise in which you will have a lot of opportunity to practice developing reports and dashboards for various purposes.
You will be provided with course files so that you may follow along with your instructor, and you will be using the Power BI Desktop version.
You will learn the following skills during this course:
- Instructions on how to import and transform data with Microsoft Power Query.
- Importing Excel, Text, and CSV files, as well as merging multiple files.
- Using the Load and Report Refresh options, you can enable or disable them.
- Errors in the data import process are resolved.
- Data modeling, relationship types, and troubleshooting relationship issues are all covered in this course.
- Comparison of Measured Columns and Calculated Columns.
- Using DAX, we can create a Date Table.
- Adding Additional and Conditional Columns to a Table.
- How to make use of the ROUNDUP and SUMX functions.
- Making Quick Measures and a Key Measures Table are two important steps.
- In DAX, the CALCULATE function is used.
- Tables vs. Matrix Tables: Which Is Better?
Visualizations should be formatted, and conditional formatting should be used.
- Column, line, and map charts are all examples of graphs.
- Visualizations of the gauge and the card
- The application of Design Elements when using Slicers and Filters.
- Creating a Shared Workspace in Power BI Service is explained in detail.
- Reports and dashboards are being created.
- Pinning Visualizations to the Dashboard is a useful feature.
- How to set up Scheduled Refreshes in your browser.
Who this course is for:
- Excel users with advanced skills.
- Users who have a basic understanding of Power BI Desktop.
- Business Intelligence Analysts are professionals who specialize in business intelligence.
Power BI Beginners to Intermediate Course: Beyond the Basics
Business Intelligence Analyst – Power BI ,Tableau
Download Now
