For Fall 2024 matriculating students at Highline College in Seattle, Washington. This is the introduction to the Busn 210 Excel Statistical Analysis class. For non-matriculating students, the class is free here at YouTube: https://www.youtube.com/playlist?list=PLrRPvpgDmw0m3oqpp1XcPuaxyM4Bpi0dN
Blog
Highline College Busn 218 Advanced Excel Fall, 2024 Introduction
For Fall 2024 matriculating students at Highline College in Seattle, Washington: this is the introduction to the class. For non-matriculating students, the class is free here at YouTube: https://www.youtube.com/playlist?list=PLrRPvpgDmw0nre_bTeBfJWjrnixKoyNtW
Lookup Manager Name in Column Headers to Create Report: Excel Magic Trick 1866
Download Excel File: https://excelisfun.net/files/EMT1866.xlsx
Buy M Code Book at Mr Excel site: https://www.mrexcel.com/products/the-… or Amazon: https://www.amazon.com/Transformative… Mike “excelisfun” Girvin’s 4th book: The Transformative Magic of Power Query M Code in Power BI & Excel. Book about Power Query M Code to help data analysts transform and shape data into useful, actionable information for decision makers.
Topics in Video:
1) (00:00) Introduction
2) (00:55) Worksheet function to create column of employee names from a table using TOCOL and UNIQUE functions.
3) (01:30) Worksheet function to lookup manager names and join with a comma between each name using Continue reading “Lookup Manager Name in Column Headers to Create Report: Excel Magic Trick 1866”
Excel 365 to Make Your Teaching Job Easy: Dynamic Spilled Arrays, XLOOKUP, Power Query & PivotTables
Highline College Professional Development Day 2024 presentation by Mike “excelisfun” Girvin
Download Excel file: https://people.highline.edu/mgirvin/M365Excel-HighlineProDevDay.xlsx
Pdf file with video notes: https://people.highline.edu/mgirvin/M365Excel-HighlineProDevDay.pdf
In this video learn how to: Create Gradebook with Dynamic Spilled Arrays Formulas and the XLOOKUP function, Use Dynamic Spilled Arrays Formulas to Create Budget, Use Power Query to Import Student Grade Data from Canvas, Use PivotTables to Create Summary Reports from Student Survey Data.
Topics:
1. (00:00) Introduction
2. (01:25) Create Gradebook with Dynamic Spilled Arrays Formulas and the XLOOKUP function.
3. (12:05) Don’t be Tricked by Number Formatting
4. (16:05) BYROW and BYCOL functions to spill aggregate totals and Continue reading “Excel 365 to Make Your Teaching Job Easy: Dynamic Spilled Arrays, XLOOKUP, Power Query & PivotTables”
Update Data Sources within Deployment Pipelines
Making use of a Deployment Pipeline within Microsoft Fabric? Not sure how to update data sources for your Power BI semantic model as you move through stages? Adam has you covered!
Get started with deployment pipelines
https://learn.microsoft.com/fabric/cicd/deployment-pipelines/get-started-with-deployment-pipelines?tabs=from-fabric
Create deployment rules
https://learn.microsoft.com/fabric/cicd/deployment-pipelines/create-rules
📢 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 “Update Data Sources within Deployment Pipelines”
Get a custom endpoint without creating an EventHub for EventStreams
No need to create a custom event hub when leveraging eventstreams in Microsoft Fabric. Just create a custom endpoint instead! Patrick shows you how.
Add custom endpoint source to an eventstream
https://learn.microsoft.com/fabric/real-time-intelligence/event-streams/add-source-custom-app?pivots=enhanced-capabilities
📢 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 Continue reading “Get a custom endpoint without creating an EventHub for EventStreams”
Get started with the On-Premises Data Gateway in Microsoft Fabric
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
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
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
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
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
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”