BI Adam Aspin in BI DAX table functions for paginated reports: Part 1 Several DAX table functions can be used for paginated reports when you want all the data, not a summary. Adam... 21 January 2022 15 min read
BI Edward Pollack in BI Vertipaq optimization and its impact on columnstore compression Vertipaq optimization is a critical component of the columnstore compression process. Edward Pollack explains how it works and what you... 19 January 2022 21 min read
BI Adam Aspin in BI How to filter DAX for paginated reports DAX is unlike SQL when filtering. In this article, Adam Aspin demonstrates how to filter DAX for paginated reports.… 17 December 2021 13 min read
BI Adam Aspin in BI Introduction to DAX for paginated reports SSRS reports can be built using DAX. In this article, Adam Aspin explains how to get started using DAX to... 15 November 2021 18 min read
BI Sanil Mhatre in BI Text Mining and Sentiment Analysis: Data Visualization in Tableau Tableau is a popular visualization tool used by organizations around the world. In this article Sanil Mhatre demonstrates sentiment analysis... 18 October 2021 19 min read
BI Sanil Mhatre in BI Text Mining and Sentiment Analysis: Oracle Text Oracle has built-in functionality to analyze text. Sanil Mhatre demonstrates how to perform a sentiment analysis on data stored in... 30 August 2021 12 min read
BI Dennes Torres in BI Embed Power BI in Jupyter Notebooks Power BI and Jupyter Notebooks are popular tools, but you may have never thought about using them together. Dennes Torres... 14 June 2021 12 min read
BI Adam Aspin in BI Introduction to generic Power BI themes Formatting Power BI visuals can be tedious. In this article, Adam Aspin explains custom Power BI themes that will save... 11 June 2021 17 min read
BI Bill Pearson in BI DAX financial functions: Depreciation calculations Business Intelligence Architect, Analysis Services Maestro, and author Bill Pearson continues his series surrounding the DAX financial functions. In this... 04 January 2021 35 min read
BI Bill Pearson in BI DAX financial functions: Loan calculations Business Intelligence Architect, Analysis Services Maestro, and author Bill Pearson kicks off a series to introduce the DAX financial functions.... 19 September 2020 27 min read
BI Rodney Landrum in BI Azure Data Factory pipelines: Filling in the gaps Azure Data Factory is a cloud based data orchestration tool that many ETL developers began using instead of SSIS. In... 18 September 2020 17 min read
BI Vince Iacoboni in BI Clarifying Data Warehouse Design with Historical Dimensions The standard data warehouse design from Kimball with facts and dimensions has been around for almost 25 years. In this... 04 August 2020 17 min read
BI Sanil Mhatre in BI Text Mining and Sentiment Analysis: Analysis with R In the third article of this series, Sanil Mhatre demonstrates how to perform a sentiment analysis using R including generating... 13 May 2020 19 min read
BI Imran Quadri Syed in BI Implementing a Data Quality Monitoring Framework For any Business Intelligence solution to be useful for analytical and decision-making purposes, it is imperative that the underlying data... 29 April 2020 26 min read
BI Sanil Mhatre in BI Text Mining and Sentiment Analysis: Power BI Visualizations Power BI is perfect for analyzing surveys. In this article, Sanil Mhatre demonstrates how to build several visualizations for key... 02 March 2020 15 min read
BI Andy Brown in BI Creating Time-Intelligence Functions in DAX DAX contains a host of time-intelligence functions with exotic names such as SAMEPERIODLASTYEAR and PARALLELPERIOD. In the last article in... 14 February 2020 19 min read
BI Sanil Mhatre in BI Text Mining and Sentiment Analysis: Introduction Microsoft provides a service to analyze text data called Text Analytics Cognitive Service. In this article, Sanil Mhatre demonstrates how... 03 February 2020 12 min read
BI Andy Brown in BI Using Calendars and Dates in Power BI You can use a host of time-intelligence functions in DAX to calculate everything from simple year-to-date totals to moving averages... 03 January 2020 17 min read
Editorials Kathi Kellenberger in Editorials SSRS is Still Around The other day, a friend asked me if Microsoft is discontinuing SQL Server Reporting Services (SSRS) now that Power BI... 20 November 2019 3 min read
BI Kathi Kellenberger in BI Reporting Services Basics: Adding Groups to Reports Most SSRS reports are organized into grouping levels where it’s possible to add totals for each group. In this article,... 01 October 2019 13 min read
