Learn to Use Time Intelligence in Power BI

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 applying Time Intelligence in Power BI reports and dashboards. Additionally, it will share some professional tips.

CodingSight - Learn to Use Time Intelligence in Power BI
Read More

Sending Report Data to Excel and SQL Database using Multicast Transformation in SSIS Packages Part 2

This article is the second part of the material dedicated to SSIS Multicast Transformation used to send the report data to multiple destinations.

In the previous section, we set up the environment for doing that task – refer to it to refresh your knowledge and recall the examples. In this section, we are going to use that data to design the Multicast Transformation solution and test-run it.

So, get back to the previously created project. We are starting the next stage of our work.

CodingSight - Sending Report Data to Excel and SQL Database using Multicast Transformation in SSIS Packages
Read More

Multicast Transformation in SSIS: Simplify Export of Data to Excel and SQL Server Simultaneously (with Example)

In professional work scenarios, we often need to load data from one report to several destinations, such as Excel files and SQL databases. One of the ways to accomplish this is using an Multicast Transformation in SSIS which accepts the data input and splits it into several outputs, creating logical data copies. As a result, you get several result copies to apply them to different purposes.

The current article clarifies the steps of gathering information, identifying problems, and designing the solution initial phase. Note that the material is meant for users with some backgrounds. It is desirable to be familiar with the SQL Server work, T-SQL scripting, and dedicated tools. You may refer to the following articles for details:

CodingSight - Sending Report Data to Excel and SQL Database using Multicast Transformation in SSIS Packages
Read More

How to Create the Date Table in Power BI

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 such Date tables for authoring the Power business intelligence (BI) reports to work as the output of a fully functional data warehouse BI solution.

CodingSight - Date Table in Power BI
Read More

SQL Server Business Intelligence (BI) – Traditional Tools and Technologies

If Business Intelligence (BI) is in your focus, you need two things to be a success. They are the knowledge and tools. If you target the SQL Server BI, you can benefit from the tools and technologies offered by Microsoft for this case particularly.

The current article highlights these tools and technologies. We are going to explore how they work to design Microsoft-based BI solutions and clarify why it is so crucial to use the using proven tools for serving the BI needs of an organization.

Read More

SQL Server Business Intelligence (BI) – Basic Understanding

In this article, we are going to clarify the fundamentals of Business Intelligence (BI) concepts with their benefits from the data utilization point of view, and explore the SQL Server-focused Business Intelligence solutions by practical examples and illustrations.

Before we discuss the particular issues related to SQL Server, let’s define the basic ideas of Business Intelligence (BI).

Read More