Advanced Filtering Within Range of Dates

Welcome to Excel Jet Consult blog post. In this tutorial, we want to learn how to use the WHERE clause to filter between two dates. Let’s get started. In the caption below, we have the 2017 Data table fetched from our Transaction Records database We want to retrieve Product, Account Manager, Order Priority, Total Revenue from the Sales Data between […]

Continue reading

New Shape Map Visual in Power BI

Welcome to Excel Jet Consult blog post. In this tutorial, we want to see how to use the new Shape Map available in Power BI November 2019 update and onward. Let’s get started The Shape Map allows users to display relative comparisons of States, Provinces and Regions on a map using colors. The Show Map visual needs to be activated […]

Continue reading

Activating Decomposition Tree Visual & Artificial Intelligence Insights

Welcome to Excel Jet Consult. In this blog post, we will talk about how to activate Decomposition Tree visual and AI Capabilities in Power BI made available in November 2019 Power BI update onward. To activate Decomposition Tree visual and AI capabilities: In the File tab, select Options and settings. Further select Options In the Options dialogue box, under Global, […]

Continue reading

Enabling New Updated Ribbon

Welcome to Excel Jet Consult. In this blog post, we will talk about how to enable the new updated ribbon made available in November 2019 Power BI update. The new updated ribbon is typical of the ribbon tab in Excel In the caption below, we can see the old ribbon tab To enable the Updated Ribbon: In the File tab, […]

Continue reading

Decomposition Tree Visual, AI & New Formatting in Power BI

Welcome to Excel Jet Consult blog post. In this tutorial, we want to see how to use the new Decomposition Tree visualization that debuts in November 2019 Power BI update. Let’s get started Decomposition Tree allows user to visualize data across spectrum of dimensions. In a simpler term, the visual allows users to break down a group to see its […]

Continue reading

Comprehensive SQL Server 2017 Installation

Welcome to Excel Jet Consult blog post. In this tutorial, we will learn how to fully download and install Microsoft SQL Server 2017. Let’s get started. DOWNLOAD SQL SERVER 2017 To download SQL Server 2017, type in download Microsoft SQL Server on google search. Click on the first search result In the caption below, click on the Developer edition Download […]

Continue reading

VLOOKUP in Excel and Power Query PBI

Welcome to Excel Jet Consult. In this tutorial, we want to look at how to perform vertical lookup in Excel and Power Query PBI. Let’s get started VLOOKUP in Excel VLOOKUP function looks for a value in the leftmost column of a table, and then returns a value in the same row from a column specified. VLOOKUP Syntax                             =VLOOKUP(lookup_value, table_array, […]

Continue reading