StarweaverStarweaver
  • Explore Courses
    • Collections

      • IT Management Frameworks
      • Live Online
      • Software Development
      • Finance Foundations – Capital Markets
      • Finance Foundations – Risk Management
      • Agile, Scrum, SAFe, Kanban…
      • Artificial Intelligence / Machine Learning
      • Business Domains
      • Big Data
      • Cloud
      • Certifications
      • Streaming Courses
  • Free Live Online
  • Get Certified
  • FOR BUSINESS
  • WEBINARS
    • Upcoming (Live)
    • Recorded (past)
  • Login?
    Explore Courses
    X
    • Streaming Courses
    • Live Online
    • Cloud
    • Artificial Intelligence / Machine Learning
    • Big Data
    • Agile, Scrum, SAFe, Kanban…
    • IT Management Frameworks
    • Software Development
    • Finance Foundations – Capital Markets
    • Finance Foundations – Corporate Finance
    • Finance Foundations – Risk Management
    • Certifications
    ⟵
    Python for Data Science & Machine Learning – Certification Boot Camp

    This Python for Data Science & Machine Learning Certification program covers how to use NumPy, Pandas, Seaborn, Matplotlib, Plotly, Scikit-L, and more in Machine Learning. Become a Python guru now!

    Learn More
    Immersion Certification in Continuous Integration and Development Tools

    This six (6) week training program combines live online, live in person and recorded content, instruction, labs, quizzes and tests to ensure delegates have a strong understanding.

    Learn More
    ⟵
    Streaming Courses View All
    Technology & Business
    • Business & Technical Writing Immersion
    • AWS Essentials
    • Cyber Security: Building a CyberWarrior Certification
    • Sales and Relationship Management
    Finance Related
    • Fundamental Financial Math
    • Capital Market Immersion
    • The Securities Trade Lifecycle
    • Commercial Credit Analysis
    ⟵
    Live Online View All
    Top Courses Now
    • Python for Data Science & Machine Learning – Certification Boot Camp
    • Azure Cloud Architect Immersion
    • Data Science & Machine Learning
    • Blockchain Business Consultant & Program Manager
    • AWS Certified Solutions Architect – Associate
    ⟵
    Cloud View All
    • Microservices Business Consultant & Program Manager Certification Program
    • Microservices Developer Certification Program
    • Understanding Kubernetes
    • Advanced Architecting on AWS
    • AWS Business Essentials
    • Big Data on AWS
    • Developing on AWS
    • DevOps Engineering on AWS
    ⟵
    Artificial Intelligence / Machine Learning View All
    Introduction/Intermediate
    • Understanding Machine Learning For Lawyers
    • Machine Learning Essentials
    • Intro to Deep Learning With TensorFlow
    • An Introduction to AI (Artificial Intelligence) and its applications
    Intermediate/Advanced
    • Data Science & Machine Learning – Developer Certification
    • DevOps Engineering on AWS
    • Machine Learning With Apache Spark
    • Machine Learning With Apache Spark
    • Machine Learning with Sagemaker (AWS)
    ⟵
    Big Data View All
    Dig into Data
    • Data Science and Big Data Analytics
    • Introduction to Python Programming
    • Data Analytics  With Python / Python for Data Scientists
    • Mastering Python
    ⟵
    Agile, Scrum, SAFe, Kanban… View All
    Certification Tracks
    • Certified ScrumMaster® (CSM)
    • Certified Scrum Product Owner® (CSPO)
    • SAFe 4.0 Scrum Master Orientation Training
    • Certified ScrumDeveloper® (CSD)
    Agile in Action
    • Introduction to Agile
    • Implementing Agile Test-Driven Development for Non-Programmers
    • Advanced Disciplined Agile Delivery
    • Collaborating and Communicating Agile Requirements
    ⟵
    IT Management Frameworks View All
    • TOGAF 9.1 Certified-Combined Program
    • Foundation Certificate Program – DevOps
    • ITIL ITSM 2011 Foundation Certification
    • Kanban Management Professional
    ⟵
    Software Development View All
    • Microservices Developer Certification Program
    • Data Science & Machine Learning – Developer Certification
    • Advanced Hadoop for Developers
    • Spark V2 For Developers
    ⟵
    Finance Foundations – Capital Markets View All
    Courses
    • Fundamental Financial Math
    • Yield Curve Building Blocks
    • Futures and Options Markets
    • Bonds with Options
    Full Curriculums
    • Capital Market Immersion
    • Capital Market Road Map
    • The Securities Trade Lifecycle
    • Market Risk Management and Capital Markets
    ⟵
    Finance Foundations – Corporate Finance View All
    Courses
    • Capital Asset Pricing Model
    • Principles of Credit Analysis
    • Corporate Financial Strategy & Capitalisation Alternatives
    • VBA Programming for Finance
    • Corporate Finance Modeling, Forecasting, Valuation and Capital Structure
    ⟵
    Finance Foundations – Risk Management View All
    Introduction/Intermediate
    • Financial Institutions and Risks
    • Credit Risk and Risk Management
    • Capital Markets: Products, Risks and Strategies
    Intermediate/Advanced
    • Financial Risk Management Essentials
    • Introduction to Credit Spreads and of the Management of Risk
    • Principles of Credit Analysis
    • Counterparty Credit Risk for Financial Institutions
    ⟵
    Professional View All
    Immersion Certification in Continuous Integration and Development Tools
    Azure Cloud Architect Immersion
    Data Science & Machine Learning Developer
    Blockchain Business Consultant and Program Manager
    • Explore Courses
      • Collections

        • IT Management Frameworks
        • Live Online
        • Software Development
        • Finance Foundations – Capital Markets
        • Finance Foundations – Risk Management
        • Agile, Scrum, SAFe, Kanban…
        • Artificial Intelligence / Machine Learning
        • Business Domains
        • Big Data
        • Cloud
        • Certifications
        • Streaming Courses
    • Free Live Online
    • Get Certified
    • FOR BUSINESS
    • WEBINARS
      • Upcoming (Live)
      • Recorded (past)
    • Login?

    Cutting Edge IT

    • Home
    • All courses
    • Cutting Edge IT
    • End to End Microsoft Business Intelligence From SQL 2008R2 to SharePoint 2010 and MS
    Home / LP Courses / Cutting Edge IT / Databases / End to End Microsoft Business Intelligence From SQL 2008R2 to SharePoint 2010 and MS

    End to End Microsoft Business Intelligence From SQL 2008R2 to SharePoint 2010 and MS

    sharepoint5
    Enquire

    Course Features

    • Duration: 40 hours
    • Skill Level: All level
    • Language: English

    Enrolled You have 10 weeks remaining for the course

    • Overview
    • Curriculum

    DESCRIPTION

    This course runs through the entire Microsoft BI stack allowing students to see everything from SQL Integration services ETL through SQL Analysis Services Cube building into Reporting Services with Report Builder 3.0 then SharePoint 2010 Business Center, Dashboard building with PerformancePoint Services, Excel Services and finishing with Data Mining and the Office Business Intelligence add-ins.

    Individuals need to have SQL DBA and developer background (writing code) before attending this class.

    TARGET AUDIENCE

    • This course is intended for DBAs, Developers and Business Intelligence Professionals seeking an introduction to the Microsoft BI Stack whether for new or existing projects or migration to the Microsoft environment or having a desire to view the new features in the entire stack.

    OBJECTIVES

    At the end of the course, students will be able to:

    • Describe the Microsoft Business Intelligence stack
    • Explain the Unified Dimension Model and when it can and cannot be used.
    • Use the new Business Intelligence Features in SQL 2008 R2
    • Create a SSAS Project using the Microsoft Unified Dimension Model
    • Create a Data Mart using Business Intelligence Studio
    • Create an Integration Services project and load a Data Mart
    • Load a Data Mart from a flat file.
    • Model Dimensions, Measures and Cubes
    • Understand the pros and cons of Integration into SharePoint
    • Create a Report using Report Builder 3.0
    • Load and Manage Reports with SharePoint
    • Utilize the Business Intelligence add-ins for Excel
    • Discover, design and implement KPIs
    • Understand the role of SQL Server Analysis Services in measurement for KPIs
    • Implement Time Intelligence features to query such as Year-To-Date, Last 6 Months etc.
    • Use Excel Services and Excel Workbooks in Scorecards or as a data source
    • Utilize the document management capabilities of SharePoint 2010 for objects for versioning, document retention and reverting.
    • Use Dashboard Designer
    • Gain a generalized understanding of MDX to write basic queries
    • Generate Visual Reports and tie them into Dashboards
    • Utilize decomposition trees
    • Understand what the advantages of having SharePoint as the platform are.
    • Use dynamic hierarchies in Scorecards
    • Implement User Menus in Scorecards
    1) Module 1: The Business Intelligence Stack
    • SQL 2008R2 Business Intelligence Platform
    • SQL Analysis Services
    • SQL Reporting Services
    • Performance Management Tools
    • SharePoint 2010
    • Multidimensional Space
    • MDX
    • Data Mining
    • Understanding the Terminology
    2) Module 2: Unified Data Model
    • UDM Defined
    • User Experience: Relational vs. UDM
    • Advantages
    • Trouble in River City
    3) Module 3: SQL Server Integration Services
    • Major Components
    • New or Changed Features
    • Script Task
    • Samples
    • SSIS and ETL
    • Transformers
    • Best Practices 1
    • Best Practices 2
    4) Module 4: SQL Server Analysis Services
    • Key Concepts
    • Schemas
    • Measures
    • Dimensions
    • Cube Processing
    • Partitions
    • Proactive Caching
    • Aggregations
    5) Module 5: SQL Server Reporting Services
    • Integration with SharePoint
    • Report Builder 3.0
    • Tablix
    • Charts
    6) Module 6: MDX (Optional)
    • What is MDX?
    • MDX Query Editor
    • Select Statement
    • Key Concepts
    • Sets
    • Functions
    • Time Intelligence
    7) Module 7: PerformancePoint Services 2010
    • Integration with SharePoint Server 2010
    • Common Service Application Framework
    • New PerformancePoint Features
    • Storage Security
    • Time Intelligence and Dynamic Filters
    • Linking of Web Parts
    • KPI Details Report
    • Retired Features
    • Scorecards in PPS
    • KPI Collections
    • Dashboard Design Guidelines
    8) Module 8: Excel and Visio Services 2010
    • Integration with SharePoint Server 2010
    • Storage Security
    • Single version of the truth
    • Excel Web Services
    • New capabilities
    9) Module 9: Excel PowerPivot
    • Integration with SharePoint Server 2010
    • Understanding
    • Modeling
    10) Module 10: Data Mining
    • Key Terms in Data Mining
    • Types of Data Mining Algorithms
    • The Algorithms
    • Excel and The BI Extensions
    • Visio 2007

    You May Like

    Python for Data Science & Machine Learning – Certification Boot Camp Read More
    techsupport

    Python for Data Science & Machine Learning - Certification Boot Camp

    Enquire
    Enquire

    Python for Data Science & Machine Learning – Certification Boot Camp

    Artificial Intelligence & Data Science, Live Now!

    50 hours ♦ All levels

    DESCRIPTIONThis course runs through the entire Microsoft BI stack allowing students to see everything from SQL Integration services ETL through SQL Analysis Services Cube building into Reporting Services with Report Builder 3.0 then SharePoint 2010 Business Center, Dashboard building with PerformancePoint Services, Excel Services and finishing with Data Mining and the Office Business Intelligence add-ins.Individuals need to have SQL DBA

    More DetailsEnquire Now
    Immersion Certification in Continuous Integration and Development Tools Read More
    techsupport

    Immersion Certification in Continuous Integration and Development Tools

    Enquire
    Enquire

    Immersion Certification in Continuous Integration and Development Tools

    Certifications

    50 hours ♦ All levels

    DESCRIPTIONThis course runs through the entire Microsoft BI stack allowing students to see everything from SQL Integration services ETL through SQL Analysis Services Cube building into Reporting Services with Report Builder 3.0 then SharePoint 2010 Business Center, Dashboard building with PerformancePoint Services, Excel Services and finishing with Data Mining and the Office Business Intelligence add-ins.Individuals need to have SQL DBA

    More DetailsEnquire Now
    Azure Cloud Architect Immersion Certification Program Read More
    Paul Siegel

    Azure Cloud Architect Immersion Certification Program

    Enquire
    Enquire

    Azure Cloud Architect Immersion Certification Program

    Certifications, Cloud, Learn Now, Live Now!

    60 hours ♦ All levels

    DESCRIPTIONThis course runs through the entire Microsoft BI stack allowing students to see everything from SQL Integration services ETL through SQL Analysis Services Cube building into Reporting Services with Report Builder 3.0 then SharePoint 2010 Business Center, Dashboard building with PerformancePoint Services, Excel Services and finishing with Data Mining and the Office Business Intelligence add-ins.Individuals need to have SQL DBA

    More DetailsEnquire Now

    Leave A Reply Cancel reply

    You must be logged in to post a comment.

    Latest Courses

    Blockchain and Machine Learning

    Blockchain and Machine Learning

    Blockchain and Machine Learning

    Blockchain, Cutting Edge IT, Machine Learning

    3 Days ♦ All levels

    Blockchain is a forge-proof distributed database, and Machine Learning is a popular technology that allows computers to understand and learn from data. Combined, then give rise to a new class of applications. In this class, the students learn about the technologies and implementation of combined Blockchain + Machine Learning use cases.Goals ● Get a solid foundation in Blockchain, Bitcoin, Ethereum, Hyperledger ●

    More DetailsEnquire Now
    Introduction to Python Programming

    Introduction to Python Programming

    Introduction to Python Programming

    App Development, Big Data, Cutting Edge IT, Data Analysis, Databases, Programming Languages

    24 hours ♦ All Levels

    DESCRIPTION Python has been around for decades, but it's still one of the most versatile and popular programming languages out there. Whether you're relatively new to programming or have been developing software for years, Python is an excellent language to add to your skill set. In this course, you'll learn the fundamentals of programming in Python, and you'll develop applications to

    More DetailsEnquire Now
    Blockchain Business Applications (4 hours)

    Blockchain Business Applications (4 hours)

    $97.50$124.95

    Blockchain Business Applications (4 hours)

    Blockchain, Cloud, Cutting Edge IT, Data Analysis, Machine Learning

    4 Hours ♦ All levels

    Description    This course is for IT consultants and business staff familiar with blockchain basics, who want to know how to apply blockchain in business functions. The course provides a solid foundation and understanding of blockchain technology (including its principles and fundamental operations) as well as a solid understanding the many growing applications of blockchain in business.  The course is

    More Details

    $124.95$97.50

    starweaver-logo-transparent

    795 Folsom Street, San Francisco, California 94107 || +1-415-483-2260 // +44 20 3289 3277

    COMPANY

    About Us
    Jobs & Careers
    Help/Support
    Policies and Terms
    Contact

    PARTNER WITH US

    Instructors & Teachers
    Channel Partners/Affiliates
    Writing and Publishing

     

    COMMUNITY

    Slack Channel
    Alumni

    FOR BUSINESS

    What Customers Say
    Private Classes
    Learning Paths
    Competency Frameworks

    Follow us

    Education you can bank on® ||  People are your most important assets!® || People are the only real asset!®

    © Starweaver Group, Inc. All Rights Reserved.

    Welcome to Starweaver!

    Stay informed and sharpen your skills!

    This website uses cookies, including third party ones, to allow for analysis of how people use our website in order to improve your experience and our services. By continuing to use our website, you agree to the use of such cookies. Click here for more information on our Privacy Policy.

    More information
    Privacy SettingsCookies

    Privacy Settings

    This website uses cookies, including third party ones, to allow for analysis of how people use our website in order to improve your experience and our services. By continuing to use our website, you agree to the use of such cookies. Click here for more information on our Privacy Policy. You may change your settings at any time. Your choices will not impact your visit.

    NOTE: These settings will only apply to the browser and device you are currently using.

    Cookies

    This website uses cookies, including third party ones, to allow for analysis of how people use our website in order to improve your experience and our services. By continuing to use our website, you agree to the use of such cookies.

    Accept