Oak Brook Classes Chicago, IL

The main purpose of the course is to review the essential skills needed to take data from Excel into Power BI then transform and shape the data, model the data, create reports, then publish the reports on the Power BI cloud service. Audience profile: The course is individuals who are not IT professionals but need to easily create and publish reports...

The main purpose of the course is to give students a good understanding of data analysis with Power BI. The course includes creating visualizations, the Power BI Service, and the Power BI Mobile App. This course uses Power BI Desktop, the Power BI cloud-based service and Excel 2016. Audience profile The course will likely be attended by report creators...

Communicating ideas and information is the cornerstone of organizational operations. And, electronic forms of communication have made the transfer of knowledge quick, easy, and inexpensive. The ability to harness the potential of electronic forms of communication is critical in nearly every type of organization. But, in many, if not most, organizations,...

This course is for individuals responsible for taking data and turning it into powerful reports. With DAX you can create reusable formulas the allow you to rapidly iterate and answer questions across multiple data tables and across different sources for complex reporting requirement. This course covers essential information needed for DAX-related...

Prerequisites Excel 2010 Introduction or equivalent skills. Must be able to create, open, save, format and print a worksheet. Should be able to use formulas and the SUM function. The ability to copy, move and delete values and formulas is required. Working with Worksheets Viewing, Renaming, and Color-coding Worksheets Editing a Group Manipulating...

Overview The new analytics tools in Excel make it easy to conduct manipulate and gain insights from big data. PowerPivot extends the use of pivot tables with a data model and offers improved data summarization and cross-tabulation and advanced calculations. Power Query retrieves data from a variety of sources can be cleaned up before being added to...

Communicating ideas and information is the cornerstone of organizational operations. And, electronic forms of communication have made the transfer of knowledge quick, easy, and inexpensive. The ability to harness the potential of electronic forms of communication is critical in nearly every type of organization. But, in many, if not most, organizations,...

As a business professional, you have some experience using Adobe® Acrobat®. Now you're ready to take further advantage of all the features of Acrobat Pro DC to bring your documents to the next level. Whether you are creating PDFs for commercial printing or for viewing digital versions on a range of platforms, Adobe Acrobat Pro DC enables you to output...

The main purpose of the course is to give students the ability to add BI techniques to Excel data analysis. The course goes beyond the capabilities of tables and charts and uses Pivot Charts, the Excel Data Model, and Power BI. Audience profile: This course is intended for anyone responsible for analyzing data with Excel. The course will likely be...

This course is intended as a continuation of our introductory-level courses in Power BI (20778: Analyzing Data with Power BI and/or Excel BI Tools: Power BI for Excel Users ). It covers common intermediate-level tasks and some of Power BI’s most desireable new features. Prerequisites Before attending this course, students should have: - General...

This five-day instructor-led course teaches IT Pros how to deploy and configure Active Directory Domain Services (AD DS) in a distributed environment, how to implement Group Policy, how to perform backup and restore, and how to monitor and troubleshoot Active Directory–related issues with Windows Server 2016. Additionally, this course teaches how...

AutoCAD is one of our most popular series classes. A green flag beside a date on the right means that a session has met the minimum enrollment levels and is running. However, it is common for dates for this course to fill several weeks in advance. Even if a date has a green flag, you might not be able to get into that session if it is full. Plan ahead!...

Until now, you have used Crystal Reports 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, you will create complex reports and data sources using the tools in Crystal Reports. You will not only create more sophisticated reports including subreports...