Web and Social Media Analysis in Practice

Handle High-Volume Downloads by Saving to a File

Categories: business intelligence, Data Mining, database, download, Facebook, Facebook Insights, Google AdWords, Google Analytics, Instagram, PIWIK, Tableau, User Comments, YouTube|Tags: , , , , |

To handle high-volume downloads, NEXT Analytics saves to a file. Having data in a file lets you easily work in other applications or import the data into a database for use in a business intelligence data warehouse. This sample video shows how to download Twitter Followers of any Twitter user, [...]

What can you do with Un-Sampled Google Analytics Data?

Categories: business intelligence, Dashboard, Data Mining, database, download, Web Analytics|Tags: |

Download un-sampled google analytics data and store it in a personal or corporate database.  This gives you a full range of options for best-in-class tools that convert raw data into business intelligence. Microsoft, Tableau, Qliktech, IBM, SAP, and many other business intelligence tools. You probably have your favourites, or tools that [...]

It takes just ten minutes to setup a personal database using free MYSQL

Categories: business intelligence, Dashboard, Data Mining, database, download|Tags: |

The install (including downloads) will probably take 10 minutes.  It pertains to software that's freely downloaded as of March 10, 2017.  Start by clicking this link and following it’s instructions. Accept all the defaults. https://www.python.org/ftp/python/3.4.0/python-3.4.0.amd64.msi Next, click this link and accept any prompts for Developer or any other default. https://cdn.mysql.com//Downloads/MySQLInstaller/mysql-installer-community- [...]

How To Avoid Google Data Sampling — For Free

Categories: database, download, Excel, Google Analytics|Tags: , |

Has your analytics run aground because you've started seeing Google Data Sampling appear? GOOGLE DATA SAMPLING - WHAT IS IT? When a web site experiences more than 500,000 sessions that covers the same time range as what you’re querying, then GA ignores some of your data. Google refers to this [...]

Dimensional Aggregation and Rollup Made Easy

Categories: Bing, business intelligence, database, download, Excel, Google Analytics, PIWIK, Scripting|Tags: , |

To get the answers we want, sometimes it's desirable to rolled up or aggregate a overly detailed dimension. This can apply to any data source including Google Analytics, PIWIK, Facebook, Instagram, Twitter, YouTube, SQL Queries and more. To demonstrate the value of rolling up detailed dimensions, a good example would [...]