Course Description
Language of Instruction:English|Category: SQL Server: IT & Computers
Designed as part of the world’s most popular business productivity suite, Microsoft Business Intelligence is designed to empower business users through the familiar tools they already know how to use today.
Microsoft Business Intelligence is designed for better management of critical data assets across diverse systems to ensure the integrity of information, spanning the desktop, datacenter, and cloud.
Most business data resides in SQL format in most data centers. It is critical to be able to mine this data intelligently. This course introduces students to Business Intelligence and Data Warehousing. Although this course is designed for beginners, it will also be useful for experienced students to further sharpen and apply the knowledge they acquire in this course in their profession. The course is designed keeping SQL Server 2008 in mind and you must have a good understanding of SQL and SQL Server 2008 to benefit from this course.
This is an instructor led course and is structured to provide a solid foundation of the SQL Server (Business Intelligence). By the end of this course, you can expect to:
- Create your own reports and analysis and easily share and collaborate with your colleagues
- Analyze millions of rows of data at lightning-fast speed by using PowerPivot for Excel
- Manage self-service reporting solutions
- Accelerate report creation and simplify collaboration and management
- Analyze millions of rows of data at lightning-fast speed by using PowerPivot for Excel etc.
What’s in the course:
- Course Duration: 60 Hours
- 30 LIVE Online classes | 2 Hours each
- Live Lab sessions
- Flexible class timings
- Access to Recorded classes/ Course material
Why you should join this course?
- Enroll in an economical course : the course is priced much less compared to other SQL courses
- Experience a modern learning environment: LIVE interactive learning including LAB Sessions
- Enhance your learning: 60 hours course covering all aspects of SQL Server and practical course with plenty of room for questions & doubts
- Advance your knowledge : learn from an experienced online teacher with excellent student rating
Course outline:
The following topics will be covered in this course:
1. Business Intelligence Design
- Data Warehousing
- Star schema
- Snowflake schema
- Surrogate keys
- Consistency
- Changing data in dimensions
2: Building Multidimensional Cubes with Analysis Services
- Analysis Services Quick Start
- Analysis Services Architecture
- Unified Dimensional Model
- Server
- Client
- Building a Database
- Business Intelligence Development Studio
- Data sources
- Data source view
- Creating a cube
- Dimensions
- Dimension Designer
- Beyond regular dimensions
- Dimension refinements
- Cubes
- Cube structure
- Dimension usage
- Calculations
- KPIs
- Actions
- Partitions
- Aggregation design
- Perspectives
- Data Storage
- Proactive caching
- SQL Server notifications
- Client-initiated notifications
- Scheduled polling notifications
- Data Integrity
- Null processing
- Unknown member
- Error Configuration
3: Programming MDX Queries
- Basic Select Query
- Cube addressing
- Dimension structure
- Basic SELECT statement
- Advanced Select Query
- Sub cubes
- WITH clause
- Dimension considerations
- MDX Scripting
- Calculated members and named sets
- Adding Business Intelligence
4: Authoring Reports with Reporting Services
- Anatomy of a Report
- Report Definition Language (RDL)
- Data Sources
- Reporting Services datasets
- Query parameters and report parameters
- Report content and layout
- The Report Authoring Process
- Creating a Reporting Services project
- Creating a report
- Using the Report Wizard to create reports
- Authoring a report from scratch
- Working with Data
- Working with SQL in the Query Designer
- Using query parameters to select and filter data
- Adding calculated fields to a dataset
- Working with XML data sources
- Working with expressions
- Designing the Report Layout
- Design basics
- Using the Tablix property pages
- Grouping and sorting data in a Tablix
- Illustrating data with charts and gauges
5: Administering Reporting Services
- Deploying Reporting Services Reports
- Deploying reports using BIDS
- Deploying reports using the Report Manager
- Deploying reports programmatically using the Reporting Services Web Service
- Configuring Reporting Services Using Management Studio Configuring
- Reporting Services server properties Security: managing roles Configuring
- Reporting Services Using Report Manager
- Managing security
- Working with linked reports
- Creating linked reports
- Leveraging the power of subscriptions
- Creating a data-driven subscription
6: Analyzing Data with Excel
- Data Connections
- Data Connection Wizard
- Microsoft Query
- Connection file types
- Basic Data Analysis
- Data tables
- PivotTables
- Pivot Charts
- Advanced Data Analysis
- Installing the data mining add-ins
- Exploring and preparing data
- Table analysis tools
- Data mining client
7: Data Mining with Analysis Services
- The Data Mining Process
- Modelling with Analysis Services
- Data Mining Wizard
- Mining Models view
- Model evaluation
- Algorithms
- Decision tree
- Linear regression
- Clustering
- Sequence clustering
- Neural Network
- Logistic regression
- Naive Bayes
- Association rules
- Time series
- Cube Integration
About the teacher:
Prof. Rao is one of the most experienced IT trainers. He has been training students in person and online for well over a decade. He is experienced in Linux, C++ and SQL. All his courses usually sell out weeks in advance and receive excellent student feedback. His affable and friendly style makes him an ideal teacher to trust your IT learning with.