power bi reports Archives - {coding}Sight https://codingsight.com/tag/power-bi-reports/ Blog for SQL Server DBAs and Developers Tue, 16 May 2023 13:20:37 +0000 en-US hourly 1 https://wordpress.org/?v=6.5.2 https://codingsight.com/wp-content/uploads/2021/10/cropped-Soсial_-Fb_180х180-1-32x32.png power bi reports Archives - {coding}Sight https://codingsight.com/tag/power-bi-reports/ 32 32 How to Set up Drill Through in Power BI Report https://codingsight.com/working-with-power-bi-drill-through/ Thu, 01 Sep 2022 02:43:00 +0000 http://codingsight.com/?p=16588 The Power BI Drill-through feature allows us to dig deeper into the data and get detailed information about a particular data entity. This article will explore the Northwind database to create a simple report that includes the Power BI Drill-through functionality. The script and the detailed information on creating the Northwind database on your SQL …

The post How to Set up Drill Through in Power BI Report appeared first on {coding}Sight.

]]> Power BI Slicers: Tutorial with Examples [2022] https://codingsight.com/working-with-power-bi-slicer/ Mon, 08 Aug 2022 11:56:00 +0000 http://codingsight.com/?p=19265 Power BI is a data analytics and interpretation tool developed by Microsoft. With Power BI, you can create various types of static and interactive visualizations. In this article, you will see how to use the Power BI Slicer tool to add interactivity to your visualizations. With Power BI slicer, you can filter data presented on …

The post Power BI Slicers: Tutorial with Examples [2022] appeared first on {coding}Sight.

]]> How to Create Paginated Report in Power BI: Definitive Tutorial https://codingsight.com/power-bi-paginated-reports/ Fri, 10 Sep 2021 06:44:39 +0000 http://codingsight.com/?p=16929 In this article, you will see how to create paginated reports using the Power BI Report Builder tool from Microsoft. You will also see how you can create parameterized paginated reports that display filtered data based on some parameter values. Table of Contents At first, you need to download the Power BI Report Builder tool …

The post How to Create Paginated Report in Power BI: Definitive Tutorial appeared first on {coding}Sight.

]]> Learn to Use Time Intelligence in Power BI https://codingsight.com/data-visualization-with-power-bi-applying-time-intelligence-to-reports/ Fri, 04 Jun 2021 09:05:08 +0000 http://codingsight.com/?p=14328 Time intelligence is a smart way of analyzing time period-based data, such as sales according to dates, using built-in time intelligence functions of Power BI. It is one of the most convenient ways because it eliminates the need to spend time on developing specialized solutions for your team.   The current article will focus on …

The post Learn to Use Time Intelligence in Power BI appeared first on {coding}Sight.

]]> How to Connect an Oracle ADW with Power BI and Create Sales Dashboard https://codingsight.com/sales-analysis-with-power-bi-desktop-and-autonomous-database/ Fri, 07 May 2021 09:52:18 +0000 http://codingsight.com/?p=13582 Oracle Autonomous Data Warehouse (ADW) is a fully managed and high-performance solution, turned and optimized for Data Warehouse workload. It means you don’t need to take more effort and resources (DBA role) to manage the database and optimize the workload. Power BI Desktop is a business analytics service by Microsoft. It offers interactive visualizations and …

The post How to Connect an Oracle ADW with Power BI and Create Sales Dashboard appeared first on {coding}Sight.

]]> Power BI Date Table Template Tutorial https://codingsight.com/why-you-should-use-date-templates-in-power-bi/ Wed, 05 May 2021 08:24:11 +0000 http://codingsight.com/?p=13459 What is the right way of using Date Templates in Power BI reports and dashboards? This article will clarify the question and help to understand the usage of Date tables as templates. But before we dig deeper, let’s refresh the information we are already familiar with. The Date Template basics A Date table is one …

The post Power BI Date Table Template Tutorial appeared first on {coding}Sight.

]]> Power BI: How to Create Date Tables Using Dax Format Functions https://codingsight.com/how-and-when-to-use-multiple-date-tables-in-power-bi/ Tue, 27 Apr 2021 12:32:38 +0000 http://codingsight.com/?p=13040 To utilize the time intelligence built-in features and functions in Power BI reports, you can use multiple Date tables. This article is going to explore this case in-depth. The readers will get a conceptual understanding of professional life scenarios and the importance of using Date tables in Power BI solutions. Multiple Date tables are necessary …

The post Power BI: How to Create Date Tables Using Dax Format Functions appeared first on {coding}Sight.

]]> Create and Use Custom Date Hierarchies in Power BI https://codingsight.com/create-and-use-custom-date-hierarchies-in-power-bi/ Thu, 22 Apr 2021 12:51:42 +0000 http://codingsight.com/?p=12843 Why are custom hierarchies Date tables essential for analysis and reporting? Let’s explore this issue. The current article focuses on the essence of custom hierarchies and using them for viewing the data in a Power BI report. What Is a Hierarchy? A hierarchy is a method of arranging the report data into an organizational top-down …

The post Create and Use Custom Date Hierarchies in Power BI appeared first on {coding}Sight.

]]> Creating the Date Table in Power BI Desktop Using DAX Function https://codingsight.com/how-to-create-date-table-in-power-bi/ Wed, 21 Apr 2021 12:30:34 +0000 http://codingsight.com/?p=12823 The time intelligence functions for the data models or databases running behind a Power BI report are really helpful. To make the most use of them, we can create a Date table on the Power BI desktop. This article focuses on the steps required to perform this task. Also, it highlights the importance of having …

The post Creating the Date Table in Power BI Desktop Using DAX Function appeared first on {coding}Sight.

]]> Formatting Data in Power BI Desktop Visualizations https://codingsight.com/formatting-data-in-power-bi-desktop-visualizations/ Fri, 03 Jul 2020 12:15:58 +0000 https://codingsight.com/?p=9197 Microsoft’s Power BI is a data analytics tool that can be used for interactive data visualization, using data from various sources such as relational and NoSQL databases, flat files, web servers, etc. Power BI visualizations are easy to plot and come with a variety of formatting options. Power BI comes in two flavors: Power BI …

The post Formatting Data in Power BI Desktop Visualizations appeared first on {coding}Sight.

]]>