Do we know where we have our data? From thestandpoint of servers and databases, probably yes, but do we know to whatgeographical area they belong? Where are they located --the majority oftransactions or where our users are located? During this session we willsee how to store geographic information in our data warehouse, and howimportant it is to do it correctly, so it can be easily consumed by the new mapcontrols in SSRS. At the end of the session we will be able to understandhow to store the information, what type of data need to be used and how tohandle reporting services maps to give the user a different view of theirinformation.
Javier Torrenteras is a Solid Quality Mentor focused onBusiness Intelligence. He has more than thirteen years of experience in theinformation technology area. Over the years, he has worked on a large varietyof projects: client/server and web development, management, businessintelligence, etc. During the last seven years, his main focus has been on theMicrosoft Data Platform, mainly on the BI tools. He has tremendous experiencewith Reporting and Analysis Services. Professional Experience Samples include:Solid Quality Mentors, Spain--acting as a Data Platform Architect on theBusiness Intelligence Area; Atento--designing and building a datamart (usingSSIS, SSAS and SSRS) to control the productivity of the teams managed by thisfirm. For one of the largest insurance companies in Spain he has beencollaborating on the design and development of a data mart (using AnalysisServices and SQL Server) for measuring the health insurance products. ForAccenture, Javier worked as a Senior Specialist leading one of the CIO teams incharge of managing some of their internal data marts. He used Microsoft BItools to report and analyze information such as time reports of all theemployees of the firm, measuring the use of the employee’s portal and otherinternal web sites, generating the tax audit information required by legalentities.