If you are tasked with developing solutions for your company or your department, you will be interested in this certificate. This course topics are centered on the business user aspects of SQL and SharePoint development and is recommended for you. If you work with data sets in SQL and third party tools required to run key systems. This curriculum is great for the transitional employee who may not be in the IT Department, but you are the most “technical” person in your department/organization.
· Administer SQL Server
· Query SQL Server
· The SQL Warehouse (modeling)
· Build Reports from SQL Server data
· Core Solutions Development: SharePoint
The course focuses on teaching individuals how to use SQL Server 2012 features and tools related to maintaining a database. In this session we covers key aspects of SQL Server database administration. From setting up a server on premises or in the cloud. Learn the impact of core key administrative processes, such as proper disaster recovery via backup and restore processes. Hear best practices for data security. Learn about data distribution via replication and other common methods.
You do not have to be a developer to write SQL queries. Obviously if you are a developer, you will write queries. If you are an analyst, you will probably pull information from various data sources that include variations of SQL. Understanding the key components is critical for working productively and accurately with data. After you have experienced our fantastic approach to queries you will be able to write selects, work with multiple tables with confidence. Learn to get the most out of the built in functions and the benefits of stored procedures.
This course focuses on teaching individuals how to create a data warehouse with SQL Server 2012, validate and cleanse data with SQL Server Data Quality Services and SQL Server Master Data Services, and implement ETL with SQL Server Integration Services. Explore the possibilities in SQL Server for creating an OLAP store. Lynn covers read-only copies, OLAP cubes and Tabular models. Learn about Analysis Services vs. read-optimized strategies in the relational engine.
This course teaches students how to empower information workers through self-service analytics and reporting. Students will learn how to implement multi-dimensional analysis solutions, create PowerPivot and tabular data models, deliver rich data visualizations with PowerView and SQL Server Reporting Services, and discover business insights by using data mining. Course covers SQL Server Reporting Services and other reporting technologies. Discover impact of the cloud to the enterprise both in technologies available now and those that she sees as gaining momentum over the next few years – focusing on SharePoint as a tool for enterprise reporting and dashboarding.
SharePoint and similar technologies are used more widely than ever before. We hear about "portals" all the time with every day people discussing the need for them. SharePoint allows you to create your own portals or silos of information. Understand how to properly get started building the sites that you need to manage the documents and day to day data of your company or department. Learn how to work with security and permissions. Learn how to build critical business processes and build workflows to pass information with ease to the right people at the right times.
If you are seeking a new career path or want to sharpen your skills in data and business intelligence then this is the ideal certificate. As power users, you will deal with data from multiple data sources, so having strong Excel and SQL skills adds value to building long term systems(and every other data set you encounter).In the lifecycle of BI you will at some point be involved in project management. This course is recommended for someone who is seeking the skills needed to effectively work in business intelligence and data analysis. If you are a professional working with multiple data sets and providing multiple reports monthly you can benefit from any of the courses in this certificate.
· Data Analysis and Business Modeling with Microsoft Excel
· Use Microsoft Excel PowerPivot
· Database Administration Fundamentals
· Design Business Intelligence Solutions
· Introduction to SSRS: Reports from SQL Server data
Learn how to use the latest Excel tools to integrate data from multiple tables. We will show you how to effectively build a relational data source inside an Excel workbook. In this hands-on course, master business modeling and analysis techniques with Microsoft Excel 2013, and transform data into bottom-line results. These skills are necessary for being able to effectively work with the data tools provided in Excel and other technologies like SharePoint. Understanding how to get data into your solution to build the proper reports, then have the flexibility to build those reports plus others.
Build a more automated solution while you wait for it to be “automated.” People need the data whether the report is automated or not. We have the need to deliver ad hoc reports faster today than ever before. In this class transform your data, and business skills—and create your own business intelligence solutions using software you already know and love: Microsoft Excel. Learn PowerPivot functionality for Excel 2013 to apply to your own real world scenarios, problem-solving, and data modeling. You’ll learn how to make data into meaningful information and get ad hoc reporting to make decisions faster with better than just your standard pivot options—and no coding required.
No matter what your exact role if you are in this course then it’s understood that you need to understand core database concepts. If you understand how to create database objects then you can learns ways to identify better data and how the system will tie that data together. You will learn techniques on manipulating data. You will also learn keys to data storage, and things that are administer in databases. This helps define permission and security procedures.
If you are responsible for creating BI Solutions for your company and don’t know where to start this course covers the high level overview of key areas: Plan the components of a BI solution. Plan a BI infrastructure. Design a Reporting Services solution. Design an Excel reporting solution. Plan a SharePoint Server BI solution. Plan for BI operations.
Learn how to get more from your data when practice self-service analytics and reporting. You will learn how to implement solutions, gain a basic understanding of PowerPivot and SQL Server Reporting Services, and discover business insights by using data mining. If you are considering a future as a database professional who wants to fulfill a business intelligence role. Create reports with reporting services. Create reusable report items that simplify self-service reporting. Manage report execution and delivery.