{"product_id":"k2s-accessing-your-companys-data-with-power-query-and-power-bi-25c01236","title":"K2's Accessing Your Company's Data With Power Query And Power BI","description":"\n\u003ch3\u003e\u003cstrong\u003e\u003cspan\u003eCourse Description\u003c\/span\u003e\u003c\/strong\u003e\u003c\/h3\u003e\n\u003cp\u003ePower Query and Power BI are genuinely incredible tools to revolutionize your workflow. They offer the promise of \"write once, refresh many\" reporting, where your reports can instantly update by clicking a button. While incredible tools, these features require additional training and experience to master. This course series will review the different methods of connecting to your data and have multiple hands-on activities to help you master these incredible tools. After completing this session, you will know how to turn your organization's data into repeatable, refreshable PivotTables, Power BI dashboards, and more!\u003c\/p\u003e\n\n\u003ch3\u003e\u003cstrong\u003e\u003cspan\u003eMajor Topics\u003c\/span\u003e\u003c\/strong\u003e\u003c\/h3\u003e\n\u003cul\u003e\n\u003cli\u003e\u003cspan\u003eUtilizing Power Query to access data from the web, spreadsheets, folders, and databases\u003c\/span\u003e\u003c\/li\u003e\n\u003cli\u003e\u003cspan\u003eUsing Power Query to perform various transformations to clean up data before importing it to Power BI or Excel\u003c\/span\u003e\u003c\/li\u003e\n\u003cli\u003e\u003cspan\u003eProducing various reporting documents from data delivered from Power Query\u003c\/span\u003e\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003e\u003cspan\u003eLearning Objectives\u003c\/span\u003e\u003c\/h3\u003e\n\u003cp\u003eUpon completing this course, you should be able to:\u003c\/p\u003e\n\u003cul\u003e\n\u003cli\u003eOutline Power Query's noteworthy features and functions and how you can use them for reporting projects\u003c\/li\u003e\n\u003cli\u003eDemonstrate how to connect Power Query to web resources, spreadsheets, and databases to extract, transform, and load data into your reports\u003c\/li\u003e\n\u003cli\u003eList the various methods to transform your data using Power Query before importing it into a report.\u003c\/li\u003e\n\u003cli\u003eDemonstrate connecting Power Query and Power BI to a sample data server\u003c\/li\u003e\n\u003c\/ul\u003e\n\n\u003ch3\u003e\u003cspan\u003eCourse Information\u003c\/span\u003e\u003c\/h3\u003e\n\u003cul\u003e\n\u003cli\u003e\n\u003cstrong\u003eCPD Credit:\u003c\/strong\u003e 2.0 hours Computer Software and Applications\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003ePrerequisites:\u003c\/strong\u003e Fundamental knowledge of Excel\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eProgram Level:\u003c\/strong\u003e Intermediate\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eAdvance Preparation:\u003c\/strong\u003e None\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eWho Should Participate:\u003c\/strong\u003e Financial professionals who want to save time, improve accuracy, and promote efficiency with their reporting projects\u003c\/li\u003e\n\u003c\/ul\u003e\n\u003ch3\u003e\u003cstrong\u003eInstructor\u003c\/strong\u003e\u003c\/h3\u003e\n\u003cul\u003e\n\u003cli\u003e\n\u003cstrong\u003eName:\u003c\/strong\u003e Stephen Yoss\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eHometown:\u003c\/strong\u003e Big Bear Lake, CA\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eBio:\u003c\/strong\u003e Stephen M. Yoss, Jr., CPA, MS, is a certified public accountant, partner and CEO of Devmatics, LLC, a continuing education instructor for financial professionals, a and a licensed pyrotechnician. While his interests and skills are varied, they all share a common thread?his love for and skill in finding technology-based solutions. In 2017, Stephen and Alex White formed Devmatics, LLC, a company focused on helping organizations develop technology strategies to streamline their business operations. He specializes in taking on high-difficulty, mission-critical organizational issues that require technological expertise and an ability to find solutions to problems that no one else can answer. With all of his clients, he emphasizes the need to embrace technology at every opportunity and utilize the latest technological trends and breakthroughs in order to gain a competitive advantage while increasing efficiency and productivity.\u003c\/li\u003e\n\u003c\/ul\u003e","brand":"K2 Enterprises","offers":[{"title":"Default Title","offer_id":42698594418786,"sku":"25c01236","price":99.0,"currency_code":"CAD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0022\/3726\/8025\/files\/default_808fa14f-51fc-4cac-8f8a-d0183358f310.png?v=1775510400","url":"https:\/\/www.k2e.ca\/products\/k2s-accessing-your-companys-data-with-power-query-and-power-bi-25c01236","provider":"K2E Canada","version":"1.0","type":"link"}