Tired of dragging formulas down endless rows?
Excel’s dynamic arrays will do the heavy lifting for you.
#EnterpriseDNA #exceltutorial #excel #dataanalytics
Blog
Let’s look at using some PySpark in your first Microsoft Fabric Notebook
Not sure about Notebooks or PySpark in Microsoft Fabric? Simon Whitely joins us to help get you started and to demystify what it’s all about. He uses some SQL also!
How to use Microsoft Fabric notebooks
https://learn.microsoft.com/fabric/data-engineering/how-to-use-notebook
Use a notebook to load data into your Lakehouse
https://learn.microsoft.com/fabric/data-engineering/lakehouse-notebook-load-data
Simon Whiteley
https://www.advancinganalytics.co.uk/
https://www.youtube.com/@AdvancingAnalytics
https://twitter.com/MrSiWhiteley
https://www.linkedin.com/in/simon-whiteley-uk/
📢 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 Continue reading “Let’s look at using some PySpark in your first Microsoft Fabric Notebook”
Swamped with documents and data entry?
Swamped with documents and data entry?Swamped with documents and data entry?
Witness how AI Builder in Power Automate turns your document chaos into organized, actionable data with ease.
#EnterpriseDNA #powerautomate #data
Have you ever felt like you’re drowning in data?
Have you ever felt like you’re drowning in data?
Imagine if half your to-do list could do itself.
#EnterpriseDNA #processautomation
Is AI the Future of Personalized Data Experiences?
Is AI the Future of Personalized Data Experiences?
ChatGPT personalizes data interactions, offering tailored insights and recommendations.
Learn More!
#EnterpriseDNA #dataanalysis
Got an app idea while showering Let’s not let it wash away!
Got an app idea while showering Let’s not let it wash away!
Great apps often begin as ‘What if…’ questions.
What’s yours?
#EnterpriseDNA #appdevelopment #dataanalysis
Ever Wondered How to Transform Data into Compelling Stories?
Ever Wondered How to Transform Data into Compelling Stories?
Dive into Python’s Pandas library for advanced data exploration and analysis.
#EnterpriseDNA #python #dataanalysis
Is Your Data Telling the Full Story?
Is Your Data Telling the Full Story?
Imagine diving into a sea of data, only to surface with misleading insights. Frustrating, right?
Data Analysis isn’t just about numbers; it’s about uncovering the truth hidden within them.
#EnterpriseDNA #dataanalysis #datavisualization
Excel Publish Any Excel Logic As Web App Using Sheetcast While Protecting Your IP – Episode 2635
Microsoft Excel Tutorial: Embed any Excel Logic in a Web App Using Sheetcast.com.
Try this web app now to search my videos: https://c07.sheetcast.com/view/c79f93d2-0dcf-441f-97ac-b0c100f02a4f/~/d174333f-e3fe-4b14-a13b-ef6e384af5bb?embed=True&expand=true&showTitle=true
Welcome to episode 2635 of the MrExcel podcast! It’s been 25 years since I started sharing my Excel tips and tricks with all of you, and I couldn’t be more grateful for your support. Today, I have something truly amazing to show you – how to publish any Excel logic as a web app using Sheetcast while protecting your intellectual property. Plus, I’ll also be sharing how you can search through 25 years of MrExcel content Continue reading “Excel Publish Any Excel Logic As Web App Using Sheetcast While Protecting Your IP – Episode 2635”
Curious About Data Visualization?
Curious About Data Visualization?
Imagine diving into a sea of data, only to surface with misleading insights. Frustrating, right?
Data Analysis isn’t just about numbers; it’s about uncovering the truth hidden within them.
#EnterpriseDNA #PowerBI #PowerBITutorial
Have you ever felt like you’re drowning in data but starved for insights?
Have you ever felt like you’re drowning in data but starved for insights?
Imagine if transforming that data was as easy as flipping a switch.
#EnterpriseDNA
Excel PIVOTBY Function to Create Completely Dynamic PivotTable Formula Reports! EMT 1845
Download Excel File: https://excelisfun.net/files/EMT1845.xlsx
You will not believe what you see in this video. See the basics of the new PIVOTBY function to make PivotTable Formula Reports, then see how to create monthly sales reports (with a hack), then see a completely dynamic Formula PivotTable Report where you can use cell inputs to change, Row, Column and Filter Conditions, Change the Function for the report and create a dynamic label that describes the report. Simply Amazing!!!
Topics:
1. (00:00) Introduction.
2. (00:22) PIVOTBY function, complete description and examples.
3. (05:50) Monthly Sales Report with PIVOTBY function.
4. (08:11) Fully dynamic PivotTable report with Continue reading “Excel PIVOTBY Function to Create Completely Dynamic PivotTable Formula Reports! EMT 1845”