Data and Database Training Courses

OneSource provides Microsoft Training and Certifications both public courses and group trainings. Contact us today for information.

A course designed to teach end users how to use Microsoft Power BI, interactive dash boards, data visualization, and how to use Power BI engine to convert Excel and many other data sets into useful data. It will also show you how to use the Microsoft Excel Power Query Editor in conjunction with Power BI. You will learn how Excel can function like a Database.

Overview: This webinar describes exactly what is required for compliance with Part 11 and the European equivalent Annex 11 for local, SaaS/Cloud hosted applications. It explains how to write a Data Privacy Statement for compliance with EU General Data Protection Regulation (GDPR). What the regulations mean is described for all four primary compliance areas: SOPs, software features, infrastructure qualification, and validation. It gets you on the right track for using electronic records and signatures to greatly increase productivity and ensure compliance.

This boot camp teaches you how to make Microsoft Outlook a partner in your productivity initiatives by showing you features in Outlook and explaining the time management benefits. You’ll learn to organize your appointments, meetings, private work time, and project tasks, enabling you to take control of important work details and stay on top of coming deadlines. Anyone who is an avid user of Microsoft Outlook, regularly delegates, and has a leadership position will benefit from this boot camp. • Team leaders • Team members • Project managers • Engineers • Managers at all levels of the company • Executives • Sales professionals • Sales managers • Customer service personnel Use Promo Code MDTD20 and get flat 20% discount on all purchases. To Register (or) for more details please click on this below link: https://bit.ly/2RIdLVN Email: support@trainingdoyens.com Toll Free: +1-888-300-8494 Tel: +1-720-996-1616 Fax: +1-888-909-1882

As an intermediate to advanced level user of Excel, not only do you want to take your knowledge and skills to the next level, you want to produce meaningful, impactful and insightful reports in the shortest time possible. These features of the application will help you to do just that. WHO WILL BENEFIT This session is aimed at Excel users who have intermediate to advanced level knowledge and who wish to take their knowledge and understanding of the application to the next level. • Business Owners • CEO's / CFO's / CTO's • Managers • Accountants • CPA's • Financial Consultants • IT Professionals • Auditors • Human Resource Personnel • Bookkeepers • Marketers • Anybody with large amounts of Data • Anybody who uses Microsoft Excel on a regular basis, and wants to be more efficient and productive Use Promo Code SPRS20 and get flat 20% discount on all purchases. To Register (or) for more details please click on this below link: https://bit.ly/2UudkQx Email: support@trainingdoyens.com

Overview: FDA and EU regulations require that firms have a program for the calibration and maintenance of test and measurement equipment. The program must include: intervals, scheduling, specific procedures, limits of accuracy/precision, and remedial action in the event that the equipment does not meet established requirements. Prior to use, however, this equipment must be validated to make sure it produces product that meets its specifications. There are ways, though, to validate equipment already in use.

Overview: This webinar will address those project management critical tasks within each project phase that must be performed flawlessly for effective project execution to occur and will provide the foundation and direction for future study of the subject. Why should you Attend: It is not possible to present a complete treatment of project management in the span of 60-90 minutes. It is however possible to focus in on those most critical project management aspects that are critical to the success of any project. Without basic tools, it is not possible to effectively manage a project to the pre-determined end-date without turmoil and chaos.

Data integrity is the assurance that data records are accurate, complete, intact and maintained within their original context, including their relationship to other data records. This definition applies to data recorded in electronic and paper formats or a hybrid of both. To assure the quality of raw materials, in process materials and finished goods,laboratory data integrity is assuming greater importance in current Good Manufacturing Practices (CGMP) for US Food and Drug Administration (FDA)-regulated industry. Data integrity and security infractions are not only 21 Code of Federal Regulations (CFR) Part 11 issues but also severe CGMP violations.

This presentation will cover the FDA regulations (21 CFR Part 820.198) regarding complaint handling, how to best approach complaints (including initiation, investigation, evaluation, and follow-up verification), examples of documentation you can use to successfully document complaints, as well as tips and tricks to what FDA auditors will look for when they come to visit your site. We will also go over some additional tips and tricks on how to ensure all negative feedback is correctly categorized within your organization and are processed correctly.

Learn how to represent data visually using different excel charts and tools. Register to learn more. Price:$200.00. Contact info : OnlineCompliancePanel Phn. no. +1-510-857-5896 Fax-+1-510-509-9659 info@onlinecompliancepanel.com Event link - https://www.onlinecompliancepanel.com/webinar/Excel-Data-Visualization-Charts-and-Infographics-505910/JULY-2019-ES-TRAININGREGISTRY

Overview: This webinar describes exactly what is required for compliance with Part 11 and the European equivalent Annex 11 for local, SaaS/Cloud hosted applications. It explains how to write a Data Privacy Statement for compliance with EU General Data Protection Regulation (GDPR). What the regulations mean is described for all four primary compliance areas: SOPs, software features, infrastructure qualification, and validation. It gets you on the right track for using electronic records and signatures to greatly increase productivity and ensure compliance.

Overview In today's fast-paced, high-tech, competitive business environment, analytics, data visualization and Business Intelligence (BI) are the hot topics many firms and professional recruiters seek.

This webinar will provide you information on how to determine data breach risks and comply with GDPR mandates by implementing ISO/IEC 27001. Price:$200.00. Contact info : OnlineCompliancePanel Phn. no. +1-510-857-5896 Fax-+1-510-509-9659 info@onlinecompliancepanel.com Event link - https://www.onlinecompliancepanel.com/webinar/How-ISO-IEC-27001-Can-Help-Achieve-GDPR-Compliance-Reduce-Data-Breach-Risks-503784/MARCH-2019-ES-TRAININGREGISTRY

This session will help you understand how to use design control in the production of Medical devices while ensuring the quality and compliance. Price:$200.00. Contact info : OnlineCompliancePanel Phn. no. +1-510-857-5896 Fax-+1-510-509-9659 info@onlinecompliancepanel.com Event link - https://www.onlinecompliancepanel.com/webinar/Quality-by-Design-Essential-Techniques-for-Medical-Devices-509040/MARCH-2019-ES-TRAININGREGISTRY

This Transact-SQL programming course teaches students relational database fundamentals and SQL programming skills in the Microsoft SQL Server environment. Topics covered include relational database architecture, database design techniques, and simple and complex query skills. The course also covers Microsoft-specific T-SQL programming constructs, creation and use of stored procedures and user-defined functions, use of cursors and updateable views. This class is intended for analysts, developers, designers, administrators, and managers new to the SQL programming language. Upon completion, participants will understand SQL functions, join techniques, database objects and constraints, and will be able to write useful stored procedures and views as well as complex queries and updates. Comprehensive hands on exercises are integrated throughout to reinforce learning and develop real competency.

This course introduces Microsoft's SQL Server Reporting Services 2017 (SSRS) utility. All reports are developed utilizing SQL Server Data Tools (SSDT), however Report Designer is also introduced. Students will complete hands-on exercises creating a number of reports including table-based, cross tabular and forms based designs. Reports utilizing charts, gauges, KPIs, spark lines, data bars and tree maps will be built. Exercises will incorporate the use of report parameters and features such as drill down, interactive sorting, hyperlinks, book marks and report maps. The student will gain experience with the new Report Services Web portal, which enables publishing content other than paginated reports, such as Excel and Power BI. Students will also learn how to include KPIs (Key Performance Indicators) directly from a shared data set.

The focus of this course is to familiarize developers with the use of SQL Server Engine, SQL Server Integration Services (SSIS) and SQL Server Analysis Services (SSAS) to create and populate data warehouses through ETL processing and build Multidimensional and Tabular models to use and reporting data sources. Students will learn how to design and build data warehouses and marts using SQL Server Management Studio. In a series of exercises, students develop SSIS packages designed to maintain a data warehouse using the Data Flow control flow task. Also demonstrated are other control flow tasks that can interact with an NTFS file system, FTP server, execute Win32 processes, send emails, and run .NET scripts. Based on the populated data warehouse they have created, students will then learn how to develop both Multidimensional and Tabular SSAS models using the languages Multidimensional Expressions (MDX) and Data Analysis Expressions (DAX).

Overview: There are GMP requirements for information technology. For a drug to be produced in a GxP/GMP compliant manner, some specific information technology practices must be followed. Computer systems involved in the development, manufacture, and sale of regulated product must meet certain requirements. Data security is the high priority in any organization but especially in a regulated industry. Companies need to safeguard against every possible vulnerability across their entire infrastructure. In order to successfully safeguard data, data governance needs to be implemented.

Learn about the GDPR's impact on companies that do business with EU citizens and how third party relationships can be managed proactively to address new and emerging risks. Price:$200.00. Contact info : OnlineCompliancePanel Phn. no. +1-510-857-5896 Fax-+1-510-509-9659 info@onlinecompliancepanel.com Event link https://www.onlinecompliancepanel.com/webinar/How-to-Tackle-Vendor-Risk-Hazards-A-Risk-Based-Management-Approach-to-Third-Party-Data-Security-Risk-and-Compliance-505739/AUGUST-2018-ES-TRAININGREGISTRY

This webinar will begin by defining and discussing why the customer-supplier relationship is important and how you define those relationships. We look at the relationship structure as a process comprising a series of inputs and outputs which we define. How the relationship impacts customer satisfaction is paramount and critical to organizational success. To achieve total customer satisfaction, you must fully understand your customers' requirements for the inputs they expect to receive from you - how and when your output must be produced, configured and transferred in order to meet their needs. We discuss this process and how to best execute a successful relationship.