Data Modeling, Querying, and Reporting for Business Intelligence

سرفصل های دوره

Building a data-driven environment is one of the key pillars of effective business decision-making. This course will teach you how to design and maintain efficient and scalable business intelligence solutions.

1. Course Overview

1. Course Overview

2. Data Modeling Concepts and Techniques for Business Intelligence

1. Introducing Different Data Structures

2. Understanding Key Characteristics of OLTP Sy

3. Understanding Key Concepts of OLAP Systems

4. Understanding Conceptual Data Model

5. Understanding Logical Data Model

6. Implementing Physical Data Model

3. Building Effective Data Warehousing Solutions by Applying Dimensional Modeling Concepts

1. Introduction to Dime

2. Understanding Star a

3. Demo - From OLTP to

4. Optimizing Database Design by Using Normalization and Denormalization

1. Implementing Normalization Concept

2. Understanding Denormalization

3. Demo - Denormalizing Data Using Power

5. Getting the Best from Both Worlds - Understanding the Concept of Data Lakehouse

1. Understanding the Modern Dat

2. Understanding Key Features o

3. Using Parquet and Delta File

4. Understanding Medallion Arch

06. Designing Impactful Reports for Business Intelligence

01. Identifying the Report Audience

02. Designing Analytical Reports

03. Choosing the Appropriate Visual Type

04. Designing for Accessibility

05. Demo - Designing Power BI Report for Accessibility

06. Demo - Displaying Detailed Data by Using the Drillth

07. Demo - Going beyond with Tooltip Pages

08. Demo - Highlighting Values with Conditional Formatti

09. Demo - Enhancing User Experience with Bookmarks

10. Best Practices for Creating Impactful Business Intel

7. Data-driven Decision Making with Interactive Dashboards and Scorecards

1. Understanding Use Cases for Dashboard

2. Demo - Creating Dashboards and Scorec

8. Enhancing Business Intelligence Solutions with Descriptive Statistics and Advanced Data Exploration Techniques

235,000 تومان

افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: PluralSight