Training

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.

Webinars

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|Categories: Uncategorized|Tags: , |

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 studygroup@denversql.org 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 17 1,2 1, 2, 3, 4 1, 2, 3, 4
Oct 24 3,4 5, 6, 7, 8 5, 6, 7
Oct 31 (No meeting just self-study) 5,6 9, 10, 11, 12 8, 9
Nov 7 7 13, 14 10, 11
Nov 14 8 15, 16 12
Nov 21 9 17 13

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|Categories: Uncategorized|Tags: , |

Looking for FREE SSAS training?

SSWUG.org 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 SSWUG.org 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 Title Speaker
Intro to SSAS 2008 Marc Beacom (blog twitter)
Real-world SSAS Performance Tuning Techniques Ted Malone (blog | twitter)
Avoiding Common Analysis Services Mistakes Craig Utley (blog)
SSAS Performance Tuning and Scalability Erik 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|Categories: Uncategorized|Tags: , |

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 envir