Search Results

Search found 422 results on 17 pages for 'marco l'.

Page 3/17 | < Previous Page | 1 2 3 4 5 6 7 8 9 10 11 12  | Next Page >

• DATE function does not support all the dates in DAX by design #powerpivot #tabular #dax

  - by Marco Russo (SQLBI)

  The DATE function in DAX has this simple syntax: DATE( <year>, <month>, <day> ) If you are like me, you never read the BOL notes that says in a clear way that it supports dates beginning with March 1, 1900. In fact, I was wrongly assuming that it would have supported any date that can be represented in a Date data type in Data…

  Read the article

• #PowerPivot Workshop Online for America’s Time Zones #ppws

  - by Marco Russo (SQLBI)

  After so many request we have finally arranged a PowerPivot Workshop online edition dedicated to America’s time zones! It is scheduled for December 19-20, 2012, with this schedule: US Eastern Time (EST): 10:00am-1:00pm / 2:00pm-5:00pm US Central Time (CST): 9:00am-12:00pm / 1:00pm-4:00pm US Pacific Time (PST): 7:00am-10:00am / 11:00am-1:00pm…

  Read the article

• Microsoft SQL Server 2012 Analysis Services – The BISM Tabular Model #ssas #tabular #bism

  - by Marco Russo (SQLBI)

  I, Alberto and Chris spent many months (many nights, holidays and also working days of the last months) writing the book we would have liked to read when we started working with Analysis Services Tabular. A book that explains how to use Tabular, how to model data with Tabular, how Tabular internally works and how to optimize a Tabular model.…

  Read the article

• xVelocity engines compared: VertiPaq vs ColumnStore #ssas #vertipaq #xvelocity #sql #tabular

  - by Marco Russo (SQLBI)

  During the last months I and Alberto worked in several projects using Analysis Services Tabular and we had to face real world issues, such as complex queries, large data volume, frequent data updates and so on. Sometime we faced the challenge of comparing Tabular performance with SQL Server. It seemed a non-sense, because even if the same…

  Read the article

• New licensing for SQL Server 2012 and #BISM #Tabular usage

  - by Marco Russo (SQLBI)

  Last week Microsoft announced a new licensing schema for SQL Server 2012. If you are interested in an extensive discussion of the new licensing scheme, Denny Cherry wrote a great blog post about that. I’d like to comment about the new BI Edition license. Teo Lachev already commented about the numbers and I agree with him. I generally like…

  Read the article

• A new SQL, a new Analysis Services, a new Workshop! #ssas #sql2012

  - by Marco Russo (SQLBI)

  One week ago Microsoft SQL Server 2012 finally debuted with a virtual launch event and you can find many intro sessions there (20 minutes each). There is a lot of new content available if you want to learn more about SQL 2012 and in this blog post I’d like to provide a few link to sessions, documents, bits and courses that are available…

  Read the article

• New training on Power Pivot with recorded video courses

  - by Marco Russo (SQLBI)

  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…

  Read the article

• ASSIMP in my program is much slower to import than ASSIMP view program

  - by Marco

  The problem is really simple: if I try to load with the function aiImportFileExWithProperties a big model in my software (around 200.000 vertices), it takes more than one minute. If I try to load the very same model with ASSIMP view, it takes 2 seconds. For this comparison, both my software and Assimp view are using the dll version…

  Read the article

• Converting #MDX to #DAX and PowerPivot Workshop online #ppws

  - by Marco Russo (SQLBI)

  I just published the article Converting MDX to DAX – First Steps on the renewed SQLBI web site about converting MDX to DAX. The reason is that with BISM Tabular in Analysis Services 2012 you will be able to write queries in both DAX and MDX. If you already know MDX, you might wonder how to “translate” your MDX knowledge in DAX. I…

  Read the article

• DIVIDE vs division operator in #dax

  - by Marco Russo (SQLBI)

  Alberto Ferrari wrote an interesting article about DIVIDE performance in DAX. This new function has been introduced in SQL Server Analysis Services 2012 SP1, so it is available also in Excel 2013 (which still doesn’t have other features/fixes introduced by following Cumulative Updates…). The idea that instead of writing: IF (…

  Read the article

• Donald Farmer left Microsoft for QlikView

  - by Marco Russo (SQLBI)

  As many of you probably already know, Donald Farmer left Microsoft to join QlikView . There are no doubts that Donald have been “the face of Microsoft BI” in the last years. This news has been initially perceived (me included, I admit) as a possible lack of confidence in Microsoft BI Vision, but after reading his blog and many…

  Read the article

• Microsoft PowerPivot for Excel 2010 – book coming in September

  - by Marco Russo (SQLBI)

  As you might already know, I and Alberto Ferrari are writing a book about PowerPivot 2010 for Excel. The official title is Microsoft PowerPivot for Excel 2010: Give Your Data Meaning and you can already order it on Amazon ! However, it will be published in September 2010, and it is reasonable considered we are still in writing…

  Read the article

• A new SQL, a new Analysis Services, a new Workshop! #ssas #sql2012

  - by Marco Russo (SQLBI)

  One week ago Microsoft SQL Server 2012 finally debuted with a virtual launch event and you can find many intro sessions there (20 minutes each). There is a lot of new content available if you want to learn more about SQL 2012 and in this blog post I’d like to provide a few link to sessions, documents, bits and courses that are…

  Read the article

• Image libraries sites to download pro images with no credits expiration policy

  - by Marco Demaio

  I found professional image libraries sites like http://www.istockphoto.com or http://www.dreamstime.com are quite useful to add some cool images to a website either when filling its contents or when designing its graphic layout. Unfortunately both of the site I listed above use credits plans that expires after 12 months: you…

  Read the article

• Watch @marcorus and @ferrarialberto sessions online #teched #msteched #tee2012

  - by Marco Russo (SQLBI)

  In June I participated to two TechEd editions (North America and Europe). I and Alberto delivered a Pre Conference and two sessions about Tabular. Both conferences provides recorded sessions freely available on Channel 9 so that you can compare which one has been delivered in the best way! If you have to choose between the…

  Read the article

• SSAS Maestro Training in July 2012 #ssasmaestro #ssas

  - by Marco Russo (SQLBI)

  A few hours ago Chris Webb blogged about SSAS Maestro and I’d like to propagate the news, adding also some background info. SSAS Maestro is the premier certification on Analysis Services that selects the best experts in Analysis Services around the world. In 2011 Microsoft organized two rounds of training/exams for SSAS…

  Read the article

• Watch @marcorus and @ferrarialberto sessions online #teched #msteched #tee2012

  - by Marco Russo (SQLBI)

  In June I participated to two TechEd editions (North America and Europe). I and Alberto delivered a Pre Conference and two sessions about Tabular. Both conferences provides recorded sessions freely available on Channel 9 so that you can compare which one has been delivered in the best way! If you have to choose between…

  Read the article

• Last day of early bird for PowerPivot Workshop in Dublin #ppws

  - by Marco Russo (SQLBI)

  The early bird discount for the PowerPivot Workshop in Dublin will expire today, Friday 11 March. There is also an upcoming workshop in Copenhagen (March 21-22, 2011) and a PowerPivot workshop in Zurich on April 4-5, 2011. I and Alberto are preparing new material in these days: something will integrate the workshop,…

  Read the article

• Attribute Overwriting in MDX

  - by Marco Russo (SQLBI)

  Jeffrey Wang wrote a great blog post about attribute overwriting in MDX that is very clear and full of helpful pictures to show what happens when you write an MDX statement that writes into your multidimensional space. This is very common in an MDX Script and if you tried to customize the DateTool solution you…

  Read the article

• Contents farms, scrapers sites, aggregators real world examples? [closed]

  - by Marco Demaio

  Contents farm, scrappers, aggregators real world examples? Could you plz clarify me: efreedom.com is a scraper site, not a content farm? Because it simply copies and pastes contents from stackoverflow. ehow.com and squidoo.com are contents farm? They don't copy and paste contents they just generate fresh…

  Read the article

• Implement Budget Allocation in DAX for Power Pivot and Tabular #powerpivot #tabular #ssas #dax

  - by Marco Russo (SQLBI)

  Comparing sales and budget, or costs and budget, is a very common operation. However, it is often the case that you have different granularities for different tables containing budget and the data to compare with. There are two ways to do that: you can limit the comparison to the granularity that is common…

  Read the article

• New PowerPivot Workshop dates: Copenhagen, Dublin and Zurich

  - by Marco Russo (SQLBI)

  The PowerPivot Workshop roadshow will continue in Europe in March and April. Registrations are now open for the following new dates in Denmark, Ireland and Switzerland: Copenhagen : 21-22, March 2011 at the Radisson Blu Royal Hotel Dublin : 28-29, March 2011 at the Microsoft Ireland Building 3 Zurich :…

  Read the article

• Learn more about MDX every day

  - by Marco Russo (SQLBI)

  I started learning MDX in 1999 and after so many years of using it and teaching it to other people, I still discover something new every day. Not only because I use it in strange ways (well, this doesn’t happen every day, at least!) but because there are other interesting information to read. Jeffrey…

  Read the article

• White Paper on Analysis Services Tabular Large-scale Solution #ssas #tabular

  - by Marco Russo (SQLBI)

  Since the first beta of Analysis Services 2012, I worked with many companies designing and implementing solutions based on Analysis Services Tabular. I am glad that Microsoft published a white paper about a case-study using one of these scenarios: An Analysis Services Case Study: Using Tabular Models…

  Read the article

• CUBEMEMBER and CUBEVALUE stop working after #PowerPivot upgrade to #Excel 2013

  - by Marco Russo (SQLBI)

  I found an issue upgrading an Excel workbook containing PowerPivot data from Excel 2010 to Excel 2013. All CUBEMEMBER and CUBEVALUE functions point to a cube name that has been changed between the two version – you have to no longer reference the PowerPivot Data name, replacing it with…

  Read the article

< Previous Page | 1 2 3 4 5 6 7 8 9 10 11 12  | Next Page >