Power BI Sales Pipeline Analytics & Visualization
What you'll learn
- Intermediate and advanced data modelling and DAX techniques
Requirements
- Knowledge of the basics of Power BI Desktop
Description
Want to extend your knowledge of Microsoft Power BI? Power BI Sales Pipeline Analytics and Visualization by G Com Solutions is a practical hands-on course, designed to give experienced Power BI users further practice on data modelling, DAX, visualization and report creation.
The course begins with data preparation using Power Query. We connect to our data, perform basic transformations and import an External Date Table which we then map to the dates in our main fact table.
We then set up relationships between our various tables. However, since we are dealing with a sales pipeline, we have a main fact table which contains multiple significant dates, as we track the progress of each lead from the contact stage, right through to sales.
This course will show you how to establish multiple relationships between the same two tables and then use DAX to activate the appropriate relationship as you perform calculations.
And the course provides plenty of additional practice in creating DAX measures.
Then we turn our attention to visualizing our data. We look at using the funnel visual, as well as displaying a hierarchy of images in slicers which enable the user to track the performance of sales managers as well as individual salespeople.
We also look at a useful technique for creating a chart which only becomes visible when a slicer selection is made by the user.
In short, this course will provide Power BI users who are familiar with the basics, with a challenging, hands-on workshop which will expand their familiarity with data modelling, visualization and report creation.
Who this course is for:
- Existing users of Power BI looking to extend their knowledge
Course content
- Preview01:44
- Preview00:02
- 00:033. Download the Course Files Here
Instructor
Grant Gamble is an experienced IT trainer, developer, consultant and author able to deliver a wide range of training courses. He has a vast experience of delivering public and on-site IT training content at different skill levels, to groups of varying sizes.
His UK company G Com Solutions Limited provide IT training courses and consultancy to a wide range of UK and international clients. His speciality is running week-long, intensive training workshops on topics like Microsoft Power BI, VBA, web development and Adobe Creative Suite automation.