Broadway Gypsy asks if there is a way to create a “minute by minute changing up/down stock price arrow in Excel”?
In this video, Bill shows how to use Icon Sets and the SIGN function to add up/down arrows next to Continue reading “Minute by Minute Stock Price Arrows In Excel – 2429”
It’s a common task in Power BI to have to combine data from multiple worksheets in the same Excel workbook. For today’s tutorial, I’ll show how you can optimize your workflow and easily open data from multiple sheets and within Continue reading “Append A Vast Number Of Excel Sheets In Power BI”
Download Excel File: https://excelisfun.net/files/EMT1757.xlsx
Learn keyboard shortcuts to bring Excel Tables, Defined Names or Dynamic Spilled Arrays from the worksheet into the Power Query Editor:
(00:00) Intro
(00:03) From Sheet Power Query command to bring Excel Table into Power Query. Continue reading “Power Query From Sheet option Import Tables, Defined Names or Dynamic Arrays. Fast Keyboard EMT 1757”
EVENT DETAILS – https://enterprisedna.co/business-analytics-week-july-2021-registration/
RESOURCE DOWNLOAD – https://portal.enterprisedna.co/p/learning-summit-series-free/
Session 2 – Gig Housing Analysis In Power BI – Live Development Example
When is it?
September 23rd, 5pm New York (EDT), 2pm Los Angeles (PDT), 10pm London (BST)
September 24th, Continue reading “Gig Housing Analysis In Power BI – Live Development Example”
Download Excel File: https://excelisfun.net/files/EMT1756.xlsx
Learn how to import an Excel file from OneDrive into a PivotTable using Power Query. This trick came from Wyn Hopkins, Excel MVP. See how to create a PivotTable Report with survey data to Continue reading “Power Query to Import Excel File From OneDrive SharePoint into PivotTable, Refresh New Data EMT 1756”
EVENT DETAILS – https://enterprisedna.co/business-analytics-week-september-2021-registration/
RESOURCE DOWNLOAD – https://portal.enterprisedna.co/p/learning-summit-series-free/
Session 1: Health Outcomes Prediction Scenario – Data Exploration w/ Power BI
When is it?
September 22nd, 5pm New York (EDT), 2pm Los Angeles (PDT), 10pm London (BST)
September 23rd, 7am Continue reading “Health Outcomes Prediction Scenario – Data Exploration w/ Power BI”
In this video, I will discuss four hidden pitfalls in Power BI that can wreck your data model and/or report right out of the gate. I will show you not only how to avoid these problems, but how to create Continue reading “The Four Horsemen of the Power BI Apocalypse”
Comparing tables is a very common task in Excel and can get tedious if you do it manually all throughout. In this tutorial, I’ll show how you can easily compare two tables in Power Query to isolate the items Continue reading “Easily Compare Two Tables in Power Query”
Download Excel File: https://excelisfun.net/files/EMT1755.xlsx
Learn how to import a file or a folder filled with files into Excel using Power Query.
(00:00) Introduction
(00:06) Import file from OneDrive. Use From Web Power Query Connector.
(01:25) Import files from Folder from OneDrive. Continue reading “Import OneDrive File or Folder using Power Query. EMT 1755”
We’re trying out a new format wherein the Enterprise DNA Experts gather for a roundtable discussion about a variety of topics. For this video, the eDNA Experts will be talking about Power BI Challenge 15, and share their strategies on Continue reading “Strategies For Building Challenge Entries With Enterprise DNA Experts”
We’re starting a new mini series that we’re calling “Member Stories”, that will serve as our platform to feature the members of the Enterprise DNA community and their inspiring skills in Power BI. For this video, Brian is joined by Continue reading “Member Stories With David Johnston and Federico Pastor – Power BI Challenge Newcomers”
For today’s video, we’re releasing the 2nd part of the topic we featured last Wednesday. This was supposed to be published next week but we were surprised with the response on the first video that we decided to bump up Continue reading “The Great New Hidden DAX Function Pt 2 – Dynamic Analyses”