Category: Business

Is Your Data Telling You a Story? #datatalks #dataanalysis #enterprisedna

Posted on by Annie D

Is Your Data Telling You a Story?

Your data holds secrets. Unlock them with the magic wand called data visualization.

Why Stare at Numbers?

Spreadsheets are great but visuals bring data to life. Ever wonder how?

Data Overwhelm

Staring at raw data feels like reading an ancient text. Confusing and overwhelming.

The Power of Visualization

With the right graphs, trends jump out at you. Insights become crystal clear.

Why Most Visualizations Fail

Not all graphs are created equal. Bad visuals mislead.

The Art of Picking the Right Graph

Bar, line, or scatter plot? The graph you choose can make or break your analysis.

Simplify Your Decision-Making

Good visuals remove guesswork. They steer you Continue reading “Is Your Data Telling You a Story? #datatalks #dataanalysis #enterprisedna” →

Are You a Data Explorer? #datatalks #football #enterprisedna

Posted on by Annie D

Are You a Data Explorer?

Make your journey worthwhile with visuals that matter.

Drowning in Data?

Let’s throw you a visual lifeline.

Navigating the Data Jungle

Without good visuals, you’re lost.

Your Map to Insights

Build pathways in your data with the right visuals.

The Right Tools

From software to color schemes, equip yourself well.

Less is More

Simplicity can be your strongest asset in visualization.

Chart Your Future

The road to success is paved with good graphs.

Navigate with Confidence

Perfect your data visualization skills at Enterprise DNA.

The Secret to Data-Driven Dynamic Subscriptions in Paginated Reports

Posted on by Annie D

We’ve been waiting a long time to see this! Finally dynamic subscriptions are available for Power BI Paginated reports! Maybe Patrick cried a little he was soooo happy!

Dynamic subscriptions for paginated reports (Preview)
https://powerbi.microsoft.com/en-us/blog/dynamic-subscriptions-for-paginated-reports-preview/

Dynamic per recipient subscriptions (Preview)
https://learn.microsoft.com/power-bi/collaborate-share/dynamic-subscriptions

📢 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 “The Secret to Data-Driven Dynamic Subscriptions in Paginated Reports” →

Mind-Blowing Power BI Update: Model View enhancements!

Posted on by Annie D

Hold on tight as Patrick unveils the game-changing update on Power BI Desktop that will blow your mind. Thanks to the hard work of Zoe and the Power BI team, you can now enjoy a whole new set of features and capabilities that will transform your modeling experience. Don’t miss out on the latest updates, make sure to subscribe for more exciting Power BI content!

Deep dive into the Model Explorer with calculation group authoring and creating relationships in the properties pane
https://powerbi.microsoft.com/en-us/blog/deep-dive-into-the-model-explorer-with-calculation-group-authoring-and-creating-relationships-in-the-properties-pane/

Work with Model explorer
https://learn.microsoft.com/power-bi/transform-model/model-explorer

Create calculation groups
https://learn.microsoft.com/power-bi/transform-model/calculation-groups

Calculation groups
https://aka.ms/calculationgroups

📢 Become Continue reading “Mind-Blowing Power BI Update: Model View enhancements!” →

FILTER Function to Create Sub Table from Master Table. Data Validation Too! Excel Magic Trick 1842

Posted on by Annie D

Download Excel File: https://excelisfun.net/files/EMT1842.xlsx
Learn about how to use the FILTER function to create sub tables based on a master table. Also learn how to create a unique sorted list of city names for data validation. Learn how to create Conditional Formatting for Dynamic Spilled Arrays.
Topics:
1. (00:00) Introduction
2. (00:05) Filter data set by city name
3. (00:35) UNIQUE and SORT functions to extract a sorted unique list
4. (01:05) Data Validation
5. (01:42) FILTER Function
6. (02:29) Conditional Formatting for Dynamic Spilled Arrays
7. (03:13) Summary
8. (03:23) Closing, Video Links

#excel #excelisfun #analytics #analysis #dataanalysis #dataanalytics #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftexcel #microsoftmvp #conditionalFormat Continue reading “FILTER Function to Create Sub Table from Master Table. Data Validation Too! Excel Magic Trick 1842” →

Excel Cell Tool Tip Calculated On The Fly – Episode 2631

Posted on by Annie D

Microsoft Excel Tutorial: Display an in-cell tooltip based on a calculation.

To download the workbook from today: https://www.mrexcel.com/youtube/Q5vwz18lir4/
Rather than type the code, download the workbook and copy it from my workbook.

Welcome to episode 2631 of MrExcel’s netcast! In this video, we will be discussing an amazing idea that was sent in by one of our viewers on YouTube. The idea is to have a cell tool tip that is calculated on the fly, meaning that the recommended value in the tool tip changes based on the data entered. This is a great way to make data entry more Continue reading “Excel Cell Tool Tip Calculated On The Fly – Episode 2631” →

Finish the Puzzle: Querying Power BI Semantic Models with Semantic Link!

Posted on by Annie D

Want to use notebooks to leverage data from a Power BI semantic model (dataset)? Maybe you’re a data scientist wanting to augment your models with that data, or maybe you just want to validate stuff as a Power BI developer. Semantic Link (or Sempy) can help!

Sample Notebook: https://github.com/guyinacube/demo-files/blob/master/video%20demos/Synapse/20231019%20-%20Sempy.ipynb

What is semantic link?
https://learn.microsoft.com/fabric/data-science/semantic-link-overview

Tutorial: Clean data with functional dependencies
https://learn.microsoft.com/fabric/data-science/tutorial-data-cleaning-functional-dependencies

Tutorial: Extract and calculate Power BI measures from a Jupyter notebook
https://learn.microsoft.com/fabric/data-science/tutorial-power-bi-measures

Detect, explore, and validate functional dependencies in your data
https://learn.microsoft.com/fabric/data-science/semantic-link-validate-data

fabric Package
https://learn.microsoft.com/python/api/semantic-link-sempy/sempy.fabric?view=semantic-link-python

📢 Become a member: https://guyinacu.be/membership Continue reading “Finish the Puzzle: Querying Power BI Semantic Models with Semantic Link!” →

Excel Labs Function To Get Answers From OpenAI In Excel – Episode 2630

Posted on by Annie D

Microsoft Excel Tutorial: Using OpenAI from a formula in Excel.

To download the workbook from today: https://www.mrexcel.com/youtube/oh4rZCKssPM/

Welcome back to the MrExcel Netcast, where we explore all things Excel. In today’s episode, we’re diving into the world of Open AI and how you can use it right inside of Excel. Thanks to the amazing team at Excel Labs, we now have access to this powerful tool that can generate answers and content for us in a matter of seconds.

If you caught our silly videos for Spreadsheet Day, you may have noticed that we had some help from some unexpected Continue reading “Excel Labs Function To Get Answers From OpenAI In Excel – Episode 2630” →

As You Celebrate Spreadsheet Day Tonight, Not Too Many PowerPivotinis! #spreadsheetday #excel

Posted on by Annie D

October 17 is Spreadsheet Day!

Welcome to my channel, where we celebrate all things Excel and spreadsheets! Today is a special day, as we honor the invention of the spreadsheet on Spreadsheet Day. As we raise our glasses to toast this incredible tool, let’s not forget to also raise a glass to the advancements in technology that have made our lives easier and more efficient.

As we reflect on the evolution of spreadsheets, let’s also take a moment to appreciate the hard work and dedication of those who have contributed to its development. From the early days of the typewriter Continue reading “As You Celebrate Spreadsheet Day Tonight, Not Too Many PowerPivotinis! #spreadsheetday #excel” →

FILTER Function or Advanced Filter to Extract Records with Complex Filter? Excel Magic Trick 1841

Posted on by Annie D

Learn about how to use FILTER function with a complex filter based on a BETWEEN, AND and OR Logical Tests. Chapter 13 in the book, The Only App That Matters. Learn about Advanced Filter also.
Topics:
1. (00:00) Introduction
2. (00:05) Complex Filter
3. (00:30) Logical Tests
4. (02:00) Filter Function
5. (06:02) Advanced Filter)
6. (07:54) Summary
7. (08:20) Closing, Video Links

#excel #excelisfun #analytics #analysis #dataanalysis #dataanalytics #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftexcel #microsoftmvp #lookup #xlookup #filter #filterfunction #logical #advancedfilter