Recently we have announced a new public update to Excel 2013 that includes major stability and usability improvements in Self Service BI scenarios, especially when Power Query, Power Pivot & Power View are involved. For this release we eliminated…
» Lue lisää With Excel 2013 you have a powerful new way to build interactive reports and analyze your data using the tool you already know and love. Now Excel provides rich data connections, transformation and visual analytics in an unified, seamless experience….
» Lue lisää Excel is part of our everyday lives. It doesn’t matter if you’re a finance, marketing or operations professional. But Excel is not what it used to be 10, 5 or even 3 years ago. Our engineering team has been very busy bringing amazing updates to Excel…
» Lue lisää Welcome back to our Getting Started with Excel and Power BI Series . In Part I of Getting Started with Power Pivot we created our first Excel Data Model. Today we will create additional relationships and start using DAX to add business logic to our…
» Lue lisää Welcome back to our Getting Started with Excel and Power BI Series . In our previous blog posts we explored how to bring data into Excel through Power Query ( Part I and Part II ). In this blog post we will take that data and prepare it for analyzing…
» Lue lisää In this post Importing the Data with Power Query Getting the right format with Power Query Power Pivot Power Q&A Crawl, then walk This year’s world cup was filled with unbelievable surprises; Miroslav Klose’s record breaking…
» Lue lisää Over the next couple of weeks, we’ll introduce you to the basic usage of all the latest and greatest features in Excel and Power BI. How do you know if this is the right series for you? Here are a few questions to help you decide: Are you new to…
» Lue lisää Power BI supports Power Pivot data models of any version. Users can choose between SQL Server 2008 R2 and SQL Server 2012 Power Pivot for Excel 2010 or simply use the latest Power Pivot version directly integrated with Excel 2013. It goes without saying…
» Lue lisää As we get closer and closer to the holidays, the Power BI team wanted to answer one of the most popular questions of all time: Where’s Santa now? Social media was the perfect source for answering question. We ran a search of the following terms…
» Lue lisää