How to pull your data in from many sources and manke dynamic dashboards using PowerQuery and PowerBI
In today's busy world, we are all presented with overwhelming amounts of data, and we are given the task of making sense of that data. It can be a very time-consuming task to pull all of this data together and somehow make sense of this large amount of data.
Microsoft has come up with 2 great tools, PowerQuery and PowerBI, which can help you gather your data, and report on it in many ways.
This course will show you how to gather and manipulate your data using PowerQuery, and then how to make the data visually appealing and dynamic with PowerBI. PowerQuery is really built into the desktop version of PowerBI.
Topics covered: Downloading PowerBI Tour of screen
Importing data from:
Excel
Normal data
Formatted data
Text
Access
SQL Server
Web
Building and managing different visuals Adding and managing Slicers Add columns Delete column Merge columns Split columns Date fields Number fields Text fields Conditional columns
Quick measure: Filters Running Total Year to Year Change
Microsoft Certified Trainer with over 25 Years of Training Experience, and over 40 years in IT overall
Tom Fragale is a computer professional with over 40 years of professional experience. He is a Microsoft Certified Trainer, a Microsoft Certified Office Master, and a Microsoft Certified Expert in Word and Excel, and a Microsoft Certified Specialist in Access, Outlook, and PowerPoint. He has trained over 50,000 business people in online webinars, public seminars, and on-site training. His clients include many Fortune 500 companies, government agencies, military bases, and companies large and small across many industries, including insurance, manufacturing, banking, pharmaceutical, education, retail, etc. He started his career as a database application programmer and has served as a consultant on many successful projects. His topics of expertise include: Access, Excel, Word, PowerPoint, Outlook, Copilot, ChatGPT, Crystal Reports, SQL Server, Visio, QuickBooks, and SharePoint, among others. His passion is helping people get the most out of their computers, and he is a published author having written a book on Microsoft Access, and another on Excel Pivot Tables. He graduated in 1988 from LaSalle University in Philadelphia, PA with a B.A. in Computer Science.
This portal is provided as a training and development resource for City of Markham employees. Every course is delivered by a qualified subject matter expert or learning organization, is quantifiable in hours, and is verifiable — you receive a documented certificate of completion for every course you finish, stored on LearnFormula indefinitely.
If you hold a professional designation (for example in engineering, accounting, human resources, or law), courses may be counted as professionally relevant, verifiable learning activities toward your continuing professional development. Individual practitioners are responsible for confirming that an activity meets the requirements of their professional body. For questions about the City of Markham's training and development policies, please speak with your people leader or Human Resources.
