Data Modeling, Querying, and Reporting for Business Intelligence

Focused View

Nikola Ilic

2:30:07

14 View

1. Course Overview

1. Course Overview.mp4

01:54

2. Data Modeling Concepts and Techniques for Business Intelligence

1. Introducing Different Data Structures.mp4

06:35

2. Understanding Key Characteristics of OLTP Sy.mp4

06:18

3. Understanding Key Concepts of OLAP Systems.mp4

05:18

4. Understanding Conceptual Data Model.mp4

06:42

5. Understanding Logical Data Model.mp4

04:07

6. Implementing Physical Data Model.mp4

08:39

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

1. Introduction to Dime.mp4

05:37

2. Understanding Star a.mp4

02:58

3. Demo - From OLTP to .mp4

06:21

4. Optimizing Database Design by Using Normalization and Denormalization

1. Implementing Normalization Concept.mp4

04:30

2. Understanding Denormalization.mp4

03:12

3. Demo - Denormalizing Data Using Power .mp4

04:10

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

1. Understanding the Modern Dat.mp4

07:20

2. Understanding Key Features o.mp4

04:01

3. Using Parquet and Delta File.mp4

10:39

4. Understanding Medallion Arch.mp4

05:05

06. Designing Impactful Reports for Business Intelligence

01. Identifying the Report Audience.mp4

06:22

02. Designing Analytical Reports.mp4

03:35

03. Choosing the Appropriate Visual Type.mp4

08:40

04. Designing for Accessibility.mp4

03:44

05. Demo - Designing Power BI Report for Accessibility.mp4

03:33

06. Demo - Displaying Detailed Data by Using the Drillth.mp4

03:28

07. Demo - Going beyond with Tooltip Pages.mp4

05:33

08. Demo - Highlighting Values with Conditional Formatti.mp4

02:45

09. Demo - Enhancing User Experience with Bookmarks.mp4

04:24

10. Best Practices for Creating Impactful Business Intel.mp4

04:20

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

1. Understanding Use Cases for Dashboard.mp4

03:25

2. Demo - Creating Dashboards and Scorec.mp4

06:52

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

Description

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.

What You'll Learn?

Building a data-driven environment is one of the greatest challenges for many organizations.

In this course, Data Modeling, Querying, and Reporting for Business Intelligence, you’ll gain the ability to design and maintain efficient and scalable business intelligence solutions.

First, you’ll explore various data modeling concepts and techniques to support effective business decisions.

Next, you’ll discover the main differences between transactional and analytical systems, and benefits of using dimensional modeling for analytical workloads. You’ll also understand the difference between the data warehouse and data lakehouse concepts.

Finally, you’ll learn how to create effective data-driven stories through interactive reports and dashboards, and how to enhance your business intelligence solutions by applying advanced data exploration concepts.

When you’re finished with this course, you’ll have the skills and knowledge of data modeling, querying and reporting for business intelligence, needed to support data-driven scenarios and effective business decision-making.

More details

User Reviews

Rating

average 0

Total votes0

Focused display

Business Intelligence

Nikola Ilic

Instructor's Courses

Nikola Ilic is an officially Business Intelligence Developer, focusing on Microsoft Data Platform technologies, especially Power BI - but “off the record” he is a data fanatic, interested in everything related to extracting meaningful information from the raw data. Nikola is self-proclaimed "Data-Mozart". As he lives in the wonderful city of Salzburg, Austria, which is well-known as the birthplace of W.A.Mozart, he was brave enough to use the composer's last name as part of his nickname. That's why Nikola's professional motto is: "Make Music from your Data!" Coming from the business environment, Nikola holds a Bachelor’s degree in both Communicology and Computer Science. He is regularly blogging on data-mozart.com and speaking at global data conferences. Nikola is also a Microsoft Data Platform MVP, Microsoft Certified Trainer, and a certified Data Analyst.

Pluralsight

View courses Pluralsight

Pluralsight, LLC is an American privately held online education company that offers a variety of video training courses for software developers, IT administrators, and creative professionals through its website. Founded in 2004 by Aaron Skonnard, Keith Brown, Fritz Onion, and Bill Williams, the company has its headquarters in Farmington, Utah. As of July 2018, it uses more than 1,400 subject-matter experts as authors, and offers more than 7,000 courses in its catalog. Since first moving its courses online in 2007, the company has expanded, developing a full enterprise platform, and adding skills assessment modules.