Introduction
In this technological and VUCA world Data Analysis is one of the most significant skill for every professional. Microsoft Excel is undoubtedly the world’s best tool in this area which makes such an analysis possible for any business decision maker. When efficiently applied it becomes a powerful tool, allowing you to work with vast amounts of data, automating tasks, and present complex information very smartly and efficiently.
This training program aims to impart advanced-level data analysis skills using Microsoft Power Excel to a broad range of users to help them become proficient at it. We will help you to take your Excel skills from traditional to the professional level and you will become proficient in all analyzing, summarizing and communication your data using power Excel tools.
Who Should Attend
- Accounting & Finance Professionals
- Financials and Costing Auditors
- Business & Accounting Students
- MIS Reporting Executives.
- Supply chain professionals
- Human Resource Professionals
- Sales & Marketing Professionals.
- Any manager that has responsibility for working with data and numbers
Learning Outcomes
- They will learn how to automate routine tasks and do more in less time.
- Quickly build data models to blend and analyze data across sources.
- Create fully automated data shaping and loading procedures.
- Define calculated measures using Data Analysis Expressions (DAX)
- They will learn advanced concepts in Excel for working with data efficiently.
- This program will increase the productivity by replacing manual work with Power Excel productivity features
- This is going to be a major contributor for career progression.
- They will learn the advanced data analysis techniques and dynamic dashboards designing.
- This will be a great opportunity to get answers to their own practical problems
Program Schedule
- Friday & Saturday, Nov 15 and 16, 2024
- From 8:00pm to 10:30pm
- Live Interactive training on Zoom
Investment:
- PKR 6,000/- Net of all taxes
- PKR 4,500 for members and students of PIPFA
For Registration:
Send your full name, email ID, organization and city at info@lexicon.edu.pk | +92 320 8875000
Course Contents
1 Connect Multiple files using Power Query
- Introduction to Power Query
- Load data having more than 1 million rows (Excel Limit)
- Types of data connectors and the query editor
- Getting data from Excel, text & CSV files
- Combining all the files in a folder
- Getting data from databases
- Pivoting and un-pivoting of data
- Merging Queries & Appending Queries
- Introduction to Table transformation, text, number, and date
2 Creating Connection among multiple files with Data Modeling
- Introduction to Data Modeling
- Data Vs Diagram View
- Fact Tables and
- Dimension Tables
- Creating Relationship with table and sheets
- Modifying relationships
3 Creating Reports with DAX
- Introduction to DAX
- DAX Formula Syntax and Operator
- Basic DAX Functions
- Reporting Preparation using DAX
4 Reporting with Dynamic Arrays
- Introduction to Dynamic Arrays
- Using to Dynamic Data Tables
- #Sign and Spilled array behavior
- New Excel functions, LAMBDAs, Sequence, Transpose, ByRow, ByCol, Sort
- Preparation of a complete model using dynamic array formulas