myspace live counter
Browse by Tags - Geeky Girl - Site Home - TechNet Blogs

Browse by Tags

Tagged Content List
  • Blog Post: Better with Office - Data Connection Libraries

    Previously in this series, I’ve talked about general Office documents, which might be Word files, PowerPoint slide decks and so on. In this post, I’m going to go a bit more specific. I’m going to talk about data connection libraries and how they are they can accessed using Excel 2007. A data connection...
  • Blog Post: BI Bites 16: Visio Services

    This video continues my series of bite-sized BI demos. This follows on from the previous BI Bites video, where I showed how to connect a Visio 2010 diagram to data in Excel. In this video, I show how to publish a Visio diagram to SharePoint 2010 using the new Visio Services feature so display the diagram...
  • Blog Post: BI Bites 15: Visio Diagrams

    This video continues my series of demos showing Microsoft's Business Intelligence solution in bite sized chunks. This video introduces Visio, part of the Office suite, as a tool for drawing rich diagrams and tying them into live data. This video is available for download from my SkyDrive .
  • Blog Post: How to: Connect to a database

    Continuing my series of how to demos. I had a request to do a video showing how to show red, yellow, green indicators based on values from a database. Yesterday, I posted a demo showing how to set up indicators. Today, you get to see how to connect to a database. The procedure is the same to connect...
  • Blog Post: BI Bites 22: PowerPivot Charts

    This video continues my series of demos showing Microsoft's Business Intelligence offerings in bite-sized chunks. This demo shows a PowerPivot application in Excel 2010 and how to build a pivot chart based on data in a range of sources. This video is available for download from my SkyDrive .
  • Blog Post: BI Bites 23: PowerPivot Data Connections

    This video continues my series of demos showing Microsoft's Business Intelligence technologies. In this demo, I show how to create a data connection to a SQL table from a PowerPivot file and how to use that data in a pivot chart containing information from other sources. This video is available...
  • Blog Post: The phases of technology use

    I’d like to make a sweeping generalisation about how people react to technology. Disregarding for the moment the variations and exceptions, I believe that people go through four phases. Phase 1: What the heck do I do with it? Phase 2: Wow! That’s amazing! Phase 3: There’s this one little annoying...
  • Blog Post: How to: Auto Populate

    A couple of different people have asked me how to auto-populate the values in fields based on the username and values in external data sources. Those questions were the inspiration for this series of videos. I will show how to do simple but useful things in InfoPath. If there's something you'd like to...
  • Blog Post: Generating a unique form number

    I’ve had someone ask me about automatically giving InfoPath forms a unique number. The scenario in question was one where the forms were being saved to a SharePoint document library with a unique number attached. Documents in a SharePoint library do get given an ID, which is unique within document...