Search results matching tags 'Analysis Services' and 'Conference Communities'http://sqlblog.com/search/SearchResults.aspx?o=DateDescending&tag=Analysis+Services,Conference+Communities&orTags=0Search results matching tags 'Analysis Services' and 'Conference Communities'en-USCommunityServer 2.1 SP2 (Build: 61129.1)Discount for PASS Business Analytics Conference 2013 #passbac #ssas #sqlpasshttp://sqlblog.com/blogs/marco_russo/archive/2013/03/12/discount-for-pass-business-analytics-conference-2013-passbac-ssas-sqlpass.aspxTue, 12 Mar 2013 12:02:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:48201sqlbi<p>One month ago <a href="http://sqlblog.com/blogs/marco_russo/archive/2013/02/08/first-spring-conference-pass-business-analytics-conference-and-sql-bits-passbac-sqlbits-sqlpass.aspx">I wrote about my sessions</a> 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 <strong>BAC228BL</strong> and you should hurry up, because there is another discount if you <a href="http://passbaconference.com/Register.aspx">register</a> within March 15, 2013.</p> <p>If you are too lazy to click on the previous post, I will speech in two sessions:</p> <ul> <li><strong>Modern Data Warehousing Strategy</strong></li> <li><strong>Self-Service Data Modeling</strong></li> </ul> <p>And now that Data Explorer Preview has been made public I can disclose that Data Explorer will be covered in my Self-Service Data Modeling session! I thought about writing an article about Data Explorer, but there is already a good coverage and I suggest you to read these blogs:</p> <ul> <li><a href="http://www.sqljason.com/2013/03/introduction-to-data-explorer-preview.html">Introduction to Data Explorer Preview for Excel</a> by Jason Thomas</li> <li><a href="http://cwebbbi.wordpress.com/category/data-explorer/">Several posts</a> by Chris Webb</li> <li><a href="http://blogs.msdn.com/b/dataexplorer/archive/2013/02/27/announcing-microsoft-data-explorer-preview-for-excel.aspx">Announcement</a> on Data Explorer Team blog</li> </ul>SQLBits XI in May 2013 – many reasons to attend! #sqlbits #dax #tabularhttp://sqlblog.com/blogs/marco_russo/archive/2013/02/20/sqlbits-xi-in-may-2013-many-reasons-to-attend-sqlbits-dax-tabular.aspxWed, 20 Feb 2013 09:33:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:47803sqlbi<p>I and <a href="http://sqlblog.com/blogs/alberto_ferrari">Alberto Ferrari</a> will speak at <a href="http://www.sqlbits.com">SQLBits XI</a> (Nottingham, UK – May 2-4, 2013) and there are many good reasons to join us there, especially if you are interested to DAX!</p> <p>Here are our sessions:</p> <ul> <li><strong>Thursday, 02 May 2013 </strong>– Training Day - <strong><a href="http://www.sqlbits.com/Sessions/Event11/From_0_to_DAX2">From 0 to DAX</a></strong></li> <ul> <li>The entire day is dedicated to learning DAX, starting from the syntax and going forward with more complex syntaxes for both expressions and queries in DAX.</li> <li>Technical level: the goal is to be introductive, explaining the important concepts in DAX (such as filter context, row context, context transitions) and covering the usage of the most common DAX functions.</li> <li>Target audience: Information Workers interested in exploiting the many interesting features of PowerPivot for Excel 2013 and BI developers who want to learn the DAX language.</li> <li>In practice: if you started using DAX two years ago and created several projects in Tabular and/or PowerPivot with complex calculations, this is not the workshop for you (read about an <a href="http://www.sqlbi.com/courses/dax-advanced-workshop-london-may2012/">Advanced DAX Workshop</a> later in this post). But if you just started your first Tabular or PowerPivot projects and you are still wondering what CALCULATE is all about, then this is definitely the right training for you!</li> </ul> <li><strong>Friday, 03 May 2013</strong> – 10:50am – <strong><a href="http://www.sqlbits.com/Sessions/Event11/Modern_Data_Warehousing_Strategy">Modern Data Warehousing Strategy</a></strong></li> <ul> <li>How to design a Data Warehouse in 2013? Should we change something considering the introduction of in-memory technologies such as xVelocity? Is Self-Service BI affecting the way we design and implement a Corporate Data Warehouse?</li> <li>This is not a session about a specific feature of a product, but features and products have their effects on the data warehouse design. We’ll stop one hour trying to understand what changes in the big picture, affecting also our day-by-day job.</li> </ul> <li><strong>Friday, 03 May 2013</strong> – 2:40pm – <strong><a href="http://www.sqlbits.com/Sessions/Event11/Inside_xVelocity_InMemory_Engine_VertiPaq_">Inside xVelocity InMemory Engine (VertiPaq)</a></strong></li> <ul> <li>Do you use PowerPivot and/or Analysis Services Tabular? They use the same engine (xVelocity/VertiPaq) and you should know how it works.</li> <li>This session will show how xVelocity/VertiPaq works, how it compresses and stores data and why it is so fast answering to your queries.</li> <li>Why this is important? Because it is geeky! And because this knowledge will help you optimizing storage and DAX queries.</li> </ul> <li><strong>Saturday, 04 May 2013 </strong>– 10:50am – <strong><a href="http://www.sqlbits.com/Sessions/Event11/DAX_Query_Engine_Internals">DAX Query Engine Internals</a></strong></li> <ul> <li>DAX is amazingly fast. But some query might be not fast enough.</li> <li>Do you want to know how to optimize your DAX query? This session is for you.</li> <li>Knowing the internals of xVelocity InMemory engine is just the first step (see Friday’s session). Then you need to apply this knowledge to DAX and understand why different DAX syntaxes for the same result might have different performance.</li> <li>Understanding cross-filtering is a key to master DAX optimization. The more you know DAX, the more you will appreciate this session!</li> </ul> </ul> <p>As I said before, the training day is an introductive course. If you already know DAX and want to improve your skills, there is a <a href="http://sqlblog.com/blogs/marco_russo/archive/2013/02/07/first-dax-advanced-workshop-in-london-may-2013-dax-tabular-ssas.aspx"><strong>3-day Advanced DAX Workshop</strong></a> I will teach in London on May 13-15, 2013. It could be also a good reason to visit London if you come from other countries!</p> <p>Now that we are almost done with the <a href="http://www.sqlbi.com/books/excel-2013-building-data-models-with-powerpivot/">PowerPivot for Excel 2013</a> book, we will write <a href="http://www.sqlbi.com/articles/">more articles</a> – stay tuned!</p>First spring conference: PASS Business Analytics Conference and SQL Bits #passbac #sqlbits #sqlpasshttp://sqlblog.com/blogs/marco_russo/archive/2013/02/08/first-spring-conference-pass-business-analytics-conference-and-sql-bits-passbac-sqlbits-sqlpass.aspxFri, 08 Feb 2013 15:50:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:47527sqlbi<p>Spring is a conferences’ season and the upcoming one is no exception. I will be speaking at PASS Business Analytics Conference 2013, which will be the first event this year, so I’d like to spend a few words about my sessions.</p> <p><a href="http://www.passbaconference.com/"><strong><font size="3">PASS Business Analytics Conference 2013</font></strong></a> <br>April 10-12, 2013 | Chicago, IL – United States</p> <p>This conference is targeted to Business Analytics professionals. Thus, I expect to meet both BI Developers, Excel Advanced Users, Data Analyst and, of course, the new Data Scientist role (if you have a business card with such a definition, please drop me one, so I can demonstrate to skeptic people that this figure actually exists!). I have two sessions:</p> <ul> <li><strong>Modern Data Warehousing Strategy</strong></li> <ul> <li><em>April 11th, 2013 – 1:30 pm – Chicago Ballroom VIII <br>Track: Strategy and Architecture</em></li> <li>The recent introduction of new technologies such as PowerPivot, the BI Semantic Model, and columnstore indexes in SQL Server and advances in self-service business intelligence and big data might be considered threats to the classic data warehouse ecosystem. In reality, a good data warehouse is still the best starting point for any kind of analysis, but we do need to update our strategy for data warehouse implementation to fit the requirements of this new era. This session will start the conversation about what a modern strategy for data warehousing can and should be. What type of data modeling should we use for the data warehouse? What is the role of data marts? Does the use of technologies such as PowerPivot or Analysis Services Tabular affect the way we should model our data? Do columnstore indexes remove the need for an analytical server like Analysis Services? We will discuss these and other questions, offering an updated approach to the data warehouse modeling methodology. <strong> <br></strong></li> </ul> <li><strong>Self-Service Data Modeling</strong></li> <ul> <li><em>April 12th, 2013 – 1:30 pm – Sheraton Ballroom I &amp; II <br>Track: Data Analytics and Visualization</em></li> <li> <p>Self-service business intelligence looks promising, empowering information workers to grab amazing insights from data. But are Excel 2013 and DAX language knowledge enough to analyze data? The answer in most cases is no – information workers will also need an ability to properly model their data and the skill to use some new tools to reshape data in the correct way. In this session, we will analyze some common problem scenarios where data analysis is difficult due to the shape of the model and see how to solve them.</p> </li> </ul> </ul> <p>In theory, I expect two different audiences at the two sessions, but I know that there will be people attending both, especially who provides tools to end users. I’d like to receive feedback about what you would expect to see in such sessions (regardless you will attend or not!), so that I check if I defined the correct expectations for the audience.</p> <p>If you want to attend, <a href="http://www.passbaconference.com/Register.aspx">register</a> before March 15 in order to get a discounted price. You can also <strong>save $200</strong> by using the code <strong>BAC228BL</strong>. See you in Chicago!</p>