Business Intelligence (BI) – Developing SQL Data Models

Business Intelligence (BI) – Developing SQL Data Models, available at $79.99, has an average rating of 4, with 53 lectures, based on 43 reviews, and has 360 subscribers.

You will learn about Design a multidimensional business intelligence (BI) semantic model Create a multidimensional database by using Microsoft SQL Server Analysis Services (SSAS) Design and implement dimensions in a cube Implement measures and measure groups in a cube Design a multidimensional business intelligence (BI) semantic model Design a tabular BI semantic model Develop queries using Multidimensional Expressions (MDX) and Data Analysis Expressions (DAX) Configure and maintain SQL Server Analysis Services (SSAS) This course is ideal for individuals who are Web Developers or Software Developers or Programmers or Anyone interested in Business Intelligence (BI) It is particularly useful for Web Developers or Software Developers or Programmers or Anyone interested in Business Intelligence (BI).

Enroll now: Business Intelligence (BI) – Developing SQL Data Models

Summary

Title: Business Intelligence (BI) – Developing SQL Data Models

Price: $79.99

Average Rating: 4

Number of Lectures: 53

Number of Published Lectures: 53

Number of Curriculum Items: 53

Number of Published Curriculum Objects: 53

Original Price: $199.99

Quality Status: approved

Status: Live

What You Will Learn

Design a multidimensional business intelligence (BI) semantic model
Create a multidimensional database by using Microsoft SQL Server Analysis Services (SSAS)
Design and implement dimensions in a cube
Implement measures and measure groups in a cube
Design a multidimensional business intelligence (BI) semantic model
Design a tabular BI semantic model
Develop queries using Multidimensional Expressions (MDX) and Data Analysis Expressions (DAX)
Configure and maintain SQL Server Analysis Services (SSAS)

Who Should Attend

Web Developers
Software Developers
Programmers
Anyone interested in Business Intelligence (BI)

Target Audiences

Web Developers
Software Developers
Programmers
Anyone interested in Business Intelligence (BI)

Note: This course will be regularly updated.

Dive into the dynamic world of Business Intelligence and elevate your decision-making prowess with our cutting-edge course designed to empower you with data modeling, visualization, and analytical techniques from the ground up. Perfectly suited for business intelligence developers, managers, architects, and administrators, this immersive learning experience will help you master the extensive Business Intelligence ecosystem in no time.

Discover the secrets of crafting sustainable and high-impact Business Intelligence datasets, reports, and dashboards that drive smart decisions. Connect to diverse data sources, shape and enhance raw data, and develop a sophisticated analytical data model, all while gaining a solid understanding of the foundations of business intelligence.

Embark on an exhilarating journey as we guide you through the ins and outs of Power Query for efficient data ingestion, cleansing, and shaping. Unleash the full potential of Business Intelligence DAX for creating a range of calculations from simple to complex. Elevate your data storytelling by incorporating interactive visualizations that captivate your audience and inspire data-driven insights.

As you progress, you’ll master the art of:

Designing multidimensional and tabular BI semantic models
Developing powerful queries using Multidimensional Expressions (MDX) and Data Analysis Expressions (DAX)
Configuring and maintaining SQL Server Analysis Services (SSAS)

Cap off your learning journey by gaining hands-on experience in crafting visually striking reports tailored to the needs of business decision-makers. Learn how to securely share these reports and foster effective collaboration among your team members.

Upon completing this course, you’ll be well-equipped to create compelling, insightful BI reports and dashboards using the latest features of Business Intelligence, setting you on the path to becoming an invaluable asset in today’s rapidly evolving business landscape. Don’t miss this opportunity to harness the power of data and transform your career – enroll now!

Course Curriculum

Chapter 1: Welcome

Lecture 1: Introduction

Chapter 2: Getting started with course

Lecture 1: Overview

Lecture 2: Introduction

Lecture 3: Microsoft SQL Server Analysis Services – Creating multidimensional databases – 1

Lecture 4: Microsoft SQL Server Analysis Services – Creating multidimensional databases – 2

Lecture 5: Microsoft SQL Server Analysis Services – Creating Dimensions and Hierarchies – 1

Lecture 6: Microsoft SQL Server Analysis Services – Creating Dimensions and Hierarchies – 2

Lecture 7: All attributes have a relationship to the key attribute – 1

Lecture 8: All attributes have a relationship to the key attribute – 2

Lecture 9: SQL Server Analysis Services – Implement measures and measure groups – 1

Lecture 10: SQL Server Analysis Services – Implement measures and measure groups – 2

Lecture 11: Design and implement aggregate functions – 1

Lecture 12: Design and implement aggregate functions – 2

Chapter 3: Designing a tabular BI semantic model

Lecture 1: Learn About Multidimensional or Tabular Models – 1

Lecture 2: Learn About Multidimensional or Tabular Models – 2

Lecture 3: Deploying a Tabular Model

Lecture 4: Processing a Tabular Model

Lecture 5: Learn About Tabular Model Storage

Lecture 6: Learn About Configuration

Lecture 7: Configuring Tabular Model Security – 1

Lecture 8: Configuring Tabular Model Security – 2

Chapter 4: Developing queries using MDX and DAX

Lecture 1: Multidimensional Expressions (MDX) – 1

Lecture 2: Multidimensional Expressions (MDX) – 2

Lecture 3: Learn About Calculated Members and Named Sets – 1

Lecture 4: Learn About Calculated Members and Named Sets – 2

Lecture 5: Learn About MDX Functions – 1

Lecture 6: Learn About MDX Functions – 2

Lecture 7: Define a SCOPE Statement – 1

Lecture 8: Define a SCOPE Statement – 2

Lecture 9: Implement custom MDX solutions

Lecture 10: Learn How to Use the EVALUATE and CALCULATE functions

Lecture 11: Learn About Calculated Measures and Columns

Lecture 12: Learn How to Perform data analysis by Using DAX

Chapter 5: Configure and maintain SQL Server Analysis Services (SSAS)

Lecture 1: SQL Server Analysis Services – 1

Lecture 2: SQL Server Analysis Services – 2

Lecture 3: Monitor and Optimize Performance – 1

Lecture 4: Monitor and Optimize Performance – 2

Lecture 5: Identify Bottlenecks in SSAS Queries

Lecture 6: Learn How to Configure Usability Limits – 1

Lecture 7: Learn How to Configure Usability Limits – 2

Lecture 8: Learn How to Configure Partition Processing – 1

Lecture 9: Learn How to Configure Partition Processing – 2

Lecture 10: Learn How to Configure Dimension Processing – 1

Lecture 11: Learn How to Configure Dimension Processing – 2

Lecture 12: Learn How to Create Key Performance Indicators (KPIs) – 1

Lecture 13: Learn How to Create Key Performance Indicators (KPIs) – 2

Lecture 14: Create KPIs in Multidimensional Models and Tabular Models

Lecture 15: Create Key Performance Indicators (KPIs) and Actions – 1

Lecture 16: Create Key Performance Indicators (KPIs) and Actions – 2

Lecture 17: Learn How to Create and Develop Translations – 1

Lecture 18: Learn How to Create and Develop Translations – 2

Chapter 6: Course Summary

Lecture 1: Summary

Lecture 2: Thank You

Instructors

Stephen Hamlin
Database Engineer and Teacher

Rating Distribution

1 stars: 1 votes
2 stars: 0 votes
3 stars: 3 votes
4 stars: 8 votes
5 stars: 31 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu