BIDA0036 – Navision Excel Dictionary Demo

0

Please watch the video in 1080p because it is recorded in High Resolution.
Please note the script of the presentation is below so you can read along with the demonstration if you like.

Hello and welcome to our latest blog post.

I am really pleased you have come back to see our latest news!

I am really pleased to be able to bring you some news that I think will really interest you.

This video is intended for companies who still have Navision 2018 installed on premise.

We are also working on a similar demonstration for Business Central in the cloud.

Download Dictionary

1. Why Would You Watch This Video?

This video is a follow up to the prior video demonstration of Meta5 accessing the Navision 2018 demonstration database.

The obvious question that arises from the prior demonstration is this.

“If we have access to so many tables and fields in Navision, how do we make it easier to find those fields because we can’t possibly remember them all.”

And that is where today’s video comes in.

If you are wondering how, you might be able to more easily search all the fields available in Navision, then you should watch today’s video.

So, as ever, on with the demo!

Download Dictionary

2. On With The Demonstration

Here we are in a simple Excel spreadsheet.

This spreadsheet has two sides to it, the left and the right.

You can download this spreadsheet using the button on the blog post.

On the left-hand side is a table of categories.

These at the same categories you saw on the prior demonstration.

They are drillable so you can immediately understand that I can click on a drill, and it will open up with the tables.

So, let’s drill on Financial Management.

Please note that the very first time you click Excel will load the power query model so it will take a second or two to respond.

Now you can see all the tables that are listed in the Financial Management Category.

We will scroll down to the GL Account table.

As you would expect, when we click on the GL Account table, we will get all the fields in the GL Account.

As an Excel user the rest would be obvious to you.

Since we would love you to download the workbook and play around with it yourself, we won’t go into too much detail of this simple drill down.

All the categories, all the tables, all the columns are there.

If we ever get good help text and descriptions?

Then we will include them in this workbook.

Now we will scroll back up to the top of the workbook.

We will close the Financial Management Category.

Now we will show you something we think is really pretty cool.

Excel drills and searches are implemented in this workbook.

So, next to Table there is a drill.

I will click on this drill.

Now we can see there is a search option for all the tables in the dictionary.

I will enter GL and it will search for all the tables with GL in the name.

I will click off all “select all search results” to have no tables selected.

Then I will scroll down and select the GL Account table again.

When we click on the GL Account and click OK, we will be returned to the report.

The GL Account table is now selected but it may not be visible in the table.

You might have to click on Financial Management again to have GL Account visible.

Once you do that then you can click on GL Account to make the fields in the table visible.

Please note we have also numbered the columns in the order in which they appear in the tables.

Just like any other Excel report you might create; the dictionary is fully searchable in this table.

Now, we will clear those selections.

Now I would like to draw your attention to the right-hand side of the report.

You can see there is a bubble saying, “search a table”.

This provides a second way of searching for a table that you might like more.

You can see GL Account is selected.

What I will do is go to the search text and enter just GL.

When I press enter the information to the right will disappear and the mouse will go to the next line.

So, I need to click my mouse over GL again to select the cell.

When I select the cell, a drill will appear next to the cell.

When I click on the drill all the tables containing GL will appear in the drop-down box.

I will again select GL Account.

Now it will show me what category GL Account is in and it will show me all the fields in GL Account.

In this way you have a second way to search for tables using this filter and drop down.

We thought that in this first release of this workbook we would give you both options.

Please feel free to let us know which one you prefer in the comments section at the bottom of this blog post.

Of course, the value of this spreadsheet is this.

As you are creating queries on the Navision database using the Meta5 query tool, you can refer to this spreadsheet.

This will help you to easily find the tables and fields that you are looking for.

Then, when you search the spreadsheet and know exactly what fields in what tables you want, you can more easily locate them in the query tool.

In our own development work we have this spreadsheet on our left screen and Meta5 on our right screen.

You might want to try that out for yourself.

If you would like to try this out for yourself on your PC?

Then please contact me to book a time on the evaluation machine.

You can also download this spreadsheet from the button on the blog post.

You can try for yourself how easy it is to query data directly from Navision using Meta5 while also having this dictionary available to you.

Further, if you would like one of these spreadsheets for your company to help you query your Navision system?

We will prepare this spreadsheet for qualified Navision installed companies.

So please feel free to contact me to see if you meet our qualification criteria.

This report takes a little while to create.

So, we will only create a limited number of these reports as “freebies”.

Download Dictionary

Summary

So, to summarize what I have shown you today?

In our prior video we showed you that it is now possible to perform direct query to all data in your Navision system using the Meta5 query tool.

However, because there are so many tables and so many columns it’s really handy to have a searchable dictionary right there on your left screen.

We created this report to be a searchable dictionary for any customized Navision system.

It provides two ways to query what tables and columns you have available.

On the left-hand side, it allows you to drill down or to use the excel search and drill functions.

On the right-hand side, it allows you to search for tables containing the search string.

We are finding this very useful in our own development work.

We think you will find it useful too, even if you don’t have Meta5.

And with that?

I would like to say thank you very much for watching our demonstration today.

I really appreciate your time and attention.

We hope you found this video interesting and informative.

We would love to hear your comments so please feel free to use the comments section below.

I wish you a good day.

Thank you.

Mihai Neacsu

Business Development Manager

BIDA

Download Dictionary

BIDA0035 – Meta5 Navision 2018 Direct Query Demo

0

Please watch the video in 1080p because it is recorded in High Resolution.
Please note the script of the presentation is below so you can read along with the demonstration if you like.


Hello and welcome to our latest blog post.

I am really pleased you have come back to see our latest news!

I am really pleased to be able to bring you some news that I think will really interest you.

This video is intended for companies who still have Navision 2018 installed on premise.

We are also working on a similar demonstration for Business Central in the cloud.

1. Why Would You Watch This Video?

So, the questions for you to be interested in this video are as follows.

Does it take you too long, and does it cost too much, to get one off questions answered from Navision?

Or worse?

Is it so hard and so expensive to get questions answered from Navision, that you actually gave up?

Do you have questions you would like the answers to, but you don’t even bother asking IT because it takes too long?

If you answered yes to any of these questions, then you will want to watch this video today.

Over the last 30 years of being in Business Intelligence, we have found that some of the hardest questions to answer are such questions as.

  1. How do I optimize my marketing dollar spend so that I am getting the best results from my marketing investment?
  2. How can I introduce differentiated customer service levels such that my investment in customer service and support will encourage an “up or out” process among our customers?
  3. How can I tell which of my customers are more likely to grow into better customers?
  4. By what mechanisms can we encourage customers to be better customers?

Getting the answers to these questions is not a matter of asking a one off question and getting a one off answer.

Getting the answers to these questions takes cycles of asking questions, getting answers, asking more questions, getting more answers. And on it goes.

If you have to go to IT every time you want to ask a question, that can get pretty tedious.

What we have found to be one of the most useful tools to answer questions like this is Meta5.

Today, we are going to show you that you can ask any question you want from your Navision 2018 system.

Of course, if your staff do not know the Navision database in detail, we can answer your questions for you a whole lot faster than anyone else can.

Or at least we think so.

2. On With The Demonstration

Here we are on our Meta5 evaluation machine.

You can get access to this machine by contacting me and scheduling time on the machine.

We will give you a Remote Access user id.

Then you will have access to this machine, as you see it today, from your desktop.

You will want to use a large screen as Meta5 is intended to be used on large screens.

We will enter the user id and password for Meta5.

Meta5 single user edition has user id and password required to gain access to the desktop.

Now that we are on the desktop you can see there are filing cabinets and folders.

These are the sorts of things you will find in a regular office space.

We keep this desktop very clean for those people who want to evaluate Meta5.

Now, you can see there is a folder called Nav 2018.

So I will open up this folder by double clicking on it.

You can see inside the folder is a demonstration capsule.

So, I will open the demonstration capsule by double clicking on it.

Inside the demonstration capsule I can see a whole series of query icons.

These have names like.

  1. Activity
  2. Account Schedule
  3. GL Entry.

And so on.

We also see an icon called Nav 2018 WTDD.

WTDD stands for Workstation Tools Data Dictionary.

This is a small and simple dictionary Meta5 uses to describe the database you want to query.

Meta5 uses this dictionary in its query tool to give you a simple graphical way of writing SQL that is sent into the Navision database.

So, what we are going to do is open this dictionary tool.

Now you can see the dictionary tool opened.

You can see there is a logical database.

In this logical database there are a set of categories.

The categories are set up in alphabetical order.

These categories are copied from the excellent Navision documentation site called Dynamics Docs dot com.

We want to provide full acknowledgement to their great site which was very helpful.

If you have Navision or Business Central, you might want to go and have a look at Dynamics Docs dot com and have a look around.

In the list of categories, you can see all the categories you would expect to see.

  1. Fixed Assets.
  2. Financial Management
  3. Purchasing
  4. Sales
  5. Service

These are all core components of Navision, and you would recognize them.

We will click on the category of Financial Management.

You can see that the tables inside the category are numbered by alphabetical order.

This is to make them easier to find.

If we scroll down you will see there are 222 tables in the Financial Management category.

And yes, we do mean that you can query any table in Navision directly from this Meta5 desktop.

So, let’s go to Sales now.

In sales you can see such tables as Customer, Customer Account, Customer Ledger Entry.

All the tables in Navision are available to you.

Now, if we click again on the Sales Category.

And then we click on Show Joins.

We scroll across.

And then we can see that the Customer table is joined to a lot of different tables.

We have analyzed the Navision database and we have added over 5,000 joins to our dictionary.

We have saved you and your colleagues weeks and weeks of work by defining all these joins.

Of course, we believe there will be a few mistakes in what we have done, but we have done a lot of the work of setting up the joins for these tables for you.

We will scroll down the sales category and you can see just how many joins and how many tables there are.

Now we will scroll back to the top.

And we will scroll back to the left.

You can see at the current state of development there are some tables that do not have joins defined yet.

When you are creating a query, you can actually add your own joins just for that query.

So if we have missed a join you can add it yourself for the query you are writing.

Also, you can create template queries that can be put into a folder in a filing cabinet for re-use by others for common questions.

So let us close the sales category.

And let us close the dictionary tool.

Now we will double click on the icon called Activity.

As we double click on it, you will see it open up.

It connects to the database server when you open the icon.

Now you can see the open query icon.

Each query icon opens up and has available up to three windows.

There is the query window itself.

Then the Query Control

And lastly the Query Catalog.

The query catalog gives you access to all the tables you are authorized to.

You could deploy a Meta5 workstation in each area of your business.

For example, Finance might want one of their own.

Sales might want one too.

In this sort of situation we would set up your Meta5 desktops to only have access to the data that you are authorized to have access to.

This very simple and easy to use query icon is your “window to your data world”.

We will click on Show DBA Catalog.

And we will make the window larger.

Now you can see the categories and the tables.

They are all available inside the query catalog.

By pointing and clicking on any table you can gain access to the data in that table.

The joins will be read in and you will not have to worry about them.

We will make the query catalog small again.

In this query we are just querying the Activity table because it is the first table.

I will record the SQL being generated.

To do this I will click on capture SQL.

A query log window will open up.

And I will make it larger.

Now I will click show data.

You can see that 9 rows were found.

This data is coming directly from the Navision 2018 demonstration database.

You will see in the query log window that we are using the CRONUS UK demonstration database.

You can see the SQL that was generated.

So, this very simple point and click query interface is available to you.

Through this simple query interface, you can gain access to all your data in Navision 2018.

Indeed, you can gain access to just about any data anywhere as long as you have the authority to access that data.

This includes data from web-based applications.

This does require another piece of licensed software.

We are not going to discuss that here.

Now we will close the Activity Query Icon.

Next, we will open the Account Schedule query icon.

In this query icon you can see that there are two joins between the tables already created when you open the query icon.

These joins are in the dictionary and were automatically drawn by the query tool when fields from both tables were requested on the output line.

Again I will click on capture SQL and then run the query.

You can pause the video to read the SQL generated in more detail.

Now I will close the Account Schedule Query Icon.

Now I will open the GL Entry query icon.

In this query icon you can see that it’s possible to request many fields from the GL Account and the GL Entry.

You can see that any field you want is there and available.

In this demonstration we just want you to see for yourself that Meta5 provides a simple query tool that can generate SQL and retrieve data from any table in your Navision system.

I will close the query catalog and you can see how many fields are available from the GL.

Again, I will click on capture SQL and then run the query.

You can pause the video to read the SQL generated in more detail.

Now I will close the GL Entry Query Icon.

Now I will open the Fixed Assets Ledger Entry query icon.

I will scroll down the Query Catalog, and you can see how many fields are available.

Again, I will click on capture SQL and then run the query.

You can pause the video to read the SQL generated in more detail.

Now I will close the Fixed Assets Ledger Entry Query Icon.

Now I will open the Sales Lines query icon.

I will scroll down the Query Catalog, and you can see how many fields are available.

Again, I will click on capture SQL and then run the query.

You can pause the video to read the SQL generated in more detail.

Now I will close the Sales Lines Query Icon.

Now I will open the Purchase Inventory query icon.

I will scroll down the Query Catalog and you can see how many fields are available.

Again, I will click on capture SQL and then run the query.

You can pause the video to read the SQL generated in more detail.

Now I will close the Purchase Inventory Query Icon.

Next to the DBA tool you can see an Excel Spreadsheet.

This is an Excel dictionary for Navision 2018.

It is helpful to be able to search for tables and field names.

It is the subject of our next video demonstration.

Now I will open up the DBA Tool again.

As you can see from the 14 categories, all the tables that you want to query from Navision are already in the dictionary.

Of course, if you have customized Navision you will need to customize the dictionary.

We would be pleased to do that for you too.

There are some tables that are not in any category.

There are many more tools in Meta5, around 150.

You can send any data you get into Meta5 into Excel for further reporting.

Those features are covered in separate videos.

Summary

To summarize what we have shown you today.

We have captured the entire dictionary for Navision 2018.

We have put all the CRONUS standard tables in to the Meta5 dictionary.

We have added more than 5,000 joins to that dictionary.

We have grouped tables into categories.

We have numbered all the tables to make them easier to find.

We have made all this available through the very simple and easy to use Meta5 query tool.

And we have shown you a series of 6 very simple queries just to show you how the query tool generates SQL, sends it to your Navision system, and retrieves the results to your desktop.

The data returned to your desktop can then be further analyzed or sent into Excel.

We believe this “direct query” to Navision 2018 is the simplest and easiest to use on the marketplace.

We would be very happy to use Meta5 to answer any and all questions you have that can be answered from your Navision system.

We would be very happy to build the Excel Dashboards you want to run your business.

Of course, if you would like to play with this evaluation machine yourself or have one of your colleagues play around with it.

Please just contact me to schedule availability of the machine.

If you would like us to set up a Meta5 desktop on your premises so you can try this out on your own data, please just contact me.

And with that?

I would like to say thank you for watching our demonstration today.

I really appreciate your time and attention.

We hope you found this video interesting and informative.

It has never been this easy to ask Navision a question.

We would love to hear your comments so please feel free to use the comments section below.

I wish you a good day.

Thank you.

Mihai Neacsu

Business Development Manager

BIDA

BIDA0034 – The Window To Your Data World – Meta5

0

Please watch the video in 1080p because it is recorded in High Resolution.
Please note the script of the presentation is below so you can read along with the demonstration if you like.


Hello and welcome to our latest blog post.

I am pleased you have come back to see our latest news!

I am pleased to be able to bring you some news that we think will be interesting to you.

As you know we are promoting Meta5 as the best tool to give to the “5 smartest business analysts” in your company.

There have been two recent feature developments in Meta5 that makes it even more useful.

1. Meta5 Dictionary Separation

Like all query tools Meta5 has a dictionary that helps the tools understand the databases you want to query.

In the past this dictionary has been required to sit in, or near, the database you want to query.

For example, in SQL Server you can put the dictionary in it’s own database.

Then you can have views in that database to point to the tables you actually want to query in another database in the same sql server.

These tables would usually be on the same server because remote query on SQL Server like this does not work so well.

Effective immediately, you can now keep your Meta5 dictionary in one database, accessed via ODBC, and query another database on another ODBC link.

Because the dictionary is very small, you can even keep it in MS Access rather than in SQL Server.

The functionality that this dictionary separation makes possible is very valuable.

For example, if you are a Business Central user, you can have a small dictionary of the tables you need to query in MS Access on your Windows desktop.

Then, your IT staff can give you read access to those tables.

Then you will be able to query all the underlying Business Central tables that you need to directly from your desktop.

You can create capsules to run and create your reports in Excel while you sleep comfortably in your bed!

Quite literally, as long as your IT staff will give you read access to the tables you need, you can create any query you want and get the data you need without going back to IT.

Of course, you have to be careful.

And it is better to query on a copy of your production ERP.

But, if you have no copy of your production database, and you have to query production data?

You now have a way of doing that very easily, and very securely.

2. Meta5 CData Partnership

There is a product available called Cdata.

You can visit their web site on the button below.

Visit CData

CData makes it possible to connect to over 200 data sources as if they were ODBC connections.

You can see the list of data sources you can connect to by clicking on the button below.

CData Drivers

CData now provides single user licenses for their connectors that can be integrated into Meta5.

Simply put.

If Meta5 can not read the data source you want to read via a regular ODBC connection?

Then CData will very likely be able to read that data for you.

This means Meta5 becomes your “Window To Your Data World”.

You will be able to read pretty much any data you could ever want to read, and get it to your desktop to work on.

You will be able to create capsules to fetch your data, and run your reports, whenever you want, by scheduling the reports in capsule services.

You can then distribute those reports to your business colleagues via one drive, shared folders, or even email.

All without getting stuck in the “IT Backlog”.

Summary

For all the installed Business Central (including Navision) customers in Romania, we can summarize this announcement like this.

If you are frustrated that it takes “forever” to get data out of Business Central and in to your reports that you needed YESTERDAY?!

You can get Meta5 and a little training on how to use it and do that job yourself.

If you want? Of course, you can hire one of our consultants.

We would be happy to build the reports that you need, even if it needs to be directly from your production Navision.

But trust us, you no longer need to wait for “IT Support” to develop a new report that you need.

You can get your data, from your production Business Central system, now, with Meta5.

And you can get almost any data from anywhere on the web as well via CData.

So if you are frustrated with how long it takes to get new reports created by your IT Support?

Just go to our contact page.

You can type in your question into our “Ask Us Anything” form.

My phone number is also there and please feel free to call me.

I would love to hear from you.

Thank you very much for your time and attention.

I really appreciate you reading our blog post.

I wish you a great day!

Best Regards

Mihai Neacsu

Business Devevlopment Manager

BIDA

BIDA0033 – New Design Techniques For Excel Power Pivot

0


Hello and welcome to our latest blog post.

I am pleased you have come back to see our latest news!

I am pleased to be able to bring you some news that we think will be interesting to you.

In this blog post we just wanted to mention upgrades we have made to the development methods we are using for our Excel Dashboards.

During this year we have released detailed training material on how we are building Excel Dashboards.

You can watch these videos on our web site.

Over the last few weeks we have put in some time and effort to see if we can find even better ways to design and build these Excel Dashboards.

We have managed to make two substantial technical upgrades.

These two upgrades do not make any difference to the users experience of the Excel Dashboard.

They make Excel Dashboards easier to design, easier to support, and faster to produce, on a daily basis.

The two upgrades are as follows.

One

We have converted the “ExcelTables” workbook to DAX.

The ExcelTables workbook was created to be able to update charts based on slicer clicks even if the number of bars or data points on the charts changed.

So, for example.

If you clicked on a slicer for a product category and that product category was not purchased by all age groups, then the charts for age groups would adjust the number of bars that are displayed.

The ExcelTables worksheet is quite complicated and we have long thought that DAX might be the answer to those complications.

We have now developed DAX calculations to replace this worksheet.

The DAX calculations make the worksheets easier to create.

Two

One of the features we wanted to embed in our workbooks was to only have one copy of the data inside the power pivot model.

In our first release of the dashboards we achieved this by having a separate “data” workbook.

This separate data workbook was linked to the dashboard workbook.

In preparing the dashboard workbook in Meta5 the data was read from the data workbook into the power pivot model in the dashboard workbook.

This is quite a slow running process.

It also had the disadvantage that the location of the data workbook must be hard coded in the dashboard workbook.

You can see in the demos we had to create a folder on the C drive, and we had to give it a standard name so the dashboard workbooks could know where to look for their data.

We have now developed a way of sending the data into the Dashboard Workbook in Excel Tables.

These Excel tables are then read into the power pivot model.

All the charts and reports are updated from the power pivot model.

The data is then deleted from the Excel Tables.

This then emulates our current feature that the data is only in the workbook once, and only in the power pivot model.

The good news is that we do not need a second “data” workbook to achieve this result any more.

Obviously, this means our training materials are a little out of date with our new best practice.

We wanted to mention this on our web site publicly.

Just so you know.

It took more than 100 hours of work to create our internal training materials and our public training materials.

Because these videos take so long to create, it will be a little while before we release updates to our training materials.

In thinking about Meta5 + Excel the bottom line to keep in mind is this.

If you love Excel, and you want to use Excel for your reporting and your dashboards?

You can get any data, from anywhere, into Excel, using Meta5.

You can put that data into Excel regions, tables, or the power pivot models.

You can parameterize the Excel Dashboard production, so that each person receives spreadsheets containing only the data they need for their reports.

You can deliver the Excel Dashboards to any device by any mechanism you have available to you.

You can even render portions of the reports as PDFs.

We love Excel.

We use it every day.

Microsoft has announced there are 300 million in force subscriptions for Office 365.

That means there are 300 million people out there who have Excel available to them, already paid for, and many of them would be happy to get their Dashboards in Excel.

If you love Excel, and you want your Dashboards in Excel?

Meta5 will make your Excel Dashboard development, support, and production running, faster, cheaper and better.

We can guarantee this.

You can put the data you need, into your Excel Dashboards, to create the best Dashboards possible in Excel.

And if you would like our colleagues to build your Dashboards for you?

We are training them via such well known teachers as Minda Treacy and Other Levels Dashboards.

So, with that?

I would like to say thank you very much for your time and attention!

I really appreciate you reading our blog post!

I wish you a great day!

Best Regards

Mihai Neacsu

Business Development Manager

BIDA

BIDA0032 – Free Meta5 Evaluation Service

0

Questions?

Are you one of the smartest business people in your company?

Do you use Microsoft’s Business Central ERP?

Do you use SQL Server for your Data Warehouse?

Does it take too long to get answers to new questions?

Does it take too long to get new data into your data warehouse?

Or do you not even have a data warehouse for Business Central?

Do you have questions you just can’t get answers to?

Do you think there is business value in getting answers to new questions faster?

Do you constantly cut and paste data into Excel try to answer your questions?

Do you have to keep asking “IT” for help to answer your questions?

Answers!

If you answered yes to four or more of these questions?

We would like to talk with you.

We are world class BI experts on SQL Server.

We represent Meta5 here in Romania.

With Meta5 you can easily answer your “just thought of” questions.

You can build dashboards in Excel faster, cheaper, better than any other way.

You can query any data you can lay your hands on!

You have seen the demos on our web site.

You have to use Meta5 to really “get it”

So we invite you to try out Meta5 for your self!

On our web site we have provided a great deal of Meta5 demonstration materials that you can download for your own, on premise, evaluation of Meta5.

To take this one step further we have made available a Meta5 Evaluation server on Azure.

This means we are able to give you remote desktop access to a Meta5 Pro desktop so that you can more easily perform your evaluation of Meta5.

You are now able to evaluate Meta5 from the comfort of your office, or home.

All you need is the standard Remote Desktop software that comes with Windows.

The evaluation machine is “bookable” seven days a week for those of you who would like to perform your evaluations on the weekends.

Slots will be 4 hour slots as follows: 10am-2pm, 2pm-6pm, 6pm-10pm.

We can also provide you “teams” & phone support with one of our trained Meta5 consultants to help you with your evaluation. (Business Hours Only)

You can arrange your exclusive access to the Meta5 Evaluation machine by contacting me (Mihai Neacsu) by clicking on the “Contact Us” button below.

I look forward to helping you discover the massive business value that Meta5 brings to you!

Please note: Our free offer is for Business Central ERP Installed Accounts. If you do not have Business Central installed, please contact us to discuss how we can help you.

BIDA0031 – Ralph Kimballs Demo Databases – Warehouse

0

Please watch the video in 1080p because it is recorded in High Resolution.
Please note the script of the presentation is below so you can read along with the demonstration if you like.

Hello and welcome to our latest blog post.

Firstly, I’d like to say thank you very much for coming along and watching our latest video today.

I really appreciate your time and attention, so thank you very much for that.

Today, we are releasing the next video in the series on the demonstration databases Ralph Kimball released in his book.

Of course, to be fair to Ralph, on each post we will put a button you can click to buy his book.

In this blog post we are going to give you a demonstration of the Warehouse database.

We would suggest you get an evaluation copy of Meta5, and query Ralphs databases as you read his excellent book.

We would also recommend you watch the first and second videos in this series.

Now.

Here we go!

We welcome you to the video demonstration of the Warehouse sample database from Ralphs excellent book.

We hope you like it!

Now!

This concludes our demonstration of the Warehouse database from Ralph Kimballs book.

You can download all these databases, and the Meta5 folder, to be able to query the databases, from the button below.

We sincerely hope you will learn more about dimensional modeling, using the databases and software, Ralph Kimball played such a large part in bringing to the world.

We hope you liked this short demonstration video.

If you did like it, please hit the like button and please subscribe, so that you will receive notifications when we release more videos.

If you are on our web site, please feel free to subscribe to our newsletter, to be notified when we release new blog posts.

Thank you very much for coming by our channel and watching our video, we really appreciate you.

I really appreciate your time and attention.

I wish you a good day!

Until the next blog post.

Goodbye for now.

BIDA0030 – Ralph Kimballs Demo Databases – Voyage

0

Please watch the video in 1080p because it is recorded in High Resolution.
Please note the script of the presentation is below so you can read along with the demonstration if you like.


Hello and welcome to our latest blog post.

Firstly, I’d like to say thank you very much for coming along and watching our latest video today.

I really appreciate your time and attention, so thank you very much for that.

Today, we are releasing the next video in the series on the demonstration databases Ralph Kimball released in his book.

Of course, to be fair to Ralph, on each post we will put a button you can click to buy his book.

In this blog post we are going to give you a demonstration of the Voyage database.

We would suggest you get an evaluation copy of Meta5, and query Ralphs databases as you read his excellent book.

We would also recommend you watch the first and second videos in this series.

Now.

Here we go!

We welcome you to the video demonstration of the Voyage sample database from Ralphs excellent book.

We hope you like it!

Now!

This concludes our demonstration of the Voyage database from Ralph Kimballs book.

You can download all these databases, and the Meta5 folder, to be able to query the databases, from the button below.

We sincerely hope you will learn more about dimensional modeling, using the databases and software, Ralph Kimball played such a large part in bringing to the world.

We hope you liked this short demonstration video.

If you did like it, please hit the like button and please subscribe, so that you will receive notifications when we release more videos.

If you are on our web site, please feel free to subscribe to our newsletter, to be notified when we release new blog posts.

Thank you very much for coming by our channel and watching our video, we really appreciate you.

I really appreciate your time and attention.

I wish you a good day!

Until the next blog post.

Goodbye for now.

BIDA0029 – Ralph Kimballs Demo Databases – Value Chain

0

Please watch the video in 1080p because it is recorded in High Resolution.
Please note the script of the presentation is below so you can read along with the demonstration if you like.


Hello and welcome to our latest blog post.

Firstly, I’d like to say thank you very much for coming along and watching our latest video today.

I really appreciate your time and attention, so thank you very much for that.

Today, we are releasing the next video in the series on the demonstration databases Ralph Kimball released in his book.

Of course, to be fair to Ralph, on each post we will put a button you can click to buy his book.

In this blog post we are going to give you a demonstration of the Value Chain database.

We would suggest you get an evaluation copy of Meta5, and query Ralphs databases as you read his excellent book.

We would also recommend you watch the first and second videos in this series.

Now.

Here we go!

We welcome you to the video demonstration of the Value Chain sample database from Ralphs excellent book.

We hope you like it!

Now!

This concludes our demonstration of the Value Chain database from Ralph Kimballs book.

You can download all these databases, and the Meta5 folder, to be able to query the databases, from the button below.

We sincerely hope you will learn more about dimensional modeling, using the databases and software, Ralph Kimball played such a large part in bringing to the world.

We hope you liked this short demonstration video.

If you did like it, please hit the like button and please subscribe, so that you will receive notifications when we release more videos.

If you are on our web site, please feel free to subscribe to our newsletter, to be notified when we release new blog posts.

Thank you very much for coming by our channel and watching our video, we really appreciate you.

I really appreciate your time and attention.

I wish you a good day!

Until the next blog post.

Goodbye for now.

BIDA0028 – Ralph Kimballs Demo Databases – Telephone

0

Please watch the video in 1080p because it is recorded in High Resolution.
Please note the script of the presentation is below so you can read along with the demonstration if you like.


Hello and welcome to our latest blog post.

Firstly, I’d like to say thank you very much for coming along and watching our latest video today.

I really appreciate your time and attention, so thank you very much for that.

Today, we are releasing the next video in the series on the demonstration databases Ralph Kimball released in his book.

Of course, to be fair to Ralph, on each post we will put a button you can click to buy his book.

In this blog post we are going to give you a demonstration of the Telephone database.

We would suggest you get an evaluation copy of Meta5, and query Ralphs databases as you read his excellent book.

We would also recommend you watch the first and second videos in this series.

Now.

Here we go!

We welcome you to the video demonstration of the Telephone sample database from Ralphs excellent book.

We hope you like it!

Now!

This concludes our demonstration of the Telephone database from Ralph Kimballs book.

You can download all these databases, and the Meta5 folder, to be able to query the databases, from the button below.

We sincerely hope you will learn more about dimensional modeling, using the databases and software, Ralph Kimball played such a large part in bringing to the world.

We hope you liked this short demonstration video.

If you did like it, please hit the like button and please subscribe, so that you will receive notifications when we release more videos.

If you are on our web site, please feel free to subscribe to our newsletter, to be notified when we release new blog posts.

Thank you very much for coming by our channel and watching our video, we really appreciate you.

I really appreciate your time and attention.

I wish you a good day!

Until the next blog post.

Goodbye for now.

BIDA0027 – Ralph Kimballs Demo Databases – Supply Chain

0

Please watch the video in 1080p because it is recorded in High Resolution.
Please note the script of the presentation is below so you can read along with the demonstration if you like.


Hello and welcome to our latest blog post.

Firstly, I’d like to say thank you very much for coming along and watching our latest video today.

I really appreciate your time and attention, so thank you very much for that.

Today, we are releasing the next video in the series on the demonstration databases Ralph Kimball released in his book.

Of course, to be fair to Ralph, on each post we will put a button you can click to buy his book.

In this blog post we are going to give you a demonstration of the Supply Chain database.

We would suggest you get an evaluation copy of Meta5, and query Ralphs databases as you read his excellent book.

We would also recommend you watch the first and second videos in this series.

Now.

Here we go!

We welcome you to the video demonstration of the Supply Chain sample database from Ralphs excellent book.

We hope you like it!

Now!

This concludes our demonstration of the Supply Chain database from Ralph Kimballs book.

You can download all these databases, and the Meta5 folder, to be able to query the databases, from the button below.

We sincerely hope you will learn more about dimensional modeling, using the databases and software, Ralph Kimball played such a large part in bringing to the world.

We hope you liked this short demonstration video.

If you did like it, please hit the like button and please subscribe, so that you will receive notifications when we release more videos.

If you are on our web site, please feel free to subscribe to our newsletter, to be notified when we release new blog posts.

Thank you very much for coming by our channel and watching our video, we really appreciate you.

I really appreciate your time and attention.

I wish you a good day!

Until the next blog post.

Goodbye for now.