Analytics

I will be sharing my personal experience with learning Power BI and clearing the PL-300 (Earlier called DA-100) exam. I hope this will help the other aspirants. I would not be compromising the signed NDA; hence no questions will be disclosed in this article. About the Exam : PL-300: Microsoft Power BI Data Analyst Analyzing […]

Paginated Reports are the same as SSRS, which have come to Power BI with advanced features for better reports. Paginated Reports are well designed & formatted reports which are perfectly sized so we can print and share the reports effectively. We can also load images and charts on these reports. We can create highly formatted […]

So Many BI Charts, but which one to choose and when? This blog series will help you understand each chart’s uses and properties. This is the second blog in a series about data visualization. Read the first blog in the series here. 10. Area Chart An area chart is essentially a line chart — good […]

The Data and AI Summit 2022 had enormous announcements for the Databricks Lakehouse platform. Among these, there were several exhilarating enhancements to Databricks Workflows, the fully managed orchestration service that is deeply integrated with the Databricks Lakehouse Platform and Delta Live tables too. With these new efficacies, Workflows enables data engineers, data scientists and analysts […]

Pagination is a great way to improve the user experience and minimize the footprints that tables occupy within Tableau dashboards. In cases, where we need to show multiple records or our tables are too long to display it in single view, pagination comes to rescue. By implementing this technique, users will be able to “turn […]

So Many BI Charts, but which one to choose and when? This blog series will help you understand each chart’s uses and its properties. To determine how to pick the right chart for your data visualization needs, first, you must answer a few questions: How many variables do you want to show in a single […]

Snowflake is Cloud hosted relational database used to create Datawarehouse on demand. Data in the data warehouse can be loaded as full load or incremental load. The full load is a process of deleting whole existing data and reloading it again. Full loads are time and resource-consuming tasks compared to incremental loads that only load […]

What is Drill Down in Power BI? In Power BI, Drill Down is nothing but the next level of hierarchical insights of the data. For example, when you want to see a year-wise sales summary, you may want to look into the “Monthly” summary, “Quarterly Summary,” and day-wise summary. So, this is where the drill-down […]

In advance Power Bi scenarios , All of us have created dynamic slicers using measures. the dynamic slicers works on factual values because we use Measures in there. But what if we want the same slicer to represent Dimensions dynamically? Well, here is the step by step solution for the same. Without using single DAX […]

In our last post we discussed the linkages between Journal Entries and the source transactions in Accounts Payable, Accounts Receivable, and Fixed Assets.  This post continues the discussion with the linkages for the Purchasing, Project Accounting, and Cost Management applications. As noted in the prior posting, since most organizations employ summary posting of Journal entries, […]

Background Core of any BI tools is to acquire business data from multiple sources and then to co-relate it for quality reports & dashboards. Information Technology is being dominantly used for business processes from last 20 years. Volume of data has grown a lot. Businesses have shifted to enterprise database platforms like SQL Server, Oracle, […]

As the numbers of mergers and acquisitions continue to rise, the majority still fail to realize their intended value. Following best-practices and using third party support can help increase your chances of success. Perficient’s wide variety of tools and assets in the following eight capability categories help complement and drive the overall success of a […]