Category: Business

Track Changes Using Dimensions In Power Query

Posted on by Annie D

Business Intelligent Summit are action packed live events showcasing a variety of beginner to advanced Power BI/Power Platform tips and techniques. Summit sessions have a unique focus on how anyone can build and develop analytical solutions with Power BI that solve real-world business problems. Thousands attend these events live to watch and learn from a real-time demo.

***** Details of what you will learn during this event series module *****
Showcase – how to implement an SCD Type 2 using Power Query to allow a full historical analysis of a specific dimension
Design – in a precise way to facilitate tracking changes Continue reading “Track Changes Using Dimensions In Power Query” →

Excel LAMBDA, LAMBDA Helper Functions & Eta-LAMBDAs: the Complete Story – Updated 2024: 365 MECS 10

Posted on by Annie D

Download Excel Start file: https://excelisfun.net/files/10-M365ExcelClassStart2024.xlsx
Download pdf notes: https://excelisfun.net/files/10-M365ExcelClass2024.pdf
Download Excel Finished file: https://excelisfun.net/files/10-M365ExcelClassFinished2024.xlsx
This is a 1:45 hour video about everything that the Excel LAMBDA function, LAMBDA Helper Functions & Eta-LAMBDAs can do. This video is also a complete lesson in Defined Names, the LET function and Spilled Single Cell Formula Reports.
Course taught by Excel MVP and Highline College Professor, Mike Girvin. Course is Microsoft 365 Excel Complete Story.
Topics in video:
1. (00:00) Introduction
2. (01:18) Overview
3. (03:09) Defined Names
4. (13:00) First look at LAMBDA to create a re-usable function
5. (19:25) Advanced Formula Environment
6. (24:08) Continue reading “Excel LAMBDA, LAMBDA Helper Functions & Eta-LAMBDAs: the Complete Story – Updated 2024: 365 MECS 10” →

Clean Your Data Like A Pro

Posted on by Annie D

Business Intelligent Summit are action packed live events showcasing a variety of beginner to advanced Power BI/Power Platform tips and techniques. Summit sessions have a unique focus on how anyone can build and develop analytical solutions with Power BI that solve real-world business problems. Thousands attend these events live to watch and learn from a real-time demo.

***** Details of what you will learn during this event series module *****
Explore – common data cleaning scenarios.
Use – Power Query/ M effectively to prepare data for analysis.
Built – reusable solutions to make this task something to look forward to!
Learn – how Continue reading “Clean Your Data Like A Pro” →

Developing Data Models In The Real World

Posted on by Annie D

Business Intelligent Summit are action packed live events showcasing a variety of beginner to advanced Power BI/Power Platform tips and techniques. Summit sessions have a unique focus on how anyone can build and develop analytical solutions with Power BI that solve real-world business problems. Thousands attend these events live to watch and learn from a real-time demo.

***** Details of what you will learn during this event series module *****
Discover – the foundations of Data Modelling in Power BI and Power Query as well as the benefits by referring to techniques such as the Kimball methodology
Understand – how to prepare Continue reading “Developing Data Models In The Real World” →

Create a measure from a filtered visual in Power BI? Of Course, you can!

Posted on by Annie D

A live stream question asked if you could create a DAX measure from a filtered visual in a Power BI report. Of course, you can! Patrick uses the new DAX Query view in Power BI Desktop to show you how.

📢 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 “Create a measure from a filtered visual in Power BI? Of Course, you can!” →

Exploring Custom Spark Pools in Microsoft Fabric Lakehouses

Posted on by Annie D

With Microsoft Fabric Lakehouses you begin with a starter pool for Spark. Patrick shows how you can create custom pools and have those as the default for your workspace.

Configuring starter pools in Microsoft Fabric
https://learn.microsoft.com/fabric/data-engineering/configure-starter-pools

How to create custom Spark pools in Microsoft Fabric
https://learn.microsoft.com/fabric/data-engineering/create-custom-spark-pools

📢 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
— <a Continue reading “Exploring Custom Spark Pools in Microsoft Fabric Lakehouses” →

Using ChatGPT To Supercharge Power BI Development

Posted on by Annie D

A unique opportunity for data professionals, data scientists, analysts, and business leaders to explore the applications of ChatGPT, a powerful language model developed by OpenAI, in the field of data analytics. This initiative will cover various aspects of using ChatGPT for data analytics, including text generation, data exploration, data visualization, and natural language processing (NLP) tasks.

Participants will gain insights into how ChatGPT can be leveraged to enhance their data analytics workflows and drive better decision-making.

#EnterpriseDNA #PowerBI #PowerBIDesktop #PowerBITutorial #artificialintelligence #chatgpt