Save for later
Business Intelligence Workflow with Excel
Data transformation from different sources if key when working in Excel. In this course, Business Intelligence Workflow with Excel, you will be equipped with Business Intelligence knowledge, tools, and best practices required to import data into Excel from different data sources, clean the data, and transform this data into any desired format. First, you will see how Power Query is an easy-to-use, yet powerful tool to import data from different sources. Next, you will learn how Power Query can cleanse and transform data without having to write any code. Then, you will also study What-if analysis which allows users to use several data sets in one or more formulas to explore various results. Finally, you will study Cube functions which help to pull data from Analysis Services into Excel. When you are finished with this course, you will have an understanding of the insertion and transformation process data goes through when imported into Excel.
Get a Reminder
Rating | Not enough ratings |
---|---|
Length | 1.8 hours |
Starts | On Demand (Start anytime) |
Cost | $35/month (Access to entire library- free trial available) |
From | Pluralsight |
Instructor | Amruta Mahajan |
Download Videos | On Windows, MacOS, iOS, and Android Pluralsight app |
Language | English |
Subjects | IT & Networking |
Tags | Data Professional |
Get a Reminder
Similar Courses
Careers
An overview of related careers and their average salaries in the US. Bars indicate income percentile.
Data 2 $50k
English Language Development, AVID & AVID Excel Teacher $53k
Excel Reporting Developer $68k
Excel/Access DTS Developers $78k
Many different sales & marketing positions $80k
Many different sales & marketing positions $80k
Excel VBA Developer $82k
Excel/Access DTS Developer $83k
Tutor - Accounting/ Excel /ESL $87k
Project Manager/ Different Appointment $101k
Project Manager/ Different Appointment $101k
Data Administrator / Data Modeler $108k
Write a review
Your opinion matters. Tell us what you think.
Please login to leave a review
Rating | Not enough ratings |
---|---|
Length | 1.8 hours |
Starts | On Demand (Start anytime) |
Cost | $35/month (Access to entire library- free trial available) |
From | Pluralsight |
Instructor | Amruta Mahajan |
Download Videos | On Windows, MacOS, iOS, and Android Pluralsight app |
Language | English |
Subjects | IT & Networking |
Tags | Data Professional |
Similar Courses
Sorted by relevance
Like this course?
Here's what to do next:
- Save this course for later
- Get more details from the course provider
- Enroll in this course