• About This Blog
  • Sitemap
  • Contact
  • concentra.co.uk
linkedin
rss
twitter
youtube
google_plus
email
Tableau European Customer Conference comes to London
Cost benefit analysis in healthcare – Lifetime costs and benefits
Excel data sources: no longer the scourge of SSIS Developers
Excel add-in using VSTO and VBA
Why SSIS always gets Excel data types wrong, and how to fix it!
  • Home
  • Operations Consulting
  • Analytics & Data Management
    • Data Visualisation
  • Technology
    • SharePoint
      • Visual Studio
    • Office 365
  • Concentra

Business Intelligence

Concentra - Tableau Customer Conference

Tableau European Customer Conference comes to London

06 Jun 2013
Tim Archer
0
Business Intelligence, Tableau
Off the back of an interesting few weeks for Tableau Software, we are looking forward to when they roll into town to host their annual customer conference next week. Coupling the recent floatation success of the company on the NYSE with a sold out venue, we are expecting an
Read More
Concentra - Excel and SSIS

Excel data sources: no longer the scourge of SSIS Developers

29 May 2013
Daniel Perianez
0
Business Intelligence, COZYROC, SSIS
The Scenario Anyone who has worked with Excel as a data source or destination in SSIS (SQL Server Integration Services) has probably found him/herself frustrated and fuming at how difficult it can be. Microsoft provided SSIS with a simple way to deal with the task of reading data
Read More

Excel add-in using VSTO and VBA

20 May 2013
Abhay Bagai
0
Add-in, Business Intelligence, Excel, Microsoft Office, VBA, VSTO
What is it? VSTO (Visual Studio Tools for Office) is a great means of customising Office applications, especially the UI. VSTO allows us to customise task panes which is impossible with VBA (Visual Basic for Applications). It is much easier to customize ribbons in VSTO using
Read More
Excel

Why SSIS always gets Excel data types wrong, and how to fix it!

15 May 2013
Sandeep Chayanam
1
Business Intelligence, Excel, SQL Server, SQL Server Integration Services, SSIS
Working as a BI Developer with the Microsoft stack of tools, I often deal with multiple sources of data, one of which being Excel, a very common data source in Data Warehousing projects. As some of you may be aware, working with Excel in SSIS (SQL Server Integration Services) can
Read More

Self-Service Business Intelligence with Excel, PowerPivot & SharePoint 2013

28 Mar 2013
Ezugo Chukweze
0
Business Intelligence, Excel, PowerPivot
A quick walk-through Self-Service Business Intelligence with PowerPivot and SharePoint 2013 Business Intelligence (BI) is a big thing these days, research suggests that it is one of the key challenges businesses face today. When you think of BI most might think big data, SQL
Read More
Tableau 8 Tour

Notes on the Tableau 8 Tour event

20 Mar 2013
Tim Archer
0
Business Intelligence, Tableau 8
Having arrived early, we were greeted by a busy room and managed to avoid the large queue that grew in the run up to the `Data gets its day` presentation. Lynn Smith opens with some interesting Statistics – Tableau business has more than tripled in the UK over the past year
Read More

Factors Affecting Educational Attainment – Deprivation & Ethnicity

25 Feb 2013
Weelin Lim
1
Business Intelligence, Education, Education Attainment, KS4, School League, UCAS
Following on from my recent posts on the latest Key Stage 4 school results, this blog post looks at factors affecting educational achievement for KS4 and also UCAS university application success. The educational attainment I have chosen is the achievement of 5+ A*-C GCSEs
Read More
Meat

The Horsemeat Scandal: where did it come from and where does it usually go?

15 Feb 2013
William Taylor
0
Business Intelligence
Since traces of horse DNA were found in Tesco Value beef burgers the flood gates seem to have opened with the FSA surfacing many other products as contaminated. This has not been constrained to supermarket own brands but fast food chains and well known ready meal producers have
Read More

Key Stage 5 English School Results 2012

11 Feb 2013
Weelin Lim
3
Business Intelligence, Compare Data, Compare Schools, Education, School League, School League Tables
Following on from last week’s blog post on the Key Stage 4 results for all schools in England, this one covers all the Key Stage 5 results for all schools, down to Subject level. The key stage 5 raw data can be found here. The most surprising aspect to this data, for me, was the
Read More

Key Stage 4 English School Results 2012

07 Feb 2013
Weelin Lim
3
Business Intelligence, Compare Schools, Education, School League, School League Tables
The government has just released the latest Education data-sets containing the Key Stage 4 English School Results (KS4 Data) and Key Stage 5 (KS5 Data) exam results for 2012. Most education sites use this data to compile their version of School League tables, based on varying
Read More
123

Our Favourites

Concentra - Analytical tools to support procurement

Procurement Analytics – Building the foundations

Self-Service Business Intelligence with Excel, PowerPivot & SharePoint 2013

Understanding Delivery - The LEGO City

Capabilities Marquee

Microsoft BI Reporting Tools – Which should you use?

Winning moment

Making Improvement Real – how we work with clients to deliver real value

See all favourites

Popular posts

How to add Google Analytics to SharePoint Online

16 Comments

Charity pricing for Microsoft Office 365

10 Comments

OData in SharePoint 2013 with jQuery

6 Comments

How to fix a SharePoint page that a web part is causing to crash

5 Comments
table of filter options

Understanding OData

4 Comments

Tags

Advanced Analytics Agile Analytics Awards Big Data Business Business Intelligence Case Study Cloud Compare Schools CRM Dashboard Data Education Excel Exchange Healthcare IIS 7.5 IIS 8.0 Intranet jQuery Lync Making Improvement Real Microsoft OData Office 365 Office 2010 Office 2013 Open Data PowerPivot PowerShell ProAgile Reporting RESTFul School League School League Tables SharePoint 2013 SharePoint Online SQL Server SSIS Tableau Tableau 8 UCAS Web part Windows

Categories

  • Home
  • Operations Consulting
  • Analytics & Data Management
    • Data Visualisation
  • Technology
    • SharePoint
      • Visual Studio
    • Office 365
  • Concentra

Recent Posts

Concentra - Age distribution for a UK region

Cost benefit analysis in healthcare – Lifetime costs and benefits

05 Jun 2013
No Responses.
Concentra - Excel and SSIS

Excel data sources: no longer the scourge of SSIS Developers

29 May 2013
No Responses.

Excel add-in using VSTO and VBA

20 May 2013
No Responses.

Twitter feed

  • Twitter feed loading

Contact

  1. Name *
    * Please enter your name
  2. Email *
    * Please enter a valid email address
  3. Message *
    * Please enter message
© 2013 Concentra
www.concentra.co.uk