New

Power BI

Is Power Bi, the silent death of SSRS?

Published by Excelgoodies · 4 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

How to Show Progress on Status Bar using VBA?

Published by Excelgoodies · 9 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

Power of Paste Special – Multiply

Published by Excelgoodies · 9 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 Query

Case Study: Transforming Raw Sales Data using Power Query

Published by Excelgoodies · 2 years 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 Reading

Power Query

10 Must-Know Features of Power Query That Excel Users Shouldn't Miss

Published by Excelgoodies · 3 years ago

In the dynamic world of data analysis, Excel users seeking to amplify their data manipulation and reporting skills have a secret weapon: Power Query. This transformative tool has the power to turn complex tasks into seamless processes, allowing users to effortlessly transform raw data into meaningful insights.

Keep Reading

DAX

10 Common mistakes to avoid while using DAX in Power BI.

Published by Excelgoodies · 3 years 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 Reading

DAX

DAX Patterns: Common Scenarios and Solutions for Advanced Data Analysis

Published by Excelgoodies · 3 years 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

Power Query

Power Query: For Powerful Financial Reporting

Published by Excelgoodies · 3 years ago

In the fast-paced world of finance, where precision and accuracy reign supreme, financial reporting holds the key to informed decision-making. Enter Power Query, the unsung hero that has redefined how financial professionals approach reporting.

Keep Reading

Fill-in the details.

Business Professionals

Techno-Business Professionals

Technology Professionals

Is Power Bi, the silent death of SSRS?

How to Show Progress on Status Bar using VBA?

Power of Paste Special – Multiply

Case Study: Transforming Raw Sales Data using Power Query

10 Must-Know Features of Power Query That Excel Users Shouldn't Miss

10 Common mistakes to avoid while using DAX in Power BI.

DAX Patterns: Common Scenarios and Solutions for Advanced Data Analysis

Power Query: For Powerful Financial Reporting