Cloud Academy - Optimizing a Power BI Data Model

Posted on 18 May 03:16 | by LeeAndro | 10 views
Cloud Academy - Optimizing a Power BI Data Model
MP4 | Video: h264, 1920x1080 | Audio: AAC, 44.1 KHz, 2 ChDifficulty: Intermediate | Genre: eLearning | Language: English + srt | Duration: 9 Lectures (47m) | Size: 690.5 MB

In Optimizing a Power BI Data Model we start by investigating the underlying structure and operation of Power BI's VertiPaq database ee.


Armed with this knowledge, we investigate various strats for optimizing performance. Not to give the game away, most of the strats involve reducing the size of the data model and loading pre-summarized data. We also look at tools within Power BI and Power Query Editor for analyzing report and query performance as well as internal error tracking and diagnosis.

Remove unnecessary rows and tailor data sets for report audiences
Change data types to improve storage and split columns into multiple columns to reduce the overall number of unique values
Remove redundant or duplicate data and replace columns with measures where possible
Use Performance Analyzer to highlight report bottlenecks
Create aggregations for imported and direct query data models
Configure and use Power BI's and Power Query's diagnostic tools

This course is intended for anyone who wants to improve the speed and responsiveness of their reports by improving the underlying data model.

We would highly recommend taking the Developing a Power BI Data Model and Using DAX to Build Measures in Power BI courses first, as they go into depth about how to implement several of the topics discussed in this course.







DOWNLOAD
uploadgig.com


rapidgator.net


nitro.download

Related News

Cloud Academy - Getting Data into Power BI from Different Sources Cloud Academy - Getting Data into Power BI from Different Sources
MP4 | Video: h264, 1920x1080 | Audio: AAC, 44.1 KHz, 2 ChDifficulty: Intermediate | Genre:...
Power BI Interview Questions and Answers Power BI Interview Questions and Answers
Power BI Interview Questions and Answers MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch...
Udemy   SQL and Power BI Data Analyst   MS SQL  SSRS  SSAS  Power BI Udemy SQL and Power BI Data Analyst MS SQL SSRS SSAS Power BI
Udemy SQL and Power BI Data Analyst MS SQL SSRS SSAS Power BI Language: English Files Type:mp4,...
Microsoft Excel Data Cleaning with Power  Query Microsoft Excel Data Cleaning with Power Query
Microsoft Excel: Data Cleaning with Power Query Last updated 09/2022 MP4 | Video: h264, 1280x720 |...

System Comment

Information

Error Users of Visitor are not allowed to comment this publication.

Facebook Comment

Member Area
Top News