Business Intelligence Senior Consultant
Areas of Expertise:
- PowerPivot
- Analysis Services
- SQL Server
- MDX
- Integration Services
- SSIS
- SSAS
- LINQ
- C#
- .NET Framework
- consulting
- speaking
- programming
- training
|
|
|
|
|
|
|
|
|
Marco blogs at:
http://sqlblog.com/blogs/marco_russo/
Not selected as a speaker at PASS Summit 2013 #sqlpass #sqlfamily
May 22 2013
I received the communication from the PASS Program Committee that none of my proposal have been accepted at PASS Summit 2013. Probably this year there was too many proposals and I made a mistake not using all the possible proposals available per speaker. In fact, I just proposed one pre-conference… read moreMay 20 2013
I and Alberto Ferrari will moderate the following Birds of a Feather session at TechEd North America 2013: CODE: BOF-ITP21 TITLE: How Far Can You Push Tabular? SPEAKER: A. Ferrari; M. Russo TIMESLOT: June 5, 2013 at 1:30 pm ROOM: 263 Abstract: Tabular is the new engine in SQL Server… read moreFrom 0 to DAX at TechEd Pre-Conference Seminar #dax #msteched #tee13
May 07 2013
In June I and Alberto will deliver a pre-conference seminar at both TechEd North America (New Orleans, LA) and TechEd Europe (Madrid, Spain).This day is a very good quickstart for those of you that still didn't complete one of our books, or those of you that missed one of our workshop about Tabular or PowerPivot.… read moreGroup Sales by Age of Customers #dax #powerpivot #tabular
May 06 2013
I published an article describing how to implement the grouping of sales transactions by age of customer at the moment of the transaction by using PowerPivot or Analysis Services. The same pattern can be used also for any kind of banding operation, this specific case is useful also to recycle… read moreDAX Studio for Excel 2013 finally available! #dax #excel #powerpivot #ssas #tabular
May 04 2013
I'm so happy that DAX Studio finally supports Excel 2013! As Darren Gosbell described in his blog, this release has a few internal changes that will better support future enhancements. I will port the code to capture the query plan for a query in this new release, but unfortunately it… read morePowerPivot Workbook Size Optimizer #powerpivot #tabular
April 30 2013
Microsoft released the Workbook Size Optimizer for Excel, the first version of an Excel add-in for Excel 2013 that inspects the data model and suggest possible optimizations. Fundamentally, it tries to apply the best practices descripted in a white paper I mentioned a few weeks ago, removing useless columns and… read moreAdvanced DAX course in May - unique date in 1H 2013 #dax #tabular #ssas #powerpivot
April 22 2013
One year after the release of SQL Server 2012 I see the growing demand for DAX. There are two reasons for that: an higher number of PowerPivot users started to build more complex data models, and SSAS Tabular is starting to be adopted by a larger number of companies, with… read moreLASTNONBLANK and FIRSTNONBLANK functions work with any column #dax #powerpivot #ssas #tabular
April 19 2013
During a PowerPivot Workshop course we received an interesting question from a student: “Can I use LASTNONBLANK (and FIRSTNONBLANK) with a column which is not a date column?” The reason is that we introduce LASTNONBLANK in the Advanced Time Intelligence module, because its typical use case is on a date… read moreSQLLunch on April 23 in London and Cardiff #sqlpass #dax #sqllunch
April 15 2013
On April 23 I will present DAX in Action in London and Cardiff at SQLLunch event.How is it possible I will be in two places at the same time?This will be a remote presentation delivered in two locations, where you can have lunch while watching the session. What is this… read morePASS BA Conference 2013 keynote coverage tomorrow #passbac #sqlpass
April 10 2013
The PASS Business Analytics Conference starts today in Chicago. In the next two days, there will be two keynotes. The most famous Steven Levitt, author of Freakonomics, will be on stage on Friday, and tomorrow (Thursday) we will see Kamal Hathi and Amir Netz. I will have two speeches at… read moreOptimize memory in #powerpivot and #ssas #tabular
April 03 2013
Microsoft published an interesting article about how to optimize memory consumption of a PowerPivot Data Model in Excel 2013. All these suggestions are also valid for SSAS Tabular. I also wrote an article Checklist for Memory Optimizations in PowerPivot and Tabular Models with a summary of the best practices. The short list… read moreNew PowerPivot 2013 book available! #excel #powerpivot
April 02 2013
Our new book about PowerPivot 2013 is finally available in printed edition, too! The title is Microsoft Excel 2013: Building Data Models with PowerPivot and it is a partial rewriting of the previous book about PowerPivot for Excel 2010. In the previous book we had a target audience that included… read moreInterviewed in SQL Down Under podcast #sqlserver #ssas #powerpivot
April 01 2013
I’ve been interviewed by Greg Low in SQL Down Under show 58, and this is *not* an April fool! We talked for one hour about Tabular, Multidimensional, Data Warehouse and just a little bit about music (you can discover which music genre I’m used to listen…). You can hear this… read morePre-Conference Seminar about DAX at TechEd 2013 #msteched #dax #ssas
March 14 2013
If you are using Microsoft BI stack and you still didn’t start learning DAX, you should not wait any longer. One of the option you have is starting with one of our books, or you can also attend one of our workshop about Tabular or PowerPivot. But if you are… read moreCost of Process Defrag in Analysis Services Tabular #ssas #tabular
March 13 2013
I recently received a question about the memory required to run a Process Defrag on a Tabular model in Analysis Services. The Process Defrag is useful when you run incremental processing of a table frequently, or when some of the values in the dictionary are no longer used in the… read moreDiscount for PASS Business Analytics Conference 2013 #passbac #ssas #sqlpass
March 12 2013
One month ago I wrote about my sessions at PASS Business Analytics Conference 2013, in Chicago, IL on April 10-12, 2013. If you still have not registered, you can save $200 by using the code BAC228BL and you should hurry up, because there is another discount if you register within… read moreUpdate to the PowerPivot for Excel 2013 licensing #powerpivot #excel
February 27 2013
Rob Collie Ken Puls (thanks Bob!) wrote a very interesting post about the PowerPivot for Excel 2013 licensing. Short recap: PowerPivot for Excel 2013 is only available in a few editions of Excel/Office (more details here) If you want to buy a perpetual license of Excel with PowerPivot, you need… read moreAlso find Marco on:
Recent Twitter posts:
Buy Now and Save
Use discount code: OPC10
All orders over $29.95 qualify for free shipping within the US. See details.
