A common symptom of organizations operating at suboptimal performance is when there is a prevalent challenge of dealing with data fragmentation. The fact that enterprise data is siloed within disparate business and operational systems is not the crux to resolve, since there will always be multiple systems. In fact, businesses must adapt to an ever-growing […]
Posts Tagged ‘BI’
SQL Best Practices and Performance Tuning
The goal of performance tuning in SQL is to minimize the execution time of the query and reduce the number of resources while processing the query. Whenever we run the query, performance depends on the amount of data and the complexity of the calculations we are working on. So, by reducing the no of calculations […]
What is Bravo for Power BI?
What is Bravo for Power BI? Bravo studio is a design before, no code tool which allows you to turn your app designs and prototypes into real publishable mobile apps (both iOS and Android). You can use Bravo to build even complex apps by connecting your design to external tools via APIs. In this blog, […]
Introduction to “Export to PDF” in Power BI Desktop
Microsoft has released the feature Export to PDF option from Power BI Desktop. This feature has been available in every update of the Power BI desktop since August 2018. Read to explore this option and how to use it. Now, let’s get started. The following screenshot refers to the sample of my report. How To […]
Power BI: Merge and Append Queries
Introduction: Power BI’s merging and appending operations allow you to join data from multiple tables. The choice between the merge and append queries depends upon the type of concatenation you want to carry out based on your requirement. When you have one or more columns that you’d like to add to another query, then you […]
Drill Down Feature in Power BI
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 […]
Analytics with Incorta using 3rd Party Tools
Incorta provides a comprehensive platform for data Acquisition, Data Enrichment, and Data Visualization. It can be a one-stop for all your data needs, but it can also be combined with other BI Visualization tools to enhance the experience even further. Incorta provides a Postgres connection to connect other 3rd party Visualization tools like Power BI, […]
Why Implement Incorta Analytics for Oracle Fusion Cloud ERP Reporting?
Oracle Cloud ERP offers several built-in tools for reporting. While native reporting tools like Oracle Transactional Business Intelligence (OTBI) and Oracle BI Publisher are well-suited for specific types of operational reporting, they do have limitations when it comes to performing complex and enterprise-wide reporting. It is therefore crucial to complement the Oracle Cloud ERP application […]
Creating & Invoking Custom Function in Power Query
Microsoft’s Power BI is a data and analytics reporting tool that lets you connect to multiple data sources. Once connected to a data source, raw data sets can be converted to dashboards and presented to the team, customer, anyone at any time. In this blog, we will get introduced to the custom function feature available […]
5 Snags to Avoid When Modifying Seeded Oracle Fusion Reports
Oracle Cloud Applications provide many predefined reports to generate important documents necessary for running a business. These documents support internal operations, communicate with trading partners, or produce legal documentation. Still, they almost always require modifications to include company branding or rearranging and adding data elements to appear similar to legacy documents. Thoughtfully, Oracle Fusion provides […]
HyperIntelligence – Let the answers find you
While Most of the people are happy with the current solutions provided by MicroStrategy there are still many who are looking for better solutions that can work in a better manner with their current infrastructure and can help with the largely growing data of the organization. “Expect epic” was one of the tag lines at […]
Microsoft Teams and Power BI – Analytics Hub and Content Management
Hub is a logical/physical space where everyone comes searches content, deciphers information, looks for viable information, lineage etc. Microsoft is enabling a similar concept in Teams. Teams is where we all have begun to collaborate via virtual meetings, notes, lists, apps etc. The future vision and big picture is to treat Teams as a single […]