Self - study tutorials - SIMM.BI

Simbi.tech YouTube Training Videos

Simm BI course - A short introduction

Installation of a browser extension that enables working localy with results.

Install SimmBI service on your computer

Connecting to a source, a database

מבוא – חיבור למסד נתונים

חיבור למסד נתונים

Introduction to AdventureWorks DB

Introduction to AdventureWorks DB

Connecting to a source, a database

Install SimmBI service on your computer

Installation of a browser extension that enables working localy with results.

Simm BI course - A short introduction

Building a model - getting started. Bringing data from the database as part of a model. Example: resellers table from the AdventureWorks DWH.

Adding calculated columns and using functions on data in the model. Example: resellers table from AdventureWorks DWH.

Using aggregate functions in the model. Example: resellers table from AdventureWorks DWH.

Renaming a column and deleting a column in the model. Example: resellers table from AdventureWorks DWH.

Renaming a column and deleting a column in the model. Example: resellers table from AdventureWorks DWH.

Using aggregate functions in the model. Example: resellers table from AdventureWorks DWH.

Adding calculated columns and using functions on data in the model. Example: resellers table from AdventureWorks DWH.

Building a model - getting started. Bringing data from the database as part of a model. Example: resellers table from the AdventureWorks DWH.

Adding a filter to the data in the model. Example: resellers table from AdventureWorks DWH.

Joining tables in the model. Example: products table from AdventureWorks DWH.

Bringing data from Google Sheets into the model. Example: profit goals table.

Grouping a table in the model. Example: profit goals table.

Grouping a table in the model. Example: profit goals table.

Bringing data from Google Sheets into the model. Example: profit goals table.

Joining tables in the model. Example: products table from AdventureWorks DWH.

Adding a filter to the data in the model. Example: resellers table from AdventureWorks DWH.

Bringing data from an API into the model. Example: exchange rates table.

Adding a virtual table (adding a table manually) to the model. Example: exchange rates table.

Implementing a pivot in the model. Example: exchange rates table.

Using the VLOOKUP step in the model.

Using the VLOOKUP step in the model.

Implementing a pivot in the model. Example: exchange rates table.

Adding a virtual table (adding a table manually) to the model. Example: exchange rates table.

Bringing data from an API into the model. Example: exchange rates table.

Using the copy table step in the model.

Using sql query with join to create resellers model. Resellers + Geography tables.

Bringing data into the model from other models. Example: creating a final model from all the models we've created so far.

Inserting data into a database from the model, fixed scheduling for the model, and additional actions that can be performed with model results (such as sending an email).

Inserting data into a database from the model, fixed scheduling for the model, and additional actions that can be performed with model results (such as sending an email).

Bringing data into the model from other models. Example: creating a final model from all the models we've created so far.

Using sql query with join to create resellers model. Resellers + Geography tables.

Using the copy table step in the model.

Introduction to Sakila DataBase, Sakila

Explaining the model for the final assignment

Showing a solution to Model 1 - Customers, Sakila

Showing a solution to Model 2 - Staff Store , Sakila

Showing a solution to Model 2 - Staff Store , Sakila

Showing a solution to Model 1 - Customers, Sakila

Explaining the model for the final assignment

Introduction to Sakila DataBase, Sakila

Showing a solution to Model 3 - Film, Sakila

Showing a solution to Model 4 - Rental Payment, Sakila

Showing a solution to the final model for Sakila

Showing a solution to the final model for Sakila

Showing a solution to Model 4 - Rental Payment, Sakila

Showing a solution to Model 3 - Film, Sakila

UI - 1 - Create a dashboard, introduction

UI - 2 - Building calculated fields and adding a data source filter

UI - 3 - How to define a chart: a general explanation of all tabs

UI - 4 - City Country (Bar Chart + Grid + Sparkline type + Conditional Formating + Tab Container) Building City and Country charts using a bar chart and grid, adding a sparkline-type column, applying conditional formatting and using Tab Container object

UI - 4 - City Country (Bar Chart + Grid + Sparkline type + Conditional Formating + Tab Container) Building City and Country charts using a bar chart and grid, adding a sparkline-type column, applying conditional formatting and using Tab Container object

UI - 3 - How to define a chart: a general explanation of all tabs

UI - 2 - Building calculated fields and adding a data source filter

UI - 1 - Create a dashboard, introduction

UI - 5 - sales over time (line and area charts + conditional formatting) Building a sales-over-time line and area chart and applying conditional formatting

UI - 6 - Sub Category + Products (Duplicate a chart) Building Sub-Category and Products tables inside a tab container using a duplicate chart

UI - 7 - Building a Category stacked column chart using a hidden measure for sorting

UI - 8 - Building a gauge chart

UI - 8 - Building a gauge chart

UI - 7 - Building a Category stacked column chart using a hidden measure for sorting

UI - 6 - Sub Category + Products (Duplicate a chart) Building Sub-Category and Products tables inside a tab container using a duplicate chart

UI - 5 - sales over time (line and area charts + conditional formatting) Building a sales-over-time line and area chart and applying conditional formatting

UI - 9 - Building KPIs using cards, text boxes, and the image object, including some design

UI - 10 - Adding a slicer and defining master filters

UI - 11 - Designing and coloring options

UI - 12 - Explaining the options for conditional formatting

UI - 12 - Explaining the options for conditional formatting

UI - 11 - Designing and coloring options

UI - 10 - Adding a slicer and defining master filters

UI - 9 - Building KPIs using cards, text boxes, and the image object, including some design

UI - 13 - Adding a window function using a calculated field

UI - 13 - Adding a window function using a calculated field

For small and medium-sized organizations or those that do not have resources for self-development, Simm.BI is the best solution, since it enables the implementation of BI quickly and economically.

For More Details