BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//Computer Training Source - ECPv6.16.4//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:20220201T083000
DTEND;TZID=UTC:20220203T160000
DTSTAMP:20260619T171239
CREATED:20201216T024841Z
LAST-MODIFIED:20211104T175837Z
UID:3496-1643704200-1643904000@computertrainingsource.com
SUMMARY:Microsoft Power BI: Level 2 (3-Day Class)
DESCRIPTION:Microsoft Power BI: Data Analysis Professional \nCourse Number: \n095212 \nCourse Length: \n3 days \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. \n  \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\nAnalyze data with self-service BI.\nConnect to data sources.\nPerform data cleaning\, profiling\, and shaping.\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.\nPublish and share reports and dashboards.\nExtend Power BI beyond the desktop.\n\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. \n  \nThis course is also designed for professionals who want to pursue the Microsoft certification Exam DA-100: Analyzing Data with Microsoft Power BI. \nPrerequisites: \nTo ensure your success in this course you should have experience managing data with a spreadsheet program such as Microsoft® Excel®\, which you could obtain by taking the following Logical Operations courses. \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\n\n  \nCourse Content \nLesson 1: Analyzing Data with Self-Service BI \nTopic A: Data Analysis and Visualization for Business Intelligence \nTopic B: Self-Service BI with Microsoft Power BI \n  \nLesson 2: Connecting to Data Sources \nTopic A: Create Data Connections \nTopic B: Configure and Manage Data Relationships \nTopic C: Save Files in Power BI \n  \nLesson 3: Performing Data Cleaning\, Profiling\, and Shaping \nTopic A: Clean\, Transform\, and Load Data with the Query Editor \nTopic B: Profile Data with the Query Editor \nTopic C: Shape Data with the Query Editor \nTopic D: Combine and Manage Data Rows \n  \nLesson 4: Visualizing Data with Power BI \nTopic A: Create Visualizations in Power BI \nTopic B: Chart Data in Power BI \n  \nLesson 5: Enhancing Data Analysis \nTopic A: Customize Visuals and Pages \nTopic B: Incorporate Tooltips \n  \nLesson 6: Modeling Data with Calculations \nTopic A: Create Calculations with Data Analysis Expressions (DAX) \nTopic B: Create Calculated Measures and Conditional Columns \n  \nLesson 7: Creating Interactive Visualizations \nTopic A: Create and Manage Data Hierarchies \nTopic B: Filter and Slice Reports \nTopic C: Create Dashboards \n  \nLesson 8: 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 9: Enhancing Reports and Dashboards \nTopic A: Enhance Reports \nTopic B: Enhance Dashboards \n  \nLesson 10: Publishing and Sharing Reports and Dashboards \nTopic A: Publish Reports \nTopic B: Create and Manage Workspaces \nTopic C: Share Reports and Dashboards \n  \nLesson 11: Extending Power BI Beyond the Desktop \nTopic A: Use Power BI Mobile \nTopic B: Extend Access with the Power BI API \n  \nAppendix A: Mapping Course Content to Exam DA-100: Analyzing Data with Microsoft Power BI Certification Objectives \n 
URL:https://computertrainingsource.com/event/microsoft-o365-project-2-2-2-2-3-4-2-2-2/
LOCATION:CA\, United States
ORGANIZER;CN="Jim Rose":MAILTO:Jrose@ComputerTrainingSource.com
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=UTC:20220217T083000
DTEND;TZID=UTC:20220217T160000
DTSTAMP:20260619T171239
CREATED:20201216T033447Z
LAST-MODIFIED:20220119T220355Z
UID:3628-1645086600-1645113600@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/
LOCATION:CA\, United States
ORGANIZER;CN="Jim Rose":MAILTO:Jrose@ComputerTrainingSource.com
END:VEVENT
END:VCALENDAR