PowerBI

Aveek Das
Power BI Data Model for Time Intelligence - Power BI Time Calculation

Overview of Power BI Time calculations

October 11, 2021 by

In this article, we are going to understand the various types of Power BI time calculations and how to implement these calculations. We will also understand the reason behind implementing such time-based calculations and the importance of these in the real world. The Power BI time calculations are also known as Time Intelligence functions that can be applied in DAX. There are a lot of functions available under Time Intelligence and you can read about it in detail from the official documentation from Microsoft.

Read more »
Aveek Das
Power BI Interview Questions

Popular Power BI Interview Questions

September 2, 2021 by

In this article, we are going to learn about the most popular Power BI Interview Questions being asked while applying for a Data Analyst role. Power BI is one of the most commonly used data visualization tools in the market. It is offered as a desktop tool using which you can author your reports and dashboards and then publish and share them with your users on the cloud. Power BI is also somewhat similar to Excel, so users who have prior experience with working in Excel can learn it quite easily.

Read more »
Aveek Das
Creating Power BI Visuals with Python Data Frame

Working with Python in Power BI

August 26, 2021 by

In this article, we are going to learn about working with Python in Power BI. Power BI has been adding a lot of features to it recently and one of the most essential was adding Python functionality to it. Users are now able to run Python scripts directly from within Power BI. Python is a great programming language, especially when it comes to the field of data analysis. Most of the machine learning frameworks and data science libraries are written in Python and there is a huge community of open-source programmers that maintain and promote the use of Python along with these libraries.

Read more »
Aveek Das
Create a Workspace in Power BI Service

Implementing Security in Power BI Workspaces using User Roles

August 19, 2021 by

In this article, we are going to learn about implementing and managing security in Power BI Workspaces. Power BI is one of the leading data visualization tools that is used by a plethora of companies around the globe. Power BI has risen to prominence in recent years due to the ease of use and familiarity of concepts with Microsoft Excel, which helped a lot of analysts tutor themselves and learn to work in Power BI. Power BI is now available in both, desktop and the cloud and users can choose to start with anyone. However, the desktop version of Power BI, known as the Power BI Desktop is used mainly for creating simple and complex data models within the Power BI environment and then published to the cloud, known as the Power BI Service.

Read more »
Aveek Das
Building the Power BI Report from scratch using the WideWorldImportersDW Database

Embedding Power BI reports in Jupyter notebooks

August 13, 2021 by

In this article, we are going to explore how to embed Power BI reports in Jupyter notebooks. Power BI is one of the most popular data visualization tools in the market that is being heavily used by Data Analysts to visualize existing data and to discover patterns lying in the data. Power BI provides a desktop application to author the reports and it can be deployed to the Power BI Service and consumed by users using a web browser.

Read more »
Aveek Das
A dataflow diagram in Power BI

An introduction to Power BI Dataflows

May 7, 2021 by

In this article, we are going to understand what the Power BI Dataflows is all about and how we can get started by building dataflows in Power BI Service. A dataflow can simply be considered as an extract transform and load pipeline that can be used to connect to source data, transform the data by applying business rules, and then finally preparing the data to be available to visualize. In a general data architecture, a dedicated ETL tool is used to prepare and transform the data, which is then loaded into a data warehouse. Power BI was used to connect to this data warehouse and visualize the data from here on.

Read more »
Rajendra Gupta

An overview of Power BI data models

April 12, 2021 by

Power BI is a business analytics solution provided by Microsoft. It helps you to create data visualizations from various data sources. We can import data from these data sources, create a data model, and prepares reports, visuals. These data sources are as below:

Read more »
Ben Richardson
Adjusted reports view with 'solar' theme applied

Working with Power BI report themes

February 25, 2021 by

Microsoft’s Power BI is a data analytics tool that can be used to plot rich reports and graphs for data analysis without writing a single line of code. Among myriads of other features, you can apply different types of Power BI report themes to change the outlook of your reports.

Read more »
Ben Richardson
A bar chart which is the output of applying the advanced filter

Power BI Visuals: Working with Filters

August 18, 2020 by

Power BI is a data analytics tool that can be used to analyze data with the help of Power BI visuals.

Power BI is a Microsoft application and is available as a desktop application as well as a cloud service. It comes with a variety of visual and filtering options that can be used to create Power BI visuals.

Read more »
Ben Richardson
Selecting the treemap visualisation to add on to our report.

Power BI Visuals: Working with Treemaps and Tables

August 6, 2020 by

In this article, you will learn how to work with Treemaps and Tables, which are two of the most commonly used Power BI visuals. You will also see how slicers can be used in Power BI to dynamically update the data in Treemaps and Tables. Power BI Visuals are extremely easy to create and don’t require you to write any code.

Read more »
Aveek Das
Power BI Report

Working with Power BI Data Models in Visual Studio Code

July 30, 2020 by

In this article, I am going to introduce the Tabular Object Model (TOM) in the Power BI Data Model and provide an understanding of how this model can be accessed outside of the Power BI environment. For more info about the Tabular Object Model in the Power BI Data Model, please read this article. In this tutorial, we are going to use the Visual Studio Code to simply write a dotnet console application and try to access the Tabular Object Model from the Power BI file. With the help of this knowledge, programmers and BI developers can not only view the underlying model in the Power BI Data Model but also can enhance the data model programmatically by writing a few lines of code. It can also be further improved by automating the creation of the Power BI models with the help of the Tabular Object Model library in dotnet.

Read more »
Aveek Das
Creating the report from the Data Model

Migrate Power BI reports between multiple workspaces

July 14, 2020 by

In this article, I am going to explain how we can create a Power BI Report using the Power BI Desktop and then publish it to the Power BI service workspace. Once the report is published to a workspace, we can also consider migrating the same report across several workspaces and all this can be done programmatically by using the Power BI REST APIs. This article is specially targeted towards Power BI admins or DevOps team whose task is to migrate dashboards between various environments like Development, QA, Production, etc. without any manual intervention of the reports.

Read more »
Aveek Das
Add users to Power BI

Add users to a Power BI workspace using PowerShell

July 6, 2020 by

In this article, I am going to explain how to add users to a Power BI workspace using Power BI PowerShell. As you already know, Power BI is a business intelligence tool from Microsoft, using which we can build graphical reports and dashboards which bring some sense to our data that resides on the database. Power BI also has a web interface known as the Power BI service, which can be used to share and collaborate these reports and dashboards with multiple users within or out of the organization.

Read more »
Aveek Das
Edit Parameters

Getting started with parameterized Power BI reports

June 16, 2020 by

In this article, I am going to explain how we can develop parameterized Power BI reports locally and then migrate the same report across multiple environments, like development, QA, and production. Parameterized Power BI reports are essential because we can use the same report to develop the charts and the KPIs and then provide the same report to the QA who will test it on a separate environment and finally when the testing is completed, it can then maybe provided to an administrator who can publish it to the production workspace.

Read more »
Aveek Das
Creating the Date Dimension in Power BI

Using a Date Dimension Table in Power BI

June 5, 2020 by

In this article, I am going to describe how to use a date dimension table in Power BI. Using a date dimension table becomes extremely important while visualizing facts and figures over some time in the calendar. Sometimes it is possible that we do not have the continuous date values in our dataset that we are trying to work upon.

Read more »
Aveek Das
Microsoft Power Platform - Virtual Agents

A quick overview of the Microsoft Power Platform

June 2, 2020 by

In this article, I am going to explain the various products offered by the Microsoft Power Platform. Microsoft Power Platform is a group of products offered by Microsoft to develop and build complex business solutions, analyze, and draw data visualizations, automate a business process, or build virtual agents for communication. All these products offer a platform in which no code is required to build the applications. These products are in the form of simple GUI which can be used by any business users or developers, thus helping to reduce the need for IT in the organization.

Read more »
Aveek Das
Power BI File Generated

Programmatic access to Power BI PowerShell commandlets

May 25, 2020 by

In this article, I am going to demonstrate how to access the Power BI PowerShell commandlets. In the previous article in this series, we discussed how to programmatically access the Power BI Service using the REST APIs available. PowerShell is one of the most frequently used and preferred ways of automating monotonous manual jobs and scripting those. PowerShell comes integrated with Windows, so it can be easily used from any Windows machine.

Read more »