ssas-tabular

This is the code repository and issue tracker for Tabular Editor 2.X (free, open-source version). This repository is being maintained by Daniel Otykier.

Useful code for tabular modeling and automation.

DAX Functions with Power BI

A pythonic approach to query SSAS data models.

A tool for managing the processing of Analysis Services, Azure Analysis Services and Power BI Premium models.

Microsoft SQL Server deployment extensions for Azure DevOps Pipelines

A tool for customizing and dynamically generating a tabular model from an existing tabular model.

Duckdb extension for parsing the metadata and contents of the embedded data mode in PowerBI pbix files

A tool for dynamically generating aggregation tables for Analysis Services Tabular and Power BI XMLA R/W models.

Publish / Deploy a Tabular or Multidimensional Cube to SSAS or AAS

A code sample to demonstrate how to improve SSAS Tabular distinct count performance by an order of magnitude.

A .NET library enabling the obfuscation of VertiPaq Analyzer files.

SSAS Tabular Data warehouse for SQL Server Logins

Generate tabular processing DGML graph based on extended events XEL file

Create and deploy an efficient data warehouse using Microsoft SQL Server tools, optimizing loading processes with SSIS for ETL workflows. Extend functionality with SSAS, SSRS, and pivot tables for in-depth analysis, enhancing insights through Power BI visualization.

Enterprise ELT Framework using Airbyte, dbt, Prefect, and Power BI for seamless data extraction, transformation, and visualization. This project showcases a scalable pipeline integrating SQL Server, GCP, and tabular models in Power BI for real-time analytics and business intelligence. Ideal for data engineers and analysts seeking efficient ETL/ELT.

Creates gantt graph based on extended events for processing tabular cube

Tool for investigate running Power BI instances as Microsoft Analysis Servises Tabular

Develop and Deploy a Datawarehouse solution. Employed MS SQL Server Management Studio to build a data warehouse and increased data loading efficiency and Implemented MS SQL Integration Services (SSIS) to devise and execute ETL processes. BI II project, Building from the Data Warehouse a SSAS, SSRS, Analysis in pivot tables and Data Visualization

Tabular SSAS API