Month: May 2023

12 Data Wrangling Functions In Python That You Should Know

Posted on by Annie D

Data wrangling in Python refers to the process of cleaning, transforming, and organizing raw data into a more structured format for analysis. It involves tasks such as data cleaning, data integration, handling missing values, data formatting, and feature engineering.

Data analysts can best utilize data wrangling in Python to ensure the data is reliable, consistent, and suitable for analysis. In this video, Gaelim shares 12 essential Data Wrangling functions in Python to be familiar with.

*****Video Details*****
00:00 Introduction
00:38 Dataset 1
00:42 Libraries to import
01:16 Dataset 2
01:35 Merging data set
02:13 Droping columns
02:44 Fill missing values
03:15 Replacing missing values
03:44 Replacing a specific value
04:25 Replacing Continue reading “12 Data Wrangling Functions In Python That You Should Know” →

Enabling Drillthrough with Power BI On-Object Editing

Posted on by Annie D

Using the new On-Object editing in Power BI Desktop? Have you figured out how to enable drillthrough yet? Adam has and is here to show you the clicks!

Power BI April 2023 Feature Summary
https://powerbi.microsoft.com/blog/power-bi-april-2023-feature-summary/

On-object Interaction
https://learn.microsoft.com/power-bi/create-reports/power-bi-on-object-interaction

📢 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/
— <a Continue reading “Enabling Drillthrough with Power BI On-Object Editing” →

Are you using your licenses correctly? See where Azure Hybrid Benefits can help!

Posted on by Annie D

If you are moving your on-premises SQL Servers to the cloud, and/or if you have a mix of Azure SQL, Managed Instance and on-prem, make sure you are licensing correctly with Azure Hybrid Benefits. Shashank shows us how!

Azure Hybrid Benefit
https://azure.microsoft.com/pricing/hybrid-benefit/

Azure Hybrid Benefit – Azure SQL Database & SQL Managed Instance
https://learn.microsoft.com/azure/azure-sql/azure-hybrid-benefit?view=azuresql&tabs=azure-portal

Azure Hybrid Benefit for Windows Server
https://learn.microsoft.com/windows-server/get-started/azure-hybrid-benefit

📢 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 “Are you using your licenses correctly? See where Azure Hybrid Benefits can help!” →

How To Install And Use Windows PowerShell Cmdlets For Power BI

Posted on by Annie D

Windows PowerShell Cmdlets are small, specialized commands used in the Windows PowerShell scripting environment. They serve as the main function of PowerShell, providing a way to automate administrative tasks and manage system components.

In Power BI, PowerShell Cmdlets can be immensely beneficial for automating various tasks, such as data refreshes, dataset creation, report publishing, and managing data gateways. By leveraging PowerShell Cmdlets, Power BI users can streamline their workflows, increase efficiency, and perform complex operations with ease, ultimately enhancing their overall Power BI experience. In this tutorial, Greg will demonstrate how you can install and utilize PowerShell Cmdlets for Continue reading “How To Install And Use Windows PowerShell Cmdlets For Power BI” →

Microsoft DP-500 Certification Pt. 1 – New Course!

Posted on by Annie D

The Microsoft DP-500 certification validates the knowledge and skills required for implementing and managing data solutions using Microsoft Azure technologies. It covers topics such as data storage, data processing, and data security in the cloud.

Getting certified with the DP-500 can boost your career prospects as it demonstrates to potential employers that you have the expertise to design and implement data solutions using Microsoft Azure. Moreover, as more and more organizations are adopting cloud technologies, having the DP-500 certification can give you a competitive edge in the job market.

We are glad to officially rollout our new course, “Microsoft DP-500 Certification”, Continue reading “Microsoft DP-500 Certification Pt. 1 – New Course!” →

🔴 Power BI tips from the Pros – LIVE (May 20, 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 20, 2023) (Member Chat 2nd Half)” →

🔴 Microsoft Build – May 2023 Social Hour

Posted on by Annie D

Join us live as we recap Power BI and Azure Data announcements made at Microsoft Build – May 2023. With special guest, Stephanie Bruno, Jason Himmelstein and John White!

Microsoft Build: https://powerbi.microsoft.com/en-us/blog/microsoft-digital-event-may-24-25/

Connect with Stephanie Bruno
https://twitter.com/StephTBruno
https://www.linkedin.com/in/brunostephanie/
https://data-witches.com

Connect with Jason and John:
Twitter: https://twitter.com/jasehimm
Twitter: https://twitter.com/diverdown1964
Twitter: https://twitter.com/BIFocalShow
Website: https://bifocal.show/

📢 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: Continue reading “🔴 Microsoft Build – May 2023 Social Hour” →

Excel Labs Creates A LAMBDA From Existing Worksheet Logic – Episode 2599

Posted on by Annie D

Microsoft Excel Tutorial – Easiest Way to Create a Lambda function in Excel.

A new version of the Advanced Formula Environment from Excel Labs has been released. It has an amazing new functionality called Import from Grid.

There are many times where I will build a complicated Excel formula in sub-formulas. I finally combine all the sub-formulas into one mega-formula by scooping the subformulas out of the formula bar and pasting in to the final formula.

The new Advanced Formula Envionment, found in the Excel Labs add-in, offers to create a LAMBDA function from existing worksheet logic in the grid.

Table of Contents
(0:00) Continue reading “Excel Labs Creates A LAMBDA From Existing Worksheet Logic – Episode 2599” →

REPLAY Power BI tips from the Pros – LIVE (April 8, 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 8, 2023)” →

Want a BEAUTIFUL Power BI Report? Start here!

Posted on by Annie D

If you are like us, creating beautiful Power BI reports doesn’t come easy. Mara Pereira joins us to show us where to start to get amazing and beautiful Power BI reports even with no designer background.

Dribbble
https://dribbble.com/

Freepik
https://www.freepik.com/

Figma
https://www.figma.com/

Adobe Color
https://color.adobe.com/create/color-wheel

Coolors
https://coolors.co/

Connect with Mara Pereira:
https://www.datapears.com/
https://www.youtube.com/@datapears
https://twitter.com/datapears
https://www.linkedin.com/in/marapereira/

📢 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 Continue reading “Want a BEAUTIFUL Power BI Report? Start here!” →

How To Create Detail Map Layers With Python Folium

Posted on by Annie D

Detail maps are used to visualize data by showing the geographic distribution of a particular attribute. They highlight patterns, trends, and relationships between variables, making it easy to identify areas with high or low values, clusters, and outliers. They are commonly used in fields such as demographics, geology, meteorology, and ecology to display data. In this video, Gaelim is going to show how to create detail map layers with Python Folium.

*****Video Details*****
00:00 Introduction
01:15 Installing Folium
01:47 Loading in the libraries
02:10 Creating a basic map
04:04 Adding a tile layer and location
04:24 Multiple layer controls
06:19 Using plugins
07:36 Adding your own data

***** Learning Power Continue reading “How To Create Detail Map Layers With Python Folium” →

Why is there a limited relationship when using the same data source?

Posted on by Annie D

Using Power BI Desktop and notice that you have some limited relationships in your model? Patrick discovered an interesting issue that threw him off at first. Learn how he solved it!

Model relationships in Power BI Desktop
https://learn.microsoft.com/power-bi/transform-model/desktop-relationships-understand

Regular and limited relationships in Power BI (SQLBI)
https://www.sqlbi.com/articles/strong-and-weak-relationships-in-power-bi/

📢 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
— Continue reading “Why is there a limited relationship when using the same data source?” →