Skip to content

Key Takeaways from TEA Tarik Talk - ACL And ... Or Tableau?

Key Takeaways from TEA Tarik Talk - ACL And ... Or Tableau?

Throwback -TEA Tarik Talk in ACL And ... Or Tableau?

 

We are proudly announcing it was a successful session not to be missed by Data Analyst professionals. 

 

For those who did not manage to attend the conference, we have put together a handy recap of the key TEA Tarik Talk in ACL And ... Or Tableau? discussion points for you.

 

 
  1. Definition of data is - facts or information used usually to calculate, analyze, or plan something. See more meanings of data. How to use data in a sentence.

  2. Types of data:
    tea1

  3. 4 Types of Data: Nominal, Ordinal, Discrete, Continuous
    1. Nominal - These are the set of values that don’t possess a natural ordering. Let’s understand this with some examples. The color of a smartphone can be considered as a nominal data type as we can’t compare one color with others.
    2. Ordinal - These types of values have a natural ordering while maintaining their class of values. If we consider the size of a clothing brand, then we can easily sort them according to their name tag in the order of small < medium < large. The grading system while marking candidates in a test can also be considered as an ordinal data type where A+ is better than B grade.
    3. Discrete - The numerical values which fall under are integers or whole numbers are placed under this category. The number of speakers in the phone, cameras, cores in the processor, the number of sims supported is some of the examples of the discrete data type.
    4. Continuous - The fractional numbers are considered as continuous values. These can take the form of the operating frequency of the processors, the android version of the phone, Wi-Fi frequency, temperature of the cores, and so on.

  4. What is data analytics?

    tea2Data analytics is the science of analyzing raw data to make conclusions about that information. Many of the techniques and processes of data analytics have been automated into mechanical processes and algorithms that work over raw data for human consumption.


  5. Definition of ACL Analytics

    tea3
    Audit Command Language (ACL) Analytics is a data extraction and analysis software used for fraud detection and prevention, and risk management. It samples large data sets to find irregularities or patterns in transactions that could indicate control weaknesses or fraud.

  6. Advantages of ACL
    1. Ease of use: Does not require high technical knowledge to use ACL Analytics
    2. Read-only Data: Once the data is imported into ACL, the user will not be able to edit or make changes to the records in the table. Other than that, the imported table does not affect the raw data (Data integrity).
    3. Function & Command: Plenty of useful commands to assist users in data analysis. Ex: DUPLICATE, GAP, JOIN, RELATE, SUMMARIZED.
    4. Ability to handle large amount of data: ACL has no limitation in terms of handling large datasets. It only depends on user’s hardware resources.
    5. Ability to integrate with different systems: ACL have most of database connector in the market that using ODBC. So, importing data from databases is seamless and secure when using ACL.
    6. Log file: ACL will capture all steps that user clicked. So, users won’t lose all your works. Log files also helps to ease the process of building automation.

  7. Tableau definition is - a graphic description or representation: picture. How to use tableau in a sentence.

  8. Advantage of using tableau
    1. Quick Visualization: Users can create an extremely interactive visual representation by using the drag and drop functions of Tableau.
    2. Comfortable implementation: There are various types of visualization options in Tableaus. This enhances the user’s experience. Tableau is easy to learn in comparison to Python. Those who don't have any experience or knowledge in coding, can also quickly learn Tableau.
    3. Mobile-friendly: There is an accomplished mobile app available for IOS and Android which adds mobility to Tableau users and allows them to keep statistics at their fingertips. The app supports the majority of functions that a desktop or online version has.
    4. Handle large datasets: Tableau can handle millions of rows of data with ease. Users can create different types of visualization, using large amounts of data, without disturbing the performance of the dashboards. Additionally, there is an option in Tableau that can go 'live' to connect with different data sources like SQL, etc.
    5. Data integration with different systems: The software supports establishing connections with many data sources, such as HADOOP, SAP, and DB Technologies, which improves data analytics quality and enables the creating of a unified, informative dashboard. Such a dashboard grants access to the required information for any user. Ref: https://help.tableau.com/current/pro/desktop/en-us/exampleconnections_overview.htm#
    6. Quick insights: The ability to develop a visualization by just applying the drag and drop method really helps the user to quickly understands the data.

  9. Concept of data access & data cleansing

    tea4

  10. Analytic result workflow

    tea5
    a) List all you need
    b) Get the sense of the data structure (name of the table, fields….)
    c) Grab the relevant …select the initial data set (join of a table of data set)
    d) Play with the data (visualize your data, filter, comparison with another table
    e) AHA – have a strong moment 0f complexity with your columns (what you need to add on in your visualization later)
    f) Share the insight (data that you applied can share with other departments)

  11. What is the difference? ACL Analytics and Tableau
    1. It has a difference. Not a competitor. It will complement each other with the data analytic process
    2. Enhance the user experience with the analytics capability.
    3. Centralized your analytics tools
    4. Can ensure ACL project to the tableau (no security issue)

 

 

For more info, kindly speak to our representative:

Email: beassured@assuringgroup.com

Mobile: 03-3855 0225

ASSURING CONSULTING SDN BHD

 

Follow us on our SOCMED :

Instagram: https://www.instagram.com/AssuringCircle/

Twitter: https://twitter.com/AssuringCircle

LinkedIn: https://www.linkedin.com/company/AssuringCircle/

Facebook: https://www.facebook.com/AssuringCircle