Training Archives - DawaBI


What’s new in Reporting Services 2012 Free Webinar


We are starting our free monthly webinars with ‘What’s new in Reporting Services 2012‘ on Wednesday August 8, 2012 at 12 noon MDT.


Description: SQL Server 2012 introduces a new reporting tool called Power View which generates interactive dashboards.  Also new is a SharePoint only feature called data alerts that helps send users messages when a data condition has been met.  In this webinar we will demonstrate how to setup and configure data alerts in SharePoint. We’ll create and deploy: a Power View report which consumes data from a BI semantic connection; a SSRS Report using report builder 3.0; and a SSRS report using the report designer using a PowerPivot workbook on a SharePoint site.

Registration for this event now open.



DawaBI offers a series of training options to help you sharpen your data management skills.  We’ll also help you improve your understanding of data warehousing, advanced reporting, choosing the right software, and custom app development.

To keep up with the latest training offerings and schedule, sign up for our distribution list so you don’t miss out.


These 1 hour online meetings will occur the second Wednesday of each month and will be offered free of charge (pre-registration required).

Jump Start Series

The Jump Start series are courses we offer that provide a mix of demos, labs and lots of lessons learned and are offered online. The intent is to get you up to speed on specific areas within a short window of time.

Custom Training Solutions

Does your team have specific needs or challenges they face?  Do you need to get your team up to speed on a technology quickly?

We offer a variety of training packages for our clients, ranging from short-term consulting on using your existing tools, to learning how to use an entirely new data system.  In any case, our primary goal is to ensure that all users feel comfortable and can use the new technology with proficiency and ease.

We’ll work with you as closely as needed to ensure that your investment in DawaBI translates to better business practices and measurable growth for your company.

Contact us with the details as we’d love to help.

By |August 5th, 2012|Uncategorized|

Announcing the fifth certification study session

The Denver SQL Server User Group is starting another round for the certification study group. Last year we ran three sessions with each focusing in on a specific subject area (DBA, Dev, BI). imageFor the next session starting next week, we thought we would try a general study session and allow for anyone wanting to study for any of the exams to participate.

Please send an email to so that we can add you to an email list. We’ll use this list to send any updates as they relate to the certification study group. Several of you have already sent us an email expressing your interest and have been added to the list so no need to send a second email. We can get your email address at Monday’s meeting if you don’t respond.

The Concept

The concept of the study sessions is to assist you in your path to passing the Microsoft SQL Server certifications. The core of this is self-study utilizing the training kits and other resources you have available. We’ll meet in person on a regular basis (once a week or so) to discuss any questions or concepts to better strengthen your understanding of the materials. The duration of the study session will last 6 weeks.

Meeting Details

We are meeting at the Department of Technology Services for Denver Public Schools located at 780 Grant Street, Denver, CO 80203.  This is a secure building and you will be allowed access via the front door located on Grant Street.

Study Outline

Date (5:30 pm to 7:30 pm)Dev (70-433)DBA (70-432)BI (70-448)
Oct 171,21, 2, 3, 41, 2, 3, 4
Oct 243,45, 6, 7, 85, 6, 7
Oct 31 (No meeting just self-study)5,69, 10, 11, 128, 9
Nov 7713, 1410, 11
Nov 14815, 1612
Nov 2191713

If anyone is studying for any of the MCITP exams, we’ll develop a schedule as there is not a specific study book for these exams.

Helpful Links

Below are links to additional information and study materials for the different tests. Here is information on special offers Microsoft has through June 30, 2011. To ask any questions to the group, the user group forms can be found at the following links: BI, Dev, and DBA.

Study Materials

Microsoft Certified Technology Specialist (MCTS)

BI 70-448 Materials TS: Microsoft SQL Server 2008, Business Intelligence Development and Maintenance

DEV 70-433 Materials TS: Microsoft SQL Server 2008, Database Development

DBA 70-432 Materials TS: Microsoft SQL Server 2008, Implementation and Maintenance

Microsoft Certified IT Professional

BI 70-452 Materials PRO: Designing a Business Intelligence Infrastructure Using Microsoft SQL Server 2008

DEV 70-451 Materials PRO: Designing Database Solutions and Data Access Using Microsoft SQL Server 2008

DBA 70-450 Materials PRO: Designing, Optimizing and Maintaining a Database Administrative Solution Using Microsoft SQL Server 2008

By |October 19th, 2011|Uncategorized|

Looking for FREE SSAS training? is hosting a free SQL Server Analysis Services expo on May 20, 2011.  Register today to reserve your spot.


If your not familiar with the events, they host several virtual conferences at great rates.  Did I mention that this event is FREE?  The sessions are pre-recorded and streamed online.  If the presenter is available, they will be available during the session time to address any questions that arise.  I am honored to be one of the speakers along with 3 other very well known SSAS experts.


Session TitleSpeaker
Intro to SSAS 2008Marc Beacom (blog twitter)
Real-world SSAS Performance Tuning TechniquesTed Malone (blog | twitter)
Avoiding Common Analysis Services MistakesCraig Utley (blog)
SSAS Performance Tuning and ScalabilityErik Veerman (blog)

Check out the full schedule for additional details and times. Don’t forget to register for this free SSAS training.


By |May 11th, 2011|Uncategorized|

Kimball University: Microsoft Data Warehouse in Depth

Several years ago, late 2006, I decided to focus my career on Data Warehousing and Business Intelligence (DW/BI). I was fortunate to have picked up a copy of a book titled The Microsoft Data Warehouse Toolkit written by members of the Kimball Group.  This is a great book and helped me immensely to get started with DW/BI using the Microsoft BI tool stack.  I would definitely recommend it to anyone thinking of getting into the DW/BI space especially those focused on the MS BI tool stack.


Since 2006, I have purchased every book that the Kimball Group has published.  The books contain great information  based off of the Kimball Group‘s methodologies and experiences in building effective DW/BI solutions.  In addition to the many books I purchase yearly, I try and attend one paid in person training event each year.


I feel that continuing ones education throughout your career is as important as when you are starting out.  Early of each year I plan and budget for an in person training event.  The last two years I’ve had the opportunity to attend the PASS Summit as a result of being President of the Denver SQL Server User Group.  This is a great event not only for the large amount of content but also for building ones professional network.


While I was doing some research on different training events I found that the Kimball Group through the Kimball University would be holding a Microsoft Data Warehouse in Depth seminar here in Denver.  Having read, or at least perused all of their books, I thought this would be a great event and decided to attend it over the PASS Summit.


The Microsoft Data Warehouse in Depth seminar was held last week.  Here is a brief outline of the seminar.

The seminar’s outline mimics that of the book starting out with the DW/BI project life cycle, project planning and requirements gathering.  They continued into dimensional modeling, system architecture and setup.  Given that this has a Microsoft BI tool specific focus, SQL Server Integration Services (SSIS) within a DW environment is discussed.  They discussed setting up auditing, utilizing configuration files for package portability, error handling as well as loading methods for dimensions and fact tables.


The next focus of the seminar was on report development with SQL Server Reporting Services (SSRS)  and Excel.  Report identification and requirements lead this section with the intent of ensuring that the reports being developed are or will be useful to the business users as well as manageable from on IT perspective.


Following the dimensional modeling and ETL was discussion on SQL Server Analysis Services (SSAS). A walk through identifying the major areas of the development of an SSAS project was provided.  Key dimension topics such as attribute relationships were covered along with a demo of how they are properly created.  Cube development in BIDS (Business Intelligence Development Studio) was covered at a high level including calculated members, partitions, KPI’s, etc.  Data mining was also covered briefly.


The last part was on the management of the DW/BI environment dealing with security, Deployment and monitoring.  Both tools and techniques to perform the needed tasks were discussed and a few demoed.


Overall, the seminar was geared towards an intro level to provide a broad scope of an entire DW/BI project using the Microsoft BI tool stack.  I would recommend this seminar to anyone entering into the DW/Bi space or up to the Junior level (1/2 to 1 year of experience) in all of the three main pillars of the Microsoft BI Tool Stack (SSIS, SSAS, SSRS).  One thing that surprised me was the distances that many attendees traveled to attend.  There were several folks from the East Coast, South and even a couple from Canada.

By |September 20th, 2010|Uncategorized|

SQLSaturday #52 – Colorado Details


What is SQL Saturday?

SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. Admittance to this event is free.  If you wish to have lunch with us there is a $10 lunch fee.  All other costs are covered by donations and sponsorships. Please register soon as seating is limited.  Please also let friends and colleagues know about the event.

When and Where?

SQL Saturday #52 Colorado is September 25, 2010 at the Cherry Creek Presbyterian Church 10150 E. Belleview Avenue Englewood, CO 80111.

Who is Presenting and what is the Schedule?

We have 36 sessions being presented by 25 local and national SQL Server Professionals.  The topics range from Business Intelligence, Database Administration, Database Development and Professional Development.  The schedule can be viewed here:


Special Presentation: We are honored to host a special lunch time presentation by Steve Jones, founder and editor, co-founder of and SQL Share, SQL Server MVP along with a host of other credits and community contributions.  Something you won’t want to miss out on.

Food Drive

SQL Saturday #52 Colorado is a community event.  All organizers and speakers are all volunteers giving their time to give back to the community.  We volunteer for any number of reasons but most important, we volunteer to help others.  At SQL Saturday #52 Colorado, you can also give back to the local community.  We will be accepting food donations that will be distributed to local food banks as well as help the victims of the Boulder fire.  Food donations will be collected in the morning during event check-in.  Those that bring a food donation to SQL Saturday #52 Colorado will be entered into a separate drawing that will be held during lunch.

Where can I register?

Event registration is now open at:

Thanks to our sponsors for making this event possible!




By |September 12th, 2010|Uncategorized|

Speaking at a SSWUG vConference

I was asked recently by Chris Shaw who is the site manager for, if I was interested in speaking at the upcoming vConference.   I was thrilled to have been asked as I’ve been wanting to do more community activities. I went out to the speakers list and my knees started to shake. There is an amazing list of speakers including Donald FarmerThomas LaRockBrent Ozar along with several local speakers such as Paul NielsenTed Malone and of course Chris Shaw. I am truly honored to be part of this event with these and all the other great speakers.

I will be giving 4 presentations, 3 on Reporting Services and 1 on Analysis Services. Here are the titles if you are interested:

  • Introduction to SQL Server Reporting Services 2008
  • Developing Reports with SQL Server Reporting Services 2008
  • Managing SQL Server Reporting Services 2008
  • Introduction to Analysis Services 2008

The SSWUG vConferences have been a huge success especially given the current financial condition we are experiencing. The vConferences bring high quality training right to you PC in your own office. No travel expenses or frustration with delayed flights. The cost investment to attend is very reasonable.

For more information on the upcoming vConference which will be held Oct 21, 22 and 23, visit the following site:

By |September 27th, 2009|Uncategorized|