Among predominant BI tools in the list which I have attached in the previous post, I have selected two of them. One is power BI form Microsoft and one is Alteryx. For power BI, there is no further issue connecting to SQL server. I can get started discovering this tool. However, Alteryx has two serious […]Read more "PRJ-WEEK6-DAY2-Select Alteryx, First TwoProblem"
I get started on diving into BI tools which have been using among the worlds thanks to their friendly user interface and a huge collection of functions supporting business users and developers. This provides a whole scenario for BI tools market in the world. From this point, I will put an effort to figure out […]Read more "PRJ-WEEK6 DAY1-BI List"
Self-Service Analytic is not a totally new definition to the whole data citizen, but it, in fact,has limit academic papers talking about it. I have spending time seeking material reference. Fortunately, I found several pdf book. One describes how we can implement Self-Service Analytic in the context of organization after data design suiting specific department. […]Read more "PRJ-WEEK5 DAY2- Material Research"
The project stems from my craving for the development in database as junior DBA which requires a variety of skills and deep insight into SQL Server, Oracle and practical knowledge dealing with data. In my project, I pay attention to gain precious understanding of Self-service Analytic. This is an update proposal from the last one. […]Read more "PRJ-WEEK5-DAY1- New Version of Proposal"
Todd has given a comprehensive exercise for the acceleration in NaLer, which enhances practical knowledge to apply this explanation to actual modelRead more "WEEK6-DAY1-NaLER"
In the process of optimizing data storage, Normalization could not ignore in any aspects. It puts a premium on organizing attributes of tables in relational database to minimize redundancy, which involves larger tables into smaller ones and defining the relationship between them It is actually a fundamental insight when I place a seat in DAT502 […]Read more "WEEK5-DAY2- NORMALIZATION"