addressalign-toparrow-leftarrow-rightbackbellblockcalendarcameraccwcheckchevron-downchevron-leftchevron-rightchevron-small-downchevron-small-leftchevron-small-rightchevron-small-upchevron-upcircle-with-checkcircle-with-crosscircle-with-pluscontroller-playcrossdots-three-verticaleditemptyheartexporteye-with-lineeyefacebookfolderfullheartglobegmailgooglegroupshelp-with-circleimageimagesinstagramFill 1light-bulblinklocation-pinm-swarmSearchmailmessagesminusmoremuplabelShape 3 + Rectangle 1ShapeoutlookpersonJoin Group on CardStartprice-ribbonprintShapeShapeShapeShapeImported LayersImported LayersImported Layersshieldstartickettrashtriangle-downtriangle-uptwitteruserwarningyahoo

Building BI Semantic Model Tabular in 60 minutes

  • Jan 7, 2014 · 6:30 PM
  • This location is shown only to members

SQL Server 2012 introduces the new Analysis Services Tabular Mode. BI Semantic Model (BISM) Tabular is in-memory database in Analysis Services using state-of-the-art compression algorithms. BI Semantic Models can be developed in either Visual Studio or in Excel using the SQL Server 2012 PowerPivot add-in. In this session, I will show you how to build a complete solution in Tabular and creating one from the ground up, deploy a rich semantic model and discover a simpler method for analyzing business data. You also learn the basics of DAX language and how to manage role based security and partitioning in a Tabular model. You will be able to create your BISM Tabular models, and gain a solid background to enable you starting your next project.


Ayad Shammout is a SQL & BI Consultant and MS MVP. He has more than 20 years deep experience in Microsoft platforms and products, specializing in SQL Server, SharePoint, and Windows OS. . He is working in OLTP design and development, Data Warehousing, Business Intelligence and Big Data, with extensive experience in data management and analysis.

Ayad has been involved in many SQL Server Enterprise implementations for High-Availability, Disaster Recovery, Infrastructure Design, Virtualization, Business Intelligence, Data Mining and Big Data.

Pizza and Soda (Free) provided by Pragmatic Works

Giveaways: Free Month of online training classes (4 cards) provided by Pluralsight.

Parking: There is free MIT parking lot on Hayward Street.  There is also a free lot across from the Alewife T stop at the Summer Shack

Note: 6:30 PM to 7:00 PM Pizza and Networking time.

Join or login to comment.

  • robin m.

    Mr. Ayad Shammout is the best

    1 · January 8, 2014

  • fred w.

    very good

    January 8, 2014

  • robin m.


    January 7, 2014

  • robin m.

    Come to 2nd floor and then check in there then u will be directed to the 4th floor

    1 · January 7, 2014

  • robin m.


    January 7, 2014

    • A former member
      A former member

      Looks like elevators dont work afterhours. I am here in lobby.

      January 7, 2014

  • A former member
    A former member

    Which floor is this?

    January 7, 2014

  • Jane

    Hi Slava,

    The BI group is excellent. Hope to attend BI soon! But every Tue. evening Data Science group is also organizing a series of seminar weekly. BI and DS are very closely related. Missing anyone is painful for me... :(


    December 19, 2013

39 went

Our Sponsors

  • Merrimack College

    MS in Data Science, MS in Business Analytics

  • Hollister Staffing

    We connect great companies to skilled talent. Our sponsors for July.

  • Pragmatic Works

    BI Training, Software and Consulting Services

  • ZoomCharts

    "Turn your data into Interactive Visualizations"

People in this
Meetup are also in:

Sign up

Meetup members, Log in

By clicking "Sign up" or "Sign up using Facebook", you confirm that you accept our Terms of Service & Privacy Policy