HD0005 – How Do I Set Up SMTP Email For 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!

Thank you for dropping by to watch our latest how two video for Meta5!

We are really pleased to see you drop by.

Today we are going to show you how to set up SMTP email for Meta5.

This is a very simple and easy thing to do, so we are sure you will understand it very quickly.

Ok?

So let us go to the demo.

There are two ways to set up SMTP email in Meta5.

You can set up your own email credentials on an individual mail box.

Or you can set up a single set of credentials for a Meta5 server, and an email box can use that set of credentials.

We will show you both ways today.

The first way that we will show you is by configuring an email outbox with your own credentials.

So, you will go to the new icons folder and double click to open the new icons folder.

Then you will go to blank icons and click twice on blank icons to open up blank icons.

Then scroll down to the email outbox icon.

Click once on the email outbox icon to select it.

Press F 4 to copy it.

Then drop the copy of the email outbox on your desktop.

Then click once on the email outbox on your desktop to select the email out box.

Then press F 4 to open the options window.

Then click on other data.

You will see the Use Global Settings option in the other data window.

If you set Use Global Settings to Yes you will use the global settings for the installation of Meta5.

Now click on Use Global Settings equals No.

Now you will see the parameters for the SMTP email server that you wish to use.

You can complete these parameters according to the settings that you are given by your email administration colleagues.

It just so happens that I have completed these parameters in another email outbox.

This is so you do not have to watch me type in the parameters.

This is the email outbox that I have set these parameters correctly in.

So I will option this email outbox and select other data.

Now you can see that the SMTP parameters are correctly set.

You can pause the video to check the settings I am using.

You can see that these parameters are all quite normal.

So now you must create a simple capsule to test sending your email.

So you click on New Icons twice to open New Icons.

Then click on blank icons twice to open blank icons.

Then click on the capsule icon once to select it.

Then press F 3 to copy the capsule icon.

Then drop it on your desktop.

Then click on the file drawer icon in the header bar of blank icons to close the file drawer.

Let us call the capsule, capsule two.

So option the capsule and add the number two to the name of the capsule.

Then close the icon options by clicking on icon options in the icon options header window.

Now click on capsule two twice to open it.

Notice that capsule two is starting out blank.

One thing we need to put in to capsule two is an email outbox.

So select the email outbox you have just configured by clicking on it once.

Then press F 3 to copy it.

Then drop the copy of the email outbox in the capsule.

Another item we need to copy in to the capsule is an envelope.

So we must go to blank icons to get an envelope.

By now you will be familiar with the routine.

Open New Icons.

Open Blank Icons.

Click once on the envelope icon.

Press F 3 to copy the envelope icon.

Then drop the envelope icon just to the left of the email outbox.

Then click on the file drawer icon in the header bar of blank icons to close the file drawer.

And then we need something to send in the envelope.

I just happen to have created another capsule where we have the Final spreadsheet from the Adventure Works Demonstration we have provided on a prior blog post.

So I will copy the Final spreadsheet from the prior test capsule I created and drop it into this new capsule.

Now I am going to close the test capsule.

Now connect the spreadsheet with the envelope.

Click once on the spreadsheet.

Click once on Connections in the header.

Click once on the envelope icon,

And you will see an arrow drawn between them.

Repeat to connect the email icon to the email outbox.

Now, when I open the envelope, there are no details in the envelope.

There is no from address, no to address, no subject, no text in the envelope.

Obviously you would type these things in here now.

I am sure you do not want to watch me type these things in, so I have a sample envelope with these items already filled in.

So I will copy that envelope in to this position while you watch.

You would complete these items for your example.

Ok?

I am going to show attachments.

I am going to delete the attachment.

And now I am going to connect these icons.

So now we have copied the sample envelope and reconnected the icons.

And we will move the icons one step to the left.

So now I have a spreadsheet going in to an email envelope.

In the email envelope I have the from address, the to address, a subject, and some text.

The email outbox is set with these parameters.

Now we can click the run button.

Now we will open up the capsule run log.

And you can see that the capsule was successful in sending the email.

So now we are going to go to the email for demo user and see if the email arrived.

And here is the email.

I open it up.

Here is my Final spreadsheet inside the email.

You can see the text that was sent with the email.

I can click on the Final spreadsheet and outlook will show me a preview of the spreadsheet.

Of course, I can also download the spreadsheet.

So we can see the spreadsheet arrived in my email.

Now let us close the email and return to our Meta5 desktop.

Now, we are going to demonstrate configuring the email for the server, and not just the individual email mail box.

So what we need to do is to go down to the bottom right hand corner of our server window.

Click on the up arrow for services.

Right click on the meta5 icon.

Then click on Configure Meta5 Starter Edition.

A window will pop up for the Meta5 Starter Edition Configuration Parameters.

Click on email in the header.

And you can see a set of parameters that it is asking for in the email parameters.

These are essentially the same parameters requested for the individual email outbox.

We are going to demonstrate this setting with the option HTML Formatted Messages both set to on and off to show you the effect.

We do not want to bore you with watching us type in the parameters so we will skip all that.

Please take note that the port for the SMTP mail server is added to the end of the SMTP Server parameter after a colon.

In our case there is a colon followed by the number 5 8 7.

Now we have added the parameters we can test the connection to the SMTP server.

And you can see it was successful.

We click on apply.

Now we must stop and restart the Meta5 server to have these settings take effect.

So log off your Meta5 desktop.

Go to the services arrow in the bottom right hand corner of your server.

Right click on the Meta5 icon.

Click on stop Meta5 Starter Edition.

You will need to click on the yes to confirm.

You will need to give it a little time to shut down all services.

Then double click on the Meta5 icon to start Meta5 again.

It will take a little time to start because it is re-starting all the services.

Now we will log on.

We will get another email box from the blank icons folder.

We are sure you know the routine now.

We will set the parameters for the email box in the options, other data window.

Notice that the option Use Global Settings is set to yes.

If we set Use Global Settings to No we will get these parameters.

In this case we will say Use Global Settings is Yes.

We will copy capsule two by selecting it, pressing F 3, and then dropping the copy just below it.

We will call this capsule three.

We click apply, then click the icon options in the header to close the icon options window.

We open up capsule 3.

We will delete the current email outbox and replace it with the new email outbox we just configured.

Each time we will use the function pad you can see on the screen to manipulate these icons.

And we are going to check that the email outbox we are using now has the Use Global Settings parameter set to Yes.

Now we are going to run this capsule.

And you can see by the Capsule Run Log that it ran successfully.

And now we will go to the email for demo user and we will see if the email has arrived.

Notice that the time is 1 34 P M.

You can see that the text in the email has not been formatted properly.

This is because we said in the options we would use HTML email formatting.

So now we are going to run through the process of altering that option and rebooting the Meta5 server and resending the email.

You can follow along on the screen because it’s really quite simple.

We just wanted to make sure we demonstrated this to you.

Now we will go to the browser to see the email has arrived.

And here is the new email with the text formatted correctly.

And here is the prior email with the text not formatted correctly because it is not using HTML.

So, this completes the demonstration of setting up the email outbox using local parameters on the email outbox, or using the Global Settings for the Meta5 server.

You can now log off your desktop after a job well done!

Meta5.

The Better Way.

This concludes our demonstration of how to set up SMTP email for Meta5.

We hope you liked this short how two video.

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

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

I wish you a good day!

Thank you.

HD0004 – How Do I Copy Objects Between Windows And 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!

Thank you for dropping by to watch our latest how two video for Meta5!

We are really pleased to see you drop by.

Today we are going to show you how to copy Meta5 objects from files on your computer across to your Meta5 desktop.

This is a very simple and easy thing to do, so we are sure you will understand it very quickly.

We have published a previous blog post called, H D 0 0 0 2, How Do I Install The Microsoft Meta5 Demonstrations.

In this blog post we demonstrated how to copy files from windows to the meta5 desktop.

However, we are going to repeat that process in this short video for those who want to see just this process.

Ok?

Let us go to the demo.

We are going to use the Microsoft Meta5 demonstration files that we have provided to you for this how two video.

So we are going to first go to the downloads folder for that demonstration.

This is where you would start with your own meta5 archive that has been copied to windows.

You can see 6 files.

They are as follows.

Oh one. Adventure Works.

Fifty one. W W I, Demos.

ADVENTURE WORKS D W M 5 A dot back.

ADVENTURE WORKS D W dot back.

WIDE WORLD IMPORTERS D W M 5 A dot back.

WIDE WORLD IMPORTERS D W dot back.

We have started with our meta5 desktop open.

Next you will need to move the Meta5 desktop to one side so that you can see the downloads folder.

Now put the mouse over the heading bar of the Meta5 desktop.

Now left click on the mouse and hold down the mouse button.

Now move the Meta5 desktop to the right so that the downloads folder in windows explorer is visible.

Now put the mouse over the file, oh one, Adventure Works.

Select the file oh one, Adventure Works, by left clicking the mouse and holding down the mouse button.

While holding the left mouse button down, drag the oh one, Adventure Works file from the external Microsoft operating system on to the Meta5 desktop.

Now release the mouse button to drop the file on to the Meta5 desktop.

Meta5 will now translate the archived Meta5 file to the required files on the Meta5 file server.

This process might take a little while for large Meta5 archives.

Next hover over the second file.

Fifty One, W W I, Demos.

Then press down on the left mouse button.

While holding the left mouse button down drag the file from the windows operating system across to the Meta5 desktop.

Release the left mouse button to drop the file on to the Meta5 desktop.

Meta5 will now translate the archived Meta5 file to the required files on the Meta5 file server.

This process might take a little while for large Meta5 archives.

Now you can edit the name of each of the folders and add an X to the end of the names.

So now select the folder, oh one, Adventure Works, by left clicking on the folder once.

Now press F 4 to open up the options for the folder.

Now click at the end of the name.

Add an X to the end of the name of the folder.

Then click on icon options in the header to close the folder.

Now select the folder, fifty one, W W I Demos, by left clicking on the folder once.

Now press F 4 to open up the options for the folder.

Then click at the end of the name.

Add an X to the end of the name of the folder.

Then left click on icon options in the header to close the folder.

Now left click once on the folder called, oh one, Adventure Works X, to select it.

Now click left once more and hold the mouse down to be able to copy it.

Now drag the folder to the windows explorer window you would like to drop it in.

Now release the left mouse button to drop the folder in the windows explorer window.

Now left click once on the folder called, fifty one, W W I Demos X, to select it.

Now click left once more and hold the mouse down to be able to copy it.

Now drag the folder to the windows explorer window you would like to drop it in.

Now release the left mouse button to drop the folder in the windows explorer window.

Now You will see that the two folders copied from the meta5 desktop are in the windows explorer window.

Now you have seen how to copy meta5 archives from a windows explorer window to a Meta5 desktop.

And you have seen how to copy a meta5 object from the meta5 desktop to a windows explorer window.

Now you can log off your meta5 desktop.

Meta5.

The Better Way.

This concludes our demonstration of how to copy Meta5 objects from files on your computer across to your Meta5 desktop.

We hope you liked this short how two video.

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

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

I wish you a good day!

Thank you.

BIDA0019 – Introducing The Meta5 Desktop

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!

Thank you for dropping by to watch our latest demonstration video for Meta5!

We are really pleased to see you drop by.

Thank You.

The purpose of today’s blog post is to show you the Meta5 desktop, and how it works.

The Meta5 desktop is the first feature you will notice when you log on.

And the Meta5 desktop is one of the features that makes Meta5 so special and so easy to use.

Most power data analysts, like you, spend 75% of your data analysis time collecting data, and 25% of your data analysis time actually doing data analysis.

For more than 30 years now, power data analysts consistently spend more time collecting data than actually analyzing it.

Meta5 switches those numbers around.

With Meta5, you will spend closer to 25% of your time collecting data, and 75% of your time analyzing it.

Meta5 makes the power data analyst, like you, around 3 times more productive.

Meta5 will make it possible for you to ask questions that you can’t ask today, without having to go back to IT and ask them for some of their programmer time.

With Meta5, you can perform almost any analysis you want, and produce any report or chart you want, without asking IT for programmer time.

All you need is access to the underlying data.

Now.

On to the demonstration!

Ok?

Firstly, your Meta5 desktop can be on your windows PC or on a server PC that you access with remote access software.

When you start Meta5 you get a splash screen with the logo.

Meta5 is accessed by a user id and password.

When you log in you are logging in to a secure environment with all the security features you would expect of enterprise software.

Only system administrators can see what is on your desktop.

So you can see in the top left hand corner there is a filing cabinet.

This is just like the filing cabinet you would find in your office.

This one is called New Icons, because this is where you go to get your new icons.

The function keys on your keyboard have the following meaning.

F 1 = Help.

F 2 = Move.

F 3 = Copy.

F 4 = Show Options.

F 5 = Delete.

These functions can be accessed using just the mouse.

This is done by pressing the left mouse button and holding it down, and then pressing the right mouse button.

A function pad will appear on the screen to provide access to the last four functions just mentioned.

In the new icons folder you can see a series of folders.

Of course, if you went to a filing cabinet in a real office, and opened the filing cabinet, and looked in a drawer, you would find folders with documents in them.

This metaphor for filing cabinets and folders was invented at Xerox Park.

Ralph Kimball brought the ideas to Metaphor Computer Systems.

Now we will look in to some of these folders.

The first folder is Blank Icons.

This is where you go to get a copy of the blank icons you want to work with.

There will be a lot of icons you don’t understand yet because you have never seen them before.

But some of them will make sense to you immediately.

Near the bottom of the list, there is a Text Icon.

This is the icon you copy when you want to write something in a text document.

Two icons above it you will see a spreadsheet icon.

Meta5 has it’s own spreadsheet tool, and this is the icon you copy when you want a new spreadsheet.

A little above there you can see a Query Icon.

This is the icon you copy to query a database using ODBC.

Above query you can see the Plot Icon.

This is the icon you use if you want to create a chart.

Today, we recommend all charting be done using Excel.

Further up, you can see an icon for an Email Envelope.

So once you have created a chart, or spreadsheet, or text document, or a query icon, or a capsule, you can put it in to a folder, and then put the folder in to the email envelope.

You can also see the Email Outbox.

Once you address the envelope, and put a message in the email envelope to explain the folder you have put in the envelope, you can email it to the people you want to receive it.

Meta5 can send email using the Meta5 email system, or you can send email using your company email system.

Just above the Email icons you can see the DBA Tool.

This is the icon that your data base people will use to give you a business users view of your data.

And the last icon I want to talk about here is the capsule icon.

This is the most important icon.

We will have separate videos about how the capsule icon is used.

Just from this portion of the demonstration, you can see that it is intuitively obvious what these icons are, and what they would be used for.

You can see a folder called Integrator Icons.

We won’t demonstrate them to you in this video.

These icons give us full integration to microsoft office.

The next folder I want to show you is the Transformer Icons.

Today you might have heard the term data wrangling as something new.

Well Meta5 has been doing that for nearly forty years.

These are the tools meta5 users do their data wrangling with.

You can get data from databases, spreadsheets, text files, web pages and more.

You can get data from where ever it exists.

Then you process that data through these data wrangling tools to deliver it to the internal spreadsheet to perform needed calculations.

And then you can send that data in to Excel.

You can send data in to excel using an excel region or table, or even in to the newer power query model.

Once you have sent the data from Meta5 in to Excel, you can use any Excel functions you like on the data, and present it in any way you like in Excel.

Meta5 can do a great deal of processing and calculations before you send the data in to Excel for reporting and charting.

Now, we are going to go through all the icons, but we are not going to explain what all of them do.

We will only explain what some of the main ones do.

Ok?

So let’s go.

The first folder is Aggregate and Combine Data.

For those of you listening to the audio only, the list of icons is as follows.

Append.

Concatenate.

Function.

Join.

Label.

Merge.

Multi Join.

Pivot.

Select Unique.

Subtotal.

The most important icons and most used icons are as follows.

One.

The Join icon.

This allows you to join data from two data streams based on the data in each of the data streams.

If you have some data in your data warehouse, and some other data in a spreadsheet that you need to join together?

You can do that with the join icon.

This is a very frequently used icon.

Two.

The Multi Join icon.

This allows you to join data from up to five data streams based on the data in each of the data streams.

So if you have 4 or 5 different pieces of data, all stored in different places, that you need to join together to perform some analysis?

Then you can do that with the multi join icon.

This is a very frequently used icon.

Three.

The Pivot icon.

This is like the Excel Pivot.

It allows you to pivot flat data in to headers and rows.

This is a very frequently used icon.

The next file drawer is the Convert Data file drawer.

The icons have meanings that are relatively obvious for most of the icons.

In the Convert Data icons we have the following icons.

Find and Replace.

Header.

Page Break.

Replace.

Sort.

Split Header.

Substitute.

Text to Spreadsheet, which helps us put text based data in to spreadsheets.

Transpose.

In the File and Utilities icons we have the following icons.

You would only need to know about these icons once you are building capsules.

Clear Contents.

Clear Files.

Clear PC Files.

Clear Transformer Files.

Copy Icon.

Random Number.

Rename Icon.

Set Colors.

Set DBA Access.

Word Count.

In the Filter Data icons we have the following icons.

They are commonly used when you want to adjust data as it flows through the data processing process.

Clean.

Column Select.

Compress.

Conditional Clean.

Multiple Select.

Multiple Split.

Row Clean.

Row Select.

In the Prepare SQL icons we have the following icons.

Data Format.

Date Format.

Period Table.

Save For.

Write SQL.

In the Regression and Time Series icons we have the following icons.

These are used for statistical analysis of data.

Auto Correlation.

Auto Regression.

Correlation.

Elementary.

Forecast.

Moving.

Regression.

Seasonality.

In the Significance and Sample Testing icons we have the following icons.

ANOVA.

Chi Square.

Cross tab.

I P Mean.

Kruskal.

KS Test.

NP Correlation.

NP Independent.

NP Paired.

So what you can see from this very long list, is that there are a lot of icons and tools in Meta5.

These icons enable you to process and manipulate data flowing through a Meta5 capsule in any way that you choose.

This means you can perform analysis of data to answer your questions to support the decision making process for your company.

To summarize the way that this works.

You come up with an idea to make some business change, or implement some business initiative, that has never been done before in your company.

You go to Meta5 to test the idea against the data you have available to see if that idea is viable.

You are asking the question.

“What are the chances of successfully implementing this idea in my company?”

If you come to the conclusion that the idea has merit, you can create a business case.

You present that business case to the appropriate level of management that is authorized to approve your business case.

It might take you a couple of cycles to get your business case approved.

If the business case gets approved?

Then you can use Meta5 to measure the planned figures for the business case against the actual figures for the business case.

That is how Meta5 supports the management decision making process.

It gives you access to all the data you have, and it gives you the tools you need to analyze that data to support your management decision making process.

And it gives you the ability to see how your new business initiatives turned out.

Meta5 is unique in giving you, the power data analyst, everything you need to support the management decision making process, without getting caught up in the IT backlog asking for IT programmer time.

To do this any other way takes multiple tools or requires IT programmer time.

You can easily see the value of investing just 2 dollars a day in to your new Meta5 desktop.

Now you can log off your Meta5 desktop.

Meta5.

The better way.

This concludes our demonstration of the Meta5 desktop, and the basic icons that are available to you.

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.

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

I wish you a good day!

Thank you.

BIDA0018 – The History Of Meta5

0

Please note the script of the presentation is below so you can read along with the demonstration if you like.

Press the button to see a demonstration of the Meta5 desktop.

The Meta5 Desktop

Press the button to go to our “How Do I…”
series which contains detailed video training for Meta5.

GoTo How Do I...


Hello and welcome!

Thank you for dropping by our latest blog post today.

We really appreciate you taking the time to listen to, or read our latest blog post.

Thank You.

The purpose of this blog post is to share with you a little history of Meta5.

We hope that by hearing a little of the long and valuable history of Meta5 you will be interested to try it out for your self.

Ok?

Meta5 was cofounded in 1982 by one of the two best known names in Data Warehousing.

Ralph Kimball.

It was created with the vision of empowering the business users in businesses to perform their own data analysis and reporting.

Quite a vision at that time.

If you know the name Ralph Kimball you really should try out the product that he invented.

Why?

To see for yourself why it remains uniquely valuable to business users today.

We would argue that just knowing how much Ralph Kimball has done in the data warehousing area should catch your curiosity enough to ask.

“What was this product that he created in the early 80s, and why is it so unique even today?”

“Where can I get a copy to play around with and evaluate?”

After all?

Ralph Kimball introduced the star-schema to the world at Metaphor.

The star schema has now become the standard way of implementing data warehouse data models.

Our BIDA Data Models are based on Ralph Kimballs star schema work that originated at Metaphor.

So please allow us to go through some of the history of Meta5.

Why?

Because it’s history will tell you just how good it still is today.

Everything you hear about here is available to you today for as little as two dollars a day.

That is 720 dollars a year as a subscription fee.

Now.

Let’s get on with the story.

Ralph Kimball was one of the researchers at Xerox Park.

He was the coinventor of the future of computing as you know it today.

After Xerox Park Ralph cofounded a company called Metaphor Computer Systems.

The purpose of this company was to empower the power data analysts at the worlds largest consumer packaged good companies to do their own data analysis.

Their vision for this product was to deliver a graphical user interface similar to what had been developed at Xerox Park.

The vision was that business people, without the delays introduced by IT people at the time, would be able to do their own data analysis.

At that time companies like Coca Cola and Proctor and Gamble were spending large fortunes on advertising.

But it was extremely difficult to analyze and understand the return on investment of the marketing dollars.

A company called I R I had developed a cube based product to help in this area and they were doing well.

With the experience from Xerox Park behind them, the founders of Metaphor Computer Systems believed they could build a product that could be successful in this area.

They were very successful.

Metaphor Computer Systems released their first product in 1984.

By 1989 Metaphor Computer Systems was the second largest data analysis software company in the world after SAS Software.

With revenues of nearly 300 million dollars, and more than 200 employees, they were the fastest growing company in the Business Intelligence space.

They counted some of the worlds largest companies as their customers.

The most notable of these were Coca Cola and Proctor and Gamble.

And many other companies used the Metaphor Software.

The first question you should be asking your self is this.

“Why was the metaphor software so successful?”

There were a number of reasons.

One.

The interface replicated the office environment as it was envisaged at Xerox Park.

There were filing cabinets, folders, documents, envelopes, and mail boxes.

Business users could be given a metaphor desktop, and it was so intuitive, they would only need a few hours training plus the manuals to be able to get started using the desktop.

It was much easier to use than any other software available at the time.

And this remains true today.

Anyone who has worked in a real office can use the Meta5 virtual office with almost no training at all.

You can watch some how two videos, like the ones we are creating, and you can then find your way around Meta5 as it is today.

Two.

Metaphor gave the business users the ability to answer his or her own business questions.

For the first time ever, the business user did not need to go to IT and ask IT to build a report for them.

This had been a major goal of computing since the invention of cobol.

Metaphor was the first system where the business users did not need to learn something that looked like a programming language to be able to answer their own questions.

This removed IT from the loop of answering questions.

This was the biggest breakthrough of the metaphor software.

Even today, in 2021, business users still require IT to help them build reports and dashboards far more than they would like.

IT remains a bottleneck for business users getting their urgent and important questions answered.

Three.

The unique capsule tool.

Even today, no other company has implemented something so unique and useful as the Metaphor capsule.

Microsoft tried and failed to build a capsule tool for Microsoft Office.

Many companies have copied the unique capsule tool to a greater or lesser extent.

The unique capsule tool allowed the business user to build even very complex applications, in a graphical environment, with no programming skills.

The software also allowed for the packaging and execution of these capsules.

So capsules could be run by product group, or marketing manager, or any combination of any parameters the business users could think of.

The results were delivered via email or by shared drives, or even printed, copied and distributed by paper mail back in the 80s.

The bottom line was that with these three main features, and many more, the best and brightest business analysts could figure out more effective ways of spending the millions and millions of dollars of marketing budgets that were being spent across these massive companies.

In the 80s the companies with Metaphor did better than the companies without metaphor.

In many of those very large companies Metaphor was the difference that made the difference.

So what went wrong?

Why isn’t everyone using Metaphor today if it was that good as long ago as 1989?

Well, in 1989, a fateful event happened.

The CEO of Proctor and Gamble called the CEO of IBM.

In 1989 IBM was the worlds dominant computer company.

To cut the story short IBM liked Metaphor so much they bought the company.

IBM decided to make the product their leading program product in the data analysis area.

In 1989, that obviously sounded like Metaphor had hit the home run out of the park, right?

No one knew that there was about to be a battle for the desktop operating system.

Everyone assumed that the IBM operating system, called OS 2, would become the dominant operating system for personal computers in the business world.

Microsoft was even hired and paid to develop portions of OS 2 in the late 80s.

IBM was about business computers.

And OS 2 was going to be the dominant operating system for the Personal System 2 computers IBM was selling.

Metaphor had it’s own unix like operating system running on 32 bit motorola chips, the same chips used by apple.

IBM set a development path for Metaphor that they would drop the hardware and operating system they sold in favor of IBM personal computers.

The development path included the idea that Metaphor would migrate their software to run on the 32 bit version of OS 2 that IBM had scheduled to release in 1993.

It is now a matter of ancient history that in the 1989 to 1993 period, the relationship between IBM and Microsoft fell apart.

It is also a matter of ancient history that in the 1991 to 1993 period, there was a very deep recession that very badly affected many companies, including IBM.

Investment in capital equipment collapsed, and the IBM main frame computer business was very badly hit.

At the very same time, sales of mid range computers and personal computers were surging.

Microsoft and IBM had a major falling out.

Microsoft stopped working on the new 32 bit operating system IBM was developing.

IBM was confident that with the release of their 32 bit operating system, many years ahead of MicroSoft, they would own the business personal computer operating system market.

IBM was convinced that Microsoft would be relegated to selling spreadsheet software.

That was most certainly the view of IBM in 1991.

But that is not what happened.

IBM’s fortunes waned badly.

Microsoft was easily the big winner of the operating system wars.

Metaphor computer systems, being owned by IBM, was simply a small department in IBM.

They fell to the much bigger issue that IBM lost the operating system war.

The Metaphor software only ran on OS 2.

IBM refused to port it to Windows 95 when it was released.

By 1996 the worlds biggest consumer product manufacturing companies had a choice to make.

Windows 95 with Microsoft Office versus OS 2 with Lotus Smart Suite.

The vast majority chose Windows 95 with MicroSoft Office.

And this is the reason that you have not heard of Metaphor today.

IBM made the decision Metaphor would only run on OS 2.

And OS 2 lost the war with Windows 95.

Because they did not want business users to run two different operating systems just to use Metaphor, most of their big customers chose to go to other data analysis software,

Numerous other products became successful.

These included Hyperion, Cognos, Business Objects, and Micro Strategy among others.

They were the big new B I vendors of the day.

The really interesting thing is that all these tools required a great deal more IT work to be done for the business users to develop reports.

None of the B I vendors of the 90s were able to empower the business users to perform their own data analysis.

Again, IT became the gate keeper and bottle neck to data access in large enterprises.

Towards the end of the 90s, Ralph Kimball publicly lamented, that in the area of Business Intelligence, the world had snatched defeat from the jaws of victory with the demise of Metaphor.

In 2000, a company called Relational Data Systems, proposed to IBM that they would port the Metaphor software to Windows 32 bit operating systems.

Since IBM was not able to sell the Metaphor software on the now very dead OS two operating system, IBM agreed that Relational Data Systems could sell a version of Metaphor, that was ported to windows 32 bit operating systems.

And with this deal, the company, Relational Data Systems, was renamed to Meta5.

The next step after Meta four.

And a version of the Ralph Kimball inspired Metaphor software became available on Windows operating systems.

It was named Meta5 as well.

One more portion of the story we want to share with you is this.

In the 80s and 90s, B I Software was expensive, and Metaphor was no exception.

The round number to get 10 workstations installed for the top data analysts in a consumer product based company was 100,000 dollars.

In the 90s the normal minimum price to get a decent data warehouse up and running was around 1 million dollars.

With a starting price around 1 million dollars, B I systems were really only for the large companies.

In those days the customers had to also build their own data warehouses as well.

So a company who wanted to buy Metaphor software had a large investment to make.

Today, virtually all large companies have a data warehouse installed.

Most large companies have selected a B I vendor or two, or maybe more.

Today, you can get the Metaphor software, now called Meta5, for as little as 2 dollars a day for the single user desktop professional edition.

So.

Why would you want Meta5 on your windows desktop?

Two main reasons.

One.

You feel you spend too much of your time building your Excel reports and charts and you would like to reduce that time.

This will save you money and save you frustration.

And that is worth 2 dollars a day easy.

Two.

This is by far the more important reason you would want Meta5 on your windows desktop.

With Meta5 and Excel you will be able to perform any data analysis possible with Excel.

You will be able to improve your ability to make decisions in the business areas where you have decision making influence or control.

You will be able to build proposals to your senior management team for them to make the big decisions over the areas of the business where they have decision making control.

In short.

If you have Meta5 and Excel on your windows desktop.

If you have access to all the data resources of your company.

If you have access to the data from many third party data vendors.

You will become the “super star” of data analysis in your company.

If you want to be the “data analysis super star”?

Don’t use the same tools the other business users are using.

Use the tools that will empower you to figure out the issues and opportunities that no other tools available today empower you to do.

This was the vision of Ralph Kimball in 1982.

And Meta5 is the product of that vision in 2021.

With a free 30 day trial, and a 60 dollars per month subscription?

You have nothing to lose and a spectacular reputation in your company to gain.

And since we propose the end results of your analysis are presented in Office 3 6 5?

The final presentation of your proposals will be in the same tools that your senior management team are used to.

So, if I have gotten you curious to see what was the hottest B I product in the world and why?

Please just keep going through our demos and how two videos and see for yourself why Meta5 was everywhere smart decisions were made.

When you are ready?

You can get an evaluation copy of Meta5 from their web site.

Then you can download the demonstrations we have released on the blog post, H D 0 0 0 2, How Do I Install The Microsoft Meta5 Demonstrations.

We would be very happy to help you review the demonstrations and evaluate the Meta5 software.

Now.

Thank you very much for listening to or reading our blog post today!

We really appreciate you!

I wish you a good day!

Thank you.

HD0003 – How Do I Know What Data Is Available To Me?

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!

Thank you for dropping by to watch our latest how two video for Meta5!

We are really pleased to see you drop by.

Today we are going to show you how to know and understand what data is available to you through your Meta5 desktop.

Of course, you are able to select data from many places using Meta5.

You can get data from web sites, from spreadsheets, from word documents and from many other places.

However, the vast majority of data that you are going to access using your meta5 desktop is data in relational databases.

At worse, the vast majority of the data that you will want to access will be accessed by a piece of software called ODBC.

You do not need to know much about what ODBC is and how it works.

You just need to know that it is a way to read data that is very common.

And that is what we are going to show you today.

We are going to show you how to access data in a relational database using ODBC as the way you will read the data.

In most cases your ODBC connections will be created for you by your technical support staff.

We have created a how two video on creating ODBC connections to the demonstration databases that you can review if you would like to.

So if you are ready?

Here we go!

Let us go to the demonstration.

Let us consider you are a marketing analyst for the Adventure Works company.

You have just been given your brand new Meta5 desktop and you have been told that there is some documentation to load and reed.

What would that documentation usually be?

Well, firstly you would likely be given some PDFs of the data models that you will have access to.

Rather than showing you PDFs we will show you the Database Administration Tool.

It is in the demonstration folder and you should be able to connect to the DBA tool in your demonstration database if you have Meta5.

So we will go in to the oh one Adventure Works folder and we will find the DBA tool.

It is in the capsule called ninety eight Define Workstation Tools Data Dictionary for Adventure Works.

We will open the capsule.

And we will find the DBA tool in the bottom left hand corner.

We will open the DBA tool.

Now we can see the different categories that are available to me.

Each category contains a set of tables that are related to each other.

The Database Administrators set up these tools for us so we don’t have to worry about how they are created.

We just need to use them.

Now down the left hand side we see the names of the categories.

At the top of any list of categories are the Orphans.

These are any tables that are not linked to any other tables and are not used in any categories.

Hence the name Orphans.

Your database administrators should have made sure there are no orphans in your data dictionary.

Next you see a line that says Adventure Works.

This is where the categories start that you are interested in.

So you can see these categories.

Oh one. Internet Sales Facts.

Oh two. Reseller Sales Facts.

Oh three. Sales Quota Facts.

Oh four. Product Inventory Facts.

Eleven. Call Center Facts.

Twelve. Survey Response Facts.

Thirteen. Finance Facts.

Fourteen. Currency Rate Facts.

Fifteen. New Currency Rate Facts.

You can also see a line called Administration Tools.

And you can see the Workstation Tools Data Dictionary.

So you can write queries against the Workstation Tools Data Dictionary if you want to.

You can also see a category called All Tables.

Now, if we come back to the category at the top of the list.

It is called Oh one. Internet Sales Facts.

We select the category by clicking on it.

Then we can select show joins in the header bar.

Meta5 responds by giving us a diagram of the tables in the category.

You can see all the table names, all the column names, and all the joins.

You can see the database administrators have placed the drawings in to a nice format for me so it is easier to reed.

Now we can go back to the category by clicking on oh one Internet Sales Facts in the header to close the database diagram window.

Now we can get a list of the tables in the category by clicking on oh one Internet Sales Facts in the list of categories.

We can see the list of tables.

Now we will click on the Dim product table.

It opens up and shows you all the columns in the product table.

Take a few seconds to read some of the column names.

By all means hit pause in the video to review the column names.

So let us choose a very normal and common column name.

Color.

We will option it using F four.

We see that we have some options in describing a field.

It has an internal name.

It has a print name.

It has a SQL name.

And it has a description.

The print name and the description can be changed by the database administrators according to the desires of the users.

In fact the users can enter these names in to excel workbooks and the database administrators will apply those changes.

So because your user representatives control the print name and the description, that helps you understand the contents of the fields.

In your job as a marketing analyst for Adventure Works you would have to make sure you spend time to learn all the fields that are available to you.

Now we will close the products table.

And we will open up the description of the Fact Internet Sales table.

We will look at some of the fields on this table.

We have such fields as.

Sales Order Number.

Sales Order Line Number.

Order Quantity.

Unit Price.

Extended Amount.

Sales Amount.

Tax Amount.

Customer Purchase Order Number.

Order Date.

Due Date.

Ship Date.

These are all very standard fields to have on an internet sales record.

As a marketing analyst for Adventure Works you will have to understand what these fields mean and how they work.

Now we will close the DBA tool.

And we will close the capsule.

Now we will go and look at some actual data.

In general, before releasing new areas of the data warehouse to users, the database administrators will create sample query icons for each of the categories and will put some test data in to a spreadsheet for you.

This is to give you more information to learn from without having to go and download data for your self.

The database administrators will also put constraints on these queries so that they only return a relatively small number of rows.

It is a common mistake for new users of query icons to simply ask for all data in a table to be put into a spreadsheet to see what is in the table.

Of course it is not possible to put millions of rows of data in to a spreadsheet.

So the database administrators will create these icons to make sure that is less likely to happen.

So we will open up the folder oh two Adventure Works Sample Query Icons by clicking on it twice.

Then we will open the capsule oh one sample query icons by clicking on it twice.

Now we can see nine sample query icons with another nine spreadsheets to capture the data from the query icons.

So let us option the oh one Internet Sales Fact query icon by clicking on it and pressing F four.

Then we will click on other data.

Now we can see that the database administrators have been kind to us.

They have set up the parameters in other data.

You will notice that the gateway is set to ODBC.

This is what we mean when we say we can access any data that is visible by ODBC.

Next we see the database name is set to Adventure Works data warehouse meta5 access database.

This is the workstation tools data dictionary database that your database administrators downloaded as a sample database and put on to your system for you.

You can see that the parameter to use the workstation tools data dictionary database has been set to yes.

The workstation tools data dictionary database owner has been set to D B O.

And you do not need to be concerned about security because the database administrators have taken care of that.

So we will close this window by clicking on icon options in the header.

Now we will open the query icon by clicking on it once.

We will click on show controls.

And here we can see a graphical representation of just the tables that have at least one field in the query output.

We will click on the star button in the top right hand corner of the query icon.

Then we will click on capture SQL.

Then we will resize the window and place it more toward the center of the screen.

Then we will click on show data.

We can see that the query tool generated SQL and sent the SQL to the database.

The database ran the SQL and returned the data to the query window.

And we have 555 items found in the database.

You will notice the fields are a little wide as the query tool allows for the maximum length of a field in the query window.

Now we will close the query log.

Now we will show the query catalog.

The query catalog shows all the tables and all the fields that are available to the current query.

In today’s world we often have very large numbers of tables and fields.

So it is common to give users access only to those fields that are commonly needed in the broadly distributed workstation tools data dictionaries.

Where access to fields that is not common is needed another dictionary can be used.

This is just to save many people the time of learning about fields that they will almost never use.

Next we will show the DBA catalog by clicking on that in the header.

Now, down the left hand side we can see each of the categories that we saw earlier in the database administration tool.

Notice the first three are as follows.

Oh one. Internet Sales Facts.

Oh two. Reseller Sales Facts.

Oh three. Sales Quota Facts.

Notice that the tables in the category oh one Internet Sales Facts are highlighted.

This means that they are in use, or available for use, in the current query icon.

By coming in to the DBA catalog and clicking on a category you can gain access to the tables in that category.

Just while we are here we will click on the star in the top right hand corner of the query catalog window.

And you will see the option read DBA catalog open up.

If the database administrators have changed something about the database that your query icon needs to know about you can refresh the DBA catalog for this query icon by clicking that option.

Notice that once a database category is rolled out to the user community the only changes that should be happening to it are the addition of fields or tables.

You should never be removing fields or tables because existing queries might be broken by such processes.

Now we will close the query catalog window.

And we will close the query control window.

Now we will click on the star at the top right hand corner of the query window again.

We will click on remove expert functions.

When we do that you will notice that the option called create column will disappear from the header of the query window.

Now we will click on the star again.

And we will click on add expert functions.

And we will see the create columns option come back.

Now we will click on clear data.

Now we will click on create column.

And you will see the computed column options window will open up.

You can place any snipped of SQL code that works for your database in that window.

Now we will close the computed column options window by hitting cancel.

We will open up show controls again.

And we will click on Fact Internet Sales field called Sales Amount to highlight it.

While it is highlighted we will click on Create Column in the query window.

Notice that the query icon has completed the form with the default operator sum, the formula containing the Sales Amount field, and it has already included the group by fields.

All we need to do is to add a label.

And we can add a label of our own choice or we can copy the Sales Amount field using the mouse functions.

We will do that just to demonstrate.

Ok?

That is a little about finding your way around the query icon.

Now we will cancel this computed column options window.

We will close the query control window.

We will close the oh one Internet Sales Facts window.

And we will open up the spreadsheet next to it by clicking on it twice.

Now we can see some of the data that was returned by the query icon only without all the blank spaces.

In this way you can write queries against the database and dump data in to spreadsheets and learn the data by looking at samples.

Looking at sample data is always the best way to learn about the data that is available to you.

Now we will close the spreadsheet.

Now we will open oh two reseller sales facts by clicking on the query icon twice.

We will click on show controls.

We will click on show query catalog.

We will click on show DBA catalog.

And now we can see that the tables in the category oh two reseller sales facts are highlighted.

You will notice that many of the tables have the same names as the tables in the oh one internet sales facts category.

And this is because they are mostly the same tables.

Tables like Dim Product, Dim Currency, Dim Order Date are all the same tables.

But in the oh two reseller sales facts category they are joined to the Fact Reseller Sales table and not the Fact Internet Sales table as they were in the oh one Internet Sales Facts category.

So you can see that if you are a marketing analyst for the Adventure Works Company you must get sales data for internet sales from the oh one Internet Sales Facts category and you must get reseller sales from the oh two Reseller Sales Facts category.

And, of course, to get total sales you must find a way to add these two together because that has not been done for you.

So while we have this query catalog open.

You can see that you can get the idea that each query icon generally gets data from one and only one category.

When we need to join data from many categories together, such as we want total sales and we need sales from oh one Internet Sales Facts and oh two Reseller Sales Facts, we have another tool called a join tool to do that for us.

In such cases we have to take care of the cases where there are not sales of products through both channels.

Perhaps there are some products we only sell via the internet and other products we only sell via resellers.

We have to be careful not to lose any sales data as we attempt to join the results of the two queries together.

We will show you how to do that in a later how two video.

Ok.

Now we will close the query catalog window.

We will close the query control window.

We will go across to the star and we will open the capture SQL window and bring it to the center of the screen to make it more readable.

We will click show data.

And there you have it.

Another SQL query generated and another set of data brought back to us by the query tool.

Now we will close the query log.

We will close the oh two Reseller Sales Facts query icon.

And we will open up the spreadsheet next to it by clicking on it twice.

And here we can see the data that was output by the query icon without all the extra spaces.

This is how you go about learning what data is available to you.

By building small queries and looking at the data that has been returned.

In the first instance the database administrators will provide you a set of such queries and spreadsheets as you have seen here.

After that you will have to explore your self or talk to your fellow business analysts and ask them if they have more details.

You may also be provided with reports or spreadsheets listing all the table names and their descriptions.

You may also be provided with reports or spreadsheets listing all column names and their descriptions.

All that information is available.

It is just a question as to whether it has been prepared in to reports for your use in your company.

Ok.

Now we will close the spreadsheet.

And we will close the oh one sample query icons window.

And we will close the oh one Adventure Works folder.

Meta 5.

The better way.

This concludes our demonstration of how to know and understand what data is available to you through your Meta5 desktop.

We hope you liked this short how two video.

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

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

I wish you a good day!

Thank you.

HD0002 – How Do I Install The Microsoft Meta5 Demonstrations

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!

Thank you for dropping by to watch our latest how two video for Meta5!

We are really pleased to see you drop by.

Today we are going to show you how to install the Microsoft Meta5 demonstrations on to a windows server such as Windows 2012 R Two.

Of course you can also install all these demonstrations on to a windows ten workstation.

It is just more normal to install SQL server and Meta5 server software on to a windows server rather than a windows ten desktop.

We do not do any of our Meta5 testing on windows 10 desktops, so we can not provide you any advice and guidance on how well that works.

In this demonstration we are using an almost blank virtual machine so that you can see things being set up pretty much as you will see them when you first install these demonstrations.

Ok?

So, let us go to the demonstration.

So here we are on our META5 DEV oh one desktop.

The first thing we need to do is to download the demonstration files.

Currently these are available as downloads direct from our web site on the relevant blog post.

You do not have to request the download files via an email form at the current time.

This might change in the future.

So we are mentioning this possibility in this video in case the download button has changed to an email form at some time in the future.

As at the time of writing, and included in the video, the demonstration files are available as a download using the button on the blog post.

So the first thing you will need to do is to download the demonstration files from the blog post.

So now go to your browser.

Now enter our web site address.

Now click on the blog menu item.

Now scroll down to the blog post, H D 0 0 0 2, How Do I Install The Microsoft Demonstrations blog post.

Now click on the blog post.

Now scroll down to the point in the blog post where you can click on the download button.

Now click on the download button.

You will see the download start.

It might take a while because the download is coming from our web server in the U S.

Once the download is complete, then click on show all in your browser.

Now click on show in folder.

From inside the download folder click once on the left mouse button on the download file.

Right click on the download file.

Extract the files from the download file.

Go into the folder you extracted the download files in to.

You will see that we have also provided you the Adventure Works and Wide World Importers data warehouse databases provided by Microsoft.

This saves you the effort of fetching them for your self.

You should see 6 files.

They are as follows.

Oh one. Adventure Works dot M 5.

Fifty one. W W I, Demos dot M 5.

ADVENTURE WORKS D W M 5 A dot back.

ADVENTURE WORKS D W dot back.

WIDE WORLD IMPORTERS D W M 5 A dot back.

WIDE WORLD IMPORTERS D W dot back.

The files that have the suffix dot back, are SQL Server back ups of the demonstration databases.

They are backed up from SQL Server 2016.

They will work on later releases of SQL Server.

They will not work on prior releases of SQL Server.

They will not work on SQL Server Express as far as we are aware.

We are not going to demonstrate how to perform restores on these databases.

If you do not know how to restore a SQL Server backup, please ask your Database Administrators to help you.

Or please perform a google search.

There are many demonstrations of how to do this already out on the web.

So it did not seem sensible to re-do the database restores to show you what happens during that process.

In this demonstration we have already performed the restore process for the SQL Server databases.

We will show you the folder that we placed the databases in to.

This is the folder that we placed the databases into.

We will also show you the SQL Server Management Studio window where the databases have been restored.

This is the SQL Server Management Studio window where you can see the databases have been restored on this server.

Next you will start the Meta5 system.

In our case we are using Meta5 Professional Edition for this demonstration.

So now double click on the Meta5 Icon.

We will pause the video so you do not have to wait for the start up process.

Next you will type in the user id and password for the desktop that you have.

Now your desktop will be open.

Next you will need to move the Meta5 desktop to one side so that you can see the downloads folder.

Now put the mouse over the heading bar of the Meta5 desktop.

Now left click on the mouse and hold down the mouse button.

Now move the Meta5 desktop to the right so that the downloads folder in windows explorer is visible.

Now put the mouse over the file, oh one, Adventure Works dot M 5.

Select the file oh one, Adventure Works dot M 5, by left clicking the mouse and holding down the mouse button.

While holding the left mouse button down, drag the oh one, Adventure Works dot M 5 file from the external Microsoft operating system on to the Meta5 desktop.

Now release the mouse button to drop the file on to the Meta5 desktop.

Meta5 will now translate the archived Meta5 file to the required files on the Meta5 file server.

This process might take a little while for large Meta5 archives.

Next hover over the second file.

Fifty One, W W I, Demos dot M 5.

Then press down on the left mouse button.

While holding the left mouse button down drag the file from the windows operating system across to the Meta5 desktop.

Release the left mouse button to drop the file on to the Meta5 desktop.

Meta5 will now translate the archived Meta5 file to the required files on the Meta5 file server.

This process might take a little while for large Meta5 archives.

The next thing you need to do is to connect the Meta5 demonstrations to the databases that you restored to the windows server.

We have produced a separate how two video to do this task..

It is called H D 0 0 0 1. How Do I Create An ODBC Connection For Meta5.

You can find it on our web site.

Please note that the ODBC connection must be created on the same desktop that is used to install Meta5 Starter Edition.

If you install Meta5 using a different desktop to the desktop you used to create the ODBC connection, Meta5 may not be able to find that connection.

You can always check by reviewing the ODBC 32 Bit connections administration panel.

So by this point we assume you have created the two ODBC Connections.

This will be as per the blog post , H D 0 0 0 1, How Do I Create An ODBC Connection For Meta5.

Now You must move the Meta5 desktop back to the left of the screen.

Move the mouse over the header bar of the Meta5 desktop window.

Press and hold down the left mouse key.

Drag the Meta5 desktop window to the left so that you place it correctly on the windows desktop.

Now you can open up the folder, oh one, Adventure Works.

Hover the mouse over the folder and open the folder by clicking on it twice.

You will see four folders.

oh two. Adventure Works Sample Query Icons.

Eleven. Adventure Works Example Report oh one.

Ninety Eight. Define Workstation Tools Data Dictionary Adventure Works.

Ninety Nine. Workstation Tools Data Dictionary Meta Data V one point six.

You are interested to know if the files in oh two, Adventure Works Sample Query Icons folder made the trip from our web site to your Meta5 system without any problems.

So now open up the oh two, Adventure Works Sample Query Icons folder by clicking on it twice.

Now open up the capsule, oh one Sample Query Icons, by clicking on it twice.

Now you will see nine query icons and nine spreadsheets in the oh one Sample Query Icons capsule.

Open up the oh one Internet Sales Facts query icon by clicking on it twice.

If you have created the ODBC Connection correctly, then the query icon should open up to the query panel and the query control panel will also likely be open.

Now click on Show Data in the header bar of the oh one Internet Sales Facts query icon.

You should get 555 rows returned by the query.

If this happens then you have managed to install the demonstrations properly on your Meta5 desktop.

Congratulations!

Next you need to make some changes to support the example capsule that generates reports for the adventure works database.

So now close the oh one internet sales facts query by clicking on the name of the query in the header.

So now close the oh one sample query icons capsule by clicking on the name of the capsule in the header.

Now close the oh two Adventure Works Sample Query Icons folder by clicking on the name in the header.

Now open the folder, Eleven, Adventure Works Example Report Oh one, by clicking on it twice.

Now open the capsule, oh one, Adventure Works Example Report oh one, by clicking on it twice.

Now open the capsule, Adventure Works Capsule oh one, by clicking on it twice.

Now go to the first PC Directory Icon in the middle of the screen and hover over the top of the icon with the mouse.

Now open the options panel by clicking on the icon once to highlight the icon and then pressing F four.

Now click on Other Data.

You will see that the Directory Name Parameter is set to C, colon, back slash, A, BIDA, HOSTING.

You must create this directory name on your server.

You can not use a different directory name for the demonstration to work.

So now you will go to windows explorer and create this directory name.

Now click back on the Meta5 desktop.

Now close the icon options by clicking on the icon options in the header.

Now move the mouse to hover over the second PC Directory icon in the bottom right hand corner.

Highlight the PC Directory Icon by clicking on it once.

Open the icons option panel by pressing F four.

Now click on Other Data.

You will see the Directory Name is set to C, colon, backslash, change me.

You must put a directory name in this parameter that exists on your Meta5 server.

In our case we will create a directory called, Z oh one dash sample reports.

We will type that name in to this Directory Name parameter in the demonstration now.

We will go and create the folder on the C drive of this virtual machine now.

Notice that we have not put the at , A, A, variable at the end of the Directory Name Parameter as we have it in our demonstration videos.

You can do that if you wish.

However, if you put the at , A, A, variable in to the directory name parameter then you must go and create the three sub directories in the target folder as well.

Meta5 will not create these directories for you.

The capsule will fail if the directories do not exist because the write of the excel spreadsheet will fail.

If everything has been installed correctly it will now be possible to run this capsule.

So we will now run this capsule from the beginning just to see if it will run.

Now close the icon options for the PC Directory Icon by clicking on icon options in the header.

Now Close the capsule Adventure Works Capsule oh one by clicking on the capsule name in the header.

Now you are in capsule oh one adventure works example report oh one.

Click on the white space in the capsule to dee select the capsule adventure works capsule oh one which will still be selected by default.

Now click run in the header of the capsule oh one Adventure Works example report 01.

The capsule will run if all has worked properly.

Please cross your fingers for us!

Ok?

And there you have it.

The capsule ran correctly.

We will now go to the folder called Z oh one dash sample reports.

Now you can see the finished spreadsheets from this capsule.

Now you can open up one of these spreadsheets.

We will open up the Europe spreadsheet just to demonstrate that the spreadsheet is there and working.

If all this has worked on your Meta5 desktop then we wish you congratulations for getting your first capsule to run on your Meta5 desktop!

Congratulations!

Now.

We would recommend you watch the video on the blog post, H D 0 0 0 3, How Do I Know What Data Is Available To Me?

This video will take you through how to check your installation and how to discover the data that is available to you in the demonstrations.

Now you can log off your Meta5 desktop, satisfied with a good days work!

Meta5.

The better way.

This concludes our demonstration of how to install the Microsoft Meta5 demonstrations on to a windows server such as Windows 2012 R Two.

We hope you liked this short how two video.

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

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

I wish you a good day!

Thank you.

HD0001 – How Do I Create An ODBC Connection For 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!

Thank you for dropping by to watch our latest how two video for Meta5!

We are really pleased to see you drop by.

Today we are going to show you how to create ODBC Connections for Meta5.

This is so that Meta5 can access any data that is available using ODBC.

In this video I am going to show you how to create ODBC connections so that Meta5 query tools and database administration tools can connect to the database.

We are going to connect the Adventure Works data warehouse database and the Wide World Importers data warehouse database.

Both these databases are available from Microsoft.

We have built some demonstrations using these databases.

Now.

Let us get started with the demonstration.

We are going to start with SQL Server.

We are going to click on SQL Server Management Studio.

And of course, this could be any database in any studio, as long as an ODBC connection is available.

We have a server name of Meta5 dev oh one.

We are using Windows authentication.

So we are just going to connect with that.

We go into databases.

We are going to connect the Adventure Works data warehouse Meta5 Access database.

And we are going to connect the Wide World Importers data warehouse Meta5 Access database.

We are going to connect both of them in this demonstration video.

We click on copy.

Now we need to go to the ODBC configuration panel.

We must use ODBC 32 bit.

So please make sure you select ODBC 32 bit.

We click on add.

We scroll down to SQL Server.

Click on paste.

Click on paste in the description.

The servers name is Meta5 Dev oh one.

Of course you would put the name of your database server that you will connect to ODBC.

We say with SQL Server Authentication.

We have created a System Administrator user I D and we have created a password.

Then you click on next.

Then change the default database to the Adventure Works D W M 5 A,. database.

Then we can test the data source is working.

O K.

That is successful.

Now we are going to create the ODBC Connection for the Wide World Importers D W M 5 A, database.

You can follow along on the screen as we create that connection.

And now you can see we have two 32 bit ODBC connections in the ODBC data source 32 bit administrator panel.

This concludes our demonstration of how to create ODBC Connections for Meta5.

We hope you liked this short how two video.

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

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

I wish you a good day!

Thank you.

HD0000 – Welcome To Our How Do I Video Series

0

Please note the script of the presentation is below so you can read along with the presentation if you like.


Hello and welcome!

Welcome to our new how two series of videos.

Our initial set of videos will be for the Meta5 product.

We will have other how two videos for other areas of Business Intelligence in the future.

If you have a question around how do I do something or other specific to Business Intelligence?

Please feel free to use the contact form below to get in touch with us and ask.

We might even do a video about your question if it is a good one that many people have.

This first video series for Meta5 is intended to serve two main purposes.

One.

It will be a quick reference video look up on you tube, and at the customer site, for how to do specific things in Meta5.

This is the primary reason we are creating this series of videos.

Two.

There is a second reason we are creating this series of videos.

We want to show the hundreds of millions of Excel users out there that there is a better way to get data in to Excel.

We want to show the hundreds of millions of Excel users that Meta5 is the perfect companion product for Excel.

We want to show the hundreds of millions of Excel users that Meta5 will save them many hours of work in building their Excel reports and charts.

Pretty much all the data that Meta5 can generate and derive through its 150 plus tools can then be sent in to Excel for further processing, charting and reporting.

No other tool in the world has the user base that Excel has.

And those users are spending too much time preparing data for reporting and charting.

This is where Meta5 excels, if we may make that joke.

Meta5 will save you hours and hours of time in data preparation for your Excel reports and dashboards.

So with that?

We would like to welcome you to our how two series for Meta5.

We hope you like it.

Welcome!

Thank you for your time.

I wish you a good day.

BIDA0017 – First AdventureWorks Dashboard – Details

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.

My name is Mihai Neacsu and I am the business development manager here at BIDA.

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

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

Todays video is going to be the very detailed demonstration of our prior summary video about Meta5 and Excel reporting.

Ok?

The prior video we just released talks at a very high level.

It is just a 10 minute video that shows you that it is possible to create what is called a Meta5 capsule.

Capsules can run in your ETL stream after all your data is prepared and capsules can create many reports.

Capsules can send out individual, customized Excel dashboards containing only the data that is necessary for the individual people who are the users of those dashboards.

These dashboards are sent out via such tools as One Drive, and then your One Drive distributes the reports according to the rules that have been defined.

Your users receive their excel dashboard via such mechanisms as the one drive or sharepoint portal or whatever mechanism is being used to receive reports.

Even email is supported.

The placement of excel reports in folders is controlled through the capsules.

The prior demonstration was to show you at a high level that this is possible, this is viable, and it gives you the ability to do excel reporting out to the masses across your company, faster, cheaper and better.

So if you have a large number of users who want excel reports across your organization and it is costing you time and effort and trouble to do that?

Or if you have to be linked back to an SSAS server for them to do that and you have to have high speed connections?

What this demonstration shows you is that it’s possible to produce the excel spreadsheet in a centralized location, say, near your data warehouse or near your ER.

Then put it into the One Drive, and have the one drive send it out to the users, ready waiting for them at 9 o’clock in the morning when they come in to work.

Ok?

That is what the previous demonstration was all about.

Todays demonstration is the details of showing you how that is possible.

How we do it.

This is a demonstration for more technical people who are asking:

“What makes Meta5 different to SSAS? Why would we use Meta5?”

That’s what we are going to show you today.

So sit back, relax and enjoy the show!

 

So here we are on my meta5 workstation desktop.

This is just the starter edition.

You can see I have opened up a folder called Adventure Works.

And inside that folder I have another folder called report examples.

And inside that folder I have a capsule with Adventure Works Example Report 01.

This is the capsule I am going to show you today.

Ok?

Now the first thing we have is this thing called a sales territory query.

This is a query icon.

We will open it up.

We click show controls.

You see this is dim sales territory out of the adventure works database.

It is getting us all the territories except the NA one.

We are calling the result at A A which is called a capsule variable.

We will turn on capture SQL so you can see what is going on.

When we hit show data and you can see the SQL that has been issued.

It has done a select distinct DimSalesTerritory.SalesTerritoryGroup from DimSalesTerritory where not DimSalesTerritory is equal to ‘NA’ order by DimSalesTerritory.

So, a simple sql statement to get the SalesTerritoryGroup from the adventure works database.

Now I will show you the query catalog.

These are all the tables available in the adventure works sample database.

You have the Product Sub Category.

Order Date.

Due Date.

Ship Date.

Currency.

Employee.

Product.

Product Category.

Promotion.

Reseller.

Sales Reason.

Sales Territory.

Fact Internet Sales.

Fact Reseller Sales.

Now you should recognize these from the adventure works database.

If you are watching this video you should be familiar with SQL Server and the Adventure Works Sample database.

So that’s our query catalog.

We can query any of those tables.

Now what this capsule does is it sends those three records, one at a time, in to the second capsule.

It sends them through the arrow in to the region name controls of the second capsule.

These are the control variables of the receiving capsule.

It is sending the region name to at A A which is a variable.

So when I open up the capsule and I click show controls and I go to at AA you can see Sales Territory Group.

You can see it is set to Pacific which was the last value from the previous run of the capsule.

I want you to understand that it runs the capsule three times.

We call it iterations of the capsule and it runs that capsule and sets that variable.

Now in front of you, you have a fairly strange thing that you have probably never seen before.

Capsules are 40 years old.

They were invented in the early 80s.

They were the first real graphical programmable environment to build applications in and many companies have copied the capsule idea.

For example if you look at datastage or informatica you will see they have copied the meta5 capsule.

So let us say you want to build a dashboard.

Let us go and look at a finished dashboard.

We come over here to Europe and we are going to open this example dashboard.

And we are going to look at what’s inside it.

So your user comes to you and says:

Hi Mihai, I want you to build a dashboard with the reseller order amounts and the internet sales amounts from the adventure works database.

And I want it by region and I want to show the categories and the currencies and the countries and those sort of things. Mihai, can you do that for me please?

And the user gives you a sketch of this sort of report and says “this is what I want it to look like”.

Ok? Let’s say that happens.

So you sit down and say Ok, the user wants a new dashboard and he has given me a description of what needs to be on it, and maybe he has created a sample excel spreadsheet, and it’s my job to build it.

And the user wants it distributed out to the individual region managers.

How do I do all that?

Think about how you do that today.

We are going to show you how that is done with Meta5 tomorrow.

On the left hand side all the normal things with dashboards are supported.

I can click on multi-select for country and then click on France and then it is also going to give me data for France as well as the United Kingdom.

I can click on Germany and it will show me data for Germany.

I have got multiple currencies selected which is adding up different currencies which does not make sense of course.

So if I click on Euros it’s going to show me euros.

If I click on british pounds it’s going to show me pounds.

If I click on US dollars it’s going to show me US dollars.

I can click on bikes. It’s just going to show me bikes.

So let us have a look inside this spreadsheet.

Just to see what is in here.

We are going to go into power pivot, and we are going to look in to the data model.

We are going to click on manager data model and look inside the data model to see what is there.

We are going to look at the diagram view.

So what do we have in here?

We have the years dimension.

A months dimension with month number and month name.

A countries dimension with country.

A product categories dimension with product category key and product category.

And currency dimension with currency key and currency.

And we have a sales fact table.

The grey fields means they are hidden from tools.

We have the sales group, the country, the region, the product sub category, the reseller order amount and the internet order amount.

That is what we have in our little mini-fact table.

Of course, with power pivot for excel I can have lots of dimension tables and lots of mini-fact tables.

I can have them all linked together.

I can have the slicers linked to these dimension tables.

Ok, to get my final excel workbook working I need years, months, countries, product categories, currencies and sales facts.

Now if I am working in a mature data warehousing environment maybe I already have an SSAS cube that has this information in it.

Maybe I can just link my excel spreadsheet to that cube.

Or maybe I have a well developed data warehousing enviornment and a well developed way of getting to this data and I can dump the data into Excel and build this dashboard.

Maybe, right?

Today what we are going to show you is how to do this with meta5.

Obviously when we go over to data view and we click on years dim there are the years.

We click on months dim there are the months.

We click on countries, there are the countries.

Remember, for countries, this is only after the selection for regions has been done.

Notice this data is just for the European region.

We click on product categories, there are the categories.

We click on currencies, there are the currencies.

And lastly sales facts.

And in sales facts we scroll down and we see 1,629 records.

And you can see the greyed out columns are the columns that can’t be presented to a tool.

And indeed, we could drop the greyed out columns from the data to have less data in the table.

We have kept them in the workbook just so you can see they are there.

We come over to the right to product sub category and you can see the reseller order amounts. When we scroll down a bit we can see the internet order amounts.

We can take out the greyed out fields if we want to, this is just an example to show you what is possible.

So this dashboard is what your user wants, and he wants it distributed to the correct users across a network.

And let us say they just want the data in the workbook for the person using the workbook.

So let us say that is what the users want.

How would you do it with Meta5?

This is called a Meta5 capsule and what we are going to do today is we are going to go through this in detail to show you exactly how you would produce the finished Excel dashboard.

We are not going to show you the construction of the dashboard itself.

We are going to show you how the data gets in to the dashboard to then be used inside the dashboard supported by the ability to be distributed across a one drive network.

You could use other ways of distributing the dashboards.

We are using one drive as an example.

You saw inside the Excel dashboard we had Years, Months, Countries, Product Categories and Currencies.

And you can see these capsules labeled with these names.

So we open up years.

And you see this little visual programming environment.

We open up the years query icon and click show controls and you can see the query for years.

We see the order calendar year.

We have restricted it to just 2012 and 2013 because that is all the data there is in the adventure works database.

We will select capture sql just so you can watch this.

We click on show data.

You can see the sql was generated and run.

You can hit pause read the sql generated for your self.

So the meta5 query tool returned me the years and then it has sent the years in to the spreadsheet next to the query tool.

You can see the data in the spreadsheet.

Then it runs an icon called “remove header”.

It says “rows to delete” and it deletes 1 row being the header row.

We have another spreadsheet which is called “headings”.

And it says “Year”.

Why do we have this?

If we come along later and we change the description of a column in the meta5 dictionary that name change will flow through the capsule in to the workbook.

This will then cause a problem in the workbook.

So we must create fixed heading names that will never change and can not be accidentally changed in the meta5 dictionary.

So in the final spreadsheet in this capsule we see two small regions, one for the heading “Year” and one for the data for the two years we have.

And then the data goes along the arrow to this out icon called Years.

The Out icon sends the data out of this little capsule to a capturing spreadsheet.

If we click on the arrow you can see that it is copying data from the region name Years. That is the little out icon inside the Years capsule.

In the target spreadsheet we have the year heading and then 2012 and 2013 as the two years.

That is the dimension table for years that is going to wind up in the excel spreadsheet.

Then we have months. And we can click show data. And we see the months 1 through 12 and January through December.

And we see the headings month num and month.

And we see the final spreadsheet with month num and month.

Being sent to the months out arrow.

And we see the arrow is reading the data from region name months in the source capsule and sending it to the target spreadsheet.

So in the months spreadsheet we have month num and month, 1 through 12 and January through December.

Ok? Do you see how that works?

Same with countries.

Now countries is a little different because when we look at the query for the countries we see at A A set as the constraint for sales terriroty group.

If we click on capture SQL and we click on show data we will see “Australia” as the returned country and we will see in the SQL the constraint on Sales Territory Group of “Pacific”.

The at A A variable has inherited the value “Pacific” and sent that to the database to get the countries just for Territory Group “Pacific”.

So whatever constraints we want to place on a query to the database we feed those values in to the capsule through the controls and they come from the controlling query.

Then we would produce a spreadsheet just for Pacific.

Again we have headings for Country and we are going to have the final spreadsheet contain the heading Country and the value Australia.

So countries are sent to this spreadsheet.

Next we have product categories.

And you can see product category keys and values.

And this is going to be the data in the dimension table in the power query for product categories.

We open up the capturing spreadsheet and we can see product category key and product category values.

And then we have currencies.

In the database there is a long list of currencies but there are only sales records for a small number of currencies.

The rest of the currencies will be ignored by the slicers because there are no sales records for them.

In the currency spreadsheet you see currency key and currency value.

So these are the dimension tables that are going to be in the power query which are going to be attached to your slicers.

Your business user says I want these slicers on my dashboard and I want these charts sliced by these slicers.

These capsules are the way you get the data to build the slicers.

Of course in a mature environment these capsules will be created for you and you will copy them in to your capsule. You will not develop them your self.

The next thing you need to get are your sales facts.

Now remember there were internet orders and reseller orders and these rows are in two different fact tables.

We open up the sales facts capsule and the first one we will look at is reseller facts.

We click on show controls.

You can see the query that has been created on top of the adventure works database.

You have the product category, product sub category, product, order date, territory and then the reseller facts.

You can see the constraint on the sales territory group set to at A A so it is going to inherit the value of that variable and send it to the database as a constraint.

We have set the order date to just 2012 and 2013.

Now we do capture sql and click show data.

The sql is a little hard to read because it does not insert new lines but you can hit pause and read the sql for your self.

You can see it is normal generated sql from the query tool.

It has found 194 rows for the pacific sales territory group.

It sends the rows in to a spreadsheet.

We open the spreadsheet and here is that data.

The other data we need is we need internet sales facts.

So when we click show controls here you have fact internet sales as the fact table.

This is a different fact table, but of course, the dimensions are the same and the constraints are the same. But it is a different fact table.

If you are familiar with building dashboards where the facts come from different fact tables you are familiar with the problems of doing that.

What we do with Meta5 is we go and query individual fact tables and we go and get the details. And then we join them together to send in to whatever the reporting tool is. In this case, Excel.

When we hit show data we get 245 items because, obviously, the number of rows should not be exactly the same.

Then in the capsule there seems to be 2 streams of data and then there seems to be a join.

I want to just to mention that you do not need all these spreadsheets in this capsule.

We are putting the data in to spreadsheets so you can see the data at each step.

So we get the reseller sales.

We get the internet sales.

We then run the reseller sales through a sort.

And we sort by columns a through m.

We then run the internet sales through a sort.

And we sort by columns a through m.

So we are doing 2 sorts and putting the results in to 2 spreadsheets.

And then we are going to do a join.

And this is the most difficult piece of building dashboards with lots of measures on the dashboards.

Taking data from multiple different fact tables, maybe from multiple source systems and presenting them on one consistent dashboard.

This is a two way join.

We have a two way join and a five way join.

We have table 1 and table 2.

And then output data.

We click on show controls.

You can see the columns that are being used to join are a through m for each table.

You see there is 1 heading row.

You see the join type is outer join.

You see that when a row is not present in both input spreadsheets that the default value of 0 will be used.

So where there are reseller sales but no internet sales the amount for internet sales will be set to 0.

So where there are internet sales but no reseller sales the amount for reseller sales will be set to 0.

This ability for end users or report developers to join data streams from multiple fact tables or sources like this is one of the big features of meta5 and what makes meta5 so useful.

Also, in our first demonstration dashboard we had 6 mini fact tables in the power pivot model. So you can build multiple fact tables in to the power pivot model and have the dimensions around them and have the slicers slicing in to multiple fact tables in the power pivot model.

It is actually pretty cool.

On the right hand end of the out table you can see how the two extended amounts are present from the two input fact tables. The join has been successful.

Then it is going to put the joined data in to a spreadsheet.

You can see in the spreadsheet how we have the extended amount for both internet sales and reseller sales which are coming from two different fact tables.

Then we run it through a clean icon. In this case this will do nothing.

Then we run it through a compress icon to delete the heading row.

We have a headings spreadsheet.

In this spreadsheet we have the column headings we want to pass in to Excel and they can never change once set and sent to Excel.

These headings will not change even if the meta5 dictionary names are changed.

We send the headings and data to a final spreadsheet.

You can see the heading row is coming from the headings spreadsheet and not the query icons.

In the end there are 340 rows in the final spreadsheet.

If we provided all the data for all the regions and included a slicer for region we would have many more rows in this workbook.

We would send out the workbook and each person would have to click on the slicer for their region.

Instead of that we create 3 excel workbooks and send each workbook just to the people for that region.

The data is going to go out of the capsule through the out icon sales facts 01.

When we option the arrow you can see it is reading data from region name sales facts 01.

Now you are seeing that the top set of capsules are providing all the data we need for our slicers.

For this report we need just one sales fact table.

Now obviously what happens is that after you have built the dashboard for the user he will come back and ask for more data to be included in the dashboard.

We all know that.

So you might come back into this capsule and build another sales fact capsule to get more data to put on the dashboard.

All these spreadsheets are sending data to the collect data spreadsheet.

So what happens in collect data?

Meta5 spreadsheets have regions.

We will go down and select the years region.

You will see the years are selected.

Then we select months dim.

Then we select countries dim.

Then we select product categories dim.

Then we select currencies dim.

Then we scroll right and select sales facts 01.

So this spreadsheet is collecting the data from all the other spreadsheets and placing them in to regions named for the data.

The regions will expand and contract depending on how much data is sent to the region.

When we option the arrow for Years we see that it is copying data from the years spreadsheet and sending it to the years dim region in the collect data spreadsheet.

We can see the same for the months arrow.

We can see the same for the product categories arrow.

We can see the same for the sales facts 01 arrow.

So now all our data we need for our dashboard, all with the appropriate constraints set for each iteration of the capsule, is in the collect data spreadsheet.

You can do this for any data from anywhere using meta5.

So your users tell you what data they want on their dashboards.

Getting that data from the data warehouse, or other sources, and updated and in to the spreadsheet every morning before 9am when the users are coming in to work to see their dashboards.

That is the hard part, right?

That is your problem and it is quite a problem to solve.

This problem of repeatedly running spreadsheets so that they are up to date at 9 am with the data from close of business yesterday is quite a problem.

That is what we have just seen.

This portion of the capsule does the work of collect the data for this spreadsheet.

It solves that problem.

And it uses the parameter of territory to collect just the data needed for this version of the spreadsheet.

Now the magic happens in getting this data in to excel.

When we option the arrow you are going to see something very cool.

Notice that we are copying data from the collect data spreadsheet and that all the region names are named.

In the copy data to area you see the excel spreadsheet name.

You see region names for the excel spreadsheet match the region names in the collect data spreadsheet.

So when this arrow runs it copies all the data from the collect data spreadsheet to the excel workbook.

So let us look in the excel workbook.

Here is our years dim.

Here is our months dim.

Here is our currencies dim.

Our countries dim.

Our product categories dim.

Our sales facts.

As an excel user you would be familiar with how we set up regions inside excel.

To send data collected by meta5 in to excel all you have to do is transfer the data via the arrow region name to region name.

It is that simple.

Then what does it do?

The excel spreadsheet has a name.

We option the arrow and we put the name of the excel worksheet in the out data region name for the PC Directory.

It will write the excel spreadsheet to the PC directory with the name specified here.

The PC Directory is set to a directory on the C Drive as named in the directory name.

And the directory name can be any drive including a mapped drive.

We are sending it to C drive A BIDA HOSTING.

Notice that the spreadsheet name has no at variable.

This spreadsheet is going to be over-written with each execution of the capsule.

It is a temporary data workbook.

So now you think.

Ok, that is the data prepared in a temporary data workbook.

But how does the data get in to the power pivot model in the dashboard?

You do that exactly like this.

This spreadsheet is called Example Report 01 Template.

So it is a template. It is not a finished report.

Let us open it up.

Ok, it looks like the finished dashboard.

That is interesting.

Let us go over to power pivot.

Go to manage model.

And what are we going to find in here?

We look in existing connections.

And here we are.

Power pivot data connections.

Each of those connections is linked to a region in the source data workbook.

Those regions are linked to the tables in the power pivot model.

So this dashboard only contains the data in the power pivot model.

It does not contain the data in worksheets or regions.

The power pivot model is also highly compressed to make it faster to send over networks.

Then inside the template we have pivot tables selecting data from the power pivot models.

We built a pivot table by category and a pivot table by country.

And we put some charts on them.

Simple.

Of course the worksheets for the pivot tables can be hidden so only the dashboard is visible.

The data in this template is from Europe. France, Germany, United Kingdom.

So obviously you understand that the data is being queried and collected by Meta5 in to collect data.

It is being send in to the temporary data workbook.

That temporary data workbook is linked to the template power pivot model in the dashboard.

But how does Meta5 get the data from the temporary data workbook in to the power pivot model in the template workbook and produce a final workbook?

We have this tool called iExcel, the Excel integrator tool.

I have a spreadsheet called dummy and it is going to send dummy data to the data region name.

Because I am not sending any data in to iExcel.

I am getting my data from the temporary data workbook.

But that still leaves me with the question.

How do I tell Excel how to get the data from the temporary data excel workbook?

You do that using iExcel which is a magic, magic piece of software.

This is what makes meta5 a really cool tool for excel reporting.

It have lots and lots of options.

iExcel is a huge piece of software.

All I need to do is to put – rad in the advanced commands parameter.

This will cause iExcel to read the template workbook and refresh the data, which will cause excel to re-read the data in from the temporary data workbook.

It will also refresh all the charts in the workbook ready for the user to open the workbook.

We have designed the workbooks that they do not re-load the data on open, they reload the data in the power pivot model on first slicer click.

iExcel will then save the newly created workbook to the Final workbook.

If we open this up this is another spreadsheet.

And you notice this is the one for Australia because that is the last workbook that was produced by the prior execution of the capsule.

It is not the workbook for Europe which is the template.

And then, some more meta5 magic.

When we option the arrow we see that the name of the spreadsheet is EX01 Sample Report 01 Final and it has the variable at AA at the end.

This means it will have the region name in the actual excel file name.

So now we have the final Excel file name and we need to know where to send it to.

In the PC directory icon you name the full path of the one drive on this computer in the directory name parameter.

In this example you can see that it is the one drive for BIDA and it is the public portion of the one drive. You can see the whole name on the screen.

You can see at the end of the name is at AA which is the region.

So the final dashboard will be placed in to the region name folder on the one drive.

This could also include the names of individual people if you wished to.

You could send customized reports for individual people via the one drive.

Just to prove this is what it does we will go to file manager.

You can see the name of the folder is the same as was in the PC directory icon.

You can see the region name is included in the path and included in the name of the spreadsheet itself just for demonstration purposes.

Now just to prove to you that this works I am going to delete these spreadsheets and then run the capsule to put them back.

So no spreadsheets in any of the folders any more.

Now we are going to run the capsule to re-create the spreadsheets.

I will hit pause on the video so you don’t have to watch the capsule run.

Ok, so the capsule has completed.

So let us go back to the folders.

You can see that the Europe workbook is back in the folder with the current time.

We can open the report.

You can see it has got the data for France, Germany, United Kingdom.

You can click on multiple currencies and click on Euros and it will update the dashboard.

Click on GBP and the dashboard updates.

You can see the date and time for North America.

You can see the date and time for Pacific.

To prove the dashboards have been sent to our portal I will open up our sharepoint portal.

You can see the report for europe was sent about a minute ago.

You can see the timing of the arrival of the workbooks for North America and Pacific.

So you can see the capsule ran and the reports were sent to the one drive and were then distributed to our sharepoint portal.

So let us go back to the inside of the capsule.

Right now at A A is set to Pacific.

This portion of the capsule to collect data and send it in to the collect data spreadsheet has the ability to literally get data from anywhere.

You can get data from web sites, logs, other databases, spreadsheets, any data from anywhere.

You do not have to have your data in a data warehouse.

You can get data from virtually any data source at all.

Meta5 can read just about everything and anything.

And if you ever come up against a data source that is not supported?

Meta5 can add support for a modest fee.

You can clean the data up.

There are many tools to perform many functions on the data including statistics if you wish.

And anything that can run on the host computer can also be called to process data inside Meta5.

Most importantly you can get data from anywhere and integrate it in to these applications and send it forward in to a spreadsheet in a parameterized repeatable batch processing mode.

So you don’t have to go back to your IT people and beg them to put the data you need in to an SSAS cube to get it into your report. Ok?

The big beauty of meta5 is that I can go and collect data from anywhere and send it into a spreadsheet.

For people who want reports and dashboards in spreadsheets this is a BIG feature.

This makes populating your power pivot models much easier than any other way you have of doing this today.

The way that these capsules are run is via the BIDA scheduler.

Today we have one customer who uses the BIDA ETL software and models to populate data from their ERP in to their data warehouse.

They do this via the scheduler that runs each night.

And at the end of the batch the scheduler runs a set of capsules to generate Excel reports and it puts those reports on to a shared drive mapped as a drive letter.

The BIDA software is doing end to end BI support producing Excel reports and dashboards with Meta5 as the software that takes data from the data warehouse and populates the Excel workbooks.

There is no need for SSAS in that environment.

This makes report development and support much faster, cheaper and easier.

Now what I am going to do is to run this capsule in front of you so you can see it run.

I will also open up the task manager so you can see Excel running.

Please remember this is a small development machine running Excel 32 bit so it runs a little slowly.

So here you can see Excel is running and Meta5 is sending data in to Excel.

Now it has finished putting data in to the temporary Excel data workbook and it is now putting the data in to the dashboard.

Obviously excel single threads so you have to be a little careful about how you set up job processing to produce the reports.

You can have capsules run on their own dedicated capsule servers if you want to parallelise processing.

You saw that it did not take Meta5 very long to go and collect the data.

And then it takes a little while to push the data in to the excel spreadsheets.

Ok, just to summarize.

What I wanted to show you today was a very detailed, drill down look in to how do you actually build excel dashboards which will collect data from many different places using the meta5 software.

I also wanted to show you how those dashboards can be parameterized for different regions so that only the data needed is in the dashboard for the user who will use it.

We wanted to show you how those dashboards could be delivered to different people in different places via the one drive feature.

That is what we have demonstrated to you today.

By using Meta5 what you will be able to do is build excel dashboards better, cheaper, faster than any other way.

Given that you are going to be building excel dashboards for a very long time out in to the future?

Building them better, cheaper, faster and easier to maintain to save time and money is a good investment.

It will reduce the cost of maintenance for all those excel spreadsheets you have out there for years and years to come.

Now as I said at the beginning this is a very detailed demonstration.

This demonstration is for those of you who have the job of building excel reports and dashboards.

This if for those of you where your business users come to you and say “Mihai, I have this new dashboard I would like to build, would you build this dashboard for me please?

And would you put it into the daily schedule to make sure it is delivered to all the people who need it by 9am please?”

That is who this video is for.

If that is your job, building excel reports and dashboards?

What we showed you today is a better, faster, cheaper way of building those excel reports and dashboards using the power of power query and meta5.

You can build your excel reports and dashboards regardless of where your data is.

You don’t need one of those big and expensive data warehouse projects to get started.

Though, of course, having a data warehouse helps.

If you do have a data warehouse that is a bonus.

But if you don’t have a data warehouse you can get started today with Meta5 and Excel producing reports and dashboards faster, cheaper, better than any other way with data from anywhere you need to get it from.

If you feel you are spending too much time building excel dashboards and reports?

This is a better, faster, cheaper way of building excel dashboards and reports.

Ok?

Now…if you would like to contact me please use our contact page.

If you are still listening?

Thank you very much for listening to my video all the way through!

I really appreciate that!

So with that?

Thank you very much for listening and bye for now.

Thank you!

Mihai Neacsu

BIDA0016 – First AdventureWorks Dashboard – Overview

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.

My name is Mihai Neacsu and I am the business development manager here at BIDA.

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

This video is a very short video on how to build Excel Dashboards using Meta5.

We are just going to show you the end result because this video is intended for business users who are wondering how do I get my Excel reports better, cheaper, faster on time, at 9am in the morning, with all the information I need in them?

Without out-dated information, without macro-errors, and all the other things that go wrong with Excel reports.

That is who this video demonstration is intended for.

We are going to show you a new idea, an alternative idea, on how to get your Excel spreadsheets, better, cheaper, faster.

Ok?

So with that let me go in to the Meta5 desktop.

And here we are, in my Meta5 desktop.

I have come in to Adventure Works, Example Reports, Example Report 01.

I just want to show you something very briefly.

Sales Territories.

We are using the Adventure Works database which you will most likely be familiar with.

We click show data and there are three sales territories, Europe, North America and the Pacific, in the adventure works database. That is the database we are using.

So let us say you want to run some reports for each of those territories and distribute them out to the territory managers maybe via a one drive.

We have created an example of exactly that.

We have this capsule. And I will just open it up.

At the end of the capsule is an icon called PC directory.

I am going to press F 4 and I am going to go in to other data.

And in the options window you can see a directory name.

Now this is a development machine and it only has a C drive.

As I scroll through the directory name you can see it is the BIDA One drive.

You can see that it has a long directory path on the C drive.

You can see that the last piece of the path name is Adventure Works and at A A.

Now at A A is what we call a variable and in this case it is the region name.

So you would expect that to point to some sub directories.

So that is the name of the directory that the PC Directory icon is pointing at.

Just to prove it, we will go across to the file manager.

Here is that directory on this PC.

You can see it is being operated on by one drive.

So what we are going to do is to go in to each sub directory and we are going to delete the excel dashboards that are currently in the sub directories.

I want you to see they are being deleted.

So you can see on the screen there is nothing in the three sub directories.

Of course you could have many reports, we are just doing one report.

We will just leave the capsule and go again to sales territory.

We will click show data.

You can see Europe, North America, Pacific.

Now of course you could use anything.

You could attach other names to the outputs to point to other sub directories.

You could have individual marketing manager names in the sub directories.

You can do all those sort of things. Ok?

The idea is that what gets put into the spreadsheet is just the data that is needed for the report for the person who is the user of the spreadsheet.

It then gets put in to the one drive and sent to wherever it is that the user of that spreadsheet wishes to receive the spreadsheet.

One drive will send the spreadsheet where ever it’s rules say to send it.

What we are going to do now is click the run button and the capsule will run and generate the dashboards.

What it will do is take those three territories and send them into the controls of the capsule. And when we look in to the capsule it is going to send the territories in to at A A. The last one that was sent in was Pacific.

So it is going to send those three sales territories in to the capsule.

It is going to run the capsule three times.

It is going to create three different excel dashboards and send them to three different directories in the one drive which will then be distributed according to the one drive rules.

So we are going to click the run button, and then we will hit pause on the video, because you do not need to wait for it to run.

Ok, so now you can see complete please continue.

And we can go back in to file manager.

And we can see Europe.

Here is a report. 1, 32 pm. 10th August.

North America.

Pacific.

They take about a minute each to produce on this PC.

Now if we open up one of the dashboards.

We can see it is a simple dashboard.

We see the reseller order amount and the internet order amount figures from the adventure works database.

We presume you have seen this database before and are familiar with what is in it.

We can do things like select multiple currencies.

We can pick individual countries.

Let us select France.

Germany.

Select the UK.

Notice that this dashboard has just the data for Europe.

Now we will close this dashboard.

Let us open the dashboard for North America.

In the North America report we can see US dollars, Canadian dollars and we can see different data. We have the same report with different data.

So we can go over here to the United States and click on that.

And it responds to show us just United States data.

We can click on just bikes.

We can click on accessories.

We can click on clothing.

You have all the features of Excel.

We are using Excel 365 because it has lots of features.

Most companies we talk to will be using Excel 365 or would be willing to move to Excel 365 to get these dashboards.

Now we can go to the Pacific folder and open the dashboard for Pacific.

We need to click on AUD as well.

We can click on bikes.

We can multi-click on accessories.

You get the idea.

So we have a capsule that ran that delivered data to a one drive that then delivered the workbooks out to different places.

Now to just prove that.

We will go over to our sharepoint site in our web browser.

We will drill down the folders to where the dashboards were delivered.

Now we come in to the Europe folder and you can see the dashboard is there.

We go into North America and you can see the dashboard is there.

We go into Pacific and you can see the dashboard is there.

So you can see that the three spreadsheets arrived in to our sharepoint portal through our one drive.

So we ran a capsule with three regions, Europe, North America, Pacific.

The capsule did something to produce an Excel dashboard for each region.

Each dashboard only contains the data for the region it references.

It was then put in to the one drive and distributed by our one drive to our sharepoint folder.

That is what I wanted to show you in this short 10 minute video.

The ability to build excel dashboards using Meta5 and distribute them through the one drive network repeatedly.

And we can customise those dashboards to contain just the data that is necessary for the people who are going to view just that dashboard.

So when someone comes in to work in the morning and go to their one drive or sharepoint portal and open their reports they only have their data for their reports in their excel dashboards.

And they don’t need to be connected to any server to get their data for their reports or to drill around in the reports. The data for the report is inside the workbook.

So that is what I wanted to show you in this demonstration.

We are going to build a more detailed demonstration for your technical people to look in to so they can understand exactly what is happening inside that strange thing called a capsule.

That will be a longer and more detailed technical demonstration.

We would like you, as a business manager, to know that it is possible to have a suite of excel reports delivered in to a one drive or a company shared drive to be distributed to all the people who need it.

And inside each report is only the data that each person who reads the report needs to have in order to use that report.

And if a number of people want a collection of data obviously they can do that too.

If you need to have reports that link back to SSAS cubes of course you can still do that.

What we are talking about is the opportunity to take all those regular reports that are run day in and day out and are sent to people.

They can receive those reports with just the data they need inside those reports disconnected from any server for more data.

I hope you liked this short demonstration of a faster, better, cheaper way to build and support your Excel reports and dashboards.

If you would like to contact me? Please use our contact page.

So with that?

Thank you very much for listening and bye for now.

I really appreciate you!

Thank you!

Mihai Neacsu