Unlocking Your Data Potential with Power Query
Are you ready to supercharge your data analysis skills and take your career to the next level? Look no further than the ‘Power Pivot & Power Query’ course, where we dive deep into the dynamic world of Power Query.
Unleash the Power of Data Transformation
In today’s data-driven business landscape, harnessing the full potential of your data is paramount. Power Query is your gateway to this transformation. In this course, you will learn how to seamlessly extract, transform, and load data from a variety of sources. From databases to Excel files, you’ll gain the skills to effortlessly prepare data for analysis, creating a solid foundation for decision-making.
Empower Your Career
Imagine the doors that will open for you with these invaluable skills. For sales executives, business analysts, project managers, and more, mastering Power Query can be a game-changer. Whether you’re looking to streamline your workflow, enhance your analytical capabilities, or simply stay ahead in the corporate world, this course is your ticket to success.
Don’t miss out on this opportunity to become a data wizard. Join us and become the go-to data expert in your organization, armed with the transformative power of Power Query.
Course Details
Course Code: -; Duration: 2 Days; Instructor-led
Overview
Microsoft Power BI will help you analyze your organization’s data and uncover insights and trends in more advanced. This course will show you how to create more interactive visual reports that reveal data insights including calculation.
When to Use
- The purposes and basic functions of the core Power BI components
- Using the Power BI desktop client
- Connecting to multiple data source
- Modelling data
- Creating reports and visualizations
Audience
- Sales Executive / Managers
- Business Analysist
- Resource Planning Team
- Project Managers
- Purchasing Manager
- Financial Executive / Managers
Prerequisites
User has an intermediate knowledge of Microsoft Power BI Desktop
Methodology
This program will be conducted with interactive lectures, PowerPoint presentation, discussion, and practical exercise.
Outlines
Module 1: Getting Data
- Connecting to an Excel Workbook from SharePoint
- Connecting to Web Data
- Connecting to a SQL Database
Module 2: Working with Advanced Visualizations
- TOPIC A: Creating Data Visualizations
- Creating Combo Chart (Line & Column)
- Adding Data
- Format Visual
- Creating Waterfall Chart
- Adding Data
- Format Visual
- Creating Scatter Chart
- Adding Data
- Format Visual
- Apply clustering techniques
- Time series Analysis
- Get More Visual
- Import Visual
Module 3: Adding interaction to visuals and reports
- TOPIC A: Adding Elements
- Sync slicer
- Adding Bookmark
- Adding Button
- Adding Navigator
- TOPIC B: Drill Through
- Adding Drill Through
- Setting up Report page for Drill Through
- Sync slicer
Module 4: Analytics in visuals
- TOPIC A: Adding Analytics
- Adding Average Line
- Adding Constant Line (Target
- TOPIC B: Adding Analytics
- Create a Group
- Edit a Group
- Create bin groups
Module 6: Publish Report to Workspace
- TOPIC A: Parameter
- Numeric Range
- Fields
- TOPIC B: Adding Quick Measure
- Time Intelligence
- Filter
- Total
Module 6: Publish Report to Workspace
- TOPIC A: Publish Report
- Publish a Report a my Workspace
- Publish Report a dedicated Workspace
- Manage Workspace
- TOPIC B: Auto Refresh
- Use Gateway to set Schedule Refresh
- Use Cloud Connection
Module 7: Managing User Permission with RLS
- TOPIC A: Manage Security Roles
- Add a Role
- Manage Roles
- View As
