The data warehouse is the core of the Business Intelligence system. Being a database administrator in my previous job, I managed various data warehouses that used to provide meaningful insights into business decision making, data analysis and reporting-for example, the sales reports and sales trends. The data warehouse is not…

I updated my current Power BI Desktop version via the Windows Apps Store recently, and now it is a good time to share the new user interface (UI) of the Power BI after the installation. In the year 2019, during my Specialized Diploma study, the Power BI Desktop skinning was…

Recently, I get access to the abundance of online learning resources for Microsoft Power BI. I learned the fundamental of using the Power BI in my Specialized Diploma course. Now, it is a good time to recap what I have learned. So, what is Power BI? It is a Microsoft…

My colleague from the Business Operation texted me one morning and asked me where she can get insights, understand some of the terminologies, the difference between the SQL and NoSQL, and make a decision which type of database to use. Instantly, I replied, “get it from me!” …

The business intelligence and analytics architecture divides into three types of analytics. Descriptive Analytics The traditional analytics that we have been doing for years which covers from raw data from various data sources, clean and summarize the data into a data warehouse to prepare standard reports and ad-hoc reports. These…

I wrote about the Introduction to Kafka a while ago without touching the technical side of it and its use cases. I will not explain in detail for each use cases for now. There are couples of jargons to be familiar with this blog. …

The idea came about when we have multiple source systems and target systems, and the integrations need to write many different configurations. Each of these configurations comes with difficult around: Protocol — how the data is transported (example: HTTP, REST, TCP, etc.). Data format — how the data is parsed…

Last year, I applied to study for a part-time course at one of the Singapore polytechnic schools. I submitted two applications, Specialized Diploma in Big Data Management and Specialized Diploma in Business Intelligence and Business Analytics. In the end, I received an offer letter. I got offered the latter one. …

During a check on the Database Engines ranking just now, I found that this link is listing the available database management systems according to their popularity. The website updates monthly and you able to see the current ranking, previous month ranking, and the ranking one year ago.