Month: February 2025

GitHub Workflow for Echo Assist

Posted on by Annie D

***** Video Details *****
This episode explores the GitHub workflow for Echo Assist, a voice-typing productivity app, and how AI-powered tools like Windsurf & GitHub make software development more efficient. Learn how to clone repositories, set up a local environment, and enhance UI/UX with AI assistance, even with minimal coding experience. We showcase automated UI improvements, API integrations, and seamless GitHub commits, demonstrating how AI reduces development time from hours to minutes. With AI streamlining the process, coding has never been more accessible.

***** Related Links *****
https://copycoder.ai/
https://codeium.com/windsurf
https://github.com/

***** Learning with Enterprise DNA ***** Continue reading “GitHub Workflow for Echo Assist” →

Stock Portfolio Expected Return & Beta with single cell array formula. Bonus Trick Too! #Short 59

Posted on by Annie D

Download Excel file: https://people.highline.edu/mgirvin/AllClasses/455/ch10/ExcelShort57-59.xlsx
Learn how to create single cell array formula that allows you to skip many intermediate steps so you can calculate the expected return and beta for a portfolio of stocks using array calculations and the SUM function

Learn #excel #excelformulas #excelfunctions #Short #excelfinance #beta #returns #portfoliomanagement

Multiple Fact Tables in Power BI Made Simple and FAST!

Posted on by Annie D

We got a question about circular dependencies based on a previous video Patrick did. So, how do you handle that with multiple fact tables in Power BI? Patrick breaks it down!

Understanding circular dependencies in DAX
https://www.sqlbi.com/articles/understanding-circular-dependencies/

Avoiding circular dependency errors in DAX
https://www.sqlbi.com/articles/avoiding-circular-dependency-errors-in-dax/

Sample files:
https://github.com/guyinacube/demo-files/blob/master/video%20demos/PBIX/2025/20250220%20-%20Multiple%20Facts.zip

📢 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" target="_blank" Continue reading “Multiple Fact Tables in Power BI Made Simple and FAST!” →

How To Become A Full Stack AI Professional AI Builders

Posted on by Annie D

***** Video Details *****
Building apps? Automating workflows? Creating intelligent systems? Years ago, these have felt out of reach. Fast forward to today—you can do it all. With AI, things that once took teams of engineers and thousands of dollars can be done in minutes with AI-powered development. This is the full-stack AI revolution, and it’s just beginning. The opportunity is massive. AI is not replacing jobs—it’s creating new ones for those who are willing to learn.

***** Related Links *****

***** Learning with Enterprise DNA *****
FREE Courses – https://bit.ly/45fu3tw
FREE Resources – https://bit.ly/455Hw6O
EDNA Learn – <a Continue reading “How To Become A Full Stack AI Professional AI Builders” →

Expected Return & Standard Deviation 4 Portfolio of Stocks Single Cell Excel Array Formula #Short 58

Posted on by Annie D

Download Excel file: https://people.highline.edu/mgirvin/AllClasses/455/ch10/ExcelShort57-59.xlsx
Learn how to create single cell array formula that allows you to skip many intermediate steps so you can calculate the expected return and standard deviation for a portfolio of stocks using array calculations and the BYROW, SUM and SQRT functions.

Learn #excel #excelformulas #excelfunctions #Short
#excelfinance #standarddeviation #BYROW #expectedreturn #excelisfun

How to Make Your PowerPoint Presentations 10X More Powerful?

Posted on by Annie D

Want to make your PowerPoint presentations 10X more powerful??? Patrick goes through new capabilities with embedding a Power BI report to make your slides interactive and more engaging!

Add live Power BI data to PowerPoint
https://learn.microsoft.com/power-bi/collaborate-share/service-power-bi-powerpoint-add-in-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
— http://twitter.com/awsaxton
— http://twitter.com/patrickdba
— http://www.facebook.com/guyinacube
— https://www.instagram.com/guyinacube/
— https://guyinacube.com

***Gear***
🛠 Continue reading “How to Make Your PowerPoint Presentations 10X More Powerful?” →

Expected Return & Standard Deviation for 2 Stocks: Single Cell Excel Spilled Array Formula #Short 57

Posted on by Annie D

Download Excel file: https://people.highline.edu/mgirvin/AllClasses/455/ch10/ExcelShort57-59.xlsx
Learn how to create single cell array formula for stock A and stock B to calculates and spills the Expected Returns and Standard Deviations using array calculations and the BYCOL, SUM and SQRT functions. Also see that we can use BYCOL and BYROW lambda eta functions that are not from the dropdown list of functions. See that we can use the SQRT function inside BYCOL and BYROW functions

#excel #excelformulas #excelfunctions #Short #excelfinance #BYCOL #BYROW #arrays #expectedreturn #standarddeviation

Create Column of 8 Excel Text Formulas from Rectangle Range with Single Spilled Formula. #Short 56

Posted on by Annie D

Download Excel file: https://people.highline.edu/mgirvin/AllClasses/455/ch10/ExcelShort55-56.xlsx
Learn how to create text formula labels from a rectangualr range with elements that the formula needs from the column headers and row headers. Amazing Dynamic Spilled Array Formula. See the TEXT, FOMULATEXT and TOCOL functions as well as the Ampersand, the Join Operator.

Learn #excel #excelformulas #excelfunctions #Short #textformatting #ampersand #formulatext #excelisfun

Excel’s Amazing SCAN Function: Spill Formula That Acts On Previous Spilled Value!?! #Short Excel 55

Posted on by Annie D

Download Excel file: https://people.highline.edu/mgirvin/AllClasses/455/ch10/ExcelShort55-56.xlsx
Learn how to spill an array of estimated stock values based on an initial stock value and an array of various changing return % values. See the functions SCAN, REDUCE and PRODUCT.

Learn #excel #excelformulas #excelfunctions #Short #lambda #lambdaexpression #scan #reduce #scanfunction #excelscan

Net Present Value Profile Spilled Formula: Table and X-Y Scatter Chart. #Short 54. ACCTG 455 #68.4

Posted on by Annie D

Download Excel file: https://people.highline.edu/mgirvin/AllClasses/455/ch08/ExcelShort51-54.xlsx
Learn how to create a dynamic spilled array formula to build a Net Present Value Profile Table based on varying Required Rate of Return values and then build a chat to visualize the relationship between RRR and NPV. See how to visualize with an X-Y Scatter Chart.