DAT 601- Week 14- Day2

This post shows how to calculate estimated data size in SQL Server Calculate the total row size: Row_Size = Fixed_Data_Size + Variable_Data_Size + Null_Bitmap + 4 The value 4 in the formula is the row header overhead of the data row. Calculate the number of rows per page (8096 free bytes per page): Rows_Per_Page = 8096 / (Row_Size + 2) Because rows do not […]

Read more "DAT 601- Week 14- Day2"

DAT 601- Week 14- Day1

Design Security Mechanisms This step develops the security measures for the database as specified by the users. In design, the security of database resource plays utmost important role, which demands the appropriate configuration of privilege for each user. Design user views: this step helps to design the user views according to logical data models.  Views […]

Read more "DAT 601- Week 14- Day1"

DAT 601- Week 13- Day2

A table or view can contain the following types of indexes: Clustered Clustered indexes are used to sort and store the data rows in the table according to their value. If a table has no clustered index, the data is not stored in an order, which can be called a heap. A clustered index is […]

Read more "DAT 601- Week 13- Day2"

DAT 601- Week 13- Day1

Today we learnt about how to make transaction analysis. Before executing a query in targeted DBMS, this step should be taken into account. In the process of each transaction implementation, users are required to figure out the underlying elements as follow: Expected frequency for each transaction All relation and attributes are required for transaction with […]

Read more "DAT 601- Week 13- Day1"

PRJ702-Week13-Day 4

Now it is time to draw some conclusion about my project. This project focuses on Self-Service Analytic with its merits and demerits when applying it in study cases. Among underlying points that lead SSA to the success, selecting the appropriate BI tools base on their designated functions and the nature of organisation remains fundamental. In […]

Read more "PRJ702-Week13-Day 4"

PRJ702-Week13-DAY 3

In the process of data exploration for Tax mechanism, using R to create dashboard and ad hoc report was the last section Similar to the evaluation with R for Uber, data set extracted data from SQL Server for each kind of data source remain fundamental. In this respect, the query below facilitated the first dataset […]

Read more "PRJ702-Week13-DAY 3"

PROJ702-WEEK13 DAY 2

This post was an attempt to use Power BI to exploit information supply chain of Tax mechanism. This coupled with several analysis that has been implemented by Alteryx and Tableau above. Firstly, Power Bi had a connection to “Customer” and “Individual” table to get started on customer evaluation for this database. The next dashboard revealed […]

Read more "PROJ702-WEEK13 DAY 2"