Month: October 2023

Want to Unlock the Secrets in Your Data? #enterprisedna

Posted on by Annie D

Want to Unlock the Secrets in Your Data?

A picture is worth a thousand data points.

Facts or Fiction?

A good visualization distinguishes one from the other.

Numbers Don’t Lie

But they can mislead if presented wrong.

Visual Integrity

Ensure your visuals are as truthful as they are stunning.

Chart Choices

Line, bar, radar. Your choice could redefine your data.

The Human Element

Understand your audience for effective visualization.

Data’s Best Friend

Aim to become indispensable in your organization.

Lead with Visualization

Master the art at Enterprise DNA.

Why Just Good When You Can Be Great? #dataviz #datavisualization #enterprisedna

Posted on by Annie D

Why Just Good When You Can Be Great?

Turn your good visualizations into great ones. Find out how.

Do You Speak Data?

Let your data do the talking through visuals that make sense.

Death by Pie Chart

Some visuals can distort your message. Be careful.

Keys to Effective Visualization

Colors, scales, labels—every detail counts.

Size Matters

The scale of your visuals can amplify or dilute your insights.

Story Over Numbers

Your data tells a story. Make sure you’re narrating it well.

Take the Leap

Go beyond conventional graphs. Get creative.

Be a Data Artist

Bring your data to life. Learn how at Enterprise DNA.

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!” →

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” →