In a series of multiple blog posts within the last few weeks, a lot of blog authors (Ken Puls, Chris Webb, Mike and many others) who I follow have raised the enthusiasm for combining multiple Excel Workbooks or even worksheets into a single table.
All of our approaches have two things in common:
- Calling a Function
- Refer to a single type of object (most of the time it’s just a Worksheet)
wich may not the best or most complete way to work with Power BI (on the cloud) since queries that refer to a function can not be refreshed on the cloud and also because you might want to combine sheets, tables and named ranges at the same time .
Note that If you try refreshing a workbook that contains a Query with a function on Power BI, you’ll get an error similar to this:
So, what if you could create a query that can combine anything and everything from multiple workbooks? READ THIS POST and you’ll see how
If you are into cool new technologies then this blog post is for you.
A few weeks ago, Microsoft released a new service called Azure Machine Learning or simply #AML. It’s a cloud service that let’s you create experiments for data prediction and machine learning in general. (What Data Scientists do)
You can read more about this service here (you can try it for FREE!!). What really has me hooked to this is the fact that it you can integrate r, so you can create your R code and even packages and use them on the cloud without doing anything special – an enfortless system bound to make things happen (or predict what would happen).
This type of service is the one that saves hundreds of hours of development or tedious coding so I recommend you give it a try
This blog post is based on this sample experiment
We have the experiment ready – let’s use the API and grab some results with Power Query!
I recently received an invitation to join the Power BI preview and of course that I had to share something with everyone
So…here you’ll find 2 videos about Power BI. Don’t worry, there are more to come so stay tuned for more information about the BI solution that will truly change the life of all the excel super heroes.
(Multiple Updates so hang on tight!)
I’m going to keep this one short as I’m actually working on another post more focused on Powerpivot
First Update: New and more Clean Website Design
Check it out for yourself! Click here to visit the site. It took me about a whole week designing this with Wix but it came out great. I’m planning on adding more widgets down the line but you’ll hear about it pretty soon.
Let me know in the comments sections below your thoughts on this new design.
Figure shows the scalability of the Powerpivot Solution from Personal, Local Network, Team and finally to the Corporate level
Since I’m suppose to throw a webinar on Monday but it will only be in Spanish I thought about throwing a personal version of my webinar on Youtube divided by parts so it won’t be too hard to digest.
Here’s part 1 (about 16 minutes) of the webinar that should be 1 hour long total. Where I’ll cover the following topics:
- User Driven BI and self-service BI
- Excel 2010 and Excel 2013 with Powerpivot
- Pivot Tables with Powerpivot
- Power View
- Microsoft Data Explorer (Preview)
- GeoFlow (Preview)
- Sharepoint Integration
- What is DAX?
- Scalability of the BI solution
Figure shows the population distribution for Panama in 2010
Made Entirely in Excel!
You can check the full post here:
and if you happen to want to download or check out the file you can go here:
Recently, Portalfront hosting has released a new test site using cutting edge technology such as Powerpivot, Power View and Sharepoint 2013.
Ever wanted to see how Powerpivot or Excel works on the Web?
Take a look at the reports that are available on the site and if you are interested in a free test site, click the link below!
Every once in a while… Microsoft releases extremely cool tools to the Excel audience that leaves us with a face similar to this one –> and they just recently introduced the latest version of Data Explorer
(which caused this to many people –> ) .
Within the past 3 years, Microsoft has released
- Power View
- Data Explorer
- Excel 2013 (all the new functions and features apart from the ones above)
All of them that answer to the needs of business users to get their hands on the Dataa and be able to explore it and reach extremely useful insights…all of this thanks to the Self-service BI concept.
Data Explorer answers the need of the user that needs to transform his data in an easy and automated way, translating this into excel-geeky language, it means:
- No more macro recordings
- No more helper columns
- No more complicated formulas and arrays that made Excel Crash
Data Explorer it’s a tool that enables you to:
- Transform and
your data. However you want. Check out this post from The Data Specialist:
to know more about what’s Data Explorer