Blog

Bonbon's Guide To Data & Tech > Blog

DAME 04: Data Analysis with Excel Worksheet Formulas: 4 Comprehensive examples.

Posted on by Annie D

Download files: https://people.highline.edu/mgirvin/AllClasses/348/348/2024/Content/Week06/Video04Files.zip
Free YouTube Data Analysis Class about Microsoft Power Tools in 2024 taught by Excel MVP and Highline College Professor, Mike “excelisfun” Girvin.
In this video learn about when Excel worksheet formulas are the perfect tool for data analysis. An hour lesson in the power of Excel worksheet formulas and when they beat PivotTables, Power Query and Power BI.
Topics:
1. (00:00) Introduction
2. (00:40) 4 scenarios where worksheet formulas are better than other tools.
3. (02:33) Example #1: Enter Data In Worksheet & Need Analysis Off To Side.
4. (03:22) MOD function for hours worked formula
5. (05:19) Line Chart
6. (06:37) 7-Day Continue reading “DAME 04: Data Analysis with Excel Worksheet Formulas: 4 Comprehensive examples.” →

🔴 Let’s talk Microsoft Fabric – LIVE w/ Matthew Roche (May 4, 2024) (Member Chat 2nd Half)

Posted on by Annie D

Join us live as we answer your questions about Microsoft Fabric (including Power BI)! Get your questions in the chat early as we don’t get to all of them.

💥 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

Connect with Matthew:
Mastodon: https://techhub.social/@SQLAllFather
YouTube: <a href="https://www.youtube.com/" Continue reading “🔴 Let’s talk Microsoft Fabric – LIVE w/ Matthew Roche (May 4, 2024) (Member Chat 2nd Half)” →

Can’t create a relationship? Time for a surrogate key in Power BI!

Posted on by Annie D

This looks at a scenario of a hierarchy but the child ID repeats and we can’t create a relationship on it. Adam looks at how you could use a surrogate key to get a relationship in place so you can build your Power BI report.

📢 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
— Continue reading “Can’t create a relationship? Time for a surrogate key in Power BI!” →

Data Mentor meets EDNA AI

Posted on by Annie D

Discover how Data Mentor seamlessly integrates with Enterprise DNA’s suite of tools to provide an unparalleled learning experience, demonstrated through the use of agents to tackle complex learning projects and guided learning interactions for personalized skill development in Power BI and DAX.

Details of what you will learn during this video:

– Integration of Data Mentor with Enterprise DNA’s tools
– Utilization of agents for complex learning projects
– Guided learning interactions for personalized skill development in Power BI and DAX

***** Learning with Enterprise DNA *****
FREE Courses – https://bit.ly/45fu3tw
FREE Resources – https://bit.ly/455Hw6O
Enterprise DNA On-Demand – <a href="https://app.enterprisedna.co/app" Continue reading “Data Mentor meets EDNA AI” →

Getting creative with a Line Chart in Power BI

Posted on by Annie D

Saw an interesting conversation about a line chart and some different approaches in Power BI. Adam explored those options and explains the differences. Never stop tinkering with visuals!

Twitter conversation:
https://twitter.com/CJMajka/status/1781039450199302195

📢 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 page Continue reading “Getting creative with a Line Chart in Power BI” →

Solving Real Problems and Improving Your Productivity

Posted on by Annie D

Data Mentor seamlessly integrates into your daily workflow, offering solutions, productivity improvements, and deep learning opportunities through real-world problem-solving scenarios.

Details of what you will learn during this video:

– Data Mentor’s role in enhancing daily workflow
– Examples showcasing Data Mentor’s problem-solving in Enterprise DNA forum
– AI tools used to tackle complex forum questions
– Step-by-step guide to solving questions with Data Mentor
– Demonstrations of measure branching and code simplification
– Saving and sharing valuable insights within Data Mentor

***** Learning with Enterprise DNA *****
FREE Courses – https://bit.ly/45fu3tw
FREE Resources – https://bit.ly/455Hw6O
Enterprise DNA On-Demand – https://app.enterprisedna.co/app
Enterprise Continue reading “Solving Real Problems and Improving Your Productivity” →

Make Learning a Habit with Data Mentor

Posted on by Annie D

Discover how to use Data Mentor to learn anything new, showcasing its versatility and effectiveness for general learning through personalized workflows and comprehensive guides covering SQL fundamentals and beyond.

Details of what you will learn during this video:

– Understanding the functionality of Data Mentor.
– Exploring personalized learning paths for various topics.
– Mastering SQL and other subjects using comprehensive guides.
– Leveraging the efficiency and speed of Data Mentor for learning.

***** Learning with Enterprise DNA *****
FREE Courses – https://bit.ly/45fu3tw
FREE Resources – https://bit.ly/455Hw6O
Enterprise DNA On-Demand – https://app.enterprisedna.co/app
Enterprise DNA Subscriptions – https://app.enterprisedna.co/pricing
Enterprise Continue reading “Make Learning a Habit with Data Mentor” →

Incredible AI Agents Revealed

Posted on by Annie D

Agents offer a glimpse into advanced AI, automating tailored learning projects for accelerated productivity in diverse data-related topics.

Details of what you will learn during this video:

– Introduction to agents: advanced AI tools for accelerating learning projects
– Creating a Python learning project outline and showcasing agents’ automated guide generation
– Exploring features like step-by-step guides and editing options within generated projects
– Discussion on agents’ versatility in covering diverse data topics and technologies
– Overview of agents’ role in documenting strategies and addressing queries across domains

***** Learning with Enterprise DNA *****
FREE Courses – https://bit.ly/45fu3tw
FREE Resources – rel=”nofollow”>https://bit.ly/455Hw6O
Enterprise DNA On-Demand – https://app.enterprisedna.co/app
Enterprise DNA Subscriptions – https://app.enterprisedna.co/pricing
Enterprise DNA Workouts – https://bit.ly/41F9weH

#EnterpriseDNA #PowerBI #PowerBIDesktop #PowerBITutorial #DAX #DAXTutorial #PowerQuery #PowerQueryTutorial

Crafting Document with Precision: A Comprehensive Guide

Posted on by Annie D

Easily create and customize your own documents with Data Mentor, combining AI-generated content with your own insights and code snippets for quick reference and sharing within your personalized knowledge base.

Details of what you will learn during this video:

– Distinction between queries, threads, and documents
– Ability to customize and create personal documents
– Comparison with Analyst Hub’s document functionality
– Demonstrations on creating, editing, and organizing documents
– Utilizing documents for storing code snippets, project documentation, and other useful information
– Future integration plans with additional functionalities like sharing and agents folders

***** Learning with Enterprise DNA *****
FREE Courses – https://bit.ly/45fu3tw
FREE Resources Continue reading “Crafting Document with Precision: A Comprehensive Guide” →

Build Content Libraries: The Ultimate Guide

Posted on by Annie D

Create customized knowledge libraries effortlessly by organizing queries and threads, allowing for seamless adjustments and enhanced productivity in personalized learning journeys.

Details of what you will learn during this video:

– Organizing queries and threads into customized knowledge libraries
– Adjusting and editing content within libraries for personalized learning
– Enhancing productivity through optimized learning journeys

***** Learning with Enterprise DNA *****
FREE Courses – https://bit.ly/45fu3tw
FREE Resources – https://bit.ly/455Hw6O
Enterprise DNA On-Demand – https://app.enterprisedna.co/app
Enterprise DNA Subscriptions – https://app.enterprisedna.co/pricing
Enterprise DNA Workouts – https://bit.ly/41F9weH

#EnterpriseDNA #PowerBI #PowerBIDesktop #PowerBITutorial #DAX #DAXTutorial #PowerQuery #PowerQueryTutorial

Expert Advise: AI Advisor Tools

Posted on by Annie D

Data Mentor offers an extensive range of AI tools covering diverse topics, from code simplification to data strategy, enabling users to learn and solve problems efficiently across various domains.

Details of what you will learn during this video:

– Overview of the AI tools available within Data Mentor
– Explanation of each tool’s functionality and purpose
– Examples demonstrating how to use different AI tools for tasks such as code simplification, data modeling, and project planning
– Insight into how these tools can enhance learning and problem-solving in various domains, including coding, data analysis, and project management

***** Learning with Enterprise DNA *****
FREE Courses – Continue reading “Expert Advise: AI Advisor Tools” →

DAME 03: PivotTables Rule for Quick & Easy Reports! 34 Amazing PT Tricks.

Posted on by Annie D

Download files: https://people.highline.edu/mgirvin/AllClasses/348/348/2024/Content/Week06/Video03Files.zip Pdf notes to read online: https://people.highline.edu/mgirvin/AllClasses/348/348/2024/Content/Week06/03-DAMEMPT.pdf
Free YouTube Data Analysis Class about Microsoft Power Tools in 2024 taught by Excel MVP and Highline College Professor, Mike “excelisfun” Girvin. This video teaches you the beauty and simplicity of PowerQuery yo get, transform, abd load the data to the location that you want/.

Topics:
1. (00:00) Introduction
2. (00:26) Free PivotTable Cheat Sheet in workbook file or pdf notes
3. (00:39) Toy sales Data Set
4. (01:21) Why use PivotTables?
5. (01:58) Basics of PivotTables
6. (02:35) PivotTable Cache
7. (04:02) Change Default PivotTable Layout
8. (04:40) PT Calculations: Summarize Values By, Continue reading “DAME 03: PivotTables Rule for Quick & Easy Reports! 34 Amazing PT Tricks.” →