WES29PAL: Should you go Vertical?

Industry analysts and many Microsoft partners have demonstrated that focusing your solutions to address the specific needs of vertical markets can help your company improve the success of its sales and marketing efforts, improve your competitive positioning, and build sustainable customer loyalty even in a weak economy.

In this session, a panel of HTG members Garrett Brucker (HTG15), Nick Bock (HTG5), Dave Sobel (HTG5, HTG11), and Robert Lindley (HTG5) will discuss how they focus on specific vertical market solutions at their company and what this approach has meant to their success.  The panel plans to discuss the following topics:

•Why is it important to focus on vertical markets?

•Which tools can help you create a vertical strategy?

•What is the potential return on investment?

•How can you get started?

– My Time Today
SELECT ISNULL(SUM(Hours_Actual),0)
FROM v_TimeRecords
WHERE Member_ID = SUBSTRING(SYSTEM_USER,CHARINDEX(”,SYSTEM_USER)+1,LEN(SYSTEM_USER)-CHARINDEX(”,SYSTEM_USER))
AND Date_Start = DATEADD(Day, 0, DATEDIFF(Day, 0, GETDATE()))

– My Time This Week
SELECT ISNULL(SUM(Hours_Actual),0)
FROM v_TimeRecords
WHERE Member_ID = SUBSTRING(SYSTEM_USER,CHARINDEX(”,SYSTEM_USER)+1,LEN(SYSTEM_USER)-CHARINDEX(”,SYSTEM_USER))
AND Date_Start BETWEEN DATEADD(week, DATEDIFF(week, 0, GETDATE()), 0)
AND DATEADD(week, DATEDIFF(week, 0, GETDATE()) +1, 0) -1

– My Utilization This Week
SELECT ROUND(ISNULL(SUM(ISNULL(Hours_Actual,0) * ISNULL(Billable_Flag,0)) / SUM(Hours_Actual),0) * 100,0)
FROM v_TimeRecords
WHERE Member_ID = SUBSTRING(SYSTEM_USER,CHARINDEX(”,SYSTEM_USER)+1,LEN(SYSTEM_USER)-CHARINDEX(”,SYSTEM_USER))
AND Date_Start BETWEEN DATEADD(week, DATEDIFF(week, 0, GETDATE()), 0)
AND DATEADD(week, DATEDIFF(week, 0, GETDATE()) +1, 0) –1

– My Utilization Last 12 Weeks
SELECT DATEPART(ww, Date_Start), ROUND(ISNULL(SUM(ISNULL(Hours_Actual,0) * ISNULL(Billable_Flag,0)) / SUM(Hours_Actual),0) * 100,0)
FROM v_TimeRecords
WHERE Member_ID = SUBSTRING(SYSTEM_USER,CHARINDEX(”,SYSTEM_USER)+1,LEN(SYSTEM_USER)-CHARINDEX(”,SYSTEM_USER))
AND Date_Start BETWEEN DATEADD(week, DATEDIFF(week, 0, GETDATE()) -12, 0)
AND DATEADD(week, DATEDIFF(week, 0, GETDATE()), 0) –1
GROUP BY DATEPART(ww, Date_Start)

Sorry for the delay in getting THE STUFF to you guys.  Please drop any comments or suggestions on my blog at www.isi.cc/rlindley.

Screen Casts: (Click to view Screen cast or right click to “Save Target As”)

1. Get read access to the data
2. Verify access to the data
3. ConnectWise Data Dictionary and v_rpt views
4. Access data using custom SQL statements
5. Connect custom Time Analysis pivot table to your data
6. Introduction to Power Gadgets
7. Connect Power Gadgets to your data

THE STUFF (Right Click to “Save Target As”) Zip file contains:

1. Time Analysis Excel Pivot Table
2. 7 Power Gadgets

Step one: Get read access to the data.  Click here to watch the screen cast.
Step two: Verify access to the data.  Click here to watch the screen cast.
Step three: ConnectWise Data Dictionary and v_rpt Views.  Click here to watch the screen cast.

I have totally dropped the ball here since ConnectWise Partner Summit.  Deborah and I had no sooner landed in Little Rock from Orlando when we got a phone call from our 26 year old son’s girlfriend.  He had an accident early Sunday morning 11/8 and was taken a local emergency room.  He had multiple broken bones in face below is right eye, missing 2 teeth, stitches in upper lip, and both eyes are heavily brushed.  He had facial reconstruction surgery last week and now has plates in his face to connect the upper jaw and cheek bones together.  His jaw has been wired shut to support the right side for the next several weeks.  He is doing great and should make a full recovery.  Thank you Lord!

Needless to say, I have fallen behind at ISI and with promises made regarding “THE STUFF”.  I hope to work on my materials over Thanksgiving holiday.  Please setup an RSS feed on this blog or check back often.  In the mean time here are the PDFs that I posted back in May.

ConnectWise Data Analysis Part 1
ConnectWise Data Analysis Part 2
ConnectWise Data Analysis Part 3
ConnectWise Data Analysis Part 4

Here is the PowerPoint from the session:
http://www.isi.cc/WebElements/ConnectWise%20Partner%20Summit%202009%20PowerPoint.pdf

HTG5 Peer Group members are bringing it with 2 Great Webinars Today!

Register NOW!!!

Microsoft

Virtualization: Defined. Building your Virtualization Practice and Solution Offerings

Dave Sobel, Evolve Technologies

11/18 at 12:00 PM EST

https://training.partner.microsoft.com/learning/app/management/LMS_ActDetails.aspx?ActivityId=510773&UserMode=0

Virtualization is becoming mainstream, and are you ready with your practice? Learn from Dave Sobel, author of “Virtualization: Defined. A Primer for the SMB Consultant”, how to build your consulting practice, get trained and offering solutions, and solutions you can start delivering right away. Learn about server consolidation assessments, Virtual Desktop Infrastructures, and how to deliver high value solutions to your customers.

ConnectWise

Top Ten Tricks in Managing a Profitable Service Team

Cohen Barnes, TBC Net, Inc.

Nick Bock, Five Nines Tech Group

11/18 at 1:00 PM EST

https://admin.na6.acrobat.com/_a874126979/serviceteambreakout/event/registration.html

Join us Wednesday November 18th at 1pm Eastern for an insightful webinar with Cohen Barnes and Nick Bock, break out session presenters from Partner Summit. Among the highest rated sessions at Partner Summit, we invited Cohen and Nick to fly down to beautiful Tampa to do a live show and record this popular session.

Cohen and Nick will speak in depth about how to manage a profitable service team. No matter how great your service offering is, if your business isn’t operated effectively and profitability, you may not survive. Get the 10 tricks that will positively affect the fluidity of your business operations and bottom line.

These 10 concepts are simple, easy to incorporate into your business structure, and will make a huge difference in your operational costs. If you have an effective plan that utilizes these ten tips, your service team will realize increased profits and provide better service to your clients.

Robert Lindley

HTG5 Facilitator

rlindley@isi.cc

501-217-8484 x101

HTG Peer Groups

Business and Personal Growth Driven by Execution

http://www.htgpeergroups.com/

Here is the session PowerPoint deck. 
http://www.isi.cc/WebElements/ConnectWise20Summit20PowerPoint.pdf