How to become ASP.NET Developer dot net video tutorials download kudvenkat videos Subscribe Kudvenkat Blog follow pragimtech on facebook follow pragimtech on twitter follow pragimtech on google plus
Home C# ASP.NET MVC GridView JavaScript Placements Contact Feedback Subscribe Careers Support us
Contact Details Phone:
+91 99456 99393
+91 80958 31888
WhatsApp:
+91 99001 13931
Email:
pragim@pragimtech.com
pragim@gmail.com
Address:
2nd Floor
Above Pick 'N' Move
Adjacent to HP Petrol Pump
Marathalli, Bangalore

Course Contents Oracle Apps Advanced Pricing
Oracle Apps ASCP Functional
Oracle Apps SCM Functional
DOT NET | MVC
Sharepoint
MSBI
Siebel CRM
Informatica (9.1)
Informatica Data Quality (9.5.1)
Java J2EE
EMC SAN
Testing Tools
Selenium Testing
HADOOP
TIBCO
Tableau
Oracle DBA
Oracle PL/SQL
Oracle OFSAA
Oracle OBIEE
QlikView
IBM MQ Admin
Android
Salesforce
Devops
UI Development

Interview Questions Dot Net Video Tutorials
C#
C# Programs
ASP.NET
WCF
SQL Server
MVC
HR
PRAGIM Technologies: MSBI Course Contents
Introduction to MS - BI:
  • What is MS-BI
  • BI/DWH life cycle
  • ETL and OLAP Tools
  • Features of MS-BI
Introduction to SSIS:
  • Package
  • Tasks
  • SSIS installation
  • SSIS Architecture
  • SSIS Wizard
  • Control Flow Tasks
  • Data Flow Task
  • Variables and Expressions
  • Errors and Debugging SSIS
  • Data viewers
  • Deployment
  • Manually Executing SSIS Package
  • Scheduling SSIS Package
  • Importing and Exporting Packages
  • Monitoring and Optimizing Packages
Introduction to SQL Server Reporting Services:
  • Reporting Services Architecture
  • Reporting Services Terminology
Creating Reports:
  • Deconstructing Reporting Services
  • Shared Data Sources
  • Creating Reports from Scratch
Calculations and Formatting:
  • Creating Expressions
  • Using the Global Collection
Grouping and Sorting:
  • Creating Groups and Calculating Totals and Percentages
  • Interactive Sorting, Creating Drill-Down Reports
Report Parameters
  • Creating Report Parameters
  • Creating Drop-Down Parameters
  • Multi-Valued Parameters
  • Debugging Parameter Issues
Creating Matrix Reports and Charts:
  • Creating a Basic Matrix Report
  • Matrix Subtotals
  • Creating a Basic Chart
  • Exploring the Charting Possibilities
Reporting Services Security:
  • Two Parts to Reporting Services Security
  • Securing Access to Reports
  • Data Source Security
OLAP Modeling:
  • Modeling source schemas—stars and snowflakes
  • Understanding dimensional modeling— Dimensions (Type 1, 2, or 3) or rapidly changing
  • Understanding fact (measures) and cube modeling
Intermediate SSAS:
  • KPIs
  • Perspectives
  • Translations – cube metadata and currency localization
  • Actions – regular, drill-through and reporting
Advanced SSAS:
  • Using multiple fact tables
  • Modeling intermediate fact tables
  • Modeling M:M dimensions, Fact (degenerate) dimensions, Role-playing dimensions, write back dimensions
  • Modeling changing dimensions – Dimension Intelligence w/ Wizard
  • Using the Add Business Intelligence Wizards – write-back, semi-additive measures, time intelligence, account intelligence
Cube Storage and Aggregation:
  • Storage topics – basic aggregations, MOLAP
  • Advanced Storage Design – MOLAP, ROLAP, HOLAP
  • Partitions – relational and Analysis Services partitions
  • Customizing Aggregation Design - Processing Design
  • Rapidly changing dimensions / ROLAP dimensions
  • Welcome to the Real Time – Proactive Caching
  • Cube processing options
Beginning MDX:
  • Basic syntax
  • Using the MDX query editor in SQL Server Management Studio
  • Most-used Functions & Common tasks
  • New MDX functions
Disclaimer - Terms of use - Contact Us