Objective
To empower professionals with advanced Data Analysis and Data Visualization skills for effective Decision Making in a dynamic environment by mastering Microsoft Power BI
Why you should attend this training?
Participants are going to get the following learning benefits by attending this training course.
- Develop a detailed understanding of Data Analytics with Power BI.
- Connecting data from multiple data sources
- Data Transformation and automating manual work with Power Query.
- Creating & managing data models
- Answering complex business questions with DAX
- Data Visualization for informed decision making.
- Collaboration and sharing the reports and dashboards.
- Learning Power BI service for sharing on cloud
Who should attend this training?
- Chief Financial Officers (CFO)
- Finance Directors
- Head of FP & A Departments
- Financial Controllers
- Accounting & Finance Professionals
- Business Planning & Development
- Investment & Commercial Banking
- Business & Data Analysts
- MIS Reporting Executives
- Finance Professionals & Auditors
- Human Resource Professionals
- Supply Chain Professionals
- Sales & Marketing Professionals
- Asset and Portfolio Management
Course Contents
- Introduction to Business Intelligence (BI)
- How Power BI is useful for professionals
- Power BI ecosystem and licensing cost
- Why to learn BI?
- Getting to know the types of data connectors and the query editor
- Getting data from using different data connectors like Excel, text, web & CSV files
- Combining all the files in a folder
- Getting data from databases
- Automating tasks in Power Query
- Text, numeric and Data transformations
- Pivoting and un-pivoting columns
- Merging and appending queries
- Creating conditional columns
- Working with ‘Transform’ and ‘Add column’ tools
- Understanding ‘Advanced Query Editor’
- Data source and query refresh settings
- Data connection best practices
- Understanding what Data Model is and why we need it
- Understanding ‘Facts’ and ‘Dimensions’ tables
- In-depth understanding regarding Primary vs. Foreign keys
- Creating ‘Star Schemas’ and ‘snowflake’
- Creating table relationships and understanding their cardinality
- Defining hierarchies and hiding fields in report view
- Intro to Data Analysis Expressions (DAX)
- Similarities and differences with Excel formula language
- Knowing DAX Formula Syntax & Operators
- Calculated Columns, Tables vs. Measures
- Implicit vs. Explicit Measures
- Using Variables and comments
- Row Context vs. Filter Context
- Using quick measures
- DAX best practices
- Calculated Columns vs. DAX Measures
- Learning Measure calculation Step-by-Step
- Important DAX Calculations
- Using ‘DAX Studio” and “Analyze in Excel for Power BI
- Desktop” external tools for advanced analysis
- Understanding time intelligence
- SAMEPERIODLASTYEAR, DATEADD, DATESINPERIOD, DATEDIFF, DATESYTD, DATESQTD, DATESMTD, PARALLELPERIOD, TOTALYTD, TOTALQTD, TOTALMTD functions
- Design for a target
- Keep everything at a glance
- Keep it simple
- Align visuals and objects
- Be consistent
- Highlight the most relevant information
- Be clear
- Start from zero
- Format the numbers
- Show the context
- Select the right colors
- Design dashboards, not reports
- Show variations
- Leave the noise off
- Pick the right charts & visuals
- Knowing the report view and exploring its interface
- Power BI desktop options and settings
- Creating dashboard and adding visuals
- Report filtering options & drill down pages
- Adding & formatting buttons, shapes, and images
- Adding slicers, Cards and KPI visuals
- Customizing themes and creating bookmarks
- Adding common charts like column, bar, Line, Area, Pie, Donut & combo
- Accessing AppSource for importing Custom Visuals for Power BI
- Zebra BI custom visual
- Bullet Chart custom visual
- Bubble chart
- Ultimate waterfall custom visual
- Smart Filter
- The Decomposition Tree visual
- The Key Influencers visual
- The Q&A visual
- Smart Narratives visual
- Analyze the changes
- Quick Insights
- Accessing Power BI Service and touring the interface
- Creating workspaces
- Workspace vs. Apps
- Designing automated KPIs tracking in the service
- Creating Data-Driven Alerts
- Exploring Data with Q&A & Generating Quick Insights
- Understanding the difference between Reports & Dashboards
- Creating dashboard from multiple reports
- Collaboration with others
- Installing ‘Data Gateway’
- Scheduling auto refresh
- Installing Power BI mobile app
- Creating Mobile view
- Adding visuals, publishing, and viewing dashboards on Mobile app / tab
1 New Batch Details
- Starting From: Starting from Dec 02, 2024 (InshaAllah)
- Program Duration: 2 Weeks | 8 Sessions of 2 hours each
- Class Days: Monday to Thursday
- Class Timing: From 8:30pm to 10:30pm (GMT+5, Pakistan Time)
- Medium of Instruction: English, as this is an international program
2 Program Deliverables
- Practice Data Sets & Case studies
- Comprehensive Notes
- Practical Dashboards preparation during sessions
- Recording of each session
- LEXICON E-Certificate
3 Important Note
• Training Fee includes LEXICON e-Certificate
• All sessions will be live and interactive on Zoom
Pay And Register
Training Fee: PKR 35,000/- (Including e-Certificate)
#Advanced Financial Analysis #Power BI Financial Analysis #Financial Modeling in Power BI #Business Intelligence Training #Financial Data Visualization #Power BI Training for Finance Professionals #Financial Reporting in Power BI #Advanced Power BI Course #Financial Dashboard Creation #Data Analytics for Finance #Power BI for Financial Planning #Business Analytics Training #Financial Data Analysis Tools #Power BI Certification #Financial Intelligence Training “Unlock insights with advanced financial analysis” “Transform financial data into actionable insights” “Become a Power BI financial analysis expert”