Category: Uncategorized

Categories
Uncategorized

Tableau Public

Tableau Public is great for learning Tableau. It is free to use, but the limitation is that all the dashboards that you create needs to be public, and have public datasource. If you need to have different connections, and have private data, that means you will need the Tableau Desktop application. But when you are just learning and want to have a public portfolio of your work, that in this case it is really great. Also you can participate in #MakeoverMonday or Workout Wednesday.

Sources and links:

more details about differences between desktop and public

https://www.makeovermonday.co.uk/

http://www.workout-wednesday.com/challenge-insights/

https://data.world/makeovermonday

Categories
Uncategorized

Tableau – Overview of Theory

Tableau is data visualization tool used in the business intelligence industry.

Basic concept

Tableau has these data types: number, string, geographic, date, date time, boolean.

Dimensions are a qualitative fields that describe categories of data. Independent values. The pane is created when you have multiple dimensions in a row or column.

Measures are a quantitative or numerical fields, that measure categories of data. Dependent values.

Measure Name is a dimension, that contains a label for each measure in the data source.

Measure Value is a measure that contains numerical values of each measure in the data source.

Latitude and Longitude are generated geo fields, and it is generated when data source contains geographic fields.

Discrete fields – create headers/labels, can be sorted, always represented in blue color.

Continuous fields – create axis, can’t be sorted, always represented in green color.

Aggregation – measures are aggregated by default, default aggregation is sum. Measures can have following aggregations: sum, average, median, count, count distinct, minimum, maximum, percentile, std.dev, std.dev (pop.), variance, variance (pop.).

Aggregation and granuality – dimensions break down the aggregated total into smaller totals by category. Dimension provides the granuality in a chart.

Aggregating the dimensions – minimum, maximum, count, count distinct. When you aggregate a dimension, it is created a new temporary measure column.

Ratio calculations for example – sum(profit)/sum(sales) sums the profits and sales to whatever the granuality of the view is, and then compoutes the ratio at that aggregation. Profit/Sales computes the profit ratio at the lowest level of granuality then sums the ratios to the requested aggregation of the view.

Basic Chart Types

Bar chart – compare data across categories. Example – sales across different products.

Line Chart – shows trends in data over time. Example – Profit between 2012-2014 as per the order date.

Scatterplot – demonstrate the relationship between measures. Example- relationship between profit and sales.

Maps – two maps types – symbol maps and filled maps. The symbol maps use the symbols to represent a central point of a geographic region whereas in filled pam boundaries of a geographic region is filled with a color.

Combined Axis Chart – is created with one shared axis (X-axis) and two separete axes (Y-axes). Placing measures on the same axis allows you to build a view that compare these measures using one chart.

Dual Axis Chart – compars multiple measures in a graph. Dual axes are two independent axes.

Stacked Bar – is the bar chart with segmented bars.

Crosstab, Highlight table – crosstabs are also known as Text tables. A highlight table encodes a measure on Text and color on Marks card.

Histogram – shows the frequency of distribution. It displays the shape of the distribution.

Categories
Uncategorized

Splunk – User Exam Preparation

Exam Outline

The Splunk core certified user exam covers eight domains:

  • Splunk Basics – 5%
  • Basic Searching – 22%
  • Using Fields in Searches – 20%
  • Search Language Fundamentals – 15%
  • Using Basic Transforming Commands – 15%
  • Creating Reports and Dashboards – 12 %
  • Creating and Using Lookups – 6%
  • Creating Scheaduled Reports and alerts – 5%

Example questions

  1. What are the main components of Splunk?
    1. Splunk forwarder, indexer, search head
    2. Splunk indexer, heavy forwarder, search head
    3. Splunk indexer, deployment manager, forwarder
    4. Splunk heavy forwarder, deployment manager, splunk indexer
  2. When you install Splunk on a stand-alone machine, which components are on it?
    1. input data
    2. parser
    3. indexer
    4. all of the above
  3. When you install the Splunk Enterprise free 60-day trial version, what is you daily index size?
    1. 100 MB
    2. 500 MB
    3. 750 MB
    4. 1000 MB
  4. A ………….. displays statistical trends over time.
    1. chart value
    2. time series
    3. stats value
    4. table value
  5. The …………. command can display any series of data you want to plot.
    1. chart
    2. stat
    3. time chart
    4. both 1 and 2
  6. Which are filtering commands in Splunk?
    1. where, dedup, and head
    2. dedup, head, and tail
    3. where, dedup, and tail
    4. all of the above
  7. A transaction is a grouping command.
    1. true
    2. false

More about exam

Notes:

  • Splunk basics – componets, usages, apps, add-ons, customizing user settings, basic navigation in Splunk.
  • Basic Searching – run basic search, time range, search results, refine searches, timeline, events, search job, save search results.
  • Using Fields in Searches – fields, fields in searches, sidebar.
  • Search Language Fundamentals – general search practices, basic search commands, search pipeline, indexes in search, table, rename, fields, dedup, sort.
  • Using basic transforming commands – top, rare, stats.
  • Creating Reports and Dashboards – save a search as a report, edit reports, create reports to display statistics, visualizations, charts, add a report to a dashboard, edit dashboard.
  • Creating and Using Lookups – lookups, lookup file, lookup definition, automatic lookup, lookup in searches.
  • Creating Scheaduled Reports and Alerts – scheduled report, configuration of scheduled reports, alerts.

Sources

Sources (Examples of questions):

  • https://docs.splunk.com/Documentation/Splunk/8.1.2/SearchReference/Stats
  • https://www.apress.com/gp/book/9781484266687
  • https://docs.splunk.com/Documentation/Splunk/latest/SearchReference/Transaction

Some sources for test preparations:

  • https://www.testpreptraining.com/tutorial/splunk-core-certified-user-splk-1001/
  • https://vceguide.com/splunk/
  • https://www.examtopics.com/exams/splunk/splk-1001/view/
  • https://www.itexams.com/info/SPLK-1001
  • https://www.itexams.com/exam/SPLK-1001

Exam: – https://wsr.pearsonvue.com/