Month: June 2022

Power Platform: Real World Experience and Applications with Henry Habib

Posted on by Annie D

Technology-based on no code enables effective “citizen development,” where business users can rapidly develop apps and virtual agents without extensive IT assistance. In order to meet this business need, Microsoft’s Power Platform combines the strengths of Power BI, Power Apps, Power Automate, and Power Virtual Agents.

Sam McKay interviews Enterprise DNA expert Henry Habib in this episode of The Analytic Mind Podcast. He talks about his real-world experiences as a Power Platform Consultant and his passion for teaching people how to succeed with no-code platforms.

Henry Habib is currently an engagement manager at a leading management consulting firm, where he advises F500 Continue reading “Power Platform: Real World Experience and Applications with Henry Habib” →

How To Create 3D Scatter Plots In Power BI Using Python

Posted on by Annie D

3D scatter plots are mainly used to plot data points in three axes with the objective of showing the relationship between three variables. In this video, Gaelim is going to demonstrate how you can make a 3D scatter plot on Power BI using Python code.

***** Video Details *****
00:00 Introduction
00:44 Data set
01:03 Importing packages
02:06 Loading seaborn data set
02:45 Dimensions & metrics
03:05 Setting x, y, z variables
03:38 Creating a figure
05:44 Creating plots
08:00 Setting axes names
09:09 Interactivity
10:10 Altering viewpoint
11:10 Bringing into Power BI

***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Power BI – http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-power-bi
FREE COURSE Continue reading “How To Create 3D Scatter Plots In Power BI Using Python” →

Introduction to Microsoft 365 Excel & Conventions for Class – 365 MECS 01

Posted on by Annie D

Download Excel File: https://excelisfun.net/files/01-M365ExcelClass.xlsx Download PDF File: https://excelisfun.net/files/01-M365ExcelClass.pdf
Topics in video:
1. (00:00) Introduction
2. (00:14) Intro Song
3. (00:22) Download Files and Create Class Folder
4. (01:45) Change File Extensions in Windows Explorer
5. (02:30) Color Coding Conventions for Class
6. (04:46) Rows, Columns, Cells, Worksheets, Sheet Tabs, Workbooks
7. (06:17) Naming Convention for all objects in class
8. (07:38) Tabs in the Excel Ribbon
9. (08:26) Quick Access Toolbar = QAT. Build Custom QAT
10. (11:04) Navigating through Workbook
11. (12:26) Keyboards: Desktop or Laptop?
12. (13:36) Keyboard Shortcuts
13. (16:41) First Formula: SUM function using a keyboard
14. (18:27) Cursors
15. (18:37) Data & Alignment and how Continue reading “Introduction to Microsoft 365 Excel & Conventions for Class – 365 MECS 01” →

What’s up with the different JOINS in Azure SQL and Azure Synapse?

Posted on by Annie D

Not sure what the different JOINs mean in Azure Synapse Analytics and Azure SQL Database? Patrick walks you through the different types to get you on the right path!

Joins (SQL Server)
https://docs.microsoft.com/sql/relational-databases/performance/joins?view=sql-server-ver16

📢 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 Continue reading “What’s up with the different JOINS in Azure SQL and Azure Synapse?” →

Forecasting Analysis in Power BI

Posted on by Annie D

When is it?
June 28th – 6pm Los Angeles (PDT), 9pm New York (EDT)
June 29th – 2am London (BST), 11am Sydney (AEST), 1pm 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 Gaelim Holland, Enterprise DNA Expert – Driving an analytical movement through using Power BI!

During This Free Training, You Will Learn:

• Master complex data model techniques especially when running forecasting analysis
• Learn how to develop entire reporting solutions and models
• Compare trends and results through time effectively

If you have questions regarding this training, please send Continue reading “Forecasting Analysis in Power BI” →

Excel Improvements To TEXTBEFORE

Posted on by Annie D

Episode 2492
The Calc team at Microsoft released three changes to new functions in late May 2022. The improvements to TEXTBEFORE and TEXTAFTER give you options for dealing with situations where the delimiter that you are searching for is not found.

Table of Contents
(0:00) Former problem with TEXTBEFORE
(0:37) New syntax
(1:11) Using Match End
(1:31) Using If Not Found
(1:47) Why both?
(2:12) Thanks Excel Team
(2:27) Nancy Faust
(2:34) Like & Subscribe
(2:41) Excel Video Courses

The Best Data Type For Calendar Tables In Power BI

Posted on by Annie D

Using a Calendar Table in Power BI can allow you to filter your reports by time intelligence attributes like Year, Quarter, Month, and any other time aggregation by non-standard columns that your organization might need. In this video, Reid is going to talk about some considerations related to the calendar table, more specifically on what data types are best to be set when displaying certain things on various visual axis.

***** Video Details *****
00:00 Introduction
00:49 Creating custom column
01:45 Text data
01:57 Date data
03:49 Noisy axis
04:19 Self-contain

***** 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://www.enterprisedna.co/power-bi-resources
FREE – 60 Page DAX Reference Guide Download – https://www.enterprisedna.co/dax-formula-reference-guide-download/
Enterprise DNA Membership – https://www.enterprisedna.co/membership
Enterprise DNA Online – http://portal.enterprisedna.co/
Enterprise DNA Events – https://www.enterprisedna.co/enterprise-dna-events-page/

#EnterpriseDNA #PowerBI #PowerBIDesktop #PowerBITutorial

Microsoft 365 Excel Complete Class: free from excelisfun at YouTube – 365 MECS 00

Posted on by Annie D

This is a full and complete class about Microsoft 365 Excel and Power BI Desktop taught by Mike “excelisfun” Girvin. Link to class: https://www.youtube.com/playlist?list=PLrRPvpgDmw0nre_bTeBfJWjrnixKoyNtW
Mike is an Microsoft Excel MVP and a professor at Highline College. This class will cover topics such as:
1. Introduction
2. Worksheet Formula Models
3. Data Analysis with PivotTable, Power Query, Data Model, Power BI…
4. Date and Time formulas
5. SUMIFS, COUNTIFS & Conditional Calculations
6. Logical Formulas: Comparative Operators, IF, AND, OR and IS functions
7. Lookup functions: XLOOKUP and FILTER, Data Validation
8. Array Formulas
9. LET and LAMBDA functions
10. Formulas to Build Reports
11. Visualizing Data with Conditional Formatting, Continue reading “Microsoft 365 Excel Complete Class: free from excelisfun at YouTube – 365 MECS 00” →

Excel Statistical Analysis for Business – Busn 210 – Summer 2022 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 summer quarter, 2022.
To watch at YouTube here is the playlist: https://www.youtube.com/playlist?list=PLrRPvpgDmw0m3oqpp1XcPuaxyM4Bpi0dN

Data From Picture is here in Excel!

Posted on by Annie D

Episode 2490:
The Android phone has had it for a long time, but the new Data From Picture has finally reached the Office Insiders beta channel on desktop Excel. Bill gives this new feature a spin with various pictures of data.

Table of Contents
(0:00) Speech Recognition 1989 to today
(1:10) From Picture near Power Query tools
(1:35) Creating data picture
(2:00) Data From Picture no gridlines
(3:40) Cleaning the results
(4:15) The numbers all match
(4:30) Gridlines don’t help
(5:35) Right-align headings
(7:20) Need to proof
(7:50) With real photo test 1
(8:40) From clipboard test 2
(10:03) This will improve

Why can’t Power BI connect to my cloud source???

Posted on by Annie D

You have a cloud data source like Azure SQL Database. Why can’t Power BI connect to it? They are both in the cloud! Adam shows you some things to consider and options you have!

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

What is a virtual network (VNet) data gateway?
https://docs.microsoft.com/data-integration/vnet/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
— <a Continue reading “Why can’t Power BI connect to my cloud source???” →

Hiring in Analytics and Improving Data Literacy with Tim Freestone

Posted on by Annie D

A company’s success directly correlates with its people which is why employers and HR/talent acquisition personnel are constantly improving how they find, hire, and retain the best candidates. Data analytics plays a major role in this process.

In this episode of The Analytic Mind Podcast, Sam McKay is joined by Tim Freestone, founder of Alooba, to talk about hiring in analytics and data literacy.
From the big issues with CVs, and interviews, where companies typically go wrong to future trends in hiring and improving data literacy.

Tim Freestone has spent his career in analytics, starting initially as a financial analyst. Throughout his career, Continue reading “Hiring in Analytics and Improving Data Literacy with Tim Freestone” →