Data model dalam Power BI

Menengah
Analis Data
Power BI

Kesuksesan dalam Power BI dimulai dengan model data yang hebat. Dalam modul ini, Anda akan belajar bagaimana merancang model data yang intuitif, berkinerja tinggi, dan mudah dirawat. Anda akan belajar tentang menggunakan bahasa DAX untuk menciptakan ukuran. Langkah-langkah tersebut akan membantu Anda menciptakan berbagai solusi analitis. Selain itu, Anda akan mempelajari cara meningkatkan kinerja dengan tugas pengambilan data Power Query.

Jalur pembelajaran ini dapat membantu Anda mempersiapkan diri untuk sertifikasi Microsoft Certified: Data Analyst Associate.

Prasyarat

Tidak ada

Modul dalam jalur pembelajaran ini

The process of creating a complicated data model in Power BI is straightforward. If your data is coming in from more than one transactional system, before you know it, you can have dozens of tables that you have to work with. Building a great data model is about simplifying the disarray. A star schema is one way to simplify a data model, and you’ll learn about the terminology and implementation of them in this module. You will also learn about why choosing the correct data granularity is important for performance and usability of your Power BI reports. Finally, you’ll learn about improving performance with your Power BI data models.

Data Analysis Expressions (DAX) is a programming language that is used throughout Microsoft Power BI for creating calculated columns, measures, and custom tables. It is a collection of functions, operators, and constants that can be used in a formula, or expression, to calculate and return one or more values. You can use DAX to solve a number of calculations and data analysis problems, which can help you create new information from data that is already in your model.

Performance optimization, also known as performance tuning, involves making changes to the current state of the data model so that it runs more efficiently. Essentially, when your data model is optimized, it performs better.