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.
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.
Table of contents
- Identifying the Report Audience 6m
- Designing Analytical Reports 4m
- Choosing the Appropriate Visual Type 9m
- Designing for Accessibility 4m
- Demo: Designing Power BI Report for Accessibility 4m
- Demo: Displaying Detailed Data by Using the Drillthrough Feature 3m
- Demo: Going beyond with Tooltip Pages 6m
- Demo: Highlighting Values with Conditional Formatting 3m
- Demo: Enhancing User Experience with Bookmarks 4m
- Best Practices for Creating Impactful Business Intelligence Reports 4m
About the author
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'... more