WELCOME

Tutorials on the Tutorial Academy

Our objective is to provide a high-quality online learning experience that empowers individuals to acquire new skills, expand their knowledge, and achieve their personal and professional goals. Through our platform, we aim to make learning accessible to everyone, regardless of their location or schedule, by offering a wide range of courses and learning resources that are engaging, interactive, and flexible. We are committed to providing a supportive and inclusive learning environment that encourages collaboration, innovation, and growth, and to continuously improving our platform and services to meet the evolving needs of our learners. Our ultimate goal is to help individuals unlock their full potential and transform their lives through learning.

We are continuously amassing our academy with more and up to date tutorials. We advance our site with advances in technology, profession, and human thinking. We have a plan in place to add popular learning areas from the best tutors. We cover many topics such as Tableau, SQL, Java, SEO, and more. Start we some notes on Tableau. We invite you to follow our pages on Youtube for more detailed learning.

Tableau from Beginners

We provide both textual and video-based Tableau training. Our training starts with an absolute beginner and goes along to an advanced level.

In the Tableau tutorial, we covered the following topics and areas. You can watch all our tutorials on our YouTube channel or on our website without being interrupted.

Why Tableau?

It is a Market-leading choice for modern business intelligence. Tableau platform is known for connecting to many data sources. It can easily turn into actionable insights with speed and ease. Tableau offers easy functionalities that can be tuned to all. Tableau has a vibrant Global data community with unparalleled support. For more click here.

Analyzing data that is stored in a crosstab format can be difficult in Tableau. Pivoting is required to change the data format from crosstab to columnar format. Mostly used Microsoft Excel, text files, Google Sheets, and .pdf data sources. UNION ALL can also be used in code to pivot data sources in the Tableau desk. Do you need more? Go here.

  • Data Interpreter

Data Interpreters can give you a hand in cleaning your data. It can detect things like titles, notes, footers, empty cells, etc, and bypass them to pick the correct data fields and values in your file. It can detect additional tables and sub-tables to help you work on a subset of your data independently of the other data. After Data Interpreter has done its magic, you can check your file. For more information please check here.

Join and Blending in Tableau

Join and blending are two ways of combining data from multiple sources in Tableau. Both methods are used to bring data together to create a more comprehensive view of the data.

Join:
Joining is a method of combining data from multiple tables that have a common field or key. In Tableau, joining is done by connecting to two or more tables that share a common field, and then creating a join relationship between them. Once the join relationship is established, Tableau combines the data from the tables based on the common field or key, creating a single table that can be used for analysis. Joining is useful when the data sources have a similar structure and when the user needs to perform calculations and analysis across the combined data.

Blending:
Blending, on the other hand, is a method of combining data from multiple sources that cannot be joined together. Blending is done by connecting to two or more data sources, and then creating a relationship between them based on a common field. However, unlike joining, blending does not create a single table. Instead, it combines the data from the sources on a sheet-by-sheet basis. This means that each sheet in Tableau can have its own blend relationships. Blending is useful when the data sources have different structures, and when the user needs to keep the data sources separate, but still wants to compare and analyze them.

In summary, joining is used to combine data from multiple tables with a common field or key, while blending is used to combine data from multiple sources that cannot be joined together. Joining creates a single table, while blending does not. The choice between joining and blending depends on the data sources and the desired analysis. If the data sources have a similar structure and can be joined, joining is usually the best option. If the data sources have different structures or cannot be joined, blending may be the best option.

  • Join vs blending additional note
    • Join is common- inner(default), Left, Right, and outer
    • Blending is used as left (only) join. Blending is used for two or more data sources. The files do not need to have the same details. Join is used for the same source data(Excel and excel tabs)
  • Filters in Tableau. Tableau is a powerful data visualization tool that allows users to explore and analyze their data in many ways. One of the key features of Tableau is the ability to filter data, which allows users to focus on specific aspects of their data and extract insights more efficiently. There are several types of filters in Tableau, each with a different purpose and use:
  • Dimension Filters: Dimension filters allow users to filter their data based on one or more dimensions in their data set, such as product category, region, or date. Users can select one or more values from a list of available options or use a search box to find specific values. Dimension filters can be applied to individual sheets, dashboards, or the entire workbook.
  • Measure Filters: Measure filters allow users to filter their data based on one or more measures in their data set, such as sales revenue, profit, or quantity sold. Users can set a range of values or use a condition to filter the data. Measure filters can be applied to individual sheets, dashboards, or the entire workbook.
  • Context Filters: Context filters are a type of dimension filter that allows users to create a temporary subset of data to improve performance. Users can select one or more dimensions to create a context filter, and Tableau will perform the analysis on the filtered data first, before applying other filters or calculations.
  • Top Filters: Top filters allow users to filter their data based on the top or bottom values of a measure. Users can select the number of values to show or set a specific threshold. Top filters can be applied to individual sheets or dashboards.
  • Relative Date Filters: Relative date filters allow users to filter their data based on a specific time period, such as the last 7 days or the next 3 months. Users can select a relative date range or create a custom range. Relative date filters can be applied to individual sheets or dashboards.
  • Interactive Filters: Interactive filters allow users to filter their data by interacting with the visualization itself. Users can click on a data point or select an area on the visualization to filter the data dynamically. In summary, filters are a powerful feature of Tableau that allow users to focus on specific aspects of their data and extract insights more efficiently. By using different types of filters, users can filter their data based on dimensions, measures, top or bottom values, relative dates, or by interacting with the visualization itself.

File Formats in Tableau

Tableau provides several output file formats for exporting and sharing data visualizations and analysis results. These file formats allow users to share their insights and findings with others or use the data for further analysis.

Here are some of the commonly used output file formats in Tableau:

Tableau Workbook (.twb):

Tableau Workbook is the native file format used by Tableau to save and share workbooks. A Tableau Workbook file contains all the worksheets, dashboards, and data connections used in the analysis. Tableau Workbook files are binary files and can only be opened in Tableau. But one can download files from Tableau in the following formats.

Tableau Packaged Workbook (.twbx):

Tableau Packaged Workbook is a compressed file format that contains all the data and metadata used in the analysis, along with the worksheets, dashboards, and data connections. Tableau Packaged Workbook files can be opened in Tableau Reader or Tableau Desktop. They can be shared with others without the need for a Tableau Server or Tableau Online account.

PDF (Portable Document Format):

PDF is a widely used file format for sharing documents and reports. Tableau allows users to export visualizations and analysis results as PDF files, which can be opened in any PDF reader.

Image formats (PNG, JPEG, BMP, SVG):

Tableau allows users to export their visualizations as image files, such as PNG, JPEG, BMP, or SVG. Image files are useful for sharing visualizations on websites or including them in presentations or reports.

Microsoft Excel:

Tableau allows users to export their data as an Excel file, which can be opened in Microsoft Excel or other spreadsheet applications. Excel files contain the raw data used in the analysis, and they can be further manipulated or analyzed in Excel.

Microsoft PowerPoint:

Tableau allows users to export their visualizations as PowerPoint slides, which can be opened in Microsoft PowerPoint or other presentation software. PowerPoint files are useful for creating presentations that include data visualizations.

In summary, Tableau provides several output file formats for exporting and sharing data visualizations and analysis results, including Tableau Workbook, Tableau Packaged Workbook, PDF, image formats, Microsoft Excel, and Microsoft PowerPoint. Each output file format has its unique characteristics and use cases, and choosing the right file format depends on the intended use and audience.

Additional summary note:

  • .twb
    • Tableau workbook files have the .twb file extension.
    • Workbooks hold one or more worksheets,
    • It may contain a single worksheet and/or stories
  • .tbm
    • Tableau bookmark files have the .tbm file extension.
    • Bookmarks contain a single worksheet and are an easy way to quickly share your work.
  • .twbx
    •  has the .twbx file extension.
    • It is a single zip file that contains a workbook along with any supporting local file data and images.
    • This format is the best way to package for sharing
    • all documents included for those who don’t have access to the original data.
  • .tde
    • A compressed/optimised snapshot of data stored on disk
    • Tableau can query data that is bigger than the available RAM on a machine-OS moves data in and out
    • The extract is fast to load
    • The extract will need to be refreshed to receive updates
  • .tds
    • Tableau data source files have the .tds file extension.
    • Data source files are shortcuts for quickly connecting to the original data that you use often.
    • Data source files do not contain the actual data
    • Data source files contain the information necessary to connect to the actual data
  • .tdsx
    • The file has the .tdsx file extension.
    • A packaged data source is a zip file that contains the data source file such as (.tds) well as any local file data such as extract files.
    • We use the (.tdsx) format to create a single file that we can share with others
    • Receivers get access to the original data stored locally on your computer. 

Excel Tutorial for Oromo Speakers

In the Excel tutorial, we covered all the basic Excel features. We discussed cells, columns, rows, and any values in them, manipulating cell and sheet values, editing, formatting, and replacing.

We covered all basic Excell tabs and functions and features on these tabs. We also covered basic arithmetic calculations using formulas. We included activities and projects across the way and at the end of the tutorial.

Tutorials on SQL from the beginning

We have SQL tutorials in the Oromo language. This tutorial is to help Oromo speakers to comprehend and understand the concept of databases and RDBMS.

In the SQL tutorial for beginners, we covered the basic concepts and syntax of SQL, as well as provided practical examples and exercises to help learners apply what they have learned.

Introduction to SQL:

The introduction to SQL and its use cases, including an overview of relational databases and their components.

Data manipulation:

The tutorial covers the basics of data manipulation in SQL, including selecting, filtering, sorting, and aggregating data.

Creating and modifying tables:

We covered how to create and modify tables, including adding columns, changing data types, and setting constraints.

Joins:

The lesson covers how to join tables together using different types of joins, including inner join, left join, right join, and full outer join.

Subqueries:

We will see how to use subqueries to perform complex queries and filters.

Functions:

We will include the use of SQL functions, including string functions, numeric functions, and date functions.

Grouping and aggregation:

The tutorial covers how to use grouping and aggregation to summarize and analyze data.

Stored procedures:

Your learning covers how to create and use stored procedures in SQL to execute frequently used queries.

Transactions:

The tutorial covers how to use transactions to ensure data consistency and integrity.

Practice exercises:

Our tutorial will provide practical exercises and examples that allow learners to apply what they have learned and build their skills.

In summary, a SQL tutorial for beginners covers the basic concepts and syntax of SQL, as well as provides practical examples and exercises that allow you to build your skills and apply what you have learned. By covering these key topics, you can gain a solid understanding of SQL and its use cases.

Oromo Language for Non-speakers

In this tutorial, we touched on all the important grammatical rules that are used to read and write the Oromo language. This tutorial is directed to people who do not talk the Oromo language but like to learn the language.

The tutorial is, then in the English language. We believe that people should understand the rules of language and grammar before they can use it. Once they master the roles, they can move to the advanced tutorials in the Oromo language.

If you need more information please contact us.

Back To Top