Power BI | MS-SQL | DAX | Power Apps | Power Automate
Power BI | MS-SQL | ETL with SSIS | VBA | Python
Advanced Excel | MIS Reporting | Power Query
VB Programming | VBA | MS-Office Automation
Power BI | Power Pivot | Power Query | Basic DAX
Advanced Excel | MIS Reporting | Model Building
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 · 21 days ago
If you've been thinking about picking up data skills, enrolling in a Power BI course online with certificate might be one of the smartest moves you can make this year. Whether you're a complete beginner or someone looking to level up, here are five solid reasons to consider it.
Keep ReadingPower BI
Published by Excelgoodies · a month ago
Well, the end-purpose of both tools is to help business users with high-end reporting. Where does the difference lie? The changing role of Business Users from just “receiving” the powerful…
Keep ReadingPower BI
Published by Excelgoodies · a month ago
In the realm of data-driven decision-making, the ability to transform raw data into actionable insights is a superpower possessed by those who harness the magic of tools like Power Query.
Keep ReadingPower BI
Published by Excelgoodies · a month 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 · a month 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 Reading