Showing all 9 results
In this course, students will gain the fundamental technical expertise needed to craft basic Transact-SQL queries for Microsoft SQL Server. Through hands-on learning, they will discover how to generate results from tables and also understand ways to form, modify or eradicate data in a database.
This course will provide a comprehensive overview of the job duties and functions that data analysts need to be familiar with, such as techniques and approaches for creating models, displaying visualizations, and evaluating information through Power BI. Besides that, you’ll also get to learn how to access various types of data sources – both relational and non-relational – in order to process them properly.
For years, Microsoft has been the go-to brand for database technology and it remains a top preference among many corporations and individual users alike. This comprehensive training series covers versions 2012 through 2019 of Microsoft SQL Server that are still extensively utilized at present. You will be given an in-depth look into SQL Server administration, database design, analysis services, reporting services, PowerBI and more during this learning program.
This course will teach you how to use Power Apps visuals, which allow your app users to get business insights and take actions from their Power BI reports in real-time. Moreover, we’ll look into the ways that Power BI and SQL Server Analysis Services can be integrated for enterprise-level data models and analysis. Don’t miss out on this chance to unlock deeper insights into your report with up-to-date context data!
With this course, you will be able to become an expert in employing both engines within a company’s infrastructure. Analysis Services is composed of two powerful applications – VertiPaq and Data Mining for multidimensional cubes, as well as xVelocity for Tabular Data Models. It provides enterprise-level semantic data modeling abilities to construct business intelligence systems such as Power BI, Excel Reporting Services and other information visualization tools that can make your organization even more successful!
Dive into the depths of SQL Server 2019 with this course and discover one of its most invaluable tools, Big Data Clusters. Here, you will fully explore data virtualization and lakes in order to build a complete artificial intelligence (AI) and machine learning (ML) platform directly within the SQL Server database engine.
In this course you will learn how to create managed enterprise BI solutions. You will learn how to implement multidimensional and tabular data models, deliver reports with Microsoft SQL Server Reporting Services, create dashboards with Microsoft SharePoint Server PerformancePoint Services, and discover business insights by using data mining. This course will also teach you how to create BI solutions that require implementing multi-dimensional data models, implementing and maintaining OLAP cubes, and creating information displays used in business decision making.
In this course you will learn how to create Business Intelligence (BI) solutions. This course will teach you how to implement a data warehouse platform to support a BI solution. You will learn how to create a data warehouse with Microsoft SQL Server 2012, implement ETL with SQL Server Integration Services, and validate and cleanse data with SQL Server Data Quality Services and SQL Server Master Data Services.
In this course you will learn how to plan and design a business intelligence (BI) infrastructure by designing a reporting solution, designing BI data models and designing an ETL solution. This course will teach business intelligence (BI) architects the overall design of a BI infrastructure and how it relates to other data systems in use.
Comments From Our Students