This course teaches attendees how to implement a SQL Server® 2016 Reporting Services solution for data analysis in an organization. The course discusses how to use the Reporting Services development tools to create and manage reports and implement self-service BI solutions.
The main purpose of this course is to give participants the ability to add analysis capabilities to Excel® spreadsheets. It also provides participants with a foundation to learn about more advanced data analytics with Excel or Power BI®.
This course examines how to plan, configure, and manage a Microsoft® SharePoint® Server 2013 environment. Special areas of focus include implementing high availability, disaster recovery, service application architecture, Business Connectivity Services, social computing features, productivity and collaboration platforms and features, business intelligence solutions, enterprise content management, web content management infrastructure, solutions, and apps. The course also examines how to optimize the search experience, how to develop and implement a governance plan. and how to perform an upgrade or migration to SharePoint Server 2013.
This course will teach participants how to plan, configure, and manage the advanced features in a SharePoint® 2016 environment. The special areas of focus for this course include implementing high availability, disaster recovery, service application architecture, and Microsoft® Business Connectivity Services. This course also focuses on social computing features, productivity, and collaboration platforms and features. Participants also will learn about Business Intelligence (BI) solutions, Enterprise Content Management, web content management infrastructure, solutions, and apps. This course also covers how to develop and implement a governance plan, and how to perform an upgrade or a migration to SharePoint 2016. NOTE: This course is the second in a sequence of two courses for IT Professionals.
This course provides participants with the technical skills required to write basic Transact-SQL queries for Microsoft® SQL Server® 2014. This course is the foundation for all SQL Server-related disciplines; namely, Database Administration, Database Development and Business Intelligence.
This course introduces participants to SQL Server® and describes logical table design, indexing and query plans. It also focusses on the creation of database objects including views, stored procedures, along with parameters, and functions. Other common aspects of procedure coding, such as indexes, concurrency, error handling, and triggers are also covered in this course.
The focus of this course is on creating managed enterprise BI solutions. It describes 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 teaches participants how to plan and design a BI solution that is based on Microsoft® SQL Server® 2014 and other Microsoft BI technologies.
This course provides attendees with the knowledge and skills to provision a Microsoft® SQL Server® database. It covers SQL Server provision both on-premise and in Azure®, and covers installing from new and migrating from an existing install.
The focus of this course is on creating managed enterprise BI solutions. It describes how to implement both multidimensional and tabular data models and how to create cubes, dimensions, measures, and measure groups. This course also helps you prepare for the certification exam.
This course provides participants with the knowledge and skills to analyse data with Power BI®.
This course will teach participants how to use PowerPivot to access data sources, create relationships, use the PowerPivot DAX expressions and generate and format reports. They will also explore how PowerPivot workbooks can be integrated with SharePoint®.
This course is designed to introduce participants to the SQL Business Intelligence Semantic Model (BISM) Tabular model, data modelling, and DAX.
This course teaches participants how to combine the functionality of Power View, PowerPivot, Power Query, and Power BI® into graphs, charts, KPIs, reports, and other visualizations for use in their business.
This course will take participants on a journey from the concepts of a Microsoft® Power BI® project right through to the end result in an engaging and structured format. Participants will get hands-on with a wealth of data to practise the techniques taught in this course.
This course teaches participants the knowledge and skills required to transform business requirements in support of data-driven decisions. They will learn to do so by mining and manipulating data, applying basic statistical methods, and analysing complex data sets while adhering to governance and quality standards throughout the entire data lifecycle. In addition, this course will help prepare participants to take the certification exam. Also, this course may earn participants a Credly Badge.
Organizations use reporting tools to access data sources and generate customized reports. Crystal Reports® 2016 enhances report building and report processing techniques with a variety of features that add value to a presentation. In this course, participants will create a basic report by connecting to a database and modifying the report's presentation.
In this course, participants will create complex reports and data sources using the tools in Crystal Reports® 2016. They will not only create more sophisticated reports including subreports, cross-tabs and running totals but will also increase the speed and efficiency of their reports by using SQL queries.
Information is critical to making sound business decisions. Data presented without any formatting or structure holds little or no meaning for interpretation. Thus, organizations use reporting tools to access data sources and generate customized reports. In this course, participants will create a basic report using Crystal Reports® 2020 by connecting to a database and modifying the report's presentation.
Until now, you have used Crystal Reports® 2020 to build and modify reports. You want to use the advanced functionality of Crystal Reports to generate reports in the format you desire. In this course, participants will create complex reports and data sources using the tools in Crystal Reports 2020. They will create more sophisticated reports including subreports and cross-tabs but also increase the speed and efficiency of their reports by using SQL queries. By creating subreports, cross-tabs, and running totals, they will turn raw data into meaningful customized reports that will help their business run more smoothly. Participants will also learn to use tools that can increase the speed with which data is retrieved and thus eliminate any performance issues they may be faced with.
This course will discuss the various methods and best practices that are in line with business and technical requirements for modelling, visualizing, and analysing data with Microsoft® Power BI®. The course will also show participants how to access and process data from a range of data sources including both relational and non-relational data. This course will also explore how to implement proper security standards and policies across the Power BI spectrum including datasets and groups. The course will also discuss how to manage and deploy reports and dashboards for sharing and content distribution. Finally, this course will show participants how to build paginated reports within the Power BI service and publish them to a workspace for inclusion within Power BI.
Analysing data to find issues, insights, and opportunities is now a critical part of many job roles. Beyond the analysis, data analysts in all job roles must be able to effectively present and communicate their findings in visually compelling ways. Microsoft® Excel® is designed for this purpose. This course will show participants how to use Excel to connect to a wide range of data sources, perform robust data analysis, and create diverse and robust data-backed visualizations to show insights and trends, and create reports. At the end of this course, these capabilities will enable participants to turn data into thoughtful action.
In this course, participants will learn about data engineering as it pertains to working with batch and real-time analytical solutions using Azure data platform technologies. They will learn how to create, manage, use, and configure data services in the Azure portal. Through a blend of hands-on labs and interactive lectures, participants will learn to build and maintain secure and compliant data processing pipelines by using different tools and techniques. Participants will learn to use various Azure data services and languages to store and produce cleansed and enhanced datasets for analysis. Lastly, participants will be able to create a real-time analytical system to create real-time analytical solutions.
With the tremendous amount of available data, the ability to make sense of it continues to be an ongoing challenge. You already know how to use Excel to perform simple calculations and modify worksheets to make them easier to read, interpret, and present to others. But Excel can do so much more. This course introduces the basics of data analysis and how to use Excel to create informative dashboards. This allows participants to be able to extract actionable organizational intelligence from their raw data and present it in a visually compelling format that enables decision-makers to view key trends and gain insights. Note: This course builds upon the foundational knowledge presented in the Microsoft® Excel® for Office 365™ (Desktop or Online): Part 1 course and introduces the basics of data analysis and how to use Excel to create informative dashboards.
With the tremendous amount of available data, the ability to make sense of it continues to be an ongoing challenge. This course introduces the basics of data analysis and how to use Microsoft® Excel® to create informative dashboards. This allows participants to be able to extract actionable organizational intelligence from their raw data and present it in a visually compelling format that enables decision-makers to view key trends and gain insights.
This course builds upon the foundational knowledge presented in either of the Microsoft® Office Excel® 2016: Part 1 (Desktop/Office 365™) courses. It will help participants start down the road to creating advanced workbooks and worksheets that they can use to create dashboards. The ability to analyse massive amounts of data, extract actionable intelligence from it, and present that information to decision-makers is the cornerstone of driving a successful organization that can compete at a high level.
Advances in technology have made it possible to store ever increasing amounts of data. Along with this, the need to analyse that data and gain actionable insight is greater than ever. You already have experience working with Excel® and creating basic PivotTables to summarize data. But, Excel® is capable of doing much more. Being able to harness the power of advanced PivotTable features and create PivotCharts will help you to gain a competitive edge. You will not only be able to summarize data for you to analyse, but also organize the data in a way that can be meaningfully presented to others. This leads to data-driven business decisions that have a better chance of success for everyone involved.
We are now living in the age of big data. Data is being collected all the time and for increasingly detailed transactions. This can lead to an overwhelming amount of data, which brings about a need for people who can analyse large amounts of data quickly. Fortunately, Excel® provides Power Pivot to help users organize, manipulate, and report on their data in the best way possible. Since a tool is only as good as the person using it, it is important to gain a solid understanding of Power Pivot to maximize your effectiveness when analysing data.
Data scientists, or any professional, use the creation of data-backed visualizations to explore, analyze, and report insights and trends from data. Microsoft® Power BI® software is designed for this purpose. Power BI was built to connect to a wide range of data sources and allows users to quickly create visualizations of connected data to gain insights, show trends, and create reports. Its data connection capabilities and visualization features go far beyond those that can be found in spreadsheets, allowing users to create compelling and interactive worksheets, dashboards, and stories that bring data to life and turn data into thoughtful action. This course teaches attendees how to use Power BI to leverage (“big”) data effectively so that it provides timely insights and competitive advantage.
Data scientists, or any professional, use the creation of data-backed visualizations to explore, analyze, and report insights and trends from data. Microsoft® Power BI® software is designed for this purpose. Power BI was built to connect to a wide range of data sources and allows users to quickly create visualizations of connected data to gain insights, show trends, and create reports. Its data connection capabilities and visualization features go far beyond those that can be found in spreadsheets, allowing users to create compelling and interactive worksheets, dashboards, and stories that bring data to life and turn data into thoughtful action. This course teaches attendees how to use Power BI to leverage (“big”) data effectively so that it provides timely insights and competitive advantage.
This course will discuss the various methods and best practices that are in line with business and technical requirements for modelling, visualizing, and analysing data with Microsoft® Power BI®. The course will also show how to access and process data from a range of data sources including both relational and non-relational data. This course will also explore how to implement proper security standards and policies across the Power BI spectrum including datasets and groups. Lastly, the course will also discuss how to manage and deploy reports and dashboards for sharing and content distribution.
This course covers everything participants need to progress from simply knowing basic SQL to telling stories and identifying trends in data. Participants will be able to start exploring their data by identifying patterns and unlocking deeper insights. They will also gain experience working with different types of data in SQL, including time-series, geospatial, and text data. Finally, they will understand how to become productive with SQL with the help of profiling and automation to gain insights faster. By the end of the course, participants will be able to use SQL in everyday business scenarios efficiently and look at data with the critical eye of analytics professional.