Intermediate Power BI, Data Modeling and DAX - Virtual 2 Day

Iteration Insights

Level up from a beginner to a power user with our instructor-led Power BI Intermediate training course.

Take your Power BI Skills to the next level! This online instructor-led course is perfect for those who have been using Power BI for 3-6 months. In this course, we will expand upon basic Power BI concepts such as transforming and cleansing data using Power Query Editor, writing basic DAX expressions and publishing dashboard visualizations to end-users.In this course, we will guide you through:<ul><li>Learning and discussing the basics of Dimensional Modelling and its importance to Power BI</li><li>Designing several Dimensional Models and populate them from some of the most common sources</li><li>Elevating your Power Query skills by going beyond simple use cases </li><li>Moving beyond DAX Fundamentals and learning how to enhance your data model using expressions from more complex DAX techniques.</li></ul>This course is for Business Analysts, IT Users, and others that are interested in learning how to elevate their data analytics techniques using Power BI. We will teach how to develop efficient data analytics and further utilize visualizations in your organization.For more course information and details, visit the <a href="http://bit.ly/IntermediateFastTrack" target="_blank" data-msys-clicktrack="0" rel="nofollow noopener noreferrer">Iteration Insights website</a>.About the InstructorsChris Sorensen, MCSE (Data Management and Analytics) and MCT, is the Founder and President of Iteration Insights based in Calgary, Alberta. He is a consultant, architect, educator, author, and coach that has been working in the Analytics space for nearly 20 years. Over his career, he has provided strategic and architectural advisory services to many clients. Most recently, Chris has lead several projects in Microsoft Power BI and Excel PowerPivot. He has evangelized both Excel and Power BI with Microsoft since July 2015 and is the author of the <a href="http://bit.ly/2PoCGuT" target="_blank" data-msys-clicktrack="0" rel="nofollow noopener noreferrer">Microsoft Press Exam Ref 70-779 Analyzing and Visualizing Data with Microsoft Excel</a>.Jarid McKenzie, BSc. In Mathematics and Statistics and certified in Business Intelligence by the University of Calgary, is co-owner and Lead Analytics Architect for Iteration Insights.Jarid has 8 years of experience working in the digital space, including teaching data analytics at the University of Calgary and SAIT. Currently, he is on the advisory board for the Business Intelligence Program at SAIT and is a mentor to many graduates from the course.As a community leader for the Power Platform and Azure Analytics User Groups in Calgary, Jarid loves to share his knowledge with the community speaking at major data analytics events, such as the <a href="https://www.powerplatformworldtour.com/locations/calgary" target="_blank" data-msys-clicktrack="0" rel="nofollow noopener noreferrer">Power Platform World Tour</a> held in Calgary last year.Duration<ul><li>This course runs from 8:30 am to 4:00 pm MDT on both days.</li></ul>Pricing<ul><li>Early Bird Savings of $124/seat ends Nov 2, 2020, at 11:30 pm.</li><li>Groups of 3 or more receive a discount of 20% of the currently available ticket price. Please contact for discount code.</li></ul>Job Grant EligibilityCombine this course with our <a href="https://www.eventbrite.ca/e/hands-down-the-best-introduction-to-power-bi-and-dax-virtual-2-day-tickets-114191975272">Introduction to Power BI and DAX</a> course and qualify for job grants. Your employer must apply for the job grant before purchasing the course. Visit the links below for more details on how to apply.<ul><li><a href="https://www.alberta.ca/canada-alberta-job-grant.aspx" target="_blank" data-msys-clicktrack="0" rel="nofollow noopener noreferrer">Canada-Alberta Job Grant</a></li><li><a href="https://www.saskatchewan.ca/business/hire-train-and-manage-employees/apply-for-the-canada-saskatchewan-job-grant" target="_blank" data-msys-clicktrack="0" rel="nofollow noopener noreferrer">Canada-Saskatchewan Job Grant</a></li><li><a href="https://www.workbc.ca/Employer-Resources/BC-Employer-Training-Grant.aspx" target="_blank" data-msys-clicktrack="0" rel="nofollow noopener noreferrer">B.C. Employer Training Grant</a></li></ul>Course outlineData Modelling for Power BI<ul><li>What is Dimensional Modelling, and why do we need it?</li><li>Dimensional Modelling Basics</li><li>Managing the Power BI data model</li></ul>Power Query for Power BI<ul><li>Power Query review</li><li>How to use Power Query in more sophisticated ways</li><li>Dive into M</li><li>Populate your dimensional models using Power Query</li><li>Error Handling in Power BI</li></ul>Intermediate DAX<ul><li>Date tables and the importance of managing your own</li><li>Filter context walk-through</li><li>Filter arguments</li><li>Deeper dive into Time Intelligence Functions</li><li>Fiscal period offsets</li><li>Currency conversions</li><li>More complex hierarchies – Parent-Child hierarchies</li><li>Dealing with multiple relationships</li><li>Understanding many-to-many relationships</li></ul>Key WordsPower BI, Power Query, Data Modelling, Data Visualizations, Calgary, Edmonton, Regina, Saskatoon, Vancouver, Montreal, TorontoDisclaimerFilming and Photography may take place; please read our <a href="https://iterationinsights.com/notice-of-filming-and-photography/" target="_blank" data-msys-clicktrack="0" rel="nofollow noopener noreferrer">Notice for Filming and Photography</a> for further information.

Our {communityGuidelinesLink} describe the sort of content we prohibit on Eventbrite. If you suspect an event may be in violation, you can report it to us so we can investigate.

To report other categories of prohibited or illegal content, submit {link}

Intermediate Power BI, Data Modeling and DAX - Virtual 2 Day

More events from Iteration Insights

Discover more events from Iteration Insights, from Business to other experiences you might love.

Still looking for the right event?

Explore all online events to browse and filter by date, category, and more.

Intermediate Power BI, Data Modeling and DAX - Virtual 2 Day

More events from Iteration Insights

Discover more events from Iteration Insights, from Business to other experiences you might love.

More Business events

Browse more Business events with different dates, prices, and formats to find your next great experience.

Still looking for the right event?

Explore all online events to browse and filter by date, category, and more.