English | Size: 3.00 GB
Genre: eLearning
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
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 training course starts by going over some of the Power BI basics before launching into how to utilize Power BI to visually display data. This course is focused more on some of the intermediate skills in Power BI, however, we are sure to cover off the basics before we launch into the more complex areas of this amazing Business Intelligence tool.
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 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
nitro.download/view/641520F8B15AC7F/PowerBIIntermediateCourse-BeyondtheBasics.fc.part1.rar
nitro.download/view/EEDE51058765C5E/PowerBIIntermediateCourse-BeyondtheBasics.fc.part2.rar
nitro.download/view/97805357B2C9B68/PowerBIIntermediateCourse-BeyondtheBasics.fc.part3.rar
nitro.download/view/4B6651FA7B679DF/PowerBIIntermediateCourse-BeyondtheBasics.fc.part4.rar
nitro.download/view/A47042EB475D65E/PowerBIIntermediateCourse-BeyondtheBasics.fc.part5.rar
nitro.download/view/004ACB50B392FDB/PowerBIIntermediateCourse-BeyondtheBasics.fc.part6.rar
nitro.download/view/41A5EC10C7F5F9B/PowerBIIntermediateCourse-BeyondtheBasics.fc.part7.rar
nitro.download/view/9AF9394ABCFED98/PowerBIIntermediateCourse-BeyondtheBasics.fc.part8.rar
rapidgator.net/file/86692bf4d68d6a95d5d6fc7085d7bc07/PowerBIIntermediateCourse-BeyondtheBasics.fc.part1.rar.html
rapidgator.net/file/adf65ecbcd1d2df2f5fae18c7ea73c32/PowerBIIntermediateCourse-BeyondtheBasics.fc.part2.rar.html
rapidgator.net/file/be9153d23db7dc43b38b10b6f3009b14/PowerBIIntermediateCourse-BeyondtheBasics.fc.part3.rar.html
rapidgator.net/file/0d5feada20a005ec2008f0e2e98f0aa5/PowerBIIntermediateCourse-BeyondtheBasics.fc.part4.rar.html
rapidgator.net/file/a129b77299b4f12cab9b7912b76fbe8b/PowerBIIntermediateCourse-BeyondtheBasics.fc.part5.rar.html
rapidgator.net/file/c921a3d3152902dce16112c1390d0667/PowerBIIntermediateCourse-BeyondtheBasics.fc.part6.rar.html
rapidgator.net/file/1fc93909849f61b14fd482da841eb4bf/PowerBIIntermediateCourse-BeyondtheBasics.fc.part7.rar.html
rapidgator.net/file/a09d4ddb2c7789745df7c1329d756ca4/PowerBIIntermediateCourse-BeyondtheBasics.fc.part8.rar.html
If any links die or problem unrar, send request to
forms.gle/e557HbjJ5vatekDV9