Login or Sign Up to become a member!
LessThanDot Site Logo

LessThanDot

A Technical Community for IT Professionals

Less Than Dot is a community of passionate IT professionals and enthusiasts dedicated to sharing technical knowledge, experience, and assistance. Inside you will find reference materials, interesting technical discussions, and expert tips and commentary. Once you register for an account you will have immediate access to the forums and all past articles and commentaries.

Browsing "excel"

0

Demystifying Power BI – slidedeck

ITPROceed has come to an end and what a great event it was. Kudos to the organizers and all the other speakers! My session went pretty well, at least from my point of view, although I had to rush my demos a bit since there was only a 50 minute time slot. I prepared for […]

Read More...
0

ITPROceed – Slide Deck and demo materials

ITPROceed 2014 is now a thing of the past, but is has been an awesome – and free! – event. A very big thank you and “well done” to the organizers. It has been a great gathering of the #sqlfamily, with superb sessions about Azure, restoring databases with PowerShell, Hekaton (yes yes In-Memory OLTP), Administration […]

Read More...
18

Building a SharePoint 2013 BI Demo Environment Part 10 – Creating a BI site

In the final part of this series, we will create a BI subsite in our site collection. You can use this site as the starting point for your SharePoint BI demos. Browse to the PowerPivot site we created earlier in part 7 and go to Site Contents. Click on…

Read More...
2

Building a SharePoint 2013 BI Demo Environment Part 9 – Installing Reporting Services

Finally we are getting to the really sweet stuff: Power View. But first we have to install Reporting Services in SharePoint integrated mode. The steps we are going to follow are described in the following MSDN document: Install Reporting Services ShareP…

Read More...
3

Building a SharePoint 2013 BI Demo Environment Part 8 – Verifying PowerPivot Integration

After configuring SharePoint in the part 7, we will now verify if the configuration was successful and if everything works correctly. The verification process is described in the following MSDN article: Verify a PowerPivot for SharePoint Installation. F…

Read More...
0

Building a SharePoint 2013 BI Demo Environment Part 7 – Configuring SharePoint

In this blog post we go over one of the most important parts of the series: running the PowerPivot Configuration Wizard in order to configure our SharePoint installation. If you followed the previous walkthroughs, you can find the wizard in the start me…

Read More...
3

Building a SharePoint 2013 BI Demo Environment Part 6 – Installing PowerPivot for SharePoint

In this part of the series we will install the Analysis Service instance that will host the PowerPivot workbooks used in SharePoint, also known as “the PowerPivot instance”.
The first step is to create a service account for this instance. I named it SP…

Read More...
9

Force installation of 64-bit ACE OLE DB provider

This blog post describes how you can install the 64-bit ACE OLE DB provider when you have 32-bit Office components installed.

Read More...
4

How I used Data Explorer to create a demo

In this short blog post I show how you can use Data Explorer to quickly gather some datasets for a demo.

Read More...
25

What’s the deal with Excel & SSIS?

When it comes to importing data from an Excel sheet with SSIS, Excel has quite a reputation. And not a terribly good one. Well deserved, to be honest, because numerous issues can rise when dealing with this piece of software. This blog post will deal wi…

Read More...
Next Page »