Skip to content

6 Results

  • Power BI : Advanced Power BI

    This is the third and final of the three courses that make up the Power BI Certificate Program. Expand your knowledge of Power BI Desktop to the highest level. This course focuses on the advanced capabilities of Power Query, Data Modeling and Reports. Check for data inconsistencies, design efficient queries, create proper relationships, and write DAX code to ensure reports update quickly and accurately. Add navigation and analytical features to your reports to enable consumers to analyze the results. This class can be taken individually, or together with the other two classes for the certificate. If you pay for all three classes at once, there is a total of a $90.00 discount at checkout. The other classes in this program are: Introduction to Power BI and Intermediate Power BI To progress through this course you will: Read the print readings. Have the option of accessing the online readings. Listen to the audio presentation for the Unit and view the slides. Have the option of taking a self-quiz to see how much you have learned. Engage in written online discussion with your instructor and other participants. The content (readings, audio lectures, slides) and self quizzes are accessible for the entire course, so you can work ahead, or go back and review again, at your convenience. Discussion: The discussion for each unit lasts one week. All comments are made in writing and can be made at any time of the day or night. Your instructor will log into the discussion area at least once a day and answer questions, make comments, and respond to comments by you and the other participants. We encourage you to make 2-3 comments each day to maximize your learning and enjoyment of the course.
  • Power BI : Intermediate Power BI

    This is the second of the three courses that make up the Power BI Certificate Program. Delve further into Power Query to ETL (Extract, Transform and Load) your data. Build the Data Model using modeling features and relationships. Perform calculations using DAX (Data Analysis Expressions) functions. Utilize Time Intelligence functions to view YoY or YTD reports. Add user friendly features to enhance your reports. This class can be taken individually, or together with the other two classes for the certificate. If you pay for all three classes at once, there is a total of a $90.00 discount at checkout. The other classes in this program are: Introduction to Power BI and Advanced Power BI To progress through this course you will: Read the print readings. Have the option of reading the online readings. Listen to the audio presentation for the Unit and view the slides. Have the option of taking a self-quiz to see how much you have learned. Engage in written online discussion with your instructor and other participants. The content (readings, audio lectures, slides) and self quizzes are accessible for the entire course, so you can work ahead, or go back and review again, at your convenience. Discussion: The discussion for each unit lasts one week. All comments are made in writing and can be made at any time of the day or night. Your instructor will log into the discussion area at least once a day and answer questions, make comments, and respond to comments by you and the other participants. We encourage you to make 2-3 comments each day to maximize your learning and enjoyment of the course.
  • Power BI : Introduction to Power BI

    This is the first of the three courses that make up the Power BI Certificate Program. Gain insights into your data! Power BI (business intelligence) is a widely used business analytics service offered by Microsoft. Power BI Desktop is a complete data analysis and report creation tool that you install for free. In this course, you will discover how to quickly extract, transform, and load data with just a few clicks. You will create interactive visualizations (charts, maps, KPIs) to provide you with insights into your company’s data to make informed decisions. This class can be taken individually, or together with the other two classes for the certificate. If you pay for all three classes at once, there is a total of a $90.00 discount at checkout. The other classes in this program are: Intermediate Power BI and Advanced Power BI To progress through this course you will: Read the print readings. Have the option of reading the online readings. Listen to the audio presentation for the Unit and view the slides. Have the option of taking a self-quiz to see how much you have learned. Engage in written online discussion with your instructor and other participants. The content (readings, audio lectures, slides) and self quizzes are accessible for the entire course, so you can work ahead, or go back and review again, at your convenience. Discussion: The discussion for each unit lasts one week. All comments are made in writing and can be made at any time of the day or night. Your instructor will log into the discussion area at least once a day and answer questions, make comments, and respond to comments by you and the other participants. We encourage you to make 2-3 comments each day to maximize your learning and enjoyment of the course.
  • Structured Query Language (SQL) : Advanced SQL

    This is the third and final of the three classes that make up the SQL Certificate Program. Take your SQL query skills to a new level by learning how to write more advanced SQL queries for enhanced decision making. In this course, you will learn how to write advanced subqueries, advanced join queries, and UNION queries that query more than one table. You will learn how to use transaction processing to ensure SQL statements execute completely or not at all and how to create stored procedures that enable you to store SQL statements for execution. Students should have a competency in the Introductory and Intermediate levels of SQL. Requirements: - Windows 10 or later. Macs are not compatible. - Necessary rights (local administrative rights) to install programs on the computer. This class can be taken individually, or together with the other two classes for the certificate. If you pay for all three classes at once, there is a total of a $90.00 discount at checkout. The other classes in this program are: Introduction to SQL and Intermediate SQL - Please be careful to choose the courses so they don't overlap since we offer the each course at varying times. To progress through this course you will: Read the print readings. Have the option of accessing the online readings. Listen to the audio presentation for the Unit and view the slides. Have the option of taking a self-quiz to see how much you have learned. Engage in written online discussion with your instructor and other participants. The content (readings, audio lectures, slides) and self quizzes are accessible for the entire course, so you can work ahead, or go back and review again, at your convenience. Discussion: The discussion for each unit lasts one week. All comments are made in writing and can be made at any time of the day or night. Your instructor will log into the discussion area at least once a day and answer questions, make comments, and respond to comments by you and the other participants. We encourage you to make 2-3 comments each day to maximize your learning and enjoyment of the course.
  • Structured Query Language (SQL): Intermediate SQL

    This is the second of the three courses that make up the SQL Certificate Program. Discover how to write powerful SQL queries that enable you to retrieve data from one table or from multiple tables stored in the database simultaneously. In this course, you will learn how to retrieve more meaningful data from one or more tables stored in a database. You will learn how to merge data from multiple columns, how to create calculated fields, and how to order and group the results from a query. You will also learn how to create a single join query or subquery to obtain data from multiple tables simultaneously. Students should have a competency in the Introductory level of SQL. Requirements: - Windows 10 or later. Macs are not compatible. - Necessary rights (local administrative rights) to install programs on the computer. This class can be taken individually, or together with the other two classes for the certificate. If you pay for all three classes at once, there is a total of a $90.00 discount at checkout. The other classes in this program are: Introduction to SQL and Advanced SQL - Please let us know if you are interested in other start dates for this series of classes. To progress through this course you will: Read the print readings. Have the option of reading the online readings. Listen to the audio presentation for the Unit and view the slides. Have the option of taking a self-quiz to see how much you have learned. Engage in written online discussion with your instructor and other participants. The content (readings, audio lectures, slides) and self quizzes are accessible for the entire course, so you can work ahead, or go back and review again, at your convenience. Discussion: The discussion for each unit lasts one week. All comments are made in writing and can be made at any time of the day or night. Your instructor will log into the discussion area at least once a day and answer questions, make comments, and respond to comments by you and the other participants. We encourage you to make 2-3 comments each day to maximize your learning and enjoyment of the course.
  • Structured Query Language (SQL): Introduction to SQL

    This is the first of the three courses that make up the SQL Certificate Program. Learn how to write SQL code to create and populate database tables and how to write simple SQL queries that are capable of retrieving vast amounts of information from a database. In this course, you will discover the power of the relational database, how to create and manage database tables, and how to use SQL SELECT statements to precisely pinpoint and retrieve data from a database. Requirements: - Windows 10 or later. Macs are not compatible. - Necessary rights (local administrative rights) to install programs on the computer. This class can be taken individually, or together with the other two classes for the certificate. If you pay for all three classes at once, there is a total of a $90.00 discount at checkout. The other classes in this program are: Intermediate SQL and Advanced SQL - Please let us know if you are interested in other start dates for this series of classes. To progress through this course you will: Read the print readings. Have the option of reading the online readings. Listen to the audio presentation for the Unit and view the slides. Have the option of taking a self-quiz to see how much you have learned. Engage in written online discussion with your instructor and other participants. The content (readings, audio lectures, slides) and self quizzes are accessible for the entire course, so you can work ahead, or go back and review again, at your convenience. Discussion: The discussion for each unit lasts one week. All comments are made in writing and can be made at any time of the day or night. Your instructor will log into the discussion area at least once a day and answer questions, make comments, and respond to comments by you and the other participants. We encourage you to make 2-3 comments each day to maximize your learning and enjoyment of the course.