Power BI Archives - {coding}Sight https://codingsight.com/category/business-intelligence/power-bi/ 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 Archives - {coding}Sight https://codingsight.com/category/business-intelligence/power-bi/ 32 32 Power BI Star Schema: The Easy How-To Guide for Starters https://codingsight.com/power-bi-star-schema-the-easy-how-to-guide-for-starters/ Thu, 03 Nov 2022 10:10:26 +0000 http://codingsight.com/?p=20127 Do you want data analysis to be your cup of tea? That’s great because 2021 is a good year for that. If you’re starting out, part of data analysis is modeling your data. And you can model your data using a mature approach called a star schema. It’s also beginner-friendly. So today, you’ll learn how …

The post Power BI Star Schema: The Easy How-To Guide for Starters appeared first on {coding}Sight.

]]> 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.

]]> Centralized Data Modeling Using Power BI Templates https://codingsight.com/centralized-data-modeling-using-power-bi-templates/ https://codingsight.com/centralized-data-modeling-using-power-bi-templates/#comments Thu, 06 May 2021 09:36:49 +0000 http://codingsight.com/?p=13349 The centralized data modeling approach is really helpful in many practical scenarios. This article focuses on achieving it using Power BI Templates and sharing the centralized Power BI data model across the organization. In addition, we are going to highlight the importance of maintaining common reporting tables in a central location for better management. In …

The post Centralized Data Modeling Using Power BI Templates appeared first on {coding}Sight.

]]> https://codingsight.com/centralized-data-modeling-using-power-bi-templates/feed/ 1 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.

]]> 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.

]]>