Blogs
-
Power BI Tips: Schedule Refresh on Composite Models
- April 5, 2019
- Posted by: Siva Mani
- Category: Power BI
No CommentsComposite Model is a great feature in Power BI. It allows users to consume data from multiple data sources in different connectivity mode. For example, you can build a model in Power BI Desktop that combines the following types of data,
-
How To Use Custom Python Script In Oracle DVCS
- March 21, 2019
- Posted by: Abishek Venkatakrishnan
- Category: Technology
In this blog, we leverage DV’s new feature of executing Python scripts. The custom Python script for Term Frequency Analysis accepts one text column as input. The script cumulates the text values and then breaks that collection into recognizable tokens and counts the number of times each token has occurred. It gives the term (token) and its corresponding frequency as output.
-
Connect to Incorta in Power BI
- March 20, 2019
- Posted by: Siva Mani
- Categories: Next Gen Analytics, Power BI
Incorta is a Next-generation Analytics Platform. Incorta provides a seamless, end-to-end analytics platform. It removes the dependency on star schemas, pre-aggregation, and complex ETL processes. You can connect to Incorta in Power BI desktop with following steps,
-
Instantaneous Reporting with Incorta
- March 16, 2019
- Posted by: Ananth Thyagarajan
- Categories: ERP Analytics, Next Gen Analytics, Operational Reporting
Does your Business users have to wait too long to get reports from ERP or any other Transactional Systems ?
-
Next Gen Reporting
- March 10, 2019
- Posted by: Ananth Thyagarajan
- Categories: Discoverer, Hyperion IR, Operational Reporting
Organization(s) run ERP systems that use legacy reporting system and are not in a position to come out of their systems due to heavy customizations. Also they are in a precarious situation as some of their reporting software can no longer be supported.
-
“OUT-OF-THE-BOX” ADVANCED ANALYTICS IN DVCS
- February 26, 2019
- Posted by: Abishek Venkatakrishnan
- Category: Technology
Oracle Data Visualization Desktop has the following “out-of-the-box” advanced analytics built in…
-
Power BI Tips: New Filter Pane
- February 6, 2019
- Posted by: Siva Mani
- Category: Power BI
Microsoft Power BI team released a feature with updated filter experience (New filter pane) with Power BI Desktop November 2018 update. The new filter pane feature gives many options to manage filters/filter pane…
-
Power BI Tips: Exasol in DirectQuery mode
- December 25, 2018
- Posted by: Siva Mani
- Categories: Power BI, Technology
We recently explored capabilities of Power BI with Exasol in DriectQuery mode. Interestingly it led us to some positive observations. It performs well and more flexible than Google Big Query. This blog will help you to resolve a few issues which may cause when you try to create BI and analytical report in Power BI with Exasol database in a DirectQuery mode.
-
Connect to Exasol in Power BI
- December 20, 2018
- Posted by: Siva Mani
- Categories: Power BI, Technology
We are in the process of exploring Power BI with different data sources to offer ‘THE’ best business and analytical solutions to our valuable customers. With this approach, we are able to find/showcase Business Intelligence and analytical capabilities of each source with a POC/Demo. We recently started with Exasol in the row.
-
Power BI Tips: Google BigQuery in DirectQuery Mode
- November 18, 2018
- Posted by: Siva Mani
- Category: Power BI
Power BI offers two different modes (Import and DirectQuery) to connect Google BigQuery. For more details about data connectivity modes, check the Cittabase’s blog. There are a few best practices to enhance the performance of the reports which are using DirectQuery mode. This blog will help you to enhance performance with the following steps.