Learning Path
Business Intelligence
Level
Advanced
Enrollment
Closed
Instructor-Led Live Session
Live Session Recording
Expert Support
Case Studies & Projects
Dedicated Resource Portal
06 weeks (Sat & Sun)
04:00 PM to 06:00 PM
Language
Urdu / Hindi
Using Power Query, users can easily import tables of data from external sources into Excel, making it possible to automatically shape and manipulate the data with no programming required. This approach reduces the time it takes to move data from multiple sources, allowing users to spend more time analyzing the data to make better business decisions.
This course will begin with the basics of Power Query and will take you to the building blocks of writing your own queries using M language.
This course makes sure that you can see the immense value of doing work in these areas right can be.
Prerequisite
Attendees must have Excel proficiency equivalent to our Excel for Everyone course
Course Content
You will get
- Exercise and Project files
- Pre and Post Assessment
- Quizzes and Homework assignments
- 1-month access to the resource portal
- HD Recording of all live sessions
Certificate of Completion
You will be awarded a course completion E-Certificate by TechTAR Solutions after fulfilling the course requirements.
- Excel users who are looking for a transition into a business intelligence role.
- Analysts who are using Excel to analyze large datasets (>1mm rows), connect to external sources, or build relational data models.
- Anyone seeking to explore Excel’s business intelligence, Extract Transform & Load (ETL), capabilities.
- Classes will be interactive throughout & LIVE on Zoom. You would be able to ask questions & share views with the Technical Assistant, Trainer & class other participants.
- Experience with Excel PivotTables and formulas is strongly recommended
Recommendations:
- Computer with internet access, a webcam, microphone, and Zoom App.
- Microsoft Excel 2016+ or Office 365 (ideally for PC/Windows)
Power Query Fundamentals
- What is Power Query?
- Versions of Power Query
- The ‘Get Data’ User Experience
- Connecting to Data Source
- The Query Editor
Importing Basic Data
- Connecting to Delimited Flat Files
- Connecting to Data in Excel Workbooks
- Connecting to Data in the Current Excel Workbook.
Data Profiling
- Examine Data Structures
- Interrogate Column Properties
- Interrogate Data Statistics
Query Function
- Reference, Duplicate
- Delete, Manage, Copy & Backup Results
- Refresh & Refresh in Protected sheet
Query Auditing
- Query Error Auditing
- Configuring Query Load Destinations
- Query Dependencies
- Navigation Shortcuts
Simple Transformation Techniques
- Column Transformation
- Row Transformation
- Text Transformation
- Number transformation
- Date transformation
- Creating Columns from Examples
- Conditional Column
- Grouping and Summarizing Data
- Pivot & Unpivot Columns
Appending Data
- Appending Tables Individually
- Appending Tables in the Current Workbook
- Appending Worksheets in an External Workbook
- Combine Files in a Folder
- Combine a Named Worksheet from Multiple Workbooks
- Combine All Worksheets in Multiple Workbooks
- Overcome Potential Errors when Combining Sheets
Merging Data
- Merging Basics
- Join Types
- Cartesian Products
- Approximate Match
- Fuzzy Matching Basic
- Fuzzy Matching in Data Quality
Basic Block of M Language
- Important Basic Power Query M Logic
- Advanced Editor
- Text functions in Power Query
- Date functions in Power Query
- Tokens – Identifiers, Keywords
- Literals, and Punctuation
Power Query Objects
- List as object and List functions in Power Query
- Record as object and Record functions in Power Query
- Table & other objects and Table functions in Power Query
Adding Custom Column
- Introduction to “Add Custom Column“
- Compatibility & Intrinsic Functions
- Drill Down
Advanced Editor and M
- Parameters in Power Query
- Parameters – Creating / editing / deleting through PQ interface
- Custom M Functions – using Parameters and Power Query Interface
- Custom M function – using the advanced editor
Individual Price
PKR 12,000
Per Person
Total charges for complete training
Group of Two
PKR 10,800
Per Person
Avail 10% off on a Group of two
Group of Three
PKR 10,200
Per Person
Avail 15% off on a Group of three
Group of Four or more
PKR 9,600
Per Person
Avail 20% off on a Group of four or more
Course Reviews
We have engaged TechTAR Solutions for a number of session in Excel and Power BI for our employees. Sohail Merchant is wonderful to deal with when making the bookings and the high level of experience the trainers hold is evident. We will definitely use them again in the future.!
I was tasked with seeking out a company to assist us in recreating our department’s appraisal Matrix and after meeting with TechTAR Solutions’ consultant, I knew they were the right fit to help get the job done! Their expertise and understanding of our needs made the whole process so simple.
Sohail Merchant from TechTAR Solutions’ [ explained the theory very well, also gave us sufficient room to ask questions and clarify our queries. Enough resources were provided to read and increase our knowledge on individual capacity..
Lots of useful information, Ideas & strategies with many practical examples. I learned a lot throughout the course & implementing it in my business. Sohail Merchant from TechTAR Solutions’ expertise gave me an amazing learning experience. Thank you.
The professionalism and Personalized service that we got from TechTAR Solutions was unlike any other company we worked with and they made us feel so comfortable by their natural communication and let’s do it attitude. Incredibly trustworthy and high value! Thankyou!
Please keep developing the products and solutions to make our lives more easier and work to be more focused efficient targeted and productive. Appreciate the contributions of the entire community in this.