Over the years Power BI has evolved into a complex and varied ecosystem of tools and solutions, which in its turn demands several supporting roles: there are, of course, developers, data engineers and data scientists, but there is need for one more, i.e. a capacity administrator.
2024-06-05
799 reads
In this article, we develop the Power BI DAX formula for basket analysis. It is the technique used in retail industry for market based analysis.
2024-05-10
1,929 reads
In this article, we discuss market-based analysis techniques for customer purchasing patterns for different products over the years in Power BI.
2024-04-19
2,711 reads
Learn about DAX functions to use in Power BI ADDCOLUMNS, CROSSJOIN, VALUES, SUMMARIZE, GENERATE, CALENDAR, FILTER, TOPN, UNION, and NATURALINNERJOIN.
2024-02-21
Microsoft Power BI Desktop provides users with multiple ways to help shape and transform their data. One of the options users have is scientific calculations, which support operations like cube, square, logarithms, etc. Power BI has this option in the Power Query Editor mode, where the user can easily apply one of these transformations for any number-based columns. In this tip, we will overview this utility in Power BI and how to benefit from it.
2024-02-14
Business Intelligence Architect, “Analysis Services Maestro, and author Bill Pearson introduces two somewhat similar DAX Time Intelligence functions related to “parallel” Date periods: PARALLELPERIOD() and SAMEPERIODLASTYEAR(). He discusses the syntax, uses and operation of each function, and then provides hands-on exposure to it in Power BI.
2026-04-15 (first published: 2024-01-24)
1,905 reads
Learn how to pivot and analyze data in Power BI like you can do in Excel for fast and easy data analysis.
2024-01-05
Learn about some of the overlooked but extremely useful features when building Power BI reports and dashboards.
2023-12-27
Learn about Power BI vs Tableau reporting comparison with SQL Server data to see the query differences when retrieving data.
2023-12-25
This article looks at ways to clean up text data used in Power BI reports and charts for a more meaningful and consistent message.
2023-10-27
In the previous post, we've built a SQL Server 2025 sandbox in an OrbStack...
By Steve Jones
Thanks to everyone for attending my talk today at Day of data Baton Rouge...
Here’s the scenario: one of my SQL Server instances migrated to the DR array....
Hub Cs: 08218154374 Jl. Gn. Sahari No.45, RT.7/RW.5, Gn. Sahari Utara, Kecamatan Sawah Besar,...
Hub Cs: 08218154374 Jl. Samanhudi No.8, RT.2/RW.8, Ps. Baru, Kecamatan Sawah Besar, Kota Jakarta...
WhatsApp: 08218154374 Jl. Jend. A. Yani No.47, Langkai, Kec. Pahandut, Kota Palangka Raya, Kalimantan...
Which of these is not true for certificates used for SQL Server connections?
See possible answers