Blog

Bonbon's Guide To Data & Tech > Blog

Get started with the On-Premises Data Gateway in Microsoft Fabric

Posted on by Annie D

Trying to leverage on-premises data? Can’t connect to a cloud source because of firewalls or private networks? Learn how you can use the On-Premises Data Gateway with Microsoft Fabric to get the data you need!

What is an on-premises data gateway?
https://learn.microsoft.com/data-integration/gateway/service-gateway-onprem

On-premises data gateway architecture
https://learn.microsoft.com/data-integration/gateway/service-gateway-onprem-indepth

Install an on-premises data gateway
https://learn.microsoft.com/data-integration/gateway/service-gateway-install

📢 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
— <a Continue reading “Get started with the On-Premises Data Gateway in Microsoft Fabric” →

A look at the Microsoft Fabric Admin Portal

Posted on by Annie D

New to Microsoft Fabric Administration? Here is a look at the Admin Portal and how you can manage Microsoft Fabric along with what roles you need to be in.

What is the admin portal?
https://learn.microsoft.com/fabric/admin/admin-center

Understand Microsoft Fabric admin roles
https://learn.microsoft.com/fabric/admin/roles

Microsoft Fabric documentation for admins
https://learn.microsoft.com/fabric/admin/

Microsoft Fabric security
https://learn.microsoft.com/fabric/security/

📢 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
— <a href="http://twitter.com/awsaxton" Continue reading “A look at the Microsoft Fabric Admin Portal” →

Understanding Gateway Clusters in Microsoft Fabric

Posted on by Annie D

Concerned about high availability of your On-Premises Data Gateway within Microsoft Fabric? Gateway clusters are a way of ensuring you can process data for sources going through a gateway.

What is an on-premises data gateway?
https://learn.microsoft.com/data-integration/gateway/service-gateway-onprem

On-premises data gateway architecture
https://learn.microsoft.com/data-integration/gateway/service-gateway-onprem-indepth

Manage on-premises data gateway high-availability clusters and load balancing
https://learn.microsoft.com/data-integration/gateway/service-gateway-high-availability-clusters

Plan, scale, and maintain a business-critical gateway solution
https://learn.microsoft.com/en-us/data-integration/gateway/plan-scale-maintain

📢 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: <a href="https://guyinacu.be/courses" Continue reading “Understanding Gateway Clusters in Microsoft Fabric” →

Augmenting Power BI development with Advanced Data Analysis

Posted on by Annie D

In the video, I dive into the differences between ChatGPT and Advanced Data Analysis within ChatGPT, comparing them to Power BI. I highlight the potential benefits of using both tools despite challenges, showcasing how they can complement each other. I demonstrate creating a data set in ChatGPT, discuss the future of data analysis, and compare the analysis process in ChatGPT and Power BI.

00:00 Introduction
05:48 Data Exploration in ChatGPT
11:07 AI Tools Usage
14:22 Comparison Analysis in Power BI
18:11 Data Verification

Exploring DAX Query View in Power BI

Posted on by Annie D

Join me as I dive into the powerful features of the DAX query view in Power BI, showcasing how it revolutionizes data discovery and insights. Learn how to efficiently explore data sets and enhance your understanding using table functions.

Examples of tables functions you could use.

FILTER
TOPN
ADDCOLUMNS
CALCULATETABLE
VALUES
SUMMARIZE
and much more!

Why I’m placing a lot more focus on learning Python….and how I’m doing it

Posted on by Annie D

Get started with free Data & AI courses today – https://enterprisedna.co/register

Python is becoming more important to learn than ever. Almost all the exciting automations and AI agents workflows being developed right now are being done with Python.

That’s why it’s crucial to spend more time learning it. I’m doing exactly this and this is how I’m targeting my learning.

I’ll be doing a lot more of this going forward due to the important of Python particularly in the field of AI.

Follow on X – https://x.com/SamMcKayOG
Follow on LinkedIn – https://www.linkedin.com/in/sammckayenterprisedna/

Follow Enterprise DNA on X Continue reading “Why I’m placing a lot more focus on learning Python….and how I’m doing it” →

Exploring Autogen – a new wave of automation possibilities!

Posted on by Annie D

Autogen is a relatively new AI agent framework supported by Microsoft.

I’ve been diving deep into this lately and I show you some of my recent findings.

This is the future! I have no doubt about it.

It’s still early but I highlight the automation potential throughout the video.

I’m going to spend A LOT more time here in coming months. I think this is a massive new wave coming.

I highly recommend doing the same.

I’ll keep sharing what I’m learning

***** Related Links *****
https://microsoft.github.io/autogen/

***** Learning with Enterprise DNA *****
FREE Courses – https://bit.ly/45fu3tw
FREE Resources – rel=”nofollow”>https://bit.ly/455Hw6O
EDNA Learn – https://app.enterprisedna.co/app
Data Mentor – https://mentor.enterprisedna.co/
EDNA Chat – https://mentor.enterprisedna.co/chat
Enterprise DNA Subscriptions – https://app.enterprisedna.co/pricing

DAME 07: How to Make Effective Dashboard. Three Examples in Power BI

Posted on by Annie D

Download files: https://excelisfun.net/files/DAMEwithMPT07.zip
Free YouTube Data Analysis Class about Microsoft Power Tools in 2024 taught by Excel MVP and Highline College Professor, Mike “excelisfun” Girvin.
In this video learn about the guidelines for how to build effective dashboards. See three examples in Power BI.
Topics:
1. (00:00) Introduction
2. (00:27) Guidelines for how to build effective dashboards
3. (09:03) Files to build Three Dashboards.
4. (09:35) Dashboard #1: Average Daily & Monthly Metrics across various attributes
5. (19:33) Dashboard #2: Grade Analysis Dashboard
6. (26:42) Dashboard #3: YOY Sales Dashboard
7. (31:27) Summary
8. (31:40) Conclusion

#dashboard #powerbi #powerbidesktop #visualization

Install Power BI Desktop the RIGHT WAY! (2024)

Posted on by Annie D

Want to get started with Power BI but not sure how? Start by installing Power BI Desktop! Adam walks you through how to install it and some things to do immediately after!

📢 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
— 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 Continue reading “Install Power BI Desktop the RIGHT WAY! (2024)” →

Excel Slow Workbook Speeds Up Instantly With ForceFullCalculation Toggled Off – 2644

Posted on by Annie D

Microsoft Excel Tutorial: Make workbook calculate faster by toggling off the ForceFullCalculation setting.

Welcome back to MrExcel! Today, I’ve got an incredible tip that can make your Excel workbooks run dramatically faster. Have you ever heard of ActiveWorkbook.ForceFullCalculation = False? Probably not, because it’s a setting that’s rarely documented. But it can make a huge difference in calculation speed, as shown in this example sent by Matt from Chicago, a member of the MrExcel message board.

Matt provided us with a file containing 7,000 rows and 27 columns, which is just a fraction of the size of his client’s actual files. With Continue reading “Excel Slow Workbook Speeds Up Instantly With ForceFullCalculation Toggled Off – 2644” →

On-premises data with Data Factory in Microsoft Fabric

Posted on by Annie D

Do you have on-premises data like a SQL Server? Want to leverage a pipeline within Data Factory in Microsoft Fabric? Patrick shows you have to get going and set that up!

How to access on-premises data sources in Data Factory for Microsoft Fabric
https://learn.microsoft.com/fabric/data-factory/how-to-access-on-premises-data

📢 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
— http://twitter.com/awsaxton
— http://twitter.com/patrickdba
— http://www.facebook.com/guyinacube
— Continue reading “On-premises data with Data Factory in Microsoft Fabric” →