Category: Power BI

How To Explore Datasets In Pandas With ProfileReport()

Posted on by Annie D

One of the most common questions you’ll encounter as a data analyst is how is the best way to explore a given data set. This is an important consideration primarily if you wan to put all the data together in a report that’s going to be easy to interpret by yourself or your team. In this tutorial, George is going to demonstrate how you can efficiently explore a dataset in Pandas using ProfileReport().

***** Video Details *****
00:00 Introduction
04:03 Overview of data set
04:33 Variables
06:06 Interactions
06:37 Correlations
07:17 Missing values
08:48 Sample
09:12 Example
10:50 Recap

***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Continue reading “How To Explore Datasets In Pandas With ProfileReport()” →

Answering your datamart questions

Posted on by Annie D

You’ve got a LOT of questions about datamarts in Power BI! Adam answers a few that we’ve seen popping up. Giving his thoughts on these questions.

Introduction to datamarts
https://docs.microsoft.com/power-bi/transform-model/datamarts/datamarts-overview

Comparing dataflows to datamarts
https://docs.microsoft.com/power-bi/transform-model/datamarts/datamarts-overview#comparing-dataflows-to-datamarts

When to use dataflows
https://docs.microsoft.com/power-bi/transform-model/dataflows/dataflows-introduction-self-service#when-to-use-dataflows

📢 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
— <a href="https://www.instagram.com/guyinacube/" Continue reading “Answering your datamart questions” →

Leveraging the Power of Business Intelligence with Pascal Kiefer

Posted on by Annie D

There’s no question that it is important for companies to understand their data. The challenge most businesses face, however, is that they lack the time and manpower to gather, analyze, and report all of their relevant data. Moreover, big data has made it even more difficult for business owners to make decisions based on information spread out across multiple systems. How can businesses find solutions that will allow them to slice and dice data in many ways so that they can understand how different areas of the business perform?

Pascal Kiefer is a Business Intelligence enthusiast and the founder of K Continue reading “Leveraging the Power of Business Intelligence with Pascal Kiefer” →

Power BI dataflows vs datamarts: What’s the difference???

Posted on by Annie D

Are you excited about datamart in Power BI? What about dataflows? Should you even use dataflows anymore? Do we just datamart all the things? Let’s have a look!

Introduction to datamarts
https://docs.microsoft.com/power-bi/transform-model/datamarts/datamarts-overview

Comparing dataflows to datamarts
https://docs.microsoft.com/power-bi/transform-model/datamarts/datamarts-overview#comparing-dataflows-to-datamarts

When to use dataflows
https://docs.microsoft.com/power-bi/transform-model/dataflows/dataflows-introduction-self-service#when-to-use-dataflows

Dataflows with benefits
https://ssbipolar.com/2022/05/25/dataflows-with-benefits/

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

#PowerBI #datamart #GuyInACube

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

Enterprise DNA Challenge 7 Remake – Judging Of Entries

Posted on by Annie D

After Data Challenge 19, our data challenge community had grown up to 750+ members within 45 days. 52 posts had been viewed over 30k times and commented 500 times. Moreover, we were pleased to accept 55 final entries with 200+ analysis pages and 150+ navigation buttons. However, everyone wants to enjoy more! So we launched a one-week data challenge to remake/redesign Challenge 7 “Purchase, Inventory and Sales” .

The report that needed to be redesigned, was created by Enterprise DNA Expert, Mudassir Ali, back in September 2020. Participants needed to rethink, reimagine, reanalyze, and redesign the report. In this video, Federico, Brian and Mudassir, showcase the winning Continue reading “Enterprise DNA Challenge 7 Remake – Judging Of Entries” →

Practical Power Query Solutions Nested Structured Values (Part 1)

Posted on by Annie D

RESOURCE DOWNLOAD – https://portal.enterprisedna.co/p/webinar-series-resources-free/

When is it?
June 2nd – 12pm Los Angeles (PDT), 3pm New York (EDT), 8pm London (BST)
June 3rd – 5am Sydney (AEST), 7am Auckland (NZST)

How long is it?
Session will run for approximately 1 hour

Where is it?
Join in from your laptop, desktop or connected device

Who’s doing it?
Presented by Melissa de Korte, Enterprise DNA Expert – Driving an analytical movement through using Power BI!

During This Free Training, You Will Learn:

• Explore structured columns containing Lists, Records or Tables
• Retrieve only certain parts from nested Lists, Records or Tables
• Deal with mixed columns or lists inside records, or Continue reading “Practical Power Query Solutions Nested Structured Values (Part 1)” →

Writing your first SQL Statement!

Posted on by Annie D

New to writing T-SQL? Patrick walks you through your first SQL statement. Great foundation to have when working with SQL Server or Azure Synapse Analytics!

Download SQL Server Management Studio
https://docs.microsoft.com/sql/ssms/download-sql-server-management-studio-ssms

Download and install Azure Data Studio
https://docs.microsoft.com/sql/azure-data-studio/download-azure-data-studio

Transact-SQL Reference (Database Engine)
https://docs.microsoft.com/sql/t-sql/language-reference?view=sql-server-ver16

Learn how you can become an Azure Synapse Influencer: http://aka.ms/synapseinfluencers

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

— rel=”nofollow”>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 – https://guyinacube.com/tools/

#PowerBI #GuyInACube

[Breakout Session 4] Member Case Studies | Reporting & Data Visualization Summit

Posted on by Annie D

EVENT DETAILS – https://enterprisedna.co/reporting-and-data-visualization-summit-may-2022-registration/

RESOURCE DOWNLOAD – https://portal.enterprisedna.co/p/reporting-and-data-visualization-summit/

[Breakout Session 4] Member Case Studies (Member-Only)

When is it?
May 24th – 12pm Los Angeles (PDT), 3pm New York (EDT), 8pm London (BST)
May 25th – 5am Sydney (AEST), 7am Auckland (NZST)

Where is it?
Join in from your laptop, desktop or connected device

Who’s doing it?
Presented by Brian Julius – Chief Content Officer, Enterprise DNA

If you have questions regarding this training, please send it to http://forum.enterprisedna.co/

#PowerBI #DataVisualization #eDNASummitMay2022 #EnterpriseDNAEvents

How To Use Power Automate To Create Adaptive Cards In Microsoft Teams

Posted on by Annie D

Adaptive cards are a great way to create shortcuts within Teams, and ask for more input. They are usually the bridge between a Teams message and an underlying Power Automate workflow. In this video, Henry shows how to use Adaptive Cards to create “add task” shortcuts within Teams. Once you have the basics down, you can use Adaptive Cards for anything! 

***** Video Details *****
00:00 Introduction
00:33 What is an Adaptive Card
01:12 Test card
02:55 New flow
03:38 Creating an Adaptive Card
05:11 Adding a task
06:57 Test run

***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Power BI – rel=”nofollow”>http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-power-bi
FREE COURSE – Ultimate Beginners Guide To DAX – http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-dax
FREE – Power BI Resources – http://enterprisedna.co/power-bi-resources
FREE – 60 Page DAX Reference Guide Download – https://enterprisedna.co/dax-formula-reference-guide-download/
Enterprise DNA Membership – https://enterprisedna.co/membership
Enterprise DNA Online – http://portal.enterprisedna.co/
Enterprise DNA Events – https://enterprisedna.co/enterprise-dna-events-page/

#EnterpriseDNA #PowerAutomate #PowerAutomateTutorial #AdaptiveCards #MicrosoftTeams #PowerBI #PowerBIDesktop #PowerBITutorial

REPLAY Power BI tips from the Pros – LIVE (Mar 19, 2022)

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 (Mar 19, 2022)” →

[Breakout Session 9] Build Your Power BI Portfolio | Reporting & Data Visualization Summit

Posted on by Annie D

EVENT DETAILS – https://enterprisedna.co/reporting-and-data-visualization-summit-may-2022-registration/

RESOURCE DOWNLOAD – https://portal.enterprisedna.co/p/reporting-and-data-visualization-summit/

[Breakout Session 9] Build Your Power BI Portfolio (Member-Only)

When is it?
May 26th – 6pm Los Angeles (PDT), 9pm New York (EDT)
May 27th – 2am London (BST), 11am Sydney (AEST), 1pm Auckland (NZST)

Where is it?
Join in from your laptop, desktop or connected device

Who’s doing it?
Presented by Ahmed Khodir – Founder of novyPro

If you have questions regarding this training, please send it to http://forum.enterprisedna.co/

#PowerBI #DataVisualization #eDNASummitMay2022 #EnterpriseDNAEvents