f9653e1acf7d40b2918186518f4b416f

0

fd054e0070c7a716c07816008f649297

f9653e1acf7d40b2918186518f4b416f

0

fd054e0070c7a716c07816008f649297

f9653e1acf7d40b2918186518f4b416f

0

fd054e0070c7a716c07816008f649297

BIDA0033 – New Design Techniques For Excel Power Pivot

0

Hello and welcome to our latest blog post.

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

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

You can watch these videos on our web site.

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

We have managed to make two substantial technical upgrades.

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

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

The two upgrades are as follows.

One

We have converted the “ExcelTables” workbook to DAX.

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

So, for example.

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

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

We have now developed DAX calculations to replace this worksheet.

The DAX calculations make the worksheets easier to create.

Two

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

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

This separate data workbook was linked to the dashboard workbook.

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

This is quite a slow running process.

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

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

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

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

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

The data is then deleted from the Excel Tables.

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

However, we do not need a second “data” workbook to achieve this result any more.

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

We wanted to mention this on our web site publicly.

Just so you know.

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

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

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

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

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

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

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

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

You can even render portions of the reports as PDFs.

We love Excel.

We use it every day.

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

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

If you love Excel and want your Dashboards in Excel?

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

We can guarantee this.

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

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

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

Thank you very much for your time and attention!

We really appreciate you reading our blog post!

We wish you a great day!

Best Regards

Mihai

Contact Us

We will be emailing our subscribers useful and
valuable information regarding business intelligence.
Please subscribe here to be on our general emailing list.

BIDA0032 – Free Meta5 Evaluation Service

0

Questions?

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

Do you use Microsoft’s Navision ERP?

Do you use SQL Server for your Data Warehouse?

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

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

Or do you not even have a data warehouse for Navision?

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

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

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

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

Answers!

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

We would like to talk with you.

We are world class BI experts on SQL Server.

We represent Meta5 here in Romania.

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

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

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

You have seen the demos on our web site.

You have to use Meta5 to really “get it”

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

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

To take this one step further we have made available a Meta5 Evaluation server via Remote PC.

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

You are now able to evaluate Meta5 from the comfort of your office or home with zero software installed on your PC!

You can do it all in a web browser.

If you want to download the very thin Remote PC client you can do that too.

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

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

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

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

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

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

Contact Us

We will be emailing our subscribers useful and
valuable information regarding business intelligence.
Please subscribe here to be on our general emailing list.

BIDA0031 – Ralph Kimballs Demo Databases – Warehouse

0

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

Hello and welcome to our latest blog post.

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

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

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

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

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

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

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

Now.

Here we go!

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

We hope you like it!

Now!

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

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

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

We hope you liked this short demonstration video.

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

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

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

I really appreciate your time and attention.

I wish you a good day!

Until the next blog post.

Goodbye for now.

Contact Us

We will be emailing our subscribers useful and
valuable information regarding business intelligence.
Please subscribe here to be on our general emailing list.

BIDA0030 – Ralph Kimballs Demo Databases – Voyage

0

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

Hello and welcome to our latest blog post.

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

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

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

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

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

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

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

Now.

Here we go!

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

We hope you like it!

Now!

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

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

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

We hope you liked this short demonstration video.

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

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

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

I really appreciate your time and attention.

I wish you a good day!

Until the next blog post.

Goodbye for now.

Contact Us

We will be emailing our subscribers useful and
valuable information regarding business intelligence.
Please subscribe here to be on our general emailing list.

BIDA0029 – Ralph Kimballs Demo Databases – Value Chain

0

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

Hello and welcome to our latest blog post.

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

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

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

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

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

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

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

Now.

Here we go!

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

We hope you like it!

Now!

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

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

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

We hope you liked this short demonstration video.

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

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

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

I really appreciate your time and attention.

I wish you a good day!

Until the next blog post.

Goodbye for now.

Contact Us

We will be emailing our subscribers useful and
valuable information regarding business intelligence.
Please subscribe here to be on our general emailing list.

BIDA0028 – Ralph Kimballs Demo Databases – Telephone

0

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

Hello and welcome to our latest blog post.

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

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

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

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

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

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

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

Now.

Here we go!

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

We hope you like it!

Now!

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

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

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

We hope you liked this short demonstration video.

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

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

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

I really appreciate your time and attention.

I wish you a good day!

Until the next blog post.

Goodbye for now.

Contact Us

We will be emailing our subscribers useful and
valuable information regarding business intelligence.
Please subscribe here to be on our general emailing list.

BIDA0027 – Ralph Kimballs Demo Databases – Supply Chain

0

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

Hello and welcome to our latest blog post.

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

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

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

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

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

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

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

Now.

Here we go!

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

We hope you like it!

Now!

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

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

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

We hope you liked this short demonstration video.

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

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

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

I really appreciate your time and attention.

I wish you a good day!

Until the next blog post.

Goodbye for now.

Contact Us

We will be emailing our subscribers useful and
valuable information regarding business intelligence.
Please subscribe here to be on our general emailing list.