insightiswonderful.blogspot.com
Insight Is Wonderful: March 2015
http://insightiswonderful.blogspot.com/2015_03_01_archive.html
Wednesday, March 4, 2015. Some tips for making the most of Power Query, based on recent experiences. Natural order for processing data:. Calculate/map/merge everything in PowerQuery (it's easier than PowerPivot). Use copy and replace (with 0 1) and multiply, in place of boolean logic. Use multi-column joins when merging. Use code for loading folder of excel files - but be careful since some approaches are much more efficient than others. Subscribe to: Posts (Atom). Simple theme. Powered by Blogger.
insightiswonderful.blogspot.com
Insight Is Wonderful: DataScienceCentral
http://insightiswonderful.blogspot.com/2015/12/datasciencecentral.html
Monday, December 28, 2015. Subscribe to: Post Comments (Atom). Oh look at that! Simple theme. Powered by Blogger.
insightiswonderful.blogspot.com
Insight Is Wonderful: October 2014
http://insightiswonderful.blogspot.com/2014_10_01_archive.html
Tuesday, October 28, 2014. Data Governance, Compliance and Security. In Hadoop with Cloudera. A nice overview of how to provide an enterprise-class Hadoop solution. Http:/ www.slideshare.net/CasertaConcepts/bdw-meetup-feb-10-2014. Wednesday, October 22, 2014. Why, as told by an actor to football players. Why bust your ass for a "W"? Monday, October 20, 2014. Why, not What or How. Sales people of the world, unite! Last week, Microsoft quietly (again! Announced support for a new Power Query connector.
insightiswonderful.blogspot.com
Insight Is Wonderful: Power Query Tips
http://insightiswonderful.blogspot.com/2015/03/power-query-tips.html
Wednesday, March 4, 2015. Some tips for making the most of Power Query, based on recent experiences. Natural order for processing data:. Calculate/map/merge everything in PowerQuery (it's easier than PowerPivot). Use copy and replace (with 0 1) and multiply, in place of boolean logic. Use multi-column joins when merging. Use code for loading folder of excel files - but be careful since some approaches are much more efficient than others. Subscribe to: Post Comments (Atom).
insightiswonderful.blogspot.com
Insight Is Wonderful: June 2014
http://insightiswonderful.blogspot.com/2014_06_01_archive.html
Monday, June 9, 2014. A brief detour through art. Embed]http:/ bigbangdata.cccb.org/en/[/embed]. A NEW ERA OF KNOWLEDGE. The revolution of disciplines after Big Data. From professional football and literary studies to crime prevention, today the fields of knowledge that have been profoundly changed by access to big data sets are countless. Data science methodologies are opening up new paths in numerous disciplines creating specialised fields that are associated with new professional profiles.
insightiswonderful.blogspot.com
Insight Is Wonderful: September 2014
http://insightiswonderful.blogspot.com/2014_09_01_archive.html
Wednesday, September 3, 2014. Solving the Mystery of Hadoop Reliability. Subscribe to: Posts (Atom). Simple theme. Powered by Blogger.
insightiswonderful.blogspot.com
Insight Is Wonderful: Power Query - loading multiple files
http://insightiswonderful.blogspot.com/2015/01/power-query-loading-multiple-files.html
Tuesday, January 27, 2015. Power Query - loading multiple files. Issues with loading a directory of Excel files? Try this (after you start the wizard). Source = Folder.Files("C: Files"),. Removed Other Columns" = Table.SelectColumns(Source,{"Content"}),. Added Custom" = Table.AddColumn(#"Removed Other Columns", "GetExcelData", each Excel.Workbook([Content]) ,. Removed Columns" = Table.RemoveColumns(#"Added Custom",{"Content"}),. And then keep going as normal! Some more explanation here:.
insightiswonderful.blogspot.com
Insight Is Wonderful: January 2015
http://insightiswonderful.blogspot.com/2015_01_01_archive.html
Tuesday, January 27, 2015. Power Query - loading multiple files. Issues with loading a directory of Excel files? Try this (after you start the wizard). Source = Folder.Files("C: Files"),. Removed Other Columns" = Table.SelectColumns(Source,{"Content"}),. Added Custom" = Table.AddColumn(#"Removed Other Columns", "GetExcelData", each Excel.Workbook([Content]) ,. Removed Columns" = Table.RemoveColumns(#"Added Custom",{"Content"}),. And then keep going as normal! Some more explanation here:.
SOCIAL ENGAGEMENT