BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//Computer Training Source - ECPv6.17.1//NONSGML v1.0//EN
CALSCALE:GREGORIAN
METHOD:PUBLISH
X-WR-CALNAME:Computer Training Source
X-ORIGINAL-URL:https://computertrainingsource.com
X-WR-CALDESC:Events for Computer Training Source
REFRESH-INTERVAL;VALUE=DURATION:PT1H
X-Robots-Tag:noindex
X-PUBLISHED-TTL:PT1H
BEGIN:VTIMEZONE
TZID:UTC
BEGIN:STANDARD
TZOFFSETFROM:+0000
TZOFFSETTO:+0000
TZNAME:UTC
DTSTART:20210101T000000
END:STANDARD
END:VTIMEZONE
BEGIN:VEVENT
DTSTART;TZID=UTC:20220831T083000
DTEND;TZID=UTC:20220831T160000
DTSTAMP:20220711T230814Z
CREATED:20201216T024841Z
LAST-MODIFIED:20220711T230814Z
UID:4036-1661934600-1661961600@computertrainingsource.com
SUMMARY:Power BI: Level 2
DESCRIPTION:Microsoft Power BI: Level 2\nCourse Number: 095212 \nCourse Length: 1 day \n  \nOverview: \nAs technology progresses and becomes more interwoven with our businesses and lives\, more data is collected about business and personal activities. This era of “big data” is a direct result of the popularity and growth of cloud computing\, which provides an abundance of computational power and storage\, allowing organizations of all sorts to capture and store data. Leveraging that data effectively can provide timely insights and competitive advantages. \nCreating data-backed visualizations is key for data scientists\, or any professional\, 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 it enables users to quickly create visualizations of connected data to gain insights\, show trends\, and create reports. Power BI’s data connection capabilities and visualization features go far beyond those that can be found in spreadsheets\, enabling users to create compelling and interactive worksheets\, dashboards\, and stories that bring data to life and turn data into thoughtful action. \n  \nCourse Objectives: \nIn this course\, you will analyze data with Microsoft Power BI. You will: \n\nVisualize data with Power BI.\nEnhance data analysis by adding and customizing visual elements.\nModel data with calculations.\nCreate interactive visualizations.\nUse advanced analysis techniques.\nEnhance reports and dashboards.\n\nTarget Student: \nThis course is designed for professionals in a variety of job roles who are currently using desktop or web-based data management tools such as Microsoft Excel® or SQL Server® reporting services to perform numerical or general data analysis. They are responsible for connecting to cloud-based data sources\, as well as shaping and combining data for the purpose of analysis. They are also looking for alternative ways to analyze business data\, visualize insights\, and share those insights with peers across the enterprise. This includes capturing and reporting on data to peers\, executives\, and clients. \nThis course is also designed for professionals who want to pursue the Microsoft certification Exam DA-100: Analyzing Data with Microsoft Power BI. \nPrerequisites: \n\nMicrosoft® Excel® for Office 365™ (Desktop or Online): Part 1 or Microsoft® Office Excel® 2019: Part 1\nMicrosoft® Excel® for Office 365™ (Desktop or Online): Part 2 or Microsoft® Office Excel® 2019: Part 2\nPower B: Introduction\n\nCourse Content \nLesson 1: Visualizing Data with Power BI \nTopic A: Create Visualizations in Power BI \nTopic B: Chart Data in Power BI \n  \nLesson 2: Enhancing Data Analysis \nTopic A: Customize Visuals and Pages \nTopic B: Incorporate Tooltips \n  \nLesson 3: Modeling Data with Calculations \nTopic A: Create Calculations with Data Analysis Expressions (DAX) \nTopic B: Create Calculated Measures and Conditional Columns \n  \nLesson 4: Creating Interactive Visualizations \nTopic A: Create and Manage Data Hierarchies \nTopic B: Filter and Slice Reports \nTopic C: Create Dashboards \n  \nLesson 5: Using Advanced Analysis Techniques \nTopic A: Create Calculated Tables\, Variables\, and Parameters \nTopic B: Enhance Visuals with Statistical Analysis \nTopic C: Perform Advanced Analysis \n  \nLesson 6: Enhancing Reports and Dashboards \nTopic A: Enhance Reports \nTopic B: Enhance Dashboards \n  \n\n\n\nThis event ticket will close at 12:00 pm the day before the event.
URL:https://computertrainingsource.com/event/microsoft-o365-project-2-2-2-2-2-2-3-2-2-2-2-2-2/
LOCATION:CA\, United States
ORGANIZER;CN="Jim Rose":MAILTO:Jrose@ComputerTrainingSource.com
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=UTC:20220831T083000
DTEND;TZID=UTC:20220831T160000
DTSTAMP:20220711T214436Z
CREATED:20201216T033447Z
LAST-MODIFIED:20220711T214436Z
UID:4010-1661934600-1661961600@computertrainingsource.com
SUMMARY:Excel Power Pivot
DESCRIPTION:Excel Power Pivot\n$219 \nCourse Length: 1 day \nCourse Description  \nOverview: Advances in technology have made it possible to store ever-increasing amounts of data. Along with this\, the need to analyze 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 analyze\, 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 for success for everyone involved. \nCourse Objectives: Upon successful completion of this course\, you will be able to use Excel O365 advanced PivotTable functionality to analyze your raw data. \nYou will: \n\nPrepare data for PivotTable reporting and create PivotTables from various data sources.\nAnalyze data by using PivotTables.\nWork with PivotCharts.\n\nTarget Student: Students taking this course are experienced Excel users who are seeking to advance their data analysis capabilities by using PivotTables. \nPrerequisites: To ensure your success in this course\, you should have experience working with Excel O365 and PivotTables. You should already understand spreadsheet concepts and be comfortable creating basic PivotTables. You can obtain this level of skill and knowledge by taking the following Logical Operations courses: \n\nMicrosoft® Office Excel® O365: Part 1\nMicrosoft® Office Excel® O365: Part 2\n\n  \nCourse Content  \nLesson 1: Preparing Data and Creating PivotTables  \n\nTopic A: Prepare Data\nTopic B: Create a PivotTable from a Local Data Source\nTopic C: Create a PivotTable from Multiple Local Data Sources\nTopic D: Create a PivotTable from an External Data Source\n\nLesson 2: Analyzing Data by Using PivotTables  \n\nTopic A: Summarize PivotTable Data\nTopic B: Organize PivotTable Data\nTopic C: Filter PivotTable Data\nTopic D: Format a PivotTable\nTopic E: Refresh and Change PivotTable Data\n\nLesson 3: Working with PivotCharts  \n\nTopic A: Create a PivotChart\nTopic B: Manipulate PivotChart Data\nTopic C: Format a PivotChart
URL:https://computertrainingsource.com/event/excel-powerpivot-2-2-2-2-2-2-2-2-2-2/
LOCATION:CA\, United States
ORGANIZER;CN="Jim Rose":MAILTO:Jrose@ComputerTrainingSource.com
END:VEVENT
END:VCALENDAR