• About This Blog
  • Sitemap
  • Contact
  • concentra.co.uk
linkedin
rss
twitter
youtube
google_plus
email

Excel add-in using VSTO and VBA
Why SSIS always gets Excel data types wrong, and how to fix it!
Secondary School Applications – Which schools are most over or under-subscribed?
SQL Bits XI – The Best Bits!
Data and Advanced Analytics – Insurance Industry steps forward
  • Home
  • Operations Consulting
  • Analytics & Data Management
    • Data Visualisation
  • Technology
    • SharePoint
      • Visual Studio
    • Office 365
  • Concentra

Welcome to our blog

We have lots to share as we have an exciting breadth of skills across operations management, data analytics and software development. It’s with this blend of skills, we solve operational challenges and create lasting value for our clients.

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...
Read More
Excel

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

15 May 2013
Sandeep Chayanam
0
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...
Read More
Concentra - Secondary School Allocation

Secondary School Applications – Which schools are most over or under-subscribed?

13 May 2013
Weelin Lim
1
Education, Open Data, School Applications, Secondary Schools, Tableau
Which areas in England are school children most likely to get their first choice of secondary school? Which schools in your area suffer from the most over-subscription or under-subscription?...
Read More
Concentra - BI Consultants - SQL Bits

SQL Bits XI – The Best Bits!

10 May 2013
Weelin Lim
0
Excel, OData, PDW, SQL Server
Last weekend, a group of Concentra BI Consultants attended SQL Bits Community Saturday, the annual conference for all things SQL Server. Here is a quick summary of the best bits, stuff we found...
Read More

Data and Advanced Analytics – Insurance Industry steps forward

02 May 2013
Weelin Lim
1
Advanced Analytics, Big Data, Data
This week, I attended The Insurance Network’s Data and Advanced Analytics Conference as a guest panellist to discuss the strategic impact of data and advanced analytics. The day itself was split...
Read More
1234Next ›Last »

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

8 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

OData in SharePoint 2013 with jQuery

4 Comments

Tags

Advanced Analytics Agile Analytics Awards Big Data Business Business Intelligence Case Study Cloud Compare Schools CRM Dashboard Data Education Excel Exchange 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 SharePlus SharePoint 2013 SharePoint Online SQL Server Statistics Tableau 8 UCAS Usage reporting Web part Windows

Categories

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

Recent Posts

Excel add-in using VSTO and VBA

20 May 2013
No Responses.
Excel

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

15 May 2013
No Responses.
Concentra - Secondary School Allocation

Secondary School Applications - Which schools are most over or under-subscribed?

13 May 2013
1 Comment

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