Category: Blogs

A step by step process showing you how to create a heatmap in Power BI Photo by Clay Banks on Unsplash Heatmap is a type of visualization that is used to project the mass of data on a map for any given point. We can say it’s a specialized chart that uses colors to represent data values in a table. We’ll…

An Introduction to the Concept of Dataflow in Power BI Photo by Adeolu Eletu on Unsplash With the increase in data volume and challenges of wrangling data into well-formed, actionable information, we need to have ready-made data which we can populate into reports or dashboards. To make this possible, we need Power BI Dataflows. The Power BI Dataflow…

Data Analysis Expressions (DAX) is a formula expression language used in Power BI, and Power Pivot in Excel. DAX formulas include functions, operators, and values to perform advanced calculations and queries on data in related tables and columns in tabular data models. In DAX functions in PowerBI, we can create new data from existing data.…

MySQL is an open-source relational database management system. For you to add, access, and process data stored in a computer database, you need a database management system such as MySQL Server. Now, we need to understand what MySQL Functions are. A function is basically a stored program that you can pass parameters into and then…

Flask is a micro web framework written in Python. It is classified as a microframework because it does not require particular tools or libraries. It has no database abstraction layer, form validation, or any other components where pre-existing third-party libraries provide common functions. In this tutorial, we’ll show you how to write a basic python…

A class is a user-defined blueprint for creating Objects. When we create a new class, we also create a new object. We can also call class an object constructor for creating objects. An object can be defined as an instance of a class for which class acts as a blueprint for an object. For instance,…

In this tutorial, we’ll be looking at how we can replace data source in a report in Power BI. Replacing Data Source in a report is common when we decide to alter our data source or probably we want to connect to an online data or a database which is different from the local CSV…

Photo by Nubelson Fernandes on Unsplash Inheritance is referred to as the act of inheriting something or when it’s passed down to someone else. In this tutorial, we’ll be looking at what inheritance is in Python. That is, how we can use it and how it’s being created. Inheritance in Python is the ability of a class to acquire or…

Photo by AltumCode on Unsplash The range() method in Python is usually used to return a fixed set of numbers between a given start integer to the end of an integer. We can have numbers like 0, 1, 2, 3, and 4, which is very useful since the numbers can be used to index into collections such as strings. The…

In this tutorial, we’ll look at how to use Tableau dashboard parameter actions. We know Parameters as containers of values used to calculate and enter values not present in the original dataset which can be workbook variables like dates, a string of text, numbers, or calculated fields. We can use the Parameter Actions in Tableau Desktop version…