Blog

Bonbon's Guide To Data & Tech > Blog

Controlling cost with Azure Synapse Serverless Pools

Posted on by Annie D

Curious how to save cost when using Azure Synapse Serverless Pools? Any way to minimize the amount of data you are processing? Patrick shows you how and has a script for you!

Cost management for serverless SQL pool in Azure Synapse Analytics
https://learn.microsoft.com/azure/synapse-analytics/sql/data-processed

Azure Synapse Toolbox
https://github.com/microsoft/Azure_Synapse_Toolbox

Sample Query: https://pastebin.com/iRKagQHR

📢 Become a member: https://guyinacu.be/membership

*******************

Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.

🎓 Guy in a Cube courses: https://guyinacu.be/courses

*******************
LET’S CONNECT!
*******************

— http://twitter.com/guyinacube
— rel=”nofollow”>http://twitter.com/awsaxton
— http://twitter.com/patrickdba
— http://www.facebook.com/guyinacube
— https://www.instagram.com/guyinacube/
— https://guyinacube.com

***Gear***
🛠 Check out my Tools page – https://guyinacube.com/tools/

#AzureSynapse #Serverless #GuyInACube

How To Calculate Percent Profit Margins In Power BI [2023 Update]

Posted on by Annie D

Percent profit margins can be used in an organization to measure the profitability of its products or services. It is calculated by dividing the profit by revenue and multiplying by 100. This metric can help data analysts identify which products or services are more profitable and which ones need improvement.

By tracking changes in profit margins over time, analysts can also monitor the effectiveness of cost-cutting measures or pricing strategies. In this video, Sam will show how you can calculate percent profit margins in Power BI using DAX.

*****Video Details*****
00:00 Introduction
00:40 Data model
01:56 Total sales
02:20 Total costs using iterating function
03:14 Total Continue reading “How To Calculate Percent Profit Margins In Power BI [2023 Update]” →

Excel for Mac New AddIn Brings More Data To Power Query – 2598

Posted on by Annie D

Power Query for Mac Excel is missing From Table/Range.
Power Query for Mac Excel is missing From Folder.
Power Query for Mac Excel is missing From XML.
Power Query for Mac Excel is missing From JSON.

A new More Data add-in from Suat Ozgur at MrExcel adds all four of these functionalities to Excel for Mac! Download the add-in from this article: https://www.mrexcel.com/board/excel-articles/morequery-for-mac.68/

The FREE, open-source add-in adds From Table/Range to Power Query for Mac. It adds From Folder. It adds From XML. It adds from JSON.

Table of Contents:
(0:00) More Data Add-In fixes Power Query for Mac
(0:37) Get Data From Table/Range Continue reading “Excel for Mac New AddIn Brings More Data To Power Query – 2598” →

Find Your Top 3 Salespeople Per Region Automatically In Power BI Using DAX [2023 Update]

Posted on by Annie D

The CALCULATE and TOPN combination is a powerful technique in data analysis that allows users to easily and efficiently discover insights within large datasets. By utilizing this technique, analysts can automate the process of identifying patterns and trends in their data, which historically would have required extensive manual effort and time investment.

This technique is particularly useful for data analysts who need to identify key trends and patterns in large data sets quickly and efficiently, making it a valuable tool in business decision-making scenarios where time is of the essence. In this tutorial, Sam will demonstrate how you can apply Continue reading “Find Your Top 3 Salespeople Per Region Automatically In Power BI Using DAX [2023 Update]” →

Excel Technique Refer To Every Third Column From Bob Umlas 2583

Posted on by Annie D

Microsoft Excel Puzzle and Solutions.
Bob Umlas sent in the puzzle. How to refer to every 3rd column on Sheet2?

Table of Contents
(0:00) Bob Umlas Book
(0:22) Problem: Refer to every 3rd cell
(0:44) CHOOSECOLS with SEQUENCE
(1:16) Horizontal XLOOKUP
(1:46) Fill Handle from 3 Cells
(2:32) Delete Empty Cells
(2:54) R1C1 Method 2
(3:43) Replace = with x=
(4:12) Change R1C1 to A1
(4:21) Insert colums/rows to test

REPLAY Power BI tips from the Pros – LIVE (April 1, 2023)

Posted on by Annie D

Join us live as we answer your questions about Power BI!

💥 30 minutes: Open Q&A (Public)
💥 Then… Members Only Chat (Public can watch & Super Chat for Questions)

📢 RULES FOR Q&A: 📢

👉 Put a “Q:” in front of your comment to help us identify questions!
👉 Super chats take priority
👉 Do NOT re-post your questions! We’ll get to as many questions as we can.
👉 If you SPAM your question, you will be put in timeout

📢 Become a member: https://guyinacu.be/membership

*******************

Want to take your Power BI skills to the next level? We have training courses available to help you Continue reading “REPLAY Power BI tips from the Pros – LIVE (April 1, 2023)” →

Integrating Power BI With Power Platform – New Course!

Posted on by Annie D

Learning to integrate Power BI with Power Platform allows data analysts to leverage the combined power of multiple tools for more efficient and effective data analysis. By integrating Power BI with Power Automate and Power Apps, analysts can streamline their workflows, automate data processing, and create interactive visualizations, making it easier to gain insights and communicate findings.

We are ecstatic to officially launch our new course “Integrating Power BI with the Power Platform” developed by Tim Weinzapfel! In this video, join Komal and Tim as they give an insight on what you can expect from this new course, and how data Continue reading “Integrating Power BI With Power Platform – New Course!” →

Unlocking the Power of Data Architecture and Data Pipelines with Gilbert Quevauvilliers

Posted on by Annie D

Today’s episode features Gilbert Quevauvilliers, an expert in the field of Business Intelligence and Data Analytics. He has been in the industry since 2009 and has been an early adopter of Power BI, which he has been using for many years in his consulting and various engagements. His expertise spans across the data stack, from multidimensional cubes to the tabular model, and he has continuously kept himself up-to-date with the latest technologies.

Starting off in a large company in Durban, South Africa, he has decided to specialize in the Microsoft ecosystem and has built a wealth of knowledge and experience Continue reading “Unlocking the Power of Data Architecture and Data Pipelines with Gilbert Quevauvilliers” →

Excel Statistical Analysis for Business – Busn 210 – Spring 2023 Quarter Introductory Video

Posted on by Annie D

Busn 210, Excel Statistics for Business class taught by Excel MVP Mike Girvin at Highline College.
This is the intro video for matriculating students at Highline College in spring quarter, 2023.
To watch at YouTube here is the playlist: https://www.youtube.com/playlist?list=PLrRPvpgDmw0m3oqpp1XcPuaxyM4Bpi0dN

BI 348: Data Analysis with Microsoft Power Tools- Spring – 2023 Quarter Introductory Video

Posted on by Annie D

BI 348 is taught by Excel MVP Mike Girvin at Highline College. This is the intro video for matriculating students at Highline College in spring quarter, 2023. If you are not a matriculating student, watch class free at YouTube here is the playlist (videos #9-end): https://www.youtube.com/playlist?list=PLrRPvpgDmw0nre_bTeBfJWjrnixKoyNtW

🔴 Power BI tips from the Pros – LIVE (May 6, 2023) (Member Chat 2nd Half)

Posted on by Annie D

Join us live as we answer your questions about Power BI!

💥 30 minutes: Open Q&A (Public)
💥 Then… Members Only Chat (Public can watch & Super Chat for Questions)

📢 RULES FOR Q&A: 📢

👉 Put a “Q:” in front of your comment to help us identify questions!
👉 Super chats take priority
👉 Do NOT re-post your questions! We’ll get to as many questions as we can.
👉 If you SPAM your question, you will be put in timeout

📢 Become a member: https://guyinacu.be/membership

*******************

Want to take your Power BI skills to the next level? We have training courses available to help you Continue reading “🔴 Power BI tips from the Pros – LIVE (May 6, 2023) (Member Chat 2nd Half)” →

Using ALLEXCEPT To Stop Cumulative Total From Resetting [2023 Update]

Posted on by Annie D

The ALLEXCEPT function is a DAX formula in Power BI that allows you to remove filters from a table or column while keeping other filters on the same table or column. Cumulative totals are a common calculation in Power BI where a running total is displayed over time.

However, when a date selection is made, the cumulative total may reset to zero, and this is where the ALLEXCEPT function can be used to stop this from happening. By using the ALLEXCEPT function, you can ensure that your cumulative totals continue to show accurate data, even when a date selection is Continue reading “Using ALLEXCEPT To Stop Cumulative Total From Resetting [2023 Update]” →