1 / 18

MSBI training in hyderbad

MSBI training in Hyderabad. We are providing lab facities with complete real time training &amp; 100% job assistance will be there"/><br><link rel="canonical" href="http://kosmiktechnologies.com/msbi-training-in-hyderbad/

kalpana126
Download Presentation

MSBI training in hyderbad

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. KosmikTechnologies About​​​​Course: ​This​​impeccable​​​MSBI​​​​(SQL​​BI)​​​course​​​​is​​carefully​​designed​​for​​aspiring​​BI​​Developers, Consultants​​and​​Architects.​​Program​​includes​​basic​​to​​advanced​​Business​​Intelligence​​and Data​​Warehouse​​concepts​​on​​SQL​​Server​​Integration​​Services​​(SSIS),​​Analysis​​Services (SSAS)​​and​​Reporting​​Services​​(SSRS). MSBI​​​​Training​​​​in​​​​Hyderabad Kosmik​​Provides​​​MSBI​​training​​in​​Hyderabad​.​​We​​are​​providing​​lab​​facilities​​with complete​​real​​time​​training.​​Training​​is​​based​​on​​complete​​advanced​​concepts.​​So​​that​​you​​can get​​easily​​"hands​​on​​experience".​​We​​will​​give​​100%​​job​​assistance. Introduction​​​​to​​​​MSBI What​​​​is​​​​MSBI:​​​​​​MSBI​​stands​​for​​Microsoft​​Business​​Intelligence.MSBI​​is​​a​​powerful ● suite​​and​​is​​composed​​of​​tools​​which​​helps​​in​​providing​​best​​solutions​​for​​Business For​​more​​info:​​​​​http://kosmiktechnologies.com/msbi-training-in-hyderbad/

  2. KosmikTechnologies Intelligence​​and​​Data​​Mining​​Queries.​​MSBI​​empower​​users​​to​​gain​​access​​to accurate​​and​​up-to-date​​information​​for​​better​​decision​​making​​in​​an​​organization. ● the​​​​life​​​​cycle​​​​of​​​​BI/DWH List​​​​of​​​​ETL​​​​and​​​​OLAP​​​​Tools:​​​​​​Before​​we​​speak​​about​​OLAP​​tool​​selection​​criterion, ● we​​must​​first​​distinguish​​between​​the​​two​​types​​of​​OLAP​​tools,​​MOLAP (Multidimensional​​OLAP)​​and​​ROLAP​​(Relational​​OLAP). ● Features​​​​of​​​​MSBI Different​​​​types​​​​of​​​​MSBI SQL​​​​Server​​​​Integration​​​​Services​​​​(SSIS):​​​​​​SQL​​​​Server​​​​Integration​​​​Services​​​​(​SSIS​​)​​is ● a​​component​​of​​SQL​​Server​​which​​can​​be​​used​​to​​perform​​a​​wide​​range​​of​​Data Migration​​and​​ETL​​operations.​​​SSIS​​​​is​​a​​component​​in​​​MSBI​​​​process​​of​​SQL​​Server. This​​is​​a​​platform​​for​​Integration​​and​​Workflow​​applications. ● SQL​​​​Server​​​​Analysis​​​​Services​​​​(SSAS): SQL​​​​Server​​​​Analysis​​​​Services​​​​(​SSAS​​)​​is​​the​​technology​​from​​the​​Microsoft​​Business Intelligence​​stack,​​to​​develop​​Online​​Analytical​​Processing​​(OLAP)​​solutions.​​In​​simple​​terms, you​​can​​use​​​SSAS​​​​to​​create​​cubes​​using​​data​​from​​data​​marts​​/​​data​​warehouse​​for​​deeper​​and faster​​data​​analysis. SQL​​​​Server​​​​Reporting​​​​Services​​​​(SSRS):​​​​​​SQL​​Server​​Integration​​Services​​(SSIS)​​is​​a ● component​​of​​SQL​​Server​​which​​can​​be​​used​​to​​perform​​a​​wide​​range​​of​​Data Migration​​and​​ETL​​operations.​​SSIS​​is​​a​​component​​in​​​MSBI​​​​process​​of​​SQL​​Server. This​​is​​a​​platform​​for​​Integration​​and​​Workflow​​applications. Pre-requisites​​​​for​​​​MSBI​​​​Training​​​​in​​​​Hyderabad For​​more​​info:​​​​​http://kosmiktechnologies.com/msbi-training-in-hyderbad/

  3. KosmikTechnologies 1. To​​learn​​MSBI​​in​​any​​of​​the​​MSBI​​Training​​in​​Hyderabad.​​when​​we​​have​​sound knowledge​​in​​SQL​​Query.​​it​​must​​understand​​the​​foundations​​about​​MSBI. 2. Database​​Tables​​is​​very​​much​​important​​for​​effective​​msbi​​training​​institutes​​in Hyderabad. 3. Having​​a​​good​​idea​​about​​Database​​Tables​​will​​make​​MSBI​​performing​​Data warehousing. 4. Basic​​knowledge​​on​​Unix​​Commands​​also​​needed​​for​​day​​to​​day​​execution​​of​​the Software. 1.​​​​SQL​​​​Server​​​​Integration​​​​Service(SSIS) Introduction​​​​to​​​​SQL​​​​Server​​​​Integration​​​​Services:​​​​​​Microsoft​​SQL​​Server​​2005 ● Integration​​Services​​(​SSIS​​)​​is​​the​​toolset​​used​​to​​help​​you​​implement​​data​​integration process​​applications​​among​​your​​business​​application​​system's​​files​​and​​databases. SSIS​​​​is​​much​​more​​than​​a​​simple​​extract,​​transform,​​and​​load​​(ETL)​​process. ● SSIS​​​​Architecture​​​​Overview For​​more​​info:​​​​​http://kosmiktechnologies.com/msbi-training-in-hyderbad/

  4. KosmikTechnologies Development​​​​and​​​​Management​​​​Tools:​​Integration​​Services​​includes​​two​​studios​​for ● working​​with​​packages: SQL​​Server​​Data​​Tools​​(SSDT)​​for​​developing​​the​​Integration​​Services​​packages​​that​​a business​​solution​​requires.​​SQL​​Server​​Data​​Tools​​(SSDT)​​provides​​the​​Integration​​Services project​​in​​which​​you​​create​​packages. SQL​​Server​​Management​​Studio​​for​​managing​​packages​​in​​a​​production​​environment. SQL​​​​Server​​​​Import​​​​and​​​​Export​​​​Wizard:​​​​​​SQL​​Server​​Import​​and​​Export​​Wizard​​is​​a ● simple​​way​​to​​copy​​data​​from​​a​​source​​to​​a​​destination.​​This​​overview​​describes​​the data​​sources​​that​​the​​wizard​​can​​use​​as​​sources​​and​​destinations,​​as​​well​​as​​the permissions​​you​​need​​to​​run​​the​​wizard. Business​​​​Intelligence​​​​Development​​​​Studio:​​Business​​Intelligence​​Development ● Studio​​is​​Microsoft​​Visual​​Studio​​2008​​with​​additional​​project​​types​​that For​​more​​info:​​​​​http://kosmiktechnologies.com/msbi-training-in-hyderbad/

  5. KosmikTechnologies are​​specific​​to​​SQL​​Server​​business​​intelligence.​​Business​​Intelligence Development​​Studio​​is​​the​​primary​​environment​​that​​you​​will​​use​​to develop​​business​​solutions​​that​​include​​Analysis​​Services,​​Integration Services,​​and​​Reporting​​Services​​projects.​​Each​​project​​type​​supplies templates​​for​​creating​​the​​objects​​required​​for​​business​​intelligence solutions,​​and​​provides​​a​​variety​​of​​designers,​​tools,​​and​​wizards​​to​​work with​​the​​objects. Introduction​​​​to​​​​Data​​​​Flow Data​​​​Flow​​​​Overview:​​​​​​SQL​​Server​​Integration​​Services​​provides​​three​​different​​types ● of​​data​​flow​​components:​​sources,​​transformations,​​and​​destinations.​​Sources​​extract data​​from​​data​​stores​​such​​as​​tables​​and​​views​​in​​relational​​databases,​​files,​​and Analysis​​Services​​databases.​​Transformations​​modify,​​summarize,​​and​​clean​​data. Destinations​​load​​data​​into​​data​​stores​​or​​create​​in-memory​​datasets. Data​​​​Sources:​​​​​​A​​​data​​​​source​​​​is​​a​​connection​​reference​​that​​you​​create​​outside​​a ● package.​​A​​​data​​​​source​​​​represents​​a​​simple​​connection​​to​​a​​​data​​​​store,​​which includes​​all​​tables​​and​​views​​in​​the​​​data​​​​store. Data​​​​Destinations:​​Destinations​​are​​the​​data​​flow​​components​​that​​load​​the​​data​​in ● a​​data​​flow​​into​​different​​types​​of​​data​​sources​​or​​create​​an​​in-memory​​dataset. Destinations​​have​​one​​input​​and​​one​​error​​output. Data​​​​Flow​​​​Transformations:​​SQL​​Server​​Integration​​Services​​transformations​​are​​the ● components​​in​​the​​data​​flow​​of​​a​​package​​that​​aggregate,​​merge,​​distribute,​​and modify​​data.​​Transformations​​can​​also​​perform​​lookup​​operations​​and​​generate sample​​data​​sets.​​This​​section​​describes​​the​​transformations​​that​​Integration​​Services includes​​and​​explains​​how​​they​​work. For​​more​​info:​​​​​http://kosmiktechnologies.com/msbi-training-in-hyderbad/

  6. KosmikTechnologies Data​​​​Viewers​​:​You​​can​​do​​this​​by​​adding​​one​​or​​more​​data​​viewers​​to​​your​​data​​flow. ● SSIS​​supports​​several​​types​​of​​data​​viewers.​​The​​one​​most​​commonly​​used​​is​​the grid​​data​​viewer,​​which​​displays​​the​​data​​in​​tabular​​format.​​However,​​you​​can​​also create​​data​​viewers​​that​​display​​histograms,​​scatter​​plot​​charts,​​or​​column​​charts. Introduction​​​​to​​​​Data​​​​Sources ● Excel​​​​Source:​​​​​​The​​​Excel​​source​​​extracts​​data​​from​​worksheets​​or​​ranges​​in​​Microsoft​​.... You​​can​​set​​properties​​through​​​SSIS​​​Designer​​or​​programmatically. ● Flat​​​​File​​​​Source:​​​​​​A​​​Flat​​File​​source​​​can​​use​​one​​of​​the​​following​​types​​of​​connection managers:​​A​​​Flat​​File​​Connection​​​manager​​if​​the​​​source​​​is​​a​​single​​​flat​​file​.​​A​​Multiple​​​Flat Files​​​connection​​manager​​if​​the​source​​​is​​multiple​​​flat​​files​​​and​​the​​Data​​Flow​​task​​is​​inside​​a loop​​container,​​such​​as​​the​​For​​Loop​​container. ● OLE​​​​DB​​​​Source:​​​​​​When​​this​​kind​​of​​command​​is​​used,​​the​​OLE​​DB​​source​​cannot​​create​​the column​​metadata​​and,​​as​​a​​result,​​the​​data​​flow​​components​​that​​follow​​the​​OLE​​DB​​sourcein the​​data​​flow​​have​​no​​column​​data​​available​​and​​the​​execution​​of​​the​​data​​flow​​fails.​​The​​OLE DB​​source​​has​​one​​regular​​output​​and​​one​​error​​output. ● XML​​​​Source:​​​​​​To​​extract​​data​​using​​an​​​XML​​source​.​​In​​SQL​​Server​​Data​​Tools​​(SSDT),​​open the​​Integration​​Services​​project​​that​​contains​​the​​package​​you​​want.​​In​​Solution​​Explorer, double-click​​the​​package​​to​​open​​it.​​Click​​the​​Data​​Flow​​tab,​​and​​then,​​from​​the​​Toolbox,​​drag the​​​XML​​source​​​to​​the​​design​​surface Introduction​​​​to​​​​Data​​​​Flow​​​​Transformations ● Aggregate​​​​Transformation:​​​​​​Aggregate​​transformation​​applies​​the​​Sum​​and​​the​​Average functions,​​each​​aggregation​​can​​be​​directed​​to​​a​​different​​output.​​...​​The​​Aggregate transformation​​has​​one​​input​​and​​one​​or​​more​​outputs.​​It​​does​​not​​support​​an​​error​​output. You​​can​​set​​properties​​through​​SSIS​​Designer​​or​​programmatically. For​​more​​info:​​​​​http://kosmiktechnologies.com/msbi-training-in-hyderbad/

  7. KosmikTechnologies ● Audit​​​​Transformation:​​​​​​You​​can​​audit​​transformation​​with​​source​​columns​​to​​have​​columns data​​besides​​audit​​information​​like​​guid​​of​​package,​​name​​of​​data​​flow​​task,​​time​​of​​execution and​​few​​other​​variables.​​This​​post​​explains​​how​​to​​useAudit​​transformation​​in​​action. ● Character​​​​Map​​​​Transformation:​​​​​​Character​​Map​​Transformation​​in​​SSIS​​is​​useful​​to transform​​input​​characters.​​If​​we​​want​​to​​change​​our​​string​​columns​​to​​Upper​​Case,​​Lower case,​​Simplified​​Chinese,​​Katakana,​​Hiragana​​and​​Traditional​​Chinese​​then​​character​​map transformation​​do​​the​​trick​​for​​you.​​It​​gives​​you​​the​​options​​to​​select,​​whether​​you​​want​​to override​​the​​existing​​column​​with​​output​​result​​or​​you​​want​​to​​add​​it​​as​​a​​new​​column. ● Conditional​​​​Split​​​​Transformation:​​​​​​Conditional​​split​​is​​used​​to​​route​​data​​rows​​to​​different outputs​​based​​on​​conditions.​​This​​is​​similar​​to​​CASE​​statement​​in​​programming​​languages. ● Copy​​​​Column​​​​Transformation:​​​​​​The​​Copy​​Column​​transformation​​creates​​new​​columns​​by copying​​input​​columns​​and​​adding​​the​​new​​columns​​to​​the​​transformation​​output. ● Derived​​​​Column​​​​Transformation:​​​​​​The​​Derived​​Column​​transformation​​creates​​new​​column values​​by​​applying​​expressions​​to​​transformation​​input​​columns.​​An​​expression​​can​​contain any​​combination​​of​​variables,​​functions,​​operators,​​and​​columns​​from​​the​​transformation​​input. ...​​Concatenate​​data​​from​​different​​columns​​into​​a​​derived​​column. ● Data​​​​Conversion​​​​Transformation:​​​​The​​Data​​Conversion​​transformation​​converts​​the​​data in​​an​​input​​column​​to​​a​​different​​data​​type​​and​​then​​copies​​it​​to​​a​​new​​output​​column. ● Multicast​​​​Transformation:​​​​​​The​​Multicast​​transformation​​distributes​​its​​input​​to​​one​​or​​more outputs.​​This​​Transformation​​is​​similar​​to​​the​​Conditional​​Split​​transformation.​​Both Transformations​​direct​​an​​input​​to​​multiple​​outputs. ● OLE​​​​DB​​​​Command​​​​Transformation:​​​​​​The​​OLE​​DB​​Command​​transformation​​runs​​an​​SQL statement​​for​​each​​row​​in​​a​​data​​flow.​​For​​example,​​you​​can​​run​​an​​SQL​​statement​​that inserts,​​updates,​​or​​deletes​​rows​​in​​a​​database​​table. For​​more​​info:​​​​​http://kosmiktechnologies.com/msbi-training-in-hyderbad/

  8. KosmikTechnologies Percentage​​​​Sampling​​​​Transformation:​​​​​​Percentage  ● Sampling​ ​ Transformation​ ​ in​ ​ SSIS  ● Percentage sampling transformation: ​​In SSIS is generally used for data modeling. This transformation selects given percentage of rows from the data source and transfer it to selected output rows option and the remaining rows will be transferred to unselected output rows. ● Row​​​​Count​​​​Transformation:​​​​​​Row​​Count​​Transformation​​in​​SSIS.​​The​​Row​​Count Transformation​​in​​SSIS​​is​​used​​to​​counts​​the​​rows​​as​​they​​pass​​through​​a​​data​​flow​​and stores​​the​​final​​count​​in​​a​​variable. Sort​​​​Transformation:​​​​​​​​​​​​The​​Sort​​transformation​​sorts​​input​​data​​in​​ascending​​or​​descending ● order ● Union​​​​All​​​​Transformation:​​​​​​Union​​All​​Transformation​​in​​SSIS​​is​​used​​to​​combine​​data​​from multiple​​sources​​(excel,​​flat​​files)​​and​​produce​​one​​output​​to​​store​​in​​destination​​. Advance​​​​use​​​​of​​​​Data​​​​Flow ● Lookup​​​​Transformation:​​​​​​The​ ​Lookup​ ​transformation​ ​lets​ ​you​ ​access​ ​a​ ​referenced​ ​dataset  either​ ​through​ ​an​ ​OLE​ ​DB​ ​connection​ ​manager​ ​or​ ​through​ ​a​ ​Cache​ ​connection​ ​manager.  ● Merge​​​​Transformation:​​​​​​Merge​​Transformation​​in​​SSIS​​is​​used​​to​​merge​​two​​inputs​​(such​​as tables​​or​​files)​​and​​produce​​one​​output. ● Merge​​​​Join​​​​Transformation:​​​​​​Using​​the​​Merge​​Join​​Transformation.SSIS​​is​​able​​to​​take sorted​​data​​from​​more​​than​​one​​OLE​​DB​​data​​source​​and​​merge​​them​​into​​one​​table​​which can​​then​​be​​sent​​to​​an​​OLE​​DB​​destination.​​This​​'Merge​​Join'​​transformation​​works​​in​​a​​similar way​​to​​a​​SQL​​join​​by​​specifying​​a​​'join​​key'​​relationship. For​​more​​info:​​​​​http://kosmiktechnologies.com/msbi-training-in-hyderbad/

  9. KosmikTechnologies slow​​​​Changing​​​​Dimension​​​​Transformation:​​​​​​The​​transformation​​that​​configures​​the ● updating​​of​​a​​slowly​​changing​​dimension.​​The​​Slowly​​Changing​​Dimension transformation​​coordinates​​the​​updating​​and​​inserting​​of​​records​​in​​data warehouse​​dimension​​tables. ● Pivot​​​​Transformation:​​​​​​Pivoting​​is​​a​​mechanism​​where​​we​​interchange​​the​​rows​​into columns. ● Export​​​​Transformation:​​​​​​Export​​Column​​Transformation​​in​​SSIS​​is​​useful​​to​​export​​images, binary​​files,​​media​​or​​any​​sort​​of​​large​​documents​​from​​SQL​​Server​​to​​file​​system. ● Import​​​​Transformation:​​​​The​​Import​​Column​​transformation​​reads​​data​​from​​files​​and​​adds the​​data​​to​​columns​​in​​a​​data​​flow.​​Using​​this​​transformation,​​a​​package​​can​​add​​text​​and images​​stored​​in​​separate​​files​​to​​a​​data​​flow. ● Unpivot​​​​Transformation​​:​​​The​​Unpivot​​transformation​​makes​​an​​unnormalized​​dataset​​into a​​more​​normalized​​version​​by​​expanding​​values​​from​​multiple​​columns​​in​​a​​single​​record​​into multiple​​records​​with​​the​​same​​values​​in​​a​​single​​column. Explain​​​​Data​​​​Flow​​​​Destinations ● Datareader​​​​Destination:​​​​​​The​​DataReader​​destination​​exposes​​the​​data​​in​​a​​data​​flow​​by using​​the​​ADO.NET​​DataReader​​interface.​​The​​data​​can​​then​​be​​consumed​​by​​other applications.​​For​​example,​​you​​can​​configure​​the​​data​​source​​of​​a​​Reporting​​Services​​report​​to use​​the​​result​​of​​running​​a​​Microsoft​​SQL​​Server​​Integration​​Services​​package. ● Excel​​​​Destination​​:​The​​Excel​​destination​​loads​​data​​into​​worksheets​​or​​ranges​​in​​Microsoft Excel​​workbooks. ● Flat​​​​File​​​​Destination​​:​​​The​​Flat​​File​​destination​​writes​​data​​to​​a​​text​​file.​​The​​text​​file​​can​​be in​​delimited,​​fixed​​width,​​fixed​​width​​with​​row​​delimiter,​​or​​ragged​​right​​format. For​​more​​info:​​​​​http://kosmiktechnologies.com/msbi-training-in-hyderbad/

  10. KosmikTechnologies ● OLE​​​​DB​​​​Destination​​:​The​​OLE​​DB​​destination​​loads​​data​​into​​a​​variety​​of​​OLE​​DB-compliant databases​​using​​a​​database​​table​​or​​view​​or​​an​​SQL​​command.​​For​​example,​​the​​OLE​​DB source​​can​​load​​data​​into​​tables​​in​​Microsoft​​Office​​Access​​and​​SQL​​Server​​databases. Introduction​​​​to​​​​Control​​​​Flow ● Control​​​​Flow​​​​Overview:​​​​​​Data​​flows​​between​​your​​selected​​entities​​(sources, transformations,​​destinations).​​Moreover​​within​​a​​data​​flow​​task,​​you​​cannot​​perform​​tasks such​​as​​iteration,​​component​​execution,​​etc.​​A​​control​​flow​​defines​​a​​workflow​​of​​tasks​​to​​be executed,​​often​​a​​particular​​order​​(assuming​​your​​included​​precedence​​constraints). ● Precedence​​​​Constraints​​:​In​​SSIS,​​tasks​​are​​linked​​by​​precedence​​constraints.​​A​​task​​will only​​execute​​if​​the​​condition​​that​​is​​set​​by​​the​​precedence​​constraint​​preceding​​the​​task​​is​​met. By​​using​​these​​constraints,​​it​​is​​possible​​to​​ensure​​different​​execution​​paths​​depending​​on​​the success​​or​​failure​​of​​other​​tasks. ● The​​​​Execute​​​​SQL​​​​Task:​​​​​​The​​Execute​​SQL​​task​​is​​one​​of​​the​​handier​​components​​in​​SQL Server​​Integration​​Services​​(SSIS)​​because​​it​​lets​​you​​run​​Transact-SQL​​statements​​from within​​your​​control​​flow.​​The​​task​​is​​especially​​useful​​for​​returning​​result​​sets​​that​​can​​then​​be used​​by​​other​​components​​in​​your​​SSIS​​package. ● The​​​​Bulk​​​​Insert​​​​Task​​:​The​​Bulk​​Insert​​task​​provides​​an​​efficient​​way​​to​​copy​​large​​amounts of​​data​​into​​a​​SQL​​Server​​table​​or​​view. ● The​​​​File​​​​System​​​​Task​​:​The​​File​​System​​task​​performs​​operations​​on​​files​​and​​directories​​in the​​file​​system.​​For​​example,​​by​​using​​the​​File​​System​​task,​​a​​package​​can​​create,​​move,​​or delete​​directories​​and​​files.​​You​​can​​also​​use​​the​​File​​System​​task​​to​​set​​attributes​​on​​files​​and directories.​​For​​example,​​the​​File​​System​​task​​can​​make​​files​​hidden​​or​​read-only. ● The​​​​FTP​​​​Task​​:​An​​FTP​​(File​​Transfer​​Protocol)​​server​​is​​often​​used​​for​​data​​exchanges​​in many​​data​​integration​​scenarios. ● The​​​​Send​​​​Mail​​​​Task:​​​​T​​he​​Send​​Mail​​task​​sends​​an​​email​​message.​​By​​using​​the​​Send​​Mail task,​​a​​package​​can​​send​​messages​​if​​tasks​​in​​the​​package​​workflow​​succeed​​or​​fail,​​or​​send messages​​in​​response​​to​​an​​event​​that​​the​​package​​raises​​at​​run​​time. For​​more​​info:​​​​​http://kosmiktechnologies.com/msbi-training-in-hyderbad/

  11. KosmikTechnologies ● Bulk​​​​Insert​​​​Task:​​​​​​The​​Bulk​​Insert​​task​​provides​​an​​efficient​​way​​to​​copy​​large​​amounts​​of data​​into​​a​​SQL​​Server​​table​​or​​view. ● Data​​​​Flow​​​​Task:​​​​​​The​​Data​​Flow​​task​​encapsulates​​the​​data​​flow​​engine​​that​​moves​​data between​​sources​​and​​destinations,​​and​​lets​​the​​user​​transform,​​clean,​​and​​modify​​data​​as​​it​​is moved.​​Addition​​of​​a​​Data​​Flow​​task​​to​​a​​package​​control​​flow​​makes​​it​​possible​​for​​the package​​to​​extract,​​transform,​​and​​loaddata. Execute​​​​DTS​​​​2000​​​​Package​​​​Task:​​​​​​The​​Execute​​DTS​​2000​​Package​​task​​runs ● packages​​that​​were​​developed​​by​​using​​the​​SQL​​Server​​2000​​tools.​​By​​using​​this task,​​you​​can​​include​​SQL​​Server​​2000​​DTS​​packages​​in​​SQL​​Server​​data transformation​​solutions. ● Execute​​​​Package​​​​Task:​​​​​​The​​Execute​​SQL​​task​​is​​one​​of​​the​​handier​​components​​in​​SQL Server​​Integration​​Services​​(SSIS)​​because​​it​​lets​​you​​run​​Transact-SQL​​statements​​from within​​your​​control​​flow.​​The​​task​​is​​especially​​useful​​for​​returning​​result​​sets​​that​​can​​then​​be used​​by​​other​​components​​in​​your​​SSIS​​package. ● Execute​​​​Process​​​​Task​​:​The​​Execute​​Process​​task​​runs​​an​​application​​or​​batch​​file​​as​​part​​of a​​SQL​​Server​​Integration​​Services​​package​​workflow. ● Web​​​​Service​​​​Task​​: ● XML​​Task Advance​​​​use​​​​of​​​​Control​​​​Flow ● For​​Loop​​Container ● For​​Each​​Loop​​Container ● Sequence​​Container Explain​​​​Variables​​​​and​​​​Configurations ● Variables​​Overview ● Variable​​scope For​​more​​info:​​​​​http://kosmiktechnologies.com/msbi-training-in-hyderbad/

  12. KosmikTechnologies ● SSIS​​system​​variables ● Using​​variables​​in​​control​​flow ● Using​​variables​​in​​data​​flow ● Using​​variables​​to​​pass​​information​​between overview​​​​of​​​​packages ● Property​​expressions ● Configuration​​Overview ● Configuration​​options ● Configuration​​discipline Debugging,​​​​Error​​​​Handling​​​​and​​​​Logging ● SSIS​​debugging​​overview ● Breakpoints​​in​​SSIS ● Control​​Flow:​​The​​On​​Error​​event​​handler ● Data​​Flow:​​Error​​data​​flow ● Configuring​​Package​​Logging ● Built-in​​log​​providers Extending​​​​SSIS​​​​through​​​​Custom​​​​Code​​​​Scripting ● Introduction​​to​​SSIS​​scripting ● The​​SSIS​​script​​editor ● The​​SSIS​​object​​model ● Script​​in​​Control​​flow:​​The​​Script​​Task ● Script​​in​​Data​​flow:​​The​​Script​​Component For​​more​​info:​​​​​http://kosmiktechnologies.com/msbi-training-in-hyderbad/

  13. KosmikTechnologies ● Introduction​​to​​SSIS​​component​​development Package​​​​Deployment​​​​of​​​​SSIS ● Configurations​​and​​deployment ● The​​deployment​​utility ● Deployment​​options ● Deployment​​security ● Executing​​packages​​DTExec​​and​​DTExecUI SSIS​​​​Package​​​​Management ● The​​SSIS​​Service ● Managing​​packages​​with​​DTUtil ● Managing​​packages​​with​​SQL​​Server​​Management Studio ● Scheduling​​packages​​with​​SQL​​Server​​Agent 2.​​​​SQL​​​​Server​​​​Analysis​​​​Services ● Introduction​​to​​SQL​​Server​​Analysis​​Services ● SSAS​​Architecture​​Overview ● Explain​​Microsoft​​Business​​Intelligence ● What​​is​​UDM ● Building​​and​​Viewing​​a​​Sample​​Cube ● Viewing​​a​​Cube​​Using​​Excel ● Cubes​​in​​Reporting​​Services ● Using​​SSAS​​in​​BIDS For​​more​​info:​​​​​http://kosmiktechnologies.com/msbi-training-in-hyderbad/

  14. KosmikTechnologies ● Understanding​​BIDS ● Creating​​Data​​Sources ● Creating​​Data​​Source​​Views ● Creating​​a​​Cube​​Using​​the​​Wizard ● Refining​​Dimensions​​and​​Measures Intermediate​​​​SSAS ● Creating​​KPIs ● Creating​​Perspectives ● Creating​​Translations ● Creating​​Actions ● Advanced​​SSAS ● Working​​with​​Many​​Fact​​Tables ● Using​​Advanced​​Dimension​​Types ● Working​​with​​Changing​​Dimensions ● Using​​the​​Business​​Intelligence​​Wizard Cube​​​​Storage​​​​and​​​​Aggregation ● Basic​​Storage:​​MOLAP ● Customized​​Aggregations ● Advanced​​Storage:​​MOLAP,​​HOLAP,​​or​​ROLAP ● Implementing​​Proactive​​Caching ● Using​​Partitions:​​Relational​​or​​SSAS ● Cube​​and​​Dimensions​​Processing​​Options Beginning​​​​MDX ● Understanding​​MDX For​​more​​info:​​​​​http://kosmiktechnologies.com/msbi-training-in-hyderbad/

  15. KosmikTechnologies ● About​​Members,​​Tuples,​​and​​Sets ● Common​​MDX​​Functions​​Explained ● New​​or​​Updated​​MDX​​Functions​​or​​Keywords Intermediate​​​​MD ● Understanding​​the​​Calculations​​Subtab ● Adding​​Calculated​​Members ● Adding​​MDX​​Scripts ● Adding​​Named​​Sets SSAS​​​​Administration ● Implementing​​SSAS​​Security ● Implementing​​XMLA​​Scripts ● Understanding​​SSAS​​Backup​​and​​Restore ● Understanding​​Performance​​Optimization Introduction​​​​to​​​​SSAS​​​​Clients ● Using​​Excel​​2007​​Pivot​​Tables ● Using​​SQL​​Server​​Reporting​​Services 3.​​​​SQL​​​​Server​​​​Reporting​​​​Services ● SQL​​Server​​Reporting​​Services​​(SSRS)​​Architecture ● Report​​types​​and​​formats ● SSRS​​Web​​Services ● Report​​Server ● Report​​Builder For​​more​​info:​​​​​http://kosmiktechnologies.com/msbi-training-in-hyderbad/

  16. KosmikTechnologies ● Model​​Designer ● Data​​sources:​​SQL​​Server,​​Oracle,​​OLE​​DB ● Authoring​​Reports Creating​​​​basic​​​​reports ● Tabular ● List ● Matrix ● Chart ● Constructing​​data​​sources​​and​​Datasets ● Inserting​​a​​data​​region,​​fields​​and​​images Leveraging​​​​expressions ● Calculating​​fields ● Integrating​​expressions​​in​​properties ● Applying​​conditional​​formatting ● Adding​​images Grouping​​​​and​​​​sorting​​​​data ● Grouping​​to​​multiple​​levels ● Sorting​​the​​results ● Employing​​aggregate​​functions Implementing​​​​Parameters​​​​and​​​​Filters Building​​​​parameters​​​​into​​​​reports ● Returning​​subsets​​of​​data​​with​​query​​parameters For​​more​​info:​​​​​http://kosmiktechnologies.com/msbi-training-in-hyderbad/

  17. KosmikTechnologies ● Mapping​​report​​parameters​​to​​query​​parameters ● Building​​cascading​​report​​parameters ● Passing​​parameters​​to​​stored​​procedures ● Exploiting​​multivalve​​parameters Restricting​​​​report​​​​data​​​​with​​​​filters ● Enhancing​​performance​​with​​filters ● Filters​​vs.​​query​​parameters ● Localizing​​tables​​and​​queries Leveraging​​​​Advanced​​​​Reporting​​​​Features Combining​​​​data​​​​regions​​​​in​​​​one​​​​report ● Utilizing​​sequential​​and​​nested​​regions ● Producing​​master/detail​​reports ● Linking​​subreports Presenting​​​​data​​​​with​​​​appropriate​​​​detail ● Revealing​​report​​detail​​with​​drill​​down ● Displaying​​related​​data​​with​​drill​​through ● Navigating​​with​​document​​maps Deploying​​​​and​​​​Delivering​​​​Reports Deploying​​​​reports​​​​to​​​​the​​​​server ● Preparing​​reports​​for​​publishing ● Configuring​​project​​properties ● Units​​of​​deployment:​​Individual​​reports,​​projects,​​solutions,​​data​​sources For​​more​​info:​​​​​http://kosmiktechnologies.com/msbi-training-in-hyderbad/

  18. KosmikTechnologies ● Checking​​results​​with​​Report​​Manager Securing​​​​Reporting​​​​Services Securing​​​​the​​​​RS​​​​environment ● Assigning​​users​​to​​roles ● Setting​​permissions​​on​​report​​items ● Granting​​and​​revoking​​system-level​​permissions Creating​​​​reports​​​​with​​​​Report​​​​Builder ● Deploying​​Report​​Builder​​to​​users ● Dragging​​and​​dropping​​entities​​onto​​charts​​and​​tabular​​reports ● Navigating​​data​​with​​infinite​​drill-through For​​more​​info:​​​​​http://kosmiktechnologies.com/msbi-training-in-hyderbad/

More Related