This day in age, apps are all around us. From our phones to our laptops, even in stores and restaurants, we can sometimes find apps. An app supports business processes in consulting balances, inputting records, grouping products, activity planning and making prognoses. However, to make those apps, someone with the right expertise needs to spend […]
Month: July 2022
Snowflake, a DWH as a Service
‘Cloud’ or ‘Clowned’? With the high adoption of cloud computing in all processes, ‘Analytics’ is the one that can benefit from it the most. Analytics as being it a data warehouse that is used for reporting or ad-hoc analysis, Data Lake which serves as a repository for data that contains added value and Big Data […]
10 performance tips to speed up your Power BI reports
Arriving at work and the first thing you do is opening your Power BI report and going for a coffee while waiting for the report to render. Seems familiar?Well, it shouldn’t. Your reports should render instantly, especially if there is a large or C-level audience consulting them on a regular basis. Luckily enough there are […]
Governed Corporate Power
Best wishes and many Data Insights. Oleon, my client, is at the forefront of the growing market of natural Chemistry. As lead of the Analytics team at Oleon it is my desire to provide useful easy-to-read business driven reports. In a previous article I’ve been pondering on the question SAC vs Power BI ao visualization. Now, […]
Managed Big Data: DataBricks, Spark as a Service
The title accompanying this blog post is quite the mouth full. This blog post will explain why you should be using Spark. If a use case would make sense, then we will introduce you to the DataBricks product, which is available on Azure. Being recognised as a Leader in the Magic Quadrant, emphasizes the operational […]
Lytix’ XTL Framework
You’ll often hear a Lytix consultant say that he/she is proud of our XTL Framework. What is it exactly? And how can it improve your business? Why do I need a Data Warehouse (DWH) ? Data Warehouses support organisations in their decision making by providing data in a well-governed way, this includes: – Integration of […]
Power BI Governator
There’s no denial that Power BI has been maintaining a steep growth since its release in 2015 in terms of capabilities. Consequently, the same positive trend also applies to its community and user base, shifting greater priority towards the art of Power BI governance. Nowadays, companies begin to feel the struggle they’re up against when simultaneously trying […]
Having Power BI on SAP BW using a gateway?
With the on-premises gateway, you can directly connect to your SAP BW system. This allows you to refresh the reports that are in the Power Bi cloud solution. The gateway is very simple to set up. However, if you are not from the US, you will run into one of the following errors. Unable to […]
Keep those Power BI reports in (source) control!
While self-service is an easy way of creating and changing existing reports, organizations may struggle with version control of the reports that are published to a Power BI service. We’ve often heard the sentence “Sh**, I’ve overwritten one of my important reports!”. Yes, this problem can also occur to experienced developers and even consultants of […]
5 Tips for Power BI/Analysis Services to improve the use of Excel
Wow, you may recall our previous post ‘5 tips for Excel users when connecting to Power BI’, its popularity needed us to upgrade our webservers. Luckily we run on azure and could easily scale up Don’t fear, we are more than happy to provide you with five (5!) additional tips to improve your BI environment. In […]