Welcome to PC Teach Me...

Free Computer Training Videos.

Although you do not need to register to access this site. Registering has its benefits. Such as:

  • Access to training material associated with the video you are watching [if applicable]
  • Automatic email updates when new training videos are available.
  • Ask for a training video.
  • Exclusive access to pose questions to me [limited availability as I am doing this for free :-)].
  • Free contribution of your own training topics, this includes referencing your videos outside of PC Teach Me.
  • Its Free!

Member Login

Lost your password?

Not a member yet? Sign Up!

By registering with this blog you are also agreeing to receive email notifications for new posts but you can unsubscribe at anytime.

24778 Registered Users
71 Number Of Articles
Free Video Tutorials (Email) Free Video Tutorials (RSS) Free Video Tutorials (Twitter) Free Video Tutorials (Flickr)

Business Intelligence

foreachloop

SSIS: Foreach Loop

The foreach (file enumerator) loop looks at a specific folder and counts the amount of files which are in there and then goes through each file one at a time. This video will...

dataviewers

SSIS: Data Viewers

We are slowly getting there! Our packages are coming along quite nicely but then DISASTER! You are getting errors all of sudden. After you have ran around the office screaming for 5...

BIPerspectiveSQL2008R2

BI Perspective: SQL 2008 R2 Editions

The following post shows the differences between Standard and Enterprise Editions of SQL 2008 R2. What I thought which was important to note is what from a BI perspective are the key advantages...

fuzzylookup

SSIS: Fuzzy Lookup

With the any kind of database import there are always going to be data problems. Why? Well, it generally down to human beings. A computer is logical, a human is not. A computer does...

lookup

SSIS: Lookups

When either importing data or ETL (Extract, Transform & Load) for a data warehouse, you quite often need to assign key values to your data so you can use these values to join/link on....

sorting

SSRS: Sorting

You have a shiny new report that your users can now interrogate with parameters (shown in last video), its interactive now, but there is something missing..... The user will always wants to sort the results...

reportparameters

SSRS: Intro To Parameters

With your report well underway, the next hurdle is ensuring your report is able to change its results depending on the criteria the user wants. this is accomplished by putting report parameters onto...

reportproperties

SSRS: Formatting & Properties

The dataset,datasource and table are present on your report but something is missing.....I know formatting! You cannot have a report that does not have borders,font stylings and shading on can you? of...

reportCreation

SSRS: Report Creation

We have so far configured, designed (albiet by wizard) & deployed our first report. Are we ready to create a report from scratch? Well this video will cover the basics of creating...

ReportDeployment

SSRS: Report Deployment

As we now have a report created in "BIDS", it will probably be a good idea to get it onto the Report Server which we configured a few videos back (see "Reporting Services -...

ReportWizard

SSRS: Report Wizard

So, you have your server configured and ready for "Report Consumers" (posh way of saying users!).  Where do you start I hear you asking?  Well, if your a novice your best place to start...

ReportConfiguration

SSRS: Report Server Configuration

"Before you can run you must walk".  Never a more a true word said!  If your intention is to produce reports for small to large businesses you need to ensure you have configured the...

Page 1 of 212»

Valid XHTML 1.0 Transitional website security