THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

SQLBI - Marco Russo

Please visit the same blog at - comments are now disabled here but you can comment on the new blog (all blog posts available here are available there, too).
You can follow me on Twitter: @marcorus

New training on Power Pivot with recorded video courses

I and Alberto Ferrari started delivering training on Power Pivot in 2010, initially in classrooms and then also online. We also recorded videos for Project Botticelli, where you can find content about Microsoft tools and services for Business Intelligence. In the last months, we produced a recorded video course for people that want to learn Power Pivot without attending a scheduled course.

We split the entire Power Pivot course training in three editions, offering at a lower price the more introductive modules:

  • Beginner: introduces Power Pivot to any user who knows Excel and want to create reports with more complex and large data structures than a single table.
  • Intermediate: improves skills on Power Pivot for Excel, introducing the DAX language and important features such as CALCULATE and Time Intelligence functions.
  • Advanced: includes a depth coverage of the DAX language, which is required for writing complex calculations, and other advanced features of both Excel and Power Pivot.

There are also two bundles, that includes two or three editions at a lower price.

Most important, we have a special 40% launch discount on all published video courses using the coupon SQLBI-FRNDS-14 valid until August 31, 2014. Just follow the link to see a more complete description of the editions available and their discounted prices. Regular prices start at $29, which means that you can start a training with less than $18 using the special promotion.

P.S.: we recently launched a new responsive version of the SQLBI web site, and now we also have a page dedicated to all videos available about our sessions in conferences around the world. You can find more than 30 hours of free videos here:

Published Wednesday, July 30, 2014 9:10 AM by Marco Russo (SQLBI)
Filed under:



Avichal Singh said:

This is really neat stuff. There is no shortage of Excel users out there, but few are converting over to Excel+PowerPivot. Anything that helps users get over that hump is great news. The course offering by module would help that. And is really cool stuff.

July 30, 2014 8:28 AM

Marco Russo (SQLBI) said:

Thanks for the nice words!

July 30, 2014 8:55 AM

John said:

Nice idea to bring business intelligence to the masses, but it has been poorly executed. Has anyone at Microsoft ever used Tableau?

August 4, 2014 11:23 AM

Marco Russo (SQLBI) said:

John, I think that every vendor know each other, even if I've seen that developers tend to not go too in detail examining competitors in order to avoid any patent issue. That said, we're talking about two different products with very different prices. Complex data visualizations you can do in Tableau are probbaly the state of the art in this area, but it could be not the right tool for any user (even only for the cost).

August 4, 2014 11:38 AM

DEV said:

is it possible to load 2million records into excel power pivot 32bit or 64bit?

August 7, 2014 3:54 AM

Marco Russo (SQLBI) said:

Yes, the limit of Power Pivot is 2 billion records.

Excel 32 bit has a limit of memory of around 1 Gb (usually less than that), so the number of rows depends on the amount of columns and the granularity (number of unique values) of each column. Excel 64 bit is limited only by memory available on the PC.

August 7, 2014 4:20 AM
New Comments to this post are disabled

About Marco Russo (SQLBI)

Marco Russo is a consultant, writer and trainer specialized in Business Intelligence with Microsoft technologies. He runs the SQLBI.COM website, which is dedicated to distribute resources useful for BI developers, like Integration Services components, Analysis Services models, tools, technical information and so on. Marco is certified as MCT, MCDBA, MCSD.NET, MCSA, MCSE+I.

This Blog



Privacy Statement