Category: Power BI

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 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!

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 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

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)” →

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” →

How To Learn Python Fast As A Beginner Today

Posted on by Annie D

Summary
In this video, I discuss the OpenAI API and how it has amplified what we can do with AI tools. I share my belief that anyone can learn Python quickly by following the steps in the video. I also highlight the benefits of on-demand learning and provide examples of using libraries like pandas and NumPy. No specific action is requested from the viewers, but the video aims to inspire and educate them on the possibilities of AI and Python.

00:00 Introduction
03:25 Utilizing Code and Learning Python
07:14 Working with Pandas
12:03 Data Manipulation with Pandas
14:20 NumPy and Matplotlib
19:48 Exploring More Python Features
24:03 Troubleshooting Continue reading “How To Learn Python Fast As A Beginner Today” →

Ditch the whiteboard! Use Microsoft Fabric task flows!

Posted on by Annie D

Tired of drawing out your flow on a whiteboard and it getting erased? Now you can use task flows within Microsoft Fabric to lay things out. Patrick gets you started!

Announcing the public preview of task flows in Microsoft Fabric
https://blog.fabric.microsoft.com/en-us/blog/announcing-the-public-preview-of-task-flows-in-microsoft-fabric?ft=All

Task flows in Microsoft Fabric (preview)
https://learn.microsoft.com/fabric/get-started/task-flow-overview

📢 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
— rel=”nofollow”>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/

#MicrosoftFabric #Taskflows #GuyInACube

Deliver your Power BI subscriptions to OneDrive or SharePoint!

Posted on by Annie D

We’ve had subscriptions in Power BI for a while but you were limited to just email. NOW you can deliver your subscriptions to OneDrive or SharePoint Online! Patrick shows you how!

Deliver report Subscriptions to OneDrive and SharePoint (Preview)
https://powerbi.microsoft.com/en-us/blog/deliver-report-subscriptions-to-onedrive-sharepoint-preview/

Send large report subscriptions to OneDrive SharePoint (Preview)
https://learn.microsoft.com/power-bi/paginated-reports/paginated-reports-onedrive-sharepoint

📢 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
— <a href="http://twitter.com/patrickdba" Continue reading “Deliver your Power BI subscriptions to OneDrive or SharePoint!” →

We’re back! Latest thoughts and updates on AI and Enterprise DNA

Posted on by Annie D

After a 6 month break, the podcast is back! There’s been a lot of reflecting and thinking that’s been happening over the last while and those thoughts are shared in detail in this latest episode of The Analytic Mind.

New content, new ideas, new guests. This is now TIW 2.0. The world is changing and so shall we!

***** Learning with Enterprise DNA *****
FREE Courses – https://bit.ly/45fu3tw
FREE Resources – https://bit.ly/455Hw6O
Enterprise DNA On-Demand – https://app.enterprisedna.co/app
Enterprise DNA Subscriptions – https://app.enterprisedna.co/pricing
Enterprise DNA Workouts – https://bit.ly/41F9weH

#EnterpriseDNA #PowerBI #PowerBIDesktop #PowerBITutorial #DAX Continue reading “We’re back! Latest thoughts and updates on AI and Enterprise DNA” →

Expert Tips for Managing OneLake Data Access in Microsoft Fabric

Posted on by Annie D

Learn how to control access to OneLake data the right way in Microsoft Fabric with these security tips. Keep your data safe and secure with these best practices!

OneLake data access roles – Public Preview Announcement
https://blog.fabric.microsoft.com/en-us/blog/9046?ft=All

OneLake security overview
https://learn.microsoft.com/fabric/onelake/security/get-started-security

Role-based access control (RBAC)
https://learn.microsoft.com/fabric/onelake/security/data-access-control-model

Microsoft Fabric security white paper
https://learn.microsoft.com/fabric/security/white-paper-landing-page

Aaron Merrill:
LinkedIn: https://www.linkedin.com/in/aajmerrill/

📢 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!
*******************

— Continue reading “Expert Tips for Managing OneLake Data Access in Microsoft Fabric” →