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.
Power BI Desktop is a business analytics service by Microsoft. It offers interactive visualizations and business intelligence capabilities with a simple interface, letting the end-users create reports and dashboards.
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.
The current article describes the process of creating a Sales Analysis with Power BI Desktop and data hosted in Oracle Autonomous Database.
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 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.
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.
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.
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.
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.
Microsoft Power BI is a data visualization and analytics tool which lets you create powerful visualizations with a graphical user interface. It can use a variety of data sources such as CSV, TSV, and other flat files, SQL databases, and even online sources through Rest APIs.
This article explains the usage of Rest API as a data source to import JSON data in Power BI from a remote location. Also, we’ll learn how to transform the imported JSON data into a tabular format. Finally, we’ll plot visualizations using the imported data.
Read MoreMicrosoft’s Power BI REST API no-code option is extremely helpful as it allows calling Power BI REST API without writing a single line of code. Of course, you can call it programmatically using any programming language. Still, testing if Power BI Rest APIs are accepting requests and returning the right data, it is convenient to use the no-code options first. This article will explain how to do that.
This article focuses on the step-by-step processes of installing and configuring the ODBC driver for MySQL. In particular, it will cover the following issues: