MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English | Duration: 70 lectures (6h 36m) | Size: 2.57 GB
Level up your Business Intelligence skills with this intermediate Power BI course from Microsoft Experts, Simon Sez IT!
What you'll learn:
How to Import and Transform Data in Power Query
Importing Excel, Text, and CSV files and combining files
How to enable/disable Load and Report Refresh
Resolving Data Import Errors
Data Modelling, Relationship Types, and Troubleshooting Relationship Issues
Measures vs Calculated Columns
Creating a Date Table with DAX
Creating Additional and Conditional Columns
How to use ROUNDUP and SUMX
Creating Quick Measures and a Key Measures Table
The CALCULATE Function in DAX
Tables vs Matrix Tables
Formatting Visualizations and applying Conditional Formatting
Using Column, Line, and Map Charts
Gauge and Card Visualizations
Using Slicers and Filter and applying Design Elements
Creating a Shared Workspace in Power BI Service
Creating Reports and Dashboards
Pinning Visualizations to the Dashboard
How to set up Scheduled Refreshes
Requirements
A basic understanding of Power BI and its interface is essential as this is an intermediate course
Power BI Desktop installed on your machine is required to take the practice exercises
A good knowledge of MS Excel is advised but not necessary
Description
**This course includes downloadable course instructor files to follow along.**
Power BI is a powerful Business Analytics service from Microsoft. It intends to provide interactive visualizations and business intelligence solutions. Power BI has a simple enough interface for users with limited technical skills to be able to create their own reports and dashboards.
This Power BI intermediate training course is designed to be a continuation of the Power BI Beginner course. It is then recommended to go through that course first to be familiar with the Power BI basics and interface, or you should already have a basic understanding of Power BI before taking this course.
We start off this course by going through the data files to be used and some Power BI Desktop settings to set you up for success in learning Power BI. The latter part of the course is a big exercise where you can have a lot of practice creating reports and dashboards.
This course includes course files to follow along with your instructor and uses the Power BI Desktop version.
In this course you will learn:
How to Import and Transform Data in Power Query
Importing Excel, Text, and CSV files and combining files
How to enable/disable Load and Report Refresh
Resolving Data Import Errors
Data Modelling, Relationship Types, and Troubleshooting Relationship Issues
Measures vs Calculated Columns
Creating a Date Table with DAX
Creating Additional and Conditional Columns
How to use ROUNDUP and SUMX
Creating Quick Measures and a Key Measures Table
The CALCULATE Function in DAX
Tables vs Matrix Tables
Formatting Visualizations and applying Conditional Formatting
Using Column, Line, and Map Charts
Gauge and Card Visualizations
Using Slicers and Filter and applying Design Elements
Creating a Shared Workspace in Power BI Service
Creating Reports and Dashboards
Pinning Visualizations to the Dashboard
How to set up Scheduled Refreshes
This course bundle includes:
6+ hours of video tutorials
68 individual video lectures
Course Instructor Files to follow along
Certificate of completion
Who this course is for
Advanced Excel users
Users with basic knowledge of Power BI Desktop
Business Intelligence Analysts
Homepage
https://www.udemy.com/course/power-bi-intermediate-course-beyond-the-basics/
Buy Premium From My Links To Get Resumable Support,Max Speed & Support Me
https://hot4share.com/d5qv8sqpv7h9/wo5fv.P.B.I.C.B.t.B.part1.rar.html
https://hot4share.com/cauw89w71uv6/wo5fv.P.B.I.C.B.t.B.part2.rar.html
https://uploadgig.com/file/download/1dc07cDf89fDfa29/wo5fv.P.B.I.C.B.t.B.part1.rar
https://uploadgig.com/file/download/7c0cac07f7F15Fcb/wo5fv.P.B.I.C.B.t.B.part2.rar
https://rapidgator.net/file/e0ed24d7954adbe055e7451605981d6e/wo5fv.P.B.I.C.B.t.B.part1.rar.html
https://rapidgator.net/file/a2f6cf19e74b2b19d6ea1b32eccb2298/wo5fv.P.B.I.C.B.t.B.part2.rar.html