Business intelligence Archives - {coding}Sight https://codingsight.com/category/business-intelligence/ 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 Business intelligence Archives - {coding}Sight https://codingsight.com/category/business-intelligence/ 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 use Oracle Advanced Analytics: Tutorial Guide https://codingsight.com/advanced-analytics-with-oracle-analytics-part-1/ Wed, 21 Sep 2022 07:50:00 +0000 http://codingsight.com/?p=14048 Advanced Analytics is a mandatory trend for Business Intelligence platforms and Self-service Analytics tools. It offers a set of statistic functions and algorithms, such as trending, forecast, etc. They help business users, analysts, and others specialists to deep dive into data insights for making better business decisions. The current article is the first part of …

The post How to use Oracle Advanced Analytics: Tutorial Guide 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.

]]> Using Data Flow to Build Sentiment Analysis in Oracle Analytics https://codingsight.com/build-sentiment-analysis-with-oracle-bi-analytics/ Wed, 31 Aug 2022 09:11:00 +0000 http://codingsight.com/?p=14202 This is the second part of the article dedicated to working with Data Flow in Oracle Analytics when the data is hosted in Oracle Autonomous Data Warehouse. The previous part focused on setting up the Data Flow and initial configurations. Now, we are going to deal with building the Sentiment Analysis, another common use case. …

The post Using Data Flow to Build Sentiment Analysis in Oracle Analytics appeared first on {coding}Sight.

]]> Learning Advanced Analytics Features with Oracle Analytics: Outliers and Clusters https://codingsight.com/advanced-analytics-with-oracle-analytics-part-2/ Thu, 25 Aug 2022 11:02:00 +0000 http://codingsight.com/?p=14090 This is the second part of the material dedicated to Oracle Analytics. In Part 1, we started our journey and learned to create Reference Line, Forecast Line with Sales data. It let us get some essential remarks about the products with outstanding performance or relations between Sales and Profit. In this part, we are going …

The post Learning Advanced Analytics Features with Oracle Analytics: Outliers and Clusters 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.

]]> Oracle Predictive Analytics: How to Predict of Employee Attrition https://codingsight.com/prediction-of-attrition-in-hr-with-oracle-analytics/ Fri, 29 Jul 2022 09:38:00 +0000 http://codingsight.com/?p=15755 From the Customer Segmentation tutorial, you already know that Oracle Analytics provides several Machine Learning (ML) algorithms to solve the Supervised Learning and Unsupervised Learning problems with low-code required. Prediction of Employee Attrition is one of such Supervised Learning problems. It is a popular use case that most organizations need to resolve to minimize the …

The post Oracle Predictive Analytics: How to Predict of Employee Attrition 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.

]]> Customer Segmentation with Data Flow in Oracle Analytics https://codingsight.com/customer-segmentation-with-data-flow-in-oracle-analytics/ Mon, 14 Jun 2021 14:48:39 +0000 http://codingsight.com/?p=14686 Customer Segmentation Analysis is a popular business issue, especially in Retail domain, where companies need to discover the data and group customers based on customer attributes, such demographics and customer transactions. The results of customer segmentation analysis let the retailers understand the customers’ behavior and create effective campaigns. This tutorial will describe the usage of …

The post Customer Segmentation with Data Flow in Oracle Analytics 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.

]]>