Business Professionals
Techno-Business Professionals
Power BI | Power Query | Advanced DAX | SQL - Query &
Programming
Microsoft Fabric | Power BI | Power Query | Advanced DAX |
SQL - Query & Programming
Microsoft Power Apps | Microsoft Power Automate
Power BI | Adv. DAX | SQL (Query & Programming) |
VBA | Python | Web Scrapping | API Integration
Power BI | Power Apps | Power Automate |
SQL (Query & Programming)
Power BI | Adv. DAX | Power Apps | Power Automate |
SQL (Query & Programming) | VBA | Python | Web Scrapping | API Integration
Power Apps | Power Automate | SQL | VBA | Python |
Web Scraping | RPA | API Integration
Technology Professionals
Power BI | DAX | SQL | ETL with SSIS | SSAS | VBA | Python
Power BI | SQL | Azure Data Lake | Synapse Analytics |
Data Factory | Databricks | Power Apps | Power Automate |
Azure Analysis Services
Microsoft Fabric | Power BI | SQL | Lakehouse |
Data Factory (Pipelines) | Dataflows Gen2 | KQL | Delta Tables | Power Apps | Power Automate
Power BI | Power Apps | Power Automate | SQL | VBA | Python | API Integration
New
Home | About Us | Contact Us
ExcelGoodies WorldwideUK | USA | Australia | Singapore | Phillipinnes
Power BI
Published by Excelgoodies · 3 years ago
Well, the end-purpose of both tools is to help business users with high-end
reporting.
Where
does the
difference lie? The changing.…Read More
Excel VBA
Published by Excelgoodies · 8 years ago
The below code will add serial numbers up to 500 in your sheet and along with it
will
show progress on the
status bar. Sub progressStatusBar()
Application.StatusBar=
“Start
Printing the…
Read More
Microsoft Excel
Published by Excelgoodies · 8 years ago
For some of you this is already known, but I know there are users who are not
aware
of
the
power of the Paste Special Dialog. Suppose you have been…
Read More
Power BI
Published by Excelgoodies · 1 months ago
DAX (Data Analysis Expressions) is a formula language used in Power BI for creating calculated columns and measures. While DAX is a powerful tool for data analysis, it can be tricky to use correctly.
Keep ReadingPower BI
Published by Excelgoodies · 1 months ago
Introduction: In the world of data analysis, the ability to extract meaningful insights from vast amounts of information is crucial. That's where Data Analysis Expressions (DAX) comes in—a powerful language used in tools like Power BI and Excel. DAX provides a versatile framework for creating advanced calculations, aggregations, and data transformations. In this blog, we will explore common scenarios and solutions using DAX patterns to enhance your data analysis capabilities.
Keep ReadingVBA & Python
Published by Excelgoodies · 1 months ago
VBA for Web Development: Creating Dynamic Web Pages
Keep ReadingVBA & Python
Published by Excelgoodies · 1 months ago
PIVOT tables are a great way to summarize data but sometimes it is important to be able to split a PIVOT table out, generating multiple reports based off all the…
Keep ReadingExcel Formulas
Published by Excelgoodies · 1 months ago
Leading spaces can cause major issues with automated reports and Excel lookups as values that might have been set previously no longer match what is in the data. Imagine if…
Keep Reading