Do you want to detect outliers in your data? Want a predictive way to complete missing values in your data, or do you want to perform other advanced analytics scenarios as part of data cleansing? Implementing advanced analytics data cleansing scenarios in Power BI is now easier than ever! Learn more about adding R steps in Power Query as part of the Power BI Desktop July Update.
» Read moreTry what’s coming next for Power BI! We hope all of you are enjoying 2015 so far! The Power Query team has been busy working on the latest Power Query update, which includes a new connector (or many new connectors, in this case!) and a bunch of other…
» Read moreRecently 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…
» Read moreWith 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….
» Read moreThanksgiving is just around the corner and before we all leave to enjoy some delicious turkey dinners, we wanted to share some visualizations we created in the past to celebrate this holiday. Last year around this time we tried to answer two questions…
» Read moreTake Power Query to the next level: Try Power BI for Free today! We are happy to announce the availability of the November 2014 Update for Power Query. This update is packed with lots of new features that we hope you will enjoy and thank us for…
» Read moreExcel 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…
» Read moreWelcome 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…
» Read moreWelcome back to our Getting Started with Excel and Power BI series . Today we will continue with our first Excel feature, Power Query, which allows you to discover, shape and transform your data before importing it into Excel or your Power Pivot data…
» Read moreTake Power Query to the next level: share your queries and create a corporate data catalog. Try Power BI for Free today! In this Post October is getting close to an end, but before we all put on our costumes and eat lots of candy for Halloween,…
» Read more