Intermediate Power BI Course
Overview:
Elevate your Power BI expertise with our intermediate course! Designed for existing users, this course expands upon basic concepts to provide personalised dashboards and data models. By mastering more advanced techniques, you'll be able to create interactive reports and visualisations that allow users to explore data and make informed decisions. Join us to take your Power BI skills to the next level!
By the end of this course, you will be able to:
· Build more complex data models using relationships and hierarchies.
· Use DAX formulas to perform advanced calculations and create custom measures and columns.
· Combine data from multiple sources using query editing and transformation tools.
· Create advanced visualisations such as custom visuals, charts, and maps.
· Design interactive reports and dashboards that allow users to drill down and explore data.
· Use Power BI in conjunction with other Microsoft tools like Excel and SharePoint.
· Implement best practices for data modelling, data visualisation, and report design.
· Understand how to optimise the performance of your Power BI reports.
· Collaborate with other users and share your reports using Power BI's sharing and publishing features.
· Gain a deeper understanding of Power BI's architecture, security features, and administration capabilities.
1-day Course:
What you'll learn:
· The Query Editor window in Excel and Power BI Desktop
· Applied Steps
· Shaping Data
· Formatting Data
· Transforming Data
· Combining Data
· Merging Data
· Calculated Columns
· Time Intelligence Measures
· Measures (Calc Fields) vs. Calc Columns
· COUNTROWS(), DISTINTCOUNT(), DIVIDE()
· Creating Variables within measures & using Return / return if
· FILTER() function
· Using SUMX and CALCULATE
· What-if Analysis using Disconnected Tables and Slicers
· Conditional Formatting (text & numbers)
· Understanding and controlling interactions between visualisations
· Using Drill Down and Drill Through on visualisations
· Using Focus Mode and Spotlight
· Viewing underlying data and hierarchies
· Using Slicers
· Key influencers / decomposition tree analytics tools
· Using bookmarks
· Importing custom visualisations
· Create a custom theme(.json file)
· Adding & Optimising Tool Tips
· Visual Alignment Tips
· Custom Page Sizing
· Using Logos & Custom Icons
· Formatting Tips & Tricks
· Publish your Report to Power BI Service
· Creating Dashboards
· Pinning Visualizations to a Dashboard
· Using Quick Insights
2-day Course:
What you'll learn:
· Connecting to Access Databases
· Connecting to a Folder of Data
· Other Data sources
· Refresh Data
· Cardinality
· Cross Filter Direction
· Data Tables vs. Lookup Tables
· The Vertipaq engine explained
· FILTER() function
· Evaluation Contexts and Context Transition
· Using SUMX and CALCULATE
· What-if Analysis using Disconnected Tables and Slicers
· Counting things that didn’t happen (eg customers that haven’t purchased)
· Date Table Rules
· Setting the Date Table
· Automatic Date Table
· Create Date/Calendar Tables
· Running totals – Year to Date, Month to Date, Quarter to Date
· Comparing historical periodical data using Sales data focussing on trends & forecasts
· Conditional Formatting (text & numbers)
· Understanding and controlling interactions between visualisations
· Using Drill Down and Drill Through on visualisations
· Using Focus Mode and Spotlight
· Viewing underlying data and hierarchies
· Using Slicers
· Key influencers / decomposition tree analytics tools
· Using bookmarks
· Importing custom visualisations
· Create a custom theme(.json file)
· Adding & Optimising Tool Tips
· Visual Alignment Tips
· Custom Page Sizing
· Using Logos & Custom Icons
· Formatting Tips & Tricks
· Publish your Report to Power BI Service
· Creating Dashboards
· Pinning Visualizations to a Dashboard
· Using Quick Insights
· Using Q & A for interactive data searching
· Viewing and Managing Power BI Content from the service
· Viewing a Workspace
· Managing Dashboards
Who should attend?
Our Power BI Courses are suitable for Business Analysts and other professionals who want to create visual representations of data and produce user-friendly reports and dashboards using data from Excel or databases. This intermediate course is suitable for those who have a basic understanding of Power BI and want to expand their knowledge or those who have completed the introductory Power BI course.
