All Things BI- Datum to Data

Recent Posts

• Create a histogram in Power BI – Method 1

  By Ansh on September 13, 2020 • ( 0 )

  

  Hello all, In this series of blog posts, we will look into 2 different ways to create a histogram (bins) in Power BI There is no out of the box visualization that currently exists for a histogram. In this post,… Read More ›

• Demystifying Date Dimension Part 4

  By Ansh on September 13, 2020 • ( 0 )

  

  Let us pick up where we left off. In part 3 we created a date table but in a very brute force method. Let us make this more dynamic in this series. If you followed me every step of the… Read More ›

• Demystifying Date Dimension Part 3

  By Ansh on September 13, 2020 • ( 0 )

  

  Hello All, Let us take a deep dive into another way of creating the Date Table. However, for the next few series of blog posts, we will focus on M Query and we will first work with static values and… Read More ›

• Power BI Date Dimension Demystified Part 2

  By Ansh on September 7, 2020 • ( 0 )

  

  Hello All, Let us continue with our journey of demystifying the Date Table. In my last post, we learned to use CALENDARAUTO() function. We will continue today with the second DAX function called Calendar(). We will also look at how… Read More ›

• Power BI Date Dimension Demystified Part 1

  By Ansh on August 24, 2020 • ( 0 )

  

  Hello All, Today let us take the first step towards demystifying Date Table journey. Date Dimension plays a very important role. Almost always there is a need to perform and derive time-based insights. Few ground rules must be adhered to when it… Read More ›

• Introduction

  By Ansh on June 21, 2020 • ( 0 )

  The big question: What exactly is Power BI? Short answer: A data visualization tool. Long answer: Though primarily it is a data visualization tool, Power BI is a very powerful self service BI tool. It is made up of multiple… Read More ›

• PowerShell – Adding a Dataset

  By Ansh on June 14, 2020 • ( 0 )

  

  PowerShell Scripts for creating and adding a dataset, columns and table.

• Custom Scripts – Power Shell

  By Ansh on June 14, 2020 • ( 0 )

  

  One of my close friend had this discussion with me about how to get list of workspaces with certain conditions and how to get those details using PowerShell script. So this following script was written to get conditional workspaces and… Read More ›

• Powershell Commands

  By Ansh on June 14, 2020 • ( 0 )

  

  Following modules are available MicrosoftPowerBIMgmt — is the highest  level within this you can have following 1.Admin 2.Capacities 3.Data 4.Profile 5.Reports 6.Workspaces To get staretd Install-Module -Name MicrosoftPowerBIMgmt and then run the installation command for individual modules as needed