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…
» 阅读更多内容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….
» 阅读更多内容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…
» 阅读更多内容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…
» 阅读更多内容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…
» 阅读更多内容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…
» 阅读更多内容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…
» 阅读更多内容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…
» 阅读更多内容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…
» 阅读更多内容