I will present three sessions at upcoming TechDays conference in Hong Kong at 12-14 March 2013.
My sessions are :
- SQL Server Analysis Services Tabular Modeling
- Data Cleansing with SQL Server 2012 Data Quality Services
- Choosing the Right Visualization Tool with Microsoft Business Intelligence (MSBI)
Here are description of my sessions:
SQL Server Analysis Services Tabular Modeling
Server 2012 provided another method for modelling BI presentation named SSAS
Tabular Modelling. SSAS Tabular is an in-memory database which helps to deliver
fast reports based on xVelocity in-memory analytics engine. In this session SSAS
Tabular concepts will be discussed and an illustration of SSAS Tabular will be
explored. Data Analysis Expression (DAX) which is Tabular Model language will
be discussed in this session as well. Also some of differences between SSAS
Multidimensional and Tabular will be highlighted.
Knowledge based driven technology recently used in the new
service of Microsoft SQL Server 2012 named Data Quality Services (DQS). DQS
provides Data Quality based on knowledge base and domains created and the
matching technology. In every enterprise system Data Quality is an important
challenge and DQS comes to help beside other Data Cleansing methods (like Fuzzy
matching and Regular Expressions). In this session a brief explanation of how
to work with Data Quality Services to solve some samples of Data Quality will
be illustrated. DQS also will be more powerful when combines with SSIS and MDS.
This session will cover samples of that combination as well.
Microsoft BI stack contains different data visualization tools
like SQL Server Reporting Services, Excel PowerPivot, Power View and
PerformancePoint as part of SharePoint services. Each of these tools is good
for specific kind of dashboards and reports. In this session along with some
best practices for data visualization, difference between MSBI data
visualization tools will be discussed and we’ll see when to use which MSBI tool
for data visualization based on users, expected format and other situation.
you can read more about TechDays Hong Kong 2013 speaker list and Agenda here: