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
Amazing New Zebra BI Charts and Tables in Power BI
Welcome to Excel Jet Consult blog post. In this video, I talked about how to use the new Zebra BI Charts and Tables made available in Microsoft Power BI December 2019 updates courtesy of Andrej Lapajne and his team!
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
Conventional Subtotalling in Excel and VBA
Welcome to Excel Jet Consult blog post. In this tutorial, we will learn how to perform subtotal and the alternative way to perform the same operation using VBA. Let’s get started SUBTOTAL IN CONVENTIONAL EXCEL METHOD In the caption below, we have our dataset in Subtotal sheet tab We want to calculate the Net Salary for each of the Department […]
Continue reading
Using GIF and Logo Backgrounds in Power BI
Welcome to Excel Jet Consult blog post. In this tutorial, we want to see how we can use GIF and logo in as Backgrounds Using GIF and logo as backgrounds is up to every Power BI users. Depending on wat you are working on, you might want to insert logo and GIF backgrounds to our reports. In the captions below, […]
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