PowerPivot Part 4: Sharing PowerPivot Workbooks

So now you have a PowerPivot workbook that’s far too awesome to keep to yourself. How do you go about sharing PowerPivot workbooks?

You could just distribute the workbook wholesale, but that’s not optimal because any user who wants to take advantage of the PowerPivot features needs to have PowerPivot for Excel 2010 installed on their machine to fully run the report.

Where else can you turn?

Luckily, SharePoint 2010 introduced PowerPivot for SharePoint that is comprised of two main pieces:

  • Server software that can retrieve the data for the report
  • The PowerPivot Gallery

The SharePoint PowerPivot Gallery is a special document library that has document management and preview for PowerPivot workbooks (along with a few other document types). With the PowerPivot Gallery’s live preview, you can interact with a PowerPivot workbook, just as you would in Excel.  You can also create workbooks from published PowerPivot workbooks and schedule data refreshes for added versatility. The gallery also has several customization options for how the reports are listed.

What’s the catch?

Continue reading PowerPivot Part 4: Sharing PowerPivot Workbooks

The Intern Diaries: Ingrid

This is the second installment of our Intern Diaries series, wherein each week our lovely interns try to give you the inside scoop on what being a programming intern at a high-tech startup is really like. Click here to read Part 1. 

Hello everyone! I’ve been interning at SoftArtisans for seven weeks now both in technical services and now in development. Here is what I have to say (in brief) thus far:

If you’ve read anything in this blog, you’ll correctly ascertain that SoftArtisans is a tight-knit community of very smart and friendly people. They have many interests and are all really good at what they do. The company still retains a startup atmosphere with weekly company lunches, soccer games (which I haven’t really participated in… I’m pretty terrible at soccer), and an overall casual atmosphere.

But I think it would be more interesting to talk about the things you wouldn’t know unless you worked here. Firstly, there is a very strong emphasis on learning especially as an intern. You are encouraged to ask questions and to truly understand the product and technology that you are working with, which is absolutely fantastic. Secondly, interning at SoftArtisans means that you are a contributing member of a team. Your practical knowledge is developed and valued in the group. Thirdly, working is very self-directed. This means that if there is a point where you don’t have something to do, you are encouraged to choose a task and tackle it! Finally, you get to listen to music as you work and can have lunch on the Charles River. Yay!

This whole internship has been a learning experience so it is very hard to think of the single coolest thing I have learned in the last seven weeks. So I guess I will tell you the top three coolest things:

Continue reading The Intern Diaries: Ingrid

What is ASP.NET Web API?

What is it?

ASP.NET Web API is functionality that was released as a part of ASP.NET MVC 4 that lets developers easily build HTTP-based web APIs on top of the .NET framework. It is available for Visual Studio 2010 SP1 or Visual Studio 2012.

Why should I be interested?

Web APIs are gaining more traction because of their ability to reach a wide variety of platforms. Unlike SOAP or WSDL-based services that use HTTP has a transfer protocol, web APIs fully embrace HTTP to convey information. It’s ridiculously easy to generate HTTP requests, which makes it simple to develop across different types of applications, operating systems, and platforms.  The success of using an HTTP-based web API is clear when you look at the companies that are already operating under this model, such as:  Facebook, Twitter, LinkedIn, Flickr, and Netflix. These organizations have hundreds of developers creating applications, particularly for mobile devices.

It’s not hard to see why ASP.NET would want to jump on this bandwagon.

I’m intrigued… What else do you have?

I watched Scott Guthrie‘s talk about ASP.NET MVC 4. Scott Guthrie is the Corporate VP in Microsoft’s Server and Tools Business division, which manages tools such as Azure, IIS, and ASP.NET.

Continue reading What is ASP.NET Web API?

5 Things to Do in Boston Other Than SharePoint

SP Tech Con is fast approaching. If you’re new to Boston here are a few things you don’t want to miss – some touristy, some local.

  1. Duck Tour – Definitely touristy, but you should go until you get every driver. They are unbelievably fun and you get a nice overview of the history of the city – Or y’know you could do those segway tours but you better have confidence of steel because between you and me, people judge.
  2. Brewery Tours – Take your pick. Tickets tend to sell out fast so I recommend getting there early.
  1. Harpoon – Tour ($5) or a tasting (free). Tours are on the weekends and tastings are weekdays at 2pm and 4pm. Either way learn about the brewing process while drinking. Leave with a souvenir glass.
  2. Sam Adams – Free. Take the Orange line and follow the signs to the brewery. Learn about the brewing process while enjoying free tastings. Afterward, hop aboard the complimentary party trolley, which will take you to Doyle’s, one of my favorite bars. Continue reading 5 Things to Do in Boston Other Than SharePoint

The Intern Diaries: Shane

This is the second installment of our Intern Diaries series, wherein each week our lovely interns try to give you the inside scoop on what being a programming intern at a high-tech startup is really like. Click here to read Part 1. 

Here I am, a few weeks into the coolest summer of my life. Usually I take classes, “work” by the pool, and travel. At SoftArtisans, I’ve been a bit more productive.  I’ve seen the usefulness of git and scrum, spent hours figuring out the few characters that determine a spreadsheet’s fate on an ipad, learned more than I’d ever thought I’d know about Excel spreadsheets, and even had a bit of fun. Without a doubt, the best part here has been seeing my work go straight into OfficeWriter. At Olin, nine out of ten times, my finished projects end up on a shelf or in some folder as a keepsake. Maybe I’ll break it out to show someone, but I rarely use them after they’re done. Here, I did work that was released a few weeks later. What I did as an intern could be used by people right now. It is quite the feeling.

So far, the most interesting thing I have learned has not been in the software, or even on the computer. I had never heard of scrum outside of the rugby field. Once I did hear about it, it still didn’t make sense to me. Why would you plan everything only two weeks in advance? How could a team function without a project manager? Why would you spend precious time every day telling people what you had done the day before?

So before I continue, the quick scrum explanation: work is divided into segments called sprints, which last a few weeks. Before each sprint, all the work that needs to be done over the next few sprints is broken up into smaller tasks and assigned a point value based on how long it will probably take and prioritized based on how important it is to the product. On the first day of the sprint, the team chooses what tasks they could definitely get done that sprint. Each day, there is a quick meeting where everyone simply and quickly explains what they worked on the day before and the challenges they faced. Finally, at the end of the sprint you have a meeting where you look back over the sprint and discuss what worked well, what didn’t, and what needs to change. Continue reading The Intern Diaries: Shane

SP Tech Con Prize Giveaway: Call Me Maybe?

Coming to SP Tech Con in Boston this July? Visit us at booth #505 and enter to win a POP Phone. We will be raffling off 5 POP phones throughout the conference. A throwback to the 50’s style Bakelight design phone, these plug into all mobile phones, tablets, and computers. Plus they add an additional cool factor when you’re Skyping or video chatting with friends. See below for prize giveaway details.

Prize details:

Where:

Booth #505

When:

July 24th – 25th

Tuesday, 11am – 7pm

Wednesday, 11am – 4pm

How to Enter:

Continue reading SP Tech Con Prize Giveaway: Call Me Maybe?

Staff Picks: Gadgets

Once a week I snoop around the office, bothering my coworkers with questions on what they’re reading, listening to, consuming, or any other random inquiries I’d like to subject them to. Sometimes they even respond.

The question:
 1. What is the coolest gadget you’ve bought recently?
 
The answers:

David, CEO

Night light for the office kayaks

Kristen, Sales Rep

iPad

Continue reading Staff Picks: Gadgets

Scrumming in Trello as a Product Owner

This morning I signed into my Trello account and I was greeted by Taco, the mysterious Husky mascot:

He told me to go to my profile for a special prize. Now I am the proud owner of a…that’s right, you guessed it: Blue Starfish Trophy.

Husky and Blue Starfish aside, it’s hard to imagine my life without Trello to keep track of practically everything that I do at work.

When I first saw the online tool, I saw the potential for personal use with my costuming hobby, as a way to keep track of elements that needed to be completed and as a way to share my progress with other members of my costuming circle.

Continue reading Scrumming in Trello as a Product Owner

The Intern Diaries

Our favorite time of year is upon us. It’s summertime, and that means kayaking down the Charles, BBQ’s in the parking lot, and best of all summer interns. We’re handing over the blogging reins to this talented crew. Each week follow along as they give you an inside look at SoftArtisans and Riparian Data, life as an intern at a start up, and any other random musings that pop into their heads.

(from left to right: Josh, Grace, Ingrid, Julian, Shane)

The questions:
1. Where do you go to school?
2. What do you study?
3. Give us a unique/random fact of your choosing.

The answers:
Josh
  1. Stanford University
  2. I’m still deciding on a major, but I know for sure I’m really excited about Mechanical Engineering and Computer Science, and also possibly Bioengineering.
  3. I like performing in circus shows. My favorite trick is juggling torches, while balancing on a rolling globe and reciting 100 digits of pi.
Continue reading The Intern Diaries

Meet the Team: Dan

Hello and welcome to our Meet the Team series, in which we aim to give you deeper insight into the minds and personalities of those who make up this eclectic, close-knit group. We are developers, marketers, and technical support engineers, and at work we craft everything from Microsoft reporting APIs to mobile email applications. And outside of work? Let’s just say racing against the machine during hackathons, building architecturally sound beer towers during retros, and paddling down the Charles during the warmer months are simply the beginning.

Say hello to Dan – grill master of SoftArtisans’ summertime BBQs, poker player extraordinaire (true story – Google it), soccer all star, not Sheldon Cooper.

1. What do you do?
As VP of Operations, I am in charge of all the financial, operational, legal and HR aspects of every business located at 3 Brook Street, Watertown, MA. I’m also the BBQ cook.

2. What are you listening to right now?
The voice in my head.


3. When you were 5 what did you want to be and why?
A lawyer because I liked Perry Mason.


4. Fill in the blank. Contrary to popular belief _____.
I am not Sheldon Cooper and I do understand context.

Continue reading Meet the Team: Dan

Blogged