Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Pluralsight

Data Modeling, Querying, and Reporting for Business Intelligence

via Pluralsight

Overview

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.

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.

Syllabus

  • Course Overview 1min
  • Data Modeling Concepts and Techniques for Business Intelligence 37mins
  • Building Effective Data Warehousing Solutions by Applying Dimensional Modeling Concepts 14mins
  • Optimizing Database Design by Using Normalization and Denormalization 11mins
  • Getting the Best from Both Worlds - Understanding the Concept of Data Lakehouse 27mins
  • Designing Impactful Reports for Business Intelligence 46mins
  • Data-driven Decision Making with Interactive Dashboards and Scorecards 10mins
  • Enhancing Business Intelligence Solutions with Descriptive Statistics and Advanced Data Exploration Techniques 16mins

Taught by

Nikola Ilic

Reviews

4.9 rating at Pluralsight based on 16 ratings

Start your review of Data Modeling, Querying, and Reporting for Business Intelligence

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.