Cloud Academy - Optimizing a Power BI Data Model

[ DevCourseWeb.com ] Cloud Academy - Optimizing a Power BI Data Model



If You Need More Stuff, kindly Visit and Support Us -->> https://DevCourseWeb.com







MP4 | Video: h264, 1920x1080 | Audio: AAC, 44.1 KHz, 2 Ch

Difficulty: Intermediate | Genre: eLearning | Language: English + srt | Duration: 9 Lectures (47m) | Size: 690.5 MB



Description

In Optimizing a Power BI Data Model we start by investigating the underlying structure and operation of Power BI's VertiPaq database engine. Armed with this knowledge, we investigate various strategies for optimizing performance. Not to give the game away, most of the strategies 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.



Learning Objectives

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



Intended Audience

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



If You Need More Stuff, kindly Visit and Support Us -->> https://CourseWikia.com



Get More Tutorials and Support Us -->> https://FreeCourseWeb.com



We upload these learning materials for the people from all over the world, who have the talent and motivation to sharpen their skills/ knowledge but do not have the financial support to afford the materials. If you like this content and if you are truly in a position that you can actually buy the materials, then Please, we repeat, Please, Support Authors. They Deserve it! Because always remember, without "Them", you and we won't be here having this conversation. Think about it! Peace...