BI Kathi Kellenberger in BI Reporting Services Basics: Parameters Kathi Kellenberger continues her series on SSRS. In this article you learn how to use parameters that let your report... 02 August 2019 18 min read
BI Andy Brown in BI Cracking DAX – the EARLIER and RANKX Functions So far in this series, Andy Brown of Wise Owl Training has shed light on functions like CALCULATE, VALUES and... 31 July 2019 17 min read
BI Benjamin Weissman in BI PolyBase in SQL Server 2019 – The End of ETL? PolyBase has been around since 2016, but Microsoft is enhancing it in 2019 with the ability to connect to more... 23 July 2019 10 min read
T-SQL Programming Monica Rathbun in T-SQL Programming What are Columnstore Indexes? Microsoft continues to enhance the performance of SQL Server with new features. In this article, Monica Rathbun explains how to... 22 July 2019 15 min read
BI Kathi Kellenberger in BI Reporting Services Basics: Understanding Data Sources and Datasets Data sources and datasets are critical components of an SSRS report, but many people new to SSRS struggle to understand... 05 July 2019 10 min read
BI Kathi Kellenberger in BI Reporting Services Basics: Creating Your First Report In this article, Kathi Kellenberger demonstrates how to create a project and report using the SSRS Report Wizard. The wizard... 30 May 2019 13 min read
BI in BI Streamlining a Power BI Solution Power BI is an excellent tool for departments or small organisations getting started with their BI solution. Unless some time... 17 May 2019 11 min read
BI in BI The BI Journey: The Journey Begins Gogula Aryalingam continues telling the story of the BI solution created by a business analyst intern. In this article, after... 08 May 2019 12 min read
BI Andy Brown in BI Using the FILTER Function in DAX In the previous article of this series, Andy Brown of Wise Owl Training explained how to use the oh-so-important CALCULATE... 17 April 2019 13 min read
BI Dennes Torres in BI Power BI and The Matrix: A Challenge The Matrix is one of the many built-in visualizations found in Power BI. While the Matrix is easy to populate,... 15 April 2019 14 min read
BI in BI The BI Journey: The Expert’s Advice – Part 2 A BI project should return value to the company quickly, not only after months or even years of work. In... 15 April 2019 13 min read
BI Kathi Kellenberger in BI Reporting Services Basics: Overview and Installation SQL Server Reporting Services has changed quite a bit since it was introduced in 2004. Despite new analytic services like... 08 April 2019 16 min read
BI in BI The BI Journey: The Expert’s Advice – Part 1 Creating a quick dashboard with a few reports may be the beginning of a BI solution, but unless time is... 20 February 2019 14 min read
BI in BI The BI Journey: The Analyst Most organizations today understand the value of analysing their data. In some cases, they haven’t realized the value or are... 21 January 2019 15 min read
BI Andy Brown in BI Using the DAX Calculate and Values Functions In the first two articles in this series on creating DAX formulae, Andy Brown of Wise Owl Training showed how... 14 January 2019 20 min read
BI Andy Brown in BI Creating Measures Using DAX In the first article in this series, Andy Brown demonstrated how to create calculated columns in Power BI using the... 28 December 2018 22 min read
BI Eugene Meidinger in BI SSRS Reporting Basics: When is SSRS the Right Tool? SSRS has undergone a number of changes over the past few versions. It remains a very popular reporting tool in... 18 December 2018 11 min read
BI Robert Sheldon in BI Power BI Introduction: Visualizing SQL Server Audit Data — Part 9 SQL Server Audit is a powerful feature that can help you comply with regulations such as HIPAA and SOX, but... 29 November 2018 21 min read
BI Andy Brown in BI Creating Calculated Columns Using DAX In this article, Andy Brown shares his knowledge of how to create calculated columns in tables, using Power BI as... 02 November 2018 20 min read
BI Supriya Pande in BI Creating Machine Learning Applications using Azure Cognitive Services Azure contains a vast array of services that can be used for machine learning, text analysis, and more. In this... 26 September 2018 17 min read
